SELECT
    poll_name,
    count()                                   AS sends,
    countIf(delivered_at IS NOT NULL)         AS delivered,
    countIf(responded_at IS NOT NULL)         AS responded,
    round(100.0 * delivered / sends, 1)       AS delivery_pct,
    round(100.0 * responded / delivered, 1)   AS response_of_delivered_pct
FROM fact_campaign_sends
WHERE scheduled_at >= today() - 30
GROUP BY poll_name
ORDER BY sends DESC

SELECT cellphone, status, retries, failed_at
FROM fact_campaign_sends
WHERE batch_id = '{your_batch_id}'
  AND failed_at IS NOT NULL
ORDER BY failed_at

SELECT
    poll_name,
    round(avg(dateDiff('minute', delivered_at, responded_at)), 1) AS avg_minutes_to_reply
FROM fact_campaign_sends
WHERE scheduled_at >= today() - 30
  AND delivered_at IS NOT NULL
  AND responded_at IS NOT NULL
GROUP BY poll_name