Recent searches


No recent searches

Analyzing agent ticket touches with Explore



image avatar

Rob Stack

Zendesk Documentation Team

Edited Jun 21, 2024


0

28

28 comments

Can you please define what is counted as a "Touch" in the following metrics?  I have reviewed our metrics and based on the initial percentages, it appears this only counts public agent replies. 

  • One-touch tickets: Tickets that were solved with only one agent reply.
  • Two-touch tickets: Tickets that were solved with two agent replies.
  • Multi-touch tickets: Tickets that were solved with more than two agent replies.

1


image avatar

Chandra Robrock

Most Helpful - 2021Community Moderator

Hi Chanteena! Taking a look at the formula used for the Agent replies distribution > One-touch tickets, Two-touch and Multi-touch metrics, I can confirm that these metrics are based on Zendesk's Agent Replies metric.

The Agent Replies metric will only include the number of public replies added to a ticket by an agent. This help article is a really a helpful resource for identifying what each metric means in Explore. 

0


Hi!  Is there a way to understand ticket touches for tickets submitted by an end user, not just those created by agents?  I'd like to understand the number of tickets submitted to our team and the breakdown of touches between the ticket's submission and it being submitted as closed.

0


image avatar

Chandra Robrock

Most Helpful - 2021Community Moderator

Hi Octave! These queries should return results for both tickets that were created by the end-user as well as the agent.

However, if you're ultimately looking to report on the number of touches per ticket for both the end-user and the agent, there are a few other comment-specific metrics that you could look at.

You'll find these metrics under the Comments section in Metrics.

0


Hi team - I'm just looking into tickets that may have multiple ticket touches, do you have any "How To" documentation on how to create a trigger for tickets with 4+ ticket touches, so I can create a view with all those tickets?

0


image avatar

Chandra Robrock

Most Helpful - 2021Community Moderator

Hi Matt - If you'd like to create a View based on multiple touch tickets, the best way to accomplish this would be to first create a trigger that adds a tag based on the number of Agent Replies.

The Trigger itself would look something like this:

From there, you could then build a View that looks for tickets with the specific tag you're adding in that trigger and any other criteria you'd like to build into this view (i.e. ticket status).

0


Hi I have a query about what counts as an agent comment. Is this just public agent comments or would it include internal comments too?

Thanks

0


image avatar

Chandra Robrock

Most Helpful - 2021Community Moderator

Hi @... - The Agent Comments metric would include both public comments left by an agent as well as internal comments left by an agent.

If you'd like to only include public agent comments, you could either add a Filter to your query for Comment Public = True when using the Agent Comments metric, or you could build a custom Standard Calculated Metric that essentially combines Zendesk's out-of-the-box Public Comments and Agent Comments metrics together.

The actual query for the custom metric would look something similar to the below:

IF ([Comment present] = TRUE AND [Updater role] != "End-user" AND [Comment public] = TRUE) 
THEN [Update ID]
ENDIF

0


This is great Chandra thank you so much :)

0


Sorry another question. Is there a way of showing this result as a % average for a group? I have filtered for the group I need, but cannot seem to get an average % of agent public comments for the group or per agent.

Thanks in advance for your help

0


image avatar

Chandra Robrock

Most Helpful - 2021Community Moderator

@... Happy to help! To find the average % of agent public comments for a specific group, you could build something similar to the following.

Metrics:
- Select either Agent Comments or the custom metric you created
- Select the exact metric you'd like to include in the denominator (ex: Ticket Created, Ticket Updated, etc).

It sounds like you're filtering for a specific group already but, if you're not, you could put the Group attribute in the Rows section. This is helpful when wanting to run an analysis for multiple groups at once.

From there, you can select Result Manipulation (the arrows on the right-side menu) and select Result Metric Calculation. This allows you to create a new metric based on two existing metrics. The actual query would look something like this - COUNT(Agent Comments)/COUNT(Tickets created) - depending on what metrics you've chosen to analyze. 

Under Chart Configuration (the paintbrush icon on the right-side menu), you can select Display Format to specify a % as the format for this new metric. Hope that helps!

0


image avatar

Chandra Robrock

Most Helpful - 2021Community Moderator

Hey Jackie - Wanted to follow up as I think I may have misunderstood what you were looking for last night. Were you hoping to understand what % of total comments each agent within a specific group accounted for?

If so, here's how you could analyze that:

Metrics: Select either Agent Comments or the custom metric you created
Rows: Updater Name (you'll likely need to filter your query by the Updater Role != End User, if you aren't already)

From there, you can select Result Manipulation (the arrows on the right-side menu) and select Result Path Calculation. You'll then select % of Total on Rows as shown in the below screenshot:

Hopefully that gets you closer to what you were looking for! :) 

0


Hi guys,

I think that there is a mistake, see this screenshot.

0


image avatar

Rob Stack

Zendesk Documentation Team

Hi Mirek Kokes, thanks so much for spotting that mistake. It's now fixed!

0


Hi guys, I am also trying to create a report to sum and average both agent and requestor comments in the ticket based on a given period of time. Our goal is to improve efficiency and find ways to lower the amount of back and forth it takes to get to a resolution and I need a way to measure that. When I look in Metrics for the word comments, this is all that comes up. Am I missing something? Thanks!

0


image avatar

Chandra Robrock

Most Helpful - 2021Community Moderator

Kenny Rohan Mind confirming that you're in the Support - Updates history dataset rather than the Support - Tickets dataset? Based on the metrics included in your screenshot, I suspect you may be querying the Support - Tickets dataset instead. 

0


That was it. Thank you very much!

0


Is there a way to measure average solve time for tickets with public replies only? It seems like there is no way to use the data from support tickets in support updates history.

0


image avatar

Brandon (729)

Zendesk LuminaryUser Group LeaderThe Humblident Award - 2021Community Moderator

Hey Landry Norman

Applying the agent replies bracket filter on your report and excluding NULL and 0 should do the trick:

0


In my org, our agents aren't currently assigned tickets, so we all touch them.  Is there a way to measure Unique touches per ticket.  For example.

If a new ticket is run from Creation to Close and 10 agent touches were made, but only from 5 distinct individuals, how could I create a report showing that 5 agents touched that case, not that there were 10 touches... 

More specifically I'd like to know what the Average number of Distinct agent touches were on tickets.

The goal is for us to trial a new ticket handling process and be able to show if the new process reduces distinct agent touches, increasing ticket "ownership" without it being tied directly to whether a ticket is assigned or not (As even an assigned ticket can still be touched by multiple people)

 

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi Kevin,
 
You can try using a custom metric to count the agents who made at least one update on a ticket. Here's a sample formula:
IF [Updater role]="Agent" OR [Updater role]="Admin" THEN [Updater name] ENDIF
You the metric aggregator D_COUNT with the metric; with your data sliced by Ticket ID, your table should show the number of agents per ticket.
 

1


Thanks Gab, 

The D_COUNT option allows me to get a distinct count of agents/Admins on a case, so this works.  I can break it down by tickets which gives me a good look into the tickets that have lots of people involved.

I'm also trying to break this down further to get the Average of the Distinct count of agents per ticket.   So kind of a:
D_Count(Agents updating a ticket) / # of Tickets

Does that make sense?

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi Kevin,

To get that average, you will need to calculate the value through Totals while the data is sliced by Ticket ID. Select AVG for the totals aggregator and the table should display this at the bottom row.

By default, Explore will display a rounded value. If you need the average to be displayed with decimal values, then you need to change the display format for the metric (which will also affect the display format of all rows). Example:

0


Hi there - how do I make a report that shows the volume of outbound emails an Agent sends? We often create outbound emails from webinar sessions we host and I need to see how many we're sending out to customers. Thank you!

0


image avatar

Chandra Robrock

Most Helpful - 2021Community Moderator

Riane Williams This help article should be helpful for your use case: https://support.zendesk.com/hc/en-us/articles/4408846777754-Explore-recipe-Tickets-created-by-agents-or-end-users. Specifically, the Tickets created by agents calculated metric. 

0


I'm trying to calculate a percentage of tickets that were 2+ touches from my reps that were the result of a reopen. I want to exclude 2+ touches that were using appropriate ticket statuses when asking clarifying questions and only account for scenarios in which my reps solved a ticket in one reply, and the customer had to reopen with follow up questions. I can't seem to identify if 2+ touches and multi-touch takes this into account. Is there any guidance from ZenDesk on how this can be calculated?

0


Hello Team,
I just need to prepare a report on Number of interactions to solve a ticket overall and by agent. Please suggest.

0


I need to know how many attempts it takes an agent to get connected with a customer. How can that be calculated? I am not finding an easy way to report that. 

0


Please sign in to leave a comment.