A customer satisfaction score on its own changes nothing. What changes things is knowing which customers are unhappy and why, replying to them quickly, and fixing the cause. This free kit gives you the surveys, the maths and the follow-up, ready to use today.
What's in the customer satisfaction and NPS kit
- Survey templates (Word and PDF): Net Promoter Score (NPS), customer satisfaction (CSAT) and customer effort (CES), one page each. Print them or copy the questions into any form tool.
- NPS, CSAT and CES calculator (Excel): enter responses and it calculates all three scores, a 12-month trend, results by location or channel, the themes behind them, and a follow-up list of unhappy customers who agreed to be contacted.
- Follow-up templates (Word and PDF): replies for detractors, passives and promoters, a "You said, we did" update and a simple close-the-loop routine.
- Guide (PDF): which metric to use when, formulas with worked examples, survey rules and common mistakes.
- Free kit
Customer satisfaction and NPS kit
Measure NPS, CSAT and customer effort, see the trend, and reply to unhappy customers before they leave a review.
- NPS, CSAT and CES survey templates
- Calculator: scores, 12-month trend, by location, themes, follow-up list
- Follow-up templates for detractors, passives and promoters
- Guide: which metric when, formulas with worked examples
WordExcelPDF
NPS, CSAT or CES?
- NPS asks "How likely are you to recommend us to a friend?" (0 to 10). It measures overall loyalty. Ask every 3 to 6 months, or within a week of a purchase.
- CSAT asks "How satisfied are you with your visit / order / service?" (1 to 5). It measures one interaction. Ask straight after it.
- CES asks whether you made it easy to get something done (1 to 7). Use it after support requests, returns and bookings.
Starting out? Use CSAT after visits or orders and NPS once a quarter.
How to calculate NPS (with an example)
NPS = % of promoters (9 or 10) minus % of detractors (0 to 6). Passives (7 or 8) count in the total but not in the score.
Example: 200 answers, 110 promoters (55%), 60 passives (30%) and 30 detractors (15%). NPS = 55 - 15 = +40. The score can range from -100 to +100.
CSAT is the % of answers that are 4 or 5: if 60 of 80 people choose 4 or 5, CSAT is 75%. CES is the average of all answers; higher means easier.
Survey rules that keep the numbers honest
- Ask everyone, not just the customers who seem happy.
- Keep it short: one score question plus "Why?" beats 15 questions.
- Never ask for a high score, and don't tie staff bonuses to NPS.
- Below 30 answers, treat a score as a signal, not a fact.
Close the loop
- Reply to every detractor within 2 working days, from a named person. The calculator flags who needs a reply.
- Ask passives one question: "What would make it a 10?"
- Thank promoters, then ask for a review.
- Fix one root cause a month: the theme with the most detractors.
- Tell customers what changed with a monthly "You said, we did" update.
Collecting feedback by QR code? Eucarl gives customers an anonymous feedback page, sorts what comes in, and lets you reply privately, even to people who didn't leave their name. Browse all our free templates and kits.
