Customer Service KPIs: 8 Metrics, Formulas & Free Excel Template

Customer service KPIs help you measure how much service demand your business receives, how quickly customers get a response, how efficiently issues are resolved, and how customers perceive the experience.

You do not need dozens of metrics to start. A practical measurement system can combine ticket volume, pending tickets, first response time, resolution time, First Contact Resolution (FCR), Customer Satisfaction Score (CSAT), Customer Effort Score (CES), and Net Promoter Score (NPS).

In this guide, you will learn what each customer service KPI measures, how to calculate it, how to interpret the results, and how the metrics work together. You can also use the free Customer Service KPI Excel template to record cases and calculate the same indicators covered in the examples.}

Table of Contents

Customer Service KPIs at a Glance

Customer service KPIWhat it helps you understandBasic formula
Tickets ReceivedCustomer service demandCount of tickets received
Pending TicketsUnresolved workload at the cutoff dateCount of eligible open cases
Average First Response TimeHow quickly customers receive an initial responseTotal first response time ÷ tickets with a first response
Average Resolution TimeHow long cases take to resolveTotal resolution time ÷ closed tickets
First Contact Resolution (FCR)How often cases are solved without additional contactsFirst-contact resolutions ÷ eligible cases × 100
CSATCustomer satisfactionPositive responses ÷ valid responses × 100
CESHow easy the service experience wasTotal CES scores ÷ valid responses
NPSWillingness to recommend the business% Promoters − % Detractors

These KPIs should not be interpreted independently. A team can respond quickly but resolve cases slowly, maintain a low backlog while customer satisfaction declines, or achieve a high FCR while customers still report a difficult experience.

The objective is not simply to improve every number. It is to understand what changed, where the problem may be, and what should be investigated next.

What Are Customer Service KPIs?

Customer service KPIs are measurable indicators used to evaluate whether a business is delivering the level of service it expects.

They can help answer practical questions such as:

  • How many customer cases are we receiving?
  • How much unresolved work is accumulating?
  • How long do customers wait for a first response?
  • How long does it take to solve their problems?
  • How often can we resolve an issue on the first contact?
  • Are customers satisfied after receiving support?
  • Is it easy for customers to get help?
  • Would customers recommend the business?

Customer service measurement generally combines operational indicators with customer feedback indicators. For example, first response time and resolution time measure aspects of service speed, while CSAT, CES, and NPS provide different views of the customer’s perception.

If you are defining the procedures, responsibilities, and operating rules behind these metrics, see our Customer Service Manual. The manual focuses on how the service operation should work; the KPIs in this guide help you measure how that operation is performing.

Customer Service Metrics vs. KPIs: What Is the Difference?

A customer service metric is any measurable value related to the service operation. Examples include emails received, open cases, customer calls, survey responses, number of contacts, or cases handled by an employee.

A KPI, or key performance indicator, is a metric selected because it helps evaluate an important objective or supports a management decision.

For example, the number of pending cases is simply a metric until the business uses it to evaluate whether its customer service capacity is keeping up with demand. At that point, it can become a KPI.

The distinction matters because tracking more data does not automatically create better management. A small business usually benefits more from a limited set of indicators that lead to decisions than from a large dashboard that nobody acts on.

8 Customer Service KPIs to Track

To make the calculations easier to follow, we will use one example throughout the guide: a small ecommerce business called Nova Home Online Store.

During the reporting period, Nova Home recorded 15 tickets received, 13 tickets closed, 2 tickets pending at the cutoff date, 14 tickets with a first response, and 13 valid responses for the customer experience indicators. These are the same sample cases included in the downloadable Excel template.

1. Tickets Received

Tickets Received measures how many customer cases enter the service operation during a defined period. A ticket might represent a complaint, return, exchange, delivery problem, billing question, product question, or another customer service request.

Formula:

Tickets Received = Count of tickets opened during the reporting period

Nova Home received 15 tickets during the example period.

This number provides context for the rest of the customer service KPIs. For example, closing 50 cases means something different if the business received 40 new tickets than if it received 100.

An increase in tickets is not automatically a service failure. Volume could increase because sales grew, a promotion generated more orders, a new channel was introduced, or more customers started using support. The next question should therefore be why demand changed.

2. Pending Tickets or Backlog

Pending tickets show how much customer service work remains unresolved at a particular cutoff date.

For a simple tracking system, this means identifying cases that were opened by the cutoff date but had not yet been closed by that point.

Nova Home had 2 pending tickets at the cutoff date.

The important issue is not merely whether backlog exists. Some cases legitimately require investigation, customer information, supplier involvement, product inspection, or another operational step.

Instead, watch how the backlog changes. If incoming ticket volume remains relatively stable but pending cases continue to increase, investigate whether the team is resolving work more slowly than it arrives. Staffing, recurring issues, escalation delays, approvals, or process bottlenecks may deserve further analysis.

3. Average First Response Time

Average First Response Time measures how long customers wait before receiving the first meaningful response to their request.

Formula:

Average First Response Time = Total First Response Time ÷ Tickets With a First Response

Nova Home had 14 tickets with a recorded first response. Together, those tickets accumulated approximately 12.05 hours before their initial responses.

Therefore:

12.05 ÷ 14 = 0.86 hours

Nova Home’s average first response time was approximately 0.86 hours, or about 52 minutes.

A lower result generally means customers are receiving an initial response faster. But this KPI does not prove that the underlying problem was solved. A business can respond in five minutes and still leave the customer waiting days for a resolution.

That is why first response time should be reviewed together with resolution time.

4. Average Resolution Time

Average Resolution Time measures how long it takes to fully resolve customer cases.

Formula:

Average Resolution Time = Total Resolution Time for Closed Cases ÷ Closed Cases

In the Nova Home example, the 13 closed cases accumulated approximately 402.92 resolution hours.

402.92 ÷ 13 = 30.99 hours

Average resolution time was approximately 31 hours.

This result becomes more useful when compared with the average first response time: Nova Home takes about 0.86 hours to provide the first response but approximately 30.99 hours to resolve a case.

That creates a useful management question: What happens between the first response and final resolution?

Possible areas to investigate include waiting for customer information, approvals, product inspection, handoffs between departments, supplier or carrier involvement, unclear ownership, or complex cases. The KPI identifies where a delay is visible; it does not prove the cause.

5. First Contact Resolution (FCR)

First Contact Resolution (FCR) measures the percentage of eligible customer issues resolved during the first interaction without requiring additional contacts.

Formula:

FCR = Cases Resolved on First Contact ÷ Eligible Cases × 100

Definitions can vary between organizations. In our Excel template, cases marked N/A are excluded from the denominator because they are not considered eligible for the calculation.

Nova Home recorded 5 cases resolved on first contact and 9 cases not resolved on first contact.

5 ÷ (5 + 9) × 100 = 35.71%

The example FCR is approximately 35.7%.

A low FCR can justify investigating missing employee knowledge, unclear procedures, insufficient authority, repeated transfers, missing customer information, or cases that inherently require follow-up.

Do not improve FCR by simply closing tickets prematurely. A higher FCR only creates value when the customer’s issue is actually resolved.

6. Customer Satisfaction Score (CSAT)

Customer Satisfaction Score (CSAT) measures how satisfied customers were with an interaction, product, service, or experience.

For this template, customers respond on a 1–5 scale, where 1 represents the lowest satisfaction level and 5 the highest. Ratings of 4 and 5 are treated as positive responses.

Formula:

CSAT = Responses Rated 4 or 5 ÷ Valid CSAT Responses × 100

Nova Home received 13 valid CSAT responses. Nine were rated 4 or 5.

9 ÷ 13 × 100 = 69.23%

The example CSAT is approximately 69.2%.

CSAT can help evaluate how customers perceive an interaction, but it does not explain why they gave that rating. If satisfaction falls, investigate the related cases and look for patterns involving reason for contact, response time, resolution time, number of contacts, channel, responsible area, and final resolution.

7. Customer Effort Score (CES)

Customer Effort Score (CES) evaluates how easy or difficult customers perceive an interaction or process to be.

CES can use different questions and scales, so the method should always be documented. Our Excel template uses a simple 1–5 ease scale, where 1 means very difficult and 5 means very easy.

Formula:

Average CES = Total CES Scores ÷ Valid Responses

Nova Home received 13 valid CES responses totaling 44 points.

44 ÷ 13 = 3.38

The average CES is 3.38 out of 5.

Because this template defines higher scores as easier experiences, a higher result represents lower customer effort. This definition must remain consistent. Do not compare your CES directly with another company unless both businesses use compatible questions, scales, and scoring direction.

CES can reveal friction that another KPI misses. A customer may ultimately be satisfied with the outcome but still have needed several contacts, repeated the same information, changed channels, or waited for multiple approvals.

8. Net Promoter Score (NPS)

Net Promoter Score (NPS) measures customers’ willingness to recommend a business.

Customers answer on a scale from 0 to 10 and are classified as:

  • Promoters: 9–10
  • Passives: 7–8
  • Detractors: 0–6

Formula:

NPS = % Promoters − % Detractors

In the Nova Home example, there are 4 Promoters, 5 Passives, and 4 Detractors from 13 valid responses.

Promoters:

4 ÷ 13 × 100 = 30.77%

Detractors:

4 ÷ 13 × 100 = 30.77%

Therefore:

30.77 − 30.77 = 0 NPS

An NPS of 0 does not mean every customer had a neutral experience. It means the percentage of Promoters and Detractors is equal in this sample.

NPS should also not be treated as interchangeable with CSAT. CSAT evaluates satisfaction with an interaction or experience, while NPS asks a broader recommendation question.

Customer Service KPI Example: Nova Home

Now we can review the complete example together.

KPINova Home resultWhat it shows
Tickets Received15Service demand during the period
Tickets Closed13Cases completed during the period
Pending at Cutoff2Unresolved workload
Average First Response0.86 hInitial response speed
Average Resolution30.99 hTime required to fully resolve cases
FCR35.71%Share of eligible cases solved on first contact
CSAT69.23%Share of satisfied responses
Average CES3.38/5Perceived ease under the template’s scale
NPS0Balance between Promoters and Detractors

The purpose of the example is not to declare these results universally good or bad. Instead, the combination tells us what deserves investigation.

For Nova Home, one important contrast is 0.86 hours to provide the first response versus 30.99 hours to resolve the case. That suggests examining what occurs after the initial response.

FCR provides another clue: 35.71% of eligible cases were resolved during the first contact. At the same time, CSAT is 69.23%, CES averages 3.38/5, and Promoters and Detractors are balanced.

None of these figures proves the cause of a problem. Together, however, they help management decide where to investigate.

How to Interpret Customer Service KPIs Together

Individual KPIs become more useful when you compare them instead of reading each result in isolation.

What you seePossible interpretationWhat to investigate
Fast first response + slow resolutionCustomers are acknowledged quickly, but solving the issue takes longerHandoffs, approvals, missing information, complex cases
Stable ticket volume + growing backlogResolution capacity may not be keeping up with demandStaffing, bottlenecks, recurring issues
High FCR + low CSATCases may be closed quickly without producing satisfactory outcomesResolution quality and premature closure
Good CSAT + low CESCustomers may like the outcome but find the process difficultRepeated contacts, transfers, unnecessary steps
Slow response + good resolutionProblems are eventually solved, but customers wait too long initiallyQueue management and staffing coverage
Rising tickets for one reasonA recurring operational problem may be generating service demandProduct, fulfillment, billing, website, or process root cause

These relationships are hypotheses, not automatic diagnoses. Growing backlog, for example, could result from insufficient capacity, unusually complex cases, or a temporary demand spike.

Use the KPI to identify where to ask the next question.

How to Set Customer Service KPI Targets

There is no universal target that every small business should copy. Response expectations differ between email, phone, messaging, social media, and in-person service. Case complexity also matters.

1. Establish a Baseline

Measure current performance before setting an improvement target. If your average first response time is 4.2 hours, that becomes the starting point for evaluating future changes.

2. Define the Service Objective

Decide what you are trying to improve. The objective could be reducing unanswered requests, controlling backlog, shortening resolution time, increasing FCR, improving satisfaction, or reducing customer effort.

3. Segment When Necessary

An overall average can hide meaningful differences. Consider reviewing results by channel, reason, responsible area, owner, customer type, or case complexity when the volume is sufficient.

For example, comparing WhatsApp response time directly with email response time may be misleading if customers have different expectations for those channels.

4. Set a Measurable Target

A useful target defines the metric, desired result, and period.

Reduce average first response time from 4.2 hours to 3.0 hours during the next quarter.

That is more actionable than simply saying “improve customer service.”

5. Review the Result and the Trade-Offs

Improving one KPI should not damage another. If first response time falls dramatically while CSAT also declines, investigate whether employees are prioritizing speed over useful responses.

The objective is not to make one number look good. It is to improve the service process.

How Often Should You Review Customer Service KPIs?

Different KPIs can require different review frequencies. Operational indicators such as incoming tickets, pending cases, first response time, and resolution time may justify more frequent monitoring when service volume is significant.

Experience measures such as CSAT, CES, and NPS often need enough survey responses before changes are meaningful.

For a small business with sufficient service activity, a simple routine could be:

  • Weekly: review workload, pending cases, response time, resolution time, and recurring problems.
  • Monthly: review FCR, CSAT, CES, NPS, trends, causes, and improvement actions.

The appropriate frequency depends on your volume and decision cycle. Avoid drawing strong conclusions from percentages based on only a few responses.

Common Customer Service KPI Mistakes

Tracking Too Many Metrics

More KPIs do not automatically create better decisions. Start with measures connected to problems the business can actually investigate and improve.

Focusing Only on Speed

A fast response does not guarantee a useful response. Review response time together with resolution, FCR, satisfaction, and effort.

Treating CSAT, CES, and NPS as the Same Metric

They answer different questions. CSAT focuses on satisfaction, CES on effort or ease, and NPS on willingness to recommend. Keep their definitions and survey scales documented.

Comparing Different Channels Without Context

Customers may expect a faster response through messaging than through email. A company-wide average can hide those differences.

Changing Definitions Between Periods

If FCR excludes certain cases in one period but includes them in another, the trend becomes less reliable. Document the numerator, denominator, scale, exclusions, and reporting period.

Treating a KPI as Proof of Cause

A KPI shows where a result changed. It does not automatically explain why it changed. Investigate cases, reasons, processes, channels, and root causes before deciding what action to take.

Reporting Without Taking Action

A KPI report should lead to a decision. A simple review can end with:

Problem → Evidence → Action → Owner → Follow-up date

Without that step, measurement can become an administrative exercise instead of a management tool.

Download the Free Customer Service KPI Excel Template

You can use the free Customer Service KPI Excel Template to apply the measurement system explained in this guide.

The workbook is designed for small businesses, ecommerce stores, service businesses, restaurants, and other organizations that need a practical customer service tracker without implementing specialized support software.

What the Template Includes

  • Instructions: explains how to enter cases, update statuses, select the reporting period, and interpret the calculations.
  • Glossary: defines the main customer service terms and KPIs used in the workbook.
  • Case Tracking: provides space for up to 200 customer cases and calculates the KPI summary automatically.

What the Template Calculates

  • Tickets Received
  • Tickets Closed
  • Pending Tickets at Cutoff
  • Average First Response Time
  • Average Resolution Time
  • First Contact Resolution
  • CSAT
  • Average CES
  • NPS

It also automatically calculates first response hours, resolution hours, and the NPS category for each case.

What You Need to Enter

For each case, you can record the Case ID, customer or order reference, opened date and time, first response, closed date and time, status, channel, reason, root cause, responsible area, owner, first-contact resolution, CSAT, CES, NPS, number of contacts, and follow-up comments.

The example data uses Nova Home Online Store, the same business used throughout this guide, so you can compare the calculations in the article with the workbook before replacing the sample cases with your own data.

Important: The template calculates time using calendar hours rather than business hours. Keep your definitions consistent when comparing periods or other reporting systems.

If you need to establish procedures, responsibilities, escalation rules, and service standards before measuring the results, use our Customer Service Manual as the operational companion to this KPI tracker.

For broader performance measurement, explore the Metrics & KPIs section. You can also use our Sales KPIs guide to measure sales performance with formulas and a practical Excel template.

Frequently Asked Questions About Customer Service KPIs

What are the most important customer service KPIs?

There is no universal set for every business. A practical starting point is to combine workload, speed, resolution, and customer perception. This may include Tickets Received, Pending Tickets, Average First Response Time, Average Resolution Time, FCR, CSAT, CES, and NPS.

What is the difference between a customer service metric and a KPI?

A customer service metric is any measurable service value. A KPI is a metric selected because it helps evaluate an important objective or supports a decision. For example, ticket volume can become a KPI when the business uses it to evaluate service demand or staffing capacity.

How do you calculate customer service KPIs?

The formula depends on the KPI. For example, FCR divides first-contact resolutions by eligible cases, CSAT divides positive responses by valid responses, average CES divides total CES scores by valid responses, and NPS subtracts the percentage of Detractors from the percentage of Promoters.

Document the definition and denominator before comparing results across periods.

What is the difference between CSAT, CES, and NPS?

CSAT measures satisfaction with an interaction or experience. CES measures how easy or difficult the experience was according to the survey scale being used. NPS measures willingness to recommend the business using a 0–10 scale. They complement one another but should not be treated as equivalent.

What is a good customer service KPI target?

There is no single target that applies to every business, channel, and type of case. Start with your current baseline, identify the service objective, segment the data when necessary, and set a measurable improvement target. External benchmarks can provide context, but they should not automatically become your internal target.

How many customer service KPIs should a small business track?

Start with enough indicators to understand workload, response, resolution, and customer perception without creating a reporting system that is difficult to maintain. Add another KPI when it answers a specific management question or supports a decision.

Can I track customer service KPIs in Excel?

Yes. Excel can be practical when the volume of customer cases is manageable and the business uses consistent definitions. The free template accompanying this guide supports up to 200 cases and automatically calculates nine summary indicators, including tickets received and closed.

As service volume and complexity grow, specialized customer service software may become more appropriate.

Sources and Methodology

The definitions and calculation methods used in this guide were reviewed against established customer service measurement resources. The Nova Home calculations correspond to the sample dataset included in the InfoExperiencia Excel template. They are provided as a worked example, not as universal customer service benchmarks.

The purpose of the measurement system is to help answer three practical questions: What changed? Where did it change? What should you investigate next?


Discover more from

Subscribe to get the latest posts sent to your email.

Scroll to Top