Skip to main content

Peliqan

Try for free
Request a demo

Intercom

Number of conversations by channel

SQL query for Intercom

Get the number of conversations by channel from Intercom data.

SELECT channel, COUNT(*) as number_of_conversations FROM intercom_data GROUP BY channel

Try this query now in Intercom

Intercom data model

Intercom
Admins

Intercom
Companies

Intercom
Contacts

Intercom
Conversations

Intercom
Conversation Parts

Intercom
Subscription Types

Intercom
Tags

Intercom
Teams

Intercom
Ticket Types

Intercom
Ticket States

Intercom
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