Analyst SaaS Metrics
Computes deterministic MRR/ARR bridges, MRR waterfalls, NRR percentages, validation checks, and markdown table exports from user-supplied inputs without external billing APIs. SaaS finance analysts and data teams use it to derive accurate revenue metrics from spreadsheets or CSV data for cohort analysis and forecasting.
Overview
Analyst SaaS Metrics is an MCP server that processes analyst-provided data to generate precise SaaS revenue calculations. It handles MRR/ARR bridges, waterfalls, net revenue retention (NRR), and validation, outputting results in markdown tables. Designed as an MVP, it operates solely on supplied inputs, avoiding dependencies on billing systems.
Key Capabilities
- MRR/ARR Bridges: Converts monthly recurring revenue (MRR) to annual recurring revenue (ARR) using deterministic formulas, accounting for expansion, contraction, and churn.
- MRR Waterfalls: Breaks down MRR changes over time into components like new business, upsells, downgrades, and cancellations.
- NRR% Calculation: Computes net revenue retention percentage from cohort data, measuring revenue growth from existing customers.
- Validation Checks: Verifies input data consistency, flagging anomalies in customer counts, revenue figures, or churn rates.
- Markdown Table Export: Formats all outputs as copy-pasteable markdown tables for reports or documentation.
Use Cases
- Cohort Revenue Analysis: Upload customer revenue data; generate MRR waterfalls to visualize quarterly churn impact and NRR% for board reports.
- Forecasting Bridges: Input projected MRR; compute MRR/ARR bridges to model annual targets without billing API access.
- Data Validation: Run validation checks on exported billing CSVs to ensure MRR integrity before investor updates.
- Report Generation: Process historical data for markdown table exports integrated into Notion or GitHub READMEs.
Who This Is For
SaaS finance analysts, revenue operations teams, and data scientists who manage metrics manually. Useful for startups without integrated billing tools, enabling quick computations from Excel or Airtable exports.