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


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:

Customer Model:

Customer Model:
Recent Repeaters

Customer Model:

Customer LifeCycles

LifeTime Value

Calculating ROI

Mapping Visitor

Measuring Retention
in Online Retailing

Measuring CRM ROI

CRM Analytics:
Micro vs. Macro

Pre-CRM Testing for
Marketing ROI

Behavior Profiling

See Customer
Behavior Maps

Favorite Drilling
Down Web Sites

About the Author

Book Contents

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

  Recent Repeaters
  Retail Promotion
  Pre-CRM ROI Test
  Tracking CRM ROI
  Tutorial: Latency
  Tutorial: Recency
  Scoring Software
  About Jim

Customer Value in the Freemium Model
Drilling Down Newsletter #106 11/2009

Drilling Down - Turning Customer
Data into Profits with a Spreadsheet
Have a question on Customer Valuation, Retention, Loyalty, or Defection?  Go ahead and send it to me here.

Get the Drilling Down Book!

Prior Newsletters:

Hi Folks, Jim Novo here.

Lately the questions I'm receiving seem to be concentrated around determining or predicting the value of customers.  Not sure if this is a seasonal thing or part of a broader change in the way business is being conducted.  

If we are moving to a longer-term view of how business is conducted that sure would be OK with me; a lot of the current trouble in the economy was caused by short-term thinking, both at the business and consumer levels.

In Marketing, this means today's Sales are not as important as tomorrow's Profits.  LifeTime Value is the traditional approach to this issue, but LTV can be culturally problematic and not always appropriate to the business model.

So this month we will explore some shortcuts to the core idea expressed by LifeTime Value that may be easier to access or more helpful to you and in your business situation.

Let's get to that Drillin'...

Sample Marketing Productivity Blog Posts

"X Month" Value

In the PPC world, "the budget" is often technically unlimited because all the activity is pegged to a specific cost per action.  As long as the cost doesn't rise over a threshold, managers can keep spending.  This approach is actually a shortcut to LTV analysis that can be used in many ways for different purposes, as outlined in this blog post:

“X Month” Value
November 20, 2009

I will respond to any comments you leave.

Questions from Fellow Drillers

Customer Value in the Freemium Model

Q: You kindly clarified a few issues when I was reading Drilling Down earlier this year - so I hope you don't mind the direct email.

A: Yes, I remember!

I am working for www.XYZ.com, a social networking / virtual world site based abroad but visitors are 85% US.

Our growth up to now has been mainly viral and in the summer we hit 1.2M UVs operating on the Freemium model with only 5% of our registered users converting to paying customers and a significant portion of our revenue coming from ads.  On average our customers are active on the site for something like 4 months making their first purchase around day 28.  But to take us to the next stage we are embarking on some marketing for the first time using AdWords and various revenue share campaigns, and of course to do this sensibly we need to arrive at a reasonable estimate of LTV.

A: Makes sense!

Q: To calculate an adjusted LTV I removed all customers with a lifetime of less than 4 months but this gives a low estimate as this calculation ignores the bumper summer months and the extra paid for features put in place earlier this year.  Calculating LTV using ARPU and monthly churn (not sure how to calculate this in our environment) gives another different estimate.  Is there any help or advice you could perhaps give us?  If not in the US then perhaps you could recommend somebody abroad - can't find anything in the literature relevant for start-up like us.

A:  It sounds to me like you're trying to make this too complicated, at least for the place you are at this time.  Monthly churn and the "28 day" threshold are nice to know on a tactical level, but LTV is more of a Strategic idea that does not necessarily benefit from analysis at that level.  And you may not really want LTV, but a derivative that might be more helpful.

Let's say the average user sticks around 4 months.  Say also that you generate revenues of $1 million over that period, and 1,000,000 users had some level of activity.  So your revs per active user are $1.  In terms of generating net revenue, you want to acquire  users for less than $1.

Now, we know that number is topline, and obviously there are expenses.  Companies like yours do not have very straightforward financial models because of the large amount of R & D that may be capitalized rather than expensed.  So you need to go to someone in Finance and determine what the right number is to use for looking at ROI.  Ask them, what percent of our revenues are left over to pay bills?  Or, what number would you like to see increased through a Marketing program?

Is it cash flow? Earnings before Interest, Taxes, Depreciation, Amortization?  Gross Margin?  Some other?  Then, what percent of sales does this number generally run at?

Let's say it's 40%.  In other words, 40% of revenues is actually available to pay bills and so forth.  So in the example above, .4 x $1 = 40 cents, which is the max you can pay to acquire a user, and anything less than that generates money to pay bills.

This method of course looks at all revenues. Not sure why you would want to look at it any differently, since even users that don't "purchase" still generate ad revenues.

But let's say you want to be more specific, you care only about buyers and only want to run campaigns that generate buyers.  In other words, the advertising revenue is "nice to have" but you want to build out the paid marketing model based on the acquisition of visitors likely to purchase.  You can run essentially the same model above, but only look at the known the buyer group.

Take any 4 month period, find revenues from purchases and divide by number of people purchasing (not purchases, but individuals who purchase, revenue / user).  Then apply the same 40% flow through from the model above, and that's the max you can pay to acquire a buyer.

When you aggregate known buyers, segment by source and you will find different campaigns generate different kinds of buyers; some will stick around longer than 4 months, some less.

Segment these folks by campaign and run the same model as above, purchase revenue for the period they stick around divided by purchases times the 40% flow through.  That's the max you can pay to acquire a buyer in that segment.  So you end up with (just guessing) being able to pay 5 cents for campaigns that generate people who stick around 2 months, 15 cents for people who stick for 3 months, and 40 cents for people who stick 4 months.

You can make LTV equations very complex, but often the point of the exercise is not really "what is the customer LTV?" it's "how much should we spend to improve cash flow?" or something similar.  This is a much easier question to answer and often what the company really wants to know.

Said another way, it's very difficult and often dangerous to peg an LTV number in a dynamic environment because there are so many potential changes that will impact it; LTV is a number you may fully understand 2 - 5 years from now.  Until then, you need something "close" that drives the same kind of thinking and action, and the approach above will get this done for you.  As things evolve, this number (called flow through, recently have heard it called "Near Term Value") will basically approach true LTV.

At the point where your business is somewhat static at an operational level, you can then look for true LTV by examining the revenue of actual defectors.  This is the only way to really peg LTV - after users have left and sufficient time has elapsed where you do not believe they will come back.

Until then, you are better off trying to figure out how much you can pay to attract high  quality user / buyer segments.


Have a question on Customer Valuation, Retention, Loyalty, or Defection?  Go ahead and send it to me here.

If you are a consultant, agency, or software developer with clients needing action-oriented customer intelligence or High ROI Customer
Marketing program designs, click here

That's it for this month's edition of the Drilling Down newsletter.  If you like the newsletter, please forward it to a friend!  Subscription instructions are top and bottom of this page.

Any comments on the newsletter (it's too long, too short, topic suggestions, etc.) please send them right along to me, along with any other questions on customer Valuation, Retention, Loyalty, and Defection here.

'Til next time, keep Drilling Down!

- Jim Novo

Copyright 2009, The Drilling Down Project by Jim Novo.  All rights reserved.  You are free to use material from this newsletter in whole or in part as long as you include complete credits, including live web site link and e-mail link.  Please tell me where the material will appear. 


    Home Page

Thanks for visiting the original Drilling Down web site!

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

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

Purchase Book



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