> ## 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.

# dim_subscribers

> Subscriber dimension with status, cohort, tenure, and lifetime revenue. Pro warehouse only.

<Note>
  **Pro warehouses only.** Subscription tables are not delivered on Foundation warehouses. See [Foundation and Pro](/docs/data-activation/managed-data-warehouse/overview).
</Note>

One row per subscriber. Use this table for subscriber status, first-subscription cohort, tenure, and realized lifetime revenue.

**Platforms:** ReCharge and Medusa.

```yaml theme={null}
version: 2

models:
  - name: dim_subscribers
    description: >
      Subscriber dimension. Grain: one row per (sm_store_id, subscriber_id).
    columns:
      - name: sm_store_id
        description: SourceMedium's unique store identifier.

      - name: subscriber_id
        description: Platform identifier for the subscriber.

      - name: subscriber_status
        description: >
          Current subscriber status. Observed values are `Active`, `Inactive`, and `Dunning`.

      - name: reporting_timezone
        description: Workspace timezone used for subscriber cohort and tenure dates.

      - name: subscriber_cohort_month
        description: Month of the subscriber's first subscription, in the reporting timezone.

      - name: subscriber_tenure_days
        description: Days from the subscriber's first subscription to the current date in the reporting timezone.

      - name: subscriber_lifetime_revenue
        description: >
          Realized charge revenue for this subscriber. ReCharge only. Medusa has no charge stream, so this is not populated for Medusa subscribers.
```

See [Reporting Currency](/docs/help-center/core-concepts/data-definitions/reporting-currency) when conversion is enabled. Charge revenue stays dependent on the subscription platform.