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. BQS 12/12 certified.
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
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
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
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.
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
The Complete Customer Success Bundle
6 files. Main workflow + scheduler + prompts + docs.
Tested. Measured. Documented.
Monthly MRR waterfall analysis with 5 movement buckets, concentration risk, churn pattern identification, and trajectory projection delivered via Notion and Slack.
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:
- ✓Production-ready 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. Churn counts canceled subscription MRR. Reactivation measures MRR from returning customers who previously churned. Together they form the MRR waterfall.
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. Quarterly and other intervals are similarly normalized.
Is there a refund policy?+
All sales are final after download. Review the Blueprint Dependency Matrix and prerequisites before purchase. Questions? Contact support@forgeworkflows.com before buying. Full terms at forgeworkflows.com/legal.
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.