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,
 from zendesk.tickets t
 where t.topic is not null
 group by month, t.topic
 order by month desc
Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular