% of tickets contacted

Répondu

5 Commentaires

  • Alex Zheng
    Zendesk Customer Care
    Hey Bobby,
     
    Can you expand a little bit on your definition of "open workable" and "proactive (outgoing) contact?" I'm assuming by open workable we are referring to tickets that haven't been solved yet and by proactive (outgoing) contact this just refers to a public agent reply, but let me know if you mean something different.
     
    A couple of ideas depending on what you're looking for. You can try to find tickets with a requester wait time of less than 3 days. Requester wait time is defined as the amount of time a ticket spends in the New, Open, and On-hold statuses. This number is measured only after a ticket's status changes from New/Open/On-hold to Pending/Solved/Closed.
     
    Otherwise, the other thought I have is to use the DATE_LAST_FIX formula in this article to grab the last agent comment timestamp which you can compare to today to see which tickets have a value greater than 3.
     
    I would probably start with either one of those options.
    0
  • Bobby Koch

    Hey Alex Zheng- thank you! Your assumptions on those definitions are correct, or at least how I am referencing them in explore. 

    I think the date_last_fix confuses me but I am going to try that out. I will also  look into requester wait time. 

     

    What I have right now, in theory, is working, but would have to be calculated outside of Zendesk. 

    For example: I have the metric Unsolved Assigned Tickets, which is basically doing a similar thing to requester wait time, then use a filter 'Last Updated" in the previous 3 days. This gives me the raw number I want, but I can't figure out how I can add that filter, in theory, to a custom metric, then divide that total by the total assigned tickets for a user. In my head, this looks like:

    Unsolved Assigned Tickets Updated in the previous 3 days / Unsolved Assigned Tickets

    Right now, it is pretty easy to do since I can take the numerator (one report which is complete) and divide it by the denominator in excel and get the % values I am looking for. 

     

    Does that make any sense (it may not LOL)? 

    0
  • Alex Zheng
    Zendesk Customer Care
    Hey Bobby,
     
    I think I follow what you're trying to do. I'm thinking you'll want to add a condition to your metric to include the DATE_DIFF function to filter out tickets that haven't been updated in the previous 3 days.
     
    So something like:
     
     IF ((DATE_DIFF(TODAY(),[Ticket updated - Timestamp], "nb_of_days")) > 3) THEN [Ticket ID] ENDIF
     
    This condition should pull in tickets that haven't been updated in more than 3 days which you should be able to take the first part of the formula and add it into your existing custom metric for unsolved assigned tickets. So you will then have two separate metrics one for tickets that haven't been updated in 3 days and one that have and you can then divide them against each other to get the result that you are looking for.
     
    Let me know if that helps.
    0
  • Bobby Koch

    You are a HERO!

    It is working with one caveat that I can't figure out yet... I am somehow capturing System updates in my total calculations (probably coming from the custom metric) do you know how I would tie in something like Updater - Role from the Ticket Updates dataset into this? I basically just want to count agent comments, or something like that!

    0
  • Alex Zheng
    Zendesk Customer Care
    Hey Bobby,
     
    I am thinking you would want to be in the TIcket Updates dataset anyways as I believe this would be the easiest way to account for updater role and all the relevant metrics should be available in that dataset as well.
    0

Vous devez vous connecter pour laisser un commentaire.

Réalisé par Zendesk