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.