Zendesk – tickets by topic
How many tickets are created by topic?
This is an important topic if you use the `topic` field in Zendesk. For our support team, we use that field to categorize each ticket by the product type.
You can read more about how we use this subquery in our blog post about using Zendesk source data to determine the ROI of our support team.
Zendesk (full schema here)
select date_trunc('month', t.created_at) as month, count(t.id) as tickets, t.topic from zendesk.tickets t where t.topic is not null group by month, t.topic order by month desc