AI Skills Marketplace / Customer Success

Renewal & Expansion Revenue Waterfall Analyzer

The Renewal & Expansion Revenue Waterfall Analyzer is a free Claude Skill that builds a real ARR waterfall bridge from account-level previous versus current ARR and computes Net Revenue Retention and Gross Revenue Retention using their correct, distinct SaaS metric definitions.

↗ View Source ⬇ Download Full Repo (.zip)
MIT
License
2 functions
Decision branches
correct NRR/GRR definitions + zero-revenue-base guardrail
Escalation rules
Yes
Multi-tool support
Aug 17, 2026
Last updated
19/19 passing
Tests
README.md View raw ↗

What this is (and isn’t)

A revenue-bridge and retention-metric engine, not a live billing integration. You supply each account’s previous and current ARR; this deterministically classifies every account and computes the two most commonly confused SaaS metrics correctly.

Files

FilePurpose
waterfall.jsclassifyAccountChange(), buildRevenueWaterfall() — zero dependencies
test.js19-test suite, hand-verified against a known 5-account waterfall example including exact NRR/GRR values
SKILL.mdFull skill definition, loadable in Claude Code/Desktop

The two real guardrails

One deterministic classification rule per account (new, expansion, contraction, churned, flat), removing analyst-to-analyst inconsistency. And NRR and GRR use their correct, distinct definitions: NRR credits expansion and can legitimately exceed 100 percent, GRR excludes expansion entirely and can never exceed 100 percent by construction. Conflating the two makes retention look better than it is.

FAQ

Is this skill free to use?

Yes. Free to download and run yourself. MV3 charges $175/hr only for implementation help wiring this into your real billing platform's actual ARR and subscription data.

Does this connect directly to my billing platform?

No. It is a pure function over the account ARR data you supply. You still need to pull previous and current ARR out of your billing system and feed it in yourself.

What is the difference between NRR and GRR?

NRR includes expansion revenue and can legitimately exceed 100 percent. GRR excludes expansion entirely and, by construction, can never exceed 100 percent. Confusing the two is a common real mistake that makes retention look better than it actually is.

What happens if every account in the set is a new logo?

The function throws rather than returning a misleading NRR or GRR, since there is no existing revenue base to measure retention against. New-logo ARR should be reported separately in that case.

Does my revenue data get sent to MV3?

No. All calculations run entirely in your own environment.

JR
Jordan Reeves
ABM & Outbound Pipeline, MV3 Marketing