Close this search box.

RFM Analysis: Segmentation To Skyrocket Your Company [2024 Easy Guide]

By Liza Shuttleworth Last updated: 11 minute read Marketing GuidesPerformance Marketing

Today, you’ll learn about a powerful tool to reinvigorate your marketing campaigns: the FRM model.

Coined by Hughes in the ’90s, RFM is a tried and tested segmentation model which gets results.

It has an impressive track record: top brands like L’Occitane have seen their income increase by 25 times by using this FRM segmentation . And because it’s simple, small companies can benefit from it too.

Here, we’ll take you through how to conduct your own Recency, Frequency, and Monetary analysis to boost your conversion rates.

Skip to What You Need

    read more

    Customer Value Segmentation Explained

    Customer value segmentation is a data-driven tool which helps you get to know your customers and understand their customer lifetime value. It’s based on the principle that you need to understand how they buy, not just who they are.

    This model groups your customers based on their spending behavior. It tells you how they’ve interacted with you in the past. Who has been loyal through thick and thin? And who is a flaky one-time shopper?

    With this data, you can then create targeted marketing campaigns that align with your business strategy. Your voice gets lost when you’re trying to reach a vast range of people with a single message.

    But Customer value segmentation allows you to send your customers high-value, focused communication that’s relevant to them. You’ll put your marketing resources where they matter most and enjoy a higher customer lifetime value.

    With RFM segmentation, you’ll be able to identify customers like:

    • Your Champions. They make up the bulk of your income — don’t lose them!
    • Potential Loyalists. With some encouragement, they could become champions too.
    • Customers Needing Attention. They’re at risk of dropping you — unless you do something to bring them back.

    For now, let’s get into how this model really works.

    Recency, Frequency, and Monetary Explained

    The RFM is built on three pillars: Recency, Frequency, and Monetary. It uses these factors to analyze your customers’ spending history within your database

    Diagram explaining the terms Recency, Frequency and Monetary in the RFM model.
    Source: CleverTap

    When analyzing RFM, you ask three questions of every customer:

    1. Recency: How long ago did they buy your product?

    You’ve got a better shot at targeting customers who’ve transacted recently with you. The fresher a purchase, the more responsive they’ll be to your messaging. 

    2. Frequency: How often have they bought from you in a fixed time period?

    Here, you’re looking for frequent buyers. This measure tells you how loyal they are to your brand — and therefore how valuable.

    3. Monetary: How much have they spent on your products?

    You’re keeping an eye out for the big spenders with this one. They’re more willing to cough up for luxury items.

    In some cases, Engagement (E) can take the place of Monetary (M). This is a useful metric if your ‘product’ isn’t traditional. Take ad revenue, for example. You could tally the visit duration, time spent per page, and the number of pages visited per user instead of the money they spent. 

    Put these three RFM factors together, and you’ve got a powerful analytic tool. You’ll get deeper insights into how your customers spend, and therefore how you can best target them.
    via SEO Butler

    Recency, Frequency, and Monetary Analysis in 4 Easy Steps.

    Now you know the theory, it’s time to put the RFM into practice.

    The great news is that RFM calculation is pretty simple for anyone to do. While there are paid kits that do it automatically for you, the process is fairly easy to do yourself. All you need is a laptop and clear instructions. (We’ve got that last one covered.)

    Here’s how to calculate RFM in 4 easy steps with an RFM analysis example:

    Step 1: Compile your data

    To start, you’ll take your company’s raw transaction data. Take each customer’s buying history and assign them an R, F, and M value.

    If you need a refresher:

    • Recency: How long it’s been since their last transaction. This is a unit of time, usually days, but can be months or even years depending on your business.
    • Frequency: The total number of transactions they made within a fixed period. 
    • Monetary: The total they’ve spent in their entire history with you. 

    Especially if you’re a beginner, RFM models work well in Excel. But Python or r make good RFM models too if you have the skills. Besides, you can configure any of Excel integrations to use RFM data for reporting or within other tools.

    After you do this, your Excel sheet should look something like this:

    Excel sheet showing transaction data with Recency, Frequency, and Monetary values.

    Step 2: Split your customers into tiers

    Next, you’ll need to calculate each customer’s RFM score. To do that, you first need to sort the R, F and M data, and then create 4 tiers. If you’re dealing with a lot of data, you could make 5 tiers — or 3 if you have less data. We prefer 4 as it makes manual calculation simple. 

    Sort each R, F, and M value in order such that your ‘ideal’ customer behavior ranks first. If we took Recency, for example, the ideal behavior is purchasing recently. So recent buyers would rank first.

    You then need to segment that data into 4 tiers: T-1 (Top score), T-2 (Upper middle), T-3 (Lower middle), and T-4 (Bottom).

    If we did that with the Recency data from our example, that would look like this:

    Excel sheet showing recency data sorted and segmented into 4 tiers.

    Repeat this process for the other 2 values, F and M. By the end, every customer should have individual tiered values for Recency, Frequency, and Monetary. 

    To calculate their combined RFM score, all you have to do is place these tiered values alongside each other:

    Excel sheet showing all customers' RFM tiers and their overall RFM score.

    Step 3: Identify who you want to target

    Now that every customer has an RFM score, you can split them up into groups, so you can form a targeted marketing strategy. It helps to give them names.

    Diagram showing different types of customers based on RFM model score, including Champions, Loyal Customers, and Lost.
    Source: Rittman Analytics

    For your RFM model example, you might focus on:

    • Champions: 1-1-1. These customers are active customers. They’re willing to pay higher prices for products, and they buy from you frequently.
    • Loyalists: 1-1-3. Even if these customers don’t spend as much, they’ve been buying from you for a long time and continue to be active. 
    • Potential champions: 1-4-2. These customers might be new and have just discovered you, but they’re willing to pay. You want to persuade them to stay.
    • At risk: 4-1-1. Once, these customers were active, maybe even champions. But they haven’t transacted in a long time, and you’re at risk of losing their interest. 
    • Lost: 4-4-4. These customers are low on all 3. Most likely, they’re long gone. They may have bought something once long ago, but they’re not loyal to your brand. 

    Of course, the labels you give these segments are up to you. You’ll have to figure out what works best for your context.

    Step 4: Create a targeted messaging campaign

    By breaking your customers down like this, you can then send out messages that resonate with each of these categories. 

    For example, you might target a group like this:

    • Reward your champions: Offer your hero customers loyalty programs. Give them exclusive access to new products as they’re likely to be early adopters. They’re willing to pay, so you don’t want to use discount pricing. Instead, focus on high-value offers.
    • Win back at risk customers: You need to investigate what’s causing their inactivity. Send them offers and helpful products to get them back in the game. 
    • Say goodbye to the lost customers: At this point, they’re just taking up space on your email list. Find a way to reconnect with them. Or, if that’s not on the table, take them off your list — they’re skewing your data. An exit survey can be helpful to find out why they’re no longer interested in you.
    Venn Diagram showing the highest value customer scores highly in all three RFM model values.
    Source: Data Analytics

    The Pros and Cons of the RFM Model

    With RFM calculation, you can reach each customer — and win their loyalty. When done right, it makes your marketing more compelling. But it’s not without its shortcomings, as we’ll get to later. 

    First, let’s take a look at why you should be using RFM:

    Pros of the RFM Model:

    1. RFM is an objective measure

    Because it’s backed by hard data, RFM gives you an accurate analysis. It’s calculated quantitatively, so it’s free from human bias. 

    Other more traditional analytic methods simply don’t do this. For example, sampling risks arbitrarily picking people who aren’t true representatives of your customers. And other segmentation methods might unfairly skew towards variables like demographics.

    2. Personalized marketing

    With RFM, you can send out personalized brand messages that are suitable for each group of customers, while still at a large scale. It helps you focus your marketing efforts on each group instead of sending out generic communication. That makes it a great option if you’ve got limited time and money available.

    By doing this, your message tells your customer that this brand understands them and their needs. A relevant message can reactivate old customers, and incentivize your best ones to keep buying. Ultimately, you’ll get more engaged and loyal customers. 

    3. Simple and low cost

    Market research can get complicated. And costly. What makes RFM popular is that it’s fairly easy and low cost to use. Sure, you can buy kits to do the hard work for you — and there are some great tools out there. But like we’ve shown, RFM analysis calculation can be straightforward with some instruction. This means it’s accessible to businesses of all sizes. 

    4. Higher Customer Lifetime Value

    It’s not about how many customers you can attract. It’s about how many you can keep.

    Because of the digital marketplace, every customer has an overwhelming number of options competing for their attention. In this climate, customer acquisition is no longer the name of the game. Customer retention is what matters. 

    With RFM, you work out who your most valuable customers are and reward their spending behavior. This targeted approach results in higher retention. They’re more likely to stay when they feel valued and satisfied with the service.

    Cons of the RFM Model

    There are drawbacks to using RFM, however. If you use it in isolation, the analysis can be misleading. Here are a couple of things to be careful of when using RFM:

    1. Can be simplistic

    RFM can’t tell you everything. It relies on only 3 factors, whereas other analytic tools use a more exhaustive data set. By honing in on these 3, you may exclude other important data, like location or demographics. 

    A good way to get around this is to supplement your RFM analysis. For example, adding qualitative data research can give you a fuller picture of your customer’s spending habits. By conducting customer interviews, you’ll be able to really get to the nuts and bolts of why they’re spending in a certain way. (Something RFM doesn’t really show.)

    2. Not predictive

    It’s tempting to assume that your customers will continue spending in the same way in the future. But that’s not necessarily true. RFM models only analyze past customer data. That might not be helpful in predicting future behavior, given trends or future activities. To get around this, consider using predictive tools in conjunction with RFM.

    3. Easily skewed

    And finally, the RFM model can produce skewed results. For certain business models, each of the 3 factors might not be useful metrics:

    • Some businesses are influenced by seasonal buying patterns. This makes the recency and frequency factors misleading. Black Friday, for instance, can seriously disrupt data patterns.
    • If your product is durable, but costly, your customers aren’t going to be buying it frequently or recently. Therefore, frequency and recency aren’t that important to analyze.
    • Similarly, your product could be expendable but cheap. Fast fashion goes out of style seasonally and customers are constantly buying to keep up with trends. In this case, monetary is less important of a factor.


    There’s a reason RFM has been kicking for 25+ years. It works. If you’re a scrappy start-up, or an old hand in a bit of a rut, RFM can give your marketing campaign new energy. With just a simple analysis, you can build relationships that matter with customers that will stick with you. 

    So use our guide to take a shot at it yourself!

    Frequently Asked Questions

    What is RFM Segmentation?

    RFM segmentation is a way of analyzing groups of customers by looking at their purchasing history. It helps you determine who your most valuable customers are based on their spending habits, so you can target them in a focused way.

    What does RFM stand for?

    RFM stands for recency, frequency, and monetary. Each is a factor used to analyze a customer’s value. Recency tells you how long ago they transacted with you. Frequency tells you how often they transacted with you. And Monetary tells you how much they spent.

    Why use RFM Segmentation?

    RFM can be a powerful tool for making targeted marketing campaigns. It gives you insights into how your customers spend, so you can send personalized communication to them, so they’re more likely to be engaged with and loyal to your brand.

    References & Sources

    1. Windsor Circle: RFM Analysis
    2. Qualtrics: Customer Lifetime Value (CLV) & How to Measure
    3. CleverTap: RFM Analysis for Customer Segmentation
    4. SEO Butler: RFM Analysis Explained
    5. Towards Data Science: An RFM Customer Segmentation with Python
    6. Rittman Analytics: RFM Analysis and Customer Segmentation using Looker, dbt and Google BigQuery
    7. Data Analytics: Customer Segmentation using RFM Analysis (using R)
    8. Shopify: Customer Retention Strategies