Customers sorted into spending deciles for a campaign list

Marketing keeps asking for the top spenders, then the middle group, then everyone else, as three separate lists.

Intermediate to advancedRead 6 minDoing: 45 minutes to an hour7 steps

What you'll have at the end

One column labelling every customer 1 through 10 by spend, ready to filter for any group marketing wants

Before you start

You need

An orders table with a customer id, an order date, and an order amount on each row, covering however far back the campaign should count spending.

Not covered

Scoring customers on how recently or how often they buy alongside spend; this recipe ranks by one number, total spend, and nothing else.

Leans on

7 steps

Best sellers by category, ranked without a manual count

go there when the ask is ranking products inside a category, not bucketing every customer into equal-sized spending groups

Flag lapsed customers who've gone quiet

go there when marketing's real question is which customers stopped buying, not how much every customer has spent

Checked 26 Aug 2026