franticnarwhal

[graceful geyser]

We don't have a SQL snippet for that unfortunately and I'm not sure of any plans to add that to Sigma. Have you already looked at this doc on how MRR is calculated?

https://support.stripe.com/questions/understanding-monthly-recurring-revenue-(mrr)

[wispy wind]

@frank urchin If you have any more questions about MRR and how the Dashboard calculates this, I recommend reaching out to our Support team: https://support.stripe.com/contact/

[frank urchin]

I have seen that thread, thanks. The trickiest thing for me atm is the logic used to label customers as churned.

For example, if i go to the billing dashboard and download the "MRR per subscriber per Month" report (which is super helpful btw) and i count up the number of customers by "Customer End Date" it doesn't equal the churn numbers in the "Active subscriber growth chart".

So I can't even get the report from the billing dashboard to match the chart on the billing dashboard. Sometimes the two numbers are off by ~30%. And the MRR report is consistently lower than the chart on the dashboard.

The articles on MRR are awesome and very helpful for understanding qualitatively what's going on. But I can't find anything in the docs that would explain why the "Customer End Date" in the "MRR per subscriber per Month" report would differ so much from the "churn" count in the "Active subscriber growth chart". Any more help would be awesome.

[wispy wind]

We're not MRR calculation experts here, unfortunately.