Frequency & Monetary Analysis For Subscription Based Services


Visitors: 261

Frequency (F) and Monetary (M) analysis, form together with Recency (R) the framework of RFM analysis. Though recency is the strongest predictor of future behavior, frequency and monetary analysis act in a complementary mode (to recency), to create a complete picture of the Customer behavior. There are many cases in which Recency analysis not coupled by Frequency & Monetary analysis, can give a misleading picture. For example, a new subscriber is very recent, but appears to have a low monetary value because she started using the service recently. The Business cannot tell, whether this new Customer will be profitable (will use the service a lot). On the other hand, an old Customer can be ranked low in R but high in F and/or M. This is probably a valuable Customer who is late in interacting with the Business. This is probably one of the candidate cases for a retention plan. In general F is a stronger predictor to M. If the service usage is producing a relatively stable monetary value, then M does not yield substantial additional insight to F. However there are exceptions. Should a Business try to offer an expensive service, the M predictor has an increased power. Those that spend a lot on a service are more likely to spend on an expensive additional service, than those who spend less. Subscription based services involve the continuous usage by a Customer, often based on a contract.

Common examples are: bank accounts, credit cards, fixed & mobile telecommunication services, internet access service. In the case of subscription based services, the frequency of use can be easily derived, since each service usage is recorded. In the case of bank accounts or credit cards, each account or card transaction is recorded. These transactions are handled by banking systems in order to produce monthly balances or Customer invoices. In the case of fixed & mobile telecommunication services, each phone call is captured in a CDR record (call detail record) along with details about the call (calling & called number, time of day, duration, cost band). These usage records are processed by the billing systems, in order to produce Customer invoices. Therefore the banking and telecoms industries, capture rich information on service usage in order to bill Customers. Thus the information for the execution of an F and/or M analysis, is there. These service usage transactions are executed by millions of Customers very frequently and may be producing a huge number of service usage records on a monthly basis. Therefore, in order to execute F and M in these industries, substantial computational & storage capacity is often needed.

Specifically, usage information should be extracted from the operational systems into a datawarehouse, which shall store the historical information on usage and periodically produce F and M scores for the Customer base and sort the Customers in F and M quintiles. Moreover, it can perform time-series analysis on FM scores. Finally, in order to produce an F or M score for any Banking or Telecom Customer, the Business has to aggregate Customer behaviour from all accounts this Customer holds. Prerequisite for this, is to have a Customer-centric data structure. If the Business operates on unlinked accounts of the same real Customer, then it may be unable to carry out an accurate F or M analysis. Copyright 2006 – Kostis Panayotakis

Material relevant to the recency and RFM technique can be found at

Material relevant to Customer Intelligence can be found at


Article Source:

Rate this Article: 
Network Marketing & Home Based Business - Why & How?
Rated 4 / 5
based on 5 votes

Related Articles:

Advertising on a Budget -- Part 3: Frequency, Frequency, Frequency

by: Michele Pariza Wacek (December 09, 2004) 

10 Reasons To Sell A Fee Based Subscription Ezine

by: Rojo Sunsen (January 05, 2006) 
(Internet and Businesses Online/Ezine Publishing)

10 Reasons To Sell A Fee Based Subscription Ezine

by: Larry Dotson (March 30, 2005) 
(Internet and Businesses Online/List Building)

MP3 Music Subscription Services. A Good Deal?

by: Mary Beim (July 22, 2005) 
(Arts and Entertainment/Music)

How To Get Rich Selling a Fee Based Subscription Ezine? 10 Reasons to Go

by: Murtuza Abbas (March 03, 2006) 
(Internet and Businesses Online/Ezine Publishing)

Subscription Services Quadruple Signups With Hi-Tech Pop-ups

by: Vince Lewis (April 03, 2006) 
(Internet and Businesses Online/List Building)

Raising The Bar For Online Magazine Subscription Services And Customer Service

by: Jason Ciment (January 12, 2005) 
(Business/Customer Service)

Real Estate Postcard Q&A - Postcard Frequency

by: Brandon Cornett (December 27, 2006) 

Online Magazine Subscription Services Make Shopping Online Fun For Magazines

by: Jason Ciment (January 12, 2005) 

Network Marketing & Home Based Business - Why & How?

by: John Juliano (July 08, 2006) 
(Home Based Business/Network Marketing)