Why this is the highest-leverage view in your pipeline
A deal whose close date is two weeks out should be the most-touched deal in the rep's book. Final negotiations, redlines, procurement check-ins, exec sponsor calls. If the deal is real, the calendar around it is busy.
If the calendar is empty — no logged activity, no scheduled call, no recent email — there's almost always a reason:
- The deal is already lost and the rep is hoping the close date passes quietly so they can quietly mark it lost without it counting against forecast attainment.
- The buyer disappeared and the rep stopped chasing, but didn't push the date out either, because pushing draws management attention.
- The deal needs urgent intervention — exec call, custom proposal, anything to break the silence — and nobody's flagged it.
All three need a manager to know about them right now, not at the end of the quarter.
What three filters in combination actually catch
Three filters in combination:
- Close date is within the next 14 days.
- Last contacted date is more than 7 days ago.
- Deal stage is not Closed Won / Closed Lost.
7 days is the standard threshold but adjust to your sales motion. For high-velocity transactional sales, 3 days. For complex enterprise, 10-14.
Why the close-window distortion costs more than other rules
notes_last_contacted has the same caveat as everywhere else it appears: sequence emails count as "contact." A deal that received an automated drip 6 days ago looks freshly contacted in the filter, even though no human has actually reached out.
For deals this close to closing, that distortion matters more — the cost of missing a real silent deal is the deal itself. Most teams either:
- Live with the false negatives (some real silences look fresh because of sequence sends).
- Build the custom "first genuine contact" property — a workflow-maintained field that excludes activities sourced from sequences. Reliable but ongoing maintenance.
The other manual friction: 14 days isn't always the right window. Q4 enterprise deals get 30-day visibility. SMB transactional deals get 5. Each pipeline gets its own version of this view, each calibrated to its sales cycle. Keeping the calibrations in sync as your motion evolves is constant work.
The manual HubSpot recipe
Three filters and a sort. Setup is fast; the harder discipline is acting on every row weekly while the close window is still open.
- Open Sales → Deals → Create viewNavigate to Sales → Deals. Click 'Create view' in the top right.
- Add filter: Close date is less than 14 days from nowFilter by Deal properties →
Close date→ 'is less than' → 14 days from now. Tightens the cohort to deals approaching their close window. - Add filter: Last contacted is more than 7 days agoAND group →
Last contacted→ 'is more than' → 7 days ago OR 'is unknown'. The 7-day threshold is conservative — for high-velocity sales adjust to 3 days, for enterprise 10-14. - Add filter: Deal stage is not closed won/lostAND group →
Deal stage→ 'is not any of' → 'Closed Won', 'Closed Lost'. Only open deals — closed deals don't need this check. - Sort by amount, descendingBiggest deals at the top. A silent $400K deal closing next week needs a different conversation than a silent $5K deal.
- Save as 'Closing soon, silent'Pin to manager dashboards. This is the cohort where exec sponsor calls happen — escalation is part of the response.
What Bloated does instead
Closing-soon deals where the rep has actually gone silent — sequence noise excluded.
Bloated cross-references close date proximity with rep-only contact recency — sequence emails, auto-replies, and bulk sends don't count. The cohort surfaced is the genuine 'rep is checked out, deal is dying' signal. Pair with the suggested action: exec sponsor reach-out, ROI re-articulation, or close-loss conversation.
closedate, notes_last_contacted · HubSpot deal properties