obt_subscription_charges

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

Charge-grain One Big Table. Use it for revenue per recharge, 1st vs nth charge, and dunning recovery. Platforms: ReCharge only. Medusa subscribers have no charge rows here. A charge can exist without a matching subscriber dimension row. Those charges are kept. Subscriber context is null on those rows.

version: 2

models:
  - name: obt_subscription_charges
    description: >
      Charge OBT. Grain: one row per (sm_store_id, charge_id).
    columns:
      - name: sm_store_id
        description: SourceMedium's unique store identifier.

      - name: charge_id
        description: Platform identifier for the charge.

      - name: subscriber_id
        description: Subscriber who was billed, when available.

      - name: charge_sequence_number
        description: 1-based billing sequence across the subscriber's charge history.

      - name: successful_charge_sequence_number
        description: Running count of settled charges for the subscriber through this charge.

      - name: subscriber_status
        description: Denormalized subscriber status at the last model refresh.

      - name: subscriber_cohort_month
        description: Denormalized first-subscription month.

      - name: subscriber_lifetime_revenue
        description: Denormalized realized charge revenue for the subscriber.

subscriber_lifetime_revenue is charge-based. It is not converted with the subscription-start FX used on subscription_price / subscription_mrr. See Reporting Currency.

⌘I

Get into BigQuery

Activate

SQL Query Library

How numbers are defined

Order Segmentation

Customer Record

Tables

Schema Standards

obt_subscription_charges