In this article

RFM Analysis and Customer Segmentation for E-commerce

13
mins read
Luca banner: RFM Analysis and Customer Segmentation for E-commerce

TL;DR

  • RFM analysis scores customers on recency, frequency, and monetary value, then groups them so each group gets its own message instead of one blast.
  • Set your recency window from your own median days between orders, not a generic 90 days, and use fixed bands for lumpy order counts.
  • Shopify scores 1 to 5 into 11 groups; Klaviyo scores 1 to 3 into 6 groups and needs 500+ ordering customers. Pick one system per decision.
  • Win back At risk and Previously loyal first, time second-order nudges to your repurchase clock, suppress Dormant, and stop discounting Champions.
  • Cohort analysis shows whether newer customers are weaker than older ones; RFM cannot, because recent customers score well on recency by default.
  • RFM ignores what customers buy. Category diversity can drive lifetime value more than frequency, and RFM inputs feed churn and CLV models.

RFM analysis scores every customer on three numbers: how recently they bought (recency), how often they buy (frequency), and how much they have spent (monetary value). Similar scores are then grouped into segments such as Champions, At risk, and Dormant, so each group gets its own message. Shopify and Klaviyo now both calculate RFM natively, but they score it differently [2][3].

Picture an operator who sells specialty coffee and brewing gear on Shopify. The store does about $90,000 a month, has 6,000 customers, and sends one Klaviyo campaign to the whole list every Thursday. Unsubscribes creep up each month. Her best customers get the same 15% code as people who bought one bag two years ago.

This guide is written for her. It covers how to score customers, what each segment means, what to send each one, and where RFM stops being enough. It sits inside our wider guide to predictive analytics for e-commerce, which covers the forecasting methods that build on it.

What is RFM analysis, and why does it still work for e-commerce?

RFM analysis scores each customer on recency (days since last order), frequency (number of orders), and monetary value (total spend), then groups similar scores into segments. It works because it uses only order data every store already has. It tracks what customers do rather than what they say. It tells you who to reward, who to win back, and who to stop emailing.

📬 The Thursday blast problem

Most small stores start with one list and one message. It feels efficient, because one campaign takes one afternoon. The cost shows up later, in unsubscribes, spam complaints, and discount codes handed to people who would have paid full price.

Kunle Campbell, in E-commerce Growth Strategy, describes Electronic Arts as an extreme version of this [1]. He writes that the company once spent about 22% of revenue sending every gamer the same marketing. A coffee store is not EA, but the logic scales down. Every identical send spends attention you cannot get back.

🔍 Three questions, three columns

RFM replaces the single list with three simple questions about each customer:

  • Recency: How many days since their last order? Fewer days usually means a warmer customer.
  • Frequency: How many orders have they placed? More orders signal a habit.
  • Monetary value: How much have they spent in total? This shows what they are worth to you so far.

Each answer becomes a score, usually 1 to 5. A customer scored 5-5-5 bought recently, buys often, and spends the most. A 1-1-1 customer bought once, long ago, and spent little.

🧠 Why behavior beats surveys

Campbell's book sums up the principle as paying attention to what people do, not what they say [1]. You need two facts per order: when it happened and how much it was worth. No quiz, no demographic data, and no extra tracking pixel.

That matters for a small team. Survey answers drift and depend on mood. Order history is already sitting in Shopify, and it does not lie about whether someone came back.

✅ What the score lets you decide

An RFM score is only useful if it changes a send. Here is what Luca AI's read is, after watching operators run this: a segment that does not change who gets which message is decoration. The three decisions RFM makes easy are:

  1. Who gets early access and no discount (your best, most recent buyers).
  2. Who gets a win-back flow before they go cold.
  3. Who you stop emailing, so your deliverability stays healthy.

Luca AI connects Shopify and Klaviyo and normalizes the order data on ingestion. That means the three RFM inputs are already clean when you ask, in plain English, which customers moved between segments this month. You still decide what to send. The difference is that the question takes a minute instead of an export.

How do you score recency, frequency and monetary value?

Customer F: 130 days since last order scores recency 3, 5 orders scores frequency 4, $460 spend scores 5, for RFM 345
Customer F spends heavily and buys often but has gone quiet, which a 345 score makes easy to spot.

Export every order, then compute days since last order, order count, and total spend per customer. Rank each measure and split it into five equal groups (quintiles), giving 5 to the best 20% and 1 to the worst. Recency is reversed: fewer days scores higher. Combine the digits into a score like 5-4-3. Stores under about 500 customers should use fixed thresholds instead.

🧾 The data you need

You need one row per customer with three numbers. Shopify's customer export already holds the last order date, order count, and amount spent. Before you score anything, clean three things:

  • Refunds: subtract fully refunded orders, or a returner looks like a Champion.
  • Zero-value orders: Klaviyo excludes orders with no positive value, such as 100% discount orders [3]. Do the same.
  • Test and staff orders: remove them, because they inflate frequency.

📊 Two ways to set the cutoffs

Quintiles split customers into five equal-sized groups per measure. Shopify uses this logic: a 5 means the customer is in the top 20% of that dimension for your store [2]. It adapts to your data automatically.

Fixed thresholds use cutoffs you choose, such as "3 or more orders scores high." Campbell offers useful starting points [1]:

  • Under about 4 months since the last order is recent for many industries.
  • Past about 12 months, you may treat the customer as churned.
  • About 3 purchases a year marks a frequent buyer for most brands.

⚠️ Frequency is lumpy

In most stores, a large pile of customers has exactly one order. Quintiles cannot split a pile of identical values, so frequency scores come out uneven. Klaviyo notes that customers with the same value get the same score, so groups are not equal [3]. I use fixed bands for frequency and quintiles for recency and spend.

⏱️ Set recency from your own repurchase clock

A mattress store and a coffee store cannot share a recency window. Campbell makes the same contrast between mattresses and chocolate [1]. Your own median days between first and second order is the right anchor.

Use the median, not the mean. Campbell's point is that the mean gets dragged by extreme values [1]. Here is an example for the coffee store, using seven customers' gaps between first and second order:

Set recency from your own repurchase clock
Gaps (days)MedianMean
21, 24, 28, 30, 33, 41, 1603048.1

One slow returner pulls the mean up by 18 days. Set "recent" from the median and the window stays honest. Luca AI can return this median from Shopify orders when you ask for it in plain English.

🧮 A worked example with 10 customers

This is an illustrative example. Recency and spend use quintiles (two customers per score). Frequency uses fixed bands: 1 order scores 1, 2 orders score 2, 3 orders score 3, 4 to 5 orders score 4, and 6 or more score 5.

A worked example with 10 customers
CustomerDays since last orderOrdersSpendRFMScore
A126$540555555
B253$210533533
C401$65411411
D704$380444444
E952$150323323
F1305$460345345
G1801$45211211
H2202$120222222
I3003$260134134
J4101$80112112

Customer F is the one to watch. F spends heavily and buys often, but has gone quiet for 130 days. Luca AI flags customers like F when their usual gap stretches, so you see the slide before the score drops.

Shopify scores 1 to 5 and Klaviyo scores 1 to 3: which RFM system should you use?

Shopify scores 1 to 5 into 11 groups; Klaviyo 1 to 3 into 6, needs 500+ customers; a 200-day customer gets recency 2 vs 1
Use Shopify to see your base and Klaviyo to trigger flows, since they can score one customer differently.

Shopify's RFM report scores each customer 1 to 5 per dimension, relative to your own store, and maps them into 11 groups [2]. Klaviyo scores 1 to 3, uses 180 and 365 day recency defaults, and maps 27 combinations into 6 groups [3]. Klaviyo needs at least 500 ordering customers and 180 days of history [3]. Use Shopify to see your base, and Klaviyo where a segment must trigger a flow.

🔀 Two tools, two labels for one customer

Most operators run both tools. Each one now has its own RFM model. The models disagree, and nobody tells you which to trust.

Luke Bean of Valente described a version of this pain in an interview with Luca AI [5]. His team migrated from Klaviyo to Bloomreach to get a single point of truth on the customer. He called the move expensive and difficult. A small store cannot afford that fix, so it needs a rule instead.

📐 How each one scores

How each one scores
-Shopify RFM customer analysisKlaviyo RFM analysis
Score scale1 to 5 per dimension [2]1 to 3 per dimension [3]
Recency methodRelative to your store (top 20% scores 5) [2]Fixed defaults: 180 and 365 days, editable [3]
Frequency and spendQuintiles of your store [2]33rd and 66th percentiles [3]
Groups11, from Champions to Prospects [2]6: Champions, Loyal, Recent, Needs attention, At risk, Inactive [3]
How groups formRecency plus FM, where FM = (F + M) / 2 rounded down [2]Each of 27 score combinations maps to one group [3]
MinimumsNone stated500+ ordering customers, 180+ days of orders, orders in last 30 days, some 3+ order customers [3]
PlanAnalytics reportsPaid Personalization or Advanced KDP add-on [3]
Where it actsCustomer segments with the rfm_group filterProfile properties used by segments and flows

⚖️ Why they disagree

Take a coffee customer whose last order was 200 days ago. Klaviyo's default puts that customer in recency 2, because it falls between 180 and 365 days [3]. Shopify might score the same customer 1 if most of your buyers ordered more recently [2]. Same person, two labels.

Neither tool is wrong. They answer different questions. Shopify's relative scale shows where a customer sits against your other customers. Klaviyo's fixed windows show whether a customer is inside a time limit you chose.

✅ The rule I would use

Pick one system of record per decision:

  • Sizing and reporting: Shopify, because its 5-point scale gives finer groups.
  • Sends and flows: Klaviyo, because its RFM properties update daily inside the tool that sends [3].
  • Below 500 customers: a spreadsheet, because Klaviyo's model will not run yet.

Operators who stitch tools together know this mismatch well. One G2 reviewer of Triple Whale described a related clash:

"Triple Whale will attribute more revenue to the email that was sent out, but the platform will attribute more revenue to the SMS that was sent out."
G2 reviewer, 4 stars, April 2023 Triple Whale - G2 Verified Review
"Some stats are not so accurate in pulling in data; they do not tally with shopify."
G2 reviewer, 4 stars, April 2023 Triple Whale - G2 Verified Review

Luca AI reads Shopify and Klaviyo data in one place. You can ask why a customer is Loyal in one tool and slipping in the other, without exporting either. The answer shows the raw dates and totals behind both labels, so you choose the rule, not the tool.

What are the 11 RFM segments, and what does each one tell you?

Shopify's 11 RFM groups are Champions, Loyal, Active, New, Promising, Needs attention, Almost lost, At risk, Previously loyal, Dormant, and Prospects [2]. Each group is defined by recency (R) and an averaged frequency-monetary score (FM). Champions have R of 5 and FM above 3. Previously loyal have R of 2 or lower with FM above 4. At risk and Previously loyal usually hold the most recoverable money.

🗺️ The full map

Shopify calculates FM as frequency plus monetary, divided by two, rounded down [2]. The group then depends on R and FM:

The full map
GroupRule (R, FM)What it tells you
ChampionsR = 5, FM above 3Recent, frequent, high spend. Your core.
LoyalR of 3 or 4, FM above 3Strong history, still fairly recent.
ActiveR of 4 or 5, FM above 1 and up to 3Recent and moderate. Room to grow.
NewR = 5, FM of 1 or lessJust bought, once or twice, low spend.
PromisingR = 4, FM of 1 or lessRecent but light. Second order not yet made.
Needs attentionR = 3, FM = 3Average on everything and starting to cool.
Almost lostR = 3, FM of 2 or lessCooling and never very valuable.
At riskR of 2 or less, FM above 2 and up to 4Was decent, now gone quiet.
Previously loyalR of 2 or less, FM above 4Was one of your best. Now absent.
DormantR of 2 or less, FM of 2 or lessOld, light, and unlikely to return.
ProspectsNo orders yetSubscribed or registered, never bought.

Source: Shopify Help Center group definitions [2].

🧮 Our 10 customers, placed

Using the worked example from Q2, here is where each customer lands:

  • Champions: A (R 5, FM 5).
  • Loyal: D (R 4, FM 4) and F (R 3, FM 4).
  • Active: B (R 5, FM 3).
  • Promising: C (R 4, FM 1).
  • Almost lost: E (R 3, FM 2).
  • At risk: I (R 1, FM 3).
  • Dormant: G, H, and J.

Customer F sits in Loyal today with a recency of 3. One more quiet month could push F toward At risk, which is the move worth catching.

💸 Where the money sits

Campbell's guidance maps neatly onto these groups [1]. High-value customers deserve perks and invitations to advocate. Lapsed but frequent customers are ripe for win-back flows. Lapsed customers who were never frequent should generally be left alone.

In Shopify's map, that makes Previously loyal and At risk the priority. They already proved they will buy. Dormant is the group to suppress, not chase.

👀 Watch movement, not the snapshot

A single month's group sizes tell you little. The signal is flow between groups. If Champions shrink while Previously loyal grows, your best buyers are leaving, even if revenue looks fine.

Glew users describe the same need from a different tool:

"It also allows you to segment and export customer data based on purchase frequency, product, and lifetime value."
G2 reviewer, 3.5 stars, September 2019 Glew - G2 Verified Review

Luca AI watches these group sizes over months and sends an alert when one moves outside its usual pattern. A slide from Champions into Previously loyal shows up in Slack or email before it shows up in revenue. You decide what to send; Luca AI makes sure you see the shift in time.

What should you send each RFM segment?

Reward Champions and Loyal customers with early access and referral asks, not discounts. Send New and Promising customers a second-purchase flow timed to your median repurchase day. Run win-back flows for At risk and Previously loyal customers. Suppress Dormant customers from regular campaigns to protect deliverability. Klaviyo's 2017 benchmark found highly segmented campaigns earned $0.19 per recipient against $0.06 for unsegmented ones [4].

💰 Why segmenting pays before you write a word

Klaviyo analyzed over 2.5 billion emails sent by US customers in the last quarter of 2017 [4]. Highly segmented lists returned more than three times the revenue per recipient. Unsegmented campaigns also had about twice the unsubscribe rate.

That data is old, and it is Klaviyo's own. Treat it as direction, not a promise. Luca AI's read is that the gap is real but smaller today, because inbox providers now punish low engagement harder than in 2017. Either way, the cost of blasting everyone has gone up, not down.

📋 The segment playbook

The segment playbook
SegmentGoalWhat to sendDiscount?
ChampionsKeep and amplifyEarly access, new product previews, referral ask, review requestNo
LoyalMove up to ChampionsBundles, cross-category picks, loyalty perksRarely
ActiveBuild the habitReplenishment reminders, how-to contentSmall, if any
NewEarn order twoWelcome series, then a second-order nudge at your median dayOne modest offer
PromisingEarn order twoSame as New, with social proofOne modest offer
Needs attentionRe-engage early"Still brewing?" check-in, best-sellersLight
Almost lostLast cheap tryOne short win-back, then lower frequencyLight
At riskWin backWin-back flow, personal note, what is newYes, measured
Previously loyalWin back hardWin-back flow, founder note, a reason to returnYes
DormantProtect the listSuppress from campaigns; one sunset emailNo
ProspectsFirst orderBrowse and cart flows, first-order offerYes

🏆 Reward without training discount habits

Champions are the group most stores over-discount. They already buy at full price. A 15% code teaches them to wait for the next one.

Campbell's guidance is to treat high-value customers with exclusive perks and give them chances to advocate for the brand [1]. For the coffee store, that is first access to a limited single-origin lot. It costs margin on nobody who would have paid anyway.

⏰ Time the second order to your own clock

New and Promising customers decide whether they become regulars. Time the nudge to your median gap between orders, which was 30 days in the Q2 example. A reminder at day 25 lands before the bag runs out.

Campbell describes how Doe Lashes used a short quiz to ask first-time visitors if they were new to false lashes [1]. The answers shaped follow-up emails that taught newcomers how to apply them. RFM cannot tell you a buyer is new to your category. A one-question quiz can.

🔁 Win-back and suppression

At risk and Previously loyal customers already proved they will pay. Campbell calls lapsed but frequent customers ripe for win-back flows [1]. Start with a plain note and what is new. Add an offer only in the second or third email.

Dormant customers are different. Campbell advises generally avoiding lapsed customers who were never frequent [1]. Keep sending to them and your open rates fall, which hurts inbox placement for everyone else. Send one sunset email, then suppress.

⚠️ Automate most of it

Campbell reports that automated email series were just 1.8% of sends in 2020 but drove almost 30% of email revenue [1]. He suggests about 80% of messaging should be automated sequences or transactional messages, and about 20% campaigns [1]. RFM segments are the triggers that make that split possible.

Luca AI can send a weekly report of flow revenue by RFM group, with the reasoning behind any change. That shows whether win-back is recovering At risk customers or just discounting people who would have returned anyway. You read it Monday and decide which flow to adjust.

How do you build RFM in a spreadsheet, or inside Shopify and Klaviyo?

In a spreadsheet, export customers with last order date, order count, and amount spent, then use PERCENTRANK to assign 1 to 5 per column. In Shopify, open Analytics, then Reports, then RFM customer analysis, and build segments with the rfm_group filter [2]. In Klaviyo, open RFM analysis under customer insights and create segments from it [3]. A spreadsheet goes stale the day you build it, so plan a monthly refresh.

📄 Path 1: The spreadsheet build

This works for any store, including those below Klaviyo's 500-customer minimum [3]. It takes an afternoon the first time.

  1. Export customers from Shopify. Keep customer ID, last order date, total orders, and amount spent.
  2. Add days since last order. In Google Sheets: =TODAY()-C2, where column C holds the last order date.
  3. Score recency (reversed). =MIN(5,1+FLOOR((1-PERCENTRANK.INC(D$2:D$6001,D2))*5)). Fewer days gives a higher score.
  4. Score spend. =MIN(5,1+FLOOR(PERCENTRANK.INC(F$2:F$6001,F2)*5)).
  5. Score frequency with bands. =IFS(E2>=6,5,E2>=4,4,E2=3,3,E2=2,2,TRUE,1).
  6. Join the digits. =G2&H2&I2 gives a score like 534.
  7. Map to groups. Add FM as =FLOOR((H2+I2)/2) and apply the Shopify rules from Q4.

Change the ranges to match your row count. PERCENTRANK.INC returns each value's position from 0 to 1, so multiplying by five gives the quintile.

🛍️ Path 2: Shopify's native report

  1. Go to Analytics, then Reports, and filter the category to Customers [2].
  2. Open RFM customer analysis. Each group shows its share of customers, days since last order, orders, and spend.
  3. Click a group. Choose View report for the customer list, or Preview segment to open the segment editor.
  4. In Customers, then Segments, combine rfm_group with other filters, such as email subscription status.

Shopify does not show individual RFM scores in the admin, only the group [2]. That is fine for targeting but limits analysis.

📧 Path 3: Klaviyo's RFM analysis

  1. Check the minimums: 500+ ordering customers, 180+ days of history, and orders in the last 30 days [3].
  2. Open RFM analysis under customer insights (the menu path depends on your plan).
  3. Use the RFM segments card to create segments, or pick the RFM profile property when building a segment.
  4. Use those segments to trigger flows. The properties update daily [3].

⚠️ The reporting trap

The spreadsheet is fine for a first pass. It becomes a problem as a weekly ritual. Richie Jones of VAST told Luca AI that, in the early days, most of the business was tied up in Excel reports built from Shopify and returns exports [6].

Operators on Reddit and G2 say the same about native exports:

"Even on higher plans, Shopify doesn't really offer automated scheduled exports by itself."
Reddit user, r/shopify Reddit Thread
"Being able to pull this into a .csv file is great too, so I can manipulate the data even further."
G2 reviewer, 5 stars, June 2023 Glew - G2 Verified Review

Luca AI replaces the monthly export. Ask for this month's RFM groups and which customers moved, and it answers from live Shopify data. The score logic stays yours; the copy-and-paste goes away.

What does cohort analysis show that RFM cannot?

Cohort tailwind: 30% of 4,000 is 1,200, 10% of 3,000 is 300, 5% of 2,000 is 100, so 1,600 returning buyers
Cohort return rates tell you how many buyers come back next year before you spend a dollar on ads.

Cohort analysis groups customers by when they first bought and tracks how many return over time. RFM shows where each customer stands today. Cohorts show whether this year's customers behave better or worse than last year's. One operator Luca AI interviewed sees about 30% of last year's buyers buy again this year, 10% of buyers from two years back, and 5% from three [7].

📅 What a cohort is

A cohort is a group of customers who share a start date, usually the month of their first order. You then track what share of each cohort comes back after 30, 60, and 90 days. The result is a triangle, because newer cohorts have less history.

Here is an illustrative example for the coffee store:

What a cohort is
First-order monthCustomersRepeat by day 30Repeat by day 60Repeat by day 90
January40018%27%33%
February45017%25%31%
March52015%22%Not yet
April61012%Not yetNot yet

🔎 How to read it

Read down each column. If repeat rates fall as cohorts get larger, your newer customers are weaker. In this example, April's 30-day repeat rate (12%) is well below January's (18%). That often means acquisition is pulling in bargain hunters, even while revenue grows.

RFM would not show this. April's customers are recent, so many score well on recency today. The cohort view shows they are not coming back at the same rate.

📈 The tailwind math

The 30%, 10%, and 5% pattern above is what that operator called the tailwind of the business [7]. It tells you how much revenue arrives next year before you spend a dollar on ads.

Here is an illustrative calculation. Say 4,000 people bought last year, 3,000 the year before, and 2,000 the year before that:

  • 30% of 4,000 = 1,200 returning buyers
  • 10% of 3,000 = 300 returning buyers
  • 5% of 2,000 = 100 returning buyers
  • Total: 1,600 returning buyers to plan around

📊 What strong looks like

Luke Bean of Valente shared his own cohort numbers with Luca AI [5]. About 20% of new customers make a second purchase within 30 days. He said that by 12 months, roughly 65 to 75% have made multiple purchases. That is one brand, not a benchmark, but it shows what a strong repeat business can reach.

⚠️ The COVID distortion

The same operator who shared the tailwind numbers warned that COVID broke the pattern [7]. Customers acquired during COVID decayed at different rates, which made forecasting hard afterward. If your 2020 and 2021 cohorts look odd, exclude them from the averages you plan with.

"The retention and segmentation features have been very useful."
G2 reviewer, January 2018 Mixpanel - G2 Verified Review

Luca AI keeps cohort-level vigilance without a cohort-level dashboard. It can flag when a new month's 30-day repeat rate falls below earlier cohorts, and explain which channels or products drove the drop. You decide whether to change the offer or the ad spend.

RFM vs cohorts vs predictive segments: which should you use when?

Use RFM to decide who gets which message this week. Use cohort analysis to judge whether acquisition quality is improving and to forecast next year's returning revenue. Use predictive segments, such as churn probability or predicted lifetime value, once you have enough order history for a model to beat simple rules. Stores under 500 customers should run RFM in a sheet first and review cohorts quarterly.

⚖️ The decision table

The decision table
-RFMCohort analysisPredictive segments
Question it answersWho should get which message now?Are newer customers better or worse?Who will buy or leave next, and how much will they spend?
Data neededOrder dates and amountsFirst-order date plus repeat orders12+ months of orders, ideally more signals
UnitOne customerA group by start monthOne customer
RefreshMonthly, or daily in toolsMonthly or quarterlyWeekly or monthly
Best forSends, offers, suppressionAcquisition quality, forecastingBudget and retention spend
Weak spotLooks backwardHides individualsNeeds enough data to trust

🌱 Match the method to your stage

Campbell relays advice from Ivan Mazour that early brands should put budget into acquisition until they have a real list [1]. Mazour also notes that a few hundred visitors a day is not enough for accurate A/B tests [1]. The same applies to segmentation software. Below a few hundred customers, segments are too small to learn from.

For the coffee store with 6,000 customers, the order is clear. Run RFM monthly. Review the cohort table each quarter. Add predictions only when a decision depends on them, such as how much to spend on win-back.

🎯 Choose segments that change what you do

April Dunford, in Obviously Awesome, argues that useful segments are built on traits you can actually spot, not broad demographics [8]. In her view, focus belongs on buyers who care most about what you do better than others, and the group must be large enough to matter. That is a positioning idea, but it applies here. An RFM segment only earns a flow if it is identifiable and big enough to pay back.

❌ What none of these replace

Campbell also warns that multi-touch attribution is not customer journey tracking [1]. Attribution credits clicks to campaigns. RFM, cohorts, and predictions describe customers. Keep them separate in your head and in your reports.

Luca AI fits stores with enough history to reason against, and not stores below that line. For those that qualify, it runs RFM, cohort, and predictive questions from the same connected Shopify and Klaviyo data, so the three views never disagree on the underlying orders.

What does RFM miss about your best customers?

RFM counts orders and dollars but ignores which products were bought. Two customers with identical scores can be worth very different amounts next year. Anthony Mink of Live Bearded ran cohort analyses and found product-category diversity was the leading driver of lifetime value: customers who added body care rose about 50 to 100% in lifetime value [9]. Add a category-count column next to your RFM score.

🧔 The common view, and the surprise

Most retention advice says the same thing. Get customers to buy more often. Launch new products. Push the hero item again.

Anthony Mink, who runs Live Bearded, believed that too. In an interview with Luca AI, he described running four or five cohort analyses with Claude Code on his store data [9]. The result surprised him:

"I would have never thought product category diversity was the leading driver of lifetime value."
Anthony Mink, Live Bearded, interview recorded by Luca AI [9]

He found that customers who bought body care jumped about 50 to 100% in lifetime value. Adding apparel and accessories lifted it again [9]. His team rebuilt their post-purchase sequence around one goal: moving single-category buyers into a second category.

💡 Why RFM hides this

In RFM, a beard-oil buyer with four orders and a buyer with four orders across oil, wash, and a hat score the same. Same recency, same count, maybe the same spend. Mink's data says they are not the same customer.

Luca AI's read is that this is the most common blind spot in RFM programs we see. The score tells you who to email. It does not tell you what to put in front of them.

📉 The trend inside the score

There is a second blind spot. RFM is a snapshot, so it misses direction. Campbell describes work by Peter Fader, a Wharton marketing professor, on site visits [1]. A customer with high baseline visits whose visits are falling was less likely to convert. A low-visit customer whose visits were rising was more likely to convert.

Two customers in the same segment can be heading in opposite directions. The segment label will not tell you which is which.

✅ What to add to your sheet

Add three columns next to the RFM score:

  1. Categories bought: count of distinct product categories per customer.
  2. Last gap vs usual gap: days since last order divided by the customer's own median gap. Above 1.5 means they are late.
  3. First product: the item in the first order, which often predicts what they buy next.

A Loyal customer with one category is your cross-sell list. A Champion whose last gap is twice their usual is an early warning.

Operators feel the limits of fixed reports here:

"It lacks the ability to draw out specific metrics for more detailed dive through."
G2 reviewer, 4 stars, April 2023 Triple Whale - G2 Verified Review

⚠️ Too many reports is its own problem

Mink also described the other side. His AI analysis produced about 20 executive summaries, each roughly 25 pages long [9]. The insight was there, but he was left asking how to act on it. More analysis is not the goal. One clear next move is.

Luca AI can answer "what is lifetime value for customers who bought from two or more categories versus one" directly against Shopify orders. It returns the numbers and the reasoning in one reply, not a 25-page summary. You decide which cross-category flow to build.

How do you move from RFM to churn and CLV predictions?

RFM test on last year's snapshot: 18 of 200 At risk customers reordered within 90 days (9%) vs 135 of 300 Loyal (45%)
If your RFM groups separate like this, they already work as a rough churn signal before you buy a model.

Recency, frequency, and monetary value, plus how long each customer has been with you, are the exact inputs of classic customer lifetime value (CLV) models such as BG/NBD with Gamma-Gamma [10][11]. RFM sorts customers by what already happened. A predictive model estimates how likely each one is to buy again and how much they will spend. Before trusting any model, check that your At risk segment really does churn faster than Loyal.

🔬 Same inputs, different question

In 2005, Peter Fader, Bruce Hardie, and Ka Lok Lee published the BG/NBD model [10]. It predicts how many future purchases a customer will make. It uses three numbers per customer: repeat purchases, the time of the last purchase, and the customer's age with you.

The same authors linked RFM directly to CLV in a 2005 paper in the Journal of Marketing Research [11]. A companion model, Gamma-Gamma, estimates average order value from past spend. Together they turn an RFM table into a predicted dollar value per customer.

🔁 What changes when you predict

What changes when you predict
-RFM segmentPredictive score
OutputA label, such as At riskA probability or a dollar figure
Time frameWhat happened so farWhat is likely next
ExampleCustomer F is LoyalCustomer F has a 40% chance of ordering in 90 days
Best useChoosing the messageChoosing how much to spend on a customer

The 40% figure is illustrative. It shows the kind of output a model gives, not a benchmark.

🧪 Test before you trust

Do not buy a churn model until you have tested your RFM groups. Here is a simple test using last year's data:

  1. Take a snapshot of your RFM groups from a date one year ago.
  2. Count who in each group ordered in the following 90 days.
  3. Compare the rates.

An illustrative result: 18 of 200 At risk customers reordered (9%), while 135 of 300 Loyal customers reordered (45%). If your groups separate like this, RFM is already working as a rough churn signal. If they do not, fix your scoring windows first. A model trained on badly scored data will just be confidently wrong.

💸 When the model is worth it

Prediction earns its keep when it changes a budget. For example, it can set how much to spend winning back a Previously loyal customer, or cap ad spend at predicted lifetime value. If the score will not change a send or a spend, stay with RFM.

Ari Tulla, founder of ELO Health, told Luca AI his company spent about $10 million building systems to turn data into meaning [12]. He said large language models then did the job far better. Most stores should not build this from scratch.

🧭 Where this goes next

Churn probability and predicted CLV are the next layer of the same customer data. Start with the RFM groups you trust, then let a model refine the ones where money is at stake.

Luca AI runs churn and lifetime value questions on the Shopify and Klaviyo data you already connected. There is no data team and no custom build like the one ELO Health paid for. You ask which Loyal customers look likely to lapse this quarter, and it returns the list with the reasoning behind each.

References

  1. Kunle Campbell, E-commerce Growth Strategy (book). RFM principle, recency and frequency thresholds, median repurchase interval, segment actions, automation share, Doe Lashes and Electronic Arts examples, and Peter Fader's visit-frequency finding.
  2. Shopify Help Center, "Customers reports: RFM customer analysis." https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/customers-reports
  3. Klaviyo Help Center, "Understanding scoring and customer groups in the recency, frequency, and monetary analysis (RFM) report." https://help.klaviyo.com/hc/en-us/articles/17797937793179
  4. Klaviyo, "Segmentation benchmark report," US emails sent October 1 to December 31, 2017. https://www.klaviyo.com/marketing-resources/segmentation-benchmark-report
  5. Luke Bean, Valente, interview recorded by Luca AI.
  6. Richie Jones, VAST, interview recorded by Luca AI.
  7. Luca AI operator interview on multi-year cohort retention, recorded by Luca AI.
  8. April Dunford, Obviously Awesome (book), on segmentation and positioning. Paraphrased, not quoted.
  9. Anthony Mink, Live Bearded, interview recorded by Luca AI.
  10. Peter S. Fader, Bruce G. S. Hardie, and Ka Lok Lee, "Counting Your Customers the Easy Way: An Alternative to the Pareto/NBD Model," Marketing Science 24(2), 2005. https://doi.org/10.1287/mksc.1040.0098
  11. Peter S. Fader, Bruce G. S. Hardie, and Ka Lok Lee, "RFM and CLV: Using Iso-Value Curves for Customer Base Analysis," Journal of Marketing Research 42(4), 2005. https://doi.org/10.1509/jmkr.2005.42.4.415
  12. Ari Tulla, ELO Health, interview recorded by Luca AI.

FAQ's

Monthly is the right default for most Shopify stores. RFM scores shift as customers order or go quiet, and a score that is three months old will send win-back emails to people who already came back.

  • Inside Shopify or Klaviyo: the groups refresh on their own. Klaviyo updates its RFM profile properties daily, so flows always act on the latest group.
  • In a spreadsheet: re-export and re-score once a month, on the same day each month, so the changes are comparable.
  • After big promotions: re-score once the sale ends. A Black Friday spike can push one-time bargain buyers into Active or New.

We also recommend keeping last month's scores beside this month's. The movement between groups is the real signal. If Champions shrink while Previously loyal grows, your best buyers are drifting, even if revenue looks fine.

Luca AI removes the monthly export step. It reads live Shopify and Klaviyo data, so you can ask which customers changed groups since last month and get the list with the reasoning. Our guide to automated e-commerce reporting covers how to schedule that as a weekly or monthly report instead of a manual task.

RFM starts to earn its keep once you have a few hundred customers with orders, and it works best above about 500. Below that, each segment holds too few people to learn from, and one customer can swing a whole group.

  • Under a few hundred customers: spend on acquisition first. Segmenting a tiny list rarely changes what you send.
  • A few hundred to 500: run RFM in a spreadsheet with fixed thresholds instead of quintiles, so groups stay stable.
  • 500 and up: Klaviyo's native RFM model becomes available. It needs at least 500 ordering customers, 180 days of history, and orders in the last 30 days.

History matters as much as headcount. A store with 2,000 customers who all bought in the last two months has no real recency spread yet. Give it at least six months.

Luca AI is built for stores with enough order history to reason against, and we say so plainly. If you are below that line, a spreadsheet and the Shopify analytics basics will serve you better than any paid segmentation tool.

No. They use the same raw data but answer different questions.

  • RFM analysis describes the past. It ranks each customer by how recently they bought, how often, and how much, and puts them in a segment.
  • Customer lifetime value (CLV) is the total revenue or profit a customer brings over the whole relationship. Historical CLV adds up what they already spent. Predicted CLV estimates what they will spend next.

The link between them is close. Academic CLV models such as BG/NBD with Gamma-Gamma take recency, frequency, monetary value, and customer age as their inputs. So a clean RFM table is the first step toward predicted CLV.

In practice, we use RFM to decide which message a customer gets this week, and CLV to decide how much we can afford to spend keeping or winning them. Mixing the two up leads to errors, such as spending heavily on a win-back for a customer who was never worth much.

Luca AI calculates both from the same connected Shopify orders, so the segment and the value number never disagree on the underlying data. For the full picture of how lifetime value works, see our guide to e-commerce customer lifetime value.

Yes, but you have to change the windows. Standard RFM assumes customers choose when to reorder. Subscriptions and rare purchases break that assumption in different ways.

  • Subscriptions: recency and frequency are set by the billing cycle, so active subscribers all look alike. Score one-off orders separately, and track churn monthly for the subscription itself.
  • Rare purchases: a mattress store and a coffee store cannot share a recency window. Set yours from your own median days between orders, not a blog's default.
  • Mixed catalogs: if you sell both a durable item and refills, score the refill behavior. That is where the repeat habit lives.

For long-cycle products, monetary value and the first product bought often matter more than frequency. A customer who bought a high-end grinder once may be worth more than one who bought three sample packs.

Luca AI can return your median repurchase interval by product category in one question, which tells you which window fits each part of your catalog. Our guide to customer retention strategies for e-commerce covers what to do once the right customers are found.

Start with At risk and Previously loyal. These customers have already proven they will buy, they have recently gone quiet, and a win-back email costs almost nothing compared with acquiring a new customer.

  • First: a win-back flow for At risk and Previously loyal, opening with what is new and adding an offer only in a later email.
  • Second: a second-order flow for New and Promising customers, timed to your median repurchase day.
  • Third: suppress Dormant customers from regular campaigns to protect deliverability.
  • Fourth: early access and referral asks for Champions, without discount codes.

We put Champions last on purpose. They are already buying, so the risk there is over-discounting, not losing them. The money you can recover this month sits in the groups that are slipping.

Measure each flow by revenue per recipient against a holdout group that receives nothing. That shows whether the flow recovers customers or just discounts people who would have returned anyway.

Luca AI can report flow revenue by RFM group every week, with the reasoning behind any change. For a broader view of who your customers are, read our guide to e-commerce customer segmentation.

Enjoyed the read? Join our team for a quick 15-minute chat — no pitch, just a real conversation on how we’re rethinking Ecommerce with AI - Luca

Loading Schedule...

Your AI Co-Founder is here.

Here’s why:
Shopify, Meta, Xero - one brain.
"Should I scale?" Answered with real data.
Growth capital. No applications. One click.
Thank you! Your submission has been received! Please book a time slot for the Meeting
Oops! Something went wrong while submitting the form.