Your HubSpot duplicate count keeps climbing, and the Manage Duplicates tab can only show you part of it. Merging pairs by hand works for a few hundred records, but once your database reaches hundreds of thousands, every permanent merge needs a rule behind it. This guide shows you how to clean up duplicates in HubSpot at scale, from measuring your duplicate rate and writing matching rules through sandbox testing, production merges, and the Data Hub and Breeze tools that keep new duplicates out.
What You’ll Find Inside
Clean up your HubSpot database without losing consent history, associations, or reporting accuracy. The guide covers how to measure your duplicate rate against a 2% standard, a matching logic ruleset with four outcomes, a merge hierarchy for every property type, a step-by-step runbook, and a playbook for merging two HubSpot portals.
Duplicates usually come from repeated imports, integrations and sync apps, form submissions with different email addresses, and records added by hand without searching first.
HubSpot combines activities, associations, and most property values into one record, keeping the primary record's values first and filling empty fields from the other record.
Who This Is For
RevOps leads, HubSpot admins, and marketing operations managers responsible for CRM data quality
Teams on HubSpot Professional or Enterprise, with or without Data Hub
Portals holding hundreds of thousands or millions of contacts and companies
Teams whose duplicate count has outgrown what the Manage Duplicates tab can display
Anyone who ran the Portal Audit Checklist and found a five-figure duplicate count
Teams planning to merge two HubSpot portals into one
