Your Marketing Database Isn’t Complete Without Completeness

Do you want to ensure your marketing database is up to standards of best practices? Then you need to learn the term “completeness,” in a marketing context.

Completeness takes three forms:

  1. Every customer and inquirer “event” is captured, even if its marketing value is not immediately apparent. This includes all orders, items, post-demand transactions and promotion history. Ideally, if available, customer service history is included.
  2. The descriptors (“fields”) that describe every event are maintained at the lowest feasible level. This is important because, although you can always aggregate, you can never disaggregate.
  3. Archiving of older data, which generally should be avoided.

Savvy direct marketers understand that completeness results in full historical views for accurate, efficiently-executed analytics.

For example, by not rolling transaction information off a marketing database after, say, 36 months, all customers with 37-plus month recency in a specific merchandise category will be properly represented in a product affinity or item-specific cluster analysis. Therefore, the conclusions derived from the analysis will be accurate representations of reality.

When you use appropriate storage and access technologies, completeness can actually be less expensive. This is because it eliminates the need for certain data-intensive processes such as archiving (along with the inevitable un-archiving), and outside-the-database workarounds to support customer-side reporting and analytical efforts such as:

  • Matchback processing for response analysis.
  • The creation of “time-0 views” for data mining projects such as predictive models, cohort analysis and over-time comparisons.

Some third-party contracts for marketing database hosting are driven by per-thousand run charges. This results in visible cost penalties for completeness because more records means higher charges. But you have to remember the offsetting, less obvious savings with completeness: the processing work is eliminated.

Jim Wheaton is a co-founder of Daystar Wheaton Group.

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.