Agent Performance
SQL query for Freshdesk
Get the average response time and resolution time by agent.
SELECT agent_id, AVG(response_time), AVG(resolution_time) FROM tickets_conversations GROUP BY agent_id
Freshdesk data model
Accounts
Agents
Contacts
Companies
Email Configs
Email Mailboxes
Groups
Products
Roles
Surveys
Tickets
Tickets Conversations
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