Subscription Bundle Metrics Daily Explore
Overview
Bundle-level performance (multi-product subscriptions).
- Grain: bundle combination per day
When to use
- Identify top bundle combinations
- Compare bundle churn rates
- Analyze AOV by bundle
Key dimensions & metrics
Field | Description |
|---|---|
Report Date | Date |
Bundle Key | Unique combo |
Product Titles | Included products |
Product Count | Number of products |
Is Large Bundle | >4 products |
Active Subscription Count | Active subs |
New Subscription Count | New subs |
Churned Subscription Count | Cancelled subs |
Bundle Churn Rate | Churn rate |
Avg Order Value | AOV |
Bundle Rank by Active Count | Popularity |
Notes & caveats
- Large bundles (5+) grouped into LARGE_BUNDLE
- Single-product subscriptions excluded
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) |