maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Fan-out producing (subscription × period_month) rows from started_month through exit_month (cancelled_at or today, whichever is earlier). `period_status` is `active` for every month before cancellation; the cancellation month + onward carry the terminal status (`cancelled` / `expired`). This keeps MRR (`sumIf(monthly_amount, period_status='active')`) correct — a sub cancelled mid-month does NOT contribute MRR that month.
12 of 12
Column
Description
Tests · PII
subscription_id
From staging.
product_id
From staging.
plan_name
From staging.
monthly_amount
From staging. Already monthly-normalised on the source.
cancelled_at
From staging. Null for live subs.
terminal_status
From `stg_postgres__subscriptions.status` — the subscription's overall lifecycle state.
started_month
`toStartOfMonth(started_at)`. Cohort key.
period_month
The month this row represents. Sorts ascending from started_month.
period_status
This-month status — `active` until cancellation; `cancelled` / `expired` thereafter.
is_churned_in_period
Derived — true only in the exact month of cancellation. Summable across months without double-counting.
is_new_in_period
Derived — true only in the start month.