Global-Z
  • What We Do
    • Services
    • Countries
  • Problems We Solve
    • Trust Your CRM
    • Integrate Data Silos
    • Customer 360
    • Chinese Cross Border Shopping
  • Perspectives
    • Why Does Data Quality Matter?
    • How Big Is My Customer Data Problem?
    • What Are The Best Practices To Integrate Data Silos?
    • What Matters In Information Security?
    • How Do Names Differ Around The World?
    • Resources To Download
    • Blog
  • About
    • About
    • Our Team
    • Careers
    • Resellers
    • Partners & Affiliations
    • Contact Us
  • Search
  • Menu

How Big Is My Customer Data Problem?

Customer data is the fuel that drives the modern revenue growth engine and the key to building stronger customer relationships – except when the data is wrong. Around 6% of annual revenue is lost through poor quality data, according to research by Royal Mail. Using a data quality tool is “the easiest 5% ROI lift you might ever achieve,” according to the Canadian Marketing Association.

However, Global-Z wanted to determine if it is possible to achieve even better results than the 5%-6% lift that an automated data quality tool alone may provide.

We learned the answer when a large multi-national corporation came to Global-Z to examine its customer list of more than 10-million records. The first data quality audit used sophisticated software explicitly designed to handle “dirty data.” Then, a second audit used Global-Z’s Master Data Quality (MDQ) process, which adds the knowledge of human subject matter experts to improve results.

Related topics:

Why Does Data Quality Matter?

Data Quality in China

In a study of more than 10-million customer contact records, 45% contained invalid information.

Phase 1: Initial Data Quality Audit

During the initial data quality audit, Global-Z found significant data issues in the following areas:

  • Erroneous data in the city, state, and/or postal code fields
  • Erroneous data in the address line field
  • Erroneous data in the name fields
  • Extraneous data in many fields

Automated cleansing, matching, and deduplication yielded excellent results. The chart below shows what the system considers to be usable data, where “usable” data is defined as records either verified as valid or are likely to be valid but could not be verified.

Related Topics:

Address Cleansing

Personal Names Around the World


Original Records9,000,000
Identified as Usable4,950,000
Percentage Usable55%

The Global-Z Master Data Quality audit combines the automated software tuned to the specific client situation with analysis by subject matter experts with decades of experience in analyzing international contact attributes.

The experts are assisted by statistical processes that highlight potential issues, such as terms in any language that appeared with unexpected frequency. Among the issues identified by the MDQ process in addition to what was found by software alone are the following:

  • 40%did not have data in the country field, which would have made them invalid. Fortunately, many countries could be derived from validated addresses and phone numbers by the subject matter experts familiar with the local markets.
  • 40%had unusable terms or phrases, including terms such as “Needs New Address.” Many terms were not in English but could be identified as unusable using a statistical analysis that applies in any language.
  • 10%had duplicate information in different fields. For example, the same entry appeared in the ADDRESS 2 and CITY fields.
  • 5%had identical values in the given name field and the surname field. In this case, these fields should not be used in the matching process as there is likely an error in one or the other field.

The result of the MDQ audit determined the following:


FALSE POSITIVES:
Invalid records that Phase 1 identified as usable
400,0004.4%
FALSE NEGATIVES:
Usable records that Phase 1 identified as invalid
150,0001.6%
Records Changed550,0006.1%
New Usable4,700,000

Over 6% of the records were repaired by Global-Z after the automated cleansing process.

For this customer, the critical issues were to better model their customer needs and to improve their quality brand image. Without Global-Z Master Data Quality, 550,000 of their 9-million customers would not have received the quality interaction this company demands, or they would have had no interaction at all.

For other companies, the quality improvement over the automated process can be broken down into both cost savings (from data not used because it was found to be invalid) and additional revenue from found customers (invalid customer data that became usable).

The larger impact is lifetime revenue value from the 150,000 recovered customers that the software-only solution marked as invalid. If just 20% of these customers spend an average of $200 per year, the lost revenue due to these false negatives would be nearly $6-million in the first year with additional revenue in future years.

To learn more about this analysis, the Global-Z Master Data Quality process, or how it could be applied in your situation, please click on the Contact Global-Z button below.

Related topics:

How Do I De-Duplicate Customer Records?

Best Practices for Address Hygiene, Data Parsing

Integrating Data from Multiple Sources

Learn More About

Link to: Trust Your CRM

Trust Your CRM

Be confident that your customer’s information is entered correctly and validated, so that you can trust what is in your CRM or CDP.

Learn More
Link to: Data Silos

Integrate Data Silos

Integrate online and brick-and-mortar, multiple geographies, and your lines of business with a common system of reference.

Learn More
Link to: Customer 360

Implement Customer 360

Identify, aggregate and link customer data across all of on-line and in-store data with accessible Single Customer Views.

Learn More
Link to: Chinese Cross Border Shopping

Delight Across Borders

Create customer experiences that recognize and delight your cross-border luxury shoppers at every touchpoint and in every location.

Learn More

Let’s Start A Project Together.

Contact Global-Z
GLOBAL-Z INTERNATIONAL
395 Shields Drive
Bennington, VT 05201  USA

Phone: +1.802.445.1011
Fax: +1.802.445.1016

info [at] globalz [dot] com

Cookie Settings, Cookie Policy, Privacy Policy, Trademarks, and Terms of Use

Scroll to top