Subscription Movements Daily Explore
Overview
Daily summary of subscription changes + estimated revenue impact.
- Grain: movement type per day
When to use
- Quantify revenue impact
- Monitor operational changes
- Investigate anomalies
Key dimensions & metrics
Field | Description |
|---|---|
Report Date | Date |
Movement Type | created, cancelled, etc. |
Movement Category | status / quantity / price |
Subscription Count | Distinct subs |
Customer Count | Distinct customers |
Event Count | Raw events |
Revenue Impact Estimate | Estimated impact |
Avg Order Value Affected | AOV |
Revenue Impact Is Estimated | Always yes |
Revenue Impact Method | Calculation logic |
Example business questions
- Revenue lost from cancellations
- Movement comparison (volume + impact)
- Day-of-week trends
- Reactivation recovery
Notes & caveats
- Revenue is estimated, not contractual
- Subscriptions without orders → NULL impact
Glossary
Term | What it Means | How to Interpret / Use | Where You’ll See It in Looker |
|---|---|---|---|
Active Subscription | A subscription that is currently ongoing. Includes both fully active and paused subscriptions. | Use this to understand the current size of your subscriber base. Note that paused users are still counted. | Subscription Metrics Daily (Active Count), Subscriber Journey (Is Active Subscriber), Subscriber Journey Monthly (Is Active Subscriber EOM), Product & Bundle Explores (Active Subscription Count) |
Churn / Churned | A subscription that has been cancelled. Does not include pauses. | Represents true customer loss. Track this to understand retention issues. | Subscription Metrics Daily (Churned Count, Churn Rate), Subscriber Journey (Is Churned, Churn Count), Monthly (Is Churned EOM, Cancellations This Month), Events Enriched (Event Type = canceled), Movements (status_cancelled) |
Winback | A subscriber who cancelled all subscriptions and later returned by subscribing again. | Indicates successful re-engagement after churn. | Subscriber Journey (Is Winback), Subscriber Journey Monthly (Has Reactivated By EOM) |
Reactivation | A previously cancelled subscription that becomes active again (subscription-level). | Measures recovery of churned subscriptions. | Subscription Metrics Daily (Reactivated Count), Movements (status_reactivated), Events Enriched (Event Type = reactivated) |
Net New | Net change in subscriptions: New + Reactivated − Cancelled. | Indicates overall growth vs decline. | Subscription Metrics Daily (Net New Count) |
LTV (Lifetime Value) | Total revenue generated by a subscriber across all subscription orders. | Use to understand customer value over time and compare cohorts or segments. | Subscriber Journey (LTV Gross / Net Revenue), Subscriber Journey Monthly (LTV Gross Revenue EOM) |
EOM (End of Month) | Metrics calculated as of the last day of a month. | Used for consistent month-over-month comparisons (retention, LTV growth). | Subscriber Journey Monthly (all EOM fields like Active EOM, LTV EOM) |
Solo Subscription | A subscription that contains only one product. | Helps identify products that perform well individually. | Subscription Product Metrics Daily (Solo Subscription Count) |
Bundle | A subscription that contains two or more products. | Useful for analyzing product combinations and cross-sell behavior. | Product Metrics (Bundle Subscription Count), Bundle Metrics Daily (all bundle fields) |
Movement | Any change in a subscription’s state (created, cancelled, paused, resumed, reactivated, quantity/price change). | Use to understand operational changes and trends in subscriptions. | Subscription Movements Daily (Movement Type, Category), Events Enriched (Event Type) |
Provider | The system managing subscriptions (Recharge, ChordOMS, CustomOMS). | Important context — data availability and detail vary by provider, which affects analysis. | All Explores (Provider filter present everywhere) |