RevOps Pipeline & Forecast Audit
Audit CRM data hygiene and isolate commercial risk from administrative noise to improve forecast accuracy.
Customise & copy
Add the context you have. The prompt updates as you work.
Paste a summary or export of current open opportunities including amount, stage, close date, probability, and forecast category.
Describe your CRM pipeline stages and the mandatory entry criteria required to advance a deal.
Provide data regarding emails, calls, and meetings logged per deal over the last 30-60 days.
Provide historical win/loss rates or past forecast accuracy metrics (e.g., historical quota attainment or slippage trends).
Select the primary industry and sales motion to calibrate expected sales cycles.
Live prompt
5 fieldsYou are a senior Revenue Operations (RevOps) auditor. Your task is to audit the underlying data quality and process consistency behind a revenue forecast to isolate administrative hygiene issues from true commercial risk, and recommend corrective RevOps controls. Analyze the following inputs provided from our CRM and sales operations: 1. Opportunity Records & Forecast Data: {{opportunity_records}} 2. Pipeline Stage Definitions & Entry Criteria: {{stage_definitions}} 3. Activity History & Engagement Metrics: {{activity_history}} 4. Historical Context & Past Forecast Performance: {{historical_context}} 5. Target Sales Motion / Industry: B2B Enterprise SaaS Produce a structured audit report following this exact structure: 1. EXECUTIVE SUMMARY - High-level assessment of the forecast's reliability. - Summary breakdown of administrative hygiene failures versus genuine commercial risks. 2. DATA HYGIENE & ANOMALY DETECTION - Specific identification of stale opportunities, past-due close dates, and unearned stage movements (stage-skipping). - Analysis of missing or incomplete CRM fields impacting forecast calculations. 3. TRUE COMMERCIAL RISK ASSESSMENT - Evaluation of deals with clean hygiene but low engagement/activity history. - Identification of inflated deal sizes or unverified probabilities based on stage criteria. 4. REVOPS REMEDIATION & CONTROLS - Actionable, implementable CRM validation rules and mandatory evidence fields to prevent recurrence. - Process enforcement controls and cadence adjustments for sales leadership inspection.
Proof before you use it
A real example
Tested on gemini-3.1-flash-lite on 2026-09-06
{
"sales_motion": "Mid-Market Tech Services",
"activity_history": "Automated email sequences account for 90% of touches; manual calls are rarely logged by reps.",
"stage_definitions": "Stage 1: Inbound Lead, Stage 2: Demo Completed, Stage 3: Proposal Sent, Stage 4: Closed Won.",
"historical_context": "Win rate is consistently 15% across all inbound leads, but forecast assumes 35% conversion once reaching Stage 2.",
"opportunity_records": "120 transactional deals totaling $1.5M pipeline. High volume of deals stuck in Stage 1 for over 90 days."
}A small ritual that works
How to use it
- 01Export your current CRM opportunity data, stage definitions, and recent activity logs.
- 02Input the data into the prompt variables, ensuring historical performance context is included.
- 03Review the generated audit report to distinguish between 'dirty' CRM data and genuine deal risk.
- 04Implement the suggested validation rules and process controls to prevent future forecast inflation.
Why it works
The prompt establishes a rigorous RevOps audit framework by separating administrative hygiene (stale records, missing CRM fields, past-due close dates) from true commercial risk (low buyer engagement, unverified stage criteria, historical forecast slippage). By requiring structured inputs across five specific operational dimensions—opportunity records, stage definitions, activity history, historical context, and sales motion—it forces an evidence-based assessment rather than a subjective review. Structuring the report into Executive Summary, Data Hygiene, Commercial Risk, and Remediation phases ensures that sales leadership receives both an accurate diagnostic and concrete, actionable CRM controls.
Where it fails
INSUFFICIENT_EVIDENCE
Customisation tips
Tailor the pipeline stage entry criteria variables to match your exact CRM configuration (e.g., specific entry gates for Enterprise vs. Transactional motions). Adjust the historical context and activity history variables to reflect your organization's actual measurement windows, such as 30-day versus 90-day rolling activity tracking.
Watch-outs
- Avoid introducing unsupported statistical claims, fabricated percentage metrics, or calculations that are not directly supported by the input data.
- Do not conflate administrative CRM hygiene issues (like missing fields or stale close dates) with confirmed commercial deal failures without explicit record-level evidence.
- Ensure remediation controls do not implement excessively blunt automated actions—such as automatic stage regression or abrupt record closure based solely on inactivity gaps—without proper managerial review or documented disposition.
Works in
Was this useful?
Submit your variation
If your version helps, it may be published with your name and a link back to you.
Related prompts
Sales Pipeline Deal Auditor
Audit sales deals against hard evidence to eliminate forecast inflation and uncover hidden risks.
SalesStalled Deal Revival Identifier
Identify the most viable stalled proposal to revive by filtering out active negotiations and noise from your pipeline.
SalesWeekly CRM Pipeline Health Summarizer
Transform raw CRM deal stage changes into a concise, analytical pipeline health report for sales leadership.
Want to make AI useful across your team? Explore Atul's training.