Excel Dashboards are great for tracking call center performance. Take a closer look at this KPI template and download the practice file.
The task is simple. Create a simple template using a weekly basis to take a quick overview of the call center performance. This article is a part of our Excel dashboard series.
How are call center metrics measured? In the example, we’ll use three common call center metrics.
We’ll use three KPIs:
Time to answer: We are using seconds to measure this KPI. The most used rule is to answer 90% of calls within 20-25 seconds. In the example, you can freely configure the required and accepted range.
Abandon rate (%): The rate of abandoned calls shows you how many clients disconnect before they can speak to an agent. Rate = Abandoned calls / Total inbound calls.
First Call Resolution: FCR measure the percentage of customer calls that are resolved in a single interaction.
Call Center Performance Template
- VLOOOKUP formula to find values in the ‘Data’ worksheet based on a selected cell.
- Conditional formatting is a great way to visualize KPIs.
- A scroll bar helps us to track changes week by week.
- Line charts to display the call center performance on the selected week
A closer look
You can show weekly results by using the scroll bar to change weeks. If you want to change the week, click on the scroll bars arrow, and Excel will refresh the data in real-time.
If you are tracking a call center performance, it’s crucial to use rag reporting (Red – Amber – Green) traffic light style. With conditional formatting, the task is easy.
Under the KPI setup, you can apply minimum and maximum values for your indicators. Based on these rules, you can track the weekly performance in the top-left corner of the template.
Tracking Branch performance over a 12-weeks period
Based on the selected period, you can compare the main indicators on the branch level. You need the show the average with a red line and the actual value. A smoothed line chart is great for this purpose.
Are you want to check the differences between Agents? No problem. On the bottom-right corner of the template, it is possible to take a deep dive into the details.
Thanks for being with us today!