Explore recipe: Agent interactions on tickets

Return to top

22 Comments

  • Yuliia Support Team Lead

    Hey,

    I am looking for a way to build a report on tickets, which had only 1 interaction with the customer (1 public comment) and the rest of the cases (>1 public interaction). Is there a way to do it in explore?

    0
  • Brett Bowser
    Zendesk Community Manager

    Hey Yuliia,

    We actually have a recipe for One Touch Tickets that should get you the results you're looking for.

    I hope this helps!

    0
  • Jeff Callahan

    Is there a way to filter where comment contains a specific string?

    1
  • Taylor Bowser
    Zendesk Customer Care

    Hi Jeff, 

    Unfortunately, the contents of ticket comments is not pulled into Explore so you would not be able to filter by a specific string.

    Warm regards, 

    -1
  • Dan Chikanov

    Hello. Was wondering if someone can help me here asap. 

     

    I am trying to figure out how many Agent Public Comments & End User Public Comments have been made in a single day. When I run a report, unfortunately, it tallies up ALL of the comments a ticket have rather than on the day its actually been commented. For example, If i had a single ticket that was submitted on 4/6 with 2 end user comments and then we responded to them on 4/7 with 2 public agent comments, then on 4/8 we received a comment from the end user. It should tell me that on 4/8 this agent who worked on the ticket have 0 public comments, but on 4/7 they had 2.

     

    My reports are unfortunately not doing this rather they are giving me the TOTAL 

    2
  • Hillary Latham
    Community Moderator

    @... if you create a query using the Ticket Updates dataset (instead of the tickets dataset) you can filter by comments made by day (use attribute update date instead of create or solved date).

    0
  • Paul Shaaf

    Having exact same problem as Daniel Chikanov

    Need to isolate agent updates vs ticket updates. zendesk - please advise  

    1
  • Jack Schuknecht
    Zendesk Customer Care
    Hi Paul,
     
    Could you please provide us with your Zendesk subdomain so we can confirm which account you're asking about? If you're not sure what your subdomain is, have a look at the URL you use to access Zendesk. For example, in companyname.zendesk.com, 'companyname' is the subdomain. You can also use our login reminder tool -- just enter your email and you'll be emailed your Zendesk address.
     
    If you are not a current Zendesk customer, you might be trying to reach someone who uses our software to provide support. We make software that companies use to give their customers a way to contact them for support, but we don't actually provide support for their product.
     
    Once we receive your reply, one of our agents will be happy to look into your request as soon as possible.
    -1
  • Brandon Tidd (729)
    Community Moderator
    The Humblident Award - 2021

    Hey Paul Shaaf

    Using the Ticket Updates data set, and a custom query, you can isolate End-User comments vs Agent comments as a metric, broken out by Update-Date as an attribute.  Hope this helps!

    Brandon

    0
  • Paul Shaaf

    Hi Brandon Tidd (729), thanks but not sure this addresses the issue. I still see an Agent's name on tickets they've commented on outside of the date I am filtering for. 

    For example, I'd like to view how many tickets Angie the Agent has commented on today. I filter for Update Date - Today and select Agent comments as the metric with Updater name in the Rows section. But I still see a ticket (using Ticket ID) that may have been UPDATED today (via someone else's comment or an automated action) but the "Agent comment" is from 2 weeks before. Angie the Agent's comment still counts as a metric for today. 

    I just want to see how many times my agents have commented on tickets TODAY. Let me know if that makes sense and thanks for your help, Brandon Tidd (729)

    3
  • Dan Chikanov

    +1 to Paul Shaaf's comment. That is the issue I am running into, still.

     

    Thanks for bringing this article back alive as I did not see Hillary Latham's comment since she did not "tag" me correctly. 

    3
  • Brandon Tidd (729)
    Community Moderator
    The Humblident Award - 2021

    Dan Chikanov / Paul Shaaf,

    To see who the updater was for that comment, try using the Updater Name attribute.

    0
  • Paul Shaaf

    Hi Brandon Tidd (729), if you refer back to my comment, you will see that I in fact am including the Updater name attribute and still experiencing the same problem.

    Please let me know if you are still having any trouble at all understanding Dan Chikanov and I's issue. Thanks.

    4
  • Brandon Tidd (729)
    Community Moderator
    The Humblident Award - 2021

    Ahh Paul Shaaf apologies - misunderstood that line. Let me review with the moderator team and see what we can come up with.  Thanks for your patience here!

    3
  • Paul Shaaf

    Brandon Tidd (729) no worries. Let me know if easier to take this discussion offline.

    2
  • Pedro Rodrigues
    Community Moderator

    Hi everyone (esp. Paul Shaaf and Dan Chikanov), regarding this "how many Agent Public Comments & End User Public Comments have been made in a single day" issue, I think you'll need to create a custom attribute, for example:

    IF [Updater role] = "Agent" AND [Update channel] = "Web form"
    AND [Comment present] = "true" AND [Comment type] = "Public"
    THEN [Update - Date]
    ELSE "-"
    ENDIF

    This is a filterable date attribute that you can use in a report, which will allow you to only see the agent comments on a specific date.

    For example, if I use this attribute for the 28th of October, I'll get valid data for an agent comment in a ticket created on the 12th:

    You can then create a report that shows agent comments per date (i.e. date they commented) using this attribute, for example (and excluding the "-" value):

    Hope this is what you're looking for!

    1
  • Arthur Burgos

    Hi,

    I'm trying to figure out the time when an agent takes the ticket from a group and adds their comment.

    Thanks!

    0
  • Dane
    Zendesk Engineering
    @Arthur,
     
    Are you pertaining to the timestamp when an agent have taken over a ticket and added the first comment? Or the total elapsed time from when the ticket was taken over to when a public reply was sent? 
    0
  • Arthur Burgos

    Hi Dane,

    I'm looking for both. 

    From the first of your choices, I'm looking for the timestamp and time elapsed when they have taken over and added their first comment after the ticket has been re-assigned to them.

    0
  • Dane
    Zendesk Engineering
    @Arthur, 
     
    For the timestamp on when the ticket was assigned, you can use the attribute First Assigned - Timestamp.  
     

    When it comes to the total elapsed time from the assignment to first public comment, we don't have a metric that can extract this data. You can also check the attribute First Reply time. It has the similar purpose. However, it will count the time from when the ticket was created. More information about metric and attributes can be found here Metrics and attributes for Zendesk Support.
    0
  • Kai Bentley

    Hi, 

    I'm trying to create a query that looks at tickets created, solved, reopened and # of public replies (sent by agents) for a team that deals with incoming emails

    The first 3 are fine and working as expected, but I can't seem to get public replies to play ball - if I include the standard metric it includes all public replies including end-users, however, if I then filter by updater role - agent then it impacts the "created" metric as obviously the updater for that is not an agent

    Is there something custom I can build so that I can see all 4 of these metrics within 1 query?

    0
  • Brandon Tidd (729)
    Community Moderator
    The Humblident Award - 2021

    Hi Kai Bentley

    This is a great example of when a Standard Custom Metric will solve your problem!

    While in the Tickets > Update History dataset, click the 'calculator' on the right side of your query editing box, select & name a new Standard Custom Metric 

    IF ([Updater role] != "End-user")  AND [Comment public] = TRUE
    THEN [Update ID]
    ENDIF

    Adding this metric into your query should then produce your desired result without the filter.

    Hope this helps!

    Brandon

     

    0

Please sign in to leave a comment.

Powered by Zendesk