New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
Nobody can say which customers have actually stopped buying without opening every account by hand.
What you'll have at the end
A sorted list of customers with no order in the last 90 days, longest-silent first, each row carrying the exact date of that customer's last order.
You need
A table of individual orders, one row per order, holding a customer id and an order date, with enough history behind it that most customers show more than one order.
Not covered
Customers who signed up but have never placed a single order at all. That's the sibling problem of finding customers with zero orders, a separate list from this one.
Leans on
Which customers have never placed an order?
go there when the question is who has never bought at all, not who bought before and has since gone quiet
Customers sorted into spending deciles for a campaign list
go there once the flagged list needs ranking by how much these customers used to spend, on top of how long they've been silent
Checked 26 Aug 2026
Part of the SQL for Data Analysis cookbook