This recipe shows you how to report on the average first reply time in minutes for tickets solved each day of the previous week.
What you'll need
Skill level: Easy
Time Required: 10 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
How to create the report in Explore
- In 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.
- In the Metrics panel, click Add.
- From the list of metrics, choose Duration between events - Calendar hours (min) > First reply time (min), then click Apply.
- Click the metric you just added, select AVG as the aggregator of this metric, then click Apply (see Changing the metric aggregator).
- In the Rows panel, click Add.
- From the list of attributes, choose Assignee > Assignee name, then click Apply.
- In the Filters panel, click Add.
- From the list of attributes, choose Time - Ticket solved > Ticket solved - Week of year, then click Apply.
- Click the filter you just added followed, then click Edit date ranges.
- On the Date range page, select Last week, then click Apply.
This report looks at the date the ticket was solved, but you can use any other date event.
You can now change the chart type to something that suits better your data (see Visualization types reference). A column chart works well.
46 Comments
Hi team,
Is someone able to assist with how to create a query that will use the first response time (not business hours) and filter it to only the weekend (Saturday/Sunday) by month? I am trying to see what happens to the FRT over the weekends only since we don't have the same number of agents on during this time.
I was imagining it would look something like this
Ticket solved month FRT (hrs)
Jan 3
Feb 4
Thanks,
Jase
Hi Jason McLean, you should be able to get the report you're looking for with the following setup:
Hi there,
I am trying to report on the first reply time. How can we calculate it if the same ticket gets assigned to Tier 2 and I would like to calculate the time they took to respond to the ticket vs the initial first reply from the Tier 1 group?
Thank you,
Prakriti
Hi Prakriti,
The native First Reply Time only calculates the time between ticket creation and the first reply, so it may not be possible to use it to get a First Reply Time from another group. By default, there is no way to track second or third reply time - Is it possible to track 2nd or 3rd reply time in Explore?
This has also been raised as a feature request. I recommend voting/replying to this thread to gain traction - Calculating First Update Time after ticket was re-assigned to another group Follow
This might require custom metrics/attributes to create, but I recommend checking Time Tracking App to see if it will fit your needs. Here are some resources:
Setting up the Time Tracking app
Time Tracking app: metrics you need to be measuring
What's the difference between using Tickets solved - Week of year vs. Ticket Created - Week of year. What does week of year mean? Is there a list somewhere defining in detail the attributes?
Hey Melyssa Furt -
Tickets Solved is going to filter or chart based on when the tickets were moved to a solved status, vs Ticket Created which looks at when the tickets were created originally. In either case, week of year refers to the numeric value corresponding to the week of the year (with the first week of the year being represented by the number 1, and the last week of the year being represented by 52*).
So, if I created a new request the 1st week of the year and it was solved 2 weeks later, Ticket Created - Week of Year would be 1 and Ticket Solved - Week of Year would be 3*.
* Note - If the end of the year falls in the middle of the week, it is possible to see week 53.
* Note - If a ticket is reopened and re-solved, the solved date will move to the more recent date
More Information can be found here and here.
Hope this helps!
Brandon
Hi,
We use the assign function to distribute tickets.
I want to be able to measure our agents first reply time from when we assign the ticket to them rather than when the ticket was first created.
Example if a ticket comes in at 12pm and we assign the ticket to the agent at 1pm and the agent responds at 2pm the first reply time should be measurable as 1 hour even though the customer has been waiting officially 2 hours for a first reply.
Is there something I can use to show this ?
Thanks
Joe
You can create a custom metric that will calculate the difference between the values from the default metrics First assignment time and First reply time. Example:
This should return the number of minutes from when the ticket was first assigned to the time the first agent response was posted.
Thank You Gab, if I want it to only calculate inside business hours not calendar hours what would I need to include in the formula ?
Joe
There's a default metric for First reply time in business hours which you can reference in your custom metric formula, but I'm afraid the metric First assignment time is only measured in calendar hours, so it wouldn't be possible to get accurate results that takes into account your business hours.
Does it make more sense for the X-axis (columns) to be based on the first assigned date vs. when the ticket was solved? If it's based on when the ticket is solved, it gives a false impression of how your agents are performing for that month.
For example:
In the example above, the First Reply Time should be reflected for the month of May. But if it's based on when the ticket is solved, it's going to be reflected in the month of June.
Yes, I agree, that makes sense. If you need the first reply time data to be sliced by when the ticket was first assigned, then instead of the solve date, you may slice the report by the attributes under Time - Ticket first assigned bucket. There's a native attribute under the Tickets dataset named Ticket first assigned - Week of year.
Does anyone know of a way that I can create a report of the average first response time by the hour of the day? Then a separate report by day of the week? We are trying to see when we are least responsive so we can make a plan to resource it.
Basically, I would like to replicate these reports but using the first response time instead
You can do this pretty simply, by choosing First reply time (min) as your metric, adding Ticket created - Day of week to Columns and Ticket created - Hour to Rows, and selecting the table format if that's not automatically chosen for you.
If you want to get some fancy color-coding for each number, you can adapt this recipe, substituting the above metric and attributes: Explore recipe: Ticket creation heatmap
Thanks, Dave Dyson appreciate the assist
Please sign in to leave a comment.