What This Solves
- No visibility into why deals are lost
- Missed patterns in pricing, product gaps, or competition
- Inability to prioritize highest-impact fixes
How It Works in HubSpot
1. Standardize “Closed Lost Reason” (Required Field)
Create or enforce a deal property:
- Property:
Closed lost reason(dropdown select) - Example options:
- Price too high
- Lost to competitor
- Missing feature
- No decision
- Timing
Then enforce via:
- Pipeline rule: Require property on Closed Lost stage
2. Capture Lost Revenue Value
You already have:
Amount(deal value)
When a deal moves to Closed Lost, that amount becomes lost revenue.
3. Build Lost Revenue Report
Use Custom Report Builder:
- Object: Deals
- Filters:
- Deal stage = Closed Lost
- Close date = This quarter/month
- Metrics:
- Sum of Amount → Total revenue lost
- Breakdowns:
- Closed lost reason
- Industry / persona
- Deal owner
4. Create “Revenue Leakage” Dashboard
Add:
- Lost revenue by reason (bar chart)
- Lost revenue vs won revenue (ratio)
- Lost revenue trend over time
Advanced Version (Where This Becomes Powerful)
A. Add Competitor Tracking
Create property:
Primary competitor
Now you can quantify:
- Revenue lost to each competitor
- Average deal size lost per competitor
B. Calculate Loss Rate by Segment
Combine with your segmentation hack:
- Industry
- Persona
Example insight:
- SaaS = 60% loss due to missing feature
- Manufacturing = 45% loss due to price
C. Build “Recoverable Revenue” View
Create a filtered view:
- Closed Lost reason = Timing / No decision
- Last activity date < 90 days
This becomes a reactivation pipeline.
Example Insight Output
- £1.5M lost this quarter
- £600K (40%) lost due to pricing
- £400K lost to one competitor
→ Clear action:
- Pricing strategy review = highest ROI lever
