Stripe MRR Movement Intelligence
AI-powered monthly MRR waterfall analysis — New, Expansion, Contraction, Churn, and Reactivation buckets with AI narrative, concentration risk, churn patterns, and trajectory projection.
Decomposes Stripe subscription movements into a 5-bucket MRR waterfall (New + Expansion + Reactivation - Contraction - Churn = Net). Identifies top movers per bucket, concentration risk, churn patterns by plan/cohort, expansion drivers, and projects next-month trajectory. Alerts on net negative months and churn > expansion. Notion monthly MRR report + Slack executive waterfall. 28-node n8n workflow with monthly scheduler. Blueprint Quality Standard (BQS) 12/12 certified. We built this after a board meeting where the CEO asked why MRR dropped $6K and nobody could decompose the number into new, expansion, contraction, and churn within the meeting. The agent delivers that decomposition automatically.
Last updated March 18, 2026
Cash flow is the primary cause of small business failure, yet most companies forecast using spreadsheets updated weekly at best. MRR movements — upgrades, downgrades, churn, new business — happen daily. Automated financial intelligence surfaces cash flow trends and MRR shifts as they occur.
Four Agents. Monthly MRR Waterfall. Revenue Narrative.
Step 1 — The Fetcher
Code-only
Retrieves subscription-level event data from Stripe API for the current and prior months — subscription created, updated, canceled, and reactivated events, invoice amounts, customer metadata, plan details, and discount codes. Pulls historical MRR snapshots for waterfall construction.
Step 2 — The Assembler
Code-only
What does The Assembler actually decide? Constructs the MRR waterfall across 5 movement buckets: New (first-time subscriptions), Expansion (plan upgrades and seat additions), Contraction (downgrades and seat removals), Churn (canceled subscriptions), and Reactivation (returning customers). Computes concentration risk, churn patterns by cohort, and trajectory projection.
Step 3 — The Analyst
Tier 2 Classification
This step exists because raw data alone is not enough. Analyzes MRR movements for revenue narrative: what drove growth or contraction, which customer segments contribute most to each bucket, concentration risk from top accounts, churn pattern identification (voluntary vs. involuntary, early vs. mature), and 3-month trajectory projection based on current trends.
Step 4 — The Formatter
Tier 3 Creative
Without this step, upstream analysis sits idle. Generates a Notion monthly MRR intelligence report with waterfall visualization data, bucket breakdowns, concentration analysis, churn patterns, and trajectory projection, plus a Slack digest with MRR movement summary and top 3 revenue actions.When Anthropic releases a new model, the customer changes one value. Every blueprint uses a Config Loader node — one configuration point.
That's the full pipeline. Here's what it intentionally does NOT do — and why those boundaries exist.
What It Does NOT Do
Does not modify subscriptions or invoices in Stripe — read-only analysis of subscription events
Does not replace financial reporting tools — it adds movement intelligence and concentration analysis
Does not forecast exact MRR numbers — trajectory projection is trend-based, not predictive modeling
Does not handle non-subscription revenue — one-time charges and usage-based billing are excluded
Does not send dunning emails — use Stripe Dunning Intelligence (#29) for failed payment recovery
With those boundaries clear, here's everything that ships when you purchase.
The Complete Customer Success Bundle
7 files.
The technical specifications below are ITP-measured, not estimated.
Tested. Measured. Documented.
Monthly MRR waterfall analysis with 5 movement buckets, concentration risk, churn pattern identification, and trajectory projection delivered via Notion and Slack.
Tested on n8n v2.7.5, March 2026
Stripe MRR Movement Intelligence v1.0.0──────────────────────────────────────────Nodes: 28 main + 3 scheduler (31 total)Agents: 4 (Fetcher, Assembler, Analyst, Formatter)LLM Calls: 2 per run (Analyst + Formatter)Model: Sonnet 4.6 (SINGLE-MODEL)Trigger: Schedule (monthly 2nd 9:00 UTC) + WebhookPattern: BATCH (monthly MRR waterfall analysis)Tool A: Stripe (API key) — subscription events, invoices, customer dataTool B: Notion (httpHeaderAuth) — monthly MRR intelligence reportTool C: Slack (httpHeaderAuth) — digest with MRR movement summaryITP: 8/8 records, 14/14 milestonesBQS: 12/12 PASSCost: $0.05–$0.10 per run
What You'll Need
Platform
n8n 2.7.5+
Est. Monthly API Cost
Monthly cost ~$0.05-0.10/run
Credentials Required
- ▪Anthropic API
- ▪Stripe (API key, secret key)
- ▪Slack (Bot Token, httpHeaderAuth Bearer)
- ▪Notion (httpHeaderAuth Bearer)
Services
- ▪Stripe account with subscription billing
- ▪Anthropic API key
- ▪Notion workspace
- ▪Slack workspace (Bot Token with chat:write)
Setup Track
Quick Start
~15 min
All credentials live, n8n running
Full Setup
1–2 hrs
Needs API config + tables
From Scratch
2–4 hrs
No n8n, no credentials
Stripe MRR Movement Intelligence v1.0.0
$299
one-time purchase
What you get:
- ✓ITP-tested n8n workflow (28 nodes + 3-node scheduler)
- ✓5-bucket MRR waterfall (New, Expansion, Contraction, Churn, Reactivation)
- ✓Concentration risk analysis from top accounts contributing to each bucket
- ✓Churn pattern identification (voluntary vs. involuntary, early vs. mature cohorts)
- ✓Expansion driver analysis showing which plan upgrades and seat additions contribute most
- ✓3-month MRR trajectory projection based on current movement trends
- ✓Customer segment breakdown per waterfall bucket
- ✓Notion monthly MRR intelligence report with waterfall data and revenue narrative
- ✓Slack digest with MRR movement summary and top 3 revenue actions
- ✓Configurable: plan grouping, concentration thresholds, cohort definitions, lookback period
- ✓Full technical documentation and system prompts
Frequently Asked Questions
What are the 5 MRR movement buckets?+
New captures first-time subscription MRR. Expansion tracks plan upgrades and seat additions. Contraction covers downgrades and seat removals.
How is concentration risk calculated?+
The Assembler computes top-account contribution to each bucket. If a single customer accounts for more than the configurable threshold (default 20%) of New or Expansion MRR, that bucket is flagged for concentration risk. Same applies to Churn — if one cancellation drives most of the churn.
Does it handle annual subscriptions?+
Yes. The Fetcher normalizes all subscription amounts to monthly equivalent values. Annual subscriptions are divided by 12 for MRR calculations.
Is there a refund policy?+
All sales are final after download. Review the Blueprint Dependency Matrix and prerequisites before purchase. Questions?
Related Blueprints
Stripe Dunning Intelligence
Intelligent payment recovery with AI-personalized dunning.
Stripe Discount Effectiveness Analyzer v1.0.0
Monthly AI analysis of your Stripe coupon and discount performance — measures redemption volume, retention impact at 30/60/90 days, upgrade rates, and revenue per customer with KEEP/MODIFY/KILL recommendations.
Stripe Plan Migration Intelligence
AI-powered subscription change analysis that classifies plan migrations, identifies the likely driver, and generates talking points for your CS team — triggered instantly when customers upgrade, downgrade, or switch plans.