Why three open deals on one company is almost never legitimate
There are real reasons a company has multiple open deals:
- Multi-product company genuinely buying two things.
- Renewal deal + expansion deal running in parallel.
- One legitimate deal + one carryover from a prior failed cycle.
But once you cross three open deals on the same company in the same pipeline, you're almost always looking at one of:
- Duplicate opportunities — same deal, recreated by a different rep who didn't see the existing one.
- Two reps competing — territory split is broken, both reps think the company is theirs.
- Stale records — old deals never marked closed-lost, polluting the active pipeline.
All three corrupt your forecast. Duplicates double-count the dollar. Competing reps confuse the buyer ("who am I supposed to talk to?"). Stale deals inflate stage-conversion stats.
What two flavors of the question really ask
Two flavors of the question:
The "right now" version: which companies currently have 3+ open deals in the same pipeline?
The "stop creating them" version: which reps tend to create duplicate deals, and where in the funnel does it happen?
The first is a filtered view. The second requires deal-creation history and a sortable rollup — most teams don't do this audit because it's painful in the native UI.
Why context decides whether each cluster is real
Catching duplicate deals is harder than it sounds because the right answer depends on context:
- Same product, different buyer at a multi-divisional company → two real deals.
- Same product, same buyer, two separate POs → real, but should be tracked as one deal with line items.
- Same product, same buyer in two reps' pipelines → duplicate.
- Same product, same buyer, one closed last quarter, new one this quarter → renewal, not duplicate.
A pure "more than 2 open deals" rule has false positives. Your sales-ops team ends up reviewing the list manually, deciding which are real, and merging the rest. That review is recurring labor — every quarter, there are new duplicates because new reps create them. The review never ends.
The strongest preventive controls — required association rules, manual approval before creating a 2nd deal on a company, deal-merge prompts — are non-native to HubSpot. You build them in Operations Hub or outside the platform. Most teams just live with the duplicates and clean up quarterly.
The manual HubSpot recipe
One filter, one optional calculation property, one optional prevention workflow. Setup is fast; the harder discipline is the recurring manager-review pass.
- Open Companies → Create viewNavigate to Companies → Companies. Click 'Create view' in the top right.
- Add filter: Number of associated deals > 2Filter by Company properties →
Number of associated deals→ 'is greater than' → 2. Three or more deals is the heuristic threshold. - (Optional) Filter to open deals onlyHubSpot doesn't natively expose 'number of open deals'. Workaround: build a calculation property
count_open_deals(Operations Hub Pro+) and filter on it. Without that, accept that closed-lost deals from prior cycles will show up too. - Add columns: Number of associated deals, Domain, Account ownerThese give you the triage context. Account owner reveals territory-conflict cases.
- Save as 'Companies — Likely duplicate deals'Pin to the sales-ops dashboard. Review monthly with managers.
- Build the on-creation duplicate-detection workflowWorkflows → Create → Deal-based. Trigger: deal created. Branch: count of open deals on associated company > 1. Action: Slack the deal owner + ops with a 'potential duplicate' alert linking to existing deals. Requires Operations Hub Pro+.
What Bloated does instead
Duplicate deals — by company, by rep, with territory-conflict context.
Bloated finds every company with 3+ open deals AND breaks down which rep owns each so territory conflicts are visible at first glance. Same product, same buyer, different reps is the strongest 'genuine duplicate' signal. Pair with the suggested action: merge to one deal, escalate to RevOps for territory clarification, or accept (multi-divisional case).
associated deals count · HubSpot company data