Request a potential analysis
EN
Menu

RFM analysis: which customers deserve attention.

Recency, frequency, monetary: the classic customer segmentation, explained simply.

An RFM analysis ranks your customers by when they last bought, how often and how much. Vittorio, the sales assistant powered by artificial intelligence (AI), goes one step further and shows your team every morning which individual customer has an occasion today.

Official WhatsApp Business Platform Hosted in Germany Developed in Hamburg
Good morning, Clara.Friday, 9:05

3 contact suggestions for today

Mrs Lehmann Not seen for a while Used to come every six weeks, last purchase in April
Hello Mrs Lehmann, the new autumn collection has arrived, and I thought of you straight away. On Saturday, I am showing it to a few clients in advance. May I reserve an appointment for you?
EditLaterSend
Mr DemirSize back in stockAsked about the jacket in 52, arrived today
Mrs RothPrivate previewLoyal client of the brand, new collection is in

Key points at a glance

  • An RFM analysis rates customers by three values: recency (last purchase), frequency and monetary value (revenue).
  • Each value is divided into classes, usually from 1 to 5. The three classes form a score such as 5-5-5 or 1-4-4.
  • Segments can be derived from the scores, such as top customers, at-risk good customers or lost customers.
  • A first RFM analysis can be done in a spreadsheet, provided purchase date, amount and customer are available.
  • Limits: the method is a snapshot, knows no occasions and treats all customers in a segment the same way.

What is an RFM analysis?

RFM analysis is a proven method of customer segmentation. It ranks customers solely by their buying behaviour, without surveys and without details of age or place of residence. The name stands for the three values determined for each customer:

  • Recency: how long ago was the last purchase?
  • Frequency: how often did the customer buy within a period?
  • Monetary: how much revenue did they bring in during this period?

The idea behind it: whoever bought recently, often and a lot is closely attached to your business. Whoever used to buy often and a lot but has not been in for a long time is a candidate for personal contact.

The three values in retail

Recency, the last purchase

Measured in days or months since the last purchase. In retail, this value is usually the strongest signal: the longer a customer is away, the harder it is to win them back.

Frequency, how often

The number of purchases or visits in the period under review. A clear rule on what counts as one purchase is important, for example all items on one day together.

Monetary, the revenue

The total revenue in the period. Calculating with gross margin instead of revenue rates high-margin customers more fairly.

Typical RFM segments and what to do with them

  • Top customers (high values in all three): show appreciation, invite them early, do not shower them with discounts.
  • Loyal customers (high frequency, medium revenue): approach them with suitable additions to their last purchase.
  • New customers (recent, rare so far): encourage the second visit, for example with an after-sales service.
  • At-risk good customers (used to buy often and a lot, now away for a long time): contact them personally, and soon. More on this under customer reactivation.
  • Dormant customers (rarely, little, away for a long time): contact them with little effort or let them rest.

The limits of RFM analysis

The method is simple, and that is exactly why it is popular. For day-to-day work with regular customers, however, it has gaps:

  • Every customer has their own rhythm. Three months without a purchase is a lot for a restaurant’s regular guest and nothing for a kitchen studio’s customer. A classification across all customers overlooks this.
  • Occasions are missing. A service that is due, a lease that is ending or an anniversary do not appear in the three values.
  • A segment is a group. All customers in it easily end up with the same message, even though each has a different history with your business.
  • It remains a snapshot. Without regular repetition, the segments quickly become outdated.

If you want to see early on which customers are drifting away, continue with churn prediction.

From analysis to contact with Vittorio

Vittorio looks not only at segments but at each customer individually, with their purchases, their service and their occasions. The result is not a report but a suggestion for the responsible employee: whom to contact, why today and with which message. More on this on the AI customer data analysis page.

Example scenes. All names of people and businesses are fictitious.

An example from a jewellery store.

Five customers, viewed over 24 months. Classes 1 to 5 result from comparison with all the store’s customers.

CustomerLast purchasePurchasesRevenueScoreSegment
Customer A3 weeks ago6€8,4005-5-5Top customer
Customer B2 months ago4€1,1504-4-3Loyal customer
Customer C1 month ago1€2,3005-1-4New customer
Customer D19 months ago5€11,2001-4-5At-risk good customer
Customer E22 months ago1€1801-1-1Dormant customer

Illustrative figures. The potential analysis shows your own numbers, based on your data.

RFM analysis step by step.

How to create a first RFM analysis with your own sales data.

  1. Choose period and data

    For example the last 24 months. For each purchase, you need customer, date and amount.

  2. Calculate three values per customer

    Days since the last purchase, number of purchases and total revenue in the period.

  3. Divide into classes

    Split each value into five equal groups. The best 20 per cent get a 5, the weakest a 1.

  4. Build the score

    The three classes give the score, for example 5-5-5 for the best customers or 1-4-4 for good customers who have not been in for a long time.

  5. Derive segments

    Group similar scores into a few segments, such as top customers, loyal customers and at-risk good customers.

  6. Act and repeat

    For each segment, decide who gets in touch and with what. Refresh the analysis regularly, for example every month.

Read on.

Discretion comes first.

What your clients entrust to you stays in your house.

People decide

Every message your house sends on its own initiative is approved by a member of staff. Vittorio never writes on its own authority.

Consent only

Contact exclusively with customers who have expressly agreed to WhatsApp.

Official platform

Messages are sent via Meta’s WhatsApp Business Platform, not via private accounts.

Hosted in Germany

Designed for use under the General Data Protection Regulation (GDPR), with a data processing agreement.

First, see what your existing customers are worth.

Before you decide on any software, we analyse your existing sales data, pseudonymised and contractually secured. After ten working days, we present the results to you in person.

  • How many good customers have not been in touch for a long time
  • Which occasions are coming up in the next 90 days
  • How much revenue potential lies in them
Example of a potential analysis

Jeweller, two stores

1,240Customers with purchases over €5,000418 of them not in store for more than 18 months
96Watch checks due in the next 90 daysPurchases 10 to 14 months ago, with consent
37Occasions from customer detailsAnniversaries, birthdays, wedding rings

Illustrative figures. The analysis shows your own numbers, based on your data.

Frequently asked questions

What does RFM stand for?

Recency, frequency and monetary, meaning when a customer last bought, how often they buy and how much revenue they bring in.

How do you calculate an RFM analysis?

For each customer, you determine the days since their last purchase, the number of purchases and the revenue within a period. Each value is divided into classes from 1 to 5. The three classes give the RFM score, from which segments can be derived.

What period makes sense for an RFM analysis?

It should cover several of your customers’ buying cycles. In retail, 12 to 24 months is common. For infrequent purchases, such as at a kitchen studio, it can be considerably longer.

What is the difference between RFM analysis and customer segmentation?

Customer segmentation is the umbrella term for any grouping of customers. RFM analysis is one specific method for it that uses buying behaviour alone.

Can I do an RFM analysis in Excel?

Yes. With a table of customer, purchase date and amount, the three values, the classes and the score can be calculated in a spreadsheet. It only becomes laborious when the analysis is to be refreshed regularly and turned into contacts.

What are the limits of RFM analysis?

It is a snapshot, does not take each customer’s own buying rhythm into account and knows no occasions such as service, contract end or anniversaries. It also treats all customers in a segment the same way.

Let’s talk about your existing customers.

30 minutes with one of the founders, in person at the H1 in Bielefeld, by video or directly in a Teams chat.