Deal-Rot Detector
Petavue, review all open pipeline opportunities and identify any that are stalled. For each opportunity:
- Calculate days in the current stage (using the stage entry date).
- Compare that to the historical average for its stage, segment (SMB, Mid-Market, Enterprise), and owner.
- Flag opportunities that either:
- Exceed 1.5× their average stage duration, or
- Have been in the same stage for over 21 days
Then deliver:
- Flagged Opportunities Table with columns:
- Opportunity Name
- Current Stage
- Stage Entry Date
- Days in Stage
- Owner
- Segment
- Total Deal Age
- Last Touch Date
- Staller Categories grouping flagged deals into:
- Moderate Stallers (10–21 days in stage)
- Critical Stallers (>21 days or >1.5× average)
Based on the flagged stalled Opportunities that have spent excessive time in their current stage:
1. For Moderate Stallers (10–21 days in stage):
- Recommend a nudge action to advance the deal — via Email or Outreach
- Suggest personalized message based on current stage (e.g., "Proposal Reminder", "Any feedback on the demo?")
- Trigger a Salesforce or HubSpot task if no activity logged in the past 7 days
2. For Critical Stallers (>21 days or >1.5× stage average):
- Recommend a requalification step or escalation
- Push a Slack alert to Opportunity Owner with next best action
- Suggest revival workflows (Outreach sequence or follow-up email template)
Output format:
- Stall Tier: (Moderate or Critical)
- Opp Name + Stage:
- Segment + Owner:
- Recommended Action (Tool):
- Trigger Condition: (e.g., "14 days in Proposal + No activity in 7 days")
What This Prompt Does
This prompt identifies pipeline deals at risk of stalling by analyzing how long each opportunity has remained in its current stage. It compares real-time stage age to historical benchmarks by deal segment, stage type, and opportunity owner, then flags deals that exceed defined thresholds. The output includes a ranked list of Moderate and Critical Stallers, along with recommended actions, such as nudges, requalification steps, or escalation triggers. This enables teams to focus on deals that appear active but are no longer progressing.
Strategic Impact
Stalled deals distort pipeline health and lead to inaccurate forecasting. This prompt helps managers surface hidden risk, improve deal hygiene, and accelerate stage progression through data-backed interventions.
Business outcomes:
→ Reduces aged pipeline and late-quarter deal slip
→ Increases conversion velocity between pipeline stages
→ Enables more targeted rep coaching based on real-time engagement and inactivity
→ Strengthens forecast accuracy by flagging functionally inactive opportunities