SELECT source_id, any(headline) AS headline, count() AS conversations
FROM fact_ad_sessions
WHERE created_at >= today() - 30
GROUP BY source_id
ORDER BY conversations DESC

SELECT
    a.source_id,
    any(a.headline)                 AS headline,
    uniqExact(a.session_id)         AS conversations,
    uniqExact(t.session_id)         AS converted
FROM fact_ad_sessions AS a
LEFT JOIN fact_target_events AS t
    ON t.company_id = a.company_id AND t.session_id = a.session_id
WHERE a.created_at >= today() - 30
GROUP BY a.source_id
ORDER BY conversations DESC