Why orphan deals are worse than they look
A deal in HubSpot is a record of a buying opportunity. Without an associated contact, it's a record of an opportunity with nobody to talk to. That seems impossible — surely every deal has a buyer? — but it's surprisingly common:
- The deal was created from a stale workflow that fires on company-level events (new ARR threshold, geographic expansion) and creates the deal but doesn't attach a contact.
- The original contact was deleted or merged, and HubSpot detached the association during the cleanup.
- The deal was created via API integration — Stripe, calendar tools, custom CRM imports — that didn't have contact context to attach.
- A rep duplicated a deal and the contact association didn't carry over (rare but happens).
Once orphaned, the deal is functionally invisible to most workflows. Contact-based cadences can't enroll it. Sequences can't reach it. Email-based reporting (open rates, reply rates) doesn't apply. The deal exists in the pipeline number but nobody is actually selling against it.
What two filter conditions actually catch
Two filter conditions:
- Number of associated contacts is
0. - Deal stage is not Closed Won / Closed Lost — orphans on closed deals are still messy but less actionable.
That's the entire rule. The harder part is fixing the orphans, which usually means identifying who should be on the deal and re-attaching.
Why the report you'd build to find these hides them
Multi-object reports in HubSpot have a known behavior that compounds this problem: when you build a report joining deals + contacts, HubSpot silently filters out deals with no associated contact. The orphan deals are missing from the very reports you'd use to find data quality issues.
The community workaround: never use multi-object joins for hygiene audits. Use single-object filtered views (which is what the rule above does). The view tells the truth; the report doesn't.
The other friction: re-attaching contacts is mostly manual. You open the orphan deal, look at the deal name or notes for clues about who the buyer was, search for that person, and re-associate. For 5 orphan deals this is a coffee break. For 500, it's a sales-ops project.
Some teams build a recovery workflow: when a deal is detected as orphaned, automatically attach the Associated company's primary contact as a fallback. That's a reasonable starting point for getting some contact on the record, but the primary contact at the company isn't always the actual deal contact — it's just the first one created. Worth doing as a baseline; not a substitute for actually identifying the right person.
The manual HubSpot recipe
Two filters in a single-object view. Re-attach manually for small lists; build the auto-attach workflow for ongoing prevention.
- Open Sales → Deals → Create viewNavigate to Sales → Deals. Click 'Create view' in the top right. Crucially, this is a *single-object* view — joined reports don't work.
- Add filter: Number of associated contacts is equal to 0Filter by Deal properties →
Number of associated contacts→ 'is equal to' → 0. - Add filter: Deal stage is not closed won/lostAND group →
Deal stage→ 'is not any of' → 'Closed Won', 'Closed Lost'. Orphans on closed deals are still messy but less actionable. - Add columns: Deal owner, Associated company, Created dateThe associated company is your re-attach starting point — open the company record and pick the most relevant contact.
- Save as 'Orphan deals — no contact'Pin to your sales-ops dashboard. Re-attach contacts manually for the small list, build the recovery workflow for the long-tail.
- Build the recovery workflow (optional)Workflows → Create → Deal-based. Trigger: deal has 0 associated contacts AND open stage. Action: auto-attach the associated company's primary contact as a fallback. Imperfect but better than zero.
What Bloated does instead
Orphan deals AND the most likely re-attach candidate, in one view.
Bloated finds every orphan deal AND suggests the most likely re-attach candidate based on the associated company's contact list, deal title keywords, and engagement history. Re-attach in one click instead of opening each company and searching for the right person. Pair with the suggested action: re-attach now, mark deal as company-only opportunity, or archive.
associated contacts · HubSpot deal data