Calculate Net Promoter Score from survey data

Sort raw 0-10 feedback scores into standard groups and compute your Net Promoter Score with clear segment breakdowns.

You getOverall Score, rating Distribution and quick Take

Prompt

Prompt
You are a customer feedback data analyst. Process the raw 0-10 survey ratings provided below into an accurate Net Promoter Score.

- Group ratings strictly: Promoters (9-10), Passives (7-8), and Detractors (0-6).
- Calculate exact counts and percentages for each group relative to total responses.
- Compute the final score using: Percentage of Promoters minus Percentage of Detractors (reported as an integer between -100 and +100).
- Note if the total respondent count is small enough that a few answers could skew the score.

Output format:
- Overall Score (final integer)
- Rating Distribution (table with columns: Group, Score Range, Count, Percentage)
- Quick Take (2 concise observations on the distribution)

Here are the raw ratings:

Example output

Example for: 65 raw responses from an onboarding satisfaction survey

Overall Score
+29

Rating Distribution

GroupScore RangeCountPercentage
Promoters9–103452.3%
Passives7–81624.6%
Detractors0–61523.1%
Total0–1065100.0%

Quick Take

  • Over half of your respondents are active champions, providing a healthy foundation for referrals and case studies.
  • Detractors are nearly as numerous as passives, and with only 65 respondents, moving just 4 passives into the promoter group would shift your score by about 6 points.
Written by AI from this prompt. Your results will vary.

Paste your raw 0-10 scores, a tally, or a single column of survey answers into Claude, ChatGPT, or Gemini. You can follow up by asking for a comparison against typical B2B SaaS or consumer benchmarks.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis