Skip to content
Shop | Excel system

Customer Satisfaction Measurement System

Customers and contacts, questionnaire, responses of all waves, results with drivers, segments and spread, accounts at risk, on-time delivery and complaint data, customer scorecards, actions with feedback, wave comparison, audit and status.

Screenshot of the Customer Satisfaction Measurement System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: wave, limits and lists. 03 Customers: classes, selection and contacts. 04 Questionnaire: your questions and the time check.
  2. 05 Responses: one row per answer, all waves in one list. 06 Results: criteria, drivers and the chart of importance and satisfaction.
  3. 07 Segments: results by class and role with a warning for small groups, and the spread of the ratings. 08 Accounts: every customer with answers, critics and status.
  4. 09 Hard Data: on-time delivery, complaint rate and first response per month. 10 Scorecards: how your customers rate you in their own supplier evaluation.
  5. 11 Actions: every action with source, owner, date, status and feedback to the customer.
  6. 12 Waves: the trend over the waves. 13 Audit once a year. 14 Status for the report to the management.

Definitions used in the workbook

  • Recommendation score: Share of answers 9 and 10 (recommenders) minus share of answers 0 to 6 (critics) on the 0 to 10 question, in points from -100 to +100.
  • Rough range: About two standard errors of the score. A change between two waves is clear when it is larger than the combined range of both waves.
  • Driver: Correlation between the rating of a criterion and overall satisfaction, from -1 to 1. A high value means: who is unhappy here is unhappy overall.
  • Account at risk: A customer with at least one critic among its contacts in the wave.

Sheets in the workbook

  1. Start
  2. Setup
  3. Customers
  4. Questionnaire
  5. Responses
  6. Results
  7. Segments
  8. Accounts
  9. Hard Data
  10. Scorecards
  11. Actions
  12. Waves
  13. Audit
  14. Status

Who it is for

Managers who run customer satisfaction as a yearly measurement and report it to the management.

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.