Posts

Make Sure You Have a 2019 Data Hygiene Plan

/in , , , , , , , , , , , , /by

As marketers prepare to launch their 2019 campaigns, they should make sure that a complementary data hygiene plan is in place, and certainly AccuList USA data services stand ready to aid in ensuring the quality, up-to-date, enriched data essential for achieving marketing results.

Why Does Clean Data Matter?

Marketers don’t want to join the 88% of U.S. companies whose bottom lines are hurt by dirty data, based on Experian research. The top areas impacted by poor data practices are marketing (66% of companies) and lead generation (80% of companies), according to DemandGen. Dirty data leads to poor targeting and ROI for marketers, reduced revenue from customer acquisition and retention, wasted company resources and misdirected strategy. To avoid that fate, marketers need a plan to regularly fix any customer and prospect data that is incorrect, inaccurate, incomplete, incorrectly formatted, duplicated, or irrelevant, plus to enrich the database via appending of relevant but missing customer parameters.

Developing a Data Cleansing Strategy

Pete Thompson, founder of DataIsBeauty.com, has put together a useful primer for developing a data hygiene plan. Start with the basics: Decide what data is important for business decisions and estimate the ROI of data quality improvement. Then review existing data processes: types of data captured, where it comes from and how is it captured, the standards for data quality, how errors and issues are detected and resolved, etc. Other questions include the main sources of errors, methods for validating and standardizing data, methods for appending or combining multiple sources, automation used if any, accountability for data quality, and measurement of data ROI.

Key Elements of a Data Hygiene Plan

Without going into detail, the basic steps of the data plan will start with creating uniform data standards, preferably applied at the point of data capture. Then develop a data validation process, applied either when data is captured or, if that is not possible, at regular intervals for data already entered. After data has been standardized and validated, you can append missing fields by cross referencing with multiple data sources. Streamline the process through automation tools and scripts, saving time and money and reducing human errors. However, while it may be tempting to start with automation, Thompson cautions against putting the cart before the horse; success requires having data standards and a proven validation process in place before automating. And then set up a monitoring system of the hygiene process, whether automated or not, via random test samples and back testing, and implement periodic checks.

For regular monitoring, or overall scrubbing without an automated regimen, experts suggest a quarterly hygiene review for databases of 100,000 records or more, and semi-annual cleaning for smaller databases. Based on our own years in the data business, we think the best advice from Thompson and other experts is to enlist the services of data processing pros when hygiene is due!

Check out more details from Thompson’s data hygiene plan.




Why You Should De-dupe Your Data

/in , , , , , , , , , , , , , , , , /by

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.