Skip to content
Shop | Excel tracker

Customer Survey Workbook

Customer list with classes and selection, a questionnaire builder with a time check, response entry for one wave, results with low ratings, importance and the importance and satisfaction chart, and a one page status.

Screenshot of the Customer Survey Workbook workbook with example data
Example data from the workbook.

How it works

  1. 03 Customers: list your customers with revenue, class and potential. Select the customers for the survey and enter the contacts you invite per role.
  2. 04 Questionnaire: write your own questions for the eight criteria in 02 Setup, decide what you use and check the time to answer.
  3. 05 Responses: enter one row per answered questionnaire. Leave a rating empty when the contact chose no experience.
  4. 06 Results: response rate, overall satisfaction, recommendation score with its rough range, the eight criteria and the chart of importance and satisfaction.
  5. 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

  1. Start
  2. Setup
  3. Customers
  4. Questionnaire
  5. Responses
  6. Results
  7. 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.

Newsletter

One Lean idea.
Every two weeks.