williams graphic solutions

Strategic Marketing Solutions

Basics of Dataset Management - Removing Duplicate Records

March 25th, 2011

The first rule of effective direct mail marketing is to have a clean dataset - a record of names, addresses and other contact information that is accurate. Often, we find datasets that have been compiled from multiple sources and have duplicate entries throughout the file. If the data is in a spreadsheet, like Microsoft Excel, simple sorting is sometimes enough to identify duplicate entries and remove them. But other times, like when the dataset is very large or the duplicates aren't obvious, it requires some advanced filtering techniques to clean up the dataset.

In this video from Tech Republic, Bill Detwiler shows you three advanced techniques for sorting through your spreadsheet data to identify and remove duplicates. If you have questions about how to compile your dataset for direct mail marketing, or if you need help sorting through the data you have, contact us and we'll help you "sort it out."

Posted by Kent Callison | Topic: Marketing
solutions center
© Williams Graphics Solutions. All rights reserved.