Lead — Deal Conversion by Speed
Petavue, for all leads that closed-won in the past 12 months:
1. Time-to-Close: Calculate days_to_close = Close_Date – Lead_Create_Date.
2. Cohorts: Group deals into 0–30, 31–60, 61–90, 91–180, and 181–365 day buckets.
3. Cohort Metrics: For each bucket, report:
- Deals Closed (count)
- Win Rate % (closed-won vs. total opportunities in that bucket)
- Average Deal Size ($)
4. Outputs:
- Summary table of cohort metrics
- Cumulative distribution in JSON format
5. SLA Recommendation:
- If the fastest (0–30 day) cohort’s win rate is ≥ 1.5× that of the slowest (181–365 day) cohort, recommend prioritizing early-intent leads and setting an SDR alert for any new lead without contact within 24 hours.
- List cohorts where the win rate gap between the fastest (0–30 days) and slowest (181–365 days) is 1.5× or greater, showing their win rates and average deal sizes.
- Break down average deal size by cohort and identify which cohorts exceed the overall average.
- Show the distribution of days_to_close for deals in the top 25% by ACV.
What This Prompt Does
This prompt measures the time from lead creation to close for all Closed‑Won leads over the past 12 months, segments deals into five speed cohorts (0–30, 31–60, 61–90, 91–180, 181–365 days), calculates closed deal counts, win rates and average deal size per cohort, returns a summary table and cumulative distribution JSON, and suggests prioritising fast‑closing leads (with an alert to SDRs) when the fastest cohort’s win rate is at least 1.5 × that of the slowest.
Strategic Impact
By linking conversion speed to deal outcomes, this prompt drives smarter lead prioritisation and process optimisation.
Business outcomes:
→ Accelerates revenue velocity by focusing on leads that close fastest
→ Improves SDR efficiency with targeted contact alerts
→ Raises average deal size by highlighting high‑value, quick‑close cohorts