How to Compute Customer LTV

Share this article:
To reference chart please use link below:


Http://www.dmnews.com/pdffiles/hugheschart.pdf


Everyone talks about customer lifetime value, but few have actually calculated it. The process is not that difficult. When you finish this article, you will be an expert.


What is lifetime value? It is the expected profit that you will realize from sales to a particular customer in the future. Though it builds on customer history, LTV is all about the future. It is based mainly on the customer's expected retention and spending rates, plus some other factors that are easy to determine. Let's begin with a typical LTV table.


In this table, 100,000 customers are acquired originally. We are following their purchase history for the next three years. The first thing you will notice is that 40 percent of them disappear after the first year. The retention rate is only 60 percent. In future years the retention rate grows. The loyalty of retained customers is higher than that of newly acquired customers. As customers stay with you, their number of orders per year and average order size tend to rise.


We are assuming a 70 percent cost of sales. Your number may differ. The cost typically goes down after the first year. The cost of customer service to existing customers is usually lower than that to new customers.


It costs you $55 to acquire a customer. This is computed by taking all your advertising and sales costs and dividing this by the 100,000 customers you acquired. We are assuming that you spend $20 per customer a year on subsequent marketing, including the cost of the database that provides the information needed for this table, and is used to provide the personal communications needed to improve the retention rate.


The gross profit is simply the revenue minus costs. We have to divide this by a discount rate to get the net present value of the expected profit. The discount rate (based on interest rates) is needed because future profits are worth less in today's money than present profit.


The formula for the discount rate is:


D = (1 + (i x rf))n


D = Discount rate, i = interest rate, rf = the risk factor and n = number of years you have to wait. With a risk factor of 2 and an interest rate of 8 percent, the discount rate in the third year (two years from now) is D = (1 + (.08 x 2))2 or D = (1.16)2 = 1.35.


The lifetime value is calculated by dividing the cumulative LTV by the originally acquired 100,000 customers. The LTV in the third year is $53. That means the LTV of the average newly acquired customer is $53 in the third year. In this one number we have encapsulated the retention rate, the spending rate, the acquisition, marketing and goods costs, and the discount rate.


From this table, you can learn quite a lot. As you can see, acquiring new customers is not a profitable activity. Customers, in this case, become profitable only in the second and third years. This is typical. It is why money spent on increased retention has a higher payoff than money spent on acquisition.


We have calculated an average LTV for a group of 100,000 customers. We now have to figure out the LTV of each individual customer. This is done by creating customer segments. How you develop customer segments is an art. It depends on your customer base and marketing program. Segments might be by age (senior citizens, college students, etc.), spending habits (gold, silver, bronze) or product type (deluxe, regular, economy), etc. However you do this, you can redo your LTV table to create a LTV for each segment.


Jane Adams, one of your customers, may be a deluxe customer, who spends $300 yearly. The LTV of the deluxe customers, for example, may be $100 in the third year. They may spend an average of $200 per year. So Jane Adams' third-year LTV is $150 ((300/200)*100)). You can set up a program to compute this number for every customer and put that number into your customer database.


LTV can be a valuable tool. You treat customers with high LTV (high expected future profit) differently from those with low LTV. You spend more to retain them. Some customers may even have negative LTV. Why spend a lot of money trying to retain them?


The LTV table can be used to evaluate the expected results of new marketing programs before you have spent millions on them. When you come up with a new initiative, estimate what it will do to the retention rate and the spending rate (orders and average order size). Some marketing programs will fail this test. Their benefits will be lower than their costs. They may cause LVT to drop rather than to rise. Don't fund them.


The table also can be used to validate LVT calculations. All of the numbers shown in the table above are real numbers (not assumed numbers like "awareness"). When the second year arrives, you can go back and see what your actual retention rate and spending rate were. If you have been too optimistic or pessimistic, you can learn that and do a better job next year.


LTV is thus a wonderful marketing tool that costs very little to calculate and can return rich rewards in terms of improved marketing strategy. You now know how to calculate it.


Share this article:
You must be a registered member of Direct Marketing News to post a comment.
close

Next Article in Data/Analytics

Sign up to our newsletters

Follow us on Twitter @dmnews

Latest Jobs:

Featured Listings

More in Data/Analytics

DMALive: Getting to 360-Degree Insight

DMALive: Getting to 360-Degree Insight

A Q&A with Mark Wright, president and CEO, Targetbase.

Acxiom East?

Acxiom East?

Ogilvy & Mather launches OgilvyAmp, a think tank for data-driven marketers headed by expatriates from Little Rock's best-known data company.

Epicor to Acquire Analytics Provider QuantiSense

Epicor to Acquire Analytics Provider QuantiSense

Retail solutions provider seeks to up its data analytics game for large and midsized retailers.