Tickets by type
SQL query for Intercom V2
Get the count of tickets for each ticket type.
SELECT ticket_types.name, COUNT(tickets.id) AS ticket_count FROM ticket_types LEFT JOIN tickets ON ticket_types.id = tickets.type_id GROUP BY ticket_types.name
Intercom V2 data model
Admins
Companies
Contacts
Conversations
Conversation Parts
Subscription Types
Tags
Teams
Ticket Types
Ticket States
Tickets
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed