RFM, Part 2

  |  February 11, 2002   |  Comments

If you know what RFM stands for, you're one step ahead of the game. But read on to learn how these three simple letters can help you maximize future revenue from your existing customers.

Two weeks ago, in Part 1, I described how to build a recency, frequency, and monetary (RFM) model in a traditional retail environment. If you haven't read Part 1, I advise doing so before reading Part 2. Not doing so would be like watching "Die Hard 2" before "Die Hard." It's nearly impossible to grasp the complicated plot of the sequel without first watching the original, experiencing the development of dark and mysterious characters such as Detective John McClane, Officer Al Powell, and Argyle. You get the idea.

Before we proceed into Part 2, I want to clear up some confusion I may have created last time. I referenced RFM models of a car dealer and a corner pharmacy. The car dealer and corner pharmacy can only define the parameters of the scoring system for each variable (RFM) by first performing the RFM analysis, as described in the "Building the Model" section of that column. Once the RFM analysis is performed, the car dealer and corner pharmacy analyze the cut-off points between the top 20 percent and middle 60 percent and between the middle 60 percent and bottom 20 percent to define the parameters of the scoring system for each variable. Daniel Riff let me know that this was not clear and deserves kudos for his attention to detail. Mea culpa.

Internet Media and the Point of Transaction

In Part 1, I promised to discuss how to apply the RFM model to an Internet media company. The key to applying the RFM model in this context is defining the point of transaction.

The point of transaction for a retailer is obvious. It's the point at which a customer buys. When a customer opens up her wallet and plunks down cold, hard cash in exchange for a product. For an Internet media company, the point of transaction is less obvious. It's when a site visitor either is exposed to advertising (impression-based ads) or makes a revenue-generating action (performance-based advertising). When a visitor sees a paid banner ad, a transaction occurs. When a visitor clicks on a paid search result, a transaction occurs. Defining the point of transaction is the key.

An RFM Model for Impression-Based Advertising

Let's look at building an RFM model for an Internet media company selling impression-based advertising. First, define the transaction cycle. In today's Internet media environment (which fosters attention-deficit disorder by offering access to mountains of information at the click of a mouse), if a visitor hasn't returned in 90 days, it's reasonable to assume he isn't coming back anytime soon. He didn't find what he was looking for or found better information elsewhere. Pull a list of all visitors in the past 90 days (the assumption here is that your site tracks visitors, most likely through a cookie). When pulling the list, request the following for each visitor:

  • Date of most recent visit

  • Number of visits in the past 90 days

  • Average ad revenue per visit

Obtaining the third item may require some mathematical gyrations. Multiply the total number of page views for each visitor in the past 90 days by the percentage of ad inventory sold (assumes one ad unit per page view). This gives you a projected number of advertising impressions for each visitor in the past 90 days. Multiply this number by the average ad revenue per impression to get the projected total ad revenue generated by each visitor in the past 90 days. Divide this number by the total number of visits. You arrive at a projection for average ad revenue per visit for each visitor.

You now have the data you need to perform the RFM analysis. Start with recency. Sort the list of visitors by date of most recent visit, with the most recent visit at the top descending to the least recent. Assign a score of 3 to the top 20 percent of visitors, a score of 2 to the middle 60 percent of visitors, and a score of 1 to the bottom 20 percent.

Now move to frequency. Sort the list of visitors by number of visits in the past 90 days, with the highest number of visits at the top descending to the lowest number at the bottom. As before, assign 3 points to the top 20 percent, 2 to the middle 60 percent, and 1 to the bottom 20 percent.

Finish with monetary. Sort the list by average ad revenue per visit, with the highest at the top. Once again, use the same scoring method: 3 points for the 20 percent; 2 points for the middle 60 percent; 1 point for the bottom 20 percent.

As with the retail model, sort the list so visitors receiving scores of 333 (remember to always represent the numbers in RFM order) appear together to form a single segment, visitors scoring 323 appear together, visitors scoring 322 appear together, and so on. When complete, you will have 27 total segments of visitors, one segment for each combination of the RFM variables (see table below). People in the 333 segment are your most valuable visitors. Those in the 111 segment are the least valuable.

111222333
121212323
131232313
112211332
113213331
122231321
123233322
132221312
133223311

Analyze the cut-off points between the top 20 percent and the middle 60 percent and between the middle 60 percent and bottom 20 percent for each recency, frequency, and monetary. You will find it illuminating to understand how visitors fit into each of the 27 segments. For example, after performing the cut-off points analysis, you may determine that to receive a score of 333, a visitor must have visited the site in the last 15 days (recency), visited a minimum of 45 times in the past 90 days (frequency), and generated average advertising revenue per site visit of at least $2.00 (monetary). After analysis, you may also determine that to receive a score of 111, a visitor must not have visited the site in the last 50 days (recency), visited a maximum of 10 times in the last 90 days (frequency), and generated average advertising revenue per site visit of no greater than $0.05 (monetary). By translating the 333 and 111 scores into these terms, you can create successful marketing strategies targeted at each segment of site visitors. That's where we'll pick up in two weeks. Until then, in the words of Detective John McClane, yippee kay-ay...

ClickZ Live Chicago Join the Industry's Leading eCommerce & Direct Marketing Experts in Chicago
ClickZ Live Chicago (Nov 3-6) will deliver over 50 sessions across 4 days and 10 individual tracks, including Data-Driven Marketing, Social, Mobile, Display, Search and Email. Check out the full agenda and register by Friday, August 29 to take advantage of Super Saver Rates!

ABOUT THE AUTHOR

Mark Sakalosky Mark Sakalosky is an associate at Howe Strategic, a business consulting firm working with early stage companies in technology sectors. Mark has more than nine years of marketing strategy, business development and product development experience in both online and offline environments. He has delivered successful results for companies ranging from Fortune 500 firms to start-ups operating in the retail, telecommunications, media and technology industries. Although he earned an MBA in marketing strategy from The College of William & Mary, he remains a devoted Spider from his undergrad days at the University of Richmond.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Analytics newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

Featured White Papers

BigDoor: The Marketers Guide to Customer Loyalty

The Marketer's Guide to Customer Loyalty
Customer loyalty is imperative to success, but fostering and maintaining loyalty takes a lot of work. This guide is here to help marketers build, execute, and maintain a successful loyalty initiative.

Marin Software: The Multiplier Effect of Integrating Search & Social Advertising

The Multiplier Effect of Integrating Search & Social Advertising
Latest research reveals 68% higher revenue per conversion for marketers who integrate their search & social advertising. In addition to the research results, this whitepaper also outlines 5 strategies and 15 tactics you can use to better integrate your search and social campaigns.

Jobs

    • Sales Planner
      Sales Planner (Verve ) - New YorkAbout Verve   Verve is the leader in location powered mobile advertising. We manage one of the largest mobile...
    • Systems Analyst/Support
      Systems Analyst/Support (Agora Inc. ) - BaltimoreIRIS (Increased Revenue Intuitive Software ) is proprietary software that helps marketers...
    • Client Services Support Specialist
      Client Services Support Specialist (Agora Inc. ) - Delray Beach OVERVIEW:  This position requires a highly motivated and resourceful individual...