Consultas

SELECT fullname, email, phone, creation_date
FROM contacts
WHERE creation_date >= '2025-01-01'
  AND creation_date < '2025-02-01'
ORDER BY creation_date DESC
LIMIT 100;

SELECT *
FROM contacts
WHERE fullname ILIKE '%nombre%'
LIMIT 50;

SELECT m.content, m.creation_date, m.f_type
FROM messages m
JOIN contacts c ON c.id = m.contact_id
WHERE c.fullname ILIKE '%nombre%'
ORDER BY m.creation_date DESC
LIMIT 100;

SELECT name, status_text, total_records, total_send,
       total_errors, success_rate
FROM campaigns
WHERE status_text = 'SENDING'
ORDER BY creation_date DESC;

SELECT name, amount, final_amount, pipeline_name,
       stage_name, assigned_agent_name, status
FROM opportunities
ORDER BY creation_date DESC
LIMIT 100;

SELECT fullname, email, tags
FROM contacts
WHERE tags::text ILIKE '%nombre_tag%'
LIMIT 100;

SELECT fullname, email, creation_date
FROM contacts
WHERE assigned_agent_name IS NULL
ORDER BY creation_date DESC
LIMIT 100;

SELECT m.content, m.ia_agent_name, m.ia_model,
       m.ia_estimated_cost_usd, m.creation_date
FROM messages m
WHERE m.ia_agent_name IS NOT NULL
ORDER BY m.creation_date DESC
LIMIT 100;

SELECT c.fullname, c.email, o.name AS oportunidad,
       o.amount, o.stage_name, o.pipeline_name
FROM contacts c
JOIN opportunities o ON o.contact_id = c.id
ORDER BY o.creation_date DESC
LIMIT 100;

SELECT campaign_name, agent_sender_name,
       response_status_text, sent_date
FROM conversations
WHERE campaign_name IS NOT NULL
ORDER BY sent_date DESC
LIMIT 100;

SELECT ia_agent_name,
       COUNT(*) AS total_mensajes,
       SUM(ia_estimated_cost_usd) AS costo_total_usd,
       AVG(ia_latency_ms) AS latencia_promedio_ms
FROM messages
WHERE ia_agent_name IS NOT NULL
GROUP BY ia_agent_name
ORDER BY costo_total_usd DESC;