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."