Chord Data Platform
Data Models
Subscriptions
4 min
introduction chord's subscription analytics module provides a suite of 7 explores designed for self service subscription analysis these explores work across recharge and your oms provide a unified view of subscription performance support analysis across customer level subscription level product level lifecycle events how to access log into the chord commerce data platform navigate to analytics click explores select a subscription explore quick reference — which explore should i use? use this as your starting point when you’re not sure where to go each explore is designed to answer a specific type of business question if your question is about… what you’re trying to understand use this explore overall subscription health are we growing or shrinking? what’s our churn rate? subscription metrics daily customer value (ltv) who are our most valuable subscribers? subscriber journey retention over time how long do customers stay? how do cohorts behave? subscriber journey monthly behavior leading to churn what happens before users cancel? subscription events enriched business impact of changes how much revenue are we losing from cancellations? subscription movements daily product performance which products drive growth or churn? subscription product metrics daily bundle performance which product combinations perform best? subscription bundle metrics daily you can use this handy guide to start your analysis start with metrics daily → “what is happening?” move to journey / monthly → “who is driving this and how does it evolve?” use events → “why is this happening?” use movements / product / bundle → “where is the impact coming from?” key dimensions & metrics docid\ vrk7flahnov r92ulujh0 docid\ phlefk8f kcnlkanepm97 docid\ k3t064arjs6taei21ua46 docid\ pgqiyyrgagkru tuwx6jj docid\ jjeyndjwhcf6ua 4ketck docid 6ldctaqrcd0oxvqrvvgoz docid\ fpvuvhii9l9wp4ybhc2hc 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)