Ecommerce Customer Segmentation: RFM Scoring and LTV Reporting, With a Worked Example

Ecommerce customer segmentation, in short: score every customer 1–5 on recency, frequency and monetary value (RFM), group the scores into about eight segments, and report lifetime value (LTV) by acquisition cohort. Shopify sorts customers into 11 RFM groups natively; Klaviyo, Omnisend and Brevo build RFM or lifecycle segments from store orders.

More on this topic: Marketing automation and funnels, every guide in one place.

Segmenting by purchase behaviour is the highest-return thing most stores are not doing properly. A 20% discount sent to a customer who was going to buy anyway is margin thrown away; the same discount sent to a lapsed big spender might be the cheapest win of the quarter. This guide shows the scoring with a worked example, the LTV formulas, which segments to build, and which tools do it for you.

Key takeaways

What is RFM segmentation in ecommerce?

RFM segmentation groups customers by how recently they bought, how often they buy and how much they have spent, using order data your store already has. Each dimension gets a score, usually 1 to 5, and the three-digit combination tells you who a customer is: 555 is your best customer, 155 is a big spender you are about to lose, 511 is a new buyer who has not come back yet.

It works because those three numbers predict behaviour better than demographics do, and they need no surveys or tracking pixels — only the order history.

How do you calculate RFM scores? A worked example

Set thresholds for each score from your own order data — the simplest method is to split customers into five equal groups (quintiles) on each dimension. The thresholds below are an illustrative store with a typical order around $60.

Now score eight customers against those thresholds:

Look at H. On a spend-only report, H is your second-best customer. On RFM, H has not bought in 260 days and is the single most urgent person on the list. That is the whole point of adding recency.

Which customer segments should an online store build?

Build the eight RFM segments first, each tied to one action, then add a few behaviour segments that RFM does not capture.

Then add behaviour segments: category bought (so a dog-food buyer never gets cat-litter emails), discount-only buyers (to stop training them), high-AOV one-time buyers, and replenishment windows for consumables. Our win-back campaign guide covers the At risk and Can't lose sequences in detail.

How do you calculate customer lifetime value (LTV)?

Customer lifetime value is the gross margin a customer generates over their whole relationship with your store. There are three useful ways to calculate it, from simplest to most honest.

1. Historic LTV

Sum what each customer has actually spent, minus refunds, times gross margin. Customer A above has spent $1,140; at a 55% gross margin that is $627 of historic LTV. Exact, but backward-looking.

2. Formula LTV

LTV = average order value × orders per year × gross margin × customer lifespan (years), where lifespan is roughly 1 ÷ annual churn rate.

Quick to calculate, but it assumes every customer behaves like the average, which none do.

3. Cohort LTV

Group customers by the month of their first order and track cumulative revenue per customer over time. This is the version to report, because it shows whether newer customers are better or worse than older ones.

If this cohort cost $45 per customer to acquire, it paid back between day 90 and day 180, and its 12-month LTV-to-CAC ratio is about 1.7 ($75.90 ÷ $45). That is the number that tells you how much you can afford to spend on acquisition — see how to measure ad performance for the CAC side.

What should an ecommerce LTV report include?

An ecommerce LTV report should show cohort LTV by acquisition month, LTV by first product or category, LTV by acquisition channel, repeat-purchase rate, and time between first and second order.

• Cohort LTV at 30/90/180/365 days — the trend matters more than the level.
• LTV by first product. The product someone buys first often predicts their value better than anything else.
• LTV by channel. A cheap channel that brings one-time buyers can be worse than an expensive one that brings Champions.
• Second-order rate and timing. Most of the gap between a one-time buyer and a repeat customer is the second order.
• Segment movement. How many customers moved from New to Promising, or from Loyal to At risk, this month.

Which tools do RFM and LTV segmentation for you?

Several ecommerce platforms now calculate RFM and LTV from your store orders, so you rarely need a spreadsheet. The details below come from each vendor's own help centre or pricing page, checked in October 2026.

Scalry is not on this list. It does not integrate with Shopify or WooCommerce, so it cannot build segments from store orders — a store that needs RFM should use one of the tools above. Scalry's segmentation is for CRM contacts, covered in how to segment contacts in a CRM.

For choosing the platform itself, see our best CRM for ecommerce comparison and the cheapest plans with abandoned cart, SMS and revenue reporting.

Common mistakes with purchase-behaviour segmentation

• Using revenue instead of margin. A customer who only buys at 40% off can top the spend chart and lose you money.
• Scoring on too little history. Under a few hundred customers, quintiles are noise; start with simple recency bands.
• Discounting Champions. They were going to buy. Give them access and recognition instead.
• Never suppressing Lost. Mailing people who will never open hurts deliverability for everyone else.
• One store-wide LTV number. It averages away the trend that tells you whether acquisition is getting better or worse.

Frequently asked questions

What is RFM analysis in ecommerce?

RFM analysis scores each customer on recency (days since last order), frequency (number of orders) and monetary value (total spend), usually 1 to 5 each, and groups the combinations into segments such as Champions, At risk and Lost.

How do I calculate customer lifetime value for an online store?

A simple formula is average order value × orders per year × gross margin × lifespan in years. For example, $62 × 2.4 × 0.55 × 2.5 = $204.60. Cohort LTV — cumulative margin per customer by first-order month — is more reliable for reporting.

Does Shopify do RFM segmentation?

Yes. Shopify's customer reports include RFM analysis that gives each customer a three-digit score, each digit 1–5, and places them in one of 11 groups. You can filter segments with the rfm_group attribute.

Which CRM has the best LTV reporting for ecommerce?

Klaviyo offers historic, predicted and total CLV once you have at least 500 customers with orders and 180 days of history. Shopify's own reports and Omnisend's Lifecycle Map are simpler options for smaller stores.

How many customer segments should a store have?

Start with eight RFM segments, each tied to one action, plus a few behaviour segments such as category bought and discount-only buyers. More segments than you can write distinct messages for add work without adding revenue.

How often should RFM scores be updated?

Continuously, from store data. Omnisend and Klaviyo both recalculate lifecycle stages and predictions automatically from new orders; a quarterly spreadsheet will always lag.

Can Scalry segment customers by Shopify purchase history?

No. Scalry has no Shopify or WooCommerce integration, so it cannot read store orders. Use Shopify, Klaviyo, Omnisend or a similar ecommerce tool for purchase-behaviour segments.