10 KPIs for Customer Service
Take inspiration from us and create realtime dashboards with your most important business metrics for your Customer Service department.
Table of contents
Introduction
We have gathered some of the most common KPIs measured by the Customer Service (CS) department. Draw inspiration for your CS dashboard and use these KPIs to give everyone a realtime overview of their workload, progress, status, and more.
What is a KPI?
In Plecto, a Key Performance Indicator or KPI consists of formula + widget + time period. This article will show you how to build formulas and add them to dashboard widgets to create the best overview of your CS performance. You can add the same formula to multiple widgets to get different KPIs – this applies to all formulas in Plecto! 🙌 Find more inspiration in our KPI library.
Some formulas require date modifiers
Your data source might have multiple date fields. If you created 5 registrations today but updated 20, which number should Plecto include in the calculations? This is where the default date field comes in. Each data source has a default date field that determines which of the numbers Plecto should display.
In some cases, you might want to use another date field in your formula than the default date. If so, you can add a date modifier to the formula component. Many of the KPIs listed in this article require date modifiers to ensure that you get the most accurate results. Watch the video below to learn how to add a date modifier.
Integrations included in the formula examples
The formula examples in this article are based on different integrations, such as Aircall, Zendesk, Salesforce, Vitally, and others. You can use any of our integrations to build the same or similar KPIs – it all depends on what data you import to Plecto. Find the different systems Plecto integrates with and the available data types on our Integration page.
Tip – Install readymade dashboards from Plecto Store
We offer readymade dashboards created by our experts that you can install for free. Integrate your systems with Plecto, then go to the Plecto Store and see if there's anything you like.
Number of Support Tickets
Get an overview of your support tickets. See the number of tickets created today or how many tickets you've had during the month compared to last month. Here are some examples of how you can use the formula on a dashboard:
 Add it to a number widget to see the number of tickets created today, the current week, or during another time period.
 Add the formula to a column chart and group your tickets by status, priority, type, or other fields from your data source.
 Add the formula to a line chart and see how many tickets got created this month vs. last month.
Tip – Use custom group by
Get an overview of your support cases by different mediums – how many customers contact you through chat, phone, email? Take a pie or column chart and group the results by a specific field from your data source.
The same formula can be reused across all widgets on dashboards, in reports, and contests. Use the Group By option on your widgets to get different KPIs from the same formula.
How to create the Number of Support Tickets KPI
Example with Zendesk Tickets. You can use any other integrations and data sources
 Create a new formula and add a data function component.
 Lookup function: Number of
 Data source: Zendesk Tickets, Freshservice Tickets, or other data sources. Make sure to select the data source relevant to your organization.
 Set the number format in the formula editor to Decimal number.
 (Optional) Feel free to customize your formula by adding conditional colors.
 Click Save in the bottomright corner.
Tip – Add filters
Number of is one of the most simple KPIs you can create. Feel free to add filters to track the number of support tickets with the status open, closed, or others. Here's more general information on how to build formulas in the formula editor.
5. Open your dashboard and add the formula to a widget of your choice. We like line or area charts, but it's really up to you to decide how you want to see your metrics.
6. Choose the time period, for example, Current month or Month to date.
7. Click Save to finish and add your KPI to the dashboard.
And this is how the formula looks in the Advanced editor. You can copy and use the formula in your formula editor, but make sure to choose your own data source.
(
Count(Zendesk Tickets)
)
Number of Solved Tickets
This formula is similar to the Number of Support Tickets formula, except that it filters the registrations and only counts the number of tickets with the status solved. Please note that the status name can differ from integration to integration (solved, resolved, closed, etc.).
The widget displays number of solved tickets compared to all tickets this month.
How to create the Number of Solved Tickets KPI
Example with Zendesk Tickets, Freshdesk Tickets, Freshservice Tickets
 Create a new formula and add a data function component.
 Lookup function: Number of
 Data source: Choose a data source that stores data about your tickets, for example, Zendesk Tickets, Freshdesk Tickets, or others.
 Click + Add filter and choose the field that contains information about the ticket status. We've mapped some data sources and their field names and values. Look for the following, depending on your data source:
Zendesk Tickets = Status = solved
Freshdesk Tickets = Status = Resolved
Freshservice Tickets = Status = Resolved  Add a date modifier to the component to make sure you see the right KPIs. Click on the three dots in the topright corner of the component and choose the relevant date field, for example, Updated at, Resolved at, or others.
 Set the number format in the formula editor to Decimal number.
 (Optional) Feel free to customize your formula by adding conditional colors.
 Click Save in the bottomright corner.
5. Open your dashboard and add the formula to a widget. We would choose a speedometer widget.
6. (Optional) Add a target formula, for example, one that counts the number of all tickets.
7. Choose the time period on the widget, such as Today or Current month.
8. Click Save to finish and add your KPI to the dashboard.
Here's how the formula looks in the Advanced editor. If you take this formula, make sure to change the data source, fields, and filters relevant to your organization.
(
Count(Zendesk Tickets,Status="solved").Date(Updated at)
)
Average Resolution Time (ART)
Average Resolution Time (ART) takes the total duration of all resolved customer interactions and divides it by the total number of interactions. This formula example is based on Zendesk Tickets, but feel free to use it with other systems.
How to create the Average Resolution Time KPI
Example with Zendesk Tickets
 Create a new formula and give it a title.
 Add a data function component in the formula editor.
 Lookup function: Sum of
 Data source: Zendesk Tickets
 Field: Resolution time
 + Add filter: Status = solved
 Date field: Updated at
 Add a new data function component.
 Lookup function: Number of
 Data source: Zendesk Tickets
 Change the operator between both components to ➗.
 Change the number format to Duration. If lower resolution time is what you're going for, you can enable the Lower value is better option.
 (Optional) Feel free to add conditional colors. For duration KPIs, the conditions need to be indicated in seconds.
 Click Save in the bottomright corner.
8. Open your dashboard and add the formula to a Number box.
9. Choose a time period, such as Today, Current week, or others, depending on your needs.
10. Click Save to finish and add your KPI to the dashboard.
An example of the Average Resolution Time formula added to number box widgets with different time periods selected.
Here's the Average Resolution Time formula for the Advanced formula editor.
(
Sum(Zendesk Tickets,Status="solved",Resolution time).Date(Updated at)
/
Count(Zendesk Tickets)
)
Average First Response Time (FRT)
The Average First Response Time or FRT is the average time it takes your agents to respond to a customer inquiry or support ticket.
An example of the Average First Response Time KPI.
How to create the First Response Time KPI
Example with Freshservice Tickets
 Create a new formula and give it a title.
 Add a data function component in the formula editor.
 Lookup function: Avg
 Data source: Freshservice Tickets
 Field: First response time in secs
 Date field: First responded at
 Change the number format to Duration. If lower response time is what you're going for, you can enable the Lower value is better option.
 (Optional) Feel free to add conditional colors. For duration KPIs, the conditions need to be indicated in seconds.
 Click Save in the bottomright corner.
6. Open your dashboard and add the formula to a Number box.
7. Choose a time period, such as Today, Current month, or others, depending on your needs.
8. Click Save to finish and add your KPI to the dashboard.
Here's how the FRT formula looks in the Advanced editor.
(
Avg(Freshservice Tickets,First response time in secs).Date(First responded at)
)
Average Handle Time (AHT)
The Average Handle Time (AHT) reflects how much time it takes your agents to handle a customer transaction. Usually AHT is calculated by dividing the total talk time + total hold time + total wrapup time by the total number of calls.
An example of the AHT formula added to a number box widget.
How to create the Average Handle Time KPI
Example with Zendesk Calls
 Create a new formula and add a group component.
 In the group component, add three data function components:
 Sum of Talk time in Zendesk Calls.
 Sum of Hold time in Zendesk Calls.
 Sum of Wrap up time in Zendesk Calls.
 Change the date field to Updated date on all three components above.
 Add a separate data function component that counts the Number of Zendesk Calls.
 Change the operator between the group and data function components to ➗.
 Change the number format to Duration.
 (Optional) Feel free to add conditional colors. For duration KPIs, the conditions need to be indicated in seconds.
 Click Save in the bottomright corner.
8. Open your dashboard and add the formula to a widget. We would choose a number box.
9. Choose the time period, such as Today, Current week, or others.
10. Click Save to finish and add your KPI to the dashboard.
This is how the formula looks in the Advanced formula editor. Feel free to use the formula, but make sure to doublecheck your data source and field names.
(
(
Sum(Zendesk Calls,Talk time).Date(Updated date)
+
Sum(Zendesk Calls,Hold time).Date(Updated date)
+
Sum(Zendesk Calls,Wrap up time).Date(Updated date)
)
/
Count(Zendesk Calls)
)
Agent Availability Status
See the latest availability status of your agents. Your agent statuses change constantly, and since you want to see the most recent agent status, you'll have to use the data function Last.
You can see the agent availability status on the table widget. Please note that the status names differ from system to system.
How to create the Agent Availability Status KPI
Example with Aircall Users
 Create a new formula and add a data function component.
 Lookup function: Last
 Data source: Aircall Users
 Field: Availability status
 Change the number format to Text.
 (Optional) Customize your formula with conditional colors. Add red if the user is unavailable, green if available, and so on. Add the conditions as they appear in your data source – the conditional colors are casesensitive.
 Click Save in the bottomright corner.
5. Open your dashboard and add the formula to a table widget. The table widget allows you to get an overview of all your agent statuses. Feel free to add multiple columns to see other agent KPIs on the same widget.
6. Set the time period to Today.
7. Click Save to finish and add your KPI to the dashboard.
Below is the formula for the Advanced editor. You can copy and paste the formula in the Advanced formula editor and use it to track your agent availability from Aircall.
(
Last(Aircall Users,Availability status)
)
Top Agents – Leaderboard
See who's answered the most calls, customer cases, and more. You can use one of your existing formulas that calculates, for example, the number of support tickets, the number of calls, or other metrics, and add it to a leaderboard on your dashboard. The widget will do the rest.
An example of a Talkdesk dashboard. The top agents with the most calls are displayed in the bottomleft corner.
How to create the Top Agents KPI
Works with any formula
 Use your existing formula such as Number of Answered Calls.
 Add the formula to a leaderboard widget on the dashboard.
 Choose a time period on the widget. Your widget will be most engaging if you set the time period to Today, the Current week, or Current month.
Average Wait Time
Your customers are more likely to give you a good score if they don't have to wait on an agent to reply to their call. Track your average waiting time and see where you can improve your service.
An example dashboard for Zendesk Calls.
How to create the Average Wait Time KPI
Example with Zendesk Calls
 Create a new formula and add a data function component.
 Lookup function: Avg
 Data source: Zendesk Calls
 Field: Wait time
 (Optional) Customize your formula with conditional colors. Add red if the wait time is over 120 seconds, yellow if 30, green if 0. You will see different colors based on the range the KPI falls in.
 Change the number format to Duration.
 Click Save in the bottomright corner.
5. Open your dashboard and add the formula to a number box.
6. Change the time period to Today, the Current week, or Current month.
7. Click Save to add your KPI to the dashboard.
This is how the formula looks in the Advanced formula editor.
(
Avg(Zendesk Calls,Wait time)
)
Customer Satisfaction Score (CSAT)
See how satisfied your customers are by tracking your Customer Satisfaction Score. To get the CSAT score, divide the number of satisfied customer responses by the total number of responses.
An example of the CSAT KPI on a number widget.
How to create the CSAT KPI
Example with Freshdesk Satisfaction Ratings
 Create a new formula and add a group component.
 In the group, add a new data function component.
 Lookup function: Number of
 Data source: Freshdesk Satisfaction Ratings
 Filter: Rating = Extremely Happy
 Click on the three dots in the topright corner of the data function component and click Duplicate component.
 Repeat the previous step and duplicate the component one more time. You should have three of the same components inside a group component.
 In the second component, change the filter to Rating = Very Happy.
 In the third component, change the filter to Rating = Happy.
 Add a new data function component (not inside the group) that counts the Number of Freshdesk Satisfaction Ratings.
 Change the operator between data function and the big group component to ➗.
 Change the number format to Percent.
 (Optional) Customize your formula with conditional colors.
 Click Save in the bottomright corner.
Formula structure
You might see either text (Extremely Happy) or numbers (4, 5) in your data source – that depends on what system you use to keep track of your ratings. If your feedback comes in numbers, you can skip creating the group component shown in the example above. Instead, divide your satisfaction ratings where the score is greater than or equal to 4 by the total number of ratings.
12. Open your dashboard and add the formula to a speedometer or number box widget.
13. Change the number format to the Current month, Current quarter, or another time period.
14. Click Save to add the KPI to your dashboard.
Here's a formula for the Advanced editor. You can copy and reuse the formula, but make sure to choose your own data source and field values.
(
(
Count(Freshdesk Satisfaction Ratings,Rating="Extremely Happy")
+
Count(Freshdesk Satisfaction Ratings,Rating="Very Happy")
+
Count(Freshdesk Satisfaction Ratings,Rating="Happy")
)
/
Count(Freshdesk Satisfaction Ratings)
)
Net Promoter Score (NPS)
Gather feedback from your customers to understand how well your product or service performs. To get the NPS score, you subtract the % of detractors from the % of promoters. For example, if 70% of your respondents are Promoters and 10% are Detractors, your Net Promoter Score is 60.
An example of an NPS score added to a speedometer widget.
How to create the NPS KPI
Example with Vitally NPS responses
 Create a new formula and add a group component.
 In the group component, add a data function component that counts the Number of NPS responses.
 Add a filter to get the number of responses where the score is greater than or equal to 9.
 Add a new data function component that counts the Number of NPS responses.
 Change the operator between the first and second components to ➗.
 Add a third component in the group – static number. Enter 100, and change the operator between this component and the middle one to ✖️.
 Duplicate the group by clicking on the three dots in the topright corner of the group component.
 In the duplicated group, find the first data function component and change the filter condition to score is less than or equal to 6.
 Change the operator between both groups to ➖.
 (Optional) Add conditional colors.
 Click Save in the bottomright corner.
7. Open your dashboard and add the formula to a widget. We would choose a speedometer widget or a number box.
8. Choose a time period such as the Current quarter or year.
9. Click Save to add your KPI to the dashboard.
This is how the NPS formula looks in the Advanced editor. You can copy and use the formula in your formula editor, but make sure to choose your own data source.
(
(
Count(Vitally NPS responses,Score>=9)
/
Count(Vitally NPS responses)
*
100
)

(
Count(Vitally NPS responses,Score<=6)
/
Count(Vitally NPS responses)
*
100
)
)
Useful tips
Here's some practical advice on how to get the best out of your formulas.
 Once you create a formula in the formula editor, you can reuse the formula across the entire platform. Add the same formula to dashboard widgets, reports, contests, notifications, and more.
 If you have a formula that counts the number of registrations in your data source (data function = Number of), you can add it to a dashboard widget that supports custom grouping and see the KPIs based on a specific field from your data source.
 Know the default date field of your integration data sources. Plecto uses the default date to show your KPIs. If the default date is Created date, but you want to see the number of registrations based on Updated date, you might consider changing the default date field (which will apply to all formulas) OR adding a date modifier to your formula (will apply to a single formula). Find the default date field in your data source settings.
 Is your widget showing 0? Check if you changed the Number format in the formula editor. If you expect the widget to display text such as Available, but the number format is Decimal number, the widget will show 0.
Was this article helpful?
Please leave a comment to help us improve.