
How it works
- 03 Customers: list your customers with revenue, class and potential. Select the customers for the survey and enter the contacts you invite per role.
- 04 Questionnaire: write your own questions for the eight criteria in 02 Setup, decide what you use and check the time to answer.
- 05 Responses: enter one row per answered questionnaire. Leave a rating empty when the contact chose no experience.
- 06 Results: response rate, overall satisfaction, recommendation score with its rough range, the eight criteria and the chart of importance and satisfaction.
- 07 Status: one page for the report. Agree actions with owner and date and tell the customers what you will do.
Definitions used in the workbook
- Rating: 1 very dissatisfied, 2 dissatisfied, 3 neither, 4 satisfied, 5 very satisfied.
- Recommendation score: Question from 0 to 10. Share of answers 9 and 10 (recommenders) minus share of answers 0 to 6 (critics), in points from -100 to +100.
- Rough range: About two standard errors of the score. With 50 answers it is close to 20 points in each direction.
- Named in top three: Share of answers that chose the criterion as one of the three most important. The average is 37.5 percent when everybody names three of eight.
Sheets in the workbook
- Start
- Setup
- Customers
- Questionnaire
- Responses
- Results
- Status
Who it is for
Sales, quality and operations managers who run their first structured customer survey.
The method behind the numbers
This workbook is part of the Customer Satisfaction Measurement toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.