Drilling Down Home Page Turning Customer Data
into Profits with a Spreadsheet
The Guide to Maximizing Customer Marketing ROI

Site Map


Book Includes all tutorials and examples from this web site
.

Get the book!

Purchase Drilling Down Book

Customers Speak Up on Book & Site


About the Author

Workshops, Project Work: Retail Metrics & Reporting, High ROI
Customer Marketing

Marketing Productivity Blog

8 Customer
Promotion Tips

Relationship
Marketing

Customer Retention

Customer Loyalty

High ROI Customer Marketing: 3 Key Success Components

LifeTime Value and
True ROI of Ad Spend

Customer Profiling

Intro to Customer
Behavior Modeling

Customer Model:
Frequency

Customer Model:
Recency

Customer Model:
Recent Repeaters

Customer Model:
RFM

Customer LifeCycles

LifeTime Value

Calculating ROI

Mapping Visitor
Conversion

Measuring CRM ROI

CRM Analytics:
Micro vs. Macro

Pre-CRM Testing for
Marketing ROI

Customer
Behavior Profiling

See Customer
Behavior Maps


Favorite Drilling
Down Web Sites

About the Author

Book Contents

 What is in the book?
 Productivity Blog
 CRM   
  Simple CRM
 Customer Retention
 Relationship Marketing
 Customer Loyalty
 Retail Optimization
 Telco/Utility/Services
  Visitor Conversion
  Visitor Quality
 
Guide to E-Metrics
  Customer Profiles
  Customer LifeCycles
  LifeTime Value
  Calculating ROI

  Workshops/Services
  Recent Repeaters
  RFM
  Retail Promotion
  Pre-CRM ROI Test
  Tracking CRM ROI
 
Tutorial: Latency
  Tutorial: Recency
  Scoring Software
  About Jim
  Consulting
  Praise
  Contact
  FAQ
  Search
 
Downloads
  Privacy

Measuring Customer
Retention in Online Retailing

First published:  E-Tailer's Digest, 10/18/00 "Measuring Customer Retention in Online Retailing"  

The following article is from the advanced topics section; you might want to take the tutorial Comparing the Potential Value of Customer Groups before reading it.  If you would rather see a general description of the Drilling Down method and specific benefits first, go to the home page.

Introduction

How is it the catalogs, and their distant cousins the TV Shopping Networks, are virtually the only profitable major B2C retailers on the Internet?   The Direct Marketing Association’s latest study of catalogs with web sites found 69% of them were making profits online.

Catalog and TV shopping marketers have understood for a very long time that it is much less expensive to retain customers than it is to acquire new ones.  They have been doing business with this philosophy for decades.  Customer acquisition is certainly important; if you don’t do it, the business eventually dies.  So why focus on customer retention?

Because by understanding customer retention behavior, catalogs lower their customer acquisition costs.  It’s all tied together.  Sure, there has to be a "first shot" somewhere, the initial push for customers.  But even these first efforts are based on what is known generally about customer retention in the catalog business.  The secret to good customer retention is to acquire the right customers in the first place.

So understanding customer retention is extremely important to the entire direct selling model of doing business with consumers, both for customer acquisition and retention.  Good retention marketers have two objectives with any kind of customer retention marketing:

1. Hold on to the most valuable customers

2. Try to make less valuable customers more valuable over time

To retain and increase the value of customers, you have to create marketing promotions and execute them.  To do this in the most efficient and effective way, you have to know the value of your customers and their likelihood to respond to a promotion, for these 2 reasons:

1.  You don't want to waste money on promoting to low value customers because you can't make a profit

2.  You don't want to waste money promoting to customers who won't respond because this is just throwing money away.

Customer Retention
and Valuation Concepts

Have you ever heard somebody refer to his or her customer list as a "file"? If you have, you were probably listening to someone who has been around the catalog block a few times.   Before computers (huh?), catalog companies used to keep all their customer information on 
3 x 5 cards.

They’d rifle through this deck of cards to select customers for each mailing, and when a customer placed an order, they would write it on the customer’s card.  These file cards as a group became known as "the customer file," and even after everything became computerized, the name stuck.

Who cares? It happens that while going through these cards by hand, and writing down orders, the catalog folks began to see patterns emerge.  There was an exchange taking place, and the data was speaking.  What the data said to them, and what they heard, were 3 things:

1.  Customers who purchased recently were more likely to buy again versus customers who had not purchased in a while

2.  Customers who purchased frequently were more likely to buy again versus customers who had made just one or two purchases

3.  Customers who had spent the most money in total were more likely to buy again.  The most valuable customers tended to continue to become even more valuable.

So the catalog folks tested this concept, the idea past purchase behavior could predict future results.  First, they ranked all their customers on these 3 attributes, sorting their customer records so that customers who had bought most Recently, most Frequently, and had spent the most Money were at the top.  These customers were labeled "best."   Customers who had not purchased for a while, had made few purchases, and had spent little money were at the bottom of the list, labeled "worst."

Then they mailed their catalogs to all the customers, just like they usually do, and tracked how the group of people who ranked highest in the 3 categories above (best) responded to their mailings, and compared this response to the group of people who ranked lowest (worst).  They found a huge difference in response and sales between best and worst customers.  Repeating this test over and over, they found it worked every time!

The group who ranked "best" in the 3 categories above always had higher response rates than the group who ranked "worst."  It worked so well they cut back on mailing to people who ranked worst, and spent the money saved on mailing more often to the group who ranked best.  And their sales exploded, while their costs remained the same or went down.  They were increasing their marketing efficiency and effectiveness by targeting to the most responsive, highest value customers.

The Recency, Frequency, Monetary value (RFM) model works everywhere, in virtually every high activity business.  And it works for just about any kind of "action-oriented" behavior you are trying to get a customer to repeat, whether it’s purchases, visits, sign-ups, surveys, games or anything else.  I’m going to use purchases and visits as examples.

A customer who has visited your site Recently (R) and Frequently (F) and created a lot of Monetary Value (M) through purchases is much more likely to visit and buy again.  And, a high Recency / Frequency / Monetary Value (RFM) customer who stops visiting is a customer who is finding alternatives to your site.  It makes sense, doesn’t it? 

Customers who have not visited or purchased in a while are less interested in you than customers who have done one of these things recently.  Put Recency, Frequency, and Monetary Value together and you have a pretty good indicator of interest in your site at the customer level.  This is valuable information to have when planning marketing promotions.

Assuming the behavior being ranked (purchase, visit) using RFM has economic value, the higher the RFM score, the more profitable the customer is to the business now and in the future.  High RFM customers are most likely to continue to purchase and visit, AND they are most likely to respond to marketing promotions.  The opposite is true for low RFM customers; they are the least likely to purchase or visit again AND the least likely to respond to marketing promotions.

For these reasons, RFM is closely related to another customer direct marketing concept: LifeTime Value (LTV).  LTV is the expected net
profit a customer will contribute to your business as long as the customer remains a customer.  Because of the linkage to LTV, RFM techniques can be used as a proxy for the future profitability of a business.

High RFM customers represent future business potential, because the customers are willing and interested in doing business with you, and
have high LTV.  Low RFM customers represent dwindling business opportunity, low LTV, and are a flag something needs to be done with those customers to increase their value.

RFM scoring of individual customers is a catalog and TV shopping technique used to select which customers you can most profitably promote to.  There is a more simplistic application of RFM online retailers can use to easily track the quality of overall customer retention, without going through the effort of RFM scoring individual customers.  We will consider this easier "group tracking" approach in the rest of this report.

Measuring Overall Customer Retention

A simplified application of RFM is Hurdle Rate Analysis, where "hurdles" are selected for Recency, Frequency, and Monetary Value, and the entire customer base is evaluated against these hurdles as a group.

A Hurdle Rate is simply the percentage of your customers who have at least a certain activity level for Recency, Frequency, and Monetary Value.  It’s the percentage of customers who have engaged in a behavior since a certain date (Recency), engaged in a behavior a certain number of times (Frequency), or have purchased a certain amount in total (Monetary Value).

Because of the link between RFM and Lifetime Value, it can be concluded:

If the percentage of customers over each hurdle (Recency, Frequency, Monetary Value) is growing, the business is healthy and thriving.  Customers are responding positively to the experience they receive, and as a group are more likely to engage in profit generating behavior in the future.

If the opposite is true, and the percentage of customers over each hurdle (Recency, Frequency, Monetary Value) is falling over time, high value customers are defecting and the future value of your business is falling.   Customers as a group are responding negatively to the overall service they are receiving.

Sample Hurdle Rate Implementation

If the business has an understanding of customer LifeCycles, the logical Hurdle Rates to set for Recency, Frequency, and Monetary value would equate to customer behavior at primary changes in the customer LifeCycle.

If the business is very new or has never studied the customer LifeCycle, then a good default position to use is based on the 20/80 rule (20% of customers generally generate 80% of the behavior, be it sales, visits, etc.)  The analysis would default to a "starting Hurdle Rate" of 20% for each behavior (purchases, visits), and examine the customer base to determine RFM values corresponding to the 20% hurdle.

In this case, the business would look at the top 20% of their customers for each of the Recency, Frequency, and Monetary value parameters, and examine the "tail end" customers – the bottom customers of the top 20%.  These values would become the hurdles the customer base is judged against.  Customers would have to have at least the activity of these tail end customers to be considered "over the Hurdle."

For example, in a database of 10,000 customers, to determine the Recency hurdle using the 20/80 rule:

1.  Select the behavior to be profiled – purchases, visits, etc.

2.  Sort customers by most Recent date of the behavior you are profiling

3.  Starting at the most Recent customer, count down to customer number 2,000 (20% of 10,000) in this sorted database.  Examine the group of customers near this target level, perhaps customer 1,950 to customer 2,050

4.  Determine how long ago these customers, on average,  engaged in the behavior you are profiling based on last activity date

5.  You find these customers last purchased an average of 60 days ago

6.  The Recency hurdle becomes 60 days for the "today" or  starting Hurdle Rate of 20%

Regardless of whether the Hurdle Rate is set using the customer Lifecycle or the 20/80 rule, the operational implementation is the same.  Each week or month, sweep the database and determine the percentage of customers who have engaged in the behavior within the hurdle definition.  For a 60-day hurdle, it would be the percentage of customers engaging in the behavior in the past 60 days.

If the percentage of customers "over the hurdle" (engaging in the behavior less than 60 days ago) grows over time, the Recency Hurdle rate is rising, and the future value of the customer base (LTV) is rising.  If the percentage of customers "over the hurdle" is falling, the Recency Hurdle Rate is falling and future value is falling as well.

For example, if you started with 20% of customers having 60 day Recency for purchases, you would like to continue seeing 20% of your customer base purchase in the past 60 days.  Ideally, you would see 21%, then 22%, then 23%, and so on, purchase in the past 60 days.  If this percentage is rising, this means the future value of your customer base is growing, your high value customers are sticking with you, and your promotions will have increasing response rates.

This calculation can be completed on the same behavior (purchases, visits) for Frequency, and  if there is a transactional value to the behavior (a purchase),  Monetary Value as well. The only difference from the Recency example above would be in Step 2, where you would sort by total activity (units or dollars).  

Additional behaviors can also be monitored simultaneously; on the web, tracking purchases and visits together would make sense.  Unless the business has a very clear understanding of revenue per visit across different areas of the site, it is unlikely tracking the Monetary Value of visits would be very useful but Recency and Frequency would still be important.

The Hurdle Rate percentages can be graphed over time, and trends established.  Clearly there will be fluctuations up and down, and seasonality in retail or event oriented businesses.  But if solid trends in Hurdle Rates develop in either direction, or year over year comparisons are dramatically different for a seasonal business, the measurement should be judged to be significant and actionable.  Graphing Hurdle Rates over time provides an easy way to present a somewhat complex subject to management or investors: line up = good, line down = bad.

Hurdle Rates in Action

Percent of the Customer Base
Over each Hurdle by Week is Growing!

The lines in the chart show the percentage of customers over each Hurdle tends to be rising over time.  This particular chart is a combination of behaviors with differing RFM parameters – Recency of Visit, Frequency of Purchase, and Monetary Value of Purchase.  For Hurdles, 30 day Recency, 10 unit Frequency, and $500 Monetary were selected.

The percent of customers who have visited in the last 30 days (Recency, broken heavy line) is rising.  The percent of customers who have purchased over 10 items (Frequency, heavy solid line) is rising.  The percent of customers who have spent over $500 in total (Monetary Value, light solid line) is also rising.  A business can mix and match tracking of behaviors and Hurdle Rates according to priorities in the business model.

This is the picture of "growing the share" of best customers in your customer database.  Your best customers are remaining with you, and other customers are "growing into" becoming best customers.

If you don’t see this effect, the future value of your business is shrinking.  Higher customer activity levels among best customers are just not happening; this trend should be researched further and action taken to counteract the trend.

A business can mix and match tracking of behaviors and Hurdle Rates across the RFM metrics according to priorities in the business model.  Any important activity at your site can be assessed using RFM Hurdle Rates.

A very effective way to take action on declining Hurdle Rates, if you choose to continue to follow the RFM methodology, would be to score individual customers for RFM.  If you don't have a problem with customer retention, it's probably not worth the effort, but if you do, promotions based on individual RFM scores are a very cost effective way to stall the decline in overall customer value.  

For advanced or large companies, with rich activity data on their customers, see the following article written by a senior director at Oracle Corporation.  This approach is similar to using individual RFM scores.  The idea is to target marketing efforts where the profit potential is the highest, and avoid areas with low potential, based on customer score: 

Where's the ROI in CRM?

After measuring customer group value, the next step is to manage customer value - to make money by creating high ROI customer marketing campaigns and site designs.  The Drilling Down book describes how to create future value and likelihood to respond scores for each customer, and provides detailed instructions on how to use these scores to continuously improve profitability.

 

 
    Home Page


Thanks for visiting the original Drilling Down web site!

The advice and discussion continue on the Marketing Productivity Blog
and
Twitter: @jimnovo

Read the first 9 chapters of the Drilling Down book: download PDF

Purchase Book

Consulting

 

Slow connection?  Same content, less graphics, think Jakob Nielsen in Arial - Go to faster loading website

Contact me (Jim Novo) for questions or problems with anything on this web site.  

 
The Drilling Down Project.  All rights reserved, all media.

 

   

Ask Jim a Question

/

Get the book with Free scoring software at Booklocker.com

Find Out Specifically What is in the Book

Learn Customer Marketing Concepts and Metrics (site article list)

 


This is the original Drilling Down web site; the advice and discussion continue on the Marketing Productivity Blog and Twitter.

Download the first 9 chapters of the Drilling Down book here: PDF
Purchase Book          Consulting