By Lightspeed Venture Partners (Reporter)
Contributor profile | More stories
 Story Views Now: Last hour: Last 24 hours: Total:

How to Project Customer Retention for a Subscription Business

We’ve posted before about how to estimate lifetime value (“LTV”) for an ecommerce business and for a subscription business, and have provided a sample cohort analysis for each (ecommerce and subscription).  This is one of the most important factors in understanding unit economics.

Recently, Eric Liaw sent us a very interesting May 2006 paper entitled “How to Project Customer Retention”, authored by marketing professors Peter Fader (Wharton) and Bruce Hardie (London Business School) and published in the Journal of Interactive Marketing in 2007.  In it, the professors explain how previous attempts to project retention rates using line-fitting regression models failed, even after introducing quadratic or exponential functions.  Since we had advocated essentially using an exponential line fit for subscription LTV estimation, we figured it was worth reading.  The authors show that exponential form fitting is too conservative and underestimates actual retention rates.

Professors Fader and Hardie decide to start from scratch with a simple assumption: what if each customer has a fixed probability of renewing his or her contract at the end of each period?  So if I’m a big movie fan, let’s say I’m 80% likely to renew Netflix each month, but you’re caught up on Breaking Bad and only 30% likely to renew each month going forward.  Probability varies by customer, but each customer’s rate remains constant over time.

It turns out that, based on probability theory, this simple assumption implies that the distribution of renewal rates can be characterized by a statistical model.  Over time, the difference in each individual’s probability to renew suggests that individuals with lower renewal probabilities will generally drop out before those with higher probabilities.  Incidentally, this also explains why incremental retention may appear to improve over time, when it’s actually a likely side effect of the remaining customer mix.

After some mathematical gymnastics, the authors unveil the model they’ve derived: the shifted-beta-geometric distribution.  The authors tested the model by using the first seven years of data from a given sample to project renewal rates at the end of the final five years in the sample.  The model proved to be quite accurate, within 3% of actuals, and much better than linear or exponential form fitting.

A few quick caveats: this model is appropriate only when the data reflects a discrete renewal period, such as a defined monthly or annual cycle.  Also, the model should be reserved for projecting behavior in contractual settings, such as subscription renewals and other observable customer exit points, rather than ecommerce or other businesses where the customer can remain dormant for long periods between orders.

We’ve uploaded a spreadsheet here, along with directions for how to use it yourself.

Hope this is helpful.  We look forward to hearing from you regardless, but especially if:

1)    You use the model and have any feedback on results

2)    Your company uses any other methods to capture, analyze, and project customer retention

3)    Your innovative company achieves valuable unit economics.  As previously mentioned, we like to see LTV / Customer Acquisition Cost > 2.5 and payback periods under 12 months.

Before It’s News® is a community of individuals who report on what’s going on around them, from all around the world.

Anyone can join.
Anyone can contribute.
Anyone can become informed about their world.

Order by Phone at 888-809-8385 or online at https://mitocopper.com M - F 9am to 5pm EST

Order by Phone at 866-388-7003 or online at https://www.herbanomic.com M - F 9am to 5pm EST

Order by Phone at 866-388-7003 or online at https://www.herbanomics.com M - F 9am to 5pm EST

Humic & Fulvic Trace Minerals Complex - Nature's most important supplement! Vivid Dreams again!

HNEX HydroNano EXtracellular Water - Improve immune system health and reduce inflammation.

Ultimate Clinical Potency Curcumin - Natural pain relief, reduce inflammation and so much more.

MitoCopper - Bioavailable Copper destroys pathogens and gives you more energy. (See Blood Video)

Oxy Powder - Natural Colon Cleanser!  Cleans out toxic buildup with oxygen!

Nascent Iodine - Promotes detoxification, mental focus and thyroid health.

Smart Meter Cover -  Reduces Smart Meter radiation by 96%! (See Video).

MOST RECENT

SignUp