Academy › CRM Data Hygiene Certification › Lesson 2 of 3
A cleaning routine
- Standardise formats: one way to write countries, phone numbers (E.164), job titles and company names.
- Merge duplicates: match by email first, then by name plus company. Keep the most recent, complete record.
- Verify emails: remove or flag undeliverable addresses, and flag people who left.
- Fill key gaps: industry, size and location for companies.
- Archive contacts with no activity for a long time, instead of letting them clutter reports.
Decide ownership
Make one person or team responsible for data quality, with simple rules everyone follows when adding records.
Key idea: standardise, merge, verify, enrich and archive, with clear ownership.