Ultimate Guide: How to Calculate Net Promoter Score

Some customers buy once, disappear, and never answer another email. Others come back on their own, tell friends about your store, and forgive the occasional mistake because they already trust you.

If you run a Shopify brand, you already feel that difference in your numbers. Repeat purchase behavior, referral activity, support volume, and review quality all tend to cluster around one basic question. Do customers want to recommend you?

That’s why merchants keep coming back to how to calculate net promoter score. NPS is simple enough to run in Google Sheets, but useful enough to shape retention strategy, customer support follow-up, and loyalty program design.

What Net Promoter Score Reveals About Your Customers

A Shopify store can look healthy on the surface and still have a retention problem underneath. Sales are coming in, paid campaigns are working, and review volume looks decent. Then repeat purchase rate softens, referral orders stay flat, and support complaints keep popping up after delivery. Net Promoter Score helps explain that gap because it measures willingness to recommend, which is often a better signal of future loyalty than a general satisfaction rating.

NPS uses one question on a 0 to 10 scale: how likely a customer is to recommend your brand to a friend or colleague. Responses fall into three groups. Promoters are 9 to 10. Passives are 7 to 8. Detractors are 0 to 6. The final score runs from -100 to 100.

For e-commerce teams, those buckets are more useful than the raw average. An 8 usually means the order went fine. A 10 often means the customer trusts the brand enough to buy again, leave a strong review, or join a referral or loyalty program.

What each group usually signals

• Promoters are the customers who create profitable momentum. They are more likely to post positive reviews, refer friends, redeem loyalty rewards, and purchase again without waiting for another discount code.
• Passives are satisfied but easy to lose. They may like the product, yet feel no real attachment to your store. If a competitor offers faster shipping, a better bundle, or a stronger loyalty offer, they switch.
• Detractors point to friction that revenue reports alone do not explain. In Shopify stores, that often means delayed fulfillment, product-page expectation gaps, hard-to-find support, damaged shipments, or a post-purchase experience that feels neglected.

That is why NPS is useful operationally, not just as a reporting metric.

Used well, it helps a merchant answer practical questions. Which product lines create real advocacy? Which first-order cohorts are least likely to come back? Which customers should get a service recovery email, and which should get a loyalty or referral invitation? Those are revenue questions.

A lot of brands already collect pieces of this story through review apps, support tags, return reasons, and repeat-order reports. NPS gives those signals one shared structure, so retention, CX, and lifecycle marketing can work from the same customer view. If you want a broader feedback system beyond one score, SynaBot's customer satisfaction roadmap is a useful companion because it connects surveys to operational follow-through.

NPS also has limits. It does not tell you why a customer scored you a 6 or a 10 unless you pair the score with a follow-up question and segment the results by product, channel, or order type. But for Shopify merchants, that simplicity is part of the value. It is easy to collect, easy to calculate in Excel or Google Sheets, and easy to turn into action once you connect each score group to a specific loyalty, support, or retention response.

The NPS Formula and Calculation in Practice

The formula is short:

NPS = % Promoters - % Detractors

You don’t include passives in the subtraction. They still matter operationally, but they don’t enter the formula itself.

A worked example in plain English

Say you collected 100 responses from recent customers.

• 50 customers gave you a 9 or 10, so you have 50% promoters
• 20 customers gave you a 0 to 6, so you have 20% detractors
• The remaining 30 are passives

Your calculation is:

50% - 20% = 30

Your Net Promoter Score is 30.

That example aligns with the standard method described in the verified data. It also highlights a common mistake. People often try to average all survey responses together. That is not how NPS works. A high average score can still hide too many detractors.

Excel and Google Sheets formulas that actually work

If your responses are in Column A, starting at A2, and each cell contains one score from 0 to 10, you can calculate the promoter and detractor percentages with spreadsheet formulas.

Use these formulas from Qualtrics’ NPS measurement guide:

• % Promoters =(COUNTIF(A2:A101,">=9")/COUNTA(A2:A101))*100

• % Detractors =(COUNTIF(A2:A101,"<=6")/COUNTA(A2:A101))*100

Then calculate NPS as:

• NPS =((COUNTIF(A2:A101,">=9")/COUNTA(A2:A101))*100)-((COUNTIF(A2:A101,"<=6")/COUNTA(A2:A101))*100)

You can also create helper columns if you want cleaner reporting.

Response type	Rule
Promoter	Score is 9 or 10
Passive	Score is 7 or 8
Detractor	Score is 0 to 6

What works and what doesn’t

What works is keeping the raw survey sheet simple. One row per response. One score per row. If you want to add order number, product category, acquisition source, or customer type later, do it in separate columns.

What doesn’t work is hand-counting responses every month. That creates errors fast, especially once multiple people touch the file.

A spreadsheet is enough for most brands at the start. Bad setup, not lack of software, is what usually breaks NPS reporting.

One more practical caution matters here. Qualtrics notes that small sample sizes under 400 can lead to high variance (Qualtrics on measuring NPS). That doesn’t mean you should wait forever to measure. It means you should be careful about overreacting to small shifts when only a limited set of customers has responded.

Collecting NPS Data You Can Actually Trust

A clean formula won’t save a messy survey process. Most bad NPS programs fail before the spreadsheet ever opens.

If you ask too early, customers haven’t fully experienced the product. If you ask too late, memory fades and the answer becomes vague. If you ask in a way that pressures people toward a good score, you stop measuring loyalty and start measuring politeness.

Good collection habits for e-commerce

For Shopify stores, the best survey timing usually lines up with the actual customer experience. A post-purchase email can work if you’re measuring checkout or ordering experience. A later message after delivery is often better if you want feedback on product satisfaction and fulfillment together. An on-site widget can work too, but only if it appears after enough engagement to produce a real opinion.

Three habits improve trust in the data:

• Keep the question stable: Don’t rewrite the NPS question every campaign. Consistency matters if you want to compare results over time.
• Separate scoring from incentives: Don’t offer a reward for a favorable score. You want honesty, not score inflation.
• Collect written feedback after the score: The number tells you who is at risk or ready to advocate. The follow-up comment tells you why.

A lot of customer teams are moving toward a broader, more operational feedback model. If you want another perspective on that shift, this piece on a transforming customer satisfaction approach is useful because it pushes beyond one-off surveying and into process design.

Where merchants distort their own NPS

The biggest distortion usually comes from sampling only your happiest customers. Brands often send NPS requests only to subscribers, only to recent repeat buyers, or only to customers who opened a prior email. That can be useful for a segment study, but it shouldn’t be confused with a true storewide reading.

Another common issue is survey clutter. If the email asks for an NPS score, a product review, a support rating, and a social follow in the same message, response quality drops. Keep the task narrow.

Ask one clear loyalty question first. Earn the right to ask for more detail after the customer answers.

If you need a practical framework for setting up those feedback touchpoints, Toki’s guide to collecting customer feedback effectively is worth reviewing before you launch your survey flow.

Benchmarking and Segmenting Your NPS for Deeper Insights

Two Shopify stores can both report an NPS of 42 and have completely different retention problems.

One might have strong repeat-purchase loyalty and a weak first-order experience. The other might be attracting the wrong customers through paid acquisition and losing margin on returns and support. The storewide score does not show that. Segmentation does.

As noted earlier, broad benchmark ranges can help you place your score in context. They should not drive the whole analysis. For e-commerce teams, the better question is simpler: which customer groups are creating future revenue, and which groups are dragging down repeat purchase rate, referrals, and lifetime value?

Start with the segments that affect revenue

Begin with segments you can already pull from Shopify, Klaviyo, or a simple export. Good first cuts include:

• First-time buyers vs. repeat buyers
• Paid acquisition vs. organic acquisition
• Single-product customers vs. multi-product customers
• Subscription customers vs. one-time purchasers
• High-return-rate customers vs. low-return-rate customers

These cuts usually reveal where the customer experience breaks. If paid social customers score far lower than organic customers, the problem may be ad-message mismatch, not service quality. If first-time buyers lag well behind repeat buyers, fix onboarding, shipping communication, and the first 30 days after delivery before you spend more on acquisition.

Use a simple sheet before you build a full dashboard

A lot of merchants wait too long to segment because they assume they need BI tooling. They usually do not. A clean CSV export and a pivot table in Excel or Google Sheets is enough to get useful answers.

Set up columns for Customer ID, NPS Score, Segment, Promoter, and Detractor. Then use formulas like:

=IF(B2>=9,1,0)
=IF(B2<=6,1,0)

If B2 holds the NPS score, those formulas flag promoters and detractors. From there, calculate each segment’s promoter rate and detractor rate:

=AVERAGEIFS(D:D,C:C,G2)
=AVERAGEIFS(E:E,C:C,G2)

If column C is your segment label and G2 contains a segment name like First-time buyer, those formulas return the share of promoters and detractors for that group. Then calculate segment NPS:

=(AVERAGEIFS(D:D,C:C,G2)-AVERAGEIFS(E:E,C:C,G2))*100

That is usually enough to spot where loyalty is being built and where margin is leaking.

What segmentation changes in practice

Segmented NPS gives you a clearer operating plan. A weak score from one product category points to merchandising, product education, or expectation setting. Low scores from subscription customers often point to billing friction, cadence problems, or poor perceived value after the first shipment. A gap between high-AOV and low-AOV customers can signal that your premium buyers get a better experience than everyone else.

I usually tell merchants to compare NPS alongside repeat purchase rate, refund rate, and support ticket volume. That trade-off matters. A segment can produce solid short-term revenue while still damaging retention economics.

If you want a practical framework for choosing segments that map to retention work, this guide on how to segment customers for retention and loyalty is a useful next step.

How to Improve Your NPS with a Loyalty Program

NPS becomes valuable when each score range triggers a different response. That’s where loyalty programs are useful. They give you a structured way to treat promoters, passives, and detractors differently instead of blasting everyone with the same discount.

What to do with promoters

Promoters have already signaled trust. Don’t waste that by sending them generic win-back campaigns.

Better moves include:

• Referral invitations: If someone scores you highly, ask them to recommend the brand while sentiment is fresh.
• VIP access: Early product drops, member-only perks, or premium tiers reinforce the relationship.
• Advocacy moments: Invite reviews, user-generated content, or community participation.

Promoters don’t need persuasion. They need a path to act on the enthusiasm they already have.

How to move passives upward

Passives are often the easiest revenue opportunity because they’re not upset. They’re just unconvinced.

Thoughtful loyalty design proves beneficial. A targeted points bonus tied to the second purchase, a personalized recommendation based on past orders, or exclusive educational content can add enough value to shift perception. Generic storewide coupons usually don’t do that. They train discount behavior without deepening attachment.

The fastest way to waste NPS data is to treat a passive customer like a detractor or a promoter. They need a nudge, not an apology or a celebration.

Here’s a useful walkthrough on loyalty strategy in action:

How to recover detractors

Detractors need human attention first. Loyalty points can support recovery, but they can’t replace service recovery.

Start with direct follow-up. Read their comment. Check the order history. Identify whether the issue came from product quality, shipping, packaging, communication, or support. Once the problem is understood, a make-it-right offer can help re-open the relationship. That offer might be store credit, replacement handling, a service gesture, or a customized follow-up after the issue is resolved.

The sequence matters:

1. Acknowledge the issue
2. Fix the root problem
3. Offer a reason to return
4. Measure again later

A mature loyalty program supports all three NPS groups because it creates multiple response paths instead of one blunt campaign. If you want examples of that structure inside Shopify, Toki’s overview of a Shopify loyalty program gives a good sense of the building blocks.

From Score to Strategy Your Next Steps

The practical loop is simple. Collect clean feedback. Calculate the score correctly. Segment the results so the number becomes useful. Then act on each group with the right retention play.

That’s the difference between reporting NPS and using NPS. Reporting gives you a number for a dashboard. Using it gives your team a way to improve first-purchase experience, strengthen post-purchase communication, and design better loyalty offers.

Start small if you need to. Survey one customer segment. Build the sheet. Read every comment. Look for patterns you can fix this month. The stores that get the most value from NPS don’t treat it like a quarterly formality. They treat it like a customer listening system.

---

If you want to turn customer sentiment into repeat purchases, referrals, and stronger retention, Toki gives Shopify brands the loyalty infrastructure to act on what NPS reveals. You can build programs that reward promoters, nurture passives, and support customer recovery without patching together multiple apps.