> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# rpt_subscription_signup_cohort_retention

> Subscription retention and MRR by signup cohort and months since signup.

```yaml theme={null}
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.
```

<Info>
  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](/docs/help-center/core-concepts/data-definitions/reporting-currency).
</Info>

<Warning>
  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.
</Warning>

<Warning>
  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.
</Warning>