SELECT
    s.last_node_id,
    n.node_type,
    n.question_text,
    count() AS conversations_ended_here
FROM fact_treble_sessions AS s
LEFT JOIN dim_poll_nodes AS n
    ON n.company_id = s.company_id AND n.node_id = s.last_node_id
WHERE s.poll_id = {your_poll_id}
  AND s.created_at >= today() - 30
GROUP BY s.last_node_id, n.node_type, n.question_text
ORDER BY conversations_ended_here DESC

SELECT trigger_keyword, count() AS conversations
FROM fact_treble_sessions
WHERE direction = 'INBOUND'
  AND created_at >= today() - 7
GROUP BY trigger_keyword
ORDER BY conversations DESC