Analyzing your Support activity

Return to top
Have more questions? Submit a request

25 Comments

  • Mike Sanchez

    Under Efficiency tab reports and Tickets by first reply time brackets, what does No replies pertain to specifically?

    0
  • Brett Bowser
    Zendesk Community Team

    Hey Mike,

    No replies will account for any tickets that have not had a first reply time applied yet. This could be new tickets in your account that haven't been viewed by the agents quite yet.

    Let me know if that doesn't make sense.

    Cheers!

    0
  • Mike Sanchez

    Hi Brett Bowser,

    While playing with the CSV extracts, I noticed the same is true when it comes to tickets that were closed by merge. They are marked as solved/closed while not having a first reply time applied. Do you think these tickets are also being counted in the report under the Efficiency tab?

    Thanks!

    0
  • Brett Bowser
    Zendesk Community Team

    Hey Mike,

    Merged tickets with no response would have a null value since no first reply time was fulfilled in the ticket. Those would also show up under this No Replies metric as well.

    Let me know if there's anything else I can assist with!

    1
  • Jón Andri

    On the SLA section, https://support.zendesk.com/hc/en-us/articles/360041487414-Analyzing-your-Support-activity-with-Explore#topic_d5h_ybj_z3b

    The image shows 100% SLA achievement rate, but also 21 achieved tickets and 2 breached tickets. How does that add up in the calculations? I would assume we are looking at ~91% achievement rate as

    21/(21+2) = ~91%

    Even if we add SLA active tickets, and 2 of them breached to this calculations we would get achievement rate as

    (21+7)/(21+2+9) = 87,5% 

    Can you please elaborate more on how the SLA rate is calculated?  
    -we have similar "strange" calculations in our SLA achievement rate which we can not confirm.

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello Jon,

    The article below breaks down how SLA is calculated and goes into depth a bit more on the topic in general. This should answer your question but if you have further questions please don't hesitate to ask. 

    Defining and using SLA policies (Professional and Enterprise)

    Best regards. 

    1
  • Vladimir Petrushenka

    Hi there, 

     

    I'm trying to build a custom CSAT query - in insights for time filter we used, i.e. Week(or Month)/Year (Requester updated), on our view it was the closest that we could use, however, it didn't always give us the most accurate data. For instance, if we continue comms with the customer into the next month, after rating was given in the ticket, that would mean that the rating would be carried into the next month's reporting. I hope this makes sense. 

    So the question is - is there a CSAT specific time attribute in Explore that we could use in our reporting? For example, Date rating given or Date ticket rated etc

    Many thanks, 

    Vlad

    2
  • Samantha Bellach

    Why can't backlog be filtered by Ticket form?  Is there a plan to add more ticket custom fields to the backlog Explore data pool to be able to filter by? 

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello Samantha Bellach,

    We don't have any updates on this feature being added to Explore at this time. I would recommend sharing your use case with our dev team in our Feedback forums so they can consider implementing this change in future updates. 

    Best regards. 

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello Vladimir Petrushenka

    Yes, that makes perfect sense. You can accomplish this by using the Satisfaction Update Metric and Update Date for your date.

    Best regards. 

    0
  • bo_zhang

    Hi,

    How can I customize the "Unsolved tickets age brackets" attribute?  Now it is "1 day, 1-7 days, 7-30 days, >30 days, Solved.", but I want to make it as "1 day, 1-3 days, 3-5 days, 5-7 days, 7-15 days, 15-30 days, >30 days".

    Thanks.

    0
  • Violeta Micu
    Community Moderator

    Hi bo_zhang,

     

    Did you tried to clone the attribute "Unsolved tickets age brackets" according to your needs?

     

    This is the standard formula:

    IF (VALUE(Unsolved tickets age (min)) <= 60*24)
    THEN "1 day"
    ELIF (VALUE(Unsolved tickets age (min))>60*24 AND VALUE(Unsolved tickets age (min)) <= 60*24*7)
    THEN "1-7 days"
    ELIF (VALUE(Unsolved tickets age (min))>60*24*7 AND VALUE(Unsolved tickets age (min)) <= 60*24*30)
    THEN "7-30 days"
    ELIF (VALUE(Unsolved tickets age (min)) > 60*24*30)
    THEN ">30 days"
    ELSE " Solved"
    ENDIF

    This is how you can change it:

    To get 1-3 days instead of 1-7 you can change

    FROM:

    (VALUE(Unsolved tickets age (min))>60*24 AND VALUE(Unsolved tickets age (min)) <= 60*24*7)
    THEN "1-7 days"

    TO:

    (VALUE(Unsolved tickets age (min))>60*24 AND VALUE(Unsolved tickets age (min)) <= 60*24*3)
    THEN "1-3 days"

    Let me know/if it works properly.

    Thanks,

    Violeta

    1
  • bo_zhang

    Violeta Micu 

    Hi Violeta,

    Thanks for your clarification. I tried that and it seems to work, but not all of tickets ages appear. I don't know whether it is normal.

     

     

    0
  • bo_zhang

    BTW, how can I create a query based on the on-hold ticket age bracket? I cannot find the attribute of "on-hold ticket age bracket". I want to know how many on-hold tickets there are under different ages. Thanks. 

    0
  • Violeta Micu
    Community Moderator

    Hi Bo,

    You can replace "Unsolved tickets age(min) with On-hold time (min))

    IF (VALUE(On-hold time (min))) <= 60*24
    THEN "1 day"
    ELSE " Solved"
    ENDIF

    You need to copy the attribute you built for Unsolved tickets and replace it as in the example above and also add the filter Tickets Status = Hold.

    Let me know how this works.

    Have fun! :)

    1
  • bo_zhang

    Violeta Micu 

    Thanks, Violeta. I am not sure why it is "ELSE ‘Solved’ ". Please check the formula below I set:

    Is it right? 

    Also, you mentioned "also add the filter Tickets Status = Hold", but I cannot find “On-hold" Status in the filter. Is it because there is no on-hold ticket in my email pool now?

     

    0
  • bo_zhang

    Violeta Micu 

    I tested to put a ticket on "on-hold" status, but there is still no "On-hold" option in the filter of " Tickets Status"

    0
  • Violeta Micu
    Community Moderator

    Hi Bo,

    You need to make some tests to find an example of on hold ticket.
    First you can go to your Zendesk Support and built a view with ticket status is On hold. Then you will have few examples or at least the one you created.

    After that you can take examples and check them into Explore by searching inside the attribute Ticket id.
    Then add the Ticket status to see if it shows up.

    Regarding the example you created, after how much time did you checked the ticket updated on status on hold in explore? It has to pass aprox 1 hour after you created or updated the ticket.

    Let me know how it goes.
    Thanks

    0
  • Sam Liston

    Hi,

    We're currently using Zendesk Chat, and thinking about upgrading. Is there anyway to monitor the customer's chat queue position when a chat is accepted by one of our agents? Basically, are we able to monitor if chats are being handled in a first-in-first-out capacity?

    Thanks!

    0
  • Heather Rommel
    Community Moderator

    Hi Sam,

    Not after the fact, no, but on the Chat home page, you will be able to see that a customer initiated a chat and which agent they were served by (and which agent didn't accept the chat). That last part depends on whether you're going to set your Zendesk Chat on broadcast or 1 agent at a time chat offering.

    0
  • Yarden Abukasis

    I'm trying to create a table using full resolution time brackets but no matter what I do the order is showing as 

     

    when it definitely should be showing as 

    hours to days not with 5-24 hours out of order. I've tried all sorts of 'sorting' options and nothing seems to work 

    the query has them in the right order but that doesnt seem to stick when shown in the table itself

    IF (VALUE(Full resolution time (min)) <= 60*5)
    THEN "0-5 hrs"
    ELIF (VALUE(Full resolution time (min))>60*5 AND VALUE(Full resolution time (min)) <= 60*24)
    THEN "5-24 hrs"
    ELIF (VALUE(Full resolution time (min))>60*24 AND VALUE(Full resolution time (min)) <= 60*24*7)
    THEN "1-7 days"
    ELIF (VALUE(Full resolution time (min))>60*24*7 AND VALUE(Full resolution time (min)) <= 60*24*30)
    THEN "7-30 days"
    ELIF (VALUE(Full resolution time (min)) > 60*24*30)
    THEN ">30 days"
    ELSE " Unsolved"
    ENDIF

    0
  • Rob Stack
    Zendesk Documentation Team

    Hi Yarden Abukasis, one way you can do this is with renamed and ordered sets. There's a great example in this article: https://support.zendesk.com/hc/en-us/articles/360022367993
    I hope this helps!

    0
  • Heather Rommel
    Community Moderator

    I have a question around the Satisfaction tab-- is the time filter on this tab looking for a good or bad CSAT rating on the date the rating was given by the customer or is it looking for the date the ticket was solved?

    The reason I'm confused is the Date Filter is checked for date solved and date updated ?!? What does that mean exactly please?

    0
  • Heather Rommel
    Community Moderator

    Also reading through comments on other strings, I'm finding that Chat CSAT timestamps swing over to Explore a little off - and can skew results.  I've validated that on an account I'm working on -- a report run for a week Sunday to Saturday had to be backed up a day to capture the chat data correctly (Sat to Friday). Can anyone confirm regarding the chat csats being a little different?

    0
  • Eric Gao
    Zendesk Team Member

    Hi Heather,

    The Satisfaction tab, as well as the default satisfaction queries in Explore, will be looking at the ticket solved date (rather than the CSAT rated date). Explore currently does not have a native attribute for the CSAT rated date.

    As for the Chat CSATs, if you're comparing the data from Chat Analytics with Explore, the former will be in the account timezone whereas the latter will be in your user profile timezone. You'll observe a similar time shift in data if the two timezones are different.

    Warm Regards,
    Eric

    Eric G. Gao | Technical Support Architect | Zendesk

    0

Please sign in to leave a comment.

Powered by Zendesk