The Retentionist. Turning one-time buyers into regulars
Email Sms

RFM Segmentation in Practice: One Spreadsheet, Three Moves

Most merchants treat RFM as a scoring exercise that ends in a spreadsheet, when the only thing that pays off is the three email moves built on top of it and measured against open, click, and unsubscribe benchmarks.

By The Retentionist  ·  November 5, 2026  ·  4 min read  ·  AI-drafted from sourced data

Most merchants think RFM segmentation is finished once the spreadsheet has a score next to every customer name. It isn’t. The scoring is the easy half. The part that actually changes revenue is what gets sent to each segment afterward, and that part lives or dies on open rates, click rates, and unsubscribe rates that can be checked against real benchmarks rather than guessed at. A spreadsheet with no send plan behind it is a filing exercise, not retention work.

The spreadsheet only needs three columns and one sort

Recency, frequency, and monetary value each need one number per customer: days since last order, number of orders, and total spend. Rank each column, split into groups, and the segments fall out on their own. There is no need for a tool before this step works, because the entire method is arithmetic on an order export. The place it gets complicated is not the math, it is deciding what to do with a customer who is high on monetary value and low on recency, and that decision is answered by the campaign performance data below, not by the spreadsheet itself.

The first move is a send to the best segment, and it should outperform the average

The customers with the best recency, frequency, and spend are the group most likely to open anything sent to them, so this is where a program proves itself fast. Benchmark data puts the average open rate at 20.73% and the top 10% of senders at 44.02%, which is a wide enough gap to use as a target: a send to the best RFM tier that lands near 44.02% confirms the segmentation is doing real work, while a result closer to 20.73% suggests the segment is too broad or the message too generic. Click-through rate follows the same pattern, averaging 2.27% with the top 10% reaching 5.22%.

The second move is win-back, and it should borrow from transactional framing

Transactional emails average a 30.63% open rate, a figure well above the 20.73% general average, and that gap exists because receipts, shipping updates, and account notices get opened out of habit rather than interest. A win-back email aimed at the lapsed, low-frequency segment can use some of that same framing, a subject line that reads like an account update rather than a promotion. This is a framing choice supported by the open-rate gap in the data, not a claim about conversion, since no conversion figures are available here.

The third move is protecting the list, and the unsubscribe numbers set the limit

Average unsubscribe rate across the benchmark set is 0.46%, while the top 10% of senders keep it down to 0.05%. That is close to a nine-times difference, and it is the clearest signal available for how aggressive a win-back cadence can be. A segment with unsubscribe rates tracking near 0.46% is being sent to too often or too generically, and the fix is narrowing the list further or slowing the send schedule, not writing a better subject line.

MetricAverageTop 10%
Open rate20.73%44.02%
Click-through rate2.27%5.22%
Unsubscribe rate0.46%0.05%
Transactional open rate30.63%—

Average versus top 10% performance across email metrics012.52537.550Open rate avg20.73Open rate top1044.02CTR avg2.27CTR top105.22Unsubscribe avg0.46Unsubscribe top100.05Method: read from Brevo’s email marketing benchmarks report, October 15 2026

The numbers in this article come from Brevo’s published email marketing and automation benchmarks page as loaded on October 15, 2026, including the separate regional figures for Europe showing a 22.83% to 36.90% open rate range and a 2.29% click-through rate alongside a 0.51% unsubscribe rate. European figures sit close to the general average and top-tier range already cited, which is useful context but not a separate target to chase.

Build the spreadsheet this week with the three RFM columns and a simple split into high, mid, and low groups for each. Then send one campaign to the top segment, measure its open and click rates against the 44.02% and 5.22% top-tier benchmarks, and only move to the lapsed segment once the unsubscribe rate on that first send sits well clear of 0.46%.

Frequently asked questions

What is RFM segmentation and do I need software for it?

RFM stands for recency, frequency, monetary value, and it ranks customers by when they last bought, how often they buy, and how much they spend. A spreadsheet with order export data is enough to start, because the method only needs three columns per customer plus a sort. The benchmarks that matter once the segments exist come from email performance data: average open rate is 20.73% and the top 10% of senders hit 44.02%, so the spreadsheet is step one and the email send is where the score gets tested.

Which RFM segment should get the first email?

Start with the recent, frequent, high-spend group because they open at rates closer to the top 10% benchmark of 44.02% than to the 20.73% average, and a quick win there proves the segmentation is working before touching the harder groups. The lapsed, low-frequency segment should come second, since that is where click-through rate of 2.27% on average and unsubscribe rate of 0.46% on average both bite hardest. Sequencing this way protects list health while the program is still new.

How does click-through rate differ for a segmented send versus a blast?

The facts available here do not separate click-through by segment, but they do set two reference points: 2.27% average click-through rate and 5.22% for the top 10% of senders. A segmented RFM send that only reaches people already showing recency and frequency should be compared against the 5.22% top-tier number, not the 2.27% average, because a narrower, more relevant list is the entire argument for segmenting in the first place.

Should win-back emails look like transactional emails?

There is a real gap worth using: transactional emails average a 30.63% open rate, well above the 20.73% average for general sends. A win-back email framed around an account update, a receipt-style subject line, or a reorder prompt borrows some of that attention, though the facts here only confirm the open-rate gap and not conversion. Treat it as a reason to test the framing, not a guarantee.

What unsubscribe rate should stop a campaign?

The average unsubscribe rate across the benchmark set is 0.46%, and the top 10% of senders hold it to 0.05%. If a segment's unsubscribe rate on an RFM-based send tracks closer to 0.46% than to 0.05%, that is a signal to slow the cadence or narrow the audience further, since the gap between those two numbers is roughly a factor of nine.

Sources & data

  1. Brevo email marketing and automation benchmarks report, average and top 10% performance metrics (checked October 15, 2026)
  2. Brevo benchmarks report, transactional email open rate figures (checked October 15, 2026)
  3. Brevo benchmarks report, regional click-through and unsubscribe rates for Europe (checked October 15, 2026)
Cite this report: The Retentionist Research Desk (2026). “RFM Segmentation in Practice: One Spreadsheet, Three Moves.” The Retentionist. https://theretentionist.com/email-sms/rfm-segmentation-in-practice-one-spreadsheet-three-moves/
Figures on this page are our own measurements. You may quote them and reproduce a single table or chart, provided you include a visible, followable link to this page. Full terms: Reuse & citation.