Data Quality

The data quality page speaks to the quality of the data in the CDP (after it has been through the matching and cleansing process). This page can help determine if there needs to be stricter rules for the data processing, or data that should be ignored.

Overall Database Quality Score

This chart shows the quality scores of the Name, Address, Email and Phone data in the CDP, and the overall data quality. Each person in the CDP is assigned a quality score for each type of contact data. The criteria for each score is shown below

  • Name Quality Score
    • Name Quality = 0
      • This person does not have a first name or a last name on file
    • Name Quality = 50
      • This person only has a first OR a last name (not both)
    • Name Quality = 100
      • This person has both a first and last name on file
  • Address Quality Score
    • Address Quality = 0
      • This person does not have a postal address on file
    • Address Quality = 50
      • This person does not have a full postal address on file, but there is a postal code on file
    • Address Quality = 100
      • This person has a full postal address on file which has been verified with USPS or Canada Post.
  • Email Quality Score
    • Email Quality = 0
      • This person does not have an email address on file
    • Email Quality = 25
      • This person gave an email address that was invalid (did not have an @ sign) and the email address bounced
    • Email Quality = 50
      • This person gave an email address that was invalid (did not have an @ sign) but the email address has not yet bounced
    • Email Quality = 75
      • This person gave an email address that was valid but the email address has since bounced
    • Email Quality = 100
      • This person has a valid email address on file that has not bounced.
  • Phone Quality Score
    • Phone Quality = 0
      • This person does not have a phone number on file
    • Phone Quality = 50
      • This person has an invalid phone number (phone number is shorter than 10 digits or longer than 11)
    • Phone Quality = 100
      • This person has a valid phone number (phone number is between 10 and 11 digits)
  • Overall Quality Score
    • This is an average across all contact data scores.

Data Quality Score by First Source

This chart displays the overall quality score by the first source. Since the first time someone interacts with the CDP is when you are most likely to get the highest quality information, this can tell you where there may be deficits in the data collection process.

Data Quality Data Table

This table allows you to see how many people fall in to different categories of data quality, and export sample records of the people with that data quality. This can help determine which people need more information collected about them to fully round out their customer profile.

Top 50 Customers

This data table shows the top 50 customers by lifetime spend, average order value and frequency of purchases. It is often true that the top few records are actually employees or test records that need to be ignored. This table can help determine whether there needs to be more rules applied when importing records, and even identify if there is suspicious activity by certain customers.

Top Shared Contact Data

Top Shared Email Addresses

This table shows the top 25 email addresses by people associated with them. This can help identify if there are test or default email addresses being used that should be excluded from the CDP.

Top Shared Phone Numbers

This table shows the top 25 phone numbers by people associated with them. This can help identify if there are test or default phone numbers being used that should be excluded from the CDP.

Top Shared Postal Addresses

This table shows the top 25 postal addresses by people associated with them. This can help identify if there are test or default postal addresses being used that should be excluded from the CDP.