RFM Analysis for Email Marketing: Score Your List by What People Actually Do

RFM analysis turns three columns you already have into a ranked customer list. How to score recency, frequency and monetary value, and what to email each group.

Inbox Connect Team
9 min read
RFM Analysis for Email Marketing: Score Your List by What People Actually Do

Most segments are guesses wearing a name badge.

"Engaged subscribers." "Loyal customers." "At risk." You made those buckets up, you drew the lines wherever felt right, and now you're sending campaigns based on a definition nobody wrote down. RFM analysis fixes that. It takes three numbers you already have sitting in your store or CRM and turns your whole list into a ranked, sortable, arguable-with-data set of segments.

Three columns. That's the whole method. And it works whether you've got 800 customers or 800,000.

What RFM Actually Measures

RFM stands for Recency, Frequency, Monetary. It came out of catalog retail decades before anyone was optimizing subject lines, which is part of why it holds up. It was built to answer one question: who is most likely to buy from us next?

Recency. How long since their last purchase. This is the heaviest of the three and it's not close. Someone who bought last week is dramatically more likely to buy again than someone who bought fourteen months ago, even if the fourteen-month customer spent more back then. Recency decays fast, and it decays quietly.

Frequency. How many times they've purchased in your scoring window. Two purchases is a fundamentally different relationship than one. The gap between a one-time buyer and a two-time buyer is the biggest behavioral jump in most ecommerce businesses.

Monetary. How much they've spent in total across that window. Use revenue, not order count, and decide up front whether you're using gross or net of refunds. Pick one and stay consistent, because you're going to rerun this every month.

Notice what's not in there. No age, no location, no job title, no "persona." RFM is pure behavioral segmentation, stripped down to the three behaviors that predict revenue best. If you've been building segments off demographics and wondering why they underperform, this is why.

The reason RFM beats hand-drawn segments is that it's relative. You're not deciding that "a good customer spends over $500." You're scoring every customer against everyone else on your list. A $500 customer might be your top 10% or your bottom 40% depending on what you sell. The math figures that out instead of you guessing.

How to Score Your List Without a Data Team

Here's the version you can do in a spreadsheet this afternoon.

Step 1: Export three columns. Customer email, last order date, order count, and total revenue. That's four columns, fine, but you get the idea. Every major platform exports this. Set a window: last 24 months is a reasonable default for most stores. Shorter if you sell something people buy weekly, longer if you sell mattresses.

Step 2: Sort and split into fifths. Sort by recency, cut the list into five equal groups, and give the most recent fifth a 5 and the oldest fifth a 1. Repeat for frequency. Repeat for monetary. Now every customer has three digits.

Quintiles matter here. Splitting into equal-sized fifths rather than picking round-number thresholds is what keeps the scores honest when your business changes. If everyone's spending drops next quarter, a 5 still means "top 20% of my customers," which is the thing you actually want to know.

Step 3: Read the three digits as a profile, not a total. This is the step people get wrong. Do not add the digits together. A 5-1-1 (bought once, recently, small) and a 1-5-5 (bought constantly, big money, gone silent for a year) both average out to something in the middle, and they could not be more different. One is a brand new customer you need to convert to a second purchase. The other is a former VIP you're actively losing.

Read them left to right as a pattern. Recency first, because recency is the one that tells you whether the relationship is alive.

Step 4: Rerun it on a schedule. Monthly is right for most businesses. RFM scores are a snapshot, and a customer's recency score drops every single day they don't buy. A segment you built in January is describing people who no longer exist by April.

If your platform supports calculated properties or dynamic segments, build this once as a live segment rather than a static list upload. Static uploads go stale and then you're emailing your "VIPs" a win-back campaign.

The Segments Your Scores Hand You

You don't need to name all 125 possible combinations. Most teams work with six or seven groups that cover the vast majority of the list.

SegmentScore patternWhat it means
Champions5-5-5, 5-5-4Bought recently, buy often, spend the most
Loyal3-5, 4-4 patterns, high FConsistent repeat buyers, mid-to-high spend
Recent one-timers5-1-xJust bought for the first time, unproven
Big spenders at risk2-4-5, 2-5-5Spent heavily, gone quiet, not gone yet
Slipping away2-2-2, 2-3-2Cooling off across the board
Hibernating1-1-1, 1-2-1Old, infrequent, low value
Lost VIPs1-5-5Your worst loss, and the most winnable

Two of these deserve extra attention because they're where the money actually moves.

Recent one-timers are the largest group on most lists and the most wasted. They just gave you money, which means their attention is as high as it will ever be, and most brands respond by dropping them into the general promo blast. Their entire job right now is to make a second purchase. Nothing else. A tuned post-purchase sequence does more for this group than any discount campaign will.

Lost VIPs are the sharpest signal in the whole grid. A 1-5-5 is someone who bought from you repeatedly, spent real money, and then stopped. That is not a cold subscriber. That's a person who had a reason. Maybe a bad delivery, maybe a competitor, maybe they just forgot. This is the group where a genuine win-back campaign earns its keep, and it's worth a bigger incentive than you'd normally offer because the customer economics justify it.

What to Send Each Group

Scores are useless until they change what lands in someone's inbox. The mapping is fairly blunt.

Champions get access, not discounts. Early releases, restocks before public announcement, the occasional "we're building this, what do you think" email. Discounting your champions is setting fire to margin on people who were going to buy anyway. Ask them for reviews and referrals instead. They're the only group who'll actually do it.

Loyal customers get relevance. Product recommendations based on what they've already bought, category expansions, replenishment reminders timed to their actual cycle. These are the people where personalization pays off most, because you have enough purchase history to be right instead of creepy.

Recent one-timers get a path to purchase two. Onboarding-style content about the thing they bought, one clear complementary product, social proof from people who bought the same item. Give it a defined window. If they haven't converted in 60 days, they've told you something and they move to a different track.

Big spenders at risk get a human email. Plain text, from a real name, asking a question rather than pitching. This group hasn't left yet, and the intervention that works is usually acknowledgment rather than a coupon.

Slipping away gets frequency reduction, not escalation. The instinct is to email harder. Do the opposite. Drop them to your lowest cadence and send your genuinely best content. Emailing a cooling segment more often is how you turn a soft decline into a spam complaint.

Hibernating gets one honest attempt, then the exit. Two or three emails, no more. If nothing lands, they belong in your sunset policy, because sending to people who reliably ignore you damages inbox placement for everyone else on the list.

One rule that ties all of these together: set exclusions before you set sends. If someone qualifies for both the champion campaign and a general promo, the champion campaign wins and the promo suppresses them. Without exclusion logic you end up sending your best customer a "we miss you" email in the same week they placed an order, which is the kind of thing people screenshot.

Where RFM Breaks Down

It's a good model, not a complete one. The honest limitations:

It only sees buyers. RFM says nothing about a subscriber who has never purchased, which on most lists is the majority of names. You still need engagement-based segments for those people. RFM is a layer on top of your broader segmentation strategy, not a replacement for it.

It's backward-looking. It describes what someone did, not what changed. A customer who just had a terrible support experience still scores 5-5-5 for another month.

Subscription businesses need a different frame. If revenue arrives automatically every month, frequency and recency stop being behavioral signals and start being billing artifacts. Score on usage and engagement instead, or you'll flag every active subscriber as a champion regardless of whether they're about to cancel.

Long purchase cycles distort the quintiles. If your product is replaced every three years, a 24-month window puts perfectly healthy customers in the bottom fifth. Stretch the window to match the actual repurchase cycle.

Small lists get noisy. Under a few hundred customers, quintiles are five tiny groups and one refund can move somebody two tiers. Use three bands instead of five, or wait until you have the volume.

Run Your First Pass This Week

Export the three columns. Sort into fifths. Score, then look at your 1-5-5s and your 5-1-1s before you look at anything else, because those two groups usually contain more recoverable revenue than the rest of your calendar combined.

Then build two campaigns. One for lost VIPs, one for recent one-timers. Don't try to launch all seven segments at once. You'll stall on the middle groups, which are the least interesting ones anyway.

Rerun the scores next month and watch which direction people are moving. That movement, not the score itself, is the thing worth acting on.

Ready for better results?

Get expert help with your email marketing strategy. Book a free call and get a complimentary audit.