We want to analyze our support team activity more closely, beyond the number of solved tickets. Can we report on agent touches in Insights?
Yes, it is possible to report on the agent touches, but you'll need to decide which agent activity you want to track. Here are few options to consider.
If you want to track not only the comments posted by agents but other ticket updates too, use the default # Ticket Updates metric. The formula of this metric is:
SELECT COUNT(Ticket Updates, Ticket Text Field Change). It returns ticket events during which at least one ticket text field value was updated.
What is considered a ticket text field in Insights? The text field is any non-numeric ticket field excluding tags and comments. The most frequently used text fields are status, priority, group, assignee, custom drop-down, and check box.
Ticket comments, tags, and numeric fields are not part of the Ticket Text Field data set, which is why such events aren't counted by the # Ticket Updates metric. For instance, if an agent posts a comment without changing the ticket status or any other ticket properties, this update will not be captured by the metric.
Total Ticket Updates
To create the report
Click the Reporting icon () in the sidebar, go to Insights > GoodData.
In the top menu, click Reports.
Then click Create Report button in the top right corner.
Open the What menu and select one or all of the metrics: # Ticket Updates, # Total Ticket Updates, # Total Comments, # Public Comments and # Private Comments.
Open the How menu and select Updater and one of the event date attributes.
Open the Filters menu and click Select from a list of Values.
Select Updater Role attribute, select Agent and Admin values.
- Open Filters menu and click Select from a list of Values.
Select a date event attribute and set a floating range.