Number of Replies an Agent has sent per Day (IN EXPLORE)

Answered

8 Comments

  • Nathalie Rey
    Comment actions Permalink

    Hi Matt,

    As you want to report on ticket updates, you would want to use the Support: Ticket Updates dataset. I would advise creating a new dataset to ensure that you have the latest schema and you correctly see all the metrics and attributes.

    In your new query, you would want to use the metric "Public Comments" and apply a filter for Updater Role is Admin and Agent. This will ensure that you only see the number of public comments agents or admins added to tickets. You can then apply a filter for dates or ticket IDs to your report if you want to see the replies they added per day or further breaking it down per ticket.

    I hope the information helps! 

    0
  • Michael
    Comment actions Permalink

    I would love to get this figured out but am not finding a true representation of what is happening daily. The numbers, no matter what I try do not actually show the correct days.

    For example, on 10/28/19 I did not comment on a single ticket, yet it still shows as 8 for the day. So how do I break it down so I see the number according to the specific day a comment happened, not when a ticket is solved through automations or triggers.

    I just want to know how many tickets my agents are responding to daily so we can adjust as needed. Any help would be appreciated.

    0
  • Graeme Carmichael
    Comment actions Permalink

    Michael

    I hope I can help you here.

    Change your row date to 'Update-Date' and you should be sorted:

    0
  • Michael
    Comment actions Permalink

    Graeme

    That may have done the trick. I will monitor and test it to make sure. Thank you so much, glad to finally get this resolved.

    Michael

    0
  • Elise Alley
    Comment actions Permalink

    I'm trying to do something similar but not exactly the same.

    I'm wanting to create a report showing the average number of touches per ticket per agent for the current month.  This was a metric in Insights but apparently not in Explore...  Any help setting this up would be appreciated.  

    0
  • Devan
    Comment actions Permalink

    Hello Elise Alley,

    So I would recommend either using "Agent Updates" for any type of change the agent makes to the ticket like tags or status change or "Agent Comments" for any kind of response written the agent makes public-facing or internal. I've also shared an article that goes into further detail on recipes using agent interactions below. 

    Explore recipe: Agent interactions on tickets

    Best regards. 

     

    0
  • Miriam
    Comment actions Permalink

    Unfortunately, Graeme's suggestion doesn't do the trick. 

    I'm running into the exact same issue of not being able to report on true agent productivity because ZD automations e.g., moving a ticket from solved --> closed, are counting as 'public agent replies'. I also noticed that even internal comments would count as 'public replies' if you do a deep dive and look at every single ticket ID from your look. Reporting on agent productivity shouldn't be faulty IMO since that's the core of agent performance evaluation. 
    If I find a solution to this problem I will follow up on this thread. 

    0
  • Devan
    Comment actions Permalink

    Hello Miriam,

    This seems to be some unexpected behavior taking place, so I've opened up a ticket on your behalf. You should receive an email followed by a response from our development team soon. Let us know if there is any other way we can help. 

    Best regards. 

    0

Please sign in to leave a comment.

Powered by Zendesk