Rating 0 stars - 0 votes

Magento 2 recency, frequency, monetary report

Magento 2 Recency, Frequency, Monetary Report or RFM analysis is used for segmenting customers into particular groups, in order to develop personalized tactics and strategies towards each of the groups.

What is Magento RFM Model and How to Use It?

According to RFM model, customer segmentation is executed basing on three following variables:

  • Recency: the last time a customer made a purchase;
  • Frequency: the regularity of making orders on your site;
  • Revenue: the money spent by a customer in a specific period of time.

Performing RFM analysis with Store Manager for Magento, you can rank clients according to each of these three variables at once and get three separate diagrams displaying recency, frequency and monetary statistics correspondingly. Each of the report segments contains its own score table. Therefore, those customers whose purchases appeared most recent, with highest frequency and brought you the biggest profit, will get the highest scores.

It is quite obvious, that clients who spent a big amount of money but made a purchase only once, may require absolutely different approach, than the ones who make orders regularly but buy products with less price.

How to Create Magento RFM Report via Store Manager?

  1. Open 'General Reports' tab on the main toolbar and select necessary Magento store view from the drop-down on the right.

  2. Magento 2 General Reports RFM Report
    Magento 2 General Reports RFM Report

  3. Double-click on 'Recency, Frequency, Monetary' report type.

Let's check the content of the report. So, we got four sections here. First page displays general Magento order statistics, namely 'Order Date Range', 'Order Count Range' and 'Revenue Range'. In the lower part of the page you can find the list of customers with their recency, frequency and monetary scores, and also last order dates, order counts and revenue.

Magento 2 RFM Report General Statistics
Magento 2 Recency, Frequency, Monetary Report

Three other pages show detailed analysis of orders according to each of the above mentioned parameters.

Recency statistics

The diagram contains two variables - 'Customers Count Range' and 'Orders Date Range'. You can determine how many clients made purchases in a particular period of time.

Magento 2 RFM Report Recency Statistics
Magento 2 Recency, Frequency, Monetary Report

You have a table containing values and their scores. The highest score corresponds to the date range with highest order recency.

Magento 2 RFM Report Recency Score
Magento 2 Recency, Frequency, Monetary Report

Frequency statistics

Frequency graph variables are 'Customers Count Range' and 'Orders Count Range'. It allows to figure out how many customers made a particular number of orders. The highest score corresponds to the highest order frequency.

Magento 2 RFM Report Frequency Statistics
Magento 2 Recency, Frequency, Monetary Report

Monetary statistics

Revenue graph contains 'Customer Count Range' and 'Revenue Range'. So, you can determine the number of customers who spent the biggest amount of money and got the highest score.

Magento 2 RFM Report Revenue Statistics
Magento 2 Recency, Frequency, Monetary Report

The received results can be used for personalizing shopping experience and preparing tactical actions towards specific customer groups. For instance, you might reward your most loyal clients or offer up-sells to those who spent less but make regular purchases or make some discounts for customers who are going to leave the loyal customers group etc.

Store Manager for Magento allows to perform an ultimate customers analysis taking into consideration every nuance of their behavior. Besides RFM report, you can generate Latency Matrix report, One-time Buyers report and reports displaying your best sellers and best viewed products etc.

Generate Magento RFM report and get detailed statistics - Try Now

Related Articles:

Magento 2 Sales Report Step by Step Tutorial

Magento 2 Reports. Sales Report

Check the list of Magento report types and the sales report tutorial. Read More...

Magento 2 Latency Matrix report Tutorial

Magento 2 Latency Matrix Report

Determine Magento 2 order statistics and analyse customer behavior with Latency Matrix Report. Read More...

create magento 2 custom reports

Create Magento 2 Custom Reports

Magento 2 custom reports tutorial: build SQL-queries, select report relation (products, customers, orders), design it at your sole discretion. Read More...

magento 2 customers data management article

Magento 2 Customer Data Management

Magento 2 customer management tutorial (addresses, orders, shopping cart, product reviews, reward points, store credit etc). Read More...

Live Chat