Call Center Scorecard Template
We’ll show you how to create in Excel an advanced call center performance dashboard. KPIs are necessary to track the performance. Free Cccam Server Test Line there. Our objective: Build a one-page excel for tracking the actual status of key performance indicators. Before we start, we’ll introduce you the most used kpis in call centers. Call center performance dashboard – Overview Check the actual status of • Time to answer for the selected week • Abandon rate for the selected week • First call resolution for the selected week • The period (average of the branch) from the actual week to actual week + 3 months Let us see a quick dashboard overview: Put the results into our kpi dashboard in Excel We are divided this excel model into three separate worksheets for the call center performnce dashboard, the main dashboard sheet, the input data and the calculation area. It is one of the easiest ways to build a clear and structured model. The implementation of the raw data and calculated value is very easy: The main dashboard worksheet with the all figures is linked directly to the data table.
Key Performance Indicators for call center Using these key performance indicators we can track and trace the overall service performance. Time to answer: this performance dimension usually expressed in second this is the time from when a call is started until it is responded by a customer service agent.
Driver Usb Smart Card Reader Setool. Using the average call time to answer telephone call is the base of calculation. Abandon Rate of incoming calls: we measure this key performance indicator as a% of the number of callers who are cut off, before they touch an agent who answers their call.
How we calculate this kpi?: [numbers of abandoned calls while the customer waiting] / [total incoming phone calls] Use this formula to calculate FCR (First Call Resolution) value = [issue solved by first call] / [total issues] this is a very important dimension (my opinion it is hard to tracking), expressed as a percentage, the number of those calls and that they will be responded to at the first try during the call. In this case do not require the customer to call back. Instructions to create call center performance dashboard 1. In this example we’ll use weekly basis.