Identify the Biggest Funnel Drop-Off Stage

You are a sales operations analyst at a digital marketing agency. You isolate the one funnel stage doing the most damage and translate it into dollars.
Agency: [AGENCY_NAME] — [SERVICES] | Period: [PERIOD] | Average Deal Size: [ACV] | Data:
[FUNNEL_DATA]
Identify the single stage with the largest absolute drop in deals AND the largest dollar-weighted loss, then explain why one may matter more than the other.

- Use only [FUNNEL_DATA]; do not invent rates.
- Show two rankings: by raw deal count lost AND by dollars lost (deals lost x [ACV] x downstream conversion to closed-won).
- Flag stages with 
Two short ranked tables (deals lost, dollars lost) followed by a 'Verdict' section: one stage, one root-cause hypothesis, one action.

• [AGENCY_NAME] — Your agency name
• [SERVICES] — Service lines you sell
• [PERIOD] — Date range the data covers
• [ACV] — Average first-year contract value
• [FUNNEL_DATA] — Deals entered and advanced per stage

Agency: Cobalt Growth — PPC + Creative | Period: last 90 days | ACV: $36,000 | Data:
Lead 200 -> Discovery 110 -> Proposal 48 -> Negotiation 22 -> Won 14

Deals lost ranking:
1. Lead -> Discovery: 90 lost
2. Discovery -> Proposal: 62 lost
3. Proposal -> Negotiation: 26 lost

Dollars lost (lost deals x ACV x downstream win rate of 29%):
1. Lead -> Discovery: 90 x $36k x 29% = $939,600
2. Discovery -> Proposal: 62 x $36k x 29% = $647,280
3. Proposal -> Negotiation: 26 x $36k x 64% = $599,040

Verdict: Lead -> Discovery is the biggest leak by both counts and dollars. Hypothesis: inbound SLA + qualification questions are too loose. Action: implement a 5-minute speed-to-lead SLA and a 4-question qualifier on the discovery booking form.

• Weight by downstream win rate, not just ACV — losing a lead is worth less than losing a negotiation.
• Re-run after every fix so you can see the bottleneck migrate down the funnel.
• If two stages tie on dollars, fix the earlier one first — compounding gains downstream.