SELECT poll_name, target_event_id, any(question_text) AS step, count() AS conversions
FROM fact_target_events
WHERE created_at >= today() - 30
GROUP BY poll_name, target_event_id
ORDER BY conversions DESC

SELECT
    uniqExact(t.session_id)                          AS converted_sessions,
    (SELECT count() FROM fact_treble_sessions
     WHERE poll_id = {your_poll_id}
       AND created_at >= today() - 30)               AS total_sessions,
    round(100.0 * converted_sessions / total_sessions, 1) AS conversion_pct
FROM fact_target_events AS t
WHERE t.poll_id = {your_poll_id}
  AND t.created_at >= today() - 30