Table of contents
applicable Roles
RevOps
Sales Ops
CRO
Sales Ops
CRO
Petavue, for the past two quarters:
1. Funnel Construction: Build the pipeline stages—Lead Created → MQL → SQL → Opportunity → Closed-Won.
2. Stage Metrics: For each stage, report:
3. Tables: Provide:
4. Drop-Off Visualization: Generate bar-chart JSON showing stage-to-stage drop-off, flagging any step where conversion falls below 70% of the previous stage average.
5. Stalled Deals: List the 10 largest deals that have been in their current stage longer than twice the median duration.
This prompt constructs a funnel from Lead Created through MQL, SQL, Opportunity and Closed‑Won stages for the last two quarters. For each stage it counts entries, calculates conversion rate to the next stage and median days spent in stage. It then breaks these metrics down by source (Inbound, Outbound, Partner), generates bar chart JSON highlighting any drop‑off steps with conversion under 70 percent of the previous stage average, and appends a list of the ten largest deals currently stuck beyond twice the median stage duration.
By pinpointing where and why leads stall in the funnel, this prompt drives targeted process improvements and faster deal flow.
Business outcomes:
→ Increases conversion efficiency by identifying and addressing weak funnel stages
→ Enhances forecast accuracy with clear stage‑level timing and drop‑off metrics
→ Improves resource allocation through source‑specific performance insights