Data Appending: Dive Deeper

Share this content:

The need to append a prospect or customer data file with third-party data is a necessity for most intelligence-driven marketers.  Missing data, stale or inactive files, data kept in silos within enterprises, inaccurate data entry– all of these “sins” can creep into the database and wear down the success of prospect and customer engagement initiatives.  Depending on the application, such data mishaps can even undermine a brand.

One of the most often asked questions in the client-data vendor dialogue is:  “what is a typical match rate on a given data append effort?”   However, answering this question is like answering the age-old question about “average” response rates.  We all know there are too many variables in price, product, promotion and offer to give an answer that is anything more than educated guesswork. 

When appending data to a customer file – whether email, mobile, telephone, demographic, behavioral or, in business-to-business, firmographic --match rates run the gamut.  No matter how established and sophisticated a data-driven marketer, these rates can vary significantly because of the marketer's existing data, and because of the vendor's various data sources.

There must be a conversation between client and vendor about data confidence levels.  Match rates are meaningless unless there is corresponding knowledge about data confidence. Confidence is about granularity:  Does the data record match to name only, to name and address, to name and ZIP Code, to multiple “touch points” across media channels?  Second, how timely are the data sources? Are data sources updated within the past day, month or year, or perhaps in real time?

Any data vendor worth its salt will enable testing regimens to determine match rates at various confidence levels.   Some marketing programs can get by with looser matching business rules; others require a strict matching regime.  Either way, a data vendor should be flexible to enable such dedication to testing. They need to prove their data sources work for the client in advance.  Clients, too, shouldn't settle for less, and should always be prepared to test.

Testing applies to digital marketing applications, just as it does for traditional media, and to both consumer and b-to-b markets.  When comparing one vendor's match rates to another, it is vital to know if it is an “apples to apples” comparison.  One match rate may “beat” another, but if the data confidence levels behind matching rules are different, then the metric comparison is pointless.  Testing enables the best outcome for the client.

Finally, there may be data variations on the client side.  Some companies have customers who turnover quickly.  Some update their data in real-time, while others do it on a pre-set schedule.  Some companies have data that enter the enterprise via channel partners.  Some have already pulled aside selected data into a distinct data mart, so only a segment of the database is being analyzed. 

Data appending requires a deep-dive conversation between database manager and vendor, as well as dedication to a periodic testing regimen, to determine if those highly-sought-after data matches are performing up to par.

-30-

Sign up to our newsletters

Company of the Week

Since 1985, Melissa has helped thousands of companies clean, correct and complete contact data to better target and communicate with their customers. We offer a full spectrum of data quality solutions, including global address, phone, email, and name validation, identify verification - available for batch or real-time processes, in the Cloud or on-premise. Our service bureau provides dedupe, email/phone append and geographic/demographic append services for better targeting and insight. For direct mailers, Melissa offers easy-to-use address management/postal software, list hygiene services and 100s of specialty mailing lists - all with competitive pricing and excellent customer service.

Find out more here »

Career Center

Check out hundreds of exciting professional opportunities available on DMN's Career Center.  
Explore careers in digital marketing, sales, eCommerce, marketing communications, IT, data strategies, and much more. And don't forget to update your resume so employers can contact you privately about job opportunities.

>>Click Here