dim_subscribers

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.