Subscription Metrics Daily Explore

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