Advanced: Revenue Forecasting and Team Performance
Use pipeline data to forecast monthly revenue, track team performance by rep, and identify where deals are dying.
Revenue Forecasting and Team Performance.
Forecasting Revenue.
Your pipeline value tells you potential revenue. But not every deal closes. Apply your historical close rate to get a realistic forecast:
- Simple forecast: Total pipeline value x overall close rate. Example: $200K pipeline x 30% close rate = $60K expected revenue.
- Weighted forecast (more accurate): Weight by stage. Discovery deals close at 10%, Proposal at 40%, Negotiation at 70%. Multiply each deal by its stage probability.
Stage Conversion Analysis.
Where are deals dying? If you lose 60% of deals at the Proposal stage, the problem is: pricing, presentation quality, or prospect qualification. Fix the stage with the highest drop-off.
- Lead → Qualified: Are you targeting the right people?
- Qualified → Discovery: Are you getting meetings?
- Discovery → Demo: Are you uncovering real pain?
- Demo → Proposal: Is the product solving their problem?
- Proposal → Close: Is pricing right? Urgency present?
Team Performance (When You Scale).
Per-rep metrics:
- Deals in pipeline (volume).
- Close rate (quality).
- Average deal size (value).
- Cycle time (speed).
- Activity count (effort).
Use these to: identify top performers (model their behavior), coach underperformers (find their bottleneck), and set fair quotas (based on data, not guesses).