Subscription Product Metrics Daily Explore
Overview
Product-level subscription performance.
- Grain: product per day
When to use
- Identify high-churn products
- Track product growth/decline
- Analyze bundle vs solo usage
Key dimensions & metrics
Field | Description |
|---|---|
Report Date | Date |
Product Title | Name |
SKU | Identifier |
Active Subscription Count | Active subs |
New Subscription Count | New subs |
Churned Subscription Count | Cancelled subs |
Product Churn Rate | Product-level churn |
Solo Subscription Count | Single-product subs |
Bundle Subscription Count | Multi-product subs |
Total Quantity | Total units |
Active Count Change 7d / 30d | Trend |
Avg Products Per Subscription | Avg bundle size |
Notes & caveats
- Bundle = multi-product subscription
- Solo vs bundle = consumption behavior insight
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) |