Category Archives: DataBase Marketing

When Do Former Best Customers Become a Lost Cause?

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.

This time, a Real World question from a practitioner who wants to prove to management they have to spend less to make more money. Spend less to make more? How could that be, and what kind of person would want to go down this road? A real world Driller, of course …


Q: I’m a “long time listener, first time caller,” and a big fan of your site and your approach to data-driven marketing.  I also have two copies of your book – one was not enough.

A: Well, thanks for your kind words. I love the talk radio reference, that is so funny.  Never though about it like that, but makes perfect sense!  Glad to know I’m actually helping people with the book too.

Q: I have a question relating to some work I am doing now with our best customers that other users of your site may have.

I work for a medium sized DTC company selling skincare products (high margin) via space ads, direct mail, and online. Our best customer “Gold Club” has about 8000 members at the moment, although members are being promoted and demoted all the time.  

According to my initial analysis, if a member does not purchase a product for more than 60 days, the chances are that they are defecting. I would like to attempt to bring them back with an offer, and leave those that don’t reply for at least 6 months for a deeply discounted “kickstart” offer (although the logistics of sending out very small mailings are a pain.) 

A: This is a common and logical approach, particularly for “renewable products.”  You don’t say what the product is, but if it is “typical” skincare product, it has a sales cycle very tightly tied to product use.  In this case, Latency usually makes more sense to use than Recency as the primary trigger for a campaign.

Continue reading When Do Former Best Customers Become a Lost Cause?

RF(M) Scoring for Offline Service Businesses

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.

Yea, I know, so much talk about digital … but does this stuff work for offline businesses? It sure does, in fact, these models were originally developed for offline – way before online was even a thing. But because of the ease of data collection, they tend to work even better online! How about for a natural healing center or an accounting practice? Sure thing! Let’s do the Drillin’ …


Q: I stumbled across your Web site some time ago and have been a regular visitor since.  I find your information very useful.  You will be pleased to know that I purchased your book (Drilling Down) and have just finished going through it.  It all sounds so easy!  Your explanations and examples were wonderful and easy to understand. 

A:   Well, thanks for the kind words.  Would you mind if I used the paragraph above as a testimonial on my web site

Q: Now I will attempt to put it all into practice for two businesses – a Natural Healing Centre (massage, natural medicine etc.), and an Accounting practice. 

A: The healing centre is a pretty straight-up situation; should work very well for them just as described in the book.  The accountant, as a service business with a built-in “forced” cycle (the tax year), a little more complex.  More on this below.

Q:   I have 2 questions though, if I can.

A: Sure!  The two questions below are related, so I will answer them as one.  Only one to a customer!  Just kidding…

Q1: Neither business has a Web Site, so a visit to the workplace, usually means a purchase.  I was intending to have R = last visit, and F = visits over past 12 months.  Will this work?

Q2:   Should I put a timeframe on F?  The way I see it, if I don’t, F will continue to grow for each customer as long as they are a customer.  Whereas if I put a timeframe it will give a better picture of behaviour patterns.

Continue reading RF(M) Scoring for Offline Service Businesses

Behavior Profiling for Long Sales Cycle B2B Customers

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.

So Jim, this customer behavior profiling / prediction is great for consumer businesses, but what happens if you’re running a long sales cycle B2B biz where buying decisions take months if not years, and may involve a dozen decision makers? Well fellow Drillers, the answer is not as complicated as you might think – it’s about where to look for the predictive behavior outside of the sale transaction. Interested? Let’s get to the Drillin’ …


Q:  I read your section about how “R” and “F” are better indicators than “M” which I agree. But for the problem I face, do you have any ideas on how I can redefine “F” for my purpose?  If not, I can always use RM, but will face the drawbacks you mentioned in the book which I think are legitimate concerns for predicting potential value. 

(Jim’s note: this Driller is referring to the modified RFM model used in the Drilling Down book.  For an overview of what he is talking about see this description of what is in the book and this outline of RFM.)

A: Just to ground this discussion, I assume you are talking about Company XXX …
(a major enterprise software company with many products. He said Yes)

You should look for R and F in other places, if “short term” prediction is what you are after  (I’ll discuss long term in a minute).  Long cycle businesses like enterprise software can be more difficult to model because the variables you are looking to do an RF scoring on are not as obvious.  The sales activity may not be particularly predictive of customer behavior because the nature of the business precludes frequency of purchase.

For example, think customer service.  Where in your organization would you see RF show up relative to customer satisfaction?  Perhaps at the call center, help desk, or “outstanding issue” logs of the implementation team?  There could certainly be other areas, depending on how customer care is set up.  The question is: how does the Recency and Frequency of customer care predict the likelihood of customer defection?

Continue reading Behavior Profiling for Long Sales Cycle B2B Customers