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
- Case Volume tab
- Case Efficiency tab
- Assignee Performance tab
- Tags tab
- Queues tab
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.
- 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.
- 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.
- 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).
Case Volume tab
The Case Volume tab gives you insight into trends in your incoming Cases and Case Types.
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 |
|
| 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 |
|
| Cases Reassigned | The number of Cases assigned to a different team member after an initial assignment |
|
The Case Volume Summary widget shows you an overview of your Cases opened, closed, reopened, assigned and reassigned.
If you’re a Premium Analytics customer, you can select which metrics appear in the summary.
The Case Volume Over Time widget shows changes in case volume over the reporting period.
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.
The Case Volume Breakdown widget shows a visualization of the Cases opened by priority and type.
If you’re a Premium Analytics customer, you can filter by Case Volume metrics.
The Case Volume by Hour widget shows you a heatmap of the average number of Cases opened per hour.
Case Efficiency tab
The Case Efficiency tab highlights industry-standard metrics to help you measure the effectiveness of your customer care.
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. |
|
| Average First Reply Time | The average time it took a team member to send a first reply after a Case is opened |
|
| 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 |
|
| Average Reply Time | The average time it took a team member to send a reply |
|
| Median Reply Time (Premium Analytics only) | The median time it took a team member to send a reply |
|
| 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.
If you’re a Premium Analytics customer, you can include Median First Reply Time and Median Reply Time.
The Average Handle Time widget shows the average time to Case resolution over the reporting period.
If you’re a Premium Analytics customer, you can view Average Handle Time by Case Type or Case Priority and customize the visualization.
The First Reply Time widget gives you insight into how quickly your teams responded to Cases during the reporting period.
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.
The Reply Time widget shows how quickly Cases were resolved during the reporting period.
Premium Analytics customers can see Median Reply Time, filter by Case Type or Case Priority and customize the visualization.
The Case Efficiency Breakdown widget gives you an overview of efficiency metrics by Case Type and Case Priority.
Premium Analytics customers can see metrics for Median First Reply Time and Median Reply Time.
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.
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 |
If you have set custom business hours, this metric only includes time within those hours. |
You can also click 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?