liveBook · Manning

Data cleaning

As explained in First-Party Data Activation

The process of detecting and correcting inaccurate, inconsistent, incomplete, or improperly formatted data.

Data cleaning detects and corrects inaccurate, inconsistent, incomplete, or improperly formatted records before they support identity resolution. Reliable inputs improve matching, while poor hygiene produces “garbage in, garbage out” outcomes. section 6.1

Practical data-cleaning priorities include:

  • Review key identity fields and use deterministic cascade matching for company records, including company name, headquarters, key employees, and third-party identifiers. section 6.1.2
  • Control data quality at entry, especially when sales teams enter company information into CRM systems. section 6.1.2
  • Have sales operations review accounts and merge duplicate company records so related knowledge remains together. section 6.1.2
  • Balance further cleaning against diminishing returns and the goals of the business or campaign. section 6.1

Why accuracy matters

Merging two records for the same person is a true positive; merging different people is a false positive that can expose personal information, damage customer experience, and create regulatory risk. At a company, duplicate CRM accounts can fragment activity and undermine lead scoring. section 6.1 section 6.1.2

Figure 6.2 Identify resolution confusion matrix
A diagram of a match

AI-generated content may be incorrect.

Use the confusion matrix to distinguish correct matches, missed matches, and incorrect matches when evaluating cleaning and identity-resolution quality. section 6.1

How First-Party Data Activation covers it

How deep it goes
Explains hygiene, match errors, field selection, manual review, and scope decisions without detailing cleaning algorithms.
Examples
Uses false-positive and false-negative matches, company fields, duplicate CRM accounts, and merged company records.
What it assumes
Assumes identity-resolution goals and data sources, while emphasizing reliable inputs and entry-time quality controls.
What you can do after
Apply data hygiene to improve matching accuracy, consolidate duplicate accounts, and reduce privacy and customer-experience risks.
How it connects
Connects data cleaning with identity resolution, data governance, deterministic matching, CRM management, and lead scoring.

Also explained in

Compare how 14 books explain data cleaning →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of First-Party Data Activation. The section links point to the parts of the book it draws on.