Category Archives: Marketing / Tech Interface

Choosing Customer Retention Metrics for the Supplements Business

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.

Today’s question is from a fellow Driller who understands customer retention really well but just can’t decide on the best metrics to measure retention in the supplements business. Should he use Customer Retention Rate? Customer Churn Rate? Hurdle Rate? Ahh, to make the right choice here the gory details will need to be visited – so let’s get to the Drillin’ !


Q: Hi Jim,

I am here choosing all the metrics I will use in the coming days to evaluate the health of my business and learn a little bit more about it. I will begin analyzing some basic metrics and then (just after being completely comfortable with the “basic metrics”) I will do some more sophisticated analyses like LTV and RF Grids. (Jim’s Note: RF Grids are advanced customer LifeCycle tracking tools described in my book).

Now I am trying to decide which is the best metric to measure my site’s ability to retain customers. There are three metrics that come to my mind. Customer Retention Rate, Customer Churn Rate and Hurdle Rate.

Customer Retention Rate would be the easiest to measure but the least precise. I could be doing a great job retaining customers but if I am attracting a lot of new customers this metric could give the wrong impression that we are doing more poorly than the last time we measured.

Customer Churn Rate is very easy to calculate when you have a “subscription model business.” If the customer cancels the contract it means a defection. But in my case there is no contract. We sell products. If the customer does not purchase in 30 days it doesn’t mean necessarily that he defected.

The Hurdle Rate based on Recency (45 days for purchase seems to be a good number for the products we sell- natural supplements, based in Brazil) seems to be the best metric I can choose to measure our ability to retain customers over time.

What metric do you think I should be using to measure our ability to retain customers?

A: I think you are one of the smartest IT guys on the subject of database marketing, that does not do database marketing for a living, I have ever met (?) ! Where did you learn this stuff? Did you read a book or something? ;)

Your analysis is absolutely correct on every point, and the approach is on target. If you start simple and work towards more complexity, you will learn more about your customers. And assuming most of your products are roughly a 30 day supply, 45 days is an excellent cut-off for a Hurdle Rate analysis. Simply track the percentage of customers who have made a purchase in the past 45 days over time, perhaps monthly to start. If the percentage is rising, you are getting better at retaining customers. If it is falling, you should be looking for reasons why this is so.

Continue reading Choosing Customer Retention Metrics for the Supplements Business

Measuring Distributor / Agent Loyalty in 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.

Today we have a fellow Driller looking to compare the “loyalty” of sales / distribution agents for insurance products and use this information to manage business with the agents more effectively. In this case, knowledge of the business is exceedingly important because segmentation of business lines across regions will dramatically improve predictions.

Let’s do some Drillin’!


Q: Hi Jim,

I happened upon your site and found the information there very valuable – so much so that I ordered your book (customer is referring to Drilling Down).

A: Well, thank you very much for that!

Q: I’m a marketing manager with an insurance company that distributes its life, auto, home, and business insurance products through independent insurance agents.  These agents represent our company as well as others.

I’m interested in techniques for measuring agent loyalty – which I think would be demonstrated by the agents choosing to place business with our company instead of another company they represent for policies.

A: I’m not sure in this case anything is too terribly different from the scenarios used in the book. Essentially, agents or consumers demonstrate loyalty though their actions, and if you can track their actions, you can spot increasing or decreasing loyalty.  Your business is more complex in many ways than retail, but to the consumer (in your case agent), there are always choices to be made between alternatives, and changes in the purchase patterns agents or consumers generate often precede customer defection.

Continue reading Measuring Distributor / Agent Loyalty in 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