Category Archives: Digital Analytics

Second Purchase Marketing

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.

HIgh end hardgoods. One of the most difficult retail categories to deal with from a customer retention perspective, both offline and online. Only vehicles are tougher. In some ways, the category can be easier online, but perhaps not for a single local store due to competition. So what’s the best way to attack the repeat purchase peoblem? Focus on where you have the highest likelihood of success – 2nd purchase Latency. Ready for the Drillin’?


Q:  I loved your book, thanks.  Armed with it, I feel like I can achieve much more than most small retailers in terms of CRM.

A:  Thanks for the kind words!

Q:  I have a question though.  I sell relatively high-priced furniture and design items, and as this is our first year of business, our inventory is pretty small.  As a result, my Frequency totals range from 1 to 4.  That’s it, after a year of business.  About 75% of our customers have bought once and it “ramps up” to 4 from there.  I use “ramp” in the broadest sense of the word.

A:  Yep.  That’s the hardgoods business, especially on the web.  Don’t beat yourself up, it’s early in your game with lines like these, and don’t blame it too much on inventory either.  In the long run, it’s better to sell the *right* stuff than everything you can find, trust me.

Q:  So when I compute RF quintiles, the totals don’t cleanly fit within quintiles.  In other words, for RF scores of X1 ­ X4, customers have purchased once.  X5 customers have purchased 2, 3, 4, or 5 times.  If I raise the hurdle and only look at customers who have purchased more than once, I still can’t fit them cleanly in five quintiles.

A:  That’s one problem with RFM, it’s a bit robotic and works best with larger (usually meaning older) databases…

Q:  I read your article on durable goods purchases and avoiding the one-time-buyer problem.  I guess I’m looking for advice on how to make the “F number” significant until we’ve been in business long enough to get a broader range of frequency options.

Continue reading Second Purchase Marketing

Segment to Best Determine LifeTime Value (LTV)

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.

LTV has to be actionable.  If  you can’t take action on the information, it’s not relevant anyway.

There you go, the most universally true rule when attempting calculation of LTV.

And the best / easiest way to accomplish this is to identify similar customer behaviors and segment the customers by these behaviors – THEN figure out LTV by segment.

If you can’t actually take action on the information, then why spend countless $$ and hours fussing over all the reasons the number you come up with might be wrong and trying to solve unsolveable data or corporate issues? The best idea to implement when developing / using LTV is consistency – let’s get the team to agree on what LTV is and how to measure it, stick with those ideas for at least several years, test and take action on the results to uncover value, THEN (perhaps) discuss improvements!


Q:  I have just been reading your series on Comparing the Potential Value of Customer Groups. I am having trouble calculating the lifetime value of our customers.

A:  Yes, well, everybody does for some reason!  Often the problem is too much
focus on trying to look at the “average customer” as opposed to segmenting
customers.  By segmenting first, it’s both easier to get to LTV *and* more useful since it’s easier to take action on  a segment than the “average customer”.

Q:  Our company provide accounting software solutions to small to medium sized owner operated  businesses.  Because of what we sell and who we sell to, a lot of our customers are most likely to just buy one or two of our software products and unless they sign up for support (only around 15% do), we may never here from them again.  It is therefore very difficult to determine an average / standard lifetime that customers use our product.

A:  Sure.  First, the 15% segment that does sign up for support sound like good customers to me.  So that’s one segment.  How long do they typically stay signed up?  That’s the average life for this segment.

Then there are probably people who upgrade over time, right?  I can’t imagine an accounting product that people would not upgrade – perhaps not every cycle, but every 2nd or 3rd cycle.  That’s another segment.  Then there are probably some who both follow the upgrade cycle and pay for support.  These are probably the “best customers” and they are a unique segment as well.

And finally, you have the buyer who makes one purchase and you never see again.  These people are also a segment.

Q:  What should I base it on, how long our customers use our products (which would be almost impossible to determine), or how long they spend money with us?  So I measure on average the time between the first and last transaction of customers who have the highest Recency???

Continue reading Segment to Best Determine LifeTime Value (LTV)

Customer Perks Marketing

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’s the best way to handle customized marketing programs, particularly if you are using customer value as the key segmentation approach? Surprise and delight, perhaps slightly influenced by making more money. Sound good? Let’s Drill it … 


Q:  Jim, do you have an opinion on overt versus covert customer benefits?  What I meant by overt vs. covert… have you seen clients do programs where they TOLD their customers they are a valued (Gold, Platinum) customer and provided tangible benefits, vs. others who have just covertly treated these customers specially in some way (i.e. priority routing, better reps, thank you calls, etc.)

A:  Well, a program won’t be very effective if everything is completely covert.  I mean, it’s nice to get great service and that certainly contributes to customer retention, but recognition is much more powerful.  The customer needs to know they are being treated specially at some level to maximize program effectiveness. Why?

Something like call routing is a good example.  If a customer is getting priority call routing and they don’t know it, they may think the service is good.  If you tell them they are going to get it and then they get it, it’s an entitlement they earned.  More powerful, and more effective in keeping the customer.  Let’s say they are thinking of defecting.  If they don’t know they are getting priority routing, they could suspect the service might be as good at the competition.  If they know they are getting priority routing, the question becomes “Does the other guy do this to?  And if so, will he give it to me?”  See what I mean?  It’s much more powerful for the customer to know they are getting special treatment than not to know.

Continue reading Customer Perks Marketing