How To Calculate NPS For Small Business Surveys
To learn how to calculate NPS, subtract the percentage of Detractors from the percentage of Promoters after asking the standard 0–10 recommendation question. Promoters are 9–10 responses, Passives are 7–8 responses, and Detractors are 0–6 responses; the final score ranges from -100 to +100 and is not written as a percentage.
> Net Promoter Score is a customer loyalty score calculated as % Promoters minus % Detractors from responses to the standard 0–10 recommendation question.
- The NPS formula is: NPS = % Promoters - % Detractors.
- Passives count in the total response base, but they are not added or subtracted in the final formula.
- Small businesses should pair the score with follow-up comments, customer records, and trend tracking instead of treating one score as the whole customer story.
Net Promoter Score Definition And NPS Formula
Net Promoter Score is calculated from one standard question: “How likely are you to recommend us to a friend or colleague?” Customers answer on a 0–10 scale, then each answer is sorted into one of three groups. This 0–10 recommendation-question method is the standard Net Promoter Score approach described by Bain & Company and NICE Satmetrix source.
Promoters are 9–10 responses. Passives are 7–8 responses. Detractors are 0–6 responses. The NPS formula is:
NPS = % Promoters - % Detractors
The result is a score from -100 to +100, not a percentage. Write “NPS of 30,” not “30% NPS.”
In a shop or restaurant, this usually starts with a receipt link printed below the total. Customer Feedback Surveys is a customer feedback survey app that collects post-purchase surveys, NPS scores, and review follow-ups for small businesses.
How The NPS Calculation Works Behind The Score
NPS works by grouping individual 0–10 answers into behavioral categories, not by averaging every rating. That is why a business with many 7s and 8s can feel “fine” but still have a modest NPS.
Passives stay in the denominator because they are real responses. However, they are not added or subtracted because NPS is meant to show the balance between enthusiastic advocates and unhappy customers. The mechanism is simple cohort classification: each response joins a group, then grouped percentages are compared.
The dashboard can look calm until one 3 appears.
Companies widely use NPS to measure loyalty and customer experience. In a 2020 McKinsey global survey, 57% of companies reported using Net Promoter Score for customer experience or loyalty measurement source. For small businesses, the score is clearest when checked as a trend, not as a one-day mood reading.
How To Calculate NPS Step By Step
How do you calculate NPS? Ask the 0–10 recommendation question, count each response group, convert Promoters and Detractors into percentages of total responses, then subtract Detractors from Promoters.
- Ask the standard 0–10 recommend question.
- Count total responses before doing any percentage math.
- Sort 9–10 as Promoters, 7–8 as Passives, and 0–6 as Detractors.
- Divide Promoters and Detractors by total responses.
- Subtract % Detractors from % Promoters.
- Round consistently and report the result as a score.
1. Ask The 0–10 Recommend Question
Use the same wording each time so weekly results compare cleanly.
2. Sort Responses Into NPS Groups
Do this before reading comments, especially after a tense support ticket.
3. Convert Counts Into Percentages
Use the total response count as the base for both percentages.
4. Subtract Detractors From Promoters
The net promoter score calculation ends with subtraction, not averaging.
NPS Calculation Example For A Small Business Survey
Here is a small-sample NPS calculation you can copy into a weekly spreadsheet tab. Say a local store receives 20 post-purchase survey responses after a Saturday sale.
The responses break down like this:
- 10 Promoters
- 6 Passives
- 4 Detractors
- 20 total responses
Calculate Promoters first: 10 / 20 = 50% Promoters. Then calculate Detractors: 4 / 20 = 20% Detractors. Apply the NPS formula: 50 - 20 = NPS of 30.
The 6 Passives still matter because they are part of the 20 total responses. They just do not enter the final subtraction. On a small response base, one extra Detractor can move the score sharply, so avoid changing staffing or pricing after a single thin week.
Five NPS Formula Facts Small Businesses Must Know
- NPS uses the 0–10 recommend question, not star ratings. A 5-star review form may help reputation work, but it is not the official NPS method.
- Promoters are 9–10, Passives are 7–8, and Detractors are 0–6. Keep these cutoffs fixed so reports stay comparable.
- The NPS formula is % Promoters - % Detractors. Passives are included in the total response base only.
- The result is a score from -100 to +100, not a percent. A score of 42 should be written as “NPS of 42.”
- NPS is most useful when paired with comments and follow-up actions. A 6 with a clear complaint is more useful than a silent 8.
A Journal of Service Research study reported that Promoters showed higher repurchase intention and referral likelihood than Passives and Detractors on the standard NPS scale source.
NPS Formula Versus Average Rating Calculation
NPS is different from an average rating because it groups customers first, then subtracts percentages. An average can look high while NPS is lower if many customers are neutral rather than enthusiastic.
| Metric | Usual question style | Calculation | What it tells you |
|---|---|---|---|
| NPS | 0–10 recommend question | % Promoters - % Detractors | Loyalty and referral intent |
| Average 0–10 rating | Any 0–10 rating | Sum ÷ responses | General score level |
| 5-star rating | 1–5 stars | Average stars | Public review-style satisfaction |
| CSAT | Satisfaction question | % satisfied or average | Recent satisfaction |
| Yes/no recommendation | Would recommend? | % yes | Basic intent, not official NPS |
A 5-point scale cannot be converted into official NPS without changing the method. Official net promoter score calculation requires the 0–10 question and grouped percentages. For satisfaction comparisons, the NPS vs CSAT distinction is worth keeping separate.
Common Myths About How To Calculate NPS
Myth 1: NPS is the average of all 0–10 responses. The correct rule is to group responses into Promoters, Passives, and Detractors, then subtract percentages.
Myth 2: Passives should be added to Promoters. Passives count in the total response base, but they are not added to either side of the formula.
Myth 3: NPS should be reported as 70%. NPS uses percentages in the math, but the final result is a score.
Myth 4: Any satisfaction question can produce an NPS. Official NPS requires the standard 0–10 recommendation question.
Myth 5: One strong score proves customer experience is healthy. A loyal customer frowning at empty shelves can still leave a 9 if staff handled it well. Use the score with comments, trends, and follow-up records.
NPS Calculation Use Cases For Customer Feedback Surveys
NPS works best for moments where recommendation intent makes sense: post-purchase surveys, post-service surveys, repeat customer check-ins, and subscription renewal feedback. It is weaker for product feature scoring, one-off complaint forms, employee satisfaction, and generic star review capture.
For small businesses, NPS usually works best as a trend metric rather than a one-time verdict because repeat measurement shows whether changes are helping. A weekly tab with NPS scores, customer quotes, and one assigned follow-up is often enough to turn feedback into a next step.
Tools like Customer Feedback Surveys, SurveyMonkey, Typeform, and Google Forms can collect the score, but the useful habit is connecting responses to order IDs or customer records. A good customer feedback survey app for small businesses should collect post-purchase surveys, NPS scores, and actionable customer insights, not bury the owner in enterprise research workflows.
McKinsey has reported that better customer journeys can raise customer satisfaction, improve revenue, and reduce service costs when teams act on the feedback instead of only tracking scores source. That makes the benefits of NPS for small business easier to explain when the score is tied to recovery work.
Limitations
NPS is useful, but it is easy to overread. Treat it as a signal that guides follow-up, not as a replacement for customer conversations.
- NPS does not explain why customers gave a score unless you ask a follow-up question.
- Low response counts can make small-business NPS volatile from week to week.
- Referral likelihood may miss price, usability, delivery, or support issues.
- Benchmarks vary by industry, culture, location, and customer expectation.
- Surveying only happy customers can inflate the score and hide service problems.
- Staff pressure to ask for 9s and 10s can game the metric.
- A one-star public review and a private Detractor comment need different recovery steps.
- NPS should not replace direct owner judgment, especially when the same complaint appears twice.
Sometimes the comment matters more than the number.
If you are choosing collection channels, compare email, SMS, and in-store QR flows before picking a best NPS survey app.
FAQ
What is the NPS formula?
The NPS formula is NPS = % Promoters - % Detractors. Promoters are 9–10 responses, and Detractors are 0–6 responses.
Is NPS a percentage?
NPS uses percentages during the calculation, but the final result is reported as a score. Write “NPS of 40,” not “40% NPS.”
Do Passives count in NPS?
Yes, Passives count in the total number of responses. They are not added or subtracted in the final formula.
What is a good NPS score?
A good NPS score depends on industry, customer expectations, and whether your trend is improving. For a small business, direction over time is often more useful than one benchmark.
Can I calculate NPS from a five-star rating?
No, a five-star rating is not the official NPS method. NPS requires the standard 0–10 recommendation question.
How do you calculate NPS in Excel?
Count 9–10 responses as Promoters and 0–6 responses as Detractors, then divide each count by total responses. Subtract the Detractor percentage from the Promoter percentage.
How many NPS responses are enough?
More responses reduce volatility and make the score more reliable. Small samples can still be useful, but they should be treated cautiously. For example, if you have only 20 responses, one additional Detractor changes the score by 5 points. That makes small-business NPS useful for spotting patterns, but risky as a stand-alone weekly verdict.
Why is NPS not an average?
NPS is not an average because it groups customers into Promoters, Passives, and Detractors. The calculation subtracts grouped percentages instead of averaging all 0–10 scores.