Open Enrollment | Subscribe to Target Marketing HERE
Connect
Follow us on
Advertisement
 

Lists : Double Vision

The secrets of merging offline and online data

June 2011 By Eric Smith
Get the Flash Player to see this rotator.
 

Perhaps you are processing a merge/purge for an upcoming mailer. At the same time, you have an ongoing email prospecting campaign and telemarketing reactivation program running. Maybe it would be most effective to coordinate all three campaigns to avoid duplication of effort and even possible damage to your business reputation. Ever wonder how people view inconsistent or overlapping messages? I'd expect not very well.

For many marketers, this is a familiar story. Direct mail, email messaging and telemarketing each have a legitimate place in your marketing plans. Sooner or later, you find yourself searching for strategies to merge duplicates between online and offline data sources.

Searching for Duplicates
The first step is recognizing that duplicates must be linked between online and offline data. What does this mean? Finding email lists that also contain postal addresses or phone numbers can provide the common contact data points that allow duplicate identification. While not possible with every list, the trick is selecting data with a high population of email, telephone and postal information.

Apply the same rules to your internal customer and prospecting lists. Don't skimp on your Web forms, surveys, data acquisitions and exchanges, or even on simple key punching, by excluding email address, phone number or postal address fields from them. To complete internal files missing key components, search out a quality data provider who can append the missing information. As much as appending email addresses and phone numbers is a common practice, so is reverse appending the postal address based on the same email address or phone number.

After your lists are selected, running a merge/purge using only basic postal address match logic may not yield adequate results. A similar mistake would be using just an email address or a phone number to identify duplicates.

A better approach is to search for duplicates on any combination of the contact name plus email address, phone number or postal address. This way, any two email address matches with different postal addresses are merged. Another example duplicate match would be to match any records with the same contact name and phone number, but with different email addresses. Using this logic, each of the records in the chart (see the mediaplayer at right) are merged.

Choosing the Best Records
This raises some questions. When data are merged and different email addresses, phone numbers or postal addresses are found for the same person, which data should be retained?

 

Companies Mentioned:

SPONSORED CONTENT

MORE ON LISTS & INSERT MEDIA >>

FROM THE BOOKSTORE

To help determine what marketers can do and should be doing with the exponential growth in mobile device ownership, Daniel Rowles gives practical and hands-on training on how to design, implement and measure an effective digital strategy.  Mobile Marketing How Mobile Technology is Revolutionizing Marketing, Communications and Advertising

To help determine what marketers can do and should be doing with the exponential growth in mobile device ownership, Daniel Rowles gives practical and hands-on training on how to design, implement and measure an effective digital strategy. ...

ORDER NOW

This PDF book explores a range of marketing metrics and seek to help marketers to answer such questions as:  What metrics to use to determine whether your marketing/advertising programs are accountable? And is it a waste of money, hence a danger to the company, if your marketing strategy and executions are not accountable? How to calculate how much you can afford to spend to acquire a customer or make a sale. And how can you calculate the customer’s lifetime value? How to understand the relative economics between customer acquisition, retention and CRM. How to measure the funnel process and which improvements will have the most impact.Your download of this book will also include model templates that you can use to immediately calculate and increase profitability for all your marketing efforts.  Profiting from the Magic of Marketing Metrics

This PDF book explores a range of marketing metrics and seek to help marketers to answer such questions as: What metrics to use to determine whether your marketing/advertising programs are accountable? And is it a waste of money, hence a danger to the company, if your marketing strategy and executions...

ORDER NOW

 

COMMENTS

Click here to leave a comment...
Comment *
Most Recent Comments: