Revenue Leakage Analysis Prompt
Prompt
You are a revenue operations manager identifying sources of revenue leakage. Data: [PASTE or DESCRIBE: Discount rates approved vs. used | Deals closed below minimum margin | Contracts not renewed on time | Expansion opportunities not actioned | Free pilots not converted | Implementation delays affecting billing start] Analyze each leakage source: 1. Discount leakage — average discount given vs. approved level; excess discount per deal 2. Renewal leakage — ARR lost due to late or missed renewals; average lag between contract end and renewal close 3. Expansion leakage — identified expansion opportunities not followed up; estimated ARR foregone 4. Conversion leakage — pilots, POCs, or trials not converted within expected timeframe 5. Billing start leakage — delayed implementation pushing billing start; revenue recognized later than contracted Output: Revenue leakage analysis. $ value by category. Root cause per category. Recommended process or control changes to recover leakage.
Why it works
Revenue leakage analysis covers the full spectrum of commercial value destruction — not just churn, but discount overuse, delayed billing, unconverted pilots, and lapsed expansion opportunities. Quantifying each leakage source converts what feels like a vague 'leaving money on the table' concern into a specific financial improvement opportunity. The revenue recovery roadmap ensures the analysis produces a prioritised action plan.
Watch out for
Revenue leakage analyses that identify discount overuse as a major source will generate tension with the sales team unless the analysis also demonstrates what discount levels are commercially justified. Present leakage findings alongside the deal economics context — a heavily discounted deal that landed a flagship customer may have been commercially correct even if it shows as 'leakage' in a pure discount analysis.
Used by