Category Archives: DataBase Marketing

New RFM: Using RFM to Improve Email Profit

Analytical Culture, DataBase Marketing, Digital Analytics, Driller Q & A, Marketing thru Operations, Measuring Engagement

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.

Traditional RFM execution is focused on giving a snapshot view of customer likelihood to respond / campaign profitability across large and varied customer databases. But is that all it can be used for? Heck no! If you understand the basics of how and why RFM works, and you understand your customer database, there’s a ton of different very valuable customer scoring operations you can accomplish. Interested? Get out the Drillin’ tools …

Q: I recently purchase your book “Drilling Down.” Really enjoying reading it!

A: Well, thanks for the kind words!

Q: I had a question about the implementation of the RFM model against email campaigns. Say we have a client that has done this:

  • Sent out 2 emails to entire database – in June and July
  • Sent out 3 targeted emails to a specific segment of database – in June, July and Aug

From my CTR and Open Rates I know that the targeted segment performance is better. For my scoring I am using the following:

  • Recency, last email responded to, and
  • Frequency, number of emails where an action (a click-thru) was taken

So the question is when trying to apply an Recency / Frequency RF score to the entire database, do you / can you use all 5 email programs? Would Recency include the email to the specific segment in August? Would frequency include the segment that received the email in August?

A:  The fact you are asking this question tells me you understand the methods better than you think you do.  The correct answer is yes, and no, depending on the objective of the scoring. As long as you **understand** that there is the potential for the marketing to the target segment to skew the scoring of the overall group, then you are thinking about the problem correctly.  Whether you decide to do the scoring as “everybody” or you score the targeted segment and then score “everybody else” separately really depends on what you are trying to accomplish / the objective of the effort.

Continue reading New RFM: Using RFM to Improve Email Profit →

New RFM: Using RF or RM Instead of RFM

Analytical Culture, Customer Experience, DataBase Marketing, Driller Q & A, Marketing thru Operations, Measuring Engagement

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.

Sometimes the traditional RFM model does not work very well for a specific business model. For example, small business databases can be too small to fill out all 125 RFM segments properly, resuslting in distortions of predictive capability. Optimizing the traditional RFM approach for unique business model criteria is a very useful skill, and it’s actually not difficult if you understand the levers of the business model. To Drill or not to Drill, that is the question …

Q:  I’ve used your site a lot and found it to be very informative.

A: Thanks for the kind words!

Q:  I have a question about the use of RFM analysis for a low margin, eCommerce business.  I read that for a relatively small customer list (<50k) using just the “RF” of the RFM analysis would be preferred since the “M” tends to hide shifts in behavior.

A:  Well, the M tends to smooth shifts regardless of the size of your list.  In addition, if you have a small list, 125 segments is too many to be really useful, so RF at 25 segments in more intuitive.  The real issue with M or Monetary Value is up and coming, accelerating customers.  If you use total spend (M), it will “punish” them with a lower rank.  But the fact is they have more future potential because Recency is low and Frequency is ramping.  Inversely, M tends to reward customers who have spent a lot in the past with a higher rank, though they may actually be declining or defected customers.  Predicting the future is more profitable than reporting on the past, so given a choice, I would drop “M.”  This is especially true on the web, where communication costs are low and changes in behavior can be very rapid.

Q:  My question to you is, since I’m talking about a low margin business, wouldn’t “M” actually be more valuable than “F” for the analysis?  For example, if 40% of my customers are driving 70% of my sales and 100% of my profits, that says that 60% of my customer base is losing me money.  I don’t want them to be given a higher value rating because they’re placing MORE unprofitable orders than someone placing fewer but profitable orders.  You see what I’m saying???

Continue reading New RFM: Using RF or RM Instead of RFM →

New RFM: Snapshots versus Movies of Behavior

Analytical Culture, Analytics Education, DataBase Marketing, Driller Q & A, Marketing thru Operations, Measuring Engagement

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.

The standard RFM customer model is essentially a “snapshot” of likelihood to purchase (and so perhaps also profitability of campaign) at a given point in time. But what if you took these snapshots and turned them into a movie, looking at likelihood to purchase over time, and what specific inputs affected these changes? Then you’d have a LifeCycle movie / model, which amplifies the power of RFM substantially. Ready to find out more? The Drillin’, the Drillin’ …

Q:  I am in catalog circulation.  We currently use RFM to segment the file and then roll the RFM cells into more manageable segments (this is a new technique to me, I am new to this company, in my former company we mailed by RFM segment).

A:  Hmm…this sounds like a “dumbing down” approach to RFM, but hey, if it works, why not.  Sometimes this is done because the customer base is not really large enough to support 125 segments, and the differences between the segments can become unstable and less predictive unless they are aggregated.

Q:  Because we are in a niche market and we saturate it pretty well, I would like to see which customers are on the edge or falling off (the Latency stuff) and which ones we can “reward” for being the best.  I do not think the RFM analysis shows me that amount of detail.

Continue reading New RFM: Snapshots versus Movies of Behavior →