Take the next steps toward a successful analytics plan

Share this content:
Jeff Williams
Jeff Williams

Chances are your organization has already made a significant investment in the IT infrastructure needed to support a mar­keting database. To maximize the return on your investment and truly unlock the power of database marketing, the next step is to implement a database analytics program that will return measur­able and actionable results.

The following are some suggestions so you can begin to realize the promises that justified your investment.

Ensure that the different tables in your database are each dedi­cated towards a specific function. This keeps your database to a manageable size and ensures that data collection and refresh is a smooth process that does not significantly impact performance or integrity.

Accurate data collection is the most critical step in the analysis process. Analysis is only as good as the data you collect. Clean data ensures that the information about your customers is correct, and that the metrics you compute are not influenced by wrong values.

Minimize holes by setting up data entry screens so users can't skip over fields with­out entering a value. Limit the ability to input free-form data with pre-populated selection menus. Standardize values as much as possible.

Each customer should be uniquely identified by a “primary key” or control number, rather than relying on matching name, address, or other fields to group or count records. Enforce col­lection of campaign or tracking keycodes and control numbers, to ensure that demographic data collected on customers in one set of tables can be accurately joined to transactional or cam­paign data in another set of tables.

Force data collection to be automatic by linking a unique toll-free number or URL to a specific creative and media source.

While the IT department still has a vital role to play in maintaining the database and helping to ensure data integrity, responsibility for database design and analysis is a function of the marketing department.

Good analytics requires an understanding of statistics, com­puter science, and marketing. An MBA without a quantitative background or a statistician who doesn't understand the market­ing challenges will not be able to create an effective analytics program. Make sure each discipline is represented on your team.

Strive to create a culture that respects and demands good ana­lytics. The best creative or media strategy is useless unless it can be measured and improved upon.

By Jeff Williams is senior marketing analyst at DMW Worldwide LLC. Reach him at jwilliams@dmwdirect.com.


Next Article in Data/Analytics

Sign up to our newsletters

Company of the Week

We recently were named B2B Magazine's Direct Marketing Agency of the Year, and with good reason: We make real, measureable, positive change happen for our clients. A full-service agency founded in 1974, Bader Rutter expertly helps you get the right message to the right audience at the right time through the right channels. As we engage our clients' audiences along their journey, direct marketing (email, direct mail, phone, SMS) and behavioral marketing (SEM, retargeting, contextual) channels deliver information relevant to the needs of each stage. We are experts at implementing and leveraging marketing technologies such as CRM and marketing automation in order to synchronize sales and marketing communications. Our team of architects and activators plan, execute, measure and adjust in real time to ensure the strategy is working as needed and change things if it's not.

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