Excellent Analytics Tip #17: Calculate Customer Lifetime Value
Some Marketers / Analysts use Click-thru Rate (CTR) to measure success of their acquisition campaigns. Nothing much to write home about, but certainly better than executing faith based initiatives. A smaller percent of those Marketers / Web Analysts will move beyond clicks and measure Visits / Visitors and Bounce Rates to measure success. Lovely, warm hugs and smiles for them. A fraction of those Marketers / Directors will calculate Conversion Rates for those marketing campaigns. They deserve our love. [And if they measure Micro Conversions they deserve our love AND respect for exhibiting savviness by using economic value.] But all of the above is still focusing on short term success. Even measuring Visitor conversion rates (Visit based conversion rates promote bad marketing behavior) is akin to declaring success after a one night stand. I reserve the best hugs, kisses, smiles, love, respect and my deepest admiration for Marketers and Analysts who use Lifetime Value computations! That is focusing on real success, not simply the first conversion (the one night stand!).
That is focusing finding the customers that create value for the company, long term.
That is truly doing the kind of Analysis Ninja work that solves tomorrow's problems today! For the above reasons I have been meaning to write a post on computing Lifetime Value for a very long time. But perhaps a better idea is to get an expert to do it, the result will clearly be far better than anything I would write. So I emailed my friend David. : ) David Hughes is the Co-Founder of the email marketing consultancy called The Email Academy and the author of one of my most beloved phrases: Non-line Marketing! His blog, Non-line Blogging, is a favourite of mine. There are a handful of people in the world I could spend the whole day talking work and still have things left over to discuss, to learn. David is one of those super-smart, funny, and nice people. I have consistently found his ideas to be practical, grounded in common sense and instantly useful. I could not be more thrilled that he agreed to cover this tough, yet rewarding, topic. In this post David covers:
Buckle up, this is going to be fun and it just might change your life! :) Here's David. . . __________________________________________________ Solve tomorrow's problems today – introducing Life Time Value. Acquiring new customers isn't getting any easier: We've picked off the low-hanging SEO fruit, we're paying more for quality clicks in AdWords and the going rate for affiliate deals just keeps getting higher. We are also haunted by the specter of "marginal cost": The more customers you need, the more impressions and clicks you need. But as we drill deeper into worse performing media, or pay out for lower-volume-lower-relevance search terms, our cost per sale gradually rises. There is a better way to analyze your acquisition strategy than simply using Conversion Rates or Cost Per Acquisition (CPA). Using Life Time Value might be a much better idea. Life Time Value (LTV) will help us answer 3 fundamental questions: 1. Did you pay enough to acquire customers from each marketing channel? 2. Did you acquire the best kind of customers? 3. How much could you spend on keeping them sweet with email and social media? I'm going to suggest that maybe you should be paying significantly more money for the right customers. Let's start at the very beginning… …that's a very good place to start. Take a snapshot of your customer database for the past 2 years and it may look like this: That is an average. The trouble with averages is they conceal all the really interesting stuff that's going on beneath the surface. If you look beyond the averages you'll find that some of your clients are "better than average" and some are "worse than average". Try and segment the customer base by total purchases over a longer time period, say a year, or total spend and you may come to a conclusion that says something like: My most valuable customers last year bought 4 times compared to an average of 2. They tended to spend 40% more than average per order. However, they might cost significantly more to acquire. Much better than the average right? So, where did you get the valuable customers from? Simply knowing that you are getting lots of conversions is not enough, you might just be getting new low value customers. This is where Lifetime Value becomes interesting: Some companies are getting really worried about the lasting impact of "buying cheap customers". For example, in many markets the price comparison intermediary (/engines) is an easy option – you pay your money (affiliate fees) and you take your customer. But how likely are these customers to buy another product? Or hang around for a few years? With no brand affinity there's no desire to cross-buy and maybe we're filling up our databases with low value, promiscuous customers. A simple segmentation by channel can easily help us answer these key questions. The output may tell the following story: But, I hear you cry, Search Marketing is labour-intensive, risky and costly compared to buying customers at a fixed price from an intermediary. OK, so let's look at how much MORE we should be paying for Mr Right, rather than Mr Average. Let's change the headings of the table above to be clear what we're talking about… Best and Average customers will have different Year 1 buying patterns: Once we have done this basic segmentation we can then factor in the cost of acquisition per segment to determine the Net Profit per customer per segment. You'll work with your acquisition team or your finance team to get the cost data. For some of your campaigns this data might not be easily available in your web analytics tool (it is also quite likely you are doing all of this analysis in Excel). The table you'll end up with might look like this:
It should be pretty obvious at this point that simply taking the short-term view with metrics like Cost Per Acquisition (CPA) might not be prudent since you are rewarding the source sending you Mr. Right and Mr. Average just the same. Yet they are not of the same value to your business (Net Profit!). It is important to move away from a cost-based acquisition model to one that recognises the cross and up-sell rewards of acquiring the right customers over the duration they'll be our customers. Spend an extra $8.00 per customer, if you have to, and you're still twice as well off than buying rubbish ones! But we can do so much more… let's take a longer term view. Value-based Segmentation & Life Time Value. By now we have established this: Some of your customers are going to be spending more with you, for longer. Let's say I am a car insurance company, or a subscription publisher, with a desire to sort out some of tomorrow's problems today. I know that the initial cost of acquiring customers (or policies/subscriptions) will only go up as more of my competitors sail for the calm waters of "cost per acquisition" pricing. So, if I need to sell 10,000 policies every year I have 2 options. Without doing the value-based segmentation we'll never understand which channels bring in the best customers and that would be a terrible shame. The ground truth is that I can re-new a policy or subscription for considerably less than buying a new one. How? One strategy might be to spend an extravagant $1.00 of marketing costs to show my love an appreciation to our customers throughout the year via email or social media, increasing the chances they'll buy again. That means I won't have to spend $20.00 buying a new one… a saving of $19.00 per renewal. So if I can grow my repeat purchase rate from 20% to 40% that means I will generate 2,000 policies at $1.00, not $20.00. That's a $19.00 savings on each of the 2,000 policies. BAM!! Moving to a Life Time Value acquisition strategy will save my company $38,000. Not bad for a couple of days work. Let's finish off the concepts of value based segmentation and lifetime value by going back to the original example we were working through. If we can identify channels, campaigns, media or propositions that deliver "better than average" customers we can begin to see how much more profitable they are and decide how much more we should be spending on them. Here's the (sample) analysis I (or you!) would do: Ladies and Gentlemen – select your lifetime! In the above example I've modelled a 3 year lifetime – that would be sensible for a typical consumer e-commerce player. Publishers and financial services companies may take a longer term view… certainly off-line we have been building 5 year plans in publishing for decades. If you're more comfortable with 6 months or 18 months, then go for it! If you do you'll need to be looking backwards and forwards at the same time. You may only have 6 months of on-going data for some segments, but use that as a starting point and build some simple scenarios from there: Over time as you replace modelled data with real data you should be able to re-weight your acquisition spend, replacing one affiliate with another as the cross and up-sell orders begin to roll in (i.e. the customers you acquired begin to make additional purchases from you). By rewarding the better partners / media / acquisition channels with higher CPA's you'll be building a defensive position that prevents competitors buying their way into the good sources ("How can they afford to pay THAT MUCH?!" they'll all be wondering). It will be our little secret. Life Time Value is for Life, not just for Christmas. We've really only just scratched the surface of LTV in this blog post. Many people have devoted their whole careers to unlocking its mysteries so apologies to all of them for the "top level" content here. However, it is a concept that deserves the attention of a new generation of digital marketer and it will alter the way many companies approach acquiring and retaining customers. __________________________________________________ Amazed? Don't cha feel a little bad that you were making decisions about where to invest your precious marketing dollars based on either Conversion Rate or based on Cost Per Acquisition? What's scary is that you could currently be using Conversion / Average Order Size / Cost Per Acquisition to invest more in one particular channel, all the while, unbeknownst to you, shoveling "poor quality" customers. Or "high CPA's" might have caused you to not spend enough on a channel where you can get lots and lots of high value customers. Scary! Yet exciting that finally you can be so much smarter!! Bonus: As a very special treat David's created an Excel spreadsheet to help jumpstart your Lifetime Value journey. The spreadsheet has two tabs. Comparison LTV lets you model two segments of customers by helping you walk through clearly articulated questions. Detailed LTV kicks things up a few notches by allowing you to make better decisions by modeling out the long term performance for a given customer segment. [Create more copies of this tab to model out multiple customer segments and then compare / contrast to make wiser decisions.] Download: Comparison + Detailed Lifetime Value Model. Closing Operational Thoughts: I wanted to add a few thoughts about the operational things you need to worry about / keep in mind, as you revolutionize your company by using LTV: 1. You'll notice instantly that almost none of the data above is available in your web analytics tool. Not Omniture's Site Catalyst, WebTrends Analytics, Coremetrics, Google Analytics or Unica or whatever. This type of PII and financial data does not exit in these tools (often for a very very good reason). Even the web analytics tools that say they create Lifetime Individual Visitor Experience (LIVE) profiles to compute Customer Lifetime Value (CLV) won't have the key Margin or multi-channel data, and hence not truly allow you to do the above, contrary to what might have been implied. Web Analytics tools, even ones with lifetime visitor profiles, usually can't even stich together one person's clickstream behavior over the long term because of cookies and other data erosion issues. So plan on looking outside. 2. [Because of reasons immediately above and more...] Remember to focus not on the "Individual Customer", rather focus on the acquisition channel by analyzing segments of customers. Individual anything ("you can track every single customer and understand every single customer and react to them in real time!!!") is over-rated. Optimizing acquisition channels with LTV. Yea! Optimizing for Jim Sterne with LTV. Nah! 3. You'll do most of this type of analysis via your ERP / customer data storage system / financial data warehouse. Your BFF will be the Finance team, both to initially teach you some of the financial intricacies and give you access to data you need. Look 'em up. Take 'em out for dinner. Trust me when I say that the LTV work will be a tremendous asset to your career and expose you to the highest levels of your organization. A really really good thing. 4. You are going to have to darn near sleep with your IT team/person to ensure the key meta-data required to do this analysis passes from your website to the sources mentioned in #3 above. For example in my first job I had to request (ok beg) the corporate IT team (ok one person) to enhance the corporate system with two columns so each web order order could be distinctly identified and contain "campaign id" and "acquisition cost". The lack of this meta-data is where most LTV efforts fail. Even if you are a 100% web business you'll have to ensure the "backend system" that contains this key web analytics meta-data else you are doomed. Sorry. 5. If you are multi-channel company (web, call center, stores, catalogs) you'll want to ensure an equivalency exists in your backend system to [A] track the same customer's multi-channel orders correctly [B] contain cost data from all multi-channel campaigns. This is really really hard to do. Don't try to climb mount Everest on day one. Start small and build over time. Remember David's tips on making do with just what you have. I want you to be aware of these few valuable lessons I have learned in my own journey. I had to learn them the hard way. : ) If LTV sounds like it needs effort and love then you have understood it correctly. Everything worth it is hard in life, but if you put in the effort you'll create an enviable advantage for yourself and your company. In closing: 1. Focus on long term success, acquiring truly valuable customers… 2. by embracing Net Profit and Lifetime Value… 3. and becoming BFF's with the Finance Team, good things will come of it! Good luck! Ok now your turn. Have you used lifetime value or other such metrics to enhance your acquisition strategies? What was your experience like? If you have not used LTV, do you plan to use it now? What did you find to be of most value in this post? What would you disagree with? Did you want to run to England and give David a hug? :) Please share your feedback via comments.
[Please do not click on the link above, rather right mouse click and choose Save Link As or equivalent in your browser. Thanks.]
April 5th, 2010 at 04:24
Very inspiring (top level content) post!
Once you get the initial tracking in your backend systems sorted out, it is truly amazing what details you can dig out. And it is really not that hard to do!
Just have an extra field on each customer and each order indicating where both the customer and order originated from. And I bet you can pull those details (medium/source) out of the Google Analytics tracking code and store along side both the customer and the order. Really, it is pretty simple to get up and running.
I have one problem with the LTV model though: If looking at it blindly it will always favor your oldest running campaigns.
Say I ran a special e-mail campaign 4 months ago. When looking at the LTV of ALL my marketing campaigns, the regular ones will always out-perform the e-mail campaign. Simply because the new customers/orders that the campaign generated hasn't accumulated enough LTV yet.
Marketing campaigns are usually evaluated once every month or every 6 months. How do you avoid that your not-so-analytics-savvy-marketing-boss will come to the conclusion, that some of your new initiatives are performing like rubbish, just because his favorite business intelligence tool reports a low LTV for those campaigns?
LTV tracking is indeed an extremely powerfull tool, especially in out-bidding your competitors. But make sure your staff (esp. management) is educated well about the pitfalls.
April 5th, 2010 at 05:45
Well said, my friend. If your web analytics efforts are not getting the kind of traction with senior management you would like to see, this is the way to get their attention!
I know it might be more *interesting* to chase down the latest front-end window into the process (iPad!) but in terms of value delivered, this kind of analysis is core. And, once you have this capability, you can value any kind of front-end data – devices, campaigns, phrases – within the LTV context.
Finally, don't let the word "LifeTime" bog down the conversation. Call it / determine "3 month value" or "6 month value" and you will be well on your way to delivering very powerful insight.
April 5th, 2010 at 06:13
Excellent article, Avinash! All SaaS subscription-based companies need to focus on acquiring customers for the long run. As a sales-rep for a SaaS company, LTV is a critical metric and constantly talked about. Data is analyzed on an ongoing basis to identify the "best" LTV type customer.
New Customer Acquisition and compensation should be tied to an LTV metric in order to align the best interest of the company and the sales team. :)
RB
April 5th, 2010 at 06:23
Avinash/David,
Great post. LTV is definitely a metric worth losing sleep over – in order to learn, understand and setting it up.
What I liked about this post is that you articulated the concept very well — and that to me is the key.
Many a times, a HIPPO (or an analyst) wants to calculate the LTV and make the mistake of starting with the calculation/statistics/financial aspect before understanding the concept. The net result is that they are overhelmed with terms like NPV (net present value), interest rate, time-value of money etc. and the LTV effort never takes off.
As Jim said above, it does not matter what you call it – "3 month value" or "6 month value" or something else — the goal of the analyst ninja should be to really understand the fundamental reason why we are doing LTV in the first place and what it represents and set it up in as simple a fashion as possible (KISS principle is very appropriate here).
Great stuff.
Regards,
Ned
April 5th, 2010 at 06:28
Wow this was a great post! Thanks for introducing us to David, Avinash. I love finding new blogs to follow.
Given Avinash's build-up, how rare is it to be thinking about lifetime value within the Web Analytics industry right now? Cutting edge? Something the top companies can demand out of new hires? Something most folks haven't hear about?
April 5th, 2010 at 06:56
I love the timing of this blog post! This article goes really well with the webinar Google released 2 weeks ago about custom variables. Google evangelist indeed!
I also appreciate the faith you have in us readers and letting us know that our time is value. In a lot of your posts (especially about segmentation), I always get the feeling that you're mentoring us by showing us how to figure out opportunity cost that lies within any Analytics decision we make.
Great post, and looking forward to the next one!
April 5th, 2010 at 06:58
^ What Jim Novo just said is what I am doing on my end. I've gone from "lifetime" to "3-months lifetime".
This is a great post that takes a lot of us out of comfort zones but in the end this is going to help out a lot. Thanks Avinash and David Hughes!
April 5th, 2010 at 12:31
Avinash and David have teamed up to give us the simple yet profound concept of LTV. I can see the immediate usefulness and I am going to apply this concept to the huge data of customers. Will try to report the results here.
April 5th, 2010 at 14:01
[...] Excellent Analytics Tip #17: Calculate Customer Lifetime Value, Avinash Kaushik [...]
April 5th, 2010 at 14:26
Avinash,
Thanks so much for this article. LTV has been on our agenda and is a hot topic which very few people know about or understand. I really liked how you broke it down to simple terms to show how to start thinking about it and figuring out who/what is involved in the process. I did want to go to England to give David a hug until I saw him hating on Thierry Henry in one of his blog posts and that made me change my mind. :)
April 5th, 2010 at 17:32
Amazing post, there are some great ways to help foster retention through new web apps and creative advertising tools. We use some great tools like FlowTown and ReTargeter to make sure we are consistently in front of customers and encourage them to come back to our site.
April 5th, 2010 at 17:58
Timely post.
I've been thinking for some time that Conversion Rate is still not the best metric to use when evaluating an online businesses performance.
And Conversion Rate is my favorite metric. (Or used to be.)
April 5th, 2010 at 18:57
Avinash,
There is no doubt in my mind that LTV is apt measurement metric.
However the problem is arriving at the life time value of a customer. With companies, especially the large ones, looking for specific numbers to back up the value computations, it is often misconstrued or ignored by the top brass. Also, the bean counters and most executives are more concerned about the short term (as you allude to the value of averages in the beginning of your post) rather than long term.
My hunch is that LTV can be much more meaningful, accurate and usable by the small and medium sized businesses to their advantages.
April 5th, 2010 at 20:20
Great post! While it is great to look at RPV and Conversion, in my opinion this is just instant gratification. I think we need to start thinking long-term strategy and thus, the LTV concept is very timely. It is time to step out of the normal mode of thinking and look beyond the already overrated CVR!
I am going to explore the model that is used in this post & see how far I go!
April 5th, 2010 at 20:42
Something's wrong with the download link.
All I get is a web page of gibbersish.
Please advise correct link.
April 5th, 2010 at 21:48
Soren: Looking blindly at anything is a very risky thing to do! :)
You are right in that you need for a "lifetime" to pass before your pronounce judgment. One way to think about the issue you raised is that for brand new campaigns (say you have never tried Facebook Display campaigns) it does take a little while to truly judge what the "lifetime" value is, but you can break it down into smaller chunks as David (and Jim and Ned and Joe) have suggested. 3 months, 6 months etc and continuously refine.
For most of your campaigns though, say common strategies like email and affiliate and search etc, you'll have a very solid foundational base of data which you can use to make very very informed decision on the value of current campaigns and quality of customers they are acquiring. Then, as above, you keep refining as you have more data.
Thank you very much for bringing up this very key concept can concern.
Jim: Thank you! Your work (and seminal article: http://www.jimnovo.com/LTV.htm ) have been so instrumental in helping shape my own thinking on this topic. I am thrilled you found this post to be of value.
Ned: Great advice that we should try not to make the mistake of making things far more complicated than they need to be. So many LTV efforts end up in the graveyard due to that mental model. The sad thing is you can extract so much mileage from the simple strategies. Then when it is time to complicate things… go crazy! :)
Josh: It is exceedingly rare to find this type of work / mental model in the web analytics world. IMHO. Primarily because we are so stuck in reporting all kinds of hits and tagging the site and redoing the tags and buying multiple layers of tools to report on visits to the site. We rarely get the chance to take three steps back and focus on the strategic.
This is sad because folks like Jim Novo and Kevin Hillstorm have been beating this drum for a long time.
I hope David's post forces all of us to take a hard look at what we as Web Analysts are actually doing to add value to our companies.
Alex: Loved the comment about David's Online Reputation Monitoring post, it was a very good one. And, ok you are not going to give me a hug any more, I thought Mr. Henry deserved some of David's ribbing!! :)
Mark: Conversion rate is still of some value, but I have always advocated against an obsession with it (even without Lifetime Value computations).
Is Conversion Rate Enough? It's A Good Start, Now Do More!
Paddu: You are right that with the HiPPO's we have to articulate the value proposition of the metric clearly and show that it can help make better decisions. I would reflect the thought Ned mentioned in his comment: try not to overdo it. I think that is sound advice (even if we all, self included, have a very hard time following!).
I have to admit that in my experience the larger the company the more value LTV can add not just because of the things mentioned in this post, but it can also be a great neutral arbitrator of what is right and hence reduce the politics and other machinations that are so popular in large companies.
-Avinash.
April 6th, 2010 at 00:35
Oh what a beautiful post! Back in the day when I ran marketing for a travel company and all of our advertising was paper-based, lifetime value was the key metric for assessing the worth of any media. The "Sunday Times" was several times more expensive as a customer acquisition route, than any other media – but we gladly coughed up the cash, because we knew how valuable those customers were.
But now, working for a company where almost all customer acquisition is web based, it is so much more complex figuring out just which customers have come from where, what that channel cost, and where best value is coming from. We must fight to get there though.
My only reservation with LTV is in line with what Soren is saying – it is not a great way of evaluating new media/channels and can easily be used as a way of justifying "sticking with what you know"
Now, I have a totally random and slightly off topic question that I wondered if you have an answer to, Avinash. I am looking for a good resource (book, blog) on SEO for blogs – specifically the key differences between SEO-ing a blog and a standard website – any ideas you have would be much appreciated!
April 6th, 2010 at 01:53
Very powerful post.
A great look at how to approach LCV and aquisition in general with a no nonsense filter that I really appreciated.
Much love for the "Individual anything is over-rated" – trending by segment, lovely!
Thanks David, and thanks Avinash for the intro :)
April 6th, 2010 at 03:11
Hi Avinash,
An interesting and insightful article as always. Whilst I bought in to the whole LTV concept a while back and this post has given me further insight, I'm not convinced the model outlined above goes far enough to optimise the channel acquisition mix (though I might well have missed something in my early morning fug!).
For me, what's missing is attribution. The model outlined above seems to relate to last click attribution but not drill down into stacking, the attribution of revenue to each campaign that contributes to the final sale.
When looking at what marketing channels to increase your spend in, surely you need to understand which ones are contributing to the final sales. If I take a last click approach, I might divert all my money to email as a retention tool for 'best customers' because that is the channel the majority use on their last click as it is an effective prompt.
However, using a stacking analysis I might discover that my social media activity is driving visits and maintaining customer engagement but the actual sale is then prompted by the email campaigns. In this case, I would attribute a % of the sale value to the social media activity as well. If I removed investment in social media, my email conversion is likely to suffer as well as my engagement levels drop.
In my mind you therefore need to be able to integrate analytics data into your financial modelling to build a more complete picture.
Does this make sense or do you think I'm barking up the wrong tree?
Thanks
James
April 6th, 2010 at 05:33
Great guest blog! Thank you David and Avinash for bridging the gap between a more traditional direct marketing concept and the digital marketing universe. What's great about his post is that it just makes sense. Why wouldn't we analyze which sources of traffic are delivering the most valuable customers? And why wouldn't we be willing to pay more for those uber-customers?
I worked on LTV analysis earlier in my career (pre-web analytics) and it just makes sense to bring that ability to identify, then target, your most valuable customers, on the web.
Thanks again David and Avinash!
April 6th, 2010 at 06:35
Very very inspiring and informative!
As the "average" company we are mistakenly focusing on CPAs!
April 6th, 2010 at 07:11
Avinash and David,
I am a subscriber to both your blogs, and this post justifies the joint presentation of well-know direct marketing analyses with web analytics.
I am greatly in favour of combining a longer-term horizon into web analytics and move away from over-reliance on conversion rates and ROI of first-time responders. This underestimates the complexity of situation, and can leave you under-estimating or overestimating the lifetime values of customers.
What I would recommend web analysts do is to get familiar with the process of calculating CLTVs from the customer database / ERPs *before* they try and marry up the clickstream data with the customer data. It's simply you need to get comfortable with the calculation before layering another dimension.
Can I suggest (if you haven't already thought about it) bringing in Kevin Hillstrom for a guest spot. He has lots of interesting ways of looking at online metrics and forecasting.
Regards
Dan Croxen-John
Applied Web Analytics
April 6th, 2010 at 15:17
Love the article, as usual.
In implementing this, I have a similar concern as James in that folks are immediately going to balk at the concept because it doesnt take into account attribution.
I would say about 30% of our customers come in via a second (or third) source in the same visit. Would you ignore those somewhat fringe cases in favor of using a majority to dictate LTV? It seems that this might be the recommendation given that using individuals is not the point, but rather evaluating the channel.
Or perhaps, look for trends in the visitors who do come in via multiple channels (and hence increasing your costs) and factor that into the overall viability of that channel?
I am very interested to hear your thoughts.
April 6th, 2010 at 21:56
Clare: My reply to Soren's excellent concert is is above (#16)
I understand the caution and we should tread carefully. But there is a way to deal with this, i.e. experiment and not kill things before you have had time to observe if they were "long term successful" (even if it is waiting eight or twelve or eighteen weeks to get the first blush of "LTV" data).
For SEO I am partial to http://www.seomoz.com , I think Rand has built a wonderful community there. The latest SEO book is The Art of SEO: http://zqi.me/bfIbU5
James (/Megan): You are not barking up the wrong tree but I humbly believe that you are merging two completely different issues that are individually hard to solve into one definitely unsolvable problem.
This comment space is not enough to do justice to a thoughtful reply so let me try to share a couple highlights and recommend that if you have my book Web Analytics 2.0 please jump to Page 358 and read the sections on Multi-touch Campaign Attribution Analysis.
Couple quick highlights: Trying to figure out how to "assign credit" for a conversion is a fatally flawed. Attribution is not the problem. Identifying the best media mix portfolio for our acquisition strategy is. In that context the methodology of LTV can still be applied, if only in the context of the customers you have acquired as a result of the controlled experiments you'll run to find the best mix.
I would recommend, as many have done in comments, taking one baby step at a time. Master media mix optimization for lowest CPA. Master application of LTV to optimize individual / group of channels. Work on trying to see who those two different things work together.
You've raised an important point and I appreciate that very much. Thank you.
Dan: A most excellent point on the order of doing things. 1. Get comfortable with the computations with even non-web data. 2. Go crazy on the web and move beyond CPA's and Conversions! Good point.
-Avinash.
April 7th, 2010 at 00:35
I thought I would add a couple of comments to Avinash's around the whole idea of LTV and attribution modelling. In the blog we wanted to illustrate a simple model that can be adapted to your own organistion's complexity, and we'd still be writing the blog that attempted to tackle last click referrals and LTV to EVERY market and channel!
Just to illustrate the futility that Avinash alluded to in the quest for first click/last click/balanced/weighted attribution models, lets not rule out the role of off-line factors too…here is a couple of lines from a blog on multi-channel attribution modelling:
The big problem with our lovely "closed" view of our customers' mind is that it is frequently polluted by mucky, grubby off-line advertising. Maybe it was a print ad that stimulated the click on a banner, or perhaps a direct mail pack thumping onto somebody's door mat that prompted a branded search.
http://www.nonlineblogging.com/blog/2009/9/15/are-you-living-in-the-digital-marketing-analytics-bubble.html
So we see that backward looking attribution modelling is a job for life but a waste of time, but understanding what may have influenced a sale and testing that moving forward seems entirely reasonable.
Finally, how about looking where the lead originally came from, rather than obsessing about the touch-points through the process? For an insurance company, a quote from a comparison engine is easy to track through to sale and LTV and could have a profound impact on how you use that acquisition channel, regardless of whether they finally convert through Facebook or email.
Hope that helps a little! David
April 7th, 2010 at 16:07
Also, as David points out, some customers are more profitable than others.
And some websites are more profitable than others.
So as well as LTV, we should probably be developing a Customer Profitability Value for our websites/online businesses.
I've put forward my own suggestions here
breakthroughecommerce.com/library/ecommerce/confessions-of-conversion-rate-nazi
As I point out, a site with a 2% Conversion Rate may well be more profitable than one with a 20% Conversion Rate.
April 8th, 2010 at 19:44
Lots of ways to consider CLV… one of the best/simplest I've read is "Managing Customers as Investments: The Strategic Value of Customers in the Long Run." More here: bit.ly/cwQDWH
April 8th, 2010 at 22:56
[...]
Introducing Customer Lifetime Value – David Hughes on Occam's Razor
Commentary: It was good to see this new post by my fellow IDM tutor David Hughes on the popular Occam’s Razor site since we rarely see LTV discussed online. A spreadsheet is available for download to get you started.
Implication LTV is a very well-established concept within direct marketing which everyone involved in digital marketing should be aware of and apply to help review the appropriate mix for customer acquisition and retention.
[...]
April 9th, 2010 at 07:08
Excellent post. It's certainly a different way of measuring success as opposed to traditional conversion rates. I'll be sure to keep it in mind.
April 9th, 2010 at 11:33
[...]
Segments for Calculating Lifetime Customer Value
In this article from analytics experts, Avinash Kaushik and David Hughes, visit based conversion rates (or conversion rates based on single visits to a website) are compared lovingly to one-night stands. Lifetime value calculations and measurements provide deeper insight into the marketing lifecycle and how a series of clicks results in a customer, not just a single visit. Further, value based calculations that seek to find the right kinds of customers and where they come from can help save marketing dollars while simultaneously increase profits.
What this means to agencies: Much of the math in articles like this can seem tricky and intimidating, especially to right-brained clients who would consider themselves creatives before they call themselves “numbers guys”. Agencies can position themselves to take on this type of deep-dive analytics, customer database and segmentation work to bring about a sweeping change for clients.
[...]
April 12th, 2010 at 10:21
Love the concept of using social media to help with customer retention.
I think that looking at customer lifetime value is an intuitive thing to do. But many don't take that next step when it comes to doing the ROI analysis.
April 12th, 2010 at 16:57
I love the insight of tracking value of every customer.
Is there a way to automate the customer follow-up transactions?
Or, is it simply that from GA, I see the beginning of the customer engagement, and then track it "off line" with other tools?
Thanks,
-Deven
April 12th, 2010 at 19:41
I decided to catch up on my Google Reader reading at the perfect time!
This post will be passed along to a coworker who asked this same question during an analytics training today.
I've noticed more and more businesses we work with are finally catching on to A – Z tracking (from first touch attribution down to lifetime value; it's exciting). Thanks for a great post!
April 12th, 2010 at 22:27
Deven: Please see the closing operational thoughts section of the post, specifically points number 3, 4, and 5.
In a nutshell Google Analytics (or Omniture or WebTrends or CoreMetrics for that matter) are not doing to 1. store the data you need to do Customer LifeTime Value calculations or 2. keep the history (past/future) to allow you to compute multi-channel CLV. You'll do this outside your web analytics systems (more in the Operational Thoughts section).
Cory: Indeed, really exciting times!!
-Avinash.
April 13th, 2010 at 11:20
I'm not sure that it's always necessary to do your own LTV modelling. If you've got an analytics provider that has enough focus on your industry (e.g. Kontagent for social gaming), you might still be able to get some good LTV-based information from them.
April 14th, 2010 at 19:28
Avinash,
1) I agree, tracking Life Time Value of the customer is one of the most valuable thing Web Analytics can do.
2) Thank you for clearly stating that tracking Life Time Value is not possible in Google Analytics and other standard tools.
3) "Closing Operational Thoughts" section was the most valuable section in this post. Especially the idea of adding "campaign id" and "acquisition cost" columns to every order.
Question: AcquisitionCost is always the same for CampaignId, right? Then why keep both these values in Order table?
Thank you for the great post!
It was a great post!
April 14th, 2010 at 20:47
Math Ninja: I am skeptical that this data will be available in web analytics tools, not because the tools can't handle it but rather because of where the key pieces of data sit today (outside the analytics tools).
You are right that Kontagent is doing some cool stuff.
Dennis: CampaignID will help us connect to the meta-data we need for campaign analysis.
The reason for storing AcquisitionCost is that most of the time it will variable and not a constant.
Think of how your bids for search campaigns, even for the same keyword, will change. Or bounties for affiliate campaigns or CPM's or CPA's for display campaigns.
They change a lot so it is helpful to have the costs listed as well (easier analysis).
-Avinash.
April 14th, 2010 at 23:57
Wonderful post and follow-up comments.
Maybe this is tangential to the main LTV discussion, but I am wondering then about the value of tracking and segmenting repeat customers in your web analytics tool. Or maybe I should look for other for insights, but don't bother to try to approximate LTV from your web analytics?
Best,
Michael
April 15th, 2010 at 02:07
LTV is all about stepping back a bit from your analytics reports and taking in the view. Although it is unlikely that sales will come directly from a banner ad, or an affiliate link (branded search will still get most of the "last click" glory), analysis of where sales originally came from is a really interesting bit of work.
If you're lucky you may conclude that:
- affiliate network A or partner B tend to generate much better value customers than anybody else…let's give them more money as a thank you.
- people coming from web site A adverts or email list B addresses are better LTV customers than other sources so let's spend more with them.
You will need to consolidate data from maybe 2 or 3 sources to get to this point, and the report won't need to include all the granular detail that your analytics tool spits out. Just get a feel for where your best and least valuable customers come from…an excel spreadsheet with "source of first visit" and "are they Hi Med or Low value after 3, 6 or 12 months". If there is no pattern, try looking deeper at creative clicked, or offer.
Simple, but it could be the best day's analysis you'll ever do in order to align acquisition activity to long term profitability.
Onwards and upwards!
April 15th, 2010 at 09:26
I tried to download "comparison+detailed_life_time_value-occams_razor.xlsx" but it's corrupted, Could you please upload a fresh version.
Thanks
April 15th, 2010 at 13:09
I love how your post takes a core concept, and gives a "basic" way of implementing.
Many of my clients haven't even figured out a target offline CPA yet! So we go ahead and start there. We then take that data, and try to get them to add it to their CRM.
In an ideal world, the web analytics tools would talk to the ERP / CRM tools and vice versa, making a very hard job only kinda hard…
We use Mongoose Metrics for phone call tracking, and use some code from Justin Cutroni to add all source medium data from the Google Analytics cookies into the forms.
(You can see his post here: http://cutroni.com/blog/2009/03/18/updated-integrating-google-analytics-with-a-crm/. Unfortunately, he doesn't have a link to the actual code, as he changed his posts when he left Epikone. I did manage to steal it, and will be posting one of these days ;) ).
These are the technical tools I use to start tracking a more comprehensive conversion to sale and LTV/CLV analytical data.
April 15th, 2010 at 22:46
So valuable! thank you so much… I finally get it! :)
April 16th, 2010 at 10:27
Awesome spreadsheet you've provided for us – thank you!
April 16th, 2010 at 14:12
Michael: Web Analytics tools can help you focus on more longer term success oriented metrics.
For example my favorites Visitor Loyalty and Visitor Recency are both geared towards looking beyond a single visit mindset. Or simply using Unique Visitors in the denominator when computing Conversion Rates rather than using Visits.
So there is certainly progress to be made in moving in the right direction with Google Analytics or Yahoo! Analytics or Site Catalyst.
If you are able to segment Repeat Customers in your Web Analytics tools then you can and should do that analysis.
Sadly what analytics tools today provide is Repeat Visits and, some will provide, Repeat Visitors. Neither one of those two actually is Repeat Customers (someone who submitted a lead, multiple leads, or placed an order/multiple orders).
But if your tool provides Repeat Customers then use it because at least for the Web you'll have a "lifetime" view, that is a fantastic first step towards a multi-channel lifetime value.
-Avinash.
April 17th, 2010 at 02:57
[...] Occam's Razor – Customer Lifetime Value Mal wieder ein richtig guter Grundlagenartikel, der nicht nur eine Maßgröße einführt, sondern auch gleich erklärt, was man damit anstellen kann. Gerade für diejenigen SEOs unter uns lesenswert, die nicht aus dem Marketing stammen, wo dieser Begriff oft Verwendung findet. [...]
April 18th, 2010 at 12:30
[...] Excellent Analytics Tip #17: Calculate Customer Lifetime Value by Avinash Kaushik [...]
April 20th, 2010 at 00:57
To the comment #1, where there is a reference to recent campaigns not accumulated enough LTV yet, so LTV analysis favors longer-running campaigns. That is not the way to think about LTV, it is not past value, but future value.
LTV is forward looking not backward looking. Of course, you can and should look backwards to get an idea of the future, and you do need past data to estimate it, but you need to be looking forward the same distance in time for all your customers. Once you convince your managers that LTV is about future value, not past value, the time window issue will go away.
The longer this forward-looking horizon, the better your results will be. However, in real life you have to balance what you wish you knew with what you actually know about your customers. So I would recommend choose the shortest history (i.e. most unknown) customers that are of interest to you in an analysis, see how far in future you are comfortable predicting their behavior, and then bring in all your other customers to the same time horizon.
April 21st, 2010 at 12:05
Downloading the Excel file does not work with FireFox. Ironically, it does work with Internet Explorer.
April 28th, 2010 at 12:27
Avinash,thanks for this article! I agree that the LTV concept is very timely.
April 29th, 2010 at 03:18
[...]
Avinash Kaushik, one of the leading experts on web analytics, just made an excellent point about not overlooking the lifetime value of a customer on his blog, Occam’s Razor. In it, he alleges, it is important to not merely view a customer by Cost-Per-Acquisition (CPA) or the cost to get a customer. Instead, it’s best to calculate the Lifetime Value (LTV or the total value that customer brings through spending) of each group of customers based on how you find them. Then do a simple, cost-benefit analysis. Where are you finding the most profitable customers, and how much does it cost to do so?
[...]
April 30th, 2010 at 02:03
[...]
Do you know how to calculate lifetime customer value? Avinash Kaushik walks you through it.
[...]
April 30th, 2010 at 02:51
[...] Are you calculating the lifetime value of your customer? [...]
May 1st, 2010 at 08:02
[...]
Calculating the Lifetime Value of a Customer – This is a bit of a marketing nerd’s read but I still think it’s a good one to try to follow because it makes an important point about the value of long term customers
[...]
May 1st, 2010 at 11:20
[...]
Web analytics : calculate customer lifetime value
[...]
May 3rd, 2010 at 03:29
Good and inspiring article.I agree that the LTV concept is very timely. Thanks for sharing…..Keep it up.
May 13th, 2010 at 04:17
I read your post today and found this is very inspiring post with LTV concept. I look forward to your next post.
Sarita
May 15th, 2010 at 21:29
[...]
Avinash Kaushik的博客中最近更新的一篇文章——Calculate Customer Lifetime Value,里面非常详细地论述了什么是网站用户的生命周期价值(Lifetime Value,简称LTV),及为什么要使用LTV这个指标。其中主要阐述的是在SEM及网站推广的过程中不要仅关注于一次访问(Visit)中的转化率(Conversion Rates)和CPA(Cost Per Acquisition)这些指标,计算用户在网站的整个周期中创造的总价值将更具意义,用户生命周期价值对于衡量网站的推广策略非常具有参考价值。
[...]
May 20th, 2010 at 09:02
[...] Calculate Customer Lifetime Value (LTV) [...]
June 9th, 2010 at 18:02
I think the link to the LTV spreadsheet in the article is broken. When I click on it, my browser (Firefox) opens a page with junk characters. I tried saving the file and that doesn't work either. Could you please fix the link?
Thanks
Shashi
June 10th, 2010 at 06:09
[...] Calculate Customer Lifetime Value (LTV) [...]
July 19th, 2010 at 06:31
[...]
Avinash Kaushik的博客中最近更新的一篇文章——Calculate Customer Lifetime Value,里面非常详细地论述了什么是网站用户的生命周期价值(Lifetime Value,简称LTV),及为什么要使用LTV这个指标。其中主要阐述的是在SEM及网站推广的过程中不要仅关注于一次访问(Visit)中的转化率(Conversion Rates)和CPA(Cost Per Acquisition)这些指标,计算用户在网站的整个周期中创造的总价值将更具意义,用户生命周期价值对于衡量网站的推广策略非常具有参考价值。
[...]
July 21st, 2010 at 09:31
[...]
Our wig client realizes about a 12x return on each email drop. However, they segment their lists according to a number of criteria and mail appropriate offers with relevant content and offers to each segment. Another of our clients sends out a newsletter 3x and only offers products for sale on the 4th email. This company’s conversion rate is exponentially higher because it has built a relationship and has trigger the “reciprocity rule” by giving something of value for free 3x’s.
Here is the link I promised: Occam's Razor
[...]
January 21st, 2011 at 22:24
Calculating the total lifetime value of a customer is just good business practice. I extends way beyond online advertising and into expenses for customer service etc. Any business that does not do it is mad.
February 2nd, 2011 at 14:05
[...] conversation on the issue of what is the right time horizon for computing LTV (life time value):http://www.kaushik.net/avinash/2…LTV is forward looking not backward looking. Of course, you can and should look backwards to get an [...]
May 2nd, 2011 at 10:38
I've been researching for this issue on the past week and found it really important.
What i'm trying to figure out now is, considering a freemium model for a web product, how to track the entire customer lifecycle, since his first visit to the time when he starts to pay to have premium account.
I need to tie the revenue generation to the first source that brought the user in order to derive the best one.
I'm struggling with Google Analytics and finding ways to track the cycle: Acquisition, Activation, Retention, Referral and Revenue. But the hardest thing is to tie the last to the first.
What do you think is the best way of getting this? Maybe move to a database level approach?
May 2nd, 2011 at 14:57
Lucca: Most of the data that you will need will be outside the web analytics tool, much of it in your "backend" databases (customer relationship management and erp systems – no matter how simple or how sophisticated they are).
The web analytics tool you use, any one, will serve as one important source of data, but just one. So you are better off with that optimal approach.
-Avinash.
May 3rd, 2011 at 09:01
What about KISSmetrics? Have you ever tried it?
May 5th, 2011 at 07:06
This is great!!
Multi-Channel Funnels on Google Analytics:
http://searchengineland.com/multi-channel-funnels-assists-coming-to-google-analytics-72833
The most lacking feature in Web Analytics