Skip to content
Tool N04Available

Customer segmentation from purchase data

Group your customers by how they buy, see what each group is worth, and know how to treat each one.

Ready to use. Buy it in your account: a one-time licence fee and a monthly fee, plus the AI it uses.

01

What it does

Upload a customer export (a row per customer with orders, total spent and last order date) or an order export (a row per order with the customer, date and amount), and any offers you are happy to use. We add up the orders, score every customer from 1 to 5 on how recently, how often and how much they buy, and put each one in a segment: champions, loyal, can't lose them, at risk, new, promising, need attention or hibernating. For each segment we work out its size, its share of customers and of revenue and, for larger ones, the typical spend, orders and days since the last order. The AI sees only the segments, never a person, and suggests a goal, an offer from your own list (or one that adds value), a message idea and a service level for each, plus one offer to test and a quarterly review. The list of customers with their segment downloads as a spreadsheet, never shown on screen.

Who it is for

  • Retailers and online shops
  • Subscription businesses and hospitality groups
  • B2B services with repeat customers
02

Quick start

  1. 01Export your customers or ordersFrom your shop, till or booking system, as a CSV. At least 20 customers.
  2. 02List the offers you would useWith their terms. Without any, the suggestions add value instead of discounting.
  3. 03Run itIt takes a minute. You can leave the page: the result waits in your run history.
  4. 04Act on two segments firstFor example thank your champions and win back those at risk, then download the lists for your email tool.
03

What you give it

Customer or order export (CSV)Required, up to 1 files
A customer export (orders, total spent, last order date) or an order export (customer, date, amount), as a CSV.
Offers you are happy to useOptional, up to 8 lines
Offers you are happy to use, a line each with their terms. Optional.
Anything elseOptional, up to 1,500 characters
Anything else, such as your busiest season. Optional.
04

What you get

Your customer segments
Each segment with who is in it, its size, its share of customers and revenue and typical figures. Downloadable as a spreadsheet.
What to do with each segment
A goal, a suggested offer, a message idea and a service level.
Offer test and quarterly review
One simple offer test and how to refresh the segments each quarter.
Customers by segment
Every customer with their segment and scores, as a spreadsheet only, for your email or CRM tool.
What to check
Notes for you only: figures we did not work out, and message ideas that mention spending or segments.

You can edit the result, then copy it, print it or download it as Word, Markdown, plain text or data. Every run is kept in your run history until you delete it.

05

An example

Kestrel Outdoors is a made-up business. Below is what was entered, then the tool's real result, unedited, made on 11 November 2026. Subscribe to run it with your own details.

What was entered

From Kestrel Outdoors’s Business profile

What you sell
Outdoor clothing and kit sold online across the UK
Products or services
Jackets, boots, rucksacks and accessories.
Customer or order export (CSV)
  • customers.csv
Offers you are happy to use
  • Free delivery on any second order
  • 15% off for customers who have not ordered in 4 months
What customers.csv says
Email,Total Orders,Total Spent,Last Order Date
customer1@example.test,1,18,2026-11-05
customer2@example.test,1,25,2026-08-12
customer3@example.test,2,64,2025-10-06
customer4@example.test,3,120,2026-09-26
customer5@example.test,5,90,2026-03-15
customer6@example.test,8,200,2026-10-21
customer7@example.test,12,384,2026-06-13
customer8@example.test,1,40,2026-11-05
customer9@example.test,1,18,2026-08-12
customer10@example.test,2,50,2025-10-06
customer11@example.test,3,96,2026-09-26
customer12@example.test,5,200,2026-03-15
customer13@example.test,8,144,2026-10-21
customer14@example.test,12,300,2026-06-13
customer15@example.test,1,32,2026-11-05
customer16@example.test,1,40,2026-08-12
customer17@example.test,2,36,2025-10-06
customer18@example.test,3,75,2026-09-26
customer19@example.test,5,160,2026-03-15
customer20@example.test,8,320,2026-10-21
customer21@example.test,12,216,2026-06-13
customer22@example.test,1,25,2026-11-05
customer23@example.test,1,32,2026-08-12
customer24@example.test,2,80,2025-10-06
customer25@example.test,3,54,2026-09-26
customer26@example.test,5,125,2026-03-15
customer27@example.test,8,256,2026-10-21
customer28@example.test,12,480,2026-06-13
customer29@example.test,1,18,2026-11-05
customer30@example.test,1,25,2026-08-12
customer31@example.test,2,64,2025-10-06
customer32@example.test,3,120,2026-09-26
customer33@example.test,5,90,2026-03-15
customer34@example.test,8,200,2026-10-21
customer35@example.test,12,384,2026-06-13
customer36@example.test,1,40,2026-11-05
customer37@example.test,1,18,2026-08-12
customer38@example.test,2,50,2025-10-06
customer39@example.test,3,96,2026-09-26
customer40@example.test,5,200,2026-03-15
customer41@example.test,8,144,2026-10-21
customer42@example.test,12,300,2026-06-13
customer43@example.test,1,32,2026-11-05
customer44@example.test,1,40,2026-08-12
customer45@example.test,2,36,2025-10-06
customer46@example.test,3,75,2026-09-26
customer47@example.test,5,160,2026-03-15
customer48@example.test,8,320,2026-10-21
customer49@example.test,12,216,2026-06-13
customer50@example.test,1,25,2026-11-05
customer51@example.test,1,32,2026-08-12
customer52@example.test,2,80,2025-10-06
customer53@example.test,3,54,2026-09-26
customer54@example.test,5,125,2026-03-15
customer55@example.test,8,256,2026-10-21
customer56@example.test,12,480,2026-06-13
customer57@example.test,1,18,2026-11-05
customer58@example.test,1,25,2026-08-12
customer59@example.test,2,64,2025-10-06
customer60@example.test,3,120,2026-09-26

1 optional detail was left empty.

In your account this is a form you fill in, and the tool runs once you subscribe.

What the tool returned

In short

Loyal customers are 8 of 60 customers (13.33%) but bring 36.38% of revenue, and Champions are another 8 customers (13.33%) with 24.25% of revenue. At risk is the largest group at 11 customers (18.33%) but brings 9.28% of revenue, with a typical spend of 64 and 402 days since the last order. Can't lose them are 6 customers (10%) with 12.79% of revenue.

Your customer segments

Segment 1

Segment: Champions

Who they are: Bought recently, buy often and spend the most

Customers: 8

Share of customers: 13.33%

Share of revenue: 24.25%

Segment 2

Segment: Loyal customers

Who they are: Buy often and fairly recently

Customers: 8

Share of customers: 13.33%

Share of revenue: 36.38%

Segment 3

Segment: Can't lose them

Who they are: Used to buy often and spend a lot, but not for a while

Customers: 6

Share of customers: 10%

Share of revenue: 12.79%

Segment 4

Segment: At risk

Who they are: Bought several times, but not for a while

Customers: 11

Share of customers: 18.33%

Share of revenue: 9.28%

Typical spend: £64

Typical orders: 2

Typical days since last order: 402

Segment 5

Segment: New customers

Who they are: First order recently

Customers: 9

Share of customers: 15%

Share of revenue: 3.27%

Segment 6

Segment: Promising

Who they are: Bought recently, a couple of times

Customers: 9

Share of customers: 15%

Share of revenue: 10.68%

Segment 7

Segment: Need attention

Who they are: Middling on recency and frequency

Customers: 9

Share of customers: 15%

Share of revenue: 3.36%

What to do with each segment

Action 1

Segment: Champions

Goal: Make the best customers feel valued so they keep choosing Kestrel Outdoors.

Suggested offer: A personal thank-you note from the business, with no discount.

Message idea

Thank you for choosing Kestrel Outdoors. We really appreciate your support and hope your kit is serving you well on the hills.

Service level: Give them priority replies to any question and a named person to contact.

Action 2

Segment: Loyal customers

Goal: Keep them buying and recognise their loyalty.

Suggested offer: A handwritten thank-you note; free delivery applies on orders over £50.

Message idea: Thanks for being part of Kestrel Outdoors. If you need anything for your next trip outdoors, we are happy to help.

Service level: Reply quickly and check in personally if anything goes wrong with a delivery.

Action 3

Segment: Can't lose them

Goal: Win back high-value customers who have been away for a while.

Suggested offer: 15% off for customers who have not ordered in 4 months.

Message idea: It has been a while and we would love to see you back at Kestrel Outdoors. Here is 15% off to welcome you back.

Service level: Send a personal message from a named person and respond to replies the same working day.

Action 4

Segment: At risk

Goal: Give them a clear reason to come back before they drift away completely.

Suggested offer: 15% off for customers who have not ordered in 4 months.

Message idea

We would like to see you back at Kestrel Outdoors. Here is 15% off for your next purchase of jackets, boots, rucksacks or accessories.

Service level: Send a friendly reminder of the offer's terms and make it easy to reach us with questions.

Action 5

Segment: New customers

Goal: Encourage a second purchase soon after the first.

Suggested offer: Free delivery on any second order.

Message idea

Welcome to Kestrel Outdoors. Thanks for choosing us, and we hope you are pleased with your kit. Delivery is free on your next order.

Service level: Send a clear welcome message and follow up on any delivery or fit questions quickly.

Action 6

Segment: Promising

Goal: Turn recent buyers into regular customers.

Suggested offer: Free delivery over £50, as set out in the delivery terms.

Message idea: Thanks for shopping with Kestrel Outdoors. Remember that delivery is free on orders over £50 when you need more kit.

Service level: Offer helpful, prompt answers on sizing and product questions.

Action 7

Segment: Need attention

Goal: Remind them Kestrel Outdoors is there and bring them back to the site.

Suggested offer: Free delivery over £50, as set out in the delivery terms.

Message idea: We have jackets, boots, rucksacks and accessories ready for your next outing, with free delivery over £50.

Service level: Include them in regular emails and respond to queries within the usual time.

One offer to test

Send the 15% off for customers who have not ordered in 4 months to half of the at risk segment (11 customers), and keep the other half as a comparison group with no offer. Run it for 4 weeks, then compare orders from each half over that period. The group is small, so treat the result as a guide.

Quarterly review

  • Export fresh customer order data covering the same fields as last time.
  • Re-run the segmentation on the new export.
  • Compare each segment's customer count and share of customers and revenue with the previous quarter.
  • Note which customers moved between segments, for example at risk back to promising or loyal.
  • Check how the tested offer performed against its comparison group and decide whether to keep, change or drop it.
  • Update the offers and messages for each segment before the next quarter begins.

How the segments were made

  • Every customer gets a score from 1 to 5 for recency (how recently they ordered), frequency (how many orders) and spend (how much in all), by fifths of your list: the top fifth score 5.
  • Each customer is in one segment, checked in this order: champions (recent and frequent), loyal (frequent), can't lose them (frequent big spenders gone quiet), at risk (repeat customers gone quiet), new (one recent order), promising (recent), need attention (middling), hibernating (the rest).
  • Typical figures are medians, shown only for segments of 10 or more customers.
  • Re-run it each quarter with a fresh export: customers move between segments as they buy.

Only for you: not included when you copy, print or download

Check before using

  • The writing says "50", which is not a figure worked out from your list or in your offers. Check it.
  • The list of customers by segment downloads as a spreadsheet; it is never shown on screen. Use it only for people who agreed to marketing.
06

What the AI does

It does

  • Suggests a goal, offer, message and service level for each segment
  • Uses only your own offers, or ones that add value
  • Never sees an individual customer
  • Never works out its own figures

It does not

  • Send messages to your customers
  • Read your shop or till directly: you upload an export
  • Know anything about customers beyond the export
  • Promise more sales

Please check itCheck the segments make sense for your business, and use the customer list only for people who agreed to marketing.

07

Limits

  • Customer or order export (CSV): up to 1 files.
  • Offers you are happy to use: up to 8 lines.
  • Anything else: up to 1,500 characters.
  • At least 20 customers and up to 20,000 a run.
  • The customer list downloads only as a spreadsheet.
  • Your workspace's monthly cap: a run that would take you over it pauses, and carries on where it stopped when you raise the cap.
08

Your data

  • What you enter, the files you choose and the result are stored encrypted with your workspace's own key. Only people in your workspace can open them.
  • To produce the result, what you give the tool (and the parts of your Business profile it uses) is sent to our AI provider, Anthropic. It uses it only to answer, and its terms do not allow it to train its models on it. We do not train on it either.
  • Files you upload are deleted after 30 days unless you choose to keep them. You can delete a run at any time: what you entered, the result and the progress notes go; only the usage record stays, because it is part of your billing.
  • Our service is hosted in the United States.

The full details are in our privacy notice.

09

Questions

How are runs charged?

A one-time licence fee of $1,200 (£1,200 in the UK), then $300 a month (£250 in the UK), including any tax that applies. On top, you pay for the AI each run uses, billed each month with your invoice and never more than the monthly cap you set. From your fourth tool there is no licence fee.

Can I change the result?

Yes. Choose Edit this result to change any wording or figure, and Restore the original result to go back. Copy, print and downloads use your edited version.

Is it ready to use now?

Yes. Sign in, open Tools in your account and choose Get started for this tool.

How are customers scored?

Each gets 1 to 5 for recency, frequency and spend, by fifths of your list, and goes into one segment by fixed rules. The method is shown with the result.

Does the AI see my customers' details?

No. It sees only each segment's size and typical figures. The customer list is made by us and only downloads as a spreadsheet.

10

If something goes wrong

The file could not be read.
Use a row per customer with email or phone, total orders, total spent and last order date, or a row per order with the customer, date and amount.
It says there are too few customers.
Segments need at least 20 customers with orders: export a longer period.

Still stuck? Use the enquiry form and say which tool and what you saw.