Customer Complaints by the Numbers: Intake Rates, Reason Codes, Reply & Resolution Times, Ageing, Escalations, Goodwill Costs, Root Causes, Repeat Complaints & a Complaints Dashboard
Work through 20 hands-on labs at a fictional home and garden retailer – measure complaint intake per 1,000 orders, sort categories and reasons, check first replies and working days to resolve, age the open cases, track escalations, outcomes and goodwill, rank root causes, catch repeat complaints, size team capacity and the cost of poor service, set fix priorities and build a complaints dashboard – with every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
In 20 hands-on spreadsheet labs you analyse the customer complaints of a fictional home and garden retailer. You turn weekly intake into rates per 1,000 orders, sort complaints by category and reason, check first replies against channel targets and count resolution times in working days with median and p90. You age the open cases on a fixed date, measure escalation rates, outcomes and goodwill per complaint, rank root causes with a cumulative share and catch repeat complaints with COUNTIFS. Then you plan team capacity, add up the cost of poor service, set fix priorities with payback months, compare before and after a process fix and build a complaints dashboard with a status rule.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Complaints at a Glance: Which Category Is Slowest?Free
- Complaint Intake: Weekly Channels and Rate per 1,000 Orders Locked
- Categorising Complaints: Categories, Reasons & Shares Locked
- First Reply: Acknowledgement Time vs the Target Locked
- Resolution Time in Working Days: Median and p90 Locked
- Ageing of Open Complaints: Buckets on an As-of Date Locked
- Stage Times: Receive, Assign, Investigate, Respond Locked
- Escalations: Level Shares and Rate by Category Locked
- Outcomes: Upheld, Partly Upheld or Not Upheld Locked
- Goodwill: Refunds, Vouchers, Replacements & Cost per Complaint Locked
- Root Causes: Cause Codes, Cumulative Share & a Ranked Chart Locked
- Repeat Complaints and Reopened Cases Locked
- Team Workload: In vs Out and the Backlog Trend Locked
- Capacity: Handling Minutes to Hours Needed vs Available Locked
- Satisfaction After Resolution: Scores and Response Rate Locked
- Cost of Poor Service: Handling, Goodwill & Lost Orders Locked
- Fix Priorities: Frequency × Cost and Expected Saving Locked
- Before and After a Process Fix: Complaints per 1,000 Orders Locked
- Monthly Trend: Rate per 1,000 Orders, Within Target & Days Locked
- Final Project: The Complaints Dashboard Locked
Learner reviews
Be the first to review this course.