Managing one-to-one campaign databases

Share this content:
Managing one-to-one campaign databases
Managing one-to-one campaign databases

A successful deployment of any one-to-one campaign can be linked directly to proper database management. Direct mail or e-mail messages with misspelled names or irrelevant offers can make communications ineffective and damage an organization's reputation.

A clean database ensures that the messages that reach recipients are accurate and relevant.

It also means fewer errors and returns on print and e-mail messages. When cleaning a database, avoid duplication of effort and do as much as possible at once. If you are cleaning addresses, make sure other data meets standards as well. Develop a plan to keep a clean database from lapsing back into disrepair as data is altered or added. It will make the campaign deployment process faster and easier if the data has been regularly maintained.

Lastly, for ongoing data cleanliness, employ applications that write back to the database.

We feature a built-in rules engine that not only reads databases and applies business rules, but also applies business rules to data being written back into the database. This provides a way to create rules that automatically ensure that new data meets existing standards.

Use tools that are designed for data. Many organizations store data in applications that are not designed to function as databases, such as Microsoft Excel. To avoid potential data pitfalls like zeros dropping off zip codes, use either Access, SQL, Oracle or another database application.

If you are provided with an Excel spreadsheet, convert the file and deal with potential issues during that process.

Another option is to use a variable data publication or cross-media application that allows you to write business rules addressing issues like zip code problems. Many organizations use both techniques in conjunction, so if something slips past the conversion process it can be caught by the business rule.

Limit free-form text fields. There are instances when free-form text fields seem necessary in a database, but this manual process allows for errors or typos during data input, increasing the likelihood of inaccurate information in the final product.

To avoid free-form text fields, assign a numerical value to your common free-form information.

For example, customer reward levels of bronze, silver and gold can be represented by 1, 2 and 3, respectively. Then, in the output business rules engine, a simple business rule could be written. Remember to apply similar business rules to the application that populates the database, as well.

As you can see, data management is a critical task before, during and after every campaign you deploy. However, if you follow these guidelines, your campaigns will be more accurate, relevant and successful. And that ultimately means more business.

Phil Rose is product marketing manager at XMPie. Reach him at

Sign up to our newsletters

Company of the Week

Since 1985, Melissa has helped thousands of companies clean, correct and complete contact data to better target and communicate with their customers. We offer a full spectrum of data quality solutions, including global address, phone, email, and name validation, identify verification - available for batch or real-time processes, in the Cloud or on-premise. Our service bureau provides dedupe, email/phone append and geographic/demographic append services for better targeting and insight. For direct mailers, Melissa offers easy-to-use address management/postal software, list hygiene services and 100s of specialty mailing lists - all with competitive pricing and excellent customer service.

Find out more here »

Career Center

Check out hundreds of exciting professional opportunities available on DMN's Career Center.  
Explore careers in digital marketing, sales, eCommerce, marketing communications, IT, data strategies, and much more. And don't forget to update your resume so employers can contact you privately about job opportunities.

>>Click Here

Relive the 2017 Marketing Hall of Femme

Click the image above