RFM Model
Customer Value Optimization, eCommerce Growth, RFM, Web Personalization

Step by Step Guide To Building An RFM Model (and How to Use It)

The RFM Model has been in use since 1970 for direct sales and mailing. Yet, it’s still one of the least explored – and most effective! – segmentation strategies.

Given that acquiring a new customer costs almost 7 times more than retaining one, and that RFM segments help you understand your customers’ behavior and reasons to buy, not using this model is a missed opportunity for online stores.

While some years ago the argument for not doing RFM modelling was the amount of manual work involved in such an analysis, today there’s really no excuse left!

RFM tools like REVEAL are doing the RFM segmentation and analysis automatically for you, so all you have to do is connect your webshop data to our software and dive into your customer insights!

What is an RFM model analysis?

By definition, the term RFM stands for Recency, Frequency and Monetary Value.

It focuses on the lifetime value of customers, and it’s the preferred segmentation methodology for eCommerce businesses who focus on retention strategies more than on client acquisition.

The common approach to RFM modelling is collecting large amounts of transactional data and based on it, segmenting customers into specific groups as per to their purchase history.

Each customer group is then addressed separately according to their own needs and behaviour patterns.

The best part of the RFM model is that it helps you focus on the customers that have high recency and frequency scores. These clients are critical because they are very likely to return and buy again.

If you’re serious about defining your ideal customer profile and buyer persona, you need to segment your customers based on RFM. Why?

Because you might find out that 1% of your customers generates up to 30 times more revenue. And that only 20% of your clients return after the first order.

Wouldn’t you like to have access to such customer insights? To get a clear picture of who these customers are, and what makes them come back?

Why you should implement an RFM Model

There was a time when advertising was everything.

People would spend huge budgets on getting attention towards their brand and acquire new customers. Over and over again.

Until terms like “retention”, “loyalty” and “building a relation” became popular.

We find ourselves in an era where the relation between consumers and providers is cold. There’s no emotion or commitment between the two parts.

As a marketer, I believe that we need to shift our attitude from transaction-focused to customer-centric.

I’ve seen many online businesses focusing on reducing their Customer Acquisition Cost (CAC). They completely disregard retention, which is similar to doing cold-calling and expecting everyone to buy at the first interaction.

That rarely happens, so focusing on acquisition instead of retention is sabotaging your business’ long-term growth.

Why spend 5 to 10 times more on acquiring new customers rather than keeping the ones you already have? The reality is that companies with 24 months of activity in online get 50% of their revenue from returning visitors.

RFM Model Graph

Screenshot from RJMetrics E-commerce Growth Report 2015

I’ve worked with a company that used to spend 20 times more on getting new customers. They had huge advertising budgets. Since the focus was on acquisition, they tried their best to reduce CPMs and CPAs, but they didn’t do anything about the Customer Lifetime Value.

RFM Model Intro

Source

Surely, acquisition is the main driver of growth in the first months or years for an ecommerce website. In this phase, it is essential to let people know you exist on the market and build awareness.

But once you’ve acquired enough customers, you need to start focusing on segmentation and retention through highly personalised customer journeys.

It’s how we helped one of our clients in the fashion industry to increase their retention rate by 6% in only 6 months!

I’ll show you how to build an RFM Model and how to use it to build a strong relationship with your current customers.

The process below is suitable for webshops built on custom platforms. If you’re using Shopify, you can skip the manual work and let REVEAL do all the RFM modelling, segmentation and analysis for you!

Step-by-step guide to creating your RFM model

Step 1. Tracking

First of all, have in mind that when you try something new for your business, you need to find a logic. I recommend starting with building a database containing the history of the purchases from the past 3 years.

From a first look at the data, you will observe some patterns. When I once analyzed a customer database, I observed that there were customers who bought once but never purchased again from the website. On the other hand, we had customers that purchased every time we launched a new product.

The first major insight was that these customers had different habits and we needed to approach them differently.

When you have the database, you need to select some criteria that will help segment the customer database and give scores. The most important metrics that you should consider are:

  • Revenue (1)
  • Number of orders (2)
  • Average Order Value (3)
  • Last Order Date (4)
  • Last order in days (5)
rfm analysis

Right after deciding what you need to track, you have to flag all of the previous purchases according to:

  • Recency – the time when they last placed an order;
  • Frequency – how many orders they have placed in the given period;
  • Monetary value – how many dollars they spent since their first purchase (Customer Lifetime Value)

Step 2. RFM segmentation

The second step in the building the RFM Model for your eCommerce site is defining the categories of customers. You will have to define them based on recency, frequency, and monetary value.

Discover and build segments of silver, gold and platinum customers. Use the RFM model to discover the most important clients. I am pretty sure that you don’t want to let the clients that have high monetary value and high frequency fly away.

To decrease the churn rate you have to understand who they are and what are the underlying factors that drive their purchase intentions.

Another segment you can look into is formed by the sleepy and ex-VIP clients. Of course, the risk is here to get lost in the data and create too many groups.

Acquiring valuable customers isn’t a hit-and-miss incident. It’s a deliberate, intentional process.

One way to have even more loyal clients is to continuously launch NPS surveys to check the pulse of  all your customers. The Net Promoter Score allows to find out what customers thinks about you.

Further on, develop a strategy based on the NPS segmentation: promoters, passives and detractors. For example, you can send a special offer to your passive ones and try to transform them into promoters.

Recency

If you decide to make the analysis for the last three years, divide the time interval into 4 or 5 parts. List all the purchases from the most recent to the least recent and divide the time equally. You will get five segments:

  1. Old
  2. Lost
  3. Potential
  4. Regular
  5. New
RFM Model

Then, assign numbers to each customer: 1,2,3,4,5.

This is an example with four-time intervals. That’s why you see only max. 4 points assigned to Recency.

In this phase, you should be able to have a major insight about your customers. For instance, I once discovered that users who bought more recently were more inclined to open our newsletters and visit the website. They were more engaged.

“Users who made recent purchases were more willing to visit from email and interact with the website.”

You have to repeat the process for Frequency and Monetary Value as well.

Frequency

Sort the entire file containing the purchases from the highest number of purchases to the lowest number of purchases. Then, divide it into equal parts like you did with the recency.

For example…

If you have divided the time interval into 5 parts, assign points from 1 to 5 for the frequency as well.

[su_note note_color=”#f87e5b”]Pro tip: Create customer surveys triggered to find out how much they are willing to spend on your site.[/su_note]  

Here are some questions to ask in customer satisfaction surveys:

  • How much are you willing to spend for [product X]/ [Special event], etc.?
  • What would you like to improve in the products on [your site]?

When you analyze the answers, pay attention to the differences between the users who make recurring purchases and the ones who purchase only once. If the difference is significant, then frequency is important to your business.

In my case, when I analyzed the results, the difference between the two was not as significant as in the Recency research. Therefore, it was more important for that business to have recent purchases rather than having a good frequency score.

Monetary Value

The third factor in the customer database segmentation using the RFM Model is the monetary value. The monetary value is the overall amount of dollars that your customers had spent in their lifetime.

All you have to do is sorting the list from the highest amount of dollars spent on your site to the lowest and divide the database into 4 or 5 equal parts (depending on how you decided to do it). Then attribute points to each part.

After applying these three segmentation criteria you’ll get a list of three-digit codes, which represents the RFM score for each customer.

Step 3. Testing

Now that you have segmented the customer database based on recency, frequency, and monetary value, how do you know which segments are the most profitable?

You test them!

First, you have to extract a sample size from the total number of customers (segmented as discussed below) and start a campaign. Choose a sample size of 5% or 10% of the total number of customers included in your database.


170,000 clients, divided by 8,500 (5% of total) equals 20. This means you have to pick every 20th client in the database.


Use this rule if you want to have a sample that is representative for the entire list.

By testing 5% or 10% of your list, you minimize the risks of launching a promotion campaign that would fail.

If you need help with setting up A/B testing experiments and website overlays for your segments, Omniconvert is the right technology to do it. I know I’m biased, but it’s the only way to do it without installing multiple codes on your site.

Step 4. Analysis

To analyze the results of your campaign, you should measure the Conversion Rate of each segment that has an RFM score attributed. The segments with the highest conversion rate are the ones that will get you the highest amount of money to your business.

When you analyze the results, use this simple procedure that works anytime, for anyone. You don’t need sophisticated tools for this.

First, you need to divide the total costs of the campaign with the total revenue.


If Revenue/Cost is 1 or greater than 1, then it’s profitable to keep investing in that customer.


Draw a line below the row that contains the last value greater than 1.

If it’s below one, it means that it’s ineffective to invest in that type of customer or that you should run more tests to find out what’s making him behave like the ideal (read most profitable) customer. I call this method “waking up the customers that sleep.”

[su_note note_color=”#f87e5b”]P.S.: We have created an RFM template to help you visualize the whole story better. Have a look.[/su_note]

Step 5. Iterating and growing

If you build the RFM model the right way, you will be more persuasive in your communication with your customers. It will most likely convince them to continue as your client. Check out these ideas to increase sales if you feel like you don’t know where to start from.

For example, if your customers are in the “1” category on Recency, you can send them a re-engaging newsletter. This newsletter could mention all the new offers you have on your site, any changes in design, or how the overall experience has been improved since they last visited your site.

If you want to talk to customers that are in the “5” segment of your Monetary Value, let them know how much they mean to you and your business. Give them special discounts if you can, tell them they’re VIPs, make them know they are appreciated. This will only bring them back to your site and buy more.

Finally, I encourage you to be creative. You can use the RFM model in any way it suits your business. But remember that just doing the RFM analysis and segmentation will not influence your website’s results.

You will have to act based on customer insights and start testing approaches and targeting them in a more emotion-based way. In the end, you’ll get more conversions.

7 Replies to Step by Step Guide To Building An RFM Model (and How to Use It)

  1. Hi Andra. Just a head’s up that this is not the correct construct for the RFM model as originated by Harte-Hanks. While your model may rely on similar variables, it isn’t true RFM in the perfect sense of the definition. One hint: for each different element you should always end up with the same number of clients in each bucket. 5’s should be the same as 4’s, etc. Rather than identifying specific cut-offs for recent purchases, you allow the data to reveal the patterns. Likewise, calculating F and M is also more complex than what is describe. Not trying to be a troll. And certainly some method for segmentation is better than none. But wanted to give a head’s up that RFM in its purest form is quite different…

    1. Hi John,

      Elena here, in charge of Marketizator’s blog management.
      Thank you for pointing this out. I will make sure to update this article as soon as possible.

      Best regards,
      Elena.

Leave a Reply

Your email address will not be published. Required fields are marked *