RFM - Recession Proof Your Marketing Spend Today!
RFM - Recession Proof Your Marketing Spend Today!
RFM was initially utilized by marketers in the B-2-C space - specifically in industries like Cataloging, Insurance, Retail Banking, Telecommunications and others. There are a number of scoring approaches that can be used with RFM. We'll take a look at three:
RFM - Basic Ranking
RFM - Within Parent Cell Ranking
RFM - Weighted Cell Ranking
Each approach has experienced proponents that argue one over the other. The point is to start somewhere and experiment to find the one that works best for your company and your customer base. Let's look at a few examples.
RFM - Basic Ranking
This approach involves scoring customers based on each RFM factor separately. It begins with sorting your customers based on Recency, i.e., the number of days or months since their last purchase. Once sorted in ascending order (most recent purchasers at the top), the customers are then split into quintiles, or five equal groups. The customers in the top quintile represent the 20% of your customers that most recently purchased from you.
This process is then undertaken for Frequency and Monetary as well. Each customer is in one of the five cells for R, F, and M
Experience tells us that the best prospects for an upcoming campaign are those customers that are in Quintile 5 for each factor - those customers that have purchased most recently, most frequently and have spent the most money. In fact, a common approach to creating an aggregated score is to concatenate the individual RFM scores together resulting in 125 cells (5x5x5).
A customer's score can range from 555 being the highest, to 111 being the lowest.
RFM - Within Parent Cell Ranking
This approach is advocated by Arthur Middleton Hughes - one of the biggest proponents of RFM analysis. It begins like the one above, i.e., all customer are initially grouped into 5 cells based on Recency. The next step takes customers in a given Recency cell - say cell number 5, and then ranks those customers based on Frequency. Then customers in the 55 (RF) cell are ranked by monetary value.
RFM - Weighted Ranking
Weightings used by RFM practitioners vary. For example some advocate adding the RFM score together - thus giving equal weight to each factor. Consequently, scores can range from 15 (5+5+5) to 3 (1+1+1). Another weighting arrangement often used is, 3xR + 2xF + 1xM. In this case, scores can range from 30 to 3.
So which to use? In reality, there are many other permutations of approaches that are being used today. Best-practice marketing analytics requires a fine mix of mathematical and statistical science, creativity and experimentation. Bottom line, test multiple scoring methods to see which works best for your unique customer base.
Establishing a Score Threshold
After a test or production campaign, you will find that some of the cells were profitable while some were not. Let's turn to a case study to see how you can establish a threshold that will help maximize your profitability. This study comes from Professor Charlotte Mason of the Kenan-Flagler Business School and utilizes a real-life marketing study performed by The BookBinders Book Club (Source:Recency, Frequency and Monetary (RFM) Analysis, Professor Charlotte Mason, Kenan-Flagler Business School, University of North Carolina, 2003).
BookBinders is a specialty book seller that utilizes multiple marketing channels. BookBinders traditionally did mass marketing and wanted to test the power of RFM. To do so, they initially did a random mailing to 50,000 customers. The customers were mailed an offer to purchase The Art History of Florence. Response data was captured and a "post-RFM" analysis was completed. This "post analysis" was done by freezing the files of the 50,000 test customers prior to the actual test offer. Thus, the impact of this test campaign did not effect the analysis by coding many (the actual buyers) of the 50,000 test subjects as the most recent purchasers. The results firmly support the use of RFM as a highly effective segmentation approach.
Purchased the book = yes; months since last purchase = 8.61; total # purchases = 5.22; dollars spent = 234.30
Purchased the book = no; Months since last purchase = 12.73; total # purchases = 3.76; dollars spent = 205.74
Customers that purchased the book were more recent purchasers, more frequent purchasers and had spent the most with BookBinders.
The response rate for the top decile (18%) was twice the response rate associated with the 5th decile (9%).
Results from this test were then used by BookBinders to identify which of their remaining customers should receive the same mailing. BookBinders used a breakeven response rate calculation to determine the appropriate RFM cells to mail.
The following cost information was used as input:
Cost per Mail-piece $0.50
Selling Price $18.00
BookBinders Book Cost $9.00
Shipping Costs $3.00
Breakeven is achieved when the cost of the mailing is equal to the net profit from a sale. In this case:
Breakeven = (cost to mail the offer/net profit from a single sale)
= $0.50/($18-9-3)
= ($0.50/6)
= 8.3% = Breakeven Response rate
So, according to the test offer, profit can be obtained by mailing to cells that exhibited a response rate of greater than 8.3%
RFM dramatically improved profitability by capturing 71% of buyers (3,214/4,522) while mailing only 46% of their customers (22,731/50,000). And the return on marketing expenditures using RFM was more than eight times (69.7/8.5) that of a mass mailing.
Number of Cells and Cell Size Considerations
As previously mentioned, RFM was initially utilized by companies that operated in the B-to-C marketplace and generally possessed a very large number of customers. The idea of generating 125 cells using quintiles for R, F and M has been a very good practice as an initial modeling effort. But what if you are a B-to-B marketer with relatively fewer customers? Or, what if you are a B-to-C marketer with an extremely large file with millions of customers? The answer is to use the same approach that is used in data mining -- be flexible and experiment.
Establishing a minimum test cell size is a good place to start. Arthur Hughes recommends the following formula:
Test Cell Size = 4 / Breakeven Response Rate.
The Breakeven Response Rate was addressed above in the BookBinders case study. The number "4" is a number that Hughes has found works successfully based on many studies he has performed. BookBinders Breakeven Response Rate was 8.3%. Using the above formula, you would need a minimum of 48 customers in each cell (4/0.083). BookBinders actually had 400 customers per cell, so they had more than adequate comfort in the significance of their test. In reality, BookBinders could have created as many as 1,041 cells if they were comfortable using the minimum of 48 per cell. As an example, they could have used deciles as opposed to quintiles and established 1,000 cells (10 x 10 x 10). The more cells the finer the analysis, but of course the law of diminishing returns will arise.
Other weighting considerations can be used for small files. If your Breakeven Response Rate is 3%, your minimum cell size would be 133 customers (4/0.03). Therefore, if you have 12,000 customers you could have about 90 cells (12,000/133). As such, a 5 x 5 x 4 (100 cells) or a 5 x 4 x 4 (80 cells) approach may be appropriate.
Conclusions
RFM, BI and data mining are all part of an evolutionary path that is common to many marketing organizations. While RFM has been practiced for over 40 years, it still holds great value for many organizations. Its merits include:
- Simplicity - easy to understand and implement
- Relatively low cost
- Proven ROI
- The demand on data requirements are relatively low in terms of variables required and the number of records
- Once utilized, it sets up a broader foundation (from an infrastructure and business case perspective) to undertake more sophisticated data mining efforts
RFM's challenges include:
- Contact fatigue can be a problem for the higher scoring customers. A high level cross-campaign communication strategy can help prevent this.
- Your lowest scoring customers may never hear from you. Again, a cross-campaign communications plan should ensure that all of your customers are communicated with periodically to ensure low scoring customers are given the opportunity to meet their potential. Also, data mining and the prediction of customer lifetime value can help address this shortcoming.
- RFM includes only three variables. Data mining typically finds RFM-based variables to be quite important in response models. But there are additional variables that data mining typically use (e.g., detailed transaction, demographic and firmographic) that help produce improved results. Moreover, data mining techniques can also increase response rates via the development of richer segment/cell profiles that can be used to vary offer content and incentives.
As stated before, successful marketing efforts require analytics and experimentation. RFM has proven itself as an effective approach to predicting response and improving profitability. It can be an important stage in your company's evolution in marketing analytics.
RFM Recession Proof Your Marketing Spend Today - To learn more about this author, visit Jim Stafford's Website.
Like this article? Share it with your friends
RFM in Action
RFM was initially utilized by marketers in the B-2-C space - specifically in industries like Cataloging, Insurance, Retail Banking, Telecommunications and others. There are a number of scoring approaches that can be used with RFM. We'll take a look at three:
RFM - Basic Ranking
RFM - Within Parent Cell Ranking
RFM - Weighted Cell Ranking
Each approach has experienced proponents that argue one over the other. The point is to start somewhere and experiment to find the one that works best for your company and your customer base. Let's look at a few examples.
RFM - Basic Ranking
This approach involves scoring customers based on each RFM factor separately. It begins with sorting your customers based on Recency, i.e., the number of days or months since their last purchase. Once sorted in ascending order (most recent purchasers at the top), the customers are then split into quintiles, or five equal groups. The customers in the top quintile represent the 20% of your customers that most recently purchased from you.
This process is then undertaken for Frequency and Monetary as well. Each customer is in one of the five cells for R, F, and M
Experience tells us that the best prospects for an upcoming campaign are those customers that are in Quintile 5 for each factor - those customers that have purchased most recently, most frequently and have spent the most money. In fact, a common approach to creating an aggregated score is to concatenate the individual RFM scores together resulting in 125 cells (5x5x5).
A customer's score can range from 555 being the highest, to 111 being the lowest.
RFM - Within Parent Cell Ranking
This approach is advocated by Arthur Middleton Hughes - one of the biggest proponents of RFM analysis. It begins like the one above, i.e., all customer are initially grouped into 5 cells based on Recency. The next step takes customers in a given Recency cell - say cell number 5, and then ranks those customers based on Frequency. Then customers in the 55 (RF) cell are ranked by monetary value.
RFM - Weighted Ranking
Weightings used by RFM practitioners vary. For example some advocate adding the RFM score together - thus giving equal weight to each factor. Consequently, scores can range from 15 (5+5+5) to 3 (1+1+1). Another weighting arrangement often used is, 3xR + 2xF + 1xM. In this case, scores can range from 30 to 3.
So which to use? In reality, there are many other permutations of approaches that are being used today. Best-practice marketing analytics requires a fine mix of mathematical and statistical science, creativity and experimentation. Bottom line, test multiple scoring methods to see which works best for your unique customer base.
Establishing a Score Threshold
After a test or production campaign, you will find that some of the cells were profitable while some were not. Let's turn to a case study to see how you can establish a threshold that will help maximize your profitability. This study comes from Professor Charlotte Mason of the Kenan-Flagler Business School and utilizes a real-life marketing study performed by The BookBinders Book Club (Source:Recency, Frequency and Monetary (RFM) Analysis, Professor Charlotte Mason, Kenan-Flagler Business School, University of North Carolina, 2003).
BookBinders is a specialty book seller that utilizes multiple marketing channels. BookBinders traditionally did mass marketing and wanted to test the power of RFM. To do so, they initially did a random mailing to 50,000 customers. The customers were mailed an offer to purchase The Art History of Florence. Response data was captured and a "post-RFM" analysis was completed. This "post analysis" was done by freezing the files of the 50,000 test customers prior to the actual test offer. Thus, the impact of this test campaign did not effect the analysis by coding many (the actual buyers) of the 50,000 test subjects as the most recent purchasers. The results firmly support the use of RFM as a highly effective segmentation approach.
Purchased the book = yes; months since last purchase = 8.61; total # purchases = 5.22; dollars spent = 234.30
Purchased the book = no; Months since last purchase = 12.73; total # purchases = 3.76; dollars spent = 205.74
Customers that purchased the book were more recent purchasers, more frequent purchasers and had spent the most with BookBinders.
The response rate for the top decile (18%) was twice the response rate associated with the 5th decile (9%).
Results from this test were then used by BookBinders to identify which of their remaining customers should receive the same mailing. BookBinders used a breakeven response rate calculation to determine the appropriate RFM cells to mail.
The following cost information was used as input:
Cost per Mail-piece $0.50
Selling Price $18.00
BookBinders Book Cost $9.00
Shipping Costs $3.00
Breakeven is achieved when the cost of the mailing is equal to the net profit from a sale. In this case:
Breakeven = (cost to mail the offer/net profit from a single sale)
= $0.50/($18-9-3)
= ($0.50/6)
= 8.3% = Breakeven Response rate
So, according to the test offer, profit can be obtained by mailing to cells that exhibited a response rate of greater than 8.3%
RFM dramatically improved profitability by capturing 71% of buyers (3,214/4,522) while mailing only 46% of their customers (22,731/50,000). And the return on marketing expenditures using RFM was more than eight times (69.7/8.5) that of a mass mailing.
Number of Cells and Cell Size Considerations
As previously mentioned, RFM was initially utilized by companies that operated in the B-to-C marketplace and generally possessed a very large number of customers. The idea of generating 125 cells using quintiles for R, F and M has been a very good practice as an initial modeling effort. But what if you are a B-to-B marketer with relatively fewer customers? Or, what if you are a B-to-C marketer with an extremely large file with millions of customers? The answer is to use the same approach that is used in data mining -- be flexible and experiment.
Establishing a minimum test cell size is a good place to start. Arthur Hughes recommends the following formula:
Test Cell Size = 4 / Breakeven Response Rate.
The Breakeven Response Rate was addressed above in the BookBinders case study. The number "4" is a number that Hughes has found works successfully based on many studies he has performed. BookBinders Breakeven Response Rate was 8.3%. Using the above formula, you would need a minimum of 48 customers in each cell (4/0.083). BookBinders actually had 400 customers per cell, so they had more than adequate comfort in the significance of their test. In reality, BookBinders could have created as many as 1,041 cells if they were comfortable using the minimum of 48 per cell. As an example, they could have used deciles as opposed to quintiles and established 1,000 cells (10 x 10 x 10). The more cells the finer the analysis, but of course the law of diminishing returns will arise.
Other weighting considerations can be used for small files. If your Breakeven Response Rate is 3%, your minimum cell size would be 133 customers (4/0.03). Therefore, if you have 12,000 customers you could have about 90 cells (12,000/133). As such, a 5 x 5 x 4 (100 cells) or a 5 x 4 x 4 (80 cells) approach may be appropriate.
Conclusions
RFM, BI and data mining are all part of an evolutionary path that is common to many marketing organizations. While RFM has been practiced for over 40 years, it still holds great value for many organizations. Its merits include:
- Simplicity - easy to understand and implement
- Relatively low cost
- Proven ROI
- The demand on data requirements are relatively low in terms of variables required and the number of records
- Once utilized, it sets up a broader foundation (from an infrastructure and business case perspective) to undertake more sophisticated data mining efforts
RFM's challenges include:
- Contact fatigue can be a problem for the higher scoring customers. A high level cross-campaign communication strategy can help prevent this.
- Your lowest scoring customers may never hear from you. Again, a cross-campaign communications plan should ensure that all of your customers are communicated with periodically to ensure low scoring customers are given the opportunity to meet their potential. Also, data mining and the prediction of customer lifetime value can help address this shortcoming.
- RFM includes only three variables. Data mining typically finds RFM-based variables to be quite important in response models. But there are additional variables that data mining typically use (e.g., detailed transaction, demographic and firmographic) that help produce improved results. Moreover, data mining techniques can also increase response rates via the development of richer segment/cell profiles that can be used to vary offer content and incentives.
As stated before, successful marketing efforts require analytics and experimentation. RFM has proven itself as an effective approach to predicting response and improving profitability. It can be an important stage in your company's evolution in marketing analytics.
RFM Recession Proof Your Marketing Spend Today - To learn more about this author, visit Jim Stafford's Website.
Like this article? Share it with your friends
 | |
 |
No article feedback found. |
| |
Leave Your Feedback |
 | |
| |||
John PowerJohn Power, founder of Biltmore Franchise Consulting, has extensive experience developing and marketing franchises and business opportunities. He has been in and around franchising for over twenty years. From 1980 through 1990 he conceptualized, organized, and developed the American Video Association. He grew AVA to 2,000 national members, before selling the company it 1990. It was later merged into another home video marketing company. From 2000 to 2005 he worked as a contract marketing and human resources consultant to several local and national companies. In 2005 Mr. Power began working as a franchise development consultant on a full-time basis. Since that time he has helped more than three dozen companies initiate and develop their franchising program. He notes that there are many companies interested in developing a franchise program, and who need his specialized assistance. Mr. Power is a “hands-on” franchise consultant. He said, “I am the ‘nuts and bolts’ person who tends to the details for my clients.” Mr. Power holds a B.S. degree with a major in Marketing. See: www.biltmorefranchise.com You may contact Mr. Power at: jpower@biltmorefranchise.co - Visit John Power's Website |
|||
Dave KurlanDave Kurlan is the founder and CEO of Objective Management Group, Inc., the industry leader in sales assessments and sales force evaluations, and the CEO of David Kurlan & Associates, Inc., a consulting firm specializing in sales force development. Dave has been a top rated speaker at Inc. Magazine's Conference on Growing the Company, the Sales & Marketing Management Conference and the Gazelles Sales & Marketing Summit. He has been featured on radio and TV, including World Business Review with General Norman Schwarzkopf, in Inc. Magazine, Selling Power Magazine, Sales & Marketing Management Magazine and Incentive Magazine. He is the author of Mindless Selling and Baseline Selling – How to Become a Sales Superstar by Using What You Already Know about the Game of Baseball. He created and wrote STAR, a proprietary recruiting process for hiring great salespeople, and he writes Understanding the Sales Force, a popular business Blog and is a contributing author to The Death of 20th Century Selling and 101 Great Ways to Improve Your Life, Volume 2. - Visit Dave Kurlan's Website |
|||
Jeff FosterWebBizIdeas.com is a Minneapolis website design company founded to help people start an internet business by providing them with website, business, and internet resources that help foster the growth of successful online businesses and develop innovative Internet business ideas. We specialize in internet consulting & internet marketing. - Visit Jeff Foster's Website |
|||
Stephanie RobeyStephanie Robey is President and CoFounder of Pivot Positive, LLC - an Internet marketing business focused on helping people start work at home ventures. Previously, she was employed at The Search Agency with over 20 years experience in graphic design and 10 years experience in online marketing. She was responsible for launching the Conversion Path Optimization (CPO) unit where she and her team have conducted hundreds of optimization tests for online companies across multiple verticals. She is a successful entrepreneur having started and sold 2 companies and remains on the board of directors of the third, PhotoSpin.com Stephanie began her career in the direct marketing realm creating and producing direct mail for many of the major cable television companies and directly attributes her understanding of Internet marketing to those early offline experiences. Stephanie is a graduate of San Diego State University with a BFA in Graphic Arts and also holds an Executive MBA from the Graziadio School of Business and Management at Pepperdine University. Read Steph's Blog Meet Steph and Dave Sign up for our Free 7-Day BootCamp: Self Employed & Rich - Visit Stephanie Robey's Website |
|||
Joe DagerJoe Dager is President of Business901, a progressive coaching company providing no-nonsense direction in areas such as Lean Six Sigma Marketing and organized referral marketing. What others say: In the past 20 years, Joe and I have collaborated on many difficult issues. Joe’s ability to combine his expertise with “out of the box” thinking is unsurpassed. He has always delivered quickly, cost effectively and with ingenuity. A brilliant mind that is always a pleasure to work with.” - James R. If you want to learn more about Business901, start a conversation with us. We can be found @ Web/Blog: Business901.com Web/Blog: FundingYourNonprofit.com LinkedIn Profile Follow me on Twitter - Visit Joe Dager's Website |
|||
David AchesonDavid Acheson is the founder of DCJA Consultancy. DCJA Consultancy is a management consultancy business specialising in B2B sales consultancy. They offer bespoke and packaged sales consultancy including Sales Optimisation Review, Interim Sales Management, Sales & Marketing Review, 1:1 Sales & Management Staff Analysis, Management Training, Solution Sales Training, Creation of New Pay Plan, KPI's, run Customer Feedback Campaigns, assist with Recruitment, Coaching, Appraisals and set up Strategic Marketing Campaigns. David spent his early career in accountancy and then moved into sales in 1982, working in Office Equipment, IT, Advertising, Training, Outsourcing and Consultancy. He has held many Senior Positions in SMBs and Global Organisations including Head of Sales Operations & Head of Business Development. His knowledge, skills and great experience of the Sales Industry has led to David making keynote speeches and running educational sessions to key businesses through organisations including The Chamber of Commerce and Business Link. - Visit David Acheson's Website |
|||
Jay Kubassek(Jay's Full Bio: EvanCarmichael.com/jaykubassek) In five years, Canadian-born entrepreneur Jay Kubassek went from selling mufflers at a Midas franchise to revolutionizing Internet marketing with the 2004 launch of CarbonCopyPRO, a online marketing education company, now worth over $20 million with customers in over 160 countries.
As an independent film producer, his upstart film fund Aliquot Films is currently producing a films with Spike Lee and Abel Fererra (starring Ethan Hawke and Dennis Hopper.)
Jay's entrepreneurial spirit is irrepressible. He’s the owner of five companies, a professional speaker and trainer, international real estate developer/investor, extreme sport enthusiast and emerging philanthropist. Jay resides in NYC with his wife Jamie, son Milo and dog Cooper. Visit Jay's official website: www.JayKubassek.com - Visit Jay Kubassek's Website |
|||
John AlexanderJohn has taught keyword research and SEO skills to small groups of business owners and Webmasters from over 80 different countries world wide since 2002. John is also the Director of Search Engine Academy ; Co-director of Training at Search Engine Workshops offering live, SEO Workshops with his partner SEO educator Robin Nobles, author of the very first comprehensive online search engine marketing courses at SEO Training Online and the SEO Workshop Resource Center. I look forward to hearing from you! - Visit John Alexander's Website |
|||
|
To learn more about the Evan Elite Author Program please contact us. | |||
 | |
|  |
Subscribe to Jim's articles
 | |
|
|  |
 | |
|
| |
 | |||||||
|
 | ||
|
||
 |
||
|
||
|
| ||
 |
| Have you written articles that would be of value to entrepreneurs? Become an expert on our site by publishing them! Expose yourself to a wide audience, drive more traffic to your website and get more sales! Click Here for details. |
|
|
 |
| Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media |
|
|
 |
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"
Click Here To Learn More |
|
|
|
|
Get advice & tips from famous business owners, new articles by entrepreneur experts, my latest website updates, & special sneak peaks at what's to come!
|
|
|
 Business vs Personal Joint Ventures ebook Increasing Coaching Effectiveness Traffic to Site Social Bookmarking Guide |
|
 | ||
 |
Top 50 Franchising Blogs
Top 50 Franchising Blogs | |
 |
Fortune Hunters
CBC Entrepreneur TV | |
| ||
 | ||||
| ||||
|
| ||||
| ||||
|
|
|
|
|
||||||||||||
|
Email us your ideas on how to make our website more valuable! Thank you Sharon from Toronto Salsa Lessons / Classes for your suggestions to make the newsletter look like the website and profile younger entrepreneurs like Jennifer Lopez and Sean Combs!
|
|
|
