Reporting on next and subsequent reply times

Have more questions? Submit a request

15 Comments

  • Bobby Quezada
    Comment actions Permalink

    Is there anything in the works or another workaround that might help measure the reply times? We would like to first find out what our teams avg reply times to open ticket from our customers before we make any SLA commitments or hold any member accountable for their response time. 

    0
  • Jessie Schutz
    Comment actions Permalink

    Hi Bobby!

    You can track first reply time in Insights, if you're on Professional or Enterprise! We have an article about how that works in Insights here.

    -2
  • Bobby Quezada
    Comment actions Permalink

    Hi Jessie, 

     

    Thanks for the reply. I think I might have asked incorrectly. I meant in terms of average reply time for any replies on a ticket. This is a follow-up question to Rebecca's answer for subsequent reply times. 

    We'd liked to get an avg reply time for the lifespan of the ticket, not just the first reply time. 

    0
  • Jessie Schutz
    Comment actions Permalink

    Hey Bobby! 

    Sorry for the misunderstanding. Let me see if I can find someone to answer this for you.

    0
  • Fernando Duarte
    Comment actions Permalink

    This may be possible by dividing the total Agent wait time in minutes by # Replies

    0
  • Olivier Pascal Netatmo
    Comment actions Permalink

    Hi

    I need to know very simply how to get the time reply for new tickets and for open ticket...by agent and by group for each previous week

    Thank you

    0
  • Mario Guisado
    Comment actions Permalink

    I'm in the same boat, looking for a way to measure average reply times across a whole interaction - like said above - don't want to set SLA's yet.

    Thanks

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Mario,

    If you're looking to track this information outside SLA's then I would recommend looking into the Time Tracking app in our App Marketplace. You'll then need to use Insights to create some custom metrics as mentioned in our Time Tracking recipe: The metrics you need to be measuring .

    I would also recommend taking a look at our Insights Metric Reference to see a full list of available metrics as well as what data they capture.

    Hopefully this helps you get the information you're looking for.

    Cheers!

    0
  • Scott Hartman
    Comment actions Permalink

    The original "Answer" says you can get last reply time by switching MIN to MAX, however, the underlying Fact for FRT is "First reply time in minutes" which provides no MAQL definition.

    How can we pull last reply time?

    0
  • Nicole - Community Manager
    Comment actions Permalink

    Hey Scott -

    You might want to cross-post that question in the community for more visibility:

    Insights and Reporting Q&A

    0
  • Scott Hartman
    Comment actions Permalink

    The original post literally states that "Insights can get the first or last reply time (using SELECT MIN and SELECT MAX)". I am asking you to elaborate on the MAQL formula for last reply time. I am not interested in opening a discussion in the community.

    0
  • Amy Dee
    Comment actions Permalink

    Hi Scott! The default first reply time is calculated by Zendesk and passed to Insights as a simple number. Insights stores those numbers in the First reply time in minutes and First reply time in minutes within business hours facts. They do not contain any additional information about the reply or how it was calculated. 

    It's also possible to capture custom durations with Insights. Insights can find the first or last time something happened by finding the lowest or highest timestamp for the associated update (SELECT MIN and SELECT MAX). These are not pre-built metrics, so you would need to define the events yourself in custom metrics. 

    We have a recipe for finding the event of the first reply: First reply by event (version 2). That shows the logic for using timestamps to find a first reply time.

    We also have recipes for finding the duration between two events using timestamps, which is a bit more open than the reply time recipe above. We also have a guide to using the events model in Insights, which could help you define different types of updates.

    This type of reporting can get very complicated very quickly. You could modify that first reply by event recipe to find the time between ticket creation to the last public agent comment instead of the first. Finding reply intervals is much more difficult; there is no quick or easy recipe to get those.

    If you're interested in ongoing reply intervals, SLAs are by far the simplest and most effective way to get them.

    I hope this helps! Happy reporting!

    1
  • Scott Hartman
    Comment actions Permalink

    Thank you for the references, Amy!

    0
  • Matteo
    Comment actions Permalink

    Hi everyone,

    The article has been updated following Amy's latest suggestions, hope this helps!

    Happy reporting!

    1
  • Jonna
    Comment actions Permalink

    Hi!
    What does this part means:

    Insights can only find the first or last time something happened (using SELECT MIN or SELECT MAX with the timestamp), so it is not a good option for ongoing replies.

    Does it mean that if I would like to report periodic update (excluding tickets on-hold status), this is not a solution?

    Has anyone actually been able to find a way to use https://support.zendesk.com/hc/en-us/articles/205367047-Insights-recipe-Duration-between-two-or-more-ticket-events-in-minutes to report this?

    If I understand correctly, I'd need to create 3 metrics:
    1) Showing timestamp when ticket status changes from "pending" to "open"
    2) Showing timestamp when ticket status is "open" and public comment made by admin or an agent
    3) Metric showing a difference between these 2 timestamps

    But how I could include also tickets that are "open" and remain "open" despite we send an update to the customer?

    0

Please sign in to leave a comment.

Powered by Zendesk