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.


Sign up to our newsletters

Company of the Week

PAN Communications is an award-winning integrated marketing and public relations agency for B2B technology and healthcare brands. PAN's data-driven approach allows the firm to specialize in public relations, social media, content and influencer marketing, and data and analytics. PAN partners with brands to create unique, integrated campaigns that captivate audiences.

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

Relive the 2017 Marketing Hall of Femme

Click the image above