rpt_subscription_signup_cohort_retention - SourceMedium

Pro warehouses only. Subscription tables are not delivered on Foundation warehouses. See Foundation and Pro.

Subscription signup-cohort retention, MRR retention, and subscriber lifetime value curves.

Grain: one row per store, cohort month, and months since signup. A cohort is the month of a subscriber’s first subscription.
Joins: none; complements the order-based cohort tables.

Columns

Column	Type	Description
`sm_store_id`	STRING	SourceMedium’s unique store identifier.
`cohort_month`	DATE	Month in which subscribers in the cohort first subscribed.
`cohort_size`	INT64	Number of subscribers who started in the cohort.
`cohort_starting_mrr`	FLOAT64	MRR at the start of the cohort.
`cumulative_revenue`	NUMERIC	Collected subscription revenue accumulated by the cohort.
`cumulative_revenue_per_subscriber`	NUMERIC	Cumulative collected subscription revenue divided by cohort size.
`months_since_signup`	INT64	Number of months since the cohort first subscribed.
`months_since_signup_name`	STRING	Display label for `months_since_signup`. Month 0 is `Acquisition Month`; later months are `+1`, `+2`, and so on.
`mrr_retention_rate`	FLOAT64	Share of starting MRR retained at this month.
`reporting_timezone`	STRING	Your store’s reporting timezone, used for the date columns on this row.
`retained_mrr`	FLOAT64	MRR retained by the cohort at this month.
`retained_subscribers`	INT64	Subscribers retained in the cohort at this month.
`smcuuid`	STRING	Hashed store identifier.
`subscriber_retention_rate`	FLOAT64	Retained subscribers / cohort size. In [0, 1].

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.