Skip to main content

Peliqan

Try for free
Request a demo

Zendesk

Number of tickets by channel

SQL query for Zendesk

Get the number of tickets by channel from Zendesk data.

SELECT channel, COUNT(*) AS ticket_count FROM tickets GROUP BY channel

Try this query now in Zendesk

Zendesk data model

Zendesk
Users

Zendesk
Locales

Zendesk
Tickets

Zendesk
Organizations

Zendesk
Organization Memberships

Zendesk
Groups

Zendesk
Group Memberships

Zendesk
Organization Fields

Zendesk
Organization Subscriptions

Zendesk
User Fields

Zendesk
Ticket Skips

Zendesk
Suspended Tickets

Zendesk
Ticket Metrics

Zendesk
Ticket Events

Zendesk
Articles

Zendesk
Macros

Zendesk
Help Center Categories

Zendesk
Help Center Sections

Zendesk
Ticket Fields

Zendesk
Satisfaction Ratings

Zendesk
Ticket Forms

Zendesk
Tags

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