Case Level Analytics

Updated 

The Case Level Analytics Report provides in-depth tracking of key metrics such as Contact Drivers, Sentiment, Predicted CSAT Score, and Average Handling Time at the case level. It enables the generation of detailed reports using standard metrics and dimensions while also offering the flexibility to incorporate custom metrics for more precise and actionable insights.

The Case Level Analytics Report belongs to the Conversational Analytics Report Group.

Metrics and Dimensions

The following are the Metrics and Dimensions available under the Case Level Analytics Report:

Name 

Definition 

Initial Predicted CSAT Score 

Indicates the CSAT score that was initially predicted on the case before the brand response was made on the associated case 

Previous Predicted CSAT Score 

Indicates the previous CSAT score based on the the brand response made on the associated case. This will show the CSAT just before the current CSAT score on the case if the score changed, or else will be same as predicted CSAT score 

First Response Time Including Bot (Case) 

Measures the duration of first brand (inclusive of both agent and bot) response that was sent on the case from the first customer message associated on the case 

Case Closure Duration 

Measures the closure duration of the case based on difference between case closure time and case creation time. SLA Preset will be applicable on this metric if applied. 

Case Count 

Measures the count of all the cases that were created in the platform across all the channels 

All Engaged Agents Count 

Measures the count of all the users based on either agent assignment, agent response or macro application depending on on the values selected in "service settings screen". 

All Responded Agents Count 

Measures the count of all the users who were assigned and further replied to the associated case 

Case Distinct Customer 

Measures the distinct number of users or customer profiles that have a case associated with them 

Associated Message Count 

Measures the overall message count associated on the case. This is a sum of both customer and brand messages including bot responses, auto responses, auto imports and call transcripts (if any) 

Current Predicted CSAT Score 

Indicates the current CSAT score based on the the brand response made on the associated case 

 

Name 

Definition 

Sentiment 

Final Sentiment of the case 

Case Queue 

Indicates the current case queue that the case is associated to or a part of. Eg. Awaiting Assignment Queue, Assigned Queue etc 

Month Of Year 

The name of the Calendar Month on which the activity occurred. 

All Engaged Agents Group 

Indicates the agent group of which the user is a part of based on either agent assignment, agent response or macro application depending on the values selected in "service settings screen". If the user is a part of multiple agent groups, it will show in separate rows. 

Case Associated Customer 

The sender profile name associated with the first message in the case. Messages are ordered in a case based on the time they were associated to the case, not necessarily the date and time the messages were created. 

Deflected To Channel 

Indicates the name of channel to which the associated case has deflected to 

Case Closure Time 

The timestamp when the case was marked closed 

Initial Channel Type 

This depicts the channel of the first message from which case was created 

Account 

The name of the social network account. When used with case details, this will display the name of the "Brand Account" through which the first message associated to the case is grabbed. Messages are ordered in a case based on the time they were associated to the case, not necessarily the date and time the messages were created. 

Difference between Current and Initial Predicted CSAT Score 

Indicates the difference between current and initial predicted CSAT score on the case 

Language 

Indicates the language detected based on the social channel that the case is associated with. Only used for live chat cases 

Time Of Day 

The specific 1 hour period within a day when an activity occurred, displayed in the 24-hour clock format (hh:mm) and adjusted to the user's time zone.  

All Engaged Agents 

Indicates the names of all the users based on either agent assignment, agent response or macro application depending on on the values selected in "service settings screen". In case there are multiple agents associated, this will show each name in a separate row 

Deflected From Channel 

Indicates the name of channel from where the associated case has been deflected from 

External Channel Name 

Indicates whether the case is being managed by the Sprinklr case module or a third party CRM (only used when an integration is enabled). 

Account Group 

The name of the Sprinklr Account Group. An Account Group is a collection of Accounts within a Client that can contain multiple social networks. You can create and edit these groups under Administration> Settings. 

Case Creation Interval 

Indicates the time interval for when the case was created. This is a histogram dimension and can be used when we want to see cases at daily/weekly etc level 

All Engaged Agents List 

Indicates the names of all the users based on either agent assignment, agent response or macro application depending on on the values selected in "service settings screen". This also shows the email ID of the engaged agent 

Difference between Current and Previous Predicted CSAT Score 

Indicates the difference between current and previous predicted CSAT score on the case 

Case Details 

This is the Case. It will include the Case subject, case ID and description. This dimension should be used to compose tables like the Outbound Post or Inbound Message dimension. 

Case Number 

The ID number associated to the case. 

Case Modification Time 

This the latest timestamp when the case was modified the last time 

Channel 

Provides the name of the channel associated on the case.  This dimension can be used to segment a common metric across multiple channels and will show the list of all channels associated to the first first message of the case 

Case Creation Time 

Indicates the time for when the case was created. This metric will not aggregate data of cases based on time interval 

Case Closure Interval 

Indicates the time interval for when the case was marked as closed This is a histogram dimension and can be used when we want to see cases at daily/weekly etc level 

Net Sentiment Change 

Indicates the difference between the predicted CSAT score and the initial CSAT score associated to the case 

Contact Driver 

All contact drivers detected in the case, including the initial and root contact drivers. This can be plotted at the case, case-interaction, call, or message level. 

Primary Contact Driver 

Primary contact driver of the case-interaction. This can be plotted at the case, case-interaction, call, or message level. 

Contact Drivers List 

All contact drivers detected in the case, including the initial and root contact drivers, as a comma-separated list. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Model 

Name of the contact driver model from which the contact drivers are detected. This can be plotted at the case, case-interaction, call, or message level. 

Intent Conversation ID 

Unique ID mapped against the case-interactions on which contact drivers are detected. 

Contact Driver Group L1 

Contact driver group detected at the L1 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L2 

Contact driver group detected at the L2 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L3 

Contact driver group detected at the L3 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L4 

Contact driver group detected at the L4 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L5 

Contact driver group detected at the L5 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L6 

Contact driver group detected at the L6 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L7 

Contact driver group detected at the L7 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L8 

Contact driver group detected at the L8 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L9 

Contact driver group detected at the L9 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Group L10 

Contact driver group detected at the L10 level. This can be plotted at the case, case-interaction, call, or message level. 

Contact Driver Interaction 

Unique identifier of the case-interactions on which contact drivers are detected, consisting of the social network and start time of the interactions. 

Smart Clustering Sentiment 

AI detected sentiment of the message containing Smart Clustering phrase.  

Smart Clustering Category 

AI identified attribute-type themes at phrase level within underlying messages based on clustering similar phrases  

Smart Clustering Subject 

AI identified subject-type themes at phrase level within underlying messages based on clustering similar phrases 

Smart Clustering - Is Brand Post 

A boolean value that determines if the messages on which the smart clustering phrase was detected were sent by the brand or not 

Smart Clustering Keyword 

AI identified top words within underlying messages based on clustering of similar keywords 

Smart Clustering Keyword Type 

Type of AI identified themes at phrase level within underlying messages based on clustering similar phrases 

Smart Clustering Phrase 

AI identified themes at phrase level within underlying messages based on clustering similar phrases 

Smart Clustering Case Count 

Measures the count of all the cases for which Smart Clustering Phrases were detected 

 

This concludes our comprehensive coverage of the Case Level Analytics Report. For more details on the Reports available under Service Analytics, please refer to the Detailed Reports Glossary .