Metrics and attributes for Zendesk Support

Return to top

126 Comments

  • Devan La Spisa
    Zendesk Community Manager

    Hello @...,

    I would recommend utilizing the following metric in your report. You can find more info on this and more in our Metrics and Attributes article.

    Requester wait time (min) The number of minutes a ticket spends in the New, Open, and On-hold statuses. This number is only measured after a ticket status is changed from New/Open/On-hold/Pending/Solved/Closed.

    (Requester wait time (min))

     

    Best regards. 

    0
  • Jorge Yeber

    I have a question about the metric Field changes Time (min)). Im building a calculated metric using the next code 

    IF(
    [Changes - Field name]="Motivo Contacto"
    and [Changes - Previous value] = NULL
    AND [Changes - New value]!= NULL
    ) THEN VALUE(Field changes time (min))
    ENDIF

    When I use the calculated metric these returns an emptyvalue. Why could occured that?

    0
  • Elissa Tikalsky
    Zendesk Digital Resources Team

    Hi @...

    I checked in with one of our Explore team and they said the metric you made may be returning empty values for a number of reasons: you may have misspelled the field name, you could be using the wrong dataset in the report you're using it in, there may be no tickets that have Motivo Contacto as a value in the subset of ticket's you're looking at.

    Another good point is that if at any point in the life of the ticket that field changed to NULL, even if it is not NULL now, the code you have excludes that ticket. So for tickets that change back and forth, those would not show up with this metric.

    This recipe may help you get it sorted out a bit: Explore recipe: Reporting on the duration of fields.

    If that does't help I'd recommend contacting support so one of our advocates can help you troubleshoot in context and pinpoint what is going wrong!

    0
  • CJ Johnson

    The Update - Timestamp Attribute appears to be missing from the Dataset for Support Updates. I'd love to know how this is calculated, as I'd like to make one that drops off the seconds from this timestamp. 

    0
  • Rob Stack
    Zendesk Documentation Team

    Hi CJ Johnson, thanks for the question. As there are a bunch of different time-based attributes, we don't list them all individually. There are a couple of ways you could tackle this:

    1. Create your own attribute with just the elements you need like Year, Hour, etc. There's a great example of this at https://support.zendesk.com/hc/en-us/articles/360022298254
    2. I think that the timestamp is always exactly the same length so you should be able to create a standard calculated attribute that returns only the first 16 characters of the Update - Timestamp attribute. The formula would look something like:

    LEFTPART([Update - Timestamp],16)

    I hope this helps to spark some ideas!

    -1
  • Admin

    Does an Answer Bot reply count as a agent First Reply? 

    0
  • Brett Bowser
    Zendesk Community Manager

    Hey David,

    Excellent question! Answer Bot reply does not count towards the First Reply Time metric. FRT requires a public response from an agent on the account.

    Let me know if you have any other questions!

    1
  • Admin

    Awesome! Thank you.

    0
  • Crawford Philleo

    I'm wondering if there is a way to get the (Agent Replies) metric on the Tickets data set to reflect only public comments by agents that do not contain a specific string. I'm noticing that this metric is pulling in values when we've merged a ticket. I wouldn't count this as a "reply" to the requester. Is this possible? So in my use case, I'd want to be able to have a metric called like "Actual Replies" which would be the same as (Agent Replies) minus comments that include the string "was closed and merged into".

    0
  • CJ Johnson

    Is there any plan to include an "end-user replies" in the Support Default dataset? It seems extremely strange that it's not available in this one. 

    1
  • Elaine
    Zendesk Customer Care

    Hi Crawford,

    Agent Replies metric always counts all public replies that are sent by your Agents within a ticket.

    Agent Replies      The number of public replies added to a ticket by an agent.

    If you're referring to the merging process where you're making the merge comments that include the string "was closed and merged into" public, you actually have the option to make this private so that this comment will not be included in the count of Agent Replies moving forward (kindly see Step 5 on To merge one ticket into another ticket in the article I mentioned above).

    You can also set the default privacy for all ticket comments which can be done by an Admin to make merge comments deselected, and for them to be posted as a private comment by default.

    Hope I was able to clear this out. Cheers! :)

    0
  • Elaine
    Zendesk Customer Care

    Hi CJ,

    If you use the Ticket updates Dataset in creating a query, you can actually find the End-user comments as a Metric.

    End-user comments The number of end-user comments on tickets. IF ([Comment present] = TRUE AND [Updater role] = "End-user") THEN [Update ID] ENDIF

    Hope I pointed you in the right direction. Cheers :)

    -1
  • CJ Johnson

    @... That doesn't help me unfortunately, I mentioned I was asking about the Support Default dataset. You cannot use the End User comments very effectively at all in the Updates dataset, because it gets constrained by the time frame. So if you want to see # of end user replies  on tickets created last week, you can't, because then it will only count end user replies at the time of the ticket creation, which is not helpful. That is why my question called out the default dataset. Additionally, the default set has agent replies, but not end-user, which really feels like an oversight. 

    1
  • Elaine
    Zendesk Customer Care

    Sorry if I wasn't able to answer you in one go. Lemme try again, CJ. :)

    You can actually use the End-user comments from the Ticket updates Dataset as how you're expecting it.

    You can use the ticket creation date as a filter and then use any ticket update metrics on your query to show the data that you needed just like on the screenshot below:

    As you can see, the End-user comments do not show just the number upon creation of a ticket only which should be a value of 1. Instead, it actually shows the total number of End-user comments in a ticket's lifetime.

    I hope this time I was able to provide you the expected answer. Cheers! :)

    -1
  • CJ Johnson

    Hi Elaine,
    Try it again with "Tickets Created" as the Metric and end user replies as the attributes, and you should get 0s across the board. My request that end user replies be included in the Default dataset still would be helpful, IMO. This was available like this in Insights. 

    -1
  • Allen Lai | Head of CX at Otter.ai

    Is there a way to show/calculate the age of unsolved tickets in business hours/days?

    0
  • Marco
    Zendesk Customer Care

    Hi Allen,

    Thanks for reaching out regarding this. You can use the metric "Unsolved tickets age (days)" for this, similar to what is described in this post: https://support.zendesk.com/hc/en-us/community/posts/360029582253-Unsolved-Ticket-Aging-Reporting

    This would unfortunately not be able to only show business days, and there is no available metric at the moment that would achieve this. I would suggest posting this as a feedback: https://support.zendesk.com/hc/en-us/community/topics/360001200913--Feedback-on-Explore-

    Hope this helps! Cheers!

    Marco M. | Zendesk Support

    0
  • April Schultz

    How do I create an attribute that shows the date a ticket's status was changed from solved to closed? The new feature of being able to redact on a closed tickets will pose a problem in our current queries. It appears that if you redact on a closed ticket, the 'Ticket updated - date' field is updated to the date the redaction took place. We are displaying 'Ticket updated - date' with the 'Status' of closed on many queries since before this new feature, that date would never change. 

    0
  • MarketSpark

    It is crazy to me that you have locked down the filtering of this dataset by at the very least Organizations, but ideally anything more than what is allowed right now. By not allowing this, this dataset is completely useless to me.

    0
  • Gab Guinto
    Zendesk Customer Care

    Hi April,

    You can create an attribute that could identify the timestamp/date that the status was changed to Closed is through the Ticket updates dataset. Only through the Updates dataset can you create this custom date attribute. Here's how the formula should look like:

    IF ([Changes - Field name]="status" AND [Changes - New value]="closed")
    THEN [Update - Date]
    ENDIF

    With this, you can create a report based on or filtered by the date the tickets were set to closed. If your reports are under the Tickets dataset, then I'm afraid there is no workaround for this.

    1
  • Kuka

    Hi team @...

    So our team wants to do quality assurance for our agent by selecting tickets only works by one agent to measure their issue handling for customer inquiry. Is there any metrics that I can use to do that?

    Context:
    - when we tried to do sampling, one ticket can contain more than 1 agent to solved/closed the ticket

    - we just want to select tickets who works by 1 agent only

     

    could you help with that? Thank you

    1
  • Rosie B.
    Zendesk Customer Care
    Hi Kautsar, 

    To specifically report one agent to measure his ticket handling, you can add the attributes "Assignee name" then select the agent name and apply. 
     
    Please make sure that you select the Tickets dataset

    A simple query may look like this for your reference: 

     

     
    -1
  • Edwards, Taylor

    Could you please update this article with the following metrics:


    Number of New Tickets

    1. This month vs. last month (MTD vs. LMTD)
    2. This month vs. same month last year (MTD vs. LYMTD)

    Number of Solved Tickets

    1. This month vs. last month (MTD vs. LMTD)
    2. This month vs. same month last year (MTD vs. LYMTD)

    Created Tickets vs. Solved Tickets variance on:

    • all the normal date ranges: a single date, last week, last month, etc.
    1
  • CJ Johnson

    The Metric "Agents" calculation is non-functional and does not return what is listed as what it is supposed to: 

    Agents The number of active agents and administrators in your Zendesk account. IF ([Requester status] = "Active" AND [Requester role] != "End-user") THEN [Requester ID] ENDIF

    This formula does not return "the number of active agents and administrators on your account". It returns stuff like a 5 agent count for a single Assignee name, and simply does not do what it says it does. 

    1
  • Edwards, Taylor

    CJ,

    What may work for you is a D_COUNT of Assignee as a metric with Assignee Name or Assignee Email in the rows section.  And then filter that on Assignee Role = Agent.

    0
  • CJ Johnson

    Hi Taylor, 
    Unfortunately, it does not, I opened a ticket with Support and they agreed the issue is how this metric is written, and that it cannot return "all active agents and admins". 

    Edit: Part of why I'm posting because that support conversation was like, a month ago and this article is still wrong, the formula hasn't changed, so I figured I'd warn others that yeah, this metric just doesn't work. 

    0
  • Edwards, Taylor

    Gotcha. 

    The D_Count(Assignees) seems to work for me with Assignee Email on rows, filtering to Assignee Role = Agent.  It lists a 1 for those still active, and a 0 for those who are no longer with the company.  Of course that doesn't get me all the way to where I want to go, so I've got to filter out agents that have a license in our instance that are in a different section of the company.


    Hopefully they fix the Agent formula soon.

    0
  • Justin

    Hi guys, 

    Currently, I'm using a calculated attribute based on the ticket subject, however, instead of using the ticket subject I want to use the ticket note internal/public to have an in depth analytics. Do you this this can be done? Is yes, what variable I should use in the attribute syntax? 

    If not possible, is there an ETA when this will be possible? 

    0
  • Raúl

    Hi everyone,

    Is there a way to set up a metric that can calculate the "Avg Number of Solved Tickets" and "Avg. Number of Updated Tickets" per "Hour"? I'm trying to use these metrics to determine how many tickets each agent is solved or updated (tracking these two separately) each hour to figure out daily ticket goals per person. Thanks1

    0
  • Erin O'Callaghan
    Zendesk Documentation Team

    Hi Raúl, you should be able to create standard calculated metrics with the following formulas to get these numbers:

    • Average tickets solved per hour: COUNT(Tickets) / DCOUNT_VALUES([Ticket solved - Hour])
    • Average tickets updated per hour: COUNT(Tickets) / DCOUNT_VALUES([Ticket updated - Hour])
    1

Please sign in to leave a comment.

Powered by Zendesk