Net Revenue Retention Bridge Analysis Builder
Analyze net revenue retention with expansion, contraction, churn, reactivation, cohort movement, account segments, and executive-ready bridge commentary.
Prompt Template
You are a SaaS revenue analytics lead. Build a net revenue retention bridge analysis for: Business model: [SaaS, usage-based, subscription plus services, marketplace subscription] Time period: [month, quarter, year] Customer cohort definition: [starting customers, logo cohort, paid accounts, enterprise accounts] Revenue metric: [ARR, MRR, committed ARR, run-rate revenue, usage revenue] Available fields: [account ID, segment, plan, start ARR, end ARR, expansion, contraction, churn, reactivation, industry, region, CSM owner] Segmentation needs: [SMB/mid-market/enterprise, product line, acquisition channel, geography, tenure] Known issues: [late invoices, billing migrations, one-time credits, currency changes, usage spikes] Audience: [CEO, board, finance, sales, customer success, product] Decision needed: [forecast, churn reduction, expansion strategy, packaging change, CSM coverage] Produce: 1. NRR formula and inclusion/exclusion rules 2. Data cleaning and reconciliation checklist 3. Revenue bridge from opening ARR/MRR to closing ARR/MRR 4. Expansion, contraction, churn, and reactivation breakdown 5. Segment/cohort comparison table 6. Top account movement analysis with reasons 7. Driver narrative for executive reporting 8. Visualization recommendations for bridge chart and heatmap 9. Actions for customer success, sales, product, and finance 10. Caveats and data quality flags
Example Output
Opening ARR: €10.0M. Expansion: +€1.2M. Contraction: -€0.4M. Churn: -€0.7M. Reactivation: +€0.1M. Ending retained ARR: €10.2M. NRR: 102%.
Driver note: Enterprise NRR was 118% due to seat expansion, while SMB NRR fell to 84% from price-sensitive downgrades and onboarding-related churn in month two.
Tips for Best Results
- 💡Define whether reactivation belongs inside or outside NRR before analysis to avoid board confusion.
- 💡Provide account-level movement reasons if you want a useful executive narrative.
- 💡Ask for both logo retention and revenue retention when churn is concentrated in small accounts.
Related Prompts
Cohort Retention Analysis Explainer
Interpret your cohort retention data to understand user behavior, identify drop-off patterns, and improve retention strategies.
Revenue Forecasting Model Builder
Build a structured revenue forecast with multiple scenarios, key assumptions, and sensitivity analysis to predict and plan for future growth.
Feature Cannibalization Impact Analysis
Analyze whether a new product feature is stealing usage, revenue, or engagement from existing features and recommend product or packaging actions.