MRR and churned MRR from a Stripe subscriptions export

What a subscriptions export can and can't tell you

The export is a snapshot: one row per subscription, with its price, quantity and status today. That's enough for MRR now, for new MRR by the month a subscription started, and for churned MRR by the month it ended. It can't show expansion or contraction, because a subscription that moved from Team to Business appears once, at Business. For upgrades and downgrades, use Stripe's Customer MRR changes report (Billing overview > Report downloads) or your invoices.

The Kept column compares each month's new MRR with what those subscriptions still bring in. A month whose new MRR is mostly gone is a cohort to look at; for customer counts month by month, see cohort retention from the payments export.

Export subscriptions from the Stripe Dashboard

1. In the Stripe Dashboard, open Billing > Subscriptions.
2. Click Export and download the CSV. Include canceled subscriptions: without them there is no churn to count.
3. Drop it in the box above.

Stripe documents the subscription fields and statuses in its API reference and the MRR definition in its Billing analytics docs, checked 2026-10-18. It doesn't publish the export's column headers. The sample uses headers typical of the export (Customer ID, Product, Quantity, Interval, Amount, Status, Created (UTC), Ended At (UTC)); if yours differ, match them in the box.

The Tableau calculation

MRR now

No dimensions in the view: each calculation returns one number for the whole file.

// Monthly value
CASE [Interval] WHEN 'year' THEN [Amount] * [Quantity] / 12 WHEN 'week' THEN [Amount] * [Quantity] * 52 / 12 WHEN 'day' THEN [Amount] * [Quantity] * 365 / 12 ELSE [Amount] * [Quantity] END

// In MRR
[Status] = 'active' OR [Status] = 'past_due'

// MRR
SUM(IF [In MRR] THEN [Monthly value] ELSE 0 END)

// ARR (MRR x 12)
SUM(IF [In MRR] THEN [Monthly value] ELSE 0 END) * 12

// Paying customers
COUNTD(IF [In MRR] THEN [Customer ID] END)

// MRR per customer
SUM(IF [In MRR] THEN [Monthly value] ELSE 0 END) / COUNTD(IF [In MRR] THEN [Customer ID] END)

MRR by product

On Rows: [Product]. Each calculation below is one column.

// Monthly value
CASE [Interval] WHEN 'year' THEN [Amount] * [Quantity] / 12 WHEN 'week' THEN [Amount] * [Quantity] * 52 / 12 WHEN 'day' THEN [Amount] * [Quantity] * 365 / 12 ELSE [Amount] * [Quantity] END

// In MRR
[Status] = 'active' OR [Status] = 'past_due'

// Subscriptions in MRR
COUNTD(IF [In MRR] THEN [id] END)

// MRR
SUM(IF [In MRR] THEN [Monthly value] ELSE 0 END)

// Share of MRR
SUM(IF [In MRR] THEN [Monthly value] ELSE 0 END) / MIN({ FIXED : SUM(IF [In MRR] THEN [Monthly value] ELSE 0 END) })

New MRR by start month, and how much is still in MRR

On Rows: DATETRUNC('month', [Created (UTC)]). Each calculation below is one column.

// Monthly value
CASE [Interval] WHEN 'year' THEN [Amount] * [Quantity] / 12 WHEN 'week' THEN [Amount] * [Quantity] * 52 / 12 WHEN 'day' THEN [Amount] * [Quantity] * 365 / 12 ELSE [Amount] * [Quantity] END

// In MRR
[Status] = 'active' OR [Status] = 'past_due'

// Started paying
[Status] <> 'trialing' AND [Status] <> 'incomplete' AND [Status] <> 'incomplete_expired' AND [Status] <> 'paused'

// New paying subscriptions
COUNTD(IF [Started paying] THEN [id] END)

// New MRR
SUM(IF [Started paying] THEN [Monthly value] ELSE 0 END)

// Still in MRR
SUM(IF [In MRR] THEN [Monthly value] ELSE 0 END)

// Share of new MRR still in MRR
SUM(IF [In MRR] THEN [Monthly value] ELSE 0 END) / SUM(IF [Started paying] THEN [Monthly value] ELSE 0 END)

Churned MRR by the month a subscription ended

On Rows: IF [Status] = 'canceled' THEN DATETRUNC('month', [Ended At (UTC)]) END. Each calculation below is one column.

// Monthly value
CASE [Interval] WHEN 'year' THEN [Amount] * [Quantity] / 12 WHEN 'week' THEN [Amount] * [Quantity] * 52 / 12 WHEN 'day' THEN [Amount] * [Quantity] * 365 / 12 ELSE [Amount] * [Quantity] END

// Canceled subscriptions
COUNTD([id])

// Churned MRR
SUM([Monthly value])

// Avg months before canceling
AVG(DATEDIFF('month', [Created (UTC)], [Ended At (UTC)]))

In Tableau the churn view shows a Null row for subscriptions that haven't been canceled; exclude it. The box above leaves it out.

The equivalent SQL

MRR now

WITH subs AS (
  SELECT *, CASE "Interval" WHEN 'year' THEN "Amount" * "Quantity" / 12
                       WHEN 'week' THEN "Amount" * "Quantity" * 52 / 12
                       WHEN 'day' THEN "Amount" * "Quantity" * 365 / 12
                       ELSE "Amount" * "Quantity" END AS monthly_value,
         "Status" IN ('active', 'past_due') AS in_mrr
  FROM read_csv('stripe-subscriptions.csv')
)
SELECT SUM(monthly_value) FILTER (WHERE in_mrr) AS mrr,
       SUM(monthly_value) FILTER (WHERE in_mrr) * 12 AS arr,
       COUNT(DISTINCT "Customer ID") FILTER (WHERE in_mrr) AS paying_customers,
       SUM(monthly_value) FILTER (WHERE in_mrr) / COUNT(DISTINCT "Customer ID") FILTER (WHERE in_mrr) AS mrr_per_customer
FROM subs;

MRR by product

WITH subs AS (
  SELECT *, CASE "Interval" WHEN 'year' THEN "Amount" * "Quantity" / 12
                       WHEN 'week' THEN "Amount" * "Quantity" * 52 / 12
                       WHEN 'day' THEN "Amount" * "Quantity" * 365 / 12
                       ELSE "Amount" * "Quantity" END AS monthly_value,
         "Status" IN ('active', 'past_due') AS in_mrr
  FROM read_csv('stripe-subscriptions.csv')
)
SELECT "Product",
       COUNT(DISTINCT id) FILTER (WHERE in_mrr) AS subscriptions_in_mrr,
       COALESCE(SUM(monthly_value) FILTER (WHERE in_mrr), 0) AS mrr,
       COALESCE(SUM(monthly_value) FILTER (WHERE in_mrr), 0) / (SELECT SUM(monthly_value) FROM subs WHERE in_mrr) AS share_of_mrr
FROM subs
GROUP BY "Product"
ORDER BY mrr DESC;

New MRR by start month, and how much is still in MRR

WITH subs AS (
  SELECT *, CASE "Interval" WHEN 'year' THEN "Amount" * "Quantity" / 12
                       WHEN 'week' THEN "Amount" * "Quantity" * 52 / 12
                       WHEN 'day' THEN "Amount" * "Quantity" * 365 / 12
                       ELSE "Amount" * "Quantity" END AS monthly_value,
         "Status" IN ('active', 'past_due') AS in_mrr,
         "Status" NOT IN ('trialing', 'incomplete', 'incomplete_expired', 'paused') AS started_paying
  FROM read_csv('stripe-subscriptions.csv')
)
SELECT date_trunc('month', CAST("Created (UTC)" AS DATE)) AS started,
       COUNT(DISTINCT id) FILTER (WHERE started_paying) AS new_subscriptions,
       COALESCE(SUM(monthly_value) FILTER (WHERE started_paying), 0) AS new_mrr,
       COALESCE(SUM(monthly_value) FILTER (WHERE in_mrr), 0) AS still_in_mrr,
       COALESCE(SUM(monthly_value) FILTER (WHERE in_mrr), 0) / NULLIF(SUM(monthly_value) FILTER (WHERE started_paying), 0) AS kept
FROM subs
GROUP BY started
ORDER BY started;

Churned MRR by the month a subscription ended

WITH subs AS (
  SELECT *, CASE "Interval" WHEN 'year' THEN "Amount" * "Quantity" / 12
                       WHEN 'week' THEN "Amount" * "Quantity" * 52 / 12
                       WHEN 'day' THEN "Amount" * "Quantity" * 365 / 12
                       ELSE "Amount" * "Quantity" END AS monthly_value,
         "Status" IN ('active', 'past_due') AS in_mrr
  FROM read_csv('stripe-subscriptions.csv')
)
SELECT date_trunc('month', CAST("Ended At (UTC)" AS DATE)) AS ended,
       COUNT(DISTINCT id) AS canceled_subscriptions,
       SUM(monthly_value) AS churned_mrr,
       AVG(date_diff('month', CAST("Created (UTC)" AS DATE), CAST("Ended At (UTC)" AS DATE))) AS avg_months_before_canceling
FROM subs
WHERE "Status" = 'canceled' AND "Ended At (UTC)" IS NOT NULL
GROUP BY ended
ORDER BY ended;

Traps in Stripe exports

• Cents or dollars. Dashboard exports show amounts in currency units (49.00). The API and Sigma store most currencies in the smallest unit (4900 cents), per Stripe's currency docs. If your MRR looks 100 times too big, divide [Amount] by 100.
• Plans billed every N months. The formula above handles month, year, week and day intervals with a count of 1. For a plan billed every 3 months, divide by 3 as well.
• Trials and incomplete subscriptions aren't in MRR, matching Stripe's definition. Stripe also leaves out taxes, free plans and metered prices; a subscriptions export has no tax column, but filter out free and metered prices if you have them.
• Discounts. Amount is the list price. Stripe's own MRR can subtract coupons depending on your Billing analytics settings, so its number can be lower than this one.
• Several currencies. Add [Currency] to the view, or convert before summing.

Stripe is a trademark of Stripe, Inc. xmetric is not affiliated with Stripe. The sample file is synthetic: made-up subscriptions using column names typical of the Dashboard's subscriptions export, statuses from Stripe's API reference, as of 2026-10-18.