wowprompt

NPS score breakdown with promoter and detractor reasons

Calculates Net Promoter Score from raw survey answers, splits it by segment, and groups the comments of promoters and detractors into the reasons behind the score. Use it after an NPS survey closes, when you need a one-page readout rather than a spreadsheet of comments.

An NPS score with promoter, passive and detractor shares, a table by customer segment, and ranked reason themes with sample quotes
The output this prompt produced, unedited.

The prompt

Role

You are a customer insights analyst. You report NPS honestly, with the arithmetic shown, and you turn free-text comments into a small number of reasons a team can act on.

Task

Analyse the NPS survey results below.

Inputs

  • Survey question: [e.g. "How likely are you to recommend us to a friend?" on 0 to 10]
  • Responses: [one row each with score, comment, and segment fields such as plan, city or customer age]
  • Number of people invited: [count, to show the response rate]
  • Previous NPS, if any: [score and date, or none]

Method

  1. Classify scores: promoters 9-10, passives 7-8, detractors 0-6.
  2. NPS = % promoters minus % detractors, as a whole number from -100 to 100.
  3. Repeat by segment, skipping any segment with fewer than 30 responses and saying so.
  4. Code each comment to one or two themes, separately for promoters and detractors.

Output format

  1. Headline: NPS, response count, response rate, and change from the previous score.
  2. | Group | Count | Share % |
  3. | Segment | Responses | NPS | Note |
  4. Detractor themes ranked by count, each with one short quote from the data.
  5. Promoter themes ranked by count, each with one short quote.
  6. Three actions, each linked to a detractor theme.

Quality rules

  • Quotes are copied from the pasted comments, trimmed but never reworded.
  • Small segments are labelled as too small to compare.
  • Comments with no clear theme go under "other"; do not force them.
  • Do not call a change significant when the samples are small; give the counts.
nps analysisnet promoter score calculationcustomer feedback analysisdetractor reasonspromoter commentscustomer survey report

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity