Reporting on Average First Reply Time in Insights (Professional and Enterprise) Follow

Comments

14 comments

  • Avatar
    Lee Savage

    Thank you for this. Unfortunately unlike Yoni I am stunned that such simple basics are not available for people to use immediately. I cannot imagine the logic that leaves such a basic tool unavailable without a tutorial. Investing the time on basics is a luxury some can ill afford.

  • Avatar
    Guillaume

    Is there a possibilty to have the same report but with hours instead of minutes?

  • Avatar
    Tobias Ritlov (Edited )

    Thanks for the great tutorial, Sarah. @Guillaume, I converted it to hours by simply adding a /60 at the end of the "SELECT AVG(First reply time in minutes)" in our new custom metric.

    See screenshots:

  • Avatar
    Jessie Schutz
    Thanks for helping out, Tobias! :)
  • Avatar
    Zach

    What would I do if I wanted to filter this out by agent? The end goal is to see which agents have the lowest average response time.

     

    Appreciate any help I can get.

  • Avatar
    Megan Howell

    @Zachary:

    The best way to do this would be to leave the "WHAT" in the report the same, but under "HOW" choose Ticket Assignee. This slices the first reply time by each ticket assignee (rather than date as it is done in this example)- it is worth noting that this attribute is going to pull the agent currently assigned to the ticket, not necessarily the first person assigned to the ticket. If you want the results only for the last month, then you will apply the same filter described in this article.

  • Avatar
    Anthony Garcia Jr.

    @Megan:

     

    I raised a ticket yesterday for the same query which Zachary has (1523251). I believe your response is the appropriate answer. However, I think it only applies when the first person who responded publicly on a ticket is the same person who closed the ticket, is that correct? In my understanding, Zendesk considers whoever last owns the ticket as the Ticket Assignee. But how about on instances where the person who first replied publicly on a ticket is different from the person who solved the ticket? Is there a way to capture the name of the agent who first responded publicly on the ticket.

  • Avatar
    Terry

    @Anthony

    I reviewed the article in your prior request and I do believe this custom metric will help you find the information you are looking for. 

    The use case described is looking for the agent who made the first public reply.

    From the article: "you want to give credit to the agents who made the first reply, not the current assignee."

    The reason you need to create a custom metric is because you need to look at the Event model by updater. 

    • The Event metric can report on first reply times by the agents who submit them.

    This metric finds the earliest timestamp of a public comment by an agent that occurred after a ticket was created. Then, it calculates the difference between that comment timestamp and the creation timestamp. Finally, it converts the average of those values from minutes to hours.

  • Avatar
    Lester Madden

    When I view the FTR value in the insights tab, the value differs to the value provide in the report when I create this metric. Even though the date criteria is the same, and I haven't applied any other filtering.

    Any ideas why?

  • Avatar
    Rebecca

    Lester-

    The first reply time report in the Insights tab dashboard is reporting on median first reply time where where this article is helping you to create metrics to report on average first reply time. Therefore the difference is likely due to average vs. median FRT not being identical.

    Further, the default prebuilt FRT metrics in Insights are also finding the median first reply time.

  • Avatar
    Lester Madden

    Hi Rebecca

    Thanks for the reply. But I’m not sure I follow

    In the Insights tab: First reply time (average) is telling me 60.41 hours for April.
    Whereas the First reply time in minutes [Avg] metric per the article gives me = 51.64 (when converted to hours)

    Since the label in Insights is saying average, I can only assume it is average not median, but lets assume it means median.  If use the median metrics in the report I get:

    First time reply (hrs) [Mdn] = 16.6
    [Biz Hrs] First Reply time hrs [Mdn] =  4.6

    So I’m not convinced Insights is giving me a median value.

    My confusion is Insights is saying average and the average metric isn’t giving me the same value for the same period.

  • Avatar
    Rebecca

    Hey Lester- 

    I'd be happy to look into this for you; I am going to pull this into a ticket so I can look at your specific Zendesk to provide a more concrete answer. 

  • Avatar
    Umran Ali

    Hi, is there an api for this? 

  • Avatar
    Jessie Schutz

    Welcome to the Community, Umran!

    It looks we do have API endpoints for ticket reply times. Here's a direct link to that information: Ticket Metrics.

Please sign in to leave a comment.

Powered by Zendesk