KPI Tree

Stripe Metric

Revenue

Cohort Revenue Retention (period n) = Revenue from Cohort in Period n / Revenue from Cohort in Period 0 x 100

Revenue Cohort Analysis groups Stripe customers by the period in which they first paid, then follows the revenue each group generates in every period that follows. Using Stripe charge, invoice, and subscription data, it shows how much of a cohort revenue persists, expands, or churns months after acquisition. Each cohort becomes a row, and each later period becomes a column, so retention and expansion curves are visible at a glance.

Full guide: definition, formula, and benchmarks
StripeRevenue

Revenue Cohort Analysis

Revenue Cohort Analysis groups Stripe customers by the period in which they first paid, then follows the revenue each group generates in every period that follows. Using Stripe charge, invoice, and subscription data, it shows how much of a cohort revenue persists, expands, or churns months after acquisition. Each cohort becomes a row, and each later period becomes a column, so retention and expansion curves are visible at a glance.

How to calculate revenue cohort analysis

Cohort Revenue Retention (period n) = Revenue from Cohort in Period n / Revenue from Cohort in Period 0 x 100

Why revenue cohort analysis matters for Stripe users

A single revenue total hides whether new customers stick around or quietly drop off. By splitting Stripe revenue into acquisition cohorts, the team can see whether customers acquired in one month behave differently from those acquired later, and whether recent product or pricing changes are improving how long customers keep paying.

For subscription and usage based businesses on Stripe, cohort curves separate genuine growth from churn that is being masked by new sales. A cohort that expands over time signals strong product fit and pricing power, while a cohort that decays quickly points to onboarding, value, or retention problems worth fixing before more acquisition spend goes in.

Understand and act on revenue cohort analysis with KPI Tree

Sync your Stripe charges, invoices, and subscriptions into your warehouse and compute Revenue Cohort Analysis in KPI Tree, assigning each customer to a cohort by first payment date and rolling up revenue per period. Place the metric in a metric tree alongside customer lifetime value and average revenue per transaction so retention curves connect to the upstream and downstream drivers that move them.

Assign RACI ownership to a revenue or finance lead so one person is accountable for reading the cohort curves and acting on decay, and set a monthly review cadence in KPI Tree to track each new cohort as it matures. Reviewing cohorts on a fixed rhythm keeps retention trends visible before they reach headline revenue.

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