RFM is the oldest and still one of the most useful ways to understand your customers. It needs nothing more than your order history, and it answers the questions every store owner asks: who are my best customers, who is new, and who is slipping away?
What RFM stands for
RFM scores every customer on three things:
- Recency: how many days since their last order. Someone who bought last week is far more likely to buy again than someone who bought two years ago.
- Frequency: how many orders they have placed. A customer with five orders has already proven they come back.
- Monetary value: how much they have spent in total.
Recency is usually the strongest of the three. A big spender who has not ordered for a year is worth less to you today than a small spender who ordered yesterday, because the first one may already be buying somewhere else.
Why it works so well for Shopify stores
Shopify already stores everything RFM needs: every order has a customer, a date and a total. You do not need tracking pixels, surveys or a data team. And because RFM looks at real buying behaviour, not demographics, the groups it produces map straight onto actions: thank the best customers, nurture the new ones, and win back the ones going quiet.
How to score customers, step by step
1. Get one row per customer
Start from your orders and roll them up per customer (most people use the email address as the key). For each customer you need:
- the date of their last paid order
- their number of paid orders
- their total spend
Leave out cancelled and fully refunded orders, or your numbers will flatter customers who never actually paid. Our guide on exporting Shopify orders to CSV shows where each of these comes from.
2. Give each customer a 1 to 5 score on each letter
The classic method splits customers into five equal groups (quintiles) for each letter:
| Score | Recency | Frequency | Monetary |
|---|---|---|---|
| 5 | Most recent 20% | Most orders | Highest spend |
| 4 | Next 20% | ||
| 3 | Middle 20% | ||
| 2 | Next 20% | ||
| 1 | Longest ago | Fewest orders | Lowest spend |
There is one catch with frequency. In most stores well over half of customers have ordered only once, so you cannot split them into five equal groups. A simple fix is to use fixed bands instead: 1 order scores 1, 2 orders score 3, 3 or 4 orders score 4, and 5 or more score 5. Adjust the bands to your store.
Recency also works better with your own buying cycle in mind. If your customers usually reorder every 30 days, a 90-day gap is a warning; for a furniture store it is nothing. See when is a customer lost? for how to find your own cycle.
3. Combine the scores into groups
A customer scoring R5 F5 M5 is your best customer. R1 F1 M1 bought once, a long time ago. In between there are many combinations, and nobody wants to market to “R4 F2 M3”. So the last step is to map score combinations to named groups, for example:
- Best Customers: high recency, high frequency, high spend.
- Loyal: buy again and again, spend well, not necessarily very recent.
- New: high recency, only one order.
- At Risk: used to buy often, low recency now.
- Big Spenders Going Quiet: high spend and frequency, but recency has dropped.
- Gone: low on everything.
Our guide to 12 customer segments lists the full set with what to do for each one.
Turning RFM into action
The point of RFM is not the score, it is what you do next. A simple starting plan:
- Best Customers and Loyal: thank them personally, give early access to new products, ask for reviews. Do not train them to wait for discounts.
- New: a good second order is the biggest jump in lifetime value most stores ever see. Send a helpful follow-up, not just a coupon.
- At Risk and Big Spenders Going Quiet: this is usually where the most money is. Reach out before they are gone, with a personal note or a win-back email.
- Gone: one last-chance campaign, then stop emailing them so your sender reputation stays healthy.
How often to recalculate
RFM scores change every day because recency changes every day. A spreadsheet you build once a quarter goes stale fast. Recalculate at least monthly, or use a tool that updates as new orders come in.
Doing it yourself vs using an app
You can do RFM in a spreadsheet with a pivot table and a few PERCENTRANK formulas. It is a great way to learn, and our free RFM calculator does the maths for you straight from a Shopify orders export, in your browser.
The downside of spreadsheets is that they go out of date and nobody opens them. If you want the groups to stay fresh and flow into your email tool, an app like WinBack keeps every customer scored automatically as orders arrive. Get WinBack on the Shopify App Store.