KPI Tree

Stripe Metric

Revenue

Net Subscription Change MRR = Upgrade MRR + Quantity Increase MRR - Downgrade MRR - Quantity Decrease MRR - Cancelled MRR

Subscription Change Analysis measures the volume and revenue impact of changes to Stripe subscriptions over a period, broken down into upgrades, downgrades, quantity changes, interval switches and cancellations. It reads Stripe subscription and subscription_item events to classify each change and attach the monthly recurring revenue it added or removed. The result is a clear view of whether plan movement across your customer base is net expansionary or net contractionary.

Full guide: definition, formula, and benchmarks
StripeRevenue

Subscription Change Analysis

Subscription Change Analysis measures the volume and revenue impact of changes to Stripe subscriptions over a period, broken down into upgrades, downgrades, quantity changes, interval switches and cancellations. It reads Stripe subscription and subscription_item events to classify each change and attach the monthly recurring revenue it added or removed. The result is a clear view of whether plan movement across your customer base is net expansionary or net contractionary.

How to calculate subscription change analysis

Net Subscription Change MRR = Upgrade MRR + Quantity Increase MRR - Downgrade MRR - Quantity Decrease MRR - Cancelled MRR

Why subscription change analysis matters for Stripe users

A single recurring revenue figure hides the forces underneath it. Two months with identical MRR growth can have very different health if one is driven by new logos masking heavy downgrades and the other by genuine expansion within the existing base. Reading Stripe subscription changes directly tells you which it is.

For a team running billing on Stripe, this analysis shows whether your pricing and packaging are pushing customers up or down. It surfaces silent contraction, such as seat reductions or interval downgrades, before it shows up as churned revenue, and it confirms whether expansion plays are actually landing in the data.

Understand and act on subscription change analysis with KPI Tree

Sync your Stripe subscription and invoice data into your warehouse and compute Subscription Change Analysis in KPI Tree, classifying each subscription event and attaching its MRR delta. Place it in a metric tree alongside customer lifetime value and cohort revenue analysis so plan movement is read in the context of the revenue it drives over time.

Assign RACI ownership to a revenue or finance lead so one person is accountable for explaining net movement each month, and set a monthly review cadence in KPI Tree tied to your billing close. Trends in upgrades versus downgrades then feed pricing and retention decisions rather than sitting unread in Stripe.

Get started with your Stripe data

Query using MCP
MCP

Pull metrics from Stripe directly through the Model Context Protocol.

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Stripe data already lands.

Professional Services
FivetranSnowflakedbt

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

Explore subscription change analysis across integrations

Empower your team to understand and act on Stripe data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business