As of 13 August 2026, AI can create an NPS report for your small business.

What to actually do

1. Hand it to a person

   The route this page recommends

   A person who owns the outcome does this end to end, worth it when the failure is dear.

2. Do it yourself

   Second choice

   A chat interface, chat-fluent skill, and roughly 30 minutes until you can act on the result.

   How to actually do it

   1. Open the spreadsheet or survey platform export containing one row per response, remove names and contact details, and keep the NPS score, response identifier and any useful customer segment.
   2. Confirm the exact NPS question, survey period, response count and definitions of any segments, then write these in a short context note.
   3. Paste the context note and the cleaned response table into a chatbot with the prompt above, or upload the CSV if the chatbot supports file analysis.
   4. Ask the chatbot to produce the report and to flag duplicated, missing or ambiguous rows instead of filling them in.
   5. Open a spreadsheet and independently count scores from 0 to 6, 7 to 8 and 9 to 10, then calculate each percentage and subtract the detractor percentage from the promoter percentage.
   6. Compare the spreadsheet calculation, response count and segment totals with the drafted report, and trace each stated finding back to the supplied responses or comments.
   7. Remove any unsupported claims and anonymise quoted comments, then send the checked report to the people who need it for the relevant customer-service actions.

   Prompt

   Create an NPS report for my small business using the survey data and context below.
   
   Survey question: [paste the exact NPS question]
   Survey period: [insert period]
   Number of responses: [insert number, or calculate it only from the supplied rows]
   Customer segments to compare: [list segments, or say none]
   Business context: [paste relevant product, service, pricing or operational context]
   Survey data:
   [paste a table or upload a CSV with one row per response]
   
   Use the standard NPS method: scores of 9 and 10 are promoters, scores of 7 and 8 are passives, and scores of 0 to 6 are detractors. Calculate NPS as the percentage of promoters minus the percentage of detractors, using all valid responses. Do not invent missing responses, dates, segments, reasons or business context. State how many valid responses were used and show the promoter, passive and detractor counts and percentages. If the data is incomplete, duplicated or ambiguous, list the problem instead of guessing.
   
   Produce:
   1. An executive summary in plain British English.
   2. A calculation table that makes the NPS result reproducible.
   3. Segment comparisons only where the segment is present in the data.
   4. The main themes from any open-text comments, with representative comments labelled as excerpts rather than presented as statistically representative.
   5. Three practical actions linked to the evidence, separating observed findings from recommendations.
   6. A short limitations section covering sample size, response bias, missing data and any uncertainty.
   7. A final list of every figure and claim that I should check against the original survey export before sharing the report.
   
   Do not claim that the result represents all customers unless the supplied data supports that conclusion. Do not expose names, email addresses or other unnecessary personal data in the report.

   Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.

3. Use a tool built for this

   The distant third