--- title: Subscription Metrics Daily Explore slug: subscription-metrics-daily-explore docTags: createdAt: 2026-03-27T18:06:43.148Z --- ## Overview Daily summary of subscription counts and flows. - Grain: **1 row per day** - Purpose: monitor **growth, churn, and overall health** ## When to use - Track subscription health on dashboards - Monitor churn trends over time - Evaluate net growth vs decline - Support executive-level reporting ## Key dimensions & metrics | Field | Description | | ---------------------------------- | ------------------------------------------------------------------------------- | | Report Date | Date of snapshot | | Active Count | Total active subscriptions | | New Count | Subscriptions created that day | | Churned Count | Subscriptions cancelled that day | | Reactivated Count | Previously cancelled → active | | Paused Count | Subscriptions paused that day | | Resumed Count | Subscriptions resumed that day | | Net New Count | New + Reactivated − Churned | | Churn Rate | Churned / previous day active | | Cancelled Cumulative Count | Running total cancellations | | Active Subscribers Count | Point-in-time count of customers with ≥1 active sub and no paused subs | | Partially Paused Subscribers Count | Point-in-time count of customers with both active AND paused subs | | Fully Paused Subscribers Count | Point-in-time count of customers with only paused subs | | Canceled Subscribers Count | Point-in-time count of customers whose only remaining subs are canceled | | Prepaid Subscribers Count | Point-in-time count of customers with ≥1 prepaid (non-gift) sub (ChordOMS only) | | Gifted Subscribers Count | Point-in-time count of customers currently receiving a gift sub (ChordOMS only) | | Gift Purchasers Count | Cumulative count of customers who have purchased a gift sub (ChordOMS only) | ## Example business questions - Daily churn trend (last 90 days) - Net growth trend over time - Monthly adds vs losses ## Notes & caveats - **Churn = cancellation only** (pauses excluded) - Paused/Resumed counts are **distinct subscription counts**, not event counts - Churn rate returns **NULL** if no previous-day active subscriptions - The subscriber counts above are **point-in-time (recalculated per report\_date)** - **Gift Purchasers Count is cumulative** — once a customer has bought a gift, they remain counted - **Prepaid, Gifted, and Gift Purchasers are ChordOMS-only** — Recharge and CustomOMS tenants will always show 0 ## 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) | | **Subscriber Category** | Mutually-exclusive current-state classification of a customer: active / partially\_paused / fully\_paused / canceled / never\_subscribed. | Use to segment customers by **current lifecycle state**. A reactivated customer returns to *active*. | Subscriber Journey, Subscriber Journey Monthly (current value) | | **Partially Paused** | Customer has at least one active AND at least one paused subscription simultaneously. | Identifies **at-risk users** scaling down but not fully churned. | Subscription Metrics Daily (Partially Paused Subscribers Count), Subscriber Journey (Subscriber Category) | | **Fully Paused** | Customer's only non-canceled subscriptions are paused. | A **softer churn signal** — these users may still reactivate. | Subscription Metrics Daily (Fully Paused Subscribers Count), Subscriber Journey (Subscriber Category) | | **Never Subscribed** | Customer exists in the system but has never had a subscription. | Useful for sizing **first-subscription / cross-sell opportunity**. | Subscriber Journey only | | **Prepaid Subscriber** | Customer has at least one prepaid (non-gift) subscription. | Identifies **upfront billing behavior**. ChordOMS only. | Subscription Metrics Daily (Prepaid Subscribers Count), Subscriber Journey (Is Prepaid Subscriber) | | **Gift Purchaser** | Customer has purchased one or more gift subscriptions for someone else. | Useful for **marketing segmentation and gifting behavior**. ChordOMS only. | Subscription Metrics Daily (Gift Purchasers Count — cumulative), Subscriber Journey (Is Gift Purchaser) | | **Gifted Subscriber** | Customer is receiving a gift subscription (someone else purchased it). | Useful for **conversion strategies** (turning recipients into paying users). ChordOMS only. | Subscription Metrics Daily (Gifted Subscribers Count), Subscriber Journey (Is Gifted Subscriber) | | **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 **cross-sell and product combinations**. | Product Metrics (Bundle Subscription Count), Bundle Metrics Daily | | **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), Events Enriched (Event Type) | | **Provider** | The system managing subscriptions (Recharge, ChordOMS, CustomOMS). | Important context — **data availability varies by provider**, impacting analysis. | All Explores |