Explore recipe: Agent interactions on tickets

Return to top

16 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

    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).

    -1
  • 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.
    0
  • Brandon Tidd
    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, 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

    2
  • Dan

    +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. 

    2
  • Brandon Tidd
    Community Moderator
    The Humblident Award - 2021

    Dan / Paul Shaaf,

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

    0
  • Paul Shaaf

    Hi Brandon Tidd, 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 and I's issue. Thanks.

    3
  • Brandon Tidd
    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 no worries. Let me know if easier to take this discussion offline.

    2
  • Pedro Rodrigues
    Community Moderator

    Hi everyone (esp. Paul Shaaf and Dan), 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

Please sign in to leave a comment.

Powered by Zendesk