Our CRM data is a mess. Who can clean it up?

André Rodrigues ·

Three kinds of people can clean up a messy CRM: your own team with the tools built into the CRM, a freelancer or consultant for a one-time cleanup, or a partner who fixes the data and the process that made the mess. Which one you need comes down to one question. Do you want the data clean once, or clean next year too?

We clean up CRMs for B2B sales teams in HubSpot, Pipedrive and Close. The part that decides the outcome is who owns the data after the job is done.

First, find out what kind of mess it is

A messy CRM is usually one of these, or all of them at once:

  • Duplicates. The same company 2 or 3 times, each with its own deals.
  • Blanks. Deals with no amount, contacts with no owner, companies with no industry.
  • Mixed formats. "UK", "U.K." and "United Kingdom" in the same field.
  • Dead records. Contacts that bounced or changed jobs years ago.
  • Old deals. Deals that have sat in "Proposal sent" since last year.

Each one has a different fix. Duplicates need a merge. Blanks need a rule about what is required. Dead records need a delete or an archive. Old deals need a decision from a rep. So count them before you call anyone.

Here is the 30-minute audit we run first, in any CRM:

  1. Count contacts with no owner.
  2. Count companies with no website domain.
  3. Count open deals with no amount or no close date.
  4. Count open deals with no activity in 60 days.
  5. Run the CRM's duplicate tool and note how many pairs it finds.
  6. Count contacts whose last email bounced.

Write the six numbers down. They tell you the size of the job. They are also the numbers you check again when the job is done, so you know it worked.

Fix where the bad data comes in

If you clean the data and change nothing else, it will be a mess again in six months. Bad data gets in a few ways:

  • Forms that ask for too much, so people type junk to get through.
  • Imports from spreadsheets with no duplicate check.
  • Tools that sync into the CRM and overwrite what a rep typed.
  • Reps who skip fields because nothing stops them.
  • Nobody owns the CRM, so nobody says no.

We start with the fields. Make a list of the fields your sales process depends on. Then close the gaps. Make those fields required. Use dropdowns instead of free text. Run the duplicate check before every import. Set enrichment to fill blanks only, so it never overwrites a rep's note. And name one person who owns the CRM.

Keep the list short. On every contact, we require five fields: first name, last name, email, lifecycle stage and owner. Add a field only when it changes who gets the lead, how fast, or what you say to them.

Then clean in stages

Do it in this order. Each step makes the next one easier.

  1. Back up first. Export contacts, companies and deals. In HubSpot, deleted records can be restored for up to 90 days. Merged records cannot be reverted, so the export is your only way back.
  2. Fix formats. Country, phone, stage names, job titles. Same value, same spelling, everywhere. Duplicates are easier to spot after this.
  3. Merge duplicates. HubSpot's duplicates manager covers contacts and companies on Professional or Enterprise. It compares name, email, phone, company name and domain, scores each pair, and shows up to 10,000 pairs. Review a sample of 20 pairs by hand before you merge anything in bulk.
  4. Fill or delete. Fill the blanks that matter with enrichment. Delete or archive what nobody will use again.
  5. Deal with old deals. A rep decides each one. Do not delete them. Mark them lost with a reason, so the reports stay honest. If your reports already disagree with each other, read why your HubSpot sales reports don't match reality.
  6. Count the six numbers again.

What is good enough? These are the targets we set: duplicates under 2% of records, bounced emails under 3%, and required fields filled on more than 95% of records.

Our view

We think the owner should see the whole pipeline in one place without asking anyone. When a CRM fails, the usual cause is that nobody keeps it up.

On our calls, the same story repeats. Spreadsheets broke once 6 people were booking calls. Owners did not log notes after their calls, so the deal record knew less than the owner did.

A cleanup fixes today's records. A named owner, a short list of required fields and a 15-minute weekly check keep them clean. Without that, the cleanup becomes a yearly event, and the year in between is spent not trusting the numbers.

Who can do this for you

Option Best for
Do it yourself One CRM, under a few thousand records, and someone on the team who owns it
A data cleanup tool A big database with many duplicates and format problems, and a person to run the tool
A freelancer or consultant A one-time cleanup with a clear scope and a deadline
An agency A cleanup tied to a migration or a new CRM setup, with many systems involved
Scaling Studio Fixing the data and the process together: required fields, routing, follow-up and reports a sales leader trusts

Three questions to ask anyone before you hire them:

  1. What will the six numbers be when you are done?
  2. What stops the mess from coming back, and who owns that?
  3. Will you merge records in bulk without a review? If the answer is yes, keep looking. Merges cannot be undone.

We have set up sales systems for 50+ B2B businesses in HubSpot and Pipedrive. Many of them tripled revenue in just over a year.

FAQ

Can HubSpot find duplicates on its own?

Yes, on Professional or Enterprise. The duplicates manager checks new records as they are created and runs once a day. It finds the pairs. A person still has to merge them, one by one or in bulk.

How often should we clean CRM data?

Do a full audit once a quarter, and a 15-minute check every week on the six numbers above. Clean more often right after an import or when new people join the team.

Should we clean the CRM or start fresh in a new one?

Clean it, unless you were already going to move. A new CRM with the same forms, imports and habits fills up with the same mess. If you are moving anyway, clean before the move so you do not carry the junk across. See how to move from Pipedrive to HubSpot without losing deals.

What if we delete the wrong records?

In HubSpot, you can restore deleted contacts, companies and most other records within 90 days. A merge cannot be undone. So export everything before you start, and never bulk merge without a sample review.

Ready to scale?

Your sales should be your
competitive advantage.

Book a 30-minute strategy call. We'll map your funnel, find where revenue is leaking, and show you exactly what we'd design, build, and run for you.

Book your Revenue Operations Audit Call