Blog · Board and management reporting · Customer service
Customer satisfaction KPIs need explicit scoring and response denominators. Calculate CSAT, survey response measures, and Net Promoter Score from exported records, then compare teams without distorting the totals.
A customer satisfaction KPI measures customers' reported experience using an explicit question, scoring rule, and denominator. Report the score with response coverage, so a high percentage cannot conceal a small or uneven responding group.
For a business scorecard, start with CSAT and a clearly labeled response measure. Add recommendation or effort questions only when they support a separate decision and have their own documented scoring rules.
CSAT fits a question about satisfaction with a particular experience. Net Promoter Score measures answers to a recommendation question. Response coverage tells you how much feedback you received from the people you invited; it is a check on participation rather than a satisfaction score.
| Measure | Decision it supports | Scoring denominator |
|---|---|---|
| CSAT | Which experiences or teams need investigation? | Valid answers to the satisfaction question |
| Net Promoter Score | How does reported willingness to recommend differ? | Valid answers to the recommendation question |
| Valid-response yield | Where is feedback coverage thin? | Delivered invitations in the defined survey program |
| Submission yield | Are invitations producing submitted surveys? | Delivered invitations in the defined survey program |
These feedback measures complement customer KPIs, which follow buying, retention, and contribution. They do not replace those business outcomes. The service leader should own the survey purpose and follow-up actions; an operations analyst should own the export checks and reproducible calculation.
Use an invitation export and a response export. The invitation file needs invitation ID, customer ID, team, interaction close date, delivery status, and survey version. The response file needs invitation ID, submission date, the satisfaction rating, and any separate recommendation rating.
Choose one eligible invitation per interaction, remove duplicate sends, and retain one valid submitted response per invitation under a stated rule. Keep team assignment as it was when the interaction closed. Otherwise, a later reassignment can move old feedback between teams.
The example is a US commercial equipment service company comparing East and West teams. It surveys eligible third-quarter interactions and accepts replies only within fourteen days after each interaction closes. The latest eligible close date, September 30, therefore has an October 14, 2026 cutoff; the export excludes later replies for every interaction. Both teams use identical wording and the same response window. The figures below are illustrative business records, not a benchmark.
For the five-point question used here, four means satisfied and five means very satisfied. The standard CSAT calculation counts those two categories as satisfied responses.
CSAT = Responses rated 4 or 5 / Valid satisfaction responses × 100
| Team | Rating 1 | Rating 2 | Rating 3 | Rating 4 | Rating 5 | Valid responses | Satisfied responses | CSAT |
|---|---|---|---|---|---|---|---|---|
| East | 3 | 4 | 5 | 18 | 30 | 60 | 48 | 80.0% |
| West | 2 | 6 | 8 | 14 | 10 | 40 | 24 | 60.0% |
| Total | 5 | 10 | 13 | 32 | 40 | 100 | 72 | 72.0% |
East's valid count is 3 + 4 + 5 + 18 + 30 = 60. Its satisfied count is 18 + 30 = 48, giving 48 / 60 = 80.0%. West's corresponding calculation is (14 + 10) / 40 = 60.0%.
The company calculation is (48 + 24) / (60 + 40) = 72.0%. The simple team average, (80.0% + 60.0%) / 2 = 70.0%, gives the smaller West response group too much weight. Displayed percentages are rounded to one decimal place after calculation.
The proof has two parts. Rating counts sum to the valid-response count, and satisfied plus other valid ratings also equals that count. At company level, 32 + 40 = 72 satisfied and 5 + 10 + 13 = 28 other valid responses; 72 + 28 = 100.
The delivery and submission records explain who contributed to the scoring table. A submitted survey may have a blank or invalid satisfaction answer, so submissions and valid answers are different counts.
Valid-response yield = Valid satisfaction responses / Delivered invitations × 100
Submission yield = Submitted surveys / Delivered invitations × 100
These are explicitly defined operational yields. Do not describe them as a standardized research response rate without the additional eligibility and outcome classifications that such a definition requires.
| Team | Delivered invitations | Submitted surveys | Blank or invalid satisfaction answers | Valid answers | Valid-response yield |
|---|---|---|---|---|---|
| East | 100 | 65 | 5 | 60 | 60.0% |
| West | 200 | 50 | 10 | 40 | 20.0% |
| Total | 300 | 115 | 15 | 100 | 33.3% |
The submission check is 115 − 15 = 100 valid answers. Company submission yield is 115 / 300 = 38.3%; valid-response yield is 100 / 300 = 33.3%. Neither denominator belongs in the CSAT formula.
West has weaker satisfaction among respondents and thinner coverage among invited interactions. That supports investigating the experience and the invitation process. It does not establish what nonrespondents would have said. Compare delivery methods, customer groups, and invitation timing before treating the team gap as a performance ranking.
The same survey contains a separate zero-to-ten recommendation question. Under the Net Promoter Score definition, ratings of nine or ten are promoters and ratings from zero through six are detractors. The remaining valid answers stay in the denominator.
NPS = (Promoters − Detractors) / Valid recommendation responses × 100
| Team | Promoters | Passives | Detractors | Valid recommendation responses | NPS |
|---|---|---|---|---|---|
| East | 30 | 10 | 10 | 50 | +40.0 |
| West | 15 | 6 | 9 | 30 | +20.0 |
| Total | 45 | 16 | 19 | 80 | +32.5 |
The total is (45 − 19) / 80 × 100 = +32.5 points. Check that 45 + 16 + 19 = 80. Its denominator differs from CSAT because some people answered only one question. Do not fill missing recommendation answers with their satisfaction rating or combine the scores into an average.
A company score can move even when each team's score stays fixed. Suppose West receives more valid answers with the same satisfied proportion, while East's response counts stay unchanged:
| Team | Valid responses in variation | Satisfied responses in variation | CSAT |
|---|---|---|---|
| East | 60 | 48 | 80.0% |
| West | 80 | 48 | 60.0% |
| Total | 140 | 96 | 68.6% |
The overall score becomes 96 / 140 = 68.6%. Neither team deteriorated; West's lower satisfaction result now has more weight. Show team counts with the total so a participation change is not mistaken for a service decline.
Use the questions a head of customer service asks to assign investigations. Keep operational causes such as queues and resolution times in the separate helpdesk KPI scorecard. The relationship between feedback and commercial results belongs in customer satisfaction and profitability.
Bring a sample of your own invitation and response exports with the rating scale, delivery status, team, and reporting dates. Covirage maps the columns; its tools compute and check the scoring and response denominators, while the external AI model explains the comparisons with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring your own files.
See Covirage for customer service for the supporting context.
For a five-point satisfaction question, a common CSAT formula is responses rated four or five divided by all valid answers to that question, multiplied by one hundred. Document the scale and the satisfied categories. Exclude blank answers from the scoring denominator.
Use your own comparable history and agreed service objectives first. A score depends on the question, survey timing, customer group, and response coverage. A higher percentage is useful only when those conditions stay sufficiently consistent to support the comparison.
No. A missing response is not a recorded dissatisfaction rating. Keep unanswered invitations in the response-coverage calculation, while calculating satisfaction from valid ratings. Report both figures so readers can distinguish weak participation from an unfavorable customer experience.
Add satisfied responses across teams and divide by their combined valid responses. Do not take a simple average of team percentages unless their valid-response counts are equal. Keep survey wording, scoring, reporting periods, and deduplication rules consistent across the combined groups.