How to find at risk customers who had a service problem
The short answer
A service problem can turn a slowing customer into a likely loss, so at risk customers with a recent complaint deserve the first recovery effort. Combine a churn-risk flag, such as being past 1.5 times their usual purchase gap, with a service case in the last six months, then value the list by each customer's expected 12-month spend.
Why it matters
Customers who had a bad experience and are already slowing down are the least likely to return without a nudge. Putting a dollar value on them helps the service team decide who gets a call, who gets a credit and how much recovery is worth spending.
The question to ask
Copy this into Lexi as written.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a pet retailer with 240,000 active customers. It finds customers past 1.5 times their usual purchase gap who had a service case in the last six months.
- Includes cases such as a late autoship delivery or a faulty product.
- Excludes open cases and customers who bought again after the case closed.
- Result: 3,900 customers who averaged $620 a year.
What the data shows
About $2.4 million in annual revenue sits with customers who went quiet after a service problem.
What it means
These customers left for a reason the business can name, which makes them easier to win back than most lapsed customers.
What to do
Call the 480 who spent over $1,500, and send the rest an apology with a credit toward their usual food order.
Would you like me to push the apology group to Klaviyo?
Frequently asked questions
How do I measure customer service impact on churn?
Compare churn for customers who logged a service case with similar customers who did not, matched on spend, tenure and purchase gap. Measure both groups over the six months after the case. The difference is the churn your service problems cause, and it puts a dollar figure on fixing them.
Is a complaint itself a churn signal?
Not always. A complaint that gets resolved may leave a customer as loyal as before. It becomes a churn signal when behavior changes afterward, such as a longer gap since the last purchase or smaller orders. Combine the two signals, which keeps recovery spend on customers who are actually drifting away.
What is saving an at risk customer worth?
Estimate it as the customer's expected spend over the next 12 months if they stay, multiplied by your gross margin rate. Use their own spend in the year before the problem as the starting point. Compare that figure with the cost of the call, credit or replacement to set a sensible recovery budget.