Data Quality -The Real Cost of Data Duplication

Data duplication is one of the most important things to consider when planning a direct mail or email campaign. Neglecting this step results in unnecessary marketing costs. What is your company doing about it?

Research from the Data Warehouse Institute estimates that data quality problems cost U.S. businesses over 600 billion dollars a year. This financial loss would have been saved by simply ‘de-duping.’

Data duplication is when a lead or record repeats within the marketing database to which you would potentially send postal mail or email. This may seem like common sense, but often, duplicates are harder to spot than you may realize. For example, if you have a lead or customer named Robert Doe, you may also have a record for Rob Doe, Bob Doe, or R. Doe. While the name is different, these are potentially the same person. Generally, computers don’t recognize these as duplicates.

The same concept applies to mailing addresses. While you may see that 1234 South Main Street, 1234 So Main Street and 1234 S Main St are duplicate addresses, most computers won’t. If these duplicates are neglected, you send the same piece of mail to one person or address three or four times, resulting in a waste of money on print and postage. The same occurs when sending an email broadcast.

Duplication can also happen with consumers at business address. If your business primarily uses B2B marketing, it is not uncommon to have multiple contacts at the same company. These would not be considered duplicates because the intended contacts are different individuals. In this circumstance, you have two choices: send the offer to all contacts or remove duplicates based on specific criteria. Depending on the offer and strategy, it’s possible that sending only one mail piece, to a targeted title or department, would be more cost-effective than mailing to all of the contacts for that company.

At ANS, we have received multiple mailings with the same offer. One piece would have been sufficient. Most recently, we received eight mail pieces, that were identical, but sent to eight individuals within the company. Since our company is relatively small, eight is a large amount. With a tighter strategy and some deduplication, this mailer could have saved sending a few mailers to our firm.

Data duplication costs add up. Suppose you are going to send out a direct mail campaign to 5,000 leads and the cost to print and mail the piece was $0.55 each. If just 1% of your file are duplicates, you are wasting $27.50 every time you mail. If you mail quarterly, that cost starts to add up.

Data Duplication, Duplicate Data, Data Quality

So, what can you do about it?

  • When entering customer data for the first time, use standardized data-entry methods to avoid multiple spellings.
  • Run data through filters on a consistent schedule to identify duplicates. Most data management software applications (Excel, Google Sheets, etc…) have basic features for duplication removal.
  • Acquire prospecting data from a reputable source, so it is clean and free of duplicates.
  • Suppress your house-file from acquired prospecting data. When acquiring data, ensure that you can suppress your house-file from these new leads to avoid multiple mailings to people are already on your file.
  • Use a reputable data management company to identify “hidden” duplicates. An experienced data company uses specialized software with “fuzzy logic” features to identify names (Rob, Robert, Bob, etc..) and addresses that don’t appear to be duplicated but are just that.

If data quality and data duplication are a concern for you, call American Name Services at 1-800-434-1851.  Our data management experts will run a free analysis on your file and outline a strategy to optimize your data for cost-effective marketing.

To learn more about the data services offered at American Name Services, click here.

To learn more about data hygiene check out other posts, here.

Leave a Reply

Your email address will not be published. Required fields are marked *