Recency, Frequency & Monetary Analysis Using Power BI

A common question that businesses ask themselves is “Which of my customers are the most valuable?” While this is a simple question, there are ways of answering this which can prove to be quite complicated. For example, how does the business define “valuable”? This could be customers who spend the most in total, or customers who have a large number of transactions. Alongside this there are other considerations, such as how recent the last purchase was, or the average basket size.

Incubeta

Luckily, we can use the Recency, Frequency and Monetary framework (or, RFM) to help us identify high value customers.

What is RFM?

As the name suggests, RFM takes into account 3 factors for determining the value of different customers:

  1. Recency; When did the customer last buy an item? Can we identify if a customer is “active” or has “lapsed”?
  2. Frequency; How many times has a customer made a purchase? Can we identify customers who make many purchases, or few purchases?
  3. Monetary; How much in total has each customer spent?

Using these three dimensions can help identify different segments of the user base which would respond to different marketing messages and promotions.

Analysis using PowerBI

PowerBI is a business analytics service that delivers insights by transforming data into stunning visuals. We have loaded example customer data into PowerBI to create an interactive visualisation for you to explore the RFM framework.

After loading sample customer data into the PowerBI platform, we can look at the demographic profile of those customers who score highly in the Frequency and Monetary dimensions.
The demographic data can help marketers keep their messaging relevant, should they choose to reach out to the different segments.

A particularly interesting group of customers are those who have a high Monetary score but a low Recency score. In other words, they are customers who have spent a lot of money but have not done so in a while. The business may want to consider strategies to re-engage those customers as doing so would likely prove to be very profitable.

The screenshot below shows those customers who:

  • Are married .
  • Belong to a 2 adults, no kids household.
  • Have previously spent a lot with the business.
  • Transacted recently (active customer).

With the flexibility in filtering that PowerBI offers, it is a great platform for ad hoc customer segmentation for frontline marketers and stakeholders. There is also the ability to export the data once filtered, so users are really empowered to do what they wish with the data.

If you would like to hear more about how we can help you with customer segmentation and visualisation using PowerBI, get in touch today.

 

Read Next

Find out how we can help you

With offices around the world, we can build a team perfect for your needs.

Keep up to date with our monthly insight digest