Three Tasks to Perform when Building a Marketing Database

When it is time to build a marketing database, a company’s internal IT group almost always lobbies tenaciously for the assignment. This is because IT professionals deeply associate the word “database” with nuts-and-bolts computer science.

Just as internal IT groups want to build marketing databases, they want to be the ones who manipulate them once they are up and running. As with internal builds, delegating ongoing marketing database manipulation to IT professionals often leads to unfortunate outcomes.

The reason is the same as with database builds: a deep, hands-on understanding of data mining is extremely helpful when navigating the inherent complexities of database manipulation.

The following are just three of the tasks that must be performed:

· Apply dynamic business rules to create the multiple past-point-in-time (“time-0”) views required to develop sophisticated scoring and decision models. An example of the former is specialized models to predict customer behavior resulting from different types of promotional efforts such as outbound telemarketing, and where each analysis file contains time-0 views corresponding to several recent campaigns. An example of the latter is quantification of the over-time effects of page counts on the performance of direct mail catalogs.

· Apply dynamic business rules to multiple time-0 views, in order to generate ongoing reports showing: 1) historical trends in customer segment counts and performance, and 2) channel performance (such as direct mail, e-commerce and retail) corresponding to specific lines of merchandise.

· Apply dynamic business rules to perform the production scoring of multiple specialized predictive models, and integrate them with homogeneous classification (“segmentation”) systems, in order to execute selections for multi-channel promotional campaigns.

The bottom line is that ongoing marketing database manipulation requires much more than IT skills. Therefore, regardless of whether the manipulation is done in house or by a third party, make sure that the maintenance team is composed of more than IT professionals!

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.