What does data cleansing include?
Data cleansing (also called data cleaning or data hygiene) involves six core activities. Deduplication: identifying and merging duplicate records (typical CRMs have 10-25% duplicates). Standardization: normalizing formats for job titles, phone numbers, addresses, and company names. Validation: confirming emails are deliverable, phone numbers are formatted correctly, and fields contain valid values. Removal: deleting records that are permanently invalid, outdated beyond recovery, or junk entries. Correction: fixing typos, updating outdated information, and resolving inconsistencies. Archival: moving inactive records out of active workflows to improve database performance.