Data quality

Duplicate companies in HubSpot keep coming back

Most teams have merged duplicates at least twice. They come back because nothing changed about what gets in.

The short answerDuplicates are a creation problem wearing a cleanup costume. Forms that create on email rather than domain, imports without a matching rule, enrichment tools writing new records instead of updating existing ones, and reps creating an account rather than searching for it. Merge without fixing those and you are scheduling the same project for next quarter.

Where they actually come from

Four sources cover almost every case. Form submissions matched on email address rather than company domain. Spreadsheet imports run without a deduplication rule. Enrichment or prospecting tools creating records when they cannot match. And reps typing a name slightly differently because searching felt slower than creating.

Why merging alone fails

A merge is a point in time. The rules that allowed the duplicate are still running the day after. Teams that merge without governance see the duplicate rate climb back to roughly where it was within a quarter, which is how organisations end up doing this every year and concluding that CRM hygiene is hopeless.

What blocking actually looks like

Normalise on domain rather than company name. Require a domain on creation from forms and integrations. Set matching rules on import rather than trusting the file. Give reps a search-first flow that makes finding the account easier than creating one. Then run a scheduled merge for the backlog rather than a heroic one-off.

The cost of leaving it

Duplicates do not just look untidy. They split the activity history, so nobody can see that this account already said no. They break attribution, because revenue lands on one record and the campaign on another. They inflate counts, so your pipeline and your TAM are both wrong. And they teach the sales team that the CRM is not the truth.

Count these before you merge anything

  • Accounts sharing a domain but not a record
  • Records created in the last 90 days with no domain at all
  • Which integrations have create permission
  • Whether your forms match on email or on domain

Questions

How do I find duplicate companies in HubSpot?

HubSpot has a built in duplicate management tool, but it works on similarity rather than on your rules. A domain based report usually surfaces more, because it catches records that do not look similar by name.

What is an acceptable duplicate rate?

Under about five percent on accounts is workable. Above ten percent, reporting built on account counts is no longer reliable.

Should we use a deduplication tool?

Tools help with the backlog. They do not change what gets created tomorrow, which is why governance has to come first or alongside.

How long does a cleanup take?

The merge itself is usually days. Agreeing the matching rules and fixing the creation paths is the part that takes real time, and it is the part that makes it stick.

Want to talk it through?

Leave an email and I will reply myself, usually the same day. No sequence, no newsletter, and no calendar link unless you ask for one.

One reply from a person. Nothing else.

Got it. You will hear from hello@sapwood.io.

Would rather just book time? Here is the calendar.