Skip to main content

Peliqan

Try for free
Request a demo

Intercom

Average resolution time for tickets

SQL query for Intercom

Get the average resolution time for tickets from the Intercom data tables.

SELECT AVG(resolution_time) AS avg_resolution_time FROM tickets

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