Category Archives: Marketing thru Operations

Discovering Customer LifeCycles

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’re asked for a simple definition of retention. Problem is, the data / biz model really creates the definition. Meaning, you gotta match the creation of metrics with the actual actions.  So I call for segmentation first so we can put some “actionable” stuff in the mix.

Make sense? Let’s do the “simple” (easy? maybe not) Drillin’ …


Q:  For an online retailer, what is the best way to gauge retention in its most basic and simplest form?  % of orders that are from repeat buyers?  % of orders in month 2 who are repeaters that first bought in month 1?

A: I would take direction on this from the actual results of campaigns.  Basically, at the point a customer no longer responds, they have defected.  Perhaps this averages 3 months or 6 months after 1st purchase, and there will be category or price segments within these “time” segments.  Retention is really measured by the defection.

Now, that’s not to say that % orders from repeats or the other one you mentioned are not valid, but I suggest you think about the specific  question you want answered by the metric you choose.  % orders from repeats, for example, is a common metric in mail order but is often biased by campaigns, e.g. if you ratchet up customer acquisition during a single month you poison your own metrics.

Continue reading Discovering Customer LifeCycles

Modeling Customer Behavior with Small Databases

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.

We’re about to take a trip into the world of small scale databases. In particular, how does a not-for-profit with a small database of donors go about using predictive models? Answer: Keep it simple. Try to avoid using a lot of variables; look for the most powerful and stick with those until you are able to uncover additonal info and grow the database. Ready?


Q: I am new in the NFP (Jim’s note – Not For Profit) sector and would like some advice re:  segmentation models to optimize campaign results – both response and value (Short Term  and Long Term).  Do you know or is there any knowledgebase of how the various techniques – behavioural, RFM, demographic, geographic – generally rate against each other?

A: Not other than my web site / book, which generally covers all the simple models. There is plenty of info around on the web though.

Assuming the end Objective is a donation, the behavioral stuff is going to be much more productive than the geo / demographics are. It’s like a pyramid.  My friend Avinash “stole” (with my permission) a slide from my presentation on this topic and put it on the web, you can see it here.  You’re looking for an “action” (donation), so actions (behavior) will be the most useful segmentation, at least as a primary cut.  Then you can get into geo /  demo stuff if it improves the model.

Q: As my database is small I don’t have the luxury of testing multiple techniques and causal factors.  I will probably run tests in series but would like a general idea of which ones to test first to cut down the time.

A:  Not sure what you mean by “small”, but in general, the more complex a behavioral segmentation approach is the larger the database it needs to be useful.  So for example, with classic RFM (125 segment scores), the bare minimum for it to make any sense is probably 5000 records, and you should really have at least 10,000.

Continue reading Modeling Customer Behavior with Small Databases

Problems Calculating Retention Rate

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.

What is your customer retention rate? Well, that kinda depends on how you define the customer. Have you had an internal discussion, and more importantly, solidified agreement across divisions / functions on the definition of an (active?) customer? Please do.

For example, is someone who hasn’t interacted with your company in any way for over 5 years still a customer? You see, if you don’t specifically define a customer, then you can’t have discussions around topics like reactivation, retention, Lifetime Value (LTV) and so forth. Where to start? With segmentation. Create segments of similar customers, then try to decide which segments are still customers; this exercise will get you going down the right track. The Drillin’?


Q:  Seasonality has great effects on customers’ purchasing activities in the retailing industry, as you may easily understand.

A:  Yes…

Q:  Furthermore, what you call Latency has also great effects on their purchasing activities, (I mean, for example, the customer who purchased a coat in one winter season are not expected to purchase another until the next winter season and so forth.)

A:  Yes, but you are profiling customers, not products, right?  The customer who bought the coat may also buy a dress, shoes, pants in other seasons?  Your approach so far sounds a bit too product centric…

Q:  Here is the problem, how these issues of seasonality and Latency must be taken into consideration for calculating retention rate?

A:  Well, you can take it into account or not, depending on your objectives.  What is the objective of the analysis?  If the objective means you should take these issues into account, then you probably should segment the customer base to do so.

Continue reading Problems Calculating Retention Rate