KPI Tree

Stripe Metric

Revenue

Churn Rate = Subscriptions Cancelled in Period / Active Subscriptions at Start of Period x 100

Churn Rate measures the proportion of active Stripe subscriptions that cancel or lapse within a given period. In Stripe terms it is derived from subscription status transitions, where a subscription moving to canceled or unpaid counts as churn against the base of subscriptions that were active at the start of the period. It can be expressed as customer churn, counting lost subscribers, or as revenue churn, weighting each loss by its monthly recurring revenue.

Full guide: definition, formula, and benchmarks
StripeRevenue

Churn Rate

Churn Rate measures the proportion of active Stripe subscriptions that cancel or lapse within a given period. In Stripe terms it is derived from subscription status transitions, where a subscription moving to canceled or unpaid counts as churn against the base of subscriptions that were active at the start of the period. It can be expressed as customer churn, counting lost subscribers, or as revenue churn, weighting each loss by its monthly recurring revenue.

How to calculate churn rate

Churn Rate = Subscriptions Cancelled in Period / Active Subscriptions at Start of Period x 100

Why churn rate matters for Stripe users

Churn is the single biggest drag on recurring revenue growth. Every percentage point of monthly churn compounds, so a subscription business losing customers faster than it acquires them will stall no matter how strong the top of the funnel looks. Reading churn straight from Stripe Billing gives you the true picture, grounded in real cancellations and failed payments rather than estimates.

Stripe data also lets you separate voluntary churn, where a customer chooses to cancel, from involuntary churn caused by declined cards and failed renewals. That distinction matters because involuntary churn is often recoverable through better dunning and retry logic, so tracking the two together tells the team where to focus retention effort.

Understand and act on churn rate with KPI Tree

Sync your Stripe subscription and invoice data into your warehouse and compute Churn Rate in KPI Tree, splitting it into customer churn and revenue churn so each tells its own story. Place it inside a metric tree alongside customer lifetime value and card decline rate so you can see how lost subscriptions and failed payments feed the wider revenue picture.

Assign RACI ownership so a named retention or revenue lead is accountable for the number, with finance and product as consulted parties, and set a monthly review cadence in KPI Tree to catch upticks early. Tie any spike to a task and an owner so the team is acting on churn rather than just watching it climb.

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.

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