In today’s data-driven marketing, data is not only the most important asset that your company can have but can also make or break your campaign. Having clean data impacts not only marketing activities but also impacts your reputation, operations and decision-making. De-duping is one of the most important aspects of overall data hygiene. Duplicates can be found on many levels of data; they arise at the household level, individual e-mail level or company level. But before you can de-dupe your data, you must make sure you have a clear definition of what a duplicate is. Some businesses de-dupe based on a household address for direct mail campaigns, others on an e-mail basis for e-mail marketing campaigns, and some de-dupe based on the company level. If you are still not convinced that you need to de-dupe, consider the following benefits:

Avoiding Different Offers to the Same Customer

Having direct mail going out to the same household can be costly, and it can also be extremely embarrassing. For example, you send two different direct mail creatives to the same household. As one of the records was a customer, you decided to provide a returning customer 15% off, while the other record was marked as a prospect and only got 10% off. Now the person opening both direct mails will be confused by having two different discounts, and the company also can face a PR nightmare.

Cutting Unnecessary Cost

It goes without saying that having duplicates increases your cost. For example, assume you are doing a direct mail creative which costs you $5 per mailing. Your list contains 10,000 recipients. The total cost of mailings therefore is $50,000. If you decided to de-dupe, you would find out that 10% of your mailing list was duplicated. Therefore, $5,000 was a waste of resources. It would have been much cheaper to de-dupe prior to deploying your campaign.

Good Analytics for Decision-making 

Analytics is important not just from a perspective of understanding how your marketing and sales is performing but also from a decision-making perspective. By having duplicates in your CRM, you are going to be double-counting your list capabilities, miscalculating your true growth rates, and getting the wrong rate of responses. If you are looking to make a decision on future campaigns, basing it on duplicate data will give you the wrong list count, wrong budget and possibly the wrong creative picked (especially if you are basing it on an A/B testing done previously).

Reducing Customer Service Confusions

If there are duplicates in your CRM system, having clients call in, e-mail or come into the store will make it difficult for staff to track down the right individual. For example, Mary Smith is found twice in your CRM with the same phone number. She calls in to your customer support to inquire about her order status. Your customer service rep decides to pull up the customer account by phone number and finds two records. Now she has to put the customer on hold while she checks both accounts to try to locate the last purchase before she can even assist the customer. Not only is it wasting everyone’s time and making customer service inefficient, it also makes the customer have a bad customer service experience.

Preventing Potential Loss of Sales

Finally, the biggest impact that duplicates have on your business is a potential loss of sale. If you have duplicates, you do not have a true view of all prospect or customer activities. Therefore, you could be excluding prospects from a sales call because your lead scoring system indicated that they are not ready. However, if the data from both records was combined, you would have all signals indicating they are ready to be passed on to sales. With duplicates, by the time you figure it out, a customer may have already lost interest and gone with your competitor.

You can easily de-dupe your list by using a de-duping tool that will require less effort to identify duplicates and establish a master record than is required to deal with the consequences of duplicate data. De-duping should be part of your data-cleaning initiative, either prior to any major campaign or on a yearly basis.

If you are interested in data clean-up and use of a de-duping tool, contact guest author Anna Kayfitz, CEO of StrategicDB Corp.