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

 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

Fun with ROI

Jim's Note:  Will the real ROI please stand up?  You were probably thinking about this one as you read the pervious page of the tutorial; knowing what you know now, what is the ROI of Ad #1 versus Ad #2?

ROI, or Return on Investment, is a concept from the financial world which is frequently applied to database or customer marketing.  What people seem to forget is ROI implies the concept of time, because "Return" happens over time.  So an ROI calculation really asks, "What was my return over time?"  And without looking at time, you can't calculate the "real ROI" of a campaign.

Think about a bank account.  The bank says if you put money in, they will pay 2% interest.  This is an yearly number; if you put in $100 and don't do anything else, you will have $102 in your account at the end of a year.  Your annual ROI is 2%.  At the end of 6 months, it's close to 1%.  So ROI depends on what time frame you are using for the calculation.

Let's go back to our example of Ad #1 and Ad #2, and look at some ROI numbers.

Ad campaigns #1 and #2 were pretty similar.  The ad units were the same and the CPM's were the same, but they ran on different sites and had different creative.  As a result, the response rates (click-throughs resulting in purchase) were different.  Here's what they look like at the end of their campaign runs:

Parameter Ad #1 Ad #2
a. Cost of Campaign $5,000 $5,000
b. People Clicking 2,000 1,000
c. Number of Buyers 185 230
d. Average Price $90 $70
e. Product Sales $16,650 $16,100
f. Product Margin 30% 30%
g. Net Margin (f x e) $4,995 $4,830
h. Campaign profit (g - a) -$5 -$170
i. Campaign ROI (h / a) 0% -3%

This is short-term ROI, right at the end of the campaign.  It's based on what customers first bought during and immediately after the campaign.  Ad #1 looks to be the clear winner, even though it only broke even; Ad #2 has a negative ROI (lost money).  You might just leave it at that.  But you're smarter now.  You know about Recency and customer LifeCycles.

Your first Recency tracking is 30 days later, and you find that 20% of the buyers from Ad #1 have made another purchase and 15% of the buyers from Ad #2 have made a purchase (these numbers are from our original example).  The rest of the numbers from the LifeCycle charts are included below.  Now what does the campaign ROI for Ad #1 and Ad #2 look like?

Parameter Ad #1 Ad #2
1 month Repeat Buyer % 20% 15%
2 month Repeat Buyer % 15% 13%
3 month Repeat Buyer % 12% 11%
4 month Repeat Buyer % 9% 13%
5 month Repeat Buyer % 6% 14%
6 month Repeat Buyer % 4% 16%
j. Total Repeat Buyer % 66% 82%
k. Original # of Buyers 185 230
l. New Purchases (j x k) 122 189
m. Average Price (d above) $90 $70
n. Product Sales (m x l) $10,989 $13,202
o. Product Margin 30% 30%
p. New Net Margin (o x n) $3,297 $3,961
q. Initial Margin (g above) $4,995 $4,830
r. 6 Month Margin (q + p) $8,292 $8,791
s. 6 Month Profit (r - a) $3,292 $3,791
t. 6 Month ROI (s / a) 66% 76%

Surprised?  These ad campaigns at 6 months have ROI numbers many times higher than they did at 30 days.  And, Ad #2 has emerged as the winner because at 6 months, it has passed Ad #1 in profits and ROI.  If you recall the LifeCycle chart, at the 6 month point, Ad #1 is going downhill fast while Ad #2 is still climbing.  Looks like the spread in profits and ROI is going to get even wider still over time.

Now, is this the best and most accurate way to determine the true ROI?  No, it's a "down and dirty" approximation of campaign ROI you can make on the spot, a "back of the napkin" kind of idea.  You're looking for trends and comparisons in order to get a feel for what's working.  But it is a heck of a lot better than just looking at conversion to first purchase though.

For this example, we don't know how many of the repeat customers may have made multiple purchases in a month - we only know they made "at least one."  And we're using "average price" from the original campaign; this has probably changed.  The point of this example is making comparisons between the potential value of customers generated by different ad campaigns, and using these comparisons to make more money with your advertising.  Once you see important trends emerging, you can decide whether it's worth spending the time and resources to take ROI down to the last penny.

Could the customer LifeCycle for Ad #2 suddenly turn down and undercut the customer LifeCycle for Ad #1?  Sure, it's possible, but not likely.  This late in the LifeCycle, when a group of customers is moving in a certain direction, they tend to keep moving in the same direction.  

Good customers tend to remain that way (until they leave you) and poor quality customers tend to remain as they are.  That's one reason there is so much money wasted in customer marketing; marketers are not targeting using the LifeCycle, and as a result they're making untargeted offers at the wrong times to most customers.

Early in the LifeCycle, it can be difficult to tell if a customer will become profitable or not.  That's why it is so critical to track trends like this from the beginning; later on, it becomes less important as the customers tend to remain either profitable or unprofitable. 

There's no reason to guess though, is there?  You'll be tracking these LifeCycles, because that is what smart marketers do. 

Next in Tutorial:
8 Tips for Customer-Focused
Marketing Promotions

Read advanced version of this topic
Extensive coverage of ROI tools, measurement techniques, and formulas for increased campaign profits are found in the Drilling Down book.

 

 
    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.

You're in the middle of a short tutorial on comparing the potential value of customer groups.
If you would like to take the tutorial from the beginning, click here.

  You're in the middle of a short tutorial on comparing the potential value of customer groups.
If you would like to take the tutorial from the beginning, click here.

Sample of Book &
Software ReadMe

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