Configuring Your Account
Understand Billing
Publishing
Analytics & Reporting
Engagement
AI and Automation
Social Listening
Sprout Integrations
Tagging
Customer Care
Salesforce Service Cloud
Instagram
Facebook
X
Tiktok
Threads
WhatsApp
LinkedIn
YouTube
Pinterest
Bluesky

What’s included in the Case Management Report?

Table of Contents

Measure the quality and efficiency of your customer care with the Case Management Report. Track key metrics like Case volume, handle and reply time and benchmark your care strategies.

Rather watch a video? Check out the tutorial: Understanding the Case Management Report

This article contains the following sections:

Configuring the report

You can filter the Case Management Report by date, Queues, Case Types and Case Priority.

To configure your report:

  • Access the Case Management Report by clicking Reports > Customer Care drop down > Case Management.
  • Select the date range and comparison period using the date picker at the top of the report.
    date-picker.png
  • Select which Queue you want to include. 
  • Select which Source you want to include. Sources are your social profiles where the Case originated from.
  • Select which Case Types you want to include. You can include General, Support, Question, Feedback, Lead or all Case Types.
    case-types.png
  • Select which Case Priorities you want to include. You can include Cases with Critical, High, Medium, Low or No Priority, or include all Case Priorities.
    case-priority.png
  • Choose which Case-level Tags you want to include - either Campaigns or Tags.

Click Share to download a PDF of the report, send or schedule a PDF delivery or create a shareable link (Premium Analytics only).

share.png

Case Volume tab

The Case Volume tab gives you insight into trends in your incoming Cases and Case Types.

case-volume.gif

This table defines Case Volume metrics and includes examples of the kinds of questions you can answer with each.

Metric Definition Value
Cases Opened The number of Cases opened, not including reopened Cases
  • How many Cases are created on a daily, monthly or weekly basis?
  • Are there enough team members to handle the volume of Cases at a given time?
Cases Closed The number of Cases closed How many cases are resolved on a daily, weekly or monthly basis?
Cases Reopened The number of previously closed Cases that were reopened Are team members appropriately trained on incoming questions?
Cases Assigned The number of Cases assigned to a team or team member for the first time, not including reassigned Cases
  • How many Cases are assigned to a team or team member on a daily, weekly or monthly basis?
  • Are there enough team members to handle the volume of Cases at a given time?
Cases Reassigned The number of Cases assigned to a different team member after an initial assignment
  • Are the appropriate team members staffed at the right time to provide the best customer experience?
  • Are teams aware of how to properly triage Cases?
  • Are my Automated Rules appropriately routing Cases?

The Case Volume Summary widget shows you an overview of your Cases opened, closed, reopened, assigned and reassigned.

case-volume.png

If you’re a Premium Analytics customer, you can select which metrics appear in the summary.

pa-case-volume.gif

The Case Volume Over Time widget shows changes in case volume over the reporting period.

case-volume-time.png

If you’re a Premium Analytics customer, you can configure the visualization by metric, view a breakdown by Case Type or Case Priority and change the visualization type.

pa-case-volume-time.gif

The Case Volume Breakdown widget shows a visualization of the Cases opened by priority and type.

case-volume-breakdown.png

If you’re a Premium Analytics customer, you can filter by Case Volume metrics.

case-volume-metric.png

The Case Volume by Hour widget shows you a heatmap of the average number of Cases opened per hour.

heatmap.png

Case Efficiency tab

The Case Efficiency tab highlights industry-standard metrics to help you measure the effectiveness of your customer care.

case-efficiency.gif

This table defines Case Efficiency metrics and includes examples of the kinds of questions you can answer with each.

Note: If you’ve set custom business hours, these metrics only include time within those hours.

Metric Definition Value
Average Handle Time The average time a Case was In Process or Open after the Case is assigned to a team member. This metric excludes time when a Case is On Hold or not assigned to a team member.
  • How much time on average are customers interacting with our team members to resolve a case?
  • How much time on average are team members/teams spending on cases? How does that compare to our SLAs?
Average First Reply Time The average time it took a team member to send a first reply after a Case is opened
  • How long are customers waiting to receive a reply?
  • How quickly are team members able to respond to new Cases?
Median First Reply Time (Premium Analytics only) The median time it took a team member to send a first reply after a Case is opened
  • How long are customers waiting to receive a reply?
  • How quickly are team members able to respond to new Cases?
Average Reply Time The average time it took a team member to send a reply
  • How long are customers waiting to receive a reply?
  • How quickly are team members able to respond to new Cases?
Median Reply Time (Premium Analytics only) The median time it took a team member to send a reply
  • How long are customers waiting to receive a reply?
  • How quickly are team members able to respond to new Cases?
First Contact Resolution The percentage of Cases that were closed after one reply Can our team members resolve Cases without additional follow-up?

A note on Median First Reply Time: 

Why does Median First Reply Time show as 0 for certain agents in the Inbox Team Report?

Answer: This occurs due to the interaction between business hours and median calculations in the Inbox Team Member Performance Report. Replies sent outside configured business hours are recorded as 0 seconds. Since the median is the middle value of an ordered dataset, the distribution of these 0-second entries determines the final metric:

  • Median is 0: This happens when an agent sends the majority (over 50%) of their replies outside business hours, making 0 the middle number.
  • Median is greater than 0: This happens when the majority of replies occur during business hours. The 0-second values remain at the bottom of the dataset, and the median reflects a standard response time.

 

The Case Efficiency Summary widget shows you an overview of each metric.

case-efficiency.png

If you’re a Premium Analytics customer, you can include Median First Reply Time and Median Reply Time.

pa-efficiency.gif

The Average Handle Time widget shows the average time to Case resolution over the reporting period.

avg-handle-time.png

If you’re a Premium Analytics customer, you can view Average Handle Time by Case Type or Case Priority and customize the visualization.

pa-avg-handle.gif

The First Reply Time widget gives you insight into how quickly your teams responded to Cases during the reporting period.

first-reply.png

If you’re a Premium Analytics customer, you can also see Median First Reply Time, filter by Case Type or Case Priority and customize the visualization.

pa-first-reply.gif

The Reply Time widget shows how quickly Cases were resolved during the reporting period.

reply-time.png

Premium Analytics customers can see Median Reply Time, filter by Case Type or Case Priority and customize the visualization.

pa-reply-time.gif

The Case Efficiency Breakdown widget gives you an overview of efficiency metrics by Case Type and Case Priority.

case-efficiency-breakdown.png

Premium Analytics customers can see metrics for Median First Reply Time and Median Reply Time.

pa-efficiency.png

Strategy tips:

  • Use the Case Volume by Hour widget to identify the times when your team receives the most inquires. Schedule additional team members to be available during those times to ensure prompt responses.
  • Use the Case Volume Breakdown widget to understand the types of cases your team is handling and their profiles. This can help you allocate resources and training effectively. 

Case Assignee tab

You can use the Case Assignee tab to measure the performance of individual team members, measure the volume of cases assigned and efficiency in resolving customer issues. The included Case Assignee Performance widget uses data from cases for the length of time you've had your Sprout account, with the exception of Average Reply Time. This metric's availability begins in May 2023.

45da4671-dee3-4e23-b2cb-8e2f43fe5363.png

The following table breaks down the metrics included in the Case Assignee Performance widget on the Case Assignee tab:

Metric Definition
Cases Assigned The number of cases assigned to a team member in the selected date range.
Same Period Cases Closed For cases assigned during the selected date range, this reflects the number of those cases that were also closed during the selected date range.
Case Completion Rate For cases assigned to a team member in the selected date range, this reflects the percentage of those cases that were also closed by that team member during the selected date range.
Total Cases Closed The number of cases closed during the selected date range. This includes any cases that had been opened prior to the selected date range.
Cases Reassigned The number of cases reassigned to a different team member.
Average Handle Time The average time a case was Open after it is assigned to a team member until it is closed.
Average Reply Time

The average time it took to send a reply.

If you have set custom business hours, this metric only includes time within those hours.

Average First Reply Time

The average time it took to send the first reply after a case is opened.

If you have set custom business hours, this metric only includes time within those hours.

Premium Analytics features

If you're a Premium Analytics user, you have access to additional metrics and can choose which metrics you want to appear in the Case Assignee Performance widget.

The additional metrics available include:

Metric Definition
Average Time to Resolution (PA-only metric)

The average time for a case to close after it was opened. This include the time a case is in

On Hold Status or Not Assigned status.

Median First Reply Time

The median time it took to send the first reply after a case is opened.

If you have set custom business hours, this metric only includes time within those hours.

Median Reply Time


The median time it took to send a reply.

If you have set custom business hours, this metric only includes time within those hours.

You can also click Screenshot 2024-02-26 at 1.08.07 PM.png to open the metric selector in the Case Assignee Performance widget to choose which metrics you want to include in the report.

Tags tab

You can use the Tags tab to view key metrics broken down by tags applied to cases across your queues. 

The Case Volume by Tag widget lets you compare and see trends in the volume of cases based on their applied tags.

The Case Efficiency by Tag lets you compare and see trends in the efficiency of cases based on their applied tags.

The Case Tag Performance lets you review your aggregate tag metrics for cases.

Queues tab

You can use the Queues tab to review case performance metrics across queues.  

The following table breaks down the metrics included in the Case Queue Performance widget on the Queues tab:

Metric Definition
Cases Opened

The number of new cases opened.

This does not include reopened cases.

Cases Closed The number of cases closed during the selected date range. This includes any cases that had been opened prior to the selected date range. 
Average Handle Time

The average time a case was Open after it is assigned to a team member until it is closed.

This excludes time a case is On Hold or not assigned to a team member.

If you have set custom business hours, this metric only includes time within those hours.

Average First Reply Time

The average time it took to send the first reply after a case is opened.

If you have set custom business hours, this metric only includes time within those hours.

Average Reply Time

The average time it took to send a reply.

If you have set custom business hours, this metric only includes time within those hours.

Premium Analytics features

If you're a Premium Analytics user, you have access to additional metrics and can choose which metrics you want to appear in the  widget.

The additional metrics available include:

Metric Definition
Cases Handled to Goal Time The percentage of cases that were handled within your goal time for a specific queue.
First Replies to Goal Time The percentage of cases for which the first reply was within your goal time for a specific queue.
Replies to Goal Time The percentage of cases that were replied to within your goal time for a specific queue.

To set goal times for cases and measure your team's performance, navigate to your Reporting settings.  You must have Manage Case Settings permissions to set goal times.

Video Guide

Was this article helpful?

0 out of 0 found this helpful

Table of Contents