Key Issues to Confront When Constructing a Database

When it is time to build a marketing database, a company’s internal IT group almost always lobbies tenaciously for the assignment. For IT professionals, this only seems natural. After all, the word “database” carries all sorts of connotations of nuts-and-bolts computer science.

So, why are internal marketing database builds so often unsuccessful? The reason is that much of what determines success has nothing to do with database technology. Consider just seven of the scores of issues that must be confronted when constructing a database:

  • Address standardization and correction; parsing and matching technologies; and programming logic must be carefully integrated to match (“group”) accounts, leveraging a combination of factors such as name, address, company name, “hard links” such as phone number, and sold-to/bill-to/ship-to relationships.
  • For B-to-C account records, matches must be determined at the individual and household levels. Also, the matches must be unified into a non-circular cross-reference that assigns each account to a single individual, and each individual to a single household. Likewise for B-to-B account records, the same must be done at the individual, site and super-site (“company”) levels.
  • Incremental periodic matches of new accounts to the existing base must be executed, to add activity to existing individuals, households, sites and super-sites, and create new ones.
  • The entire database must be periodically re-matched whenever the number of address changes reaches critical mass, or key USPS tables have been updated.
  • All programming logic must be maintained such that it can be easily adjusted and enhanced, and data re-consolidated, based on the results of ongoing quality assurance of the matches.
  • Logic must be dynamically imposed to make the historical data consistent and usable, and correspond with “real world” behavior. For example, “split-shipment” order records must be aggregated into “true” orders.
  • Rapid classification of customers as of any point-in-time must be done, at the individual, household, site and super-site levels, employing atomic-level histories up to that point-in-time only. This multiple-level aggregation of data, performed dynamically and at-will, is essential for: 1) accurate response attribution, analysis, scoring, and selection for promotions, and 2) the appropriate allocation of marketing-spend to each customer.

Jim Wheaton is co-founder of Daystar Wheaton Group.

Rethink Operational Systems For Best Database Practices
Data Analysis is No Game For Amateurs | handle your data analytics

Partner Content

Hincapie Sportswear Finds Omnichannel Success in the Cloud - Netsuite
For more and more companies, a cloud-based unified data solution is the way to make this happen. Custom cycling apparel maker Hincapie Sportswear has leveraged this capability to gain greater visibility into revenue streams, turning opportunities into sales more quickly while gaining overall operating efficiency. Download this ecommerce special report from Multichannel Merchant to more.
The Gift of Wow: Preparing your store for the holiday season - Netsuite
Being prepared for the holiday rush used to mean stocking shelves and making sure your associates were ready for the long hours. But the digital revolution has changed everything, most importantly, customer expectations. Retailers with a physical store presence should be asking themselves—what am I doing to wow the customer?
3 Critical Components to Achieving the Perfect Order - NetSuite
Explore the 3 critical components to delivering the perfect order.
Streamlining Unified Commerce Complexity - NetSuite
Explore how consolidating multiple systems through a cloud-based commerce platform provides a seamless experience for both you, and your customer.