---
title: "What NPS is and how a small business can calculate it without a CRM"
description: "NPS is the share of customers who would recommend you minus the share who wouldn't. The question, the 0-10 scale, the formula and a worked spreadsheet example"
url: "https://pochuto.com/en/posts/net-promoter-score-small-business"
published: "2026-11-10"
updated: "2026-11-10"
author: "Denys Zaiarnyi"
language: "en"
---

# What NPS is and how a small business can calculate it without a CRM

NPS (Net Promoter Score) shows how many of your customers are ready to recommend you. You ask one question, "How likely are you to recommend us to a friend or colleague?", on a scale from 0 to 10, then subtract the percentage of people who answered 0-6 from the percentage who answered 9-10. A plain spreadsheet is enough

## What NPS measures and where it came from

The metric was created by Fred Reichheld of Bain & Company in 2003. In December of that year Harvard Business Review published his article "The One Number You Need to Grow". Instead of a long satisfaction survey, he proposed asking a single question about whether a customer would recommend you

NPS doesn't measure how much a customer liked one visit. It measures whether they're willing to put their own reputation on the line and name you to a friend. For a salon, a garage or a clinic, where new customers often come on a friend's advice, that's close to what actually brings in money

> **Note:** Net Promoter and NPS are registered trademarks, and Net Promoter Score is a service mark, of Bain & Company, NICE Systems and Fred Reichheld

## The NPS formula

Every answer from 0 to 10 falls into one of three groups. You don't calculate an average here, you calculate the shares of the groups

| Score | Group | What it means |
| --- | --- | --- |
| 9-10 | Promoters | Loyal, enthusiastic fans who praise you to friends and colleagues |
| 7-8 | Passives | Satisfied for now, but could leave |
| 0-6 | Detractors | Unhappy customers |

Formula: NPS = % promoters - % detractors. Passives don't appear in the formula, but they count toward the total number of answers. The result ranges from -100 (all detractors) to +100 (all promoters)

## A worked example for a salon with 40 answers

Say 40 customers answered in a month: 22 gave 9 or 10, 10 gave 7 or 8, and 8 gave 0 to 6. Promoters are 22 of 40, or 55%. Detractors are 8 of 40, or 20%. NPS = 55 - 20 = 35

Note that the average of the same answers can look like "all good", while NPS shows plainly that one customer in five is a detractor

## How to track NPS without a CRM or paid tools

1. Create a Google Form with one required 0-10 question and one optional text field: "What could we do better?"
2. Send the link to every customer after a visit, the same way each time, in the channel you already use with them: text message, email or a messaging app
3. The form collects answers into a Google Sheet. Add three cells: the count of 9-10 answers, the count of 0-6 answers and the total
4. Calculate NPS once a month or once a quarter, not after every answer: with only a few answers the number jumps around by chance

In a Google Sheet it takes one row: COUNTIF counts answers in a range, and NPS is the difference between the two shares multiplied by 100. You don't need a separate calculator or a CRM

> **Warning:** Don't send the NPS question only to customers you think are happy. A selective survey gives a nice number that means nothing: you measure the mood of your friends, not your customers

## What counts as a good NPS

Any number above zero means you have more promoters than detractors. But there is no single benchmark: the score depends on the industry, the country and how exactly you ask. Comparing your NPS with a figure from someone else's article tells you very little

For a small business it's more useful to compare yourself with yourself: this quarter against the last one, one stylist against another with a similar number of answers, one location against another. A drop of 10-15 points is a reason to reread the detractors' comments, not to look for a "good benchmark"

## How NPS differs from a Google rating and review

|  | NPS | Google stars |
| --- | --- | --- |
| Scale | 0 to 10 | 1 to 5 |
| Question | Would you recommend us? | How was your experience? |
| Who sees it | Only you | Anyone who finds you on Maps |
| Purpose | An internal loyalty gauge | A new customer's decision whether to come |

You can't convert one scale into the other: a 9 in NPS and four stars on Google answer different questions. And don't ask for a Google review only from people who gave 9-10: Google's policy prohibits selectively soliciting positive reviews. See [review gating](https://pochuto.com/en/posts/review-gating) for why

Pochuto doesn't calculate NPS. Its review page asks the customer for a 1-5 star rating: a high one leads to the Google review form, a low one first opens a form for the owner, and the Google link stays visible by default at any rating. It's a tool for public reviews, while NPS is a separate internal metric best kept in your own spreadsheet

**A free first step**

**See how your profile looks to a customer right now**

Your rating, review count and how many five-star reviews it takes to reach the next tenth - in 30 seconds, no sign-up

[Check your profile for free](https://pochuto.com/en/audit) · [Make a review link and QR code](https://pochuto.com/en/tools/review-link)

## FAQ about NPS

### How many answers do I need for NPS to make sense?

The more, the steadier the number. With 10-15 answers a single customer moves NPS by 7-10 points, so a small business is better off collecting answers over a month or a quarter and watching the trend, not one value

### Can I ask the NPS question out loud at the counter?

You can, but the answers will be inflated: people feel awkward giving a low score to the person who just served them. An anonymous form via a link gives a more honest number

### Can NPS be negative?

Yes. If there are more detractors than promoters, NPS is below zero. The lowest possible value is -100, when everyone answered 0 to 6

### Why don't passive scores of 7-8 count in the formula?

They're neither added nor subtracted, but they count toward the total and so reduce the shares of both other groups. Bain calls this group "passively satisfied": happy for now, so they count neither for nor against

## Sources

Checked on 2026-11-10. The question, group boundaries and formula come from Bain & Company's Net Promoter System site, and the ban on selectively soliciting positive reviews comes from Google's user-generated content policy

- [Bain & Company: Measuring Your Net Promoter Score](https://www.netpromotersystem.com/about/measuring-your-net-promoter-score/)
- [Bain & Company: About the Net Promoter System](https://www.netpromotersystem.com/about/)
- [Harvard Business Review: The One Number You Need to Grow (2003)](https://hbr.org/2003/12/the-one-number-you-need-to-grow)
- [Google Maps user-generated content policy](https://support.google.com/contributionpolicy/answer/7400114)

## Related

- [CSAT or NPS survey vs a Google review](https://pochuto.com/en/posts/csat-nps-survey-vs-google-review)
- [Review gating: why filtering out negative reviews is risky](https://pochuto.com/en/posts/review-gating)
- [Rating-based review routing and how to check it isn't gating](https://pochuto.com/en/posts/rating-based-review-routing)
