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 DATABASE, LISTS AND CRM >>

FROM THE BOOKSTORE

A guide to delivering a better user experience through A/B testing: Offers best practices and lessons learned from over 100,000 experiments run by over 2,000 Optimizely customersDetails a roadmap for how to use A/B testing to personalize your customer's web experience and a practical guide to start A/B testing todayAuthors Dan Siroker and Pete Koomen are cofounders of Optimizely.com, an user-friendly testing system that more than 2,000 organizations use A/B Testing: The Most Powerful Way to Turn Clicks Into Customers

A guide to delivering a better user experience through A/B testing:
Offers best practices and lessons learned from over 100,000 experiments run by over 2,000 Optimizely customersDetails a roadmap for how to use A/B testing to personalize your customer's web experience and a practical guide to start A/B testing todayAuthors Dan...

ORDER NOW

One of the only books for fundraisers on monthly giving! Tips on how to make monthly giving work alongside other fundraising effortsHow to acquire monthly donors through different channels such as email, social media, direct mail, television and radioAnd much, much more! Monthly Giving: The Sleeping Giant

One of the only books for fundraisers on monthly giving! Tips on how to make monthly giving work alongside other fundraising effortsHow to acquire monthly donors through different channels such as email, social media, direct mail, television and radioAnd much, much more!...

ORDER NOW

 

COMMENTS

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