🚀 Early Access: FREE full access to All Workflows and AI Prompt Systems! No credit card required.

Revenue Leakage Analysis

Find where revenue is lost across pipeline, pricing, handoffs, renewals, and process execution.

Sales - Revenue Operations - Revenue Leakage Analysis

Who it's for

Revenue operations leaders, Sales leaders, Finance partners, RevOps analysts, Operations managers

Get Ready

Prepare the Required Inputs listed in the Workflow Prompt. Use as much detail as necessary.

How to use this prompt

1. Copy the Workflow Prompt.
2. Paste it into your AI tool.
3. Replace the "Required Inputs"
4. Run the prompt.

🔒

Unlock the Full Workflow

Get access to this workflow and 1000+ others designed to save hours and get better results with AI.

Workflow Prompt

				
					You are a revenue operations consultant. Your task is to identify where revenue is leaking across the sales and customer journey and produce a practical recovery plan.

### Required Input
- Business Model: [Example: B2B SaaS with annual subscriptions and expansion revenue]
- Revenue Journey Scope: [Example: lead to close, close to renewal, expansion process, or full lifecycle]
- Revenue Targets: [Example: $3M quarterly new ARR target]
- Performance Data: [Provide conversion rates, win rates, discounting, churn, expansion, slippage, no-shows, or handoff data]
- Sales Process Summary: [Briefly describe lead flow, qualification, opportunity stages, proposal, close, onboarding, renewal]
- Known Problem Areas: [Example: high discounting, slow legal review, missed renewals, poor lead follow-up]
- Customer Segments: [Example: SMB, mid-market, enterprise]
- Constraints: [Example: limited headcount, CRM gaps, no dedicated CS operations]

### Input Validation
Review all inputs before analysis. If the user has not defined the journey scope or provided any performance indicators, ask for clarification before continuing. If data is partial, state assumptions and separate proven leakage from suspected leakage.

### Instructions
Treat revenue leakage as preventable revenue loss caused by process gaps, data issues, poor qualification, pricing behaviour, handoff failures, conversion friction, retention risk, or expansion underperformance. Do not only look at closed-lost deals.

Trace the revenue journey from source to realised revenue. For each step, identify where value can disappear: lead response delays, poor routing, low meeting conversion, stage stagnation, weak discovery, proposal delays, excessive discounts, procurement friction, failed handoffs, under-adoption, renewal risk, or missed expansion signals.

Quantify leakage where possible. If exact numbers are unavailable, use directional estimates and explain what data would confirm the scale. Separate leakage by revenue type: new business, expansion, renewal, and margin protection.

Make recommendations operational. Include changes to ownership, process controls, CRM fields, approval rules, inspection cadence, enablement, and handoff quality. Prioritise fixes that recover revenue without requiring major new systems.

### Output
- Executive Summary: top leakage points and estimated commercial urgency
- Revenue Journey Map: stages where revenue is created, delayed, reduced, or lost
- Leakage Findings: each issue with evidence, likely cause, revenue impact, and confidence level
- Leakage Categories: acquisition, qualification, pipeline, pricing, closing, onboarding, renewal, expansion
- Quantification Table: known or estimated loss, required data, and recovery potential
- Root Cause Analysis: process, people, data, customer, and governance factors
- Recovery Opportunities: specific actions to stop or reduce leakage
- Control Measures: dashboards, CRM rules, approvals, SLAs, or review cadences to prevent recurrence
- Prioritised Recovery Roadmap: immediate, 30-day, and 90-day actions
- Success Metrics: how to measure recovered revenue and leakage reduction

Optional advanced instructions

				
					Include a conservative, moderate, and ambitious revenue recovery estimate based on the available data.

Example output

1. Executive Summary

This audit evaluates the full lifecycle revenue infrastructure of the Cross-Border Customs API Hub product line. The goal is to isolate systemic process leaks, margin erosion, and churn points that threaten our quarterly targets.

Top Leakage Point: Late-Stage Discounting & Technical Sandbox Stagnation. Sales cycles are unnecessarily drawn out in mid-funnel technical evaluations, leading to an average 22% price concession during procurement to force quarter-end closes.
Estimated Commercial Urgency: CRITICAL. Leakage across the pipeline accounts for an estimated annualized loss of $640,000 in recurring ARR across new business and account expansions. Fixing these process gaps is our fastest path to hitting revenue goals without needing to scale top-of-funnel marketing spend.

2. Revenue Journey Map

The operational lifecycle reveals four distinct points where revenue is delayed, reduced, or lost:

Inbound Form Submission (Delayed): High-intent website requests experience variable response times, allowing lead velocity to slow down before discovery even begins.
Technical Evaluation Gate (Delayed/Lost): Opportunities stall for an average of 42 days because reps run generic product walkthroughs rather than securing technical stakeholder alignment.
Procurement & Closing (Reduced): A complete lack of pricing controls lets reps apply deep manual discounts to close deals by the end of the month.
Post-Sale Implementation (Lost): Weak technical handoffs from sales extend onboarding timelines past 30 days, delaying time-to-value and introducing early renewal risks.

3. Leakage Findings

Finding 1: Uncontrolled Late-Stage Discounting (Margin Leakage)

Evidence: Fictional performance reviews show an average price markdown of 22% across mid-market and enterprise deals closed over the last two quarters.
Likely Cause: Reps lack a structured value argument and resort to quick price drops to hit monthly quotas, rather than aligning our solution to the buyer’s operational costs.
Revenue Impact: $240k ARR in lost margin annually.
Confidence Level: High (Verified via historical CRM booking reports).

Finding 2: Onboarding Stagnation & Delayed Implementation (Time-to-Value Leakage)

Evidence: 34% of signed accounts require more than 45 days to complete active API database integrations, far exceeding our 30-day target timeline.
Likely Cause: Account Executives do not document the buyer’s target ERP infrastructure or data schemas during the sales cycle, forcing implementation engineers to run duplicate discovery.
Revenue Impact: Delays subscription activation schedules and creates early churn risks.
Confidence Level: High (Confirmed by onboarding logs and customer support queues).

Finding 3: High-Intent Speed-to-Lead Drop-Off (Acquisition Leakage)

Evidence: 18% of qualified inbound demo requests are not contacted within the required business-hour windows.
Likely Cause: Inbound leads are routed into a single account management queue rather than being distributed via an automated round-robin to active reps.
Revenue Impact: Estimated $120k ARR in lost pipeline value due to prospects engaging with faster competitors.
Confidence Level: Medium (Suspected based on website form timestamps vs. first logged rep activity logs).

4. Leakage Categories

Journey Phase	Primary Failure Mechanism	Operational Impact
Acquisition & Routing	Sloppy inbound lead assignments and slow response times.	Reduces top-of-funnel pipeline yield.
Pipeline & Technical	Deals stall in mid-funnel stages because reps do not qualify technical requirements early.	Extends the average sales cycle out to 75 days.
Pricing & Closing	Reps use manual discounts to push through month-end deals.	Erodes contract values and lowers gross margins.
Onboarding & Expansion	Poor data transfer during post-sale handoffs.	Delays implementation and reduces first-year net revenue retention.

5. Quantification Table

Identified Leakage Point	Estimated Annual ARR Loss	Required CRM Field Validation	Recovery Potential
Late-Stage Concessions	$240,000	Enforce manager approval for discounts over 10%.	Recover 50% ($120k ARR) within 60 days.
Onboarding Bottlenecks	$280,000	Make the Target ERP Infrastructure field mandatory before closing.	Accelerate implementation times by 30%.
Inbound SLA Breaches	$120,000	Track the time delta between lead creation and first outbound activity.	Recover $60k ARR in saved opportunities.

6. Root Cause Analysis

Process Flaw: Sales stages are tracked based on rep actions (“Proposal Sent”) rather than verifiable milestones showing buyer commitment.
People & Enablement: Reps lack training on value-based negotiation, causing them to rely on discounting to overcome late-stage objections.
Data & Governance: The CRM …

When to reuse this workflow

Forecast Risk Assessment

Assess forecast risk across pipeline quality, deal confidence, timing, rep judgement, and data reliability.

Sales, Revenue Operations

Revenue Growth Constraint Analysis

Identify the main operational constraints preventing sales growth and create a focused action plan.

Sales, Revenue Operations

Sales Activity Effectiveness Analysis

Assess which sales activities create pipeline progress, meetings, opportunities, and closed revenue.

Unlock the full library.

Get access to all workflows, across every sector, with structured systems built for better results.