Category Archives: Analytical Culture

How Long is a Customer LifeTime?

Jim answers questions from fellow Drillers
(More questions with answers here, Work Overview here, Index of concepts here)

Topic Overview

Hi again folks, Jim Novo here.

There’s always two questions about the topic of Lifetime Value – how do you quanitify value, and how long is / how do you measure / decide what a Lifetime is? For now we’ll leave the value question unanswered, because a lot of that depends on company culture and what question you are trying to answer. Plus, it depends on how you measuree a Lifetime.

So let’s do the Lifetime thing first, shall we? To the Drillin’…


Q:  First of all thanks for an excellent web site – I often visit it to learn and / or get inspiration in my work.

A:  Thanks for the kind words!

Q:  Anyway, I work in a telco retention department and I’m trying to calculate a true and fair value for customer life time answering the question : “How long do we on average have a customer?”.

A:  A both noble and useful pursuit!

Q:  I have data on when customers signed up and when they left (or of course whether they are still here). My first problem is whether to include both lost and existing customers in the calculation.  If you only include the customers you lost you are only able to answer the question for those.  If you include existing customers you don’t know what life time to use for them.

A:  Well, yes, that’s correct.  But you’re really trying to accomplish several things at the same time, so you can break the analysis into different parts and then apply some business logic to get your answers. 

Continue reading How Long is a Customer LifeTime?

When Acquisition Spoils Retention

Jim answers questions from fellow Drillers
(More questions with answers here, Work Overview here, Index of concepts here)

Topic Overview

Hi again folks, Jim Novo here.

OK, here’s a bit of a tough one – what if while investigating customer retention problems you find out that customer defection is highly correlated to specific salespeople or marketing programs? What if I told you this correlation is pretty common – but unrecognized, because hardly anybody goes looking for it? And if found, find trouble doing something about it?

Two issues – you can try to predict / save a customer in the process of defecting, and / or you can hunt down / fix the source of the defection – why is it happening in the first place?

Welcome to the politics of customer retention – and make sure to put your Drillin’ shoes on …


Please note: XXX is a major cell phone provider…

Q:  I’m an XXX customer – I saw an ad for a new phone I wanted for $230.  I went in to the XXX store and asked for the phone – the clerk rang it up at $580!! I showed him the ad.  He said that price is for new customers and he could not give it to me at that price.  So it made me feel that XXX did not value my business.  I then cancelled with XXX service and have told about 10 people about this situation.

A:  Right, this is a pretty common problem with companies that don’t understand
customer retention.  They’re so focused on acquisition that they cause defection and that’s where a lot of the churn in that particular business comes from.  I’d chalk it up to totally clueless marketing management.  

The irony of this situation:  XXX used to be one of the “gold standard” 1-to-1 marketers in the good ‘ol days.

In the first place, companies should not “broadcast” these kinds of offers, because you understand the impact, the leverage, the “costs 5x as much to acquire a customer as retain one” and so forth. If you want to make offers like that, you try to use discrete channels – direct mail and so on, as opposed to newspapers or radio / TV. The strategic issue is people are defecting at such a high rate the company thinks they need to really drive acquisition to make up for it instead of concentrating on retention, which would be less costly and more profitable overall. But even worse, these aggressive acquisition programs are actually increasing the likelihood of customer defection!

Continue reading When Acquisition Spoils Retention

Customer Marketing for a Carpet Store

Jim answers questions from fellow Drillers
(More questions with answers here, Work Overview here, Index of concepts here)

Topic Overview

Hi again folks, Jim Novo here.

OK Jim, so what if the small business is “old school”, you know, not a lot of computer stuff other than billing / scheduling and so forth, and knowledge of spreadsheets is limited. Can the business till take advantage of the ideas you are putting forth without a lot of Excel going on?

You betcha fellow Driller – as long as you don’t mind a little paper and pencil madness …


Q:  Like most of your readers and visitors, I am absolutely bowled over at the prospect of what can be achieved by studying customer behaviour on a simple database/spreadsheet and using the resultant insight to drive unique High ROI customer marketing programmes to increase profits and reduce marketing costs.

A:  That’s a mouthful!  Welcome to the club.

Q:  I have to say that prior to meeting you, on your website and in your book, I had been intrigued by Arthur M. Hughes’ Strategic Database Marketing, but regretfully had reached the conclusion that its inspirational techniques were just not capable of being actioned by me, an Access/Excel illiterate and not so good on the figures either.

A:  Arthur Hughes is a hero of mine though I have never met him.  Some very nice folks have told me my material reminds them of Hughes, sort of a “next generation” Hughes.  That’s very good company for me to be in…

Q:  But your Drilling Down methods and the possibility of your consultancy help, has revived my enthusiasm to learn all I can about these wonderful techniques and to make use of as many of them as I am able.

Here is my challenge:  Father and son business.  Together about 12 years, but moved to present premises four years ago when they extended their product range and re-launched with new branding- under our stewardship!  They are a typical, small company turning over just under the $1M mark and spend around $30,000 – $40,000 pa on their marketing, mostly direct mail (works for them) and email.  Their product range has consisted of fitted carpets, flooring and Oriental rugs.  They have now doubled the size of their store by taking the first floor too.

Continue reading Customer Marketing for a Carpet Store