Customer satisfaction score by agent
SQL query for Zendesk
Get the customer satisfaction score by agent from Zendesk data.
SELECT agent_name, AVG(customer_satisfaction_score) AS avg_satisfaction_score FROM zendesk_data GROUP BY agent_name
Zendesk data model
Users
Locales
Tickets
Organizations
Organization Memberships
Groups
Group Memberships
Organization Fields
Organization Subscriptions
User Fields
Ticket Skips
Suspended Tickets
Ticket Metrics
Ticket Events
Articles
Macros
Help Center Categories
Help Center Sections
Ticket Fields
Satisfaction Ratings
Ticket Forms
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