In Zendesk Support, a zero-touch ticket is a ticket that was solved without an agent reply (known as a touch). This could include:
- Tickets that were solved because they contained nothing actionable
- Tickets that were solved because the customer updated the initial request to indicate they solved the problem themselves.
While Explore includes metrics that enable you to report on tickets with one or more agent touches (replies) as well as tickets without replies that haven't yet been solved, there is no included metric that displays solved tickets with no agent reply.
In this Explore recipe, you'll learn how to create a new standard calculated metrics that gives you the information you need.
This recipe contains the following sections:
What you'll need
Skill level: Intermediate
Time Required: 15 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Adding users to Explore)
- Ticket data in Zendesk Support
Creating the metric
Use this procedure to create a metric that returns all tickets that are solved or closed without any replies from the agent.
To create the metric
- In Zendesk Explore, click the reports (
) icon.
- In the Reports library, click New report.
-
On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- Now, create a standard calculated metric that returns tickets that are closed or solved with no agent replies. Click Calculations (
), then click Standard calculated metric.
- On the Standard calculated metric page, enter or paste the formula below into the Formula field. Add a name for the metric like Closed or solved tickets with no agent replies.
IF (VALUE(Agent replies) <1 AND ([Ticket status - Unsorted] = "Solved"
OR [Ticket status - Unsorted] ="Closed")) THEN [Ticket ID] ENDIFThe formula will look like the screenshot below:
Tip: If you're working in a language other than English, read this article to help you enter Explore formulas in your language. - When you are finished, click Save.
- In the Metrics panel of the report builder, click Add.
- From the list of metrics, choose Calculated metrics > Closed or solved tickets with no agent replies, then click Apply.
- In the Metrics panel, click the metric you just added, change the metric aggregator to COUNT, then click Apply. Explore displays the number of tickets that were solved with no agent reply.
Tip: If the report returns a large number of tickets, consider using a filter to restrict your results. For example, you could displays only tickets created this month. For more help, see Working with report filters.
Next steps
While this is a useful report, you can make it even more useful by adding attributes to the report. For example, in this screenshot, the Ticket channel attribute has been added to the Columns panel.
For a list of all of the metrics and attributes you can add to Explore reports for Zendesk Support, see Metrics and attributes for Zendesk Support.
9 comments
Customer Care Service Account
Thanks for this excellent guide. I'm curious if, as configured, this calculated metric includes chats. For the new integrated chat experience I believe when a chat is concluded the entire conversation is saved as a private comment. I built out the query as described and added Assignee Name as a column and Ticket Channel as a row and it appears that almost every chat is included in this 'zero touch' formula.
Is there a way to not include chats in a zero touch formula?
Thank you kindly.
0
Gab Guinto
Hi Ray,
You can add a filter to the query to exclude tickets that came from the Chat channel. Or, if you want this to be a metric-level filter, then you may add this condition – [Ticket channel]!="Chat" – to the custom metric formula:This should exclude tickets from chats that didn't have follow-up conversations thru an email ticket.
Hope this helps. Thanks Ray!
1
Customer Care Service Account
Amazing!! Thank you Gab.
0
shelley
Is there a way to split tickets into two parts
1. Resolved by Agent
2. Tickets resolved automaticlaly by triggers?
We receive a lot of support tickets that are automatically closed by triggers, so no agent touched the ticket. How can we identify those tickets opposed to tickets that were closed by agents with no replies?
0
Gabriel
I hope all is well! The best way for you to read this would be by adding an action that "adds a Tag" o tickets that have been Solved by the trigger. Sor example: solved_trigger.
Once you have this workflow in place, then you can use this Tag to filter tickets that have this action upon being Solved. Other tickets without this Tag will be the ones Solved by your agents. For more information, please check the article: "Reporting with tags" - https://support.zendesk.com/hc/en-us/articles/4408838151450-Reporting-with-tags
I hope this helps!
0
Syafiq Rahman
Are we able to pull out all solved tickets solved by the system?
0
Dainne Kiara Lucena-Laxamana
Hi Syafiq Rahman,
The best option would be creating a report using the dataset "Support: Updates History" & using the attribute "Updater" from there, you can exclude the agent/admin/end-user role & would be left with the system updates.
0
Frank Roberts
This confuses me "without no replies that haven't yet been solved" sorry
0
Ivan Miquiabas
Good day! Apologies for the confusion, but that should have been 'tickets without replies that haven't yet been solved' thanks for pointing that out though. I will flag that article for our publisher's to edit.
Cheers!
0