Customer analytics guide
RFM segmentation for Shopify, explained
RFM segmentation sorts your customers by how recently they bought, how often they buy and how much they spend. It is one of the simplest ways to decide who to reward, who to win back and who to leave alone.
Written by Malick Alexandre Sarr, co-founder of Avantages. Published on . About 8 minutes to read.
What is RFM segmentation?
RFM segmentation groups customers using three numbers from their order history. Recency is how long ago they last ordered. Frequency is how many orders they have placed. Monetary value is how much they have spent. Customers with similar scores behave in similar ways, so each group can get its own message.
RFM works well for Shopify stores because all three numbers come straight from your orders. You do not need tracking pixels, surveys or a data team to start.
How RFM scores work
The most common method gives each customer a score from 1 to 5 for recency, frequency and monetary value. You sort customers by each measure and split them into five equal groups, so the most recent 20% of buyers get a recency score of 5 and the least recent 20% get a 1.
A customer who bought last week, has ordered eight times and spends more than most gets a score of 5-5-5. A customer whose only order was 14 months ago scores close to 1-1-1. Scores are then grouped into named segments that are easier to act on.
The main RFM segments and what to do with each
Segment names and score rules vary between tools. The table below shows a common set and a sensible first action for each one.
| Segment | Typical scores | Who they are | What to do |
|---|---|---|---|
| Champions | High recency, frequency and spend | Your best and most recent customers | Reward them with early access and ask for reviews, not discounts |
| Loyal customers | High frequency, good recency | Regular buyers who respond well to new products | Offer bundles, refills and loyalty perks |
| Potential loyalists | Recent, two or three orders | Newer customers who are building a habit | Recommend a second product and explain how to get the most from it |
| New customers | Very recent, one order | First-time buyers | Welcome flow, product education and a reason to order again |
| At risk | Low recency, good frequency and spend | Good customers who have not ordered for a while | A personal win-back message before they are lost |
| Hibernating | Low recency and frequency | Occasional buyers who have gone quiet | Light reminders or a seasonal offer; keep spend low |
| Lost | Lowest recency and frequency | Customers who have probably moved on | Exclude them from paid audiences and try one final win-back |
How to calculate RFM from Shopify orders
You can calculate RFM in a spreadsheet from a Shopify order export. Use paid orders only and choose a fixed analysis date, usually today.
- For each customer, find the date of the last order and count the days between that date and the analysis date. That is recency, and lower is better.
- Count each customer’s orders in your chosen time window. That is frequency.
- Add up each customer’s net sales in the same window, after discounts and refunds. That is monetary value.
- Split customers into five equal groups for each measure and give each group a score from 1 to 5.
- Combine the three scores and map each combination to a segment, such as the table above.
Choosing the right time window
Most stores use the last 12 or 24 months of orders. Pick a window that covers several of your normal reorder cycles. A coffee brand whose customers reorder every month can use 12 months, while a furniture brand may need 36 months to see repeat orders at all.
Recalculate segments regularly, at least monthly. RFM describes customers at a point in time, and the most useful signal is a customer moving from Champion or Loyal into At risk.
Common RFM mistakes
- Splitting frequency into five groups when most customers have one order. Use fixed bands such as 1, 2, 3 to 4 and 5 or more instead.
- Sending discounts to Champions who would have bought anyway, which cuts margin without adding orders.
- Treating RFM as a one-off project. Segments go stale within weeks unless they are refreshed.
- Counting gross sales instead of net sales, which overrates customers who return a lot.
- Ignoring the size of each segment. A small At risk segment of high spenders can be worth more attention than a large Hibernating one.
RFM and cohort analysis work best together
Cohort analysis tells you whether retention is improving over time. RFM tells you which of today’s customers need attention now. Used together, they show both the trend and the people behind it.
RFM segments in AvantagesLive
See your segments and what they are worth
Avantages scores every customer from your Shopify orders and keeps the segments up to date each day. You see how many customers sit in each segment and how much revenue they bring in. In our demo store, Champions are 6% of customers but bring in 31% of revenue.
Founding member offer for the first 20 brands
Get 3 months free as a founding member
Then 50% off your first year. In a 30-minute call, we connect your Shopify store and walk you through your first daily briefing.
A 30-minute call, no commitment