Checklist
CRM cleanup
in an afternoon
A messy CRM isn't a software problem. It's a Tuesday afternoon. Here are eight steps, each with a time box, that turn a CRM your team avoids into one they trust, plus a 20-minute monthly routine to keep it that way.
Why it matters
Our rule
If your team doesn't trust the CRM, they stop using it, and leads go back to sticky notes, text threads and memory. That's where they get lost.
Trust breaks in small ways:
The same customer appears three times.
A "hot" lead turns out to be from two years ago.
Nobody knows what the tag "follow up??" means.
Email marketing databases naturally degrade by about 22.5% a year as people change jobs, addresses and email accounts. That figure comes from business-to-business email lists, and local service lists vary, but the point holds: a CRM left alone gets worse every month.
HubSpot · Database Decay Simulation, based on MarketingSherpa researchThe fix isn't a new CRM. It's one focused afternoon and a small monthly habit.
The afternoon, step by step
About 3 hours
Put it in the calendar, close your email, and work through these in order.
Back up everything
Export all contacts, deals and notes before you change anything. If something goes wrong, you can put it back.
Merge duplicates
Match on email address first, then phone number. Keep the record with the most recent activity and merge the history into it.
Standardise your stages
Keep five to seven stages that match how you actually sell, for example: New inquiry, Contacted, Site visit, Quote sent, Won or Lost.
Prune your tags
Keep a short list that someone can explain in one sentence each, and write those definitions down. Merge near-duplicates and delete the rest.
Archive dead leads
Pick a clear rule, such as no reply or activity in 12 months, and archive rather than delete.
Record consent
Make sure every contact shows whether they've agreed to receive texts and marketing emails.
Set owners
Every open lead and deal gets one named person. "Unassigned" is where leads go to be forgotten.
Book the monthly check
A recurring 20-minute slot for the routine below. This keeps the other seven from needing to be done again.
A quick test
If most of your deals sit in one stage for a month or more, either that stage is defined wrong or that's where your process is stuck.
The 20-minute monthly routine
Once a month, the same person:
Merges any new duplicates.
Reviews deals that haven't moved in 30 days.
Tags or archives anything untagged.
Checks every open lead has an owner.
Spot-checks that new leads have their source recorded.
Works in any CRM
These steps apply whether you're on GoHighLevel, HubSpot, Jobber, Pipedrive or a spreadsheet you've outgrown. The names of the menus change. The discipline doesn't.
An example
An established renovation company had customer details in three places: an old CRM, the office manager's spreadsheet, and the owner's phone. When they moved everything into one CRM, the first import produced a mess of duplicates, dozens of overlapping tags and a pipeline nobody recognised.
One afternoon following these steps got them to one record per customer, six stages that matched how they actually sell, a short tag list with written definitions, and an owner on every open lead. The monthly 20 minutes has kept it that way.
A composite based on businesses like the ones we work with; details are illustrative.Want us to do it for you?
Book a free 30-minute strategy call. We'll look at your CRM with you and tell you what a cleanup, and the guardrails to keep it clean, would involve.
Get the one-page checklist
Print it and work through it in one sitting. The eight steps with their time boxes on the front, the monthly routine on the back.
Related resources
Nate designs custom websites and the CRM, automation and reporting behind them as one system, for builders, makers and established teams that have outgrown their setup.
Sources
HubSpot. Database Decay Simulation (based on MarketingSherpa research).
CRM Cleanup Checklist
One page: eight steps on the front, the monthly routine on the back.
Get the checklist