Pro warehouses only. Subscription tables are not delivered on Foundation warehouses. See Foundation and Pro.
- Grain: (sm_store_id, subscriber_id).
Columns
| Column | Type | Description |
|---|---|---|
sm_store_id | STRING | SourceMedium’s unique store identifier. |
customer_email_hashed | STRING | Hashed customer email supplied by the charge source, when available. |
first_charge_processed_at | TIMESTAMP | UTC timestamp of the subscriber’s first settled charge, when available. |
has_failed_latest_charge | BOOL | Whether the subscriber’s latest charge attempt failed. |
is_dunning | BOOL | Whether the subscriber is currently in dunning after a recent failed latest charge. |
last_charge_processed_at | TIMESTAMP | UTC timestamp of the subscriber’s most recent settled charge, when available. |
last_failed_charge_at | TIMESTAMP | UTC timestamp of the subscriber’s most recent failed charge attempt, when available. |
number_active_subscriptions | INT64 | Subscriptions currently active for this subscriber. |
number_subscriptions | INT64 | Total subscriptions associated with this subscriber. |
number_successful_charges | INT64 | ReCharge charges with a successful status for this subscriber. |
reporting_timezone | STRING | Your store’s reporting timezone, used for the date columns on this row. |
smcuuid | STRING | Hashed store identifier. |
subscriber_cohort_month | DATE | Month of the subscriber’s first subscription, in the reporting timezone. |
subscriber_created_at | TIMESTAMP | UTC timestamp of the subscriber’s earliest subscription creation. |
subscriber_id | STRING | Platform identifier for the subscriber. |
subscriber_lifetime_revenue | NUMERIC | Realized net charge revenue for this subscriber. This is 0 when no settled charge revenue is available, including for Medusa subscribers because Medusa has no charge stream. |
subscriber_status | STRING | Current subscriber status. Published values are active, inactive, and dunning. |
subscriber_tenure_days | INT64 | Days from the subscriber’s first subscription to the current date in the reporting timezone. |
subscriber_updated_at | TIMESTAMP | Latest UTC subscription-update timestamp for this subscriber. |