In this Explore recipe, you'll learn how to create a query that shows your customer satisfaction rating by agent.
What you'll need
Skill level: Moderate
Time Required: 20 minutes
- Zendesk Explore Professional
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
Creating the query
To create the query
- In Zendesk Explore, click the query (
) icon. - In the Queries library, click New query.
- On the Choose a dataset page, click Support > Tickets > Support: Tickets, then click New query. Query builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, choose Tickets > Solved tickets, then click Apply.
- From the list of metrics, choose Customer satisfaction > % Satisfaction rated and Customer satisfaction > % Satisfaction score, then click Apply.
- In the Columns panel, click Add.
- From the list of attributes, choose Assignee > Assignee name, then click Apply.
- From the Visualization type (
) menu, click Column. - Click the % Satisfaction rated metric, change the axis to Dual, then click Apply.
- Click the % Satisfaction score metric, change the axis to Dual, then click Apply.
- From the Chart configuration (
) menu, click Secondary axes. - On the Secondary axes page, change Type of secondary series to Column.
- Under SUM(% Satisfaction rated) set the Max value to 1.
- Select Hide title under each metric, and hide the axis under one of the metrics.
- From the Chart configuration () menu, click Display format.
- On the Display format page, change the display format for % Satisfaction rated and % Satisfaction score to %.
- From the Chart configuration () menu, click Displayed values.
- On the Displayed values page, change Show value to Show.
The query is complete. See the screenshot below for an example of the finished result with one agent selected.
Next steps
Below are some examples of how you can enhance this report.
- Add a filter for Ticket solved - Date, then edit the date range to the period for which you want information. See Editing dates and date ranges.
- To filter the top agents by ticket solves, you can use a top/bottom filter. See Creating a top/bottom filter.
- If you want to show results only where the number of satisfaction surveys offered was greater than a value, you can use a metric filter. See Selecting the metric result range.
3 Comments
I've added this query which is helpful for seeing satisfaction percentages, however, I haven't found a way to go through and view customer responses to surveys all in one place as we've been able to in the past.
I recall we used to be able to easily export a .csv file with all ratings/surveys together with the click of a button, but haven't been able to find something similar to this anywhere
Hi Luke,
I can see this in my Satisfaction dashboard from the Reports screen in Support which looks like it gives you the option to export what you are looking for. I think this is an Admin only screen.
On Wednesday, April 8, from 8:00am-10:00pm CDT, we'll have a special guest team of experts on hand to answer your questions about Explore: Reporting & Insights Migration in your Zendesk Explore instance for an AMA-style conversation!
Just click the "new post" button and write up your question. Be sure to be as detailed as possible. The best questions include:
Questions posted to this topic in advance of the start time will be answered first thing on the 8th, so if you've got something you want our experts to look at, post it today!
Please sign in to leave a comment.