The Lifetime Value of a Catalog Customer
by Arthur Middleton Hughes

 

Catalog Age Magazine Article

The Lifetime Value of a Catalog Customer

 

By Arthur Middleton Hughes

 

Most catalogers have used the term customer lifetime value, but few of them have actually calculated it, or used it in determining their marketing strategy. Here at DoubleClick our staff has computed customer lifetime value for a number of clients, including catalogers. The results may be helpful for those in the catalog community who want to do the same thing. LTV provides a very useful measurement that can tell you whether your marketing program is going in the right direction. In this article, I will explain how we go about these projects, and what you can do with the results.

 

The need for a database

To compute lifetime value you need a customer database which contains both transactions and promotion history from the catalog, the web, as well as from retail if you have retail sales.  Few catalogers have such databases yet. Most of them have a fulfillment system like Ecometry, which is really swell for getting orders filled and keeping track of inventory, but is no real substitute for a multi-channel database.  Sitting on top of the database you need an analytical tool such as Ensemble or Brio, so that you can get immediate access to the data you need.

Tracking a newly acquired group of customers

Lifetime value tracks the buying behavior of a group of customers projecting that into the future. LTV is defined as the profits that you will receive from a given group of customers within the next three or four years.  For example, we took customers who were acquired in 2000, and measured their behavior in that year, 2001 and 2002.  Here is what we needed to know:

 

  1. The number of customers acquired in Year 1
  2. The number of catalogs used to acquire these customers
  3. The catalogs mailed to them after their first purchase
  4. The average catalog in the mail cost
  5. The customer retention rate  (Year 1 customers who continued to shop in subsequent years)
  6. The customer referral rate (provided by Year 1 customers then and later)
  7. The average order size each year
  8. The average number of orders per year
  9. The cost of goods sold
  10. The average rate of returns
  11. The revenue and costs of shipping and handling
  12. The market rate of interest.

 

With these twelve factors, you can compile the catalog customer lifetime value. LTV is calculated on an Excel spreadsheet. It is not difficult to do if you have the data. Here is what a typical cataloger lifetime value table looks like:

 

This is a simplified table because it leaves out the returns, the shipping and handling revenue and costs, and the referrals. But it gives a good picture of how we went about the exercise in the catalogs that we studied. 

 

The Retention Rate

 

As you can see from the top line, only about one third of the customers acquired in Year 1 come back to shop in Year 2. This figure was approximately the same in all the different segments that we studied.  In Year 2 and subsequent years, the retention rate becomes much higher. Many of the disloyal customers disappear after the first year. Sixty percent of those who do return in Year 2 are still buying in Year 3. Not only are they still buying, their average order size goes up, and the number of orders per year rises.  Finally, the profit per customer goes up. You can see loyalty developing right before your eyes!

 

It took 800,000 catalogs to acquire the 200,000 Year 1 customers. Thereafter, to maintain sales the cataloger had to mail about 8 catalogs per person per year.  The lifetime computation includes the discount rate. This is a simple calculation that is needed to compute the Net Present Value of profits that you are going to receive in the future. The formula is D = (1+ i*2)n  where i = the market rate of interest, and n = the number of years you have to wait.  If the market rate of interest is 6% then the discount rate in year 3 (2 years to wait) is 1.25.

 

On the last line the lifetime value is calculated by dividing the cumulative net present value of the profits in each year by the original number of Year 1 customers (200,000).

 

What the number tells you

By itself, the figure $95.36 -- the LTV in Year 3 -- does not tell you very much. What makes this number useful is to compare it to the same number derived from customers in various segments. This is where the real payoff comes in. In our work with catalogs we go ahead and calculate many other numbers. In this article, I am not going to spill the beans by providing the actual numerical results. The table above, for example, is not the LTV from any one DoubleClick cataloger, but sample numbers that are actually quite realistic (in terms of the retention rate, number of orders, catalogs sent, etc.) What I can do, however, is to show you how the LTV is used to make some very powerful marketing decisions.

The type of things that LTV can be used to measure include:

·              Peak season buyers versus buyers in the rest of the year

·              Sale item buyers versus regular price items buyers.

·              Web buyers, phone buyers, retail buyers, and multi-channel buyers.

·              Buyers referred by another customer

What kind of marketing decisions come out of LTV projects?

These are typical but not universal results. In our research, some catalogs performed quite differently. In one catalog, for example, there was no difference in the LTV of peak season and off peak season buyers. In others, web buyers do not necessarily have a higher LTV. Web LTV results usually depend on the sophistication of the web site.  Cross sales with live operators can beat a web site without automatic cross sale recommendations. Tracking referred customers requires a database system that keeps track of their source.

 

Sears Canada Catalog Results

There have been amazing results from such LTV exercises in the past. When Sears Canada for the first time built a database that combined both retail and catalog customers they learned that the average catalog customer spent $492 dollars per year. The average retail customer spent $1,102 dollars per year. What surprised them was that cross shoppers who used both channels were spending $1,883 per year with Sears. The finding led to a reorganization of the corporate management and the store layouts in 130 stores. They put the catalog desk in the most traveled entrance to each store, and provided catalog phones on the wall of every department with laminated catalog pages to help retail customers find what they wanted in the catalog if they could not find the item in the retail store. This shift alone led to increased sales of more than $250 million in the first year.

How you can use LTV plus a database

With a marketing database plus LTV analysis, catalogers have the tools in their hands to learn a great deal more about their customers than they do now, and to make profitable strategic decisions.  Look at sale items, for example.  Without a database, a cataloger looks at the sale items in the catalog and says, "Yes, we sold a lot of those, but the sale cut in to our margin. Was it worth it?"  With a database, the cataloger says, "These 20% of customers are providing us with 80% of our revenue. What are they buying? Do they buy sale items? Do they use the web? How can we reorganize our catalog and web offerings to appeal to and retain them? "

Catalogers are rapidly realizing the value of having a customer marketing database, and using it to launch profitable research and operational programs such as lifetime value analysis.

 

Arthur Middleton Hughes is Vice President of The Database Marketing Institute. Ltd. (Arthur.hughes@dbmarketing.com) which provides strategic advice on relationship marketing. Arthur is also Senior Strategist at e-Dialog.com (ahughes@e-Dialog.com) which provides precision e-mail marketing services for major corporations worldwide. Arthur is the author of Strategic Database Marketing 3rd ed. (McGraw Hill 2006). You may reach Arthur at (954) 767-4558 .

The articles on this web site are available to the general public to read, enjoy and for limited business use. If you want to reprint more than one or two of them for resale or use in a business or educational environment, send an email to Arthur Hughes at arthur.hughes@dbmarketing.com. He will give you permission by return email. The cost, depending on the number of copies you want to reprint, is very inexpensive.