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

Table Admins

Table Companies

Table Contacts

Table Conversations

Table Conversation Parts

Table Subscription Types

Table Tags

Table Teams

Table Ticket Types

Table Ticket States

Table Tickets

Magical SQL for Intercom V2 with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Tickets by type

SQL query for Intercom V2

Intercom V2 data model

Magical SQL for Intercom V2 with Peliqan.io

Let AI do the work for you

Ready to get instant access to all your company data ?

Ready to get instant access to
all your company data ?