In an earlier blog I briefly described how data mining and RFM analysis can help marketers be more efficient (read... increased marketing ROI!). Data mining and RFM can significantly help with all direct marketing efforts (multichannel campaign management efforts using direct mail, email and call center) and some interactive marketing efforts as well. So, why aren't all companies using it today? Well, typically it comes down to a lack of data and/or data mining expertise. Even if you don't have data mining expertise, YOU can benefit from data mining by using a consultant. With that in mind, let's tackle the first problem -- collecting and developing the data that is useful for data mining.
The most important data to collect for data mining include:
How much data do you need for data mining? You'll hear many different answers, but I like to have at least 15,000 customer records to have confidence in my results.
Once you have the data, you need to massage it to get it ready to be "baked" by your data mining application.
Some data mining applications will automatically do this for you. It's like a bread machine where you put in all the ingredients -- they automatically get mixed, the bread rises, bakes, and is ready for consumption! Some notable companies that do this include KXEN, SAS, and SPSS. Even if you take the automated approach, it's helpful to understand what kinds of things are done to the data prior to model building.
Preparation includes:
The most important data to collect for data mining include:
- Transaction data - For every sale, you at least need to know the product and the amount and date of the purchase.
- Past campaign response data - For every campaign you've run, you need to identify who responded and who didn't. You may need to use direct and indirect response attribution.
- Geo-demographic data - This is optional, but you may want to append your customer file/database with consumer overlay data from companies like Acxiom.
- Lifestyle data - This is also an optional append of indicators of socio-economic lifestyle that are developed by companies like Claritas.
How much data do you need for data mining? You'll hear many different answers, but I like to have at least 15,000 customer records to have confidence in my results.
Once you have the data, you need to massage it to get it ready to be "baked" by your data mining application.
Some data mining applications will automatically do this for you. It's like a bread machine where you put in all the ingredients -- they automatically get mixed, the bread rises, bakes, and is ready for consumption! Some notable companies that do this include KXEN, SAS, and SPSS. Even if you take the automated approach, it's helpful to understand what kinds of things are done to the data prior to model building.Preparation includes:
- Missing data analysis. What fields have missing values? Should you fill in the missing values? If so, what values do you use? Should the field be used at all?
- Outlier detection. Is “33 children in a household” extreme? Probably — and consequently this value should be adjusted to perhaps the average or maximum number of children in your customer’s households.
- Transformations and standardizations. When various fields have vastly different ranges (e.g., number of children per household and income), it’s often helpful to standardize or normalize your data to get better results. It’s also useful to transform data to get better predictive relationships. For instance, it’s common to transform monetary variables by using their natural logs.
- Binning Data. Binning continuous variables is an approach that can help with noisy data. It is also required by some data mining algorithms.
I'd love to hear your questions or comments if you have a few moments over the Holidays.
My best to you and your family!
Jim
The great news about blogging is that you'll already be interested in what I have to say or else you wouldn't have found me! (Keyword Response Attribution in practice ....)
Powered by Compendium Blogware