Work in a fixed order or you will redo steps. Deduplicate first, because any formatting or enrichment done to a record you later merge away is wasted. Then standardize only the fields you actually filter by. Then fill gaps that change a decision and deliberately leave the rest blank. Then archive dead records rather than deleting them, so the history survives. Finally set the weekly routine, because a cleanup without one simply resets the clock. In HubSpot, merges cannot be undone, so review each one rather than bulk-accepting the suggestions — a wrong merge permanently takes two customer histories with it.
What this actually feels like
Someone opens the CRM intending to tidy it and finds four thousand records, an unknown number of duplicates, and deals from two years ago sitting in "proposal sent".
The natural response is to close it again. The second natural response is to start fixing things in whatever order they appear, which produces a lot of work and very little improvement.
What it costs to do by hand
A first cleanup on a small neglected CRM is four to eight hours. On ten thousand records that have never been touched, it is two to five days.
The cost scales with neglect rather than size, which is the argument for the fifteen minutes a week that would have prevented it.
Cleaning and maintaining CRM data
The full cleanup order with the reasoning behind it, how to choose which record survives a merge, and what to measure afterwards.
Read the guide →Input, skill, output
- HubSpot — The full record set.
- Age threshold — What counts as stale.
- Rules — Your standards for each field.
- Scan the CRM — Stale, duplicates and gaps.
- Flag issues — What needs a fix.
- Fix on approval — Only what you OK.
- Duplicate list — Grouped, with a suggested survivor.
- Stale records — Flagged for archive or revival.
- Applied fixes — Only the changes you approved.
Who this is for
- Your CRM has not been maintained systematically.
- You are about to run a campaign and do not trust the list.
- Reporting from the CRM produces numbers nobody believes.
If none of those describe you, this is probably not your first priority — and the rest of the library may point somewhere more useful.
Common questions
Where do I start?
Deduplicate first. Everything you do to a record you later merge away is wasted work, so this has to come before formatting or enrichment.
Should I delete duplicates?
Merge, do not delete, so activity and associations survive. In HubSpot merges are permanent, so review each rather than bulk-accepting.
Which record should survive?
Usually the one with the most activity history. A stale email address is a five-second fix; three years of context cannot be reconstructed.
Should I fill in every empty field?
No. Fill only what changes a decision. A guessed value is worse than a blank one, because it is indistinguishable from a fact.
How do I stop it happening again?
Fifteen minutes weekly — review new duplicates, log activity, update stages, flag what went quiet. Without that you are booking the same cleanup for next year.
See it on your own books, once
The First Close is one real month of your books, closed properly and configured to your chart of accounts, delivered inside two weeks. Full reconciliation against every processor, every exception flagged with the transaction behind it, and the narrative written. $497, refundable if the packet is not delivered, and it credits in full toward the first month if you continue.
Get Your First Close — $497 See a sample packet