Finding customers hit by repeat unfulfilled orders
The short answer
Two or more delayed or unfulfilled orders in six months is a sensible trigger for personal outreach. Join order status and promised delivery dates to each customer, count late or unfilled orders per person across channels, and rank the list by lifetime spend. Contact the top of the list while they still expect to shop with you.
Why it matters
A customer who waits twice for the same retailer has a reason to try a competitor next time. Reaching them first costs a phone call or a credit, which is small next to the lifetime value you lose if they quietly stop buying.
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 furniture retailer. It checks six months of orders from every channel for late deliveries and lines cancelled for stock.
- Includes customers with two or more late or cancelled orders.
- Excludes delays the customer requested and cases the service team has already handled.
- Result: 1,460 customers, 210 of whom have spent over $5,000 with the brand.
What the data shows
Repeated problems are concentrated in a small group, and one in seven of them is a high-value customer.
What it means
Customers who hit two service failures in a row are the ones most likely to stop buying, and the 210 high spenders carry the most revenue at risk.
What to do
Have the service team call the 210 this week, and send the other 1,250 an apology email with a delivery credit.
Would you like me to push the 1,250-customer group to Klaviyo?
Frequently asked questions
How is this different from an order aging report?
An order aging report shows open orders grouped by how long they have waited, which helps operations clear the backlog. This list looks at customers across six months of orders and flags people who have been let down more than once. Use the aging report to fix today's orders and this list to keep the customer.
Should every delayed customer get a discount?
No. A blanket discount costs margin on customers who barely noticed a one-day slip. Save credits for repeat failures and long delays, and lead with an apology and a clear update. High-value customers often value a direct call and a named contact more than a percentage off their next order.
How does delayed delivery affect customer loyalty?
Check it in your own data by comparing repeat rates for customers whose orders arrived late with similar customers whose orders arrived on time. Match the groups on past spend and category, since big-ticket buyers both wait longer and buy less often. The gap between the groups is the loyalty cost of late delivery.