Per-subscription net changes between adjacent captured daily snapshots, with both snapshots calculated under the same CURRENT workspace settings. No movement for the baseline; settings changes alone are not growth. This is a comparison of observed balances, not an exact provider-event ledger or intraday chronology. movement is new, reactivation, expansion, contraction, churn, pause, eligibility_change, currency_change, coverage_change, unknown or unchanged. A late import of an old subscription is coverage_change, never new; disappearance alone is not churn. currency_change, coverage_change and unknown have NULL change_minor; do not coalesce them into measured growth. Comparable changes retain signed change_minor and same-currency units. reason explains the classification. previous_observed_at/observed_at disclose the actual interval and any missing days. Keep provider/connection/currency separate and expose unknown comparisons when aggregating.
- daydate
- observed_attimestamp
- previous_observed_attimestamp
- providertext
- connection_iduuid
- subscription_idtext
- currencytext
- previous_currencytext
- previous_mrr_minorbigint
- mrr_minorbigint
- change_minorbigint
- movementtext
- reasontext
- settings_versionint