Using Data Science to find patterns from Installed Base purchasing behavior
Using Data Science to find patterns from Installed Base purchasing behavior

A primer on how FCRM (Frequency, Consistency, Recency, and Monetary Value) analysis can help Industrial OEMs predict buying behavior.

Customers expect OEMs to understand their needs and expectations and hence they have to come up with the right marketing strategies that work for their customers. Successful organizations do not make product, service, and marketing decisions based on their ideas, but they take into account things such as what products/services customers purchase, how often and regularly they purchase, what makes their customers engage with them, etc. Hence, understanding customer behavior at scale becomes paramount for OEMs in such cases. This is where FCRM (Frequency, Consistency, Recency, Monetary Value) analysis could help.

An analysis of customer FCRM data can help OEMs understand customer purchasing patterns, identify potential problems, and improve customer satisfaction. FCRM analysis help marketers better strategize on their campaigns, fine-tune their efforts and improve their results. Thus, FCRM plays a vital role in learning and gaining insights from the vast amount of customers and their transactional data.

But, What is FCRM Analysis for Industrial OEMs?

FCRM analysis is a 4-dimensional framework that ranks customers based on their FCRM scores. The framework is a behavioral approach to target customers a company can focus on to maintain a healthy business. The analysis help OEMs know who are their best customers and which customers need their attention.

But what exactly is FCRM?

F for Frequency:  How often do the customers engage/purchase?

C for Consistency: How regularly they engage/purchase?

R for Recency:  How recently did they engage/purchase?

M for Monetary Value:  How much did they spend?

Let’s understand these scores with examples. The below table contains the transaction history of few customers between 2015-01-01 and 2017-04-30. These scores can be calculated at different time durations (time ordinal), it can be day, week, month or year. The table below contains time ordinal in weeks and hence contains data for 121 weeks.

CustomerOrder DateTime Ordinal (Week)Order Amount  ($)
12015-01-021631
12015-02-157261
12015-04-1215565
12015-09-0836330
12017-04-11119793
12017-04-24121990
22015-01-01183
22015-01-082511
22015-01-163522
22015-01-254535
22015-02-025768
22015-02-056903
32015-03-1010826
32015-05-1820654
32015-07-2630310
32015-10-0240494
32015-12-1550675
32016-02-2160476
32016-04-3070418
32016-07-0880675
32016-09-169085
32016-11-2610016
32017-02-03110535
32017-04-14120962
42015-01-041876
42015-01-193603
42015-02-056320
42015-03-039322
42015-03-2212211
42015-04-0915287
42016-02-2360628
42016-07-0980890

Below table contains FCRM scores derived using customers’ above transaction history which are indicative of customers purchasing behavior. Each FCR score contains value between 0 to 1 where 0 is worst and 1 being best and Monetary Value is the total amount spent by customers on orders.

CustomerFrequencyConsistencyRecencyMonetary Value
10.090.2513653
2110.0853239
30.1116126
40.180.30.754137

As one can see, Customer 2 is making purchases often, hence, their frequency score is reflective of that. Customer 3 is not making purchases very often, but on a regular basis which reflects its low frequency and high consistency scores and the high score of recency also tells about the recency of its transactions compared to other customers’ last transactions in the same period.

By analyzing the above scores, OEMs can figure out which customers are most valued and can take necessary steps to improve relations with those customers. The below image shows a few examples of types of customers identified using FCRM scores.

ClusterDescriptionFrequencyConsistencyRecencyMonetary Value
ChampionsPurchase recently, often, and regularly, and spend the mostMedium-HighMedium-HighMedium-HighMedium-High
LoyalPurchase regular and spend the mostLow-HighMedium-HighLow-HighMedium-High
At RiskSpent most and often, but a long time agoMedium-HighLow-HighLow-MediumMedium-High
LostLowest FCRM ValueLowLowLowLow

Focusing on one type of customer can often lead to neglecting customers of another type. Unsatisfied customers can be less frequent, less valuable, and older than a company’s best customers. Such unsatisfied customers may never complain, but by understanding their behavior, a company can work on improving overall customer satisfaction.

When considering other customer attributes along with FCRM scores, such as the type of product or service they purchase or the industry they belong to, business unit, etc., It’s helpful to divide customers into different groups of similar types. This way, you can more easily conduct exploratory data analysis of each customer group and create customer profiles. These profiles can then be used to identify the needs, requirements, and pain points of certain customer types. From there, you can tailor your marketing efforts to better meet their needs.

Found this interesting?

Sign up for more such content from Entytle- The Installed Base Company, delivered directly to your inbox

Ways to Get Started

Resources for your
Installed Base journey

Speak to an
Installed Base Expert

Explore our Installed
Base Platform

SEE ENTYTLE
IN ACTION

Join our next 30-min live demo!

Learn from our Installed Base experts how Entytle can help your organisation today.
Register Now

Explore Resources

Drive upsell within the Installed Base for global B2B manufacturers

Blog

News

Videos

Industrial Guides

Case Studies

White Papers

Events

Tip Sheets