Learn how to measure Complaint Rate % month by month so you can spot when rising job volume starts affecting the customer experience. In this lesson, you’ll build a clear visual that helps you monitor service quality, compare results against a target, and identify when operational pressure may be driving more complaints.
Download the Excel file used in this tutorial:
Start by adding a month field based on the service date.
Use the EOMONTH function so every job is assigned to the last day of its month.
This gives you a clean monthly grouping field that can be used for reporting and charting.
Once the month field is ready, create a monthly summary table.
This becomes the month list for the KPI table.
Next, build out the columns you need in the reporting section:
This gives you the structure needed to calculate the KPI and build the chart.
To calculate total jobs each month:
Because each row represents one job, counting the month entries gives you total jobs for that month.
To calculate complaints for each month:
Since the complaint flag is binary, the video notes that you could also use COUNTIFS, but SUMIFS is used to show a different approach.
This gives you the monthly complaint total.
Once jobs and complaints are calculated:
This creates the monthly Complaint Rate % line used in the chart.
Create a target value above the monthly target column, such as 3.5%, and then reference that value down the entire target column.
This makes the target dynamic, so you can change one cell and update the full chart instantly.
This is helpful for sensitivity analysis or for testing different performance thresholds.
For the visual, the video uses:
The number of complaints is not included in the chart because the percentage is the more useful KPI.
Jobs are included to show workload volume, while the percentage normalizes complaint activity across months.
To create the chart:
Then assign the chart types as follows:
Set the percentage-based series to the secondary axis so the KPI is displayed correctly as a percentage.
To clean up the chart:
This helps simplify the display and makes the KPI easier to read.
The video then improves the chart formatting so the KPI stands out more clearly.
Recommended visual adjustments include:
This makes the complaint rate the main focus while still showing job volume in the background.
The video shows that labeling every point can make the chart feel cluttered.
Instead, you can:
This keeps the chart easier to interpret without overwhelming the user.
Add a clear chart title and make small layout adjustments so the dashboard looks polished and presentation-ready.
At this point, the chart shows:
That gives you a clear monthly view of customer complaints relative to workload, with a target benchmark you can update at any time.
Q1. What is Complaint Rate %?
Complaint Rate % measures the percentage of completed jobs that resulted in a customer complaint during a given period. It’s an important customer success KPI because it helps you understand how service quality is holding up as job volume changes.
Q2. Why is Complaint Rate % better than just tracking the number of complaints?
The total number of complaints by itself can be misleading. A higher complaint count may simply reflect a busier month. Complaint Rate % gives better context by comparing complaints to total jobs, making it easier to evaluate customer experience fairly over time.
Q3. How can Complaint Rate % help improve customer satisfaction?
Tracking this KPI month by month helps you identify when operational stress starts affecting service quality. If complaint rates rise during busy periods, you can use that insight to improve scheduling, technician support, dispatch planning, or follow-up processes.
Q4. What should be included in the data for this KPI?
At a minimum, you need a service date and a complaint flag for each completed job. If you collect additional details like technician, customer type, service category, or acquisition channel, you can break down complaint trends further and find the root causes faster.
Q5. Why should I compare Complaint Rate % to a target?
A target line makes it easier to see whether performance is staying within an acceptable range. This helps managers quickly identify when complaint levels are moving too high and when corrective action may be needed.
Q6. Can this KPI be analyzed by technician or customer segment?
Yes. Once your data is structured properly, you can analyze Complaint Rate % by technician, service type, customer segment, or job source. This gives you deeper insight into where customer experience issues are happening and which areas need the most attention.