Category Archives: Analytics Education

ROI of Branding

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.

Speaking of questions, you folks are starting to toss in some real zingers. We’ve moved on from the “How do I calculate Lifetime Value” type of stuff to some real mind benders, and this month’s featured question is a heck of an example. Speaking of questions, I always hide the identities of any organizations or people involved, so don’t be afraid to send them on in. Help yourself, and help others as well!

Branding is a much misunderstood topic and it’s beat to death in the forums and trades. I pretty much run in the other direction when it comes up, because I’m a numbers kind of guy and the branders out there never seem to have any numbers to back up their position. That said, there are ways to numerically quantify the value of branding …


Q. Jim, I send a monthly corporate custom-published magazine (content mix of product and broader lifestyle interests) via email to my house e-mail list – how do I measure ROI on what is a purely brand loyalty vehicle?

A: Thanks for sending in such an easy question – Geesh Louise, doesn’t anybody have easy ones any more? I assume you believe over the longer run, those receiving the magazine will either convert to customers, increase their level of business with you, or bring business to you through referrals.

If you have new business “source tracking” in place (where did the business come from?), it should be fairly easy to determine if the business came from someone who is receiving the magazine, or from someone not on the magazine list. Assuming you are also able to track where the non-magazine business comes from, you can look at expenses versus business generated and find out if the magazine is at least as efficient as other ways of generating business.

Hot links to product offers would be a perfect way to do this, and you can test varying offers by Recency to maximize the profit of different customer segments. Under this scenario, the magazine is not only branding, but selling merchandise. So you don’t have to worry about the “ROI of Branding,” the ROI comes from sales and you can easily quantify the ROI using merchandise profit versus the cost of the magazine.

Continue reading ROI of Branding

Profiling Subscription / Service 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.

This Driller knows his stuff, using advanced database marketing techniques on the customer acquisition side. But in a business where the bill gets paid every month and it’s about the same (electric utility), how do you get to the R and F (Recency and Frequency) to model potential customer defections? Great question, and a pithy answer.

Remember, you can use RF profiling on any behavior not just payment related activity! If you don’t know what we’re talking about with this RF stuff, see explanation here.


Q. Jim, Ordered and read your book AFTER reading EVERY page in your website. Your newsletter is outstanding and you seem to be one of the few with real life experience in database marketing with the skills to simply explain with pragmatic examples of how RFM and LTV should be used.

We are a technology based Call Center company with over 70 clients – we do a lot of the “operational” CRM stuff you refer to – Siebel, Onyx, Kana, Webline, as well as a lot of custom developed SFA solutions and data warehousing solutions we developed – mostly the premise of investing to collect enough information to do the 360 view of the customer across communication medium (email, chat, phone, fax) and reason for calling (campaign, sales, orders, info, customer service).

We have a good mix of B-B as well as B-C. We already do a lot of the demographic modeling for list acquisition (SIC codes, size, number of computers, Geo …). One thing I noticed is that we do a lot of lead generation based upon list acquisitions along with inbound marketing campaigns that seem to address one shot Sales, not recurring sales.

For example, we sell and service de-regulated energy for one client – this is sell once, then service. Since they pay every month for the service, how do you suggest the RFM model be used for service based sales since there is not really an R or an F??? We still have acquisition and retention problems, but we mainly focus on operational efficiency through technology, not strategic use of CRM data. I would really like to be able to add real value based upon the data collected.

I know this is not your forte, but I was just curious if you had any opinions using CRM data in an RFM model when the product is basically recurring service.

A: Thanks for the compliments on the site, book, and newsletter. I hope they will be helpful to you as we try to get a firmer grasp on these subjects this year!

It’s a little tough to provide you a direct answer to such a broad question without more details, but in general, R and F are highly predictive of any action-oriented behavior. In a “billing / service” business like a utility, you sometimes have to hunt a bit harder for the action you want to model as predictive.

For example, at Home Shopping Network, use of the automated ordering process (touch-tone interface to the ordering system circa 1990) was very highly correlated with Future Intent to Purchase. Not exactly a traditional RF action, to be sure, but a falling RF score on use of the interface was very highly predictive of a defecting customer.

Continue reading Profiling Subscription / Service Customers

Subsidy Costs and Halo Effects – Measuring True Marketing Profitability

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.

Got a couple of top shelf questions this issue from the more experienced side of the customer retention biz. As I’ve said before, the Drilling Down method works whatever size your business is. The tools used are different, not the ideas driving their use. For example, a small business may be using MS Excel or Access to keep track of customers, and a large business would be using a CRM app or rules-based engine. Doesn’t matter, works for both. So, hey little guys, don’t let the experts hog the spotlight, send your questions in!

These two questions from Drillers make a nice pair; they are related features of customer buying behavior!


Q:  Jim, I still don’t get Subsidy Costs.  I get the idea of using control groups, but how can a response to a marketing campaign be bad?

A:  Most response is good, of course.  Subsidy costs refer to a hidden cost primarily in best customer programs, where customers have a high probability of making a purchase anyway.  When you promote to these people and offer discounts, you run the risk of spending money and margin you did not have to spend to generate the sale.

Think of it this way.  You have a specific purchase in mind.  The catalog / web site / shopping network mails or e-mails you pretty frequently (you’re a best customer), so you are waiting intently for a communication to arrive before you make the purchase in case there’s a discount available. Communication arrives, and low and behold, has a “20% off” coupon.

You go ahead with the planned purchase and spend 20% less than you intended.  That’s a subsidy cost.  Great for the customer, bad for business. Why care? You can measure these subsidy costs, and create promotions that financially cover the subsidy costs they create.  Or, a better alternative might be to intentionally design the promotion to minimize subsidy costs. For example, make discount good only on orders over a customer’s average purchase size, meaning customer generates more than average margin, hopefully covering the subsidy cost.

Q:  Hi Jim.  Is there any way to tell what the best length of time is to look for Halo Effects?

Continue reading Subsidy Costs and Halo Effects – Measuring True Marketing Profitability