1

Zendesk – tickets by topic

Question

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.

Sources

Zendesk (full schema here)

Query

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