True Marketing Databases Make Sophisticated Data Mining Possible

Posted on by Chief Marketer Staff

(This topic was first covered in the June 18, 2010 Direct Listline article, “How Marketing Databases Differ from Operational Databases.” http://directmag.com/lists/0622-lists-how/)
By Jim Wheaton
There is a big difference between a marketing database and an operational database. A marketing database supports sophisticated data mining and an operational database does not.

Sophisticated data mining, in turn, is impossible without the ability to recreate multiple past-point-in-time (“time 0”) views. This is because data mining professionals work in the present, on the past, in anticipation of the future. For example, multiple customer and house non-buyer “time 0” views make it possible to:

*Create the analysis and validation files required for statistics-based predictive models.

*Generate the data for all cohort analysis, including lifetime value.

*Monitor changes in customer inventories, such as fluctuations in segment sizes over time.

Multiple “time 0” views also support data mining to understand how lifecycle changes affect consumer purchase behavior. Direct marketers are lucky because, as a natural consequence of running their businesses, they receive all of the detailed order, item and promotion history required to perform lifecycle analysis. Retailers are not so lucky, unless they have a mechanism for identifying customers and tracking their behavior. That is where loyalty programs come into play.

Let’s take a vertical industry – publishing – and work through a hypothetical example. Keep in mind that, although the specifics are peculiar to publishing, the general concepts are universal across vertical industries. We’ll begin with two assumptions:

*A publisher of a magazine that is targeted to people in their 20’s and 30’s wants to understand how changes in lifecycle affect renewal rates.

*The publisher hypothesizes that renewal rates are adversely affected as subscribers begin to raise families.

If the publisher’s hypothesis is true, then we would expect to see a drop in renewal rates as subscribers move from multiple family dwelling units (MFDUs) to single family dwelling units (SFDUs), or from urban to suburban locations. With a properly constructed marketing database, multiple subscriber cohorts can be analyzed over time for such relationships; that is, from when they first signed up for the magazine though all of their subsequent renewal cycles.

People in their 20’s and 30’s are notoriously mobile. For example, from the time I entered the workforce in 1980 to when I purchased my first SFDU home in 1988, I lived in five different apartments in three different cities and states. Without being able to recreate “time 0” information, it would be impossible to track this sort of customer movement.

The inability to track customer movement is the unfortunate outcome of any marketing database designed such that, every time an address change is received, the previous address is over-written. Such a database will never be able to support data mining to understand how lifecycle changes affect customer purchase behavior, no matter how many years of history have been accumulated.

Does your marketing database overwrite address information as notifications of customer relocations are received? Are you even certain that you have a marketing database? Many companies think they have a marketing database when, in fact, what they really have is an operational database.

Jim Wheaton (jim.wheaton@wheatongroup.com) is a principal at Wheaton Group.

More

Get Content Like This Delivered to Your Inbox

Related Posts

Chief Marketer Videos

by admin

Chief Marketer Awards

Fusion Marketing - Gold Velcro Industries - Gold Pringles - Gold Bud Light - Gold Bud Light - Gold Target - Gold Coca-Cola - Gold Coca-Cola - Gold HISTORY - Gold Denny’s - Gold Ford Motor Co. - Gold Cottonelle - Gold Intel Corp. - Gold Intel Corp. - Gold Miller High Life - Gold McDonald’s Corp. - Gold Poland Spring - Gold REI - Gold Game of Thrones - Gold Kingsford Charcoal - Gold Pernod Ricard USA - Gold Breathe Right Nasal Strips - Gold Lincoln Motor Co. - Gold Coca-Cola - Gold Mike’s Hard Lemonade - Gold National Football League - Gold Google Asia Pacific - Gold Piper-Heidsieck - Gold 2014 Show Your Joe Campaign - Gold Nike - Gold Cîroc Ultra Premium Vodka - Gold Kmart - Gold Kmart - Gold Coca-Cola - Gold Cotton Inc. - Gold Nike - Gold Malibu Rum - Gold Hostess Brands LLC - Gold HBO - Gold Prevacid 24HR - Gold Samsung Mobile USA - Gold Cîroc Ultra Premium Vodka - Gold Frito-Lay and PepsiCo - Gold Hewlett Packard Co. - Gold FX Television Network - Gold Captain Morgan - Gold American Express OPEN - Gold HBO - Gold Corona Extra - Gold AT&T - Gold World Vision - Gold Gillette - Gold Pantene - Gold Porsche - Gold Duracell - Gold Corona Extra - Gold Microsoft - Gold Cottonelle - Gold Chicago Shakespeare Theater - Gold HBO - Gold Crown Imports - Gold Samsung Mobile USA - Gold The Clorox Co.
 - Gold Pepsi Co. - Gold Oreck - Gold Jockey International - Gold The Art Institutes - Gold Monster Worldwide, Inc.
 - Gold Pepsi Co.
 - Gold HISTORY - Gold MillerCoors - Gold Time Warner Cable - Gold Frito-Lay - Gold American Express OPEN - Gold AT&T - Gold MillerCoors Foster’s - Gold Microsoft Windows - Gold ConAgra Foods, Inc.
 - Gold Coca-Cola - Gold Nestlé - Gold Ford Motor Co.
 - Gold

Chief Marketer Top Shops

TRCO MARKETING WUNDERMAN VERTICAL MARKETING NETWORK UPSHOT TWO/TEN TRACK MARKETING GROUP TPN TIPTON & MAGLIONE TIC TOC TEAM EPIC TEAM ENTERPRISES TEAM DIGITAL PROMOTIONS THE STRATEGIC AGENCY SWITCH SOURCE MARKETING SOHO EXPERIENTIAL SLANT SCOUT SPORTS & ENTERTAINMENT RYAN PARTNERSHIP RUBIK MARKETING REVOLUTION RE:FUEL AGENCY REDPEG MARKETING RED MOON MARKETING PSE-PACKAGED SPORTS AND ENTERTAINMENT PRO MOTION PRIZELOGIC POWERPACT PGW EXPERIENCE NEXT MARKETING NATURAL SELECTION PROMOTIONS MOMENTUM WORLDWIDE MKTG MIRRORBALL MICHAEL ALAN GROUP MASTERMIND MARKETING MATCH MARKETING GROUP THE MARS AGENCY MARKETVISION MARKETING WERKS THE MARKETING STORE MARKETING RESOURCES MARKETING LAB THE MARKETING ARM MARKETING ACTIVATIONS GROUP MARDEN-KANE LIVE NATION MEDIA & SPONSORSHIP LIKEABLE MEDIA LEGACY MARKETING PARTNERS LEADDOG MARKETING GROUP LAUNCHFIRE LAGARD´ERE UNLIMITED KICKING COW PROMOTIONS JACK MORTON WORLDWIDE INTERACTIONS THE INTEGER GROUP INSPIRA MARKETING IN MARKETING SERVICES IC GROUP HMT ASSOCIATES, INC. HELLOWORLD GROW MARKETING GOOD SOLUTIONS GROUP GOLDNFISH MARKETING GROUP LLC GMR MARKETING GEORGE P. JOHNSON GEOMETRY GLOBAL GENERATION Z MARKETING GAGE MARKETING GROUP FUSE, LLC FORMULA STREET INC. FLUENT FCBX FCB/RED FAME ESCALATE THE ELEVATION GROUP EASTWEST MARKETING GROUP DON JAGODA ASSOCIATES DEPARTMENT ZERO CONCEPT ONE COMMUNICATIONS COLLABORATIVE MARKETING GROUP COLANGELO CATAPULT CARDENAS MARKETING NETWORK BRANDFORCE BRAND CONNECTIONS BLUE CHIP MARKETING WORLDWIDE BFG COMMUNICATIONS BECORE BDA ATTACK! MARKETING A2G ARC ALL TERRAIN ALLIED INTEGRATED MARKETING ALLIED EXPERIENTIAL ALCONE ACTIVENT MARKETING, LLC THE A TEAM