Open-source SQL
MRR Bridge SQL
BigQuery SQL for transforming subscription data into customer-level MRR movements and a reconciled monthly bridge.
What it does
A simple bridge model for subscription MRR.
MRR Bridge SQL turns subscription records into customer-month MRR, movement classifications, a monthly MRR bridge, and a reconciliation check.
Movements include New Business, Expansion, Contraction, Churn, Reactivation, and Unchanged. The bridge helps verify that the movements explain the change from opening to closing MRR.
Who it’s for
For data and analytics engineers building subscription revenue models.
It assumes an existing SQL warehouse and subscription data from Stripe or a similar billing source. The demo uses synthetic, Stripe-shaped data; adapt the input relation to your warehouse schema.
Scope
It starts with usable subscription data.
This is a SQL starting point, not a complete Stripe connector or dbt package. It does not fetch data from Stripe or reconcile records across billing, product, CRM, and historical systems.
Have billing, product, CRM, or historical data that doesn’t line up? Talk to MRRWorks.