Questions
How do I clean up a messy HubSpot contact database?
Diagnose the database before changing it. Identify duplicates, missing fields, unset lifecycle stages and lead sources, stale records, and inconsistent formatting, then decide which findings are real problems in your operating context.
Why people ask this
Contact-data problems are usually invisible until reporting breaks, personalization fails, attribution becomes unreliable, or the portal bill grows.
My answer
Start by seeing exactly what exists. The HubSpot Health Check audits nine common contact-data conditions and provides a downloadable list of affected records without changing the portal.
The findings still require judgment. If Salesforce is the system of record, an unset HubSpot field may be expected. A stale contact may be worth retaining. The tool shows reality; the operating decision remains yours.
Fixing records before diagnosis can remove evidence, create inconsistent rules, or clean symptoms without resolving the process that keeps producing them.
Real example
Nine visible checks create one diagnostic view
The Health Check looks for missing emails, missing names, missing company associations, unset lifecycle stages and lead sources, duplicate emails, inactive contacts, never-contacted older records, and inconsistent phone formatting.
Common mistake
Treating every flag as an error or immediately changing data before deciding what each field is supposed to mean.
The system of record, reporting model, routing rules, and ownership all affect what a correct record looks like.
Try this
Run a read-only audit, review each category against your actual operating rules, and fix the process that creates the highest-impact recurring issue before attempting a complete cleanup.