How to recreate the Insights CSAT dashboard in Explore
The Goal
It can be really satisfying (ha) to see all of your CSAT ratings with clear visual indicators for good and bad CSAT in the Reporting section of your instance. As Insights will be removed in February 2021, I thought I would share how we recreated this experience using Explore.
Prerequisites
- Zendesk Explore Professional
- Image links for the indicator you would like to use
Explore doesn't have a way to highlight the rating name as green or red, but you can add a URL to an image and use that to make it easy to visually identify good and bad ratings. In my case, I chose a green dot for good and a red dot for bad.
Instructions
Step 1
- Create a new Explore query using the Support: Tickets dataset
Step 2
- Add the metric COUNT(Rated Satisfaction tickets)
- Add the following attributes to Rows:
- Ticket solved - Date (filter: Edit date ranges>Advanced> 1 month in the past to today) You may need to adjust the date filter depending upon the number of rows generated. Reducing the timeframe should allow you to avoid reaching the row limit.
- Assignee Name
- Clickable Ticket ID
- Ticket Satisfaction (filter: Include Good, Bad)
- Ticket Satisfaction Comment
Step 3
- Create a Renamed Set Attribute
- For this step you will need your image URLs
- Click on Calculations at the right
- Select "Renamed Set"
- Name your new attribute, I chose "Ticket Satisfaction Dots Rename"
- Set the "Computed From" to Ticket Satisfaction Rating
- For each condition add the URL for the image you would like to represent that attribute
- Save your changes
Once saved, you can now add this new attribute to your rows. Your attributes will look like this:
Step 4
- Apply any filters that make sense for your business model. For instance, we tag chat trolls so they can be excluded from our satisfaction comments.
The Result
Your finished product will look similar to this:
Now you can have a quick and easy view of your CSAT in Explore. Enjoy!
-
Great post! Thx Chris Bulin!
Especially the images for ratings. I never thought something like this is possible in Explore ;)
-
Glad to help Andrei Kamarouski!
-
Hi Chris,
I love this query! I did find that the URLs in my renamed set would only output as strings, not images (not sure if I missed something). Anyway, I was able to just paste the emoticon (🔴 and 🟢) instead and that does seem to work.
Thanks for creating this 👍
댓글을 남기려면 로그인하세요.
3 댓글