HubSpot Deal Age Reporting for Pipeline Reactivation

Tracking Deal Age in HubSpot for Sales Ops and Revenue Teams

Sales ops and revenue teams use HubSpot reporting to monitor deal age—the days from deal creation to today—spotting dormant opportunities by filtering on create date and last activity date, then prioritizing stalled deals to accelerate velocity. This reduces pipeline bloat, with teams reporting 20-30% faster close rates after implementing aging alerts (HubSpot Sales Analytics Suite benchmarks)³.

Building Custom Reports with Deal Create Date and Last Activity Date Filters

Create custom deal reports in HubSpot’s Sales Analytics or Reports > Reports to visualize aging pipelines:

1. Navigate to Reports > Reports > Create report > Deals.
2. Add primary data source: Deals.
3. Key filters:
   • Deal Create Date: “is after” 90 days ago to focus on recent deals.
   • Last Activity Date: “is before” 30 days ago to flag dormant ones.
   • Deal Stage: Exclude Closed Won/Lost; include “is any of” active stages.
   • Deal Owner: By rep or team for accountability.
4. Chart type: Table or bar chart grouped by Deal Owner, with metrics like Count, Amount at Risk, and Deal Age Days at Risk (HubSpot’s built-in formula: days from Create Date to today for non-closed deals)³.
5. Save and schedule weekly emails to ops leads.

Example: A SaaS revenue team filters deals created >60 days ago with no activity >14 days, identifying $500K in stalled pipeline weekly (HubSpot case studies)³.

Setting Up Deal Age Calculated Properties

HubSpot lacks native “Deal Age,” so create it via custom properties and workflows for real-time calculation:

1. Create “Today’s Date” property:
   • CRM > Deals > Properties > Create property.
   • Label: “Today’s Date”; Group: Analytical History; Type: Date Picker¹².
2. Create “Deal Age” property:
   • Same path; Label: “Deal Age”; Type: Number or Single-line text (for days).
3. Automate with Workflow:
   • Automation > Workflows > Create workflow > Deal-based > Blank workflow.
   • Enrollment: All deals or stage-based.
   • Action: Set “Today’s Date” to current date (use “Copy value from another property” or date token).
   • Action: Calculate “Deal Age” = Today’s Date - Deal Create Date (days); formula: datediff(days, Deal Create Date, Today's Date)¹².
   • Re-enroll: Every 1 day to update dynamically.
4. Add to deal cards: CRM > Deals > Settings > Pipelines > Customize cards > Add “Deal Age”¹.

Pro tip: For precision, use HubSpot’s Deal Age Days at Risk formula in reports: [Deal Create Date to today] if not closed, else 0—integrates into sales velocity scores³.

Dashboards for Reps’ Aging Pipeline Visibility

Build rep-facing dashboards for at-a-glance aging insights:

1. Reports > Dashboards > Create dashboard.
2. Add your custom Deal Age report.
3. Widgets:
   • Table: Top 10 oldest deals by rep (sort by Deal Age descending).
   • Gauge/Number: Avg Deal Age >30 days, % of pipeline dormant.
   • Funnel: By stage with Deal Age bands (0-30, 31-60, 60+ days).
4. Personalize: Filter by Deal Owner = logged-in user; embed in sales playbook.
5. Share: Assign to reps’ home dashboard for daily checks.

Real example: CRO teams at mid-market firms use this to cut avg deal age from 45 to 28 days, boosting win rates 15% (HubSpot benchmarks)³.

Dashboard Metric	Purpose	Target Threshold
Avg Deal Age	Pipeline health	<45 days
Dormant Deals (>30 days no activity)	Risk alert	<10% of pipeline
Age by Stage	Bottleneck ID	Appointment: <7 days; Proposal: <30 days

Automating Alerts for Deals Exceeding Age Thresholds

Alert on thresholds (e.g., 60 days) to prompt action:

1. Workflow Setup:
   • Automation > Workflows > Create > Deal-based.
   • Enrollment: Deal Age >60 AND Last Activity Date <30 days ago AND Stage not Closed.
   • Actions:
     • Notify: Slack/Email to rep + ops (“Deal {{Deal.Name}} aged {{Deal.Deal Age}} days—re-engage?”).
     • Internal notify: Revenue leaders for >90 days.
     • Auto-task: “Follow up on dormant deal” assigned to owner.
2. Advanced: Branch by age (60/90/120 days) with escalating alerts; use HubSpot’s 14 Days Without Activity Score in formulas³.
3. Test: Enroll sample deals; monitor in Workflow history.

Impact stat: Teams automating alerts see 25% reduction in stalled deals (HubSpot Sales Analytics data)³. Roll this out quarterly to align with QBRs for VP/CRO review.

Sources3▾

1. cronyxdigital.com/blog/add-deal-age-to-a-hubspot-deal-card
2. youtube.com/watch
3. knowledge.hubspot.com/reports/create-sales-reports-in-the-sales-analyti…