How to estimate Lifetime Value; Sample cohort analysis July 19, 2010
Posted by jeremyliew in Ecommerce, ltv, subscription.8 comments
In many businesses, repeat purchase behavior is a key driver of value. Many companies track % of repeat purchases as a key business metric. This is useful in steady state, but can sometimes be quite misleading if the company is showing substantial growth. By definition, growth implies many first time customers, and the mix of these new customers can distort the view into how much repeat purchase behavior is actually occuring.
I prefer to try to analyze repeat pruchase behavior, and hence, estimate lifetime value, by doing cohort analysis. This is approximate by definition, but it can give you some sense of lifetime value well before you actually see a full customer lifetime, which can help in accelerating decisions about marketing and customer acquisition. I recently posted about how you can improve LTV and CAC for your subscription or repeat purchase business. But how do you estimate Lifetime value?
I’ve uploaded a spreadsheet with a sample cohort analysis, using representative but dummy data to illustrate how to do this.
In this particular example, I look at a hypothetical subscription business. Assume that the business has been in operation for one year. First, divide the users into cohorts depending on when they initially subscribed to the service. I calculate retention at the end of month N by dividing the number of subscribers still subscribing after month N by the total number of subscribers that started in each cohort. These are the numbers in blue. Obviously, for the subscribers that started in month 1, we have 12 months of retention data, for the subscribers that started in month 2 we have 11 months of retention data, and so on.
By averaging across the cohorts, you can get an average retention rate at the end of one month, two months and so on. As the cohorts age, there are fewer datapoints to average over, and hence the potential for error is greater. However, it is still a useful exercise to get an early indication of how the business looks.
A typical pattern found in subscription businesses is that after a steep drop off after an initial period, month-on-month attrition rates tend to level off. You can see a similar pattern in this example, where after the first month, month-on-month attrition rates are around -6% (ie month N subs ~ 94% of month [N-1] subs).
If you see a pattern like this, you can extrapolate forward using the same month-on-month attrition across several years. As you can see in the model, we extrapolate an average lifetime of 9.77 months by extrapolating forward over 5 years of data.
So if you were a subscription business charging $20/month with 90% gross margins (after accounting for customer service costs for example), then you would attribute a lifetime value for a new customer of 9.77 x $20 x 90% = $176. This sets an upper bound of what you would be willing to pay to acquire a customer (although in practice, you would prefer to see a ratio of CAC/LTV in the 25-35% range).
This example is for a subscription business where the key value driver is the number of active subscribers. However, you can conduct similar analysis on any type of repeat behavior business. In a social business the metric might be activity (e.g. how many users posted a photo this month), and in a social game the metric might be dollars spent in virtual goods that period. The measurement periods may vary according to the tempo of the business. Many social games do their cohort analysis on a daily or weekly basis, whereas some ecommerce companies whose purchases are less frequent may do their cohort analysis on a quarterly basis. This will dictate how long you have to collect data before you have enough data to project forward.
Different billing mechanisms can complicate this (e.g. an annual billing system will by nature skew average lifetime upwards) and while these can be important levers, it is usually helpful to hold billing constant and compare cohorts on a same-billing basis, at least initially. However, this cohort analysis is also useful tool to see what the impact of changes in billing, registration flow, product features etc can have on retention as you can often see an increase in early month retention from later cohorts.
The spreadsheet for the sample cohort analysis is read only but you can download it to play with it yourself.
I’d love to hear from others how they estimate lifetime value.
Why online brand spending will create new winners in online ad networks July 14, 2010
Posted by jeremyliew in advertising, branding.9 comments
One of Lightspeed’s consumer internet predictions for 2010 is that brand advertising dollars are going to start to flow online at scale. Two thirds of all ad spending in the US is for brand advertising, yet three quarters of online ad spending is direct response.
The recession of the last couple of years has provided a catalyst to drive more brand marketers online in an effort to seek greater efficiency in their media buys, and as they have tasted some success, they will continue to spend online as their marketing budgets recover.
Late last year the IAB put out a very interesting study about building brands online. I recommend that you read the whole thing if you are involved in the online advertising industry.
For those of you who won’t, here are some highlight charts:
Marketers believe that the internet can be a branding mechanism:
But the bulk of online advertising volume today is not considered effective for brand building:
This is because most online ad inventory has been optimized for direct response advertisers, whereas brand marketers want to see their traditional metrics (click image to see full detail):
Furthermore, brand advertisers want relationships with the media companies that they work with, not simply self service efficiency (again, click image to see full detail)
Most brand advertisers have primarily stuck with portals and big publishers who offer brand safety, reach/frequency control, reporting on the metrics that they care about and strong relationship, but often tied to higher priced media. As brand advertisers seek better efficiency from their online media budgets, they will turn increasingly to ad networks. Although there are over 300 ad networks today, the vast majority of them have grown over the last 10-15 years by optimizing their offering for the direct response advertisers who have constituted the vast majority of online advertisers to date. I think we’ll see a new generation of ad networks emerge who are tuned to cater to the specific needs of brand advertisers, and I’m actively looking to invest in companies with this mindset.
How can you improve LTV and CAC? June 15, 2010
Posted by jeremyliew in CAC, ltv.9 comments
A lot of the startups that have quickly reached millions in monthly revenue rely on the arbitrage of being able to acquire customers through paid marketing for less than the lifetime value of that customer.
CAC < LTV
As a reminder, lifetime value, or lifetime contribution as it should perhaps more accurately be named, is given by the formula:
LTV = Expected Life x ARPU x Gross Margin
where Arpu = average revenue per user in each time period. This equation can hold whether you are in a subscription business or an ecommerce business with repeat purchase behavior. Although you need to be a bit more nuanced with non subscription businesses, the same cohort analysis techniques still allow you to approximate LTV in this manner. I’ll post more about this later.
Both LTV and CAC are key metrics that the management teams should be focused on improving.
Usually CAC is a blended average of several customer acquisition costs from several different channels. Each of these channels typically can be optimized by better targeting, better copy and creative on the advertising, better landing pages,optimization ofthe flow through to checkout, more and better payment options, and increased viral pass along.
Some of the tools that can be used to improve LTV include retention programs to extend life, cross sell and upsell campaigns to increase ARPU, and improving gross margin.
Both metrics are very important. However, if resource constraints force a choice between focusing on one or the other (it can be hard enough to do one thing at a time at a startup!), I would choose to focus on lifetime value. There are two reasons for this. Firstly, most of the improvements that can be made to LTV will improve LTV for all users, both current and future, and regardless of channel of acquisition. In contrast, many of the improvements that can be made to CAC are channel specific (e.g. copy of a particular ad) and none of them improve the economics of existing customers, only new customers. You get more leverage out of your efforts on LTV.
Secondly, because LTV is typically already higher than CAC, an x% increase in LTV has more impact to the company than an x% reduction in CAC.
I’d love to hear what others think about this choice, and about other ways to improve both CAC and LTV
Why Lightspeed invested in ShoeDazzle April 28, 2010
Posted by jeremyliew in Ecommerce, growth, subscription.Tags: shoedazzle, entertainment commerce, push commerce
6 comments
Lightspeed led a $13m investment in Shoedazzle, announced yesterday. We are very excited to help Shoedazzle grow.
Shoedazzle is one of the companies that I was thinking of when I wrote about startups that can quickly get to millions in monthly revenue:
… are all taking advantage of one of Lightspeeds consumer internet predictions for 2010, that direct direct response advertising is getting more efficient. A bad time to sell ads is a good time to buy ads. All these companies are taking advantage of relatively low customer acquisition costs.
If you understand your customer lifetime value, and you can acquire customers for 20-30% of the lifetime value, you are going to make money. Understanding lifetime value is hard for media companies, but it’s easier for gaming companies, ecommerce companies and subscription businesses. They have predictable customer behavior cohorts that can be extrapolated from a few months of data from a representative sample. Running an aggressive positive arbitrage while online media is cheap has allowed all of these companies to grow revenue very fast once they get the micro-economics right.
The company is based outside of Silicon Valley (LA) and is definitely built on the back of business model innovation, as are many of the current crop of fast growth companies.
Shoedazzle has a terrific user value proposition. A member first takes a style quiz to assess her taste. Then, on the first of each month, she receives an email with five pairs of shoes that have been specially selected for her. If she likes one of the pairs, she buys it. If none of them grab her, she can either skip that month, or request a re-selection and give specific guidance as to what she is looking for (e.g. boots, or higher heels, bolder colors). Women get personal stylist advice and recommendations brought directly to them, helping them to keep abreast of the latest fashion trends.
Thematically, I am very excited about the move towards entertainment shopping, and Shoedazzle falls squarely into this category:
One of the most exciting trends in e-commerce over the last couple of years has been the trend towards “shopping as entertainment”. Traditionally e-commerce has been a chore type activity. Customers know what they are looking for (a digital camera, a new laptop) and are looking for the best product and best price with a very “research” based mindset.
This is quite unlike the real world, where a customer might walk around a mall without any particular purchases in mind, and perhaps opportunistically buy something that caught their eye in their wanderings. There is no real “intent to buy” in a trip to the mall. It is more like entertainment time which may, or may not, lead to a purchase.
SheoDazzle captures the wonderful serendipity of finding something great as you wander the mall, and brings it into your inbox.
Kim Kardashian is one of the co-founders of Shoedazzle, and has been instrumental to the success of the company, both through her promotion of the site, and through her fashion input into the shoe selection. But this company is about much more than Kim alone. The company prides itself on delivering terrific experiences to its members, and this has resulted in an incredibly strong and positive community, as reflected by the vibrant wall on its facebook page, the constant tweeting on twitter, and even the unboxing videos on youtube.
Notwithstanding Kim and the community, Shoedazzle is about the shoes. And that is what has let the company grow through word of mouth. This isn’t the manufactured virality that works so well for facebook apps and early social networks, riding the transports of notifications, invites, wall posts or email importation. This is the real thing, with one happy member telling another about where they got their great shoes.

On the flip side, online commerce is an operationally intensive business. With physical goods, you get lower gross margins then you see in online media. In shoes, return rates can be high (Zappos’s average return rate is 35%). If you care as much about member satisfaction as Shoedazzle does, client care needs a lot of resources. And breaking through the noise and clutter on the consumer web is always difficult. Building a business like shoedazzle is not as easy as simply hacking all night for a few days and standing up a website. It requires deep knowledge of merchandising, logistics, customer care, marketing and promotion.
Shoedazzle has a terrific team of experienced, passionate people (with great shoes!) who are tackling this challenge, and at the end of the day, that is why we invested in ShoeDazzle.
Business model innovation is making Silicon Valley less important as a startup center April 19, 2010
Posted by jeremyliew in growth.12 comments
Last week I noted some companies that have quickly grown revenues to over $1M/mth, including Zynga, Playdom, Playfish, Gilt, Hautelook, RueLaLa, Groupon, Living Social, Lifelock and Zoosk. Later I and others added Crowdstar, Cash4Gold, Shoedazzle, Second Life and TheLadders to this list.
It’s interesting to break this list down geographically, especially if you seperate the gaming/virtual world companies from the rest.
- Gaming Companies in the Bay Area: Zynga, Playdom, Crowdstar, Second Life
- Gaming Companies outside the Bay Area: Playfish (London)
- Other Companies in the Bay Area: Zoosk
- Other Companies outside the Bay Area: Gilt (NY), HauteLook (LA), RueLaLa (Boston), Groupon (Chicago), Living Social (DC), Lifelock (AZ), Cash4Gold (FL), Shoedazzle (LA), TheLadders (NY)
Given that the the Bay Area attracts the most VC funding (a proxy for startup activity), the fact that most of the gaming/virtual world companies are based here isn’t too surprising. But what is pretty surprising is that the vast majority of other fast growth companies are from outside the bay area.
One notable thing about many of these companies is that they innovated more on business model than on technology or product. While there is some core technology to each of these companies, most of them have more people in functions like marketing, sales, customer care, merchandizing etc than in technology. This is in marked contrast to the gaming and virtual world companies where the bulk of the headcount is in technology since the product is the game.
Many other “hot” companies in the bay area also show a bias towards product and technology in their employee mix; youtube, facebook, digg, etc.
When product and technology are core to the success of a company, Silicon Valley still dominates the startup scene, but when the innovation is in other functions, and technology is more an enabler than core to the product, other regions can be as competitive, if not more so.








