# HubSpot Data Quality Command Center and duplicate management: a weekly check for a small sales team

https://salesbond.app/blog/hubspot-data-quality-command-center-duplicates/
Published: 2026-10-22 · Updated: 2026-10-22

HubSpot’s Data Quality Command Center shows two things a sales manager cares about: pairs of records HubSpot thinks are duplicates, and property values it thinks are formatted wrong. A manager of five reps needs about half an hour a week with it. Spend the first half on duplicate companies and contacts that sit on open deals, because those are the ones that make the pipeline report count a customer twice, and the rest on the properties your reports and routing depend on. Everything else can wait for a monthly clean.

This is the HubSpot-specific version of the routine. The CRM-neutral monthly hour is in [CRM data cleansing as a monthly routine for a small team](https://salesbond.app/blog/crm-data-cleansing-monthly-routine-small-team/); this article is only about the weekly pass and the HubSpot tools it uses.

## What the Data Quality Command Center shows (and what it does not)

The page lives under **More > Data Management > Data Quality**. HubSpot’s help center calls it the data quality overview page and, a few paragraphs later, the data quality command center. It opens on a summary and a block of recommended actions, then splits into tabs: Manage Duplicates, Formatting issues, Data Enrichment and Property Insights ( [HubSpot: Use data quality tools](https://knowledge.hubspot.com/data-management/use-data-quality-tools)). Recommended actions also count unused workflows, and Property Insights flags duplicated, empty or unused properties. The weekly check needs only the first two tabs. Duplicate alerts exist as well, but they need Data Hub Professional or Enterprise, and the account is checked for them every 24 hours, not on demand (same article).

What it does not show is the thing you actually want: which duplicate matters. The duplicates table knows that two company records look alike. It does not know that one of them has a $40k deal in Negotiation and the other has a rep who just logged a discovery call on the same buyer. That judgement comes from the pipeline, so the weekly pass starts from your open deals, not from the table.

The duplicates manager covers contacts and companies only ( [HubSpot: Manage duplicate records](https://knowledge.hubspot.com/records/manage-duplicate-records)), so a duplicate deal is still found by a human. The formatting checks HubSpot documents are for contact properties: Email, the name fields, State/Region and Country ( [HubSpot: Manage property format issues](https://knowledge.hubspot.com/records/manage-property-format-issues)). A company whose Industry says “SaaS” on one record and “Software” on another is not among them. As for plans, the duplicates manager needs a Professional or Enterprise subscription, and so does the formatting tool (Starter accounts get it only through a public beta). Merging two records you already know about works on every plan ( [HubSpot: Merge records](https://knowledge.hubspot.com/records/merge-records)).

## Duplicate management: the pairs that break deal reports

A duplicate company is worse than a duplicate contact, and it is not close. Deals associate to companies, so two records for the same customer split the deal history, the activity timeline and any report grouped by company. A duplicate contact mostly splits emails and a sequence enrollment. Annoying, but it does not change the number at the top of the pipeline report.

HubSpot finds candidates by comparing property values as records are created and once a day otherwise. By default it looks at Company Domain Name, Company Name, Country/Region, Phone Number and Industry for companies, and First Name, Last Name, Email, IP country, Phone, Zip Code and Company Name for contacts. Each pair gets a similarity score, and the table shows when the pair was found ( [HubSpot: Manage duplicate records](https://knowledge.hubspot.com/records/manage-duplicate-records)). Same domain on both records makes an easy, high-score pair. A holding company and the operating company you actually sell to, with different domains, will score low or not appear at all, and that is exactly teh pair that carries two open deals with two owners.

So the order is: companies attached to open deals, then contacts attached to open deals, then everything else, and “everything else” is monthly, not weekly. We think a pair with no open deal and no activity last quarter can wait a month. A pair with two open deals cannot sit there until Friday.

When you merge companies in HubSpot, the record you pick as primary keeps its property values, blanks are filled from the secondary, and the activities and associated records of both, deals included, land on the result. By default the merged record gets a new Record ID (the old ones stay in the Merged [record] IDs property), which matters if a spreadsheet keys on ID. And it is one-way: “It’s not possible to unmerge records” ( [HubSpot: Merge records](https://knowledge.hubspot.com/records/merge-records)). Pick the older record as primary when in doubt, it usually holds the history.

## The 30-minute weekly pass

Same day each week, before the pipeline review, so the review runs on merged numbers. If you haven’t yet, turn on the weekly data quality digest (Set it up in the Recommended Actions block); last week’s changes then arrive by email. The timer is honest. If you blow past thirty minutes you are doing monthly work.

![Timeline of the 30-minute weekly pass split into five steps, from reading the page to writing three numbers](https://salesbond.app/wp-content/uploads/2026/10/hubspot-data-quality-command-center-duplicates-2.png)

1. Minutes 0–5: read the page, write nothing yet. Open Data Quality and note the duplicate counts for companies and contacts. Above the Manage duplicates table, “Last checked for duplicates on [date]” is the last time a scan found a duplicate, not the last time it ran ( [HubSpot: Manage duplicate records](https://knowledge.hubspot.com/records/manage-duplicate-records) ).
2. Minutes 5–15: company pairs on open deals. In your open-deals view, read the Associated company column for the same customer under two names or spellings. Then go to **Companies**, click the three vertical dots in the upper right and select **Manage duplicates**; the same table sits on the Manage Duplicates tab of the Data Quality page. Pick the primary, merge. Reject the pairs that are clearly two different companies. A rejected suggestion does not come back unless one of its records is later merged into another, and you have 14 days to roll back a rejection if you were wrong (same article).
3. Minutes 15–22: contact pairs on open deals. Same move from **Contacts**, limited to people who sit on an open deal or are enrolled in a sequence. Two “Anna Kowalski” records at different companies are not a duplicate; reject them so they stop coming back.
4. Minutes 22–27: formatting issues that route or report. Open **Contacts > Actions > Fix formatting issues** and accept only the fixes on Country, State/Region and Email. Skip names this week (see the next section).
5. Minutes 27–30: three numbers in the weekly note. Pairs merged, pairs rejected, formats accepted. Next week the merged count should fall; if it climbs for three weeks, a form, an import or an integration is creating the duplicates and the fix is upstream, not in the table.

One rule for the pipeline review that follows: a deal whose company was merged this week gets its amount and close date re-read out loud. The surviving record now carries two reps’ notes, and they may not agree on where the deal stands.

## Formatting issues: fix the ones that route or report

Country and State/Region first, names last. For Email and the name fields HubSpot’s tool flags capitalization, swapped or combined names, placeholder text and invalid or temporary addresses; for State/Region and Country it flags capitalization, punctuation, empty values and values that don’t match the format you chose in settings ( [HubSpot: Manage property format issues](https://knowledge.hubspot.com/records/manage-property-format-issues)). Of all that, the location fields are the ones a small sales team’s reports and territory rules actually read. “california”, “CA” and “California” are three values in a report grouped by state, and a workflow that routes by Country/Region will skip the record spelled “usa”.

Email comes second: an invalid address is a sequence that bounces. Names come last. “LORELAI GILMORE” looks bad in a merge field, but it does not change a number.

HubSpot uses Breeze to pick the issues and says plainly that “you may disagree with a detected issue or suggested fix” (same article). Accept or Reject takes the item off the list either way. And if a fixed record is later overwritten with another wrong format, by hand, by import or through an integration, the page will typically not flag it again ( [HubSpot: Use data quality tools](https://knowledge.hubspot.com/data-management/use-data-quality-tools)). A bad fix stays invisible from then on, so be slow with the select-all checkbox.

Automation can fix capitalization, combined fields, and spacing and punctuation on Email, First Name and Last Name, for the records in the list and for new ones going forward. It needs Data Hub Professional or Enterprise ( [HubSpot: Manage property format issues](https://knowledge.hubspot.com/records/manage-property-format-issues)). Without it the weekly pass is manual, and its still five minutes if you stick to location and email.

## Limits of the built-in tools: pair caps, daily checks, no undo

The duplicates manager shows up to 10,000 pairs on a Professional or Enterprise subscription; bulk management with Data Hub Professional or Enterprise raises that to 30,000 or 100,000 ( [HubSpot: Manage duplicate records](https://knowledge.hubspot.com/records/manage-duplicate-records)). A team of five hits that only after a large import full of near-duplicates; then start the pass from the import file, not the table.

There is no rescan button. Duplicates are compared at creation and once a day, and the help articles describe no way to force a re-check of a record.

The page does not keep your history either. The summary gives a percentage change over a date range, and the merge history export covers 90 days and only merges done in the Data Quality tool ( [HubSpot: Merge records](https://knowledge.hubspot.com/records/merge-records)). Your weekly note is the real record. If you want it as a metric with a target, the definitions are in [CRM data quality metrics](https://salesbond.app/blog/crm-data-quality-metrics/).

Custom matching helps with the holding-company case: up to two custom rules per object, up to nine properties each, on Data Hub Professional or Enterprise ( [HubSpot: Manage duplicate records](https://knowledge.hubspot.com/records/manage-duplicate-records)). A rule on Company Name plus Country, without the domain, finds the pairs the default scoring misses, and a lot of pairs that are not duplicates. That makes it a monthly tool.

## Who presses Merge

The manager owns the list; the rep who owns the primary record presses Merge. There is no undo, and only the person who has talked to the customer knows whether “Acme Ltd” and “Acme Limited” are one buyer or a reseller and its client.

Merging needs the Merge records permission or Super Admin. The duplicates manager needs Data quality tools access plus edit permissions set to All contacts or All companies ( [HubSpot: Merge records](https://knowledge.hubspot.com/records/merge-records); [Manage duplicate records](https://knowledge.hubspot.com/records/manage-duplicate-records)) If your reps have those rights the rule is simple: nobody merges a record they do not own. A pair owned by two different reps goes to the manager, who reads both timelines and picks the primary.

If the merged count does not fall, look upstream: [which integrations should be allowed to write to deals](https://salesbond.app/blog/hubspot-integrations-write-to-deals-manager-allow-list/) and, for contacts that keep arriving as new leads, [lead status vs lifecycle stage in HubSpot](https://salesbond.app/blog/hubspot-lead-status-vs-lifecycle-stage/).

A disclosure: we build SalesBond, a sales management layer on top of the CRM a team already uses. The merge itself still happens in HubSpot, by the rep who owns the record. If the weekly pass is already a habit and you want a second look at the pipeline behind it, [check your CRM with SalesBond](https://salesbond.app/).

Before next week’s pipeline review, open your open-deals view, sort it by company, and look for the same customer twice. If you find one, that pair is your first merge, and the other 25 minutes can wait until the review is over.