The RFM Method for Creators: Segmenting Customers by Recency, Frequency, and Spend
A decades-old retail formula, translated for creators selling digital products off one link.
Big retailers have been sorting shoppers by Recency, Frequency, and Monetary value (RFM) since the 1990s catalog mail-order days, and the math hasn't aged a bit — it just never made it down to solo creators, because it used to require a data warehouse and an analyst. It doesn't anymore. If you sell an ebook, a preset pack, or a coaching call off one link, you already have every number RFM needs sitting in your customer list right now. This guide shows you how to turn that plain list into three simple scores per person, and how those scores point you straight at the five customers quietly about to churn and the three who are one email away from buying again.
What Recency, Frequency, and Monetary actually mean when you sell one thing at a time
Strip away the retail jargon and RFM is just three questions about every person who has ever paid you. Recency: how many days since their last order? Frequency: how many total orders have they placed, ever? Monetary: what's their total lifetime spend across every purchase, not just the last one? That's it. No churn-prediction model, no cohort curves — just three numbers you can pull directly from your store.fan customer list and orders history. The insight isn't in any single number; it's in the combination. A customer who spent $180 total but hasn't ordered in 95 days looks completely different from one who spent $180 in the last nine days, even though their monetary score is identical.
Score every customer on a 1–3 scale
Keep the scoring dead simple — a 1-to-3 scale beats a 1-to-10 scale because you'll actually use it. Export your customer list, add three columns, and score each row using thresholds like the ones below. Adjust the dollar and day cutoffs to fit your own price point; a creator selling a $19 template and one selling a $2,000 cohort course will land in very different bands, and that's fine.
| Score | Recency (days since last order) | Frequency (lifetime orders) | Monetary (lifetime spend) |
|---|---|---|---|
| 3 — High | 0–30 days | 3 or more orders | Top third of your customers |
| 2 — Medium | 31–90 days | 2 orders | Middle third of your customers |
| 1 — Low | 91+ days | 1 order | Bottom third of your customers |
The four segments worth acting on
Once every customer has a three-digit code like 3-3-3 or 1-3-2, you don't need all 27 possible combinations. Four buckets do almost all the work for a creator-sized list.
- VIPs (3-3-3 or close to it): bought recently, buy often, spend the most. These are the people who should get early access, a private discount code, or a direct invite to your next cohort before anyone else hears about it.
- Loyal but quiet (1-3-3): historically your best customers by frequency and spend, but recency has dropped — no order in 90+ days. This is the segment almost everyone ignores, and it's usually the single highest-ROI list to re-engage because they already trust you and already paid you real money.
- New big spender (3-1-3): just bought, and bought big, but it's only their first order. The move here is a fast, warm upsell while the goodwill is fresh — not a hard sell, a natural next step.
- At risk (1-1-1): one small order, a long time ago, never came back. Don't waste a discount code chasing these; a low-cost win-back email is worth trying once, then let them go.
The customer everyone forgets to email is the one who already bought three times and just went quiet. That's not a lost customer — that's an unopened invoice.— store.fan creator playbook
Build it by hand: a 30-minute spreadsheet workflow
You don't need a CRM subscription to run RFM on a list of a few hundred customers. Here's the exact manual process.
Build your RFM sheet
0/7Turning a spreadsheet into revenue
A segment is worthless sitting in a spreadsheet — it only pays off once it becomes an email. Because store.fan keeps your orders and customer list in one place, you can copy a segment's email addresses straight into a broadcast campaign rather than juggling a separate export-and-import step with a third-party tool. Send your VIP segment a private discount code a few days before you open a new offer to the general list — not because they need the discount to convert, but because early access itself is the reward and it keeps them feeling like insiders. Send the quiet-loyal segment a short, personal-sounding "it's been a while" note referencing what they bought before, paired with a time-limited code. Send new big spenders a related product suggestion within 48 hours, while the purchase is still top of mind. None of this requires new tooling — it requires looking at the list you already have with three new columns.
If you're still deciding whether it's worth setting this up, look at how a working store actually behaves: a live example store shows what a real product lineup and customer flow look like end to end. RFM only has teeth once real transactions are flowing through store.fan — segmentation is a multiplier on sales you're already making, not a substitute for making them. If you haven't opened a store yet, that's the actual first step; everything in this article assumes you have order history to mine.
How often to re-score
Re-run the exercise monthly if you launch often, or quarterly if your catalog is stable. The point isn't precision — it's catching movement. A customer sliding from 3-3-3 to 2-3-3 is your earliest warning sign that someone valuable is drifting, weeks before they'd show up on any "churned" report. Small creators tend to check revenue totals and open rates obsessively but never look at individual customer trajectories; RFM is the cheapest way to fix that blind spot without adding a single new tool to your stack.
Every RFM score starts with real order history — open your store and start collecting the data that makes segmentation possible.
Start freeFAQ
No. A spreadsheet and your store.fan customer list export are enough for anything under a few thousand customers. The method is intentionally low-tech — three columns, three scores, done.
Around 30–50 paying customers is the practical minimum — below that, you can just remember who your best buyers are. Once your list crosses into the hundreds, patterns stop being visible from memory alone and RFM starts earning its keep.
Yes — Frequency then measures repeat purchases of the same item (or renewals, for a membership), and Monetary can include upsells like a bundled coaching call. Even single-SKU stores have customers who buy once versus customers who buy as gifts, restock, or renew.
Total revenue alone hides recency. A customer who spent $300 two years ago and never returned looks the same as one who spent $300 last week and is actively engaged — until you add the recency score, which is exactly the signal that tells you who to email first.
Check the blog for more retention and email playbooks, browse common questions about the platform, or contact support if you get stuck setting up your customer list export.
Turn your knowledge into income
Launch your Store.Fan in minutes — sell digital products, courses, and calls straight from your bio. Free to start.
