maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Per-month rollup of subscription state from the exploding intermediate. `mrr` is `sumIf(monthly_amount, period_status='active')` — annual plans contribute their monthly-normalised value (the source already amortises). New starts and churned events fire only in their exact month, so summing across months is safe.
What it means
Watch out for
- highMultiplying `monthly_amount` by 12 for annual plans
`monthly_amount` is already normalised at the source — annual plans store the per-month value. Sum directly for MRR; multiply only when computing ARR explicitly.
- highCounting `active_subscriptions` across period_status
`active_subscriptions` is a row count in the (period_month, plan_name, period_status) bucket — to count truly-active subs in a month, filter `period_status='active'` first.
Questions this answers
- “MRR by plan over the last 6 months.”
- “Monthly churn rate this year.”
Related metrics
- revenue
MRR is the recurring-revenue subset of total revenue.
- customer_health
Subscription churn signals customer churn.
References
8 of 8
Column
Type
Description
Tests · PII
period_month
Date
Start-of-month for this row. Sort + partition key.
1 test
plan_name
String
`monthly` / `quarterly` / `annual`.
1 test
period_status
String
This-month status — `active` / `cancelled` / `expired` / `paused`.
1 test
active_subscriptions
UInt64
Row count of (subscription × month) pairs in the bucket.
2 tests
unique_customers
UInt64
Distinct customer_id count.
1 test
mrr
Decimal(14, 2)
Sum of `monthly_amount` filtered to period_status='active'. Decimal(14,2).
2 tests
new_subscriptions
UInt64
Count of subs that started in this month. Fires once per sub.
1 test
churned_subscriptions
UInt64
Count of subs that cancelled in this month. Fires once per sub.
1 test