version: 2
models:
- name: rpt_subscription_signup_cohort_retention
description: >
Subscription retention by signup cohort and months since signup. Use it to compare subscriber
and MRR retention across cohorts. A cohort is the month a subscriber first started a
subscription, not the month of their first order.
columns:
- name: sm_store_id
description: SourceMedium's unique store identifier.
- name: reporting_timezone
description: Workspace timezone used to bucket cohort and activity months.
- name: cohort_month
description: Month in which subscribers in the cohort first subscribed.
- name: months_since_signup
description: Number of months since the cohort first subscribed.
- name: months_since_signup_name
description: >
Display label for `months_since_signup`. Month 0 is `Acquisition Month`; later months are
`+1`, `+2`, and so on.
- name: cohort_size
description: Number of subscribers who started in the cohort.
- name: retained_subscribers
description: Subscribers retained in the cohort at this month.
- name: subscriber_retention_rate
description: Share of the original cohort retained at this month.
- name: cohort_starting_mrr
description: MRR at the start of the cohort.
- name: retained_mrr
description: MRR retained by the cohort at this month.
- name: mrr_retention_rate
description: Share of starting MRR retained at this month.
- name: cumulative_revenue
description: Collected subscription revenue accumulated by the cohort.
- name: cumulative_revenue_per_subscriber
description: Cumulative collected subscription revenue divided by cohort size.
- name: smcuuid
description: Hashed store identifier.
When reporting-currency conversion is enabled, cohort MRR uses the exchange rate for the relevant cohort activity month. Conversion does not apply to cumulative charge revenue, which depends on data and currency supplied by the subscription platform. See Reporting Currency.
Collected subscription revenue depends on charge data supplied by the subscription platform. Medusa does not provide subscription charge history, so cumulative revenue is not available as realized Medusa subscription LTV.
A ReCharge bundle currently lands as multiple component subscriptions. Cohort size, retained subscribers, and MRR can be inflated for bundle-heavy stores until SourceMedium can collapse those components.