BRUTAL MARKETING

RFM ANALYSIS FOR ECOMMERCE: SEGMENTS, FORMULAS & PLAYBOOKS

2026
BRUTAL MARKETING

RFM Analysis for Ecommerce: Segments, Formulas & Playbooks

2026

RFM Analysis for Ecommerce: How to Segment Customers and Stop Wasting Budget on One-Size-Fits-All Campaigns

20–25% of an online store's customers bring in roughly 80% of its revenue. That's not a textbook formula. It's the pattern we see every time we open a client's CRM at Brutal Marketing. The rest of the base is made up of one-time buyers, dormant contacts and people who already shop with your competitors. And the store sends all of them the same email with the same discount.

That's where the marketing budget leaks.
Serhii Ponomarenko. RFM Analysis for Ecommerce: Segments, Formulas & Playbooks | Brutal Marketing blog
Serhii
Ponomarenko
The cause isn't expensive traffic or a weak product. The cause is that you don't know who you're talking to. It could be a loyal buyer you should reward without a discount, or someone who left long ago and needs a completely different approach.

RFM analysis solves exactly this. Below you'll find how to calculate RFM in a spreadsheet in one evening and how to set thresholds for your niche. You'll also see which 8 segments to look for, what to do with each one, and how to move the whole logic into your CRM so it runs without manual work. With numbers from our projects.

What RFM Analysis Is and Why Behavior Beats Demographics

Most online stores segment customers by gender, age, location or product category. That makes sense for targeting cold audiences. For working with your existing customer base, it's almost useless.

A 35-year-old woman from Chicago might be your best customer with 12 orders a year. Or she might have bought once two years ago and never come back. Demographics won't tell you the difference. Behavior will.

RFM is a customer segmentation method built on three behavioral metrics:
  • Recency — how many days have passed since the last purchase.
  • Frequency — how many orders the customer placed during the chosen period.
  • Monetary — how much the customer spent during that same period.

Each customer gets a score for each metric, usually from 1 to 5. Together, the three scores form an RFM code. A 5-5-5 is a champion: bought recently, often and for a large amount. A 1-1-1 is a random or long-lost buyer.

A 1–5 scale gives you 125 possible combinations in theory. Nobody can run 125 separate groups, so you merge them into 8–11 segments with clear business logic. Below we'll walk through the eight we use most often.

In our experience at Brutal Marketing, the calculation is the easy part. The hard part is choosing the right thresholds, reading the results correctly and building a separate communication playbook for each segment. That's where most attempts fall apart.
What RFM Analysis Is and Why Behavior Beats Demographics | RFM Analysis for Ecommerce: Segments, Formulas & Playbooks – Brutal Marketing

What Data You Need and Why a Messy CRM Breaks Everything

Three fields are enough: customer ID, order date and order amount. If your data lives in a CRM, the export takes a few minutes.

The real problem lies elsewhere. RFM tells the truth only when your system records every purchase. In audits, we keep seeing the same picture. Some orders come through the website, some through Instagram DMs, some through WhatsApp, and others through a marketplace or an in-store POS. Each channel lives in its own silo. A customer who bought five times across different channels turns into five one-time buyers in your calculation.

Before launching RFM, we always check the base against a short list:
  1. Duplicate contacts. One customer with two emails or two phone numbers counts as two separate "buyers." Merge records by email and phone.
  2. Cancelled and refunded orders. Exclude them, or they'll inflate F and M.
  3. Open deals. Orders still "in progress" shouldn't count as purchases.
  4. Channels without integration. Everything sold outside the CRM has to land there, through an integration or at least manually.
  5. A single identifier. Email is usually the most reliable one for online stores, with phone number as a backup.

This check takes anywhere from an hour to a few days, depending on the state of your data. It saves weeks of wrong decisions.

If leads from messengers still get lost between chats, start by bringing all messenger conversations into a single customer card. The same goes for social selling: make sure Instagram Direct leads flow straight into your CRM.

How to Calculate R, F and M: Thresholds, Scales and Pitfalls

Recency: Time Since Last Purchase

The fewer days since the last purchase, the higher the score. A customer who bought three days ago is more likely to buy again than someone who last visited a year ago.

Thresholds depend on the repeat purchase cycle in your niche. For a cosmetics store, a "fresh" customer bought within the last 30 days. For a furniture store, these boundaries shift by years.

Sample scale for a store with a purchase cycle of about two months:
Don't guess your cycle. Calculate the median gap between the first and second purchase for customers with at least two orders. That's your real cycle, and your thresholds should start from it.

Benchmarks from our projects (validate them against your own data):

Frequency: How Often They Buy

Here you count orders over a period, usually 12 months. A customer with 10+ orders a year behaves in a fundamentally different way from someone who bought once or twice.

Most guides skip this pitfall: the quintile method often fails for F. Quintiles split your base into five equal groups. But in a typical online store, 50–65% of customers have exactly one order. You can't split them into equal fifths. Half of your base ends up with the same score, and segment boundaries blur.

That's why we recommend fixed thresholds for frequency:
Don't confuse frequency with average order value. A customer who buys often in small amounts is one profile. A customer who buys rarely but spends big is another.

Monetary: Customer Value

Use total spend over the period, not average order value. A customer with 12 orders at $20 each ($240 a year) is worth more to your business than a customer with one $120 order. That holds even though the first customer's average order is six times smaller.

If your CRM stores cost data, calculate M on gross profit rather than revenue. You'll see why this matters in the section on common mistakes.

Quintiles or Fixed Thresholds: Which to Choose

Our practice: fixed thresholds for R and F, quintiles for M.

RFM Analysis in Excel or Google Sheets: Step by Step

Many teams stop before they start because they think RFM is technically complex. In reality, a first calculation for a base of up to 10,000–20,000 customers takes one evening in a spreadsheet.
  1. Export your orders. Three columns: customer ID (A), order date (B), order amount (C). Remove cancelled and refunded orders right away. Shopify, WooCommerce and most CRMs let you export this in a few clicks.
  2. Pick a period. Usually 12 months. For seasonal products, take 24 to capture several cycles. The reference point for recency is the calculation date.
  3. Build a list of unique customers on a separate sheet, using the UNIQUE function (available in Google Sheets and Excel 365) or a pivot table.
  4. Calculate three metrics for each customer (customer ID in column E):
  • last purchase date: =MAXIFS(B:B, A:A, E2), days since purchase: =TODAY()-F2;
  • number of orders: =COUNTIFS(A:A, E2);
  • total spend: =SUMIFS(C:C, A:A, E2).
  1. Assign scores. For R and F, use a threshold table with XLOOKUP (or VLOOKUP with approximate match). For M, use percentiles: =MAX(1, ROUNDUP(PERCENTRANK.INC($I$2:$I$5000, I2)*5, 0)). Depending on your locale, the argument separator may be a semicolon instead of a comma.
  2. Build the RFM code with =J2&K2&L2. You'll get something like "545."
  3. Assign segments using the table in the next section. A pivot table works well here: R in rows, F in columns, customer counts in cells, plus color formatting. This "map" shows the health of your base in a minute.
  4. Push segments into your CRM as a tag or a dedicated field. From there, you can filter the base, launch sequences and assign tasks to your team.

Once you pass 20,000–50,000 customers, or want to recalculate RFM daily, the spreadsheet becomes a bottleneck. At that point, an SQL query against your store database or a Python script with pandas does the job in seconds.

8 RFM Segments: Who's Who in Your Customer Base

Once every customer has three scores, you can sort the base into segments. Here are the eight we use most often. The boundaries are guidelines, so adapt them to your niche.
If a customer fits two segments, the one higher in the table takes priority. Customers who fit none (for example, R3 F1) go into a "Needs attention" group and receive your standard campaigns.

Playbooks for Each Segment: What to Actually Do

Knowing who sits in which segment is half the job. The other half is giving each segment its own mechanics, channel and contact frequency.

Champions → Retain and Amplify

No blanket discounts. These people buy anyway, so a discount just cuts your margin. Instead, offer early access to new products, a personal message from the founder or an account manager, a private club or a referral program. Champions are your best source of referrals and reviews.

One of our clients created a private WhatsApp group for champions with exclusive offers. It converted at 34%, compared with 4% for regular email campaigns. We break down how to build mechanics like this in our WhatsApp sales funnel examples with CRM.

Loyal Customers → Grow Average Order Value

Upsell and cross-sell work best here. Look at what the customer buys regularly and offer a logical add-on. If they keep ordering dog food, suggest supplements, treats or accessories.

A triggered sequence in your CRM after each purchase handles this with zero manual effort. For ideas on building offers from order history, see our guide on personalization in subscription messaging.

Potential Loyalists → Lock In the Habit

This segment needs onboarding: three or four touchpoints in the month after the second purchase. Share useful content on how to get the most out of the product. Send a personal product selection based on their history. Ask for a review. Offer a small bonus for the third order.

The goal is to bring the customer back before they forget you. In our observation, customers churn far less often after their third purchase, so make that third order the target.

New Customers → Don't Lose Them in the First 30 Days

In the customer bases we work with, about 60% of buyers never return after their first order. Most of them aren't unhappy. Nobody reminded them. A simple three-message sequence in the first three weeks after the order retains 15–25% of them.

Basic flow:
  1. Day 1–2: order confirmation, shipping status and a tip on how to use the product.
  2. Day 7–10: a review request and a hint on what pairs well with the purchase.
  3. Day 18–21: a personal product selection or a time-limited bonus on the second order.

For a step-by-step build, see our guide to the automated welcome email series.

At Risk → Win Them Back Before It's Too Late

This is your most urgent segment. When a customer who ordered every two months suddenly goes silent for three, that's no accident. These people already know your product and trust you, so reactivation pays off best here.

An aggressive promo code shouldn't be your first move. A call or message from a team member asking "Was everything okay with your last order?" beats any automated email. It also often uncovers a service issue you didn't know about. To make sure nobody forgets these contacts, let the CRM create the task automatically. We cover this in our guide to sales department automation.

Hibernating → Reactivate Only Above the Break-Even Point

Before you invest in a win-back, run the numbers (see the next section). For hibernating customers with a high M score, we recommend personal outreach: a short messenger note with no template language.

"Hi Alex, you last ordered from us in March. We've refreshed our range, and I think you'll like what's new." In our projects, this approach converts at 8–14%, three to four times better than a mass campaign. For the rest of the segment, run a re-engagement email campaign with offers that escalate step by step.

One caveat for SMS and WhatsApp: check that you have marketing consent before you hit send. Rules differ by country, and regulations like GDPR in the EU and the TCPA in the US set strict requirements.

Big One-Timers → Personal Outreach

Few orders, long ago, but a meaningful amount. Often it's a single large purchase: electronics, a gift, furnishing a new home. Automation loses to human contact here.

A call from your team with a specific offer, such as servicing, accessories or an upgraded model, brings these customers back better than any campaign. One returning big spender can be worth more than a dozen reactivated hibernating customers.

Lost → Minimize Spend

One small order, long ago. Reactivation costs a lot and rarely pays off.

Remove this segment from active campaigns. That cuts unsubscribes and spam complaints, which improves email deliverability for the rest of your base. Keep one or two low-cost reminders per quarter.

Win-Back Economics: When Reactivation Actually Pays Off

The most expensive mistake with hibernating customers is spending money on win-backs that won't even cover the cost of contact. One formula tells you whether it's worth it:

Cost per win-back = cost per contact ÷ conversion rate

Then compare that figure with the expected gross profit from the returning customer. Use margin, not revenue.

Here's an example with illustrative numbers. The hibernating segment has 2,000 people, the average order is $80 and the margin is 30%.
Scenario A pays back twelvefold. Scenario B loses money. Either find a cheaper channel or narrow the segment to customers who spent more.

Plug in your own numbers, since these are only illustrative. If returning customers usually buy again, use margin over 6–12 months instead of a single order. To track real customer value over time, connect RFM with LTV and CAC by combining CRM, PPC and end-to-end analytics.

RFM in Your CRM: Turning a Spreadsheet into a System

A one-off RFM analysis is useful. A regular, automated one is a system that runs every day without a marketer's involvement.

Here's how it works technically:
  1. The contact card gets dedicated fields: R score, F score, M score, RFM code and segment.
  2. An integration or script recalculates the scores on a schedule, daily or weekly, based on order history.
  3. When a customer's segment changes, the CRM updates the tag, launches the right sequence and assigns a task to the responsible team member.
  4. A dashboard shows how many customers sit in each segment and where they move.

In Kommo CRM, we build RFM logic directly into the pipeline. A segment change triggers a playbook, and your team gets a task the moment a loyal customer starts "cooling off." Nobody has to remember whom to call, because the system tells them. In Pipedrive, the same logic runs through custom fields and workflow automations tied to field updates. Not sure which one fits your store? Our Pipedrive vs Kommo CRM comparison breaks it down.

The triggers we set up most often:
A case from our practice: a home goods store with about 4,000 active customers. Before RFM, the team worked on a "whoever shouts loudest" basis. After implementation, the base split into seven segments, and we set up a separate CRM playbook for each. Within three months, repeat purchases in the "At risk" segment grew by 23%. Average order value among loyal customers rose by 17% thanks to the upsell sequence.

A quick note on AI. Machine-learning clustering can find groups that don't fit the classic RFM grid, and predictive models can estimate churn probability. Still, for most stores with up to a few tens of thousands of customers, classic RFM delivers the core result faster and in a form your team actually understands.

If you're still choosing a system, start with our guide to CRM for online stores and closed-loop sales.

RFM + End-to-End Analytics: Where Your Champions Come From

RFM shows customer behavior inside your base. It doesn't tell you where your champions came from: which channel, campaign or search query.

When you connect RFM with end-to-end sales analytics, you see more than who buys. You see where your frequent, high-spending customers come from. That changes how you allocate ad spend. You stop optimizing for cost per first purchase and start optimizing for LTV.

On the technical side, we link UTM parameters from ad accounts to each customer's RFM profile in the CRM. In one project, a baby products store, Google Shopping turned out to bring in more champions than Meta ads at a similar cost per click. After we shifted budget toward Google, revenue from repeat purchases grew by 31% in two months.

Show the share of champions by channel on your sales dashboard, right next to acquisition cost. If you don't have end-to-end analytics yet, RFM still works. You just won't have this extra layer.

Common RFM Implementation Mistakes

After years of working with ecommerce, we keep seeing the same mistakes. Here are the most common ones.
  1. Running it once and forgetting it. Segments change: a "loyal" customer in January can turn "hibernating" by July. Recalculate at least monthly, or better, automatically in your CRM.
  2. Using the same thresholds across categories. Electronics and household cleaning products live in different worlds when it comes to purchase frequency. With a multi-category range, run RFM per category or at least adjust F thresholds to the real cycle.
  3. Using revenue instead of margin for M. A customer who only buys discounted, low-margin items can technically become a "champion" while actually costing you money. If you have margin data, add it to the calculation.
  4. Running the same promo for every segment. A 15% discount is a fine tool for hibernating customers. The same discount for champions throws away margin on people who would buy anyway.
  5. Using quintiles where they don't work. As covered above, most stores need fixed thresholds for F, or half the base ends up with the same score.
  6. Keeping RFM separate from the sales plan. RFM also works as a forecasting tool. For example, 300 loyal customers × 1.2 orders per quarter × $60 average order = about $21,600 in expected revenue from that segment alone. That's a plan built on your actual base, not a guess.
  7. Dirty data. Duplicates, cancelled orders and sales outside the CRM make your segments show a fictional picture.

Who Owns RFM and How Often to Update Segments

Teams often overlook this organizational question. Who recalculates the segments? Who launches the campaigns? Who evaluates the results? If the answer is "everyone," then nobody does.

Our recommendation: make RFM a recurring process with a single owner, usually the head of marketing or the Head of Sales.
How often you recalculate depends on your purchase cycle. A store with weekly orders needs daily or weekly updates. For furniture or electronics, monthly is enough.

Segment dynamics are the best indicator of your customer base's health. If the share of champions grows, you're on the right track. If hibernating customers pile up faster than new ones arrive, you have a systemic problem somewhere: in the product, the service or your customer experience management.

A business owner needs just three numbers on the owner's dashboard. The first is the revenue share from champions and loyal customers. The second is how many customers moved into "At risk" this month. The third is the win-back rate. The Head of Sales also needs task completion stats for the "At risk" segment per team member, alongside the core sales department KPIs. If you want to build this view quickly, a Google Looker Studio sales dashboard connected to your CRMis a solid starting point.

Customer segmentation isn't a one-time project. It only works when you update it regularly and act on every segment.

What RFM Delivers: Numbers from Our Projects

We don't like promising "sales growth" without numbers. Here's what we've seen after implementing RFM segmentation with CRM automation:
  • Hibernating customer reactivation through personal messages: 8–14% conversion with zero ad spend.
  • Upsell sequence for loyal customers: average order value up 15–22% within 60 days.
  • Onboarding series for new customers: the share of one-time buyers dropped from 61% to 44%.
  • Segmented campaigns instead of mass sends: unsubscribes fell 2.3x, and email-to-order conversion rose from 1.2% to 3.8%.

There's no magic here. This is what happens when a store stops sending everyone the same thing and starts speaking to each segment in its own language. Read more about customer retention in ecommerce and winning customers back for repeat sales.
We at Brutal Marketing will select the best CRM program for you to use in your business. We will be happy to tell you about the program's capabilities and show you which settings will exactly help you achieve the desired financial results.

Frequently Asked Questions

What is RFM analysis in simple terms?

It's a way to evaluate customers on three metrics: how recently they bought (Recency), how often (Frequency) and how much they spent (Monetary). Each customer gets scores that show how valuable they are to your business right now and how you should work with them.

How is RFM different from ABC and XYZ analysis?

ABC and XYZ traditionally apply to products: ABC ranks items by revenue contribution, XYZ by demand stability. RFM evaluates customers by behavior. You can apply ABC to customers too, but it only looks at money and won't show you who's starting to drift away. RFM shows exactly that.

How many customers do you need for RFM analysis?

Meaningful segments appear once you have a few hundred customers with a year of purchase history. With fewer than 300–500 customers, use a 1–3 scale instead of 1–5 so your segments don't end up empty.

How do you do RFM analysis in Excel?

Export your orders (customer ID, date, amount). For each customer, calculate recency with MAXIFS, order count with COUNTIFS and total spend with SUMIFS. Then assign scores based on thresholds, build the RFM code and map customers to segments. You'll find the full step-by-step guide with formulas above.

Can you automate RFM analysis in a CRM?

Yes. Scores live in contact card fields, an integration or script recalculates them on a schedule, and the CRM launches playbooks and creates tasks when a segment changes. We set up this logic in Kommo CRM and Pipedrive.

How often should you update RFM segments?

It depends on your purchase cycle. Stores with weekly orders should update daily or weekly. Niches with long cycles, like furniture or electronics, can update monthly. Review your R, F and M thresholds every six months.

Does RFM work for B2B?

Yes, with adjustments. B2B companies have fewer customers, longer cycles and larger deal sizes, so R and F thresholds shift, and M works better on margin. For long deal cycles, combine RFM with pipeline data. We cover this in our guide to CRM setup for B2B with long deal cycles.

Let Us Set Up RFM Segmentation in Your CRM

If you have a customer base and purchase history, you already have everything RFM needs. We audit your data, set up segmentation and automated playbooks in your CRM, and connect it all to end-to-end analytics. That way, every segment drives a specific revenue number.

What you get:
  • a data audit covering duplicates, channels outside the CRM and overall data quality;
  • R, F and M thresholds tailored to your niche's purchase cycle;
  • automatic segment recalculation with a playbook for each segment;
  • a dashboard with segment dynamics for the owner and the Head of Sales.

Talk to us about CRM implementation with RFM segmentation for your online store. We'll review your base and show you where the money you're not making right now is hiding. Prefer to start on your own? Use our sales dashboard checklist.
RFM analysis, RFM segmentation, RFM analysis for ecommerce, RFM analysis in Excel, customer segmentation for online stores, RFM in CRM | Brutal Marketing blog | RFM Analysis for Ecommerce: Segments, Formulas & Playbooks
By submitting an application, you agree to the privacy policy
Join our community at Telegram and WhatsApp