- Grain: One row per sm_order_key.
- Date field: order_processed_at_local_datetime.
- Filters to start with: is_order_sm_valid = TRUE (exclude test/cancelled orders); sm_channel for segmentation.
- Platform caveat: TikTok Shop coverage may be limited.
- Joins: obt_order_lines via sm_order_key (1:many); obt_customers via sm_customer_key (many:1); dim_orders via sm_order_key (1:1).
When to use this table
Useobt_orders for anything counted or summed per order: revenue, order counts, refunds, discounts, channel and campaign performance, new versus repeat customers. It already joins customer, attribution, and channel context, so most questions need no joins. Use obt_order_lines when the question is about products, and obt_customers when it is about customers rather than orders.
Always filter is_order_sm_valid = TRUE unless you deliberately want cancelled, test, or excluded orders.
Example query
Net revenue and order count by month and sales channel for the last 12 months:SELECT
DATE_TRUNC(DATE(order_processed_at_local_datetime), MONTH) AS month,
sm_channel,
COUNT(DISTINCT sm_order_key) AS orders,
SUM(order_net_revenue) AS net_revenue
FROM `your_project.sm_transformed_v2.obt_orders`
WHERE is_order_sm_valid = TRUE
AND DATE(order_processed_at_local_datetime) >= DATE_SUB(CURRENT_DATE(), INTERVAL 12 MONTH)
GROUP BY 1, 2
ORDER BY 1, 2
More query examples
- Attribution & Data Health
- Customers & Retention
- Journeys & Lead Capture
- LTV & Retention
- Orders & Revenue
- Products
Columns
| Column | Type | Description |
|---|---|---|
sm_customer_key | STRING | Stable SourceMedium customer key. Unique per customer. Key joins: dim_customers (1:1); dim_orders/obt_orders (1:many). Platform caveat: TikTok Shop coverage may be limited. Foreign key to obt_customers (many:1 - multiple orders per customer). |
sm_order_key | STRING | Stable SourceMedium order key. Unique per order. Key joins: obt_order_lines (1:many via sm_order_key); dim_customers (many:1 via sm_customer_key). Platform caveat: TikTok Shop coverage may be limited. Primary key (grain: one row per sm_order_key). Join to obt_order_lines via sm_order_key (1:many), obt_customers via sm_customer_key (many:1), dim_orders via sm_order_key (1:1). |
sm_store_id | STRING | SourceMedium’s unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers. |
currency_conversion_mapping_from_currency | STRING | Configured original currency from the mapping that applied to this order. Uses NO_MAPPING when no mapping applies. |
currency_conversion_mapping_id | STRING | Source/account mapping identifier used to resolve the original and converted currency. Uses NO_MAPPING when no mapping applies. |
currency_conversion_mapping_source | STRING | Source of the mapping used for this order, such as operator override or dynamically generated mapping. Uses NO_MAPPING when no mapping applies. |
currency_conversion_mapping_to_currency | STRING | Configured target currency from the mapping that applied to this order. Uses NO_MAPPING when no mapping applies. |
currency_conversion_resolution_method | STRING | Method used to resolve original currency for this order, such as record currency or operator override. Uses NO_MAPPING when no mapping applies. |
currency_conversion_settings_version | STRING | Published store-level currency conversion settings version used for the order. Uses NOT_ENABLED when the store does not have active conversion settings. |
customer_device_type | STRING | Device type derived from user agent (e.g., mobile, desktop, tablet). Coverage depends on website tracking; limited for marketplaces. |
customer_email_hashed | STRING | A hashed version of the customer’s email address. |
customer_id | STRING | The ID of the customer who placed the order. |
customer_tags_csv | STRING | Comma-separated customer tags at time of order; string version of customer_tags_array. Prefer array field for robust matching; CSV can include commas in tag values. |
earliest_order_refund_date | DATE | The earliest date when a refund was processed for an order. |
gross_profit | FLOAT64 | Net order revenue and shipping revenue minus order product cost, order shipping cost, order fulfillment cost, and merchant processing fees. |
is_first_subscription_order | BOOL | Whether a subscription order is the first subscription order based on the subscription order index or order tag indicators when an index is not available. |
is_latest_order | BOOL | Whether an order has an order_index_reversed that equals 1. |
is_order_currency_canonicalized | BOOL | True when canonical order money fields use the converted values for this row. |
is_order_sm_valid | BOOL | True if order is not voided, cancelled, uncollectible, draft, or refunded, and not cancelled for fraud or a declined payment (excluded even if still marked paid). Use WHERE is_order_sm_valid = TRUE to exclude test/invalid orders from revenue. |
is_pending | BOOL | True for Amazon or Medusa orders with no settled order-line rows. This can represent ingestion lag, terminal itemless orders, or source anomalies; it does not indicate whether an order with at least one settled line is otherwise complete. |
is_price_tax_inclusive | BOOL | Whether taxes are included in the order subtotal. |
is_recurring_subscription_order | BOOL | Whether a subscription order is a repeat subscription order based on the subscription order index or order tag indicators when an index is not available. |
is_subscription_order | BOOL | Whether the order is a subscription order. |
latest_order_refund_date | DATE | The most recent date when a refund was processed for an order. |
order_cancellation_reason | STRING | The reason an order was cancelled (sourced from the platform, e.g. Shopify’s cancel_reason). A reason of ‘fraud’ or ‘declined’ marks the order as not sm-valid (is_order_sm_valid = false) regardless of payment status. |
order_cancelled_at | TIMESTAMP | UTC timestamp when the order was cancelled. Null if order has not been cancelled. |
order_cancelled_at_local_datetime | DATETIME | Order cancelled timestamp converted to reporting timezone (from order_cancelled_at UTC). Null if order has not been cancelled. |
order_cart_net_quantity | NUMERIC | The quantity of items that were originally purchased in an order minus the quantity of items refunded. |
order_cart_quantity | NUMERIC | The quantity of items that were originally purchased in an order. |
order_checkout_id | STRING | The ID of the checkout that the order is associated with. |
order_converted_currency_code | STRING | Target reporting currency resolved by the currency conversion runtime. For stores without active conversion settings, this falls back to the original order currency. |
order_converted_discounts | NUMERIC | Order discounts converted using order_currency_conversion_rate_applied. |
order_converted_duty_refunds | NUMERIC | Duty refunds converted using the applied FX rate. |
order_converted_gross_duties | NUMERIC | Gross order duties converted using the applied FX rate. |
order_converted_gross_revenue | NUMERIC | Gross order revenue converted using order_currency_conversion_rate_applied. |
order_converted_gross_shipping | NUMERIC | Gross shipping revenue converted using the applied FX rate. |
order_converted_gross_shipping_taxes | NUMERIC | Gross shipping taxes converted using the applied FX rate. |
order_converted_gross_taxes | NUMERIC | Gross non-shipping order taxes converted using the applied FX rate. |
order_converted_net_duties | NUMERIC | Net order duties converted using the applied FX rate. |
order_converted_net_revenue | NUMERIC | Net order revenue converted using order_currency_conversion_rate_applied. |
order_converted_net_revenue_before_refunds | NUMERIC | Gross revenue less discounts, before refunds, converted using the applied FX rate. |
order_converted_net_shipping | NUMERIC | Net shipping revenue converted using the applied FX rate. |
order_converted_net_shipping_taxes | NUMERIC | Net shipping taxes converted using the applied FX rate. |
order_converted_net_taxes | NUMERIC | Net non-shipping order taxes converted using the applied FX rate. |
order_converted_refunds | NUMERIC | Order refunds converted using order_currency_conversion_rate_applied. |
order_converted_shipping_discounts | NUMERIC | Shipping discounts converted using the applied FX rate. |
order_converted_shipping_refunds | NUMERIC | Shipping refunds converted using the applied FX rate. |
order_converted_shipping_tax_refunds | NUMERIC | Shipping tax refunds converted using the applied FX rate. |
order_converted_tax_refunds | NUMERIC | Non-shipping tax refunds converted using the applied FX rate. |
order_converted_total_discounts | NUMERIC | Total order and shipping discounts converted using the applied FX rate. |
order_converted_total_refunds | NUMERIC | Total order and shipping refunds converted using the applied FX rate. |
order_converted_total_revenue | NUMERIC | Total order revenue including shipping and taxes converted using the applied FX rate. |
order_converted_total_taxes | NUMERIC | Total order and shipping taxes, net of refunds, converted using the applied FX rate. |
order_created_at | TIMESTAMP | UTC timestamp when the order was created. |
order_created_at_local_datetime | DATETIME | Order created timestamp converted to reporting timezone (from order_created_at UTC). |
order_currency_canonicalization_status | STRING | Safety status for replacing canonical order money fields with converted values. |
order_currency_code | STRING | Three-letter ISO 4217 currency code used to price and settle the order (e.g., USD, CAD, EUR). Multi-currency brands should normalize for FX when comparing revenue across currencies. |
order_currency_conversion_currency_code | STRING | Currency code that should describe order-level money fields after conversion is applied. This is the converted currency for converted or passthrough rows, and the original currency for unresolved rows. |
order_currency_conversion_effective_date | DATE | Date used to choose the daily FX rate for order currency conversion. Defaults to the order processed date when no active conversion mapping exists. |
order_currency_conversion_rate_applied | FLOAT64 | Multiplicative rate used to convert order-level money from original currency into converted currency. A value of 1 indicates passthrough, disabled conversion, or unresolved conversion. |
order_currency_conversion_status | STRING | Runtime status explaining whether the order was converted, passed through, not enabled, or blocked by missing configuration, missing FX coverage, or a source excluded from the current runtime scope. |
order_currency_mismatch_flag | BOOL | True when a row-level source currency is available and conflicts with the configured mapping currency. This is diagnostic only; row-level source currency still wins where available. |
order_customer_street_address | STRING | Customer’s billing street address associated with the order. May differ from shipping address; use for billing analysis and fraud detection. |
order_discount_codes_csv | STRING | A list of discount codes applied to an order. |
order_discounts | NUMERIC | The total amount of discounts applied to an order. |
order_duty_refunds | NUMERIC | The amount of duty refunds applied to an order. |
order_fulfillment_cost | NUMERIC | The blended cost to fulfill (pick and pack) orders for customers, considering that fulfillment cost is a variable order cost included in cost of goods sold (COGS). This data is recorded in the Financial Cost - Fulfillment tab of the financial cost configuration sheet. |
order_gross_duties | NUMERIC | The amount the customer paid in duties for an order. |
order_gross_revenue | NUMERIC | The gross revenue for an order, based on an order’s lines. Gross revenue is calculated by multiplying the price of an order’s lines by the quantity purchased. Gross revenue excludes revenue from gift card purchases. |
order_gross_shipping | NUMERIC | The amount the customer paid in shipping for an order. This does not include shipping tax. |
order_gross_shipping_taxes | NUMERIC | The amount of taxes associated with shipping, after discounts and before returns. |
order_gross_taxes | NUMERIC | The amount of taxes associated with an order’s lines, after discounts and before returns. This does not include shipping taxes. |
order_id | STRING | Platform order identifier. Not globally unique across stores; pair with sm_store_id and source_system when needed for scoping. |
order_index | INT64 | Ordered index identifying the sequential position of an order among the orders present in SourceMedium’s data for a customer (1..N, oldest = 1). Counts only ingested orders and is fully self-contained; for workspaces with incomplete ingested history (see int_shopify__incomplete_history_flags) this can understate the customer’s true lifetime position. |
order_index_reversed | INT64 | Ordered index identifying the sequential position of an order in a customer’s order history, in reverse order (newest = 1). Ranks the orders present in SourceMedium’s data. |
order_latency_days | INT64 | The number of days between the order_created_at and the order_processed_at for an order. |
order_merchant_processing_fees | NUMERIC | The payment processing fees for an order. This data is entered in the Financial Cost - Merchant Processing Fees tab of the SourceMedium financial cost configuration sheet. |
order_name | STRING | Platform-rendered name (human‑readable or platform‑specific). Not a stable join key. |
order_net_duties | NUMERIC | The gross order duties minus duty refunds. |
order_net_revenue | NUMERIC | The gross order revenue minus order discounts and refunds. |
order_net_revenue_before_refunds | NUMERIC | The gross order revenue minus order discounts. |
order_net_shipping | NUMERIC | The gross shipping revenue for an order minus shipping discounts and shipping refunds. |
order_net_shipping_taxes | NUMERIC | The order shipping tax minus shipping tax refunds. |
order_net_taxes | NUMERIC | The order tax minus order tax refunds. This does not include shipping taxes. |
order_number | STRING | Shop-scoped sequence number assigned by the platform. Not globally unique; pair with sm_store_id for scoping. |
order_original_currency_code | STRING | Original order currency resolved by the currency conversion runtime. For enabled Shopify stores, this prefers the row-level source currency; otherwise it falls back to order_currency_code. |
order_original_discounts | NUMERIC | Order discounts expressed in the original order currency. |
order_original_duty_refunds | NUMERIC | Duty refunds expressed in the original order currency. |
order_original_gross_duties | NUMERIC | Gross order duties expressed in the original order currency. |
order_original_gross_revenue | NUMERIC | Gross order revenue expressed in the original order currency. |
order_original_gross_shipping | NUMERIC | Gross shipping revenue expressed in the original order currency. |
order_original_gross_shipping_taxes | NUMERIC | Gross shipping taxes expressed in the original order currency. |
order_original_gross_taxes | NUMERIC | Gross non-shipping order taxes expressed in the original order currency. |
order_original_net_duties | NUMERIC | Net order duties expressed in the original order currency. |
order_original_net_revenue | NUMERIC | Net order revenue expressed in the original order currency. |
order_original_net_revenue_before_refunds | NUMERIC | Gross order revenue less discounts, before refunds, in the original currency. |
order_original_net_shipping | NUMERIC | Net shipping revenue expressed in the original order currency. |
order_original_net_shipping_taxes | NUMERIC | Net shipping taxes expressed in the original order currency. |
order_original_net_taxes | NUMERIC | Net non-shipping order taxes expressed in the original order currency. |
order_original_refunds | NUMERIC | Order refunds expressed in the original order currency. |
order_original_shipping_discounts | NUMERIC | Shipping discounts expressed in the original order currency. |
order_original_shipping_refunds | NUMERIC | Shipping refunds expressed in the original order currency. |
order_original_shipping_tax_refunds | NUMERIC | Shipping tax refunds expressed in the original order currency. |
order_original_tax_refunds | NUMERIC | Non-shipping tax refunds expressed in the original order currency. |
order_original_total_discounts | NUMERIC | Total order and shipping discounts expressed in the original order currency. |
order_original_total_refunds | NUMERIC | Total order and shipping refunds expressed in the original order currency. |
order_original_total_revenue | NUMERIC | Total order revenue including shipping and taxes in the original currency. |
order_original_total_taxes | NUMERIC | Total order and shipping taxes, net of refunds, in the original currency. |
order_payment_status | STRING | Financial status of the order (e.g., paid, partially_paid, partially_refunded, authorized, pending, refunded, voided, draft). Platform‑defined. |
order_processed_at | TIMESTAMP | UTC timestamp when the order was processed. |
order_processed_at_local_datetime | DATETIME | Order processed timestamp converted to reporting timezone (from order_processed_at UTC). Primary date field for order analytics and time-based filtering. |
order_processing_method | STRING | Method used to process the order (e.g., ‘manual’, ‘direct’, ‘offsite’). Platform-defined strings; some methods may only appear for specific integrations. |
order_product_tags_csv | STRING | The unique product tags across the order’s lines, de-duplicated, sorted and comma-and-space separated; the exact string form of order_product_tags_array, so array_to_string(order_product_tags_array, ’, ’) reproduces it. Null when no line in the order carries a tag. Tags are free-form and merchant-defined, and can be inconsistent across platforms; prefer normalized dimensional attributes when available. |
order_product_titles_csv | STRING | A list of product titles included in an order. |
order_product_variant_titles_csv | STRING | A list of product variant titles included in an order. |
order_referrer_url | STRING | The URL of the site that referred the customer to the shop. |
order_refund_quantity | NUMERIC | The quantity of order lines originally purchased in an order that were refunded. |
order_refunds | NUMERIC | The total amount of refunds applied to an order. |
order_return_cost | NUMERIC | The blended cost per order to handle returned products from a customer, considering that the cost of returns is a variable order cost included in cost of goods sold (COGS). This data is entered in the Financial Cost - Shipping tab of the SourceMedium financial cost configuration sheet. |
order_sequence | STRING | Customer lifecycle classification: 1st_order for the customer’s first order, repeat_order for every later order. Counts all orders; see sm_valid_order_sequence for valid orders only. |
order_session_browser_type | STRING | Browser type derived from user agent (e.g., chrome, safari, firefox). Coverage depends on website tracking; limited for marketplaces. |
order_session_user_agent | STRING | Raw user agent string. Used to derive customer_device_type and order_session_browser_type. |
order_shipping_city | STRING | The city, town, or village of the shipping address. |
order_shipping_cost | NUMERIC | The blended cost per order to ship products to customers, considering that shipping costs are variable order costs included in cost of goods sold (COGS). This data is set in the Financial Cost - Shipping tab of the SourceMedium financial cost configuration sheet. |
order_shipping_country | STRING | The country of the shipping address. |
order_shipping_country_code | STRING | The two-letter code (ISO 3166-1 format) for the country of the shipping address. |
order_shipping_discounts | NUMERIC | The amount of discounts applied to shipping. |
order_shipping_refunds | NUMERIC | The amount of shipping refunds applied to an order. |
order_shipping_state | STRING | Province/state of the shipping address; format varies by country and platform. |
order_shipping_tax_refunds | NUMERIC | The amount of shipping tax refunds applied to an order. |
order_shipping_zip_code | STRING | Postal/ZIP code from the shipping address (alphanumeric, varies by country). Use with country and state to avoid ambiguity; not geo-normalized. |
order_skus_csv | STRING | A list of SKUs included in an order. |
order_tags_csv | STRING | Comma-separated list of tags that the shop owner has attached to the order. Use for simple filtering; beware that individual tag values may contain commas. |
order_tax_refunds | NUMERIC | The amount of tax refunds applied to an order. This does not include shipping tax refunds. |
order_to_refund_days_earliest | INT64 | The number of days between the process date and the first refund date for an order. |
order_to_refund_days_latest | INT64 | The number of days between the process date and the most recent refund date for an order. |
order_to_refund_months_earliest | INT64 | The number of months between the process date and the first refund date for an order. |
order_to_refund_months_latest | INT64 | The number of months between the process date and the most recent refund date for an order. |
order_to_refund_weeks_earliest | INT64 | The number of weeks between the process date and the first refund date for an order. |
order_to_refund_weeks_latest | INT64 | The number of weeks between the process date and the most recent refund date for an order. |
order_total_discounts | NUMERIC | The amount of order and shipping discounts for an order. |
order_total_refunds | NUMERIC | The amount of order and shipping refunds. |
order_total_revenue | NUMERIC | Total order revenue after factoring in shipping revenue, taxes collected, discounts, and refunds. |
order_total_taxes | NUMERIC | Canonical order-level tax: order and shipping taxes less their refunds, summed from dim_order_taxes line taxes through int_order_line_transactions_revenue_calculated. Do not substitute the raw Shopify order-header total_tax, which is incomplete in some historical data. |
order_updated_at | TIMESTAMP | UTC timestamp from source system when the order was last updated. |
order_updated_at_local_datetime | DATETIME | Order last updated timestamp converted to reporting timezone (from order_updated_at UTC). |
order_vendors_csv | STRING | Comma-separated list of product vendors in the order, aggregated from line items. Vendor names may vary by platform; use for vendor mix analysis at order level. |
primary_order_payment_gateway | STRING | The technology or service that securely transmitted payment information between the customer, the business, and the payment processor. |
product_cost | NUMERIC | The landed cost of an order as defined by the SourceMedium financial cost configuration sheet (or by costs input directly into Shopify) multiplied by the quantity purchased. |
product_gross_profit | NUMERIC | Net order revenue minus product cost. |
sm_channel | STRING | Sales channel via hierarchy: (1) exclusion tag ‘sm-exclude-order’ -> excluded; (2) config sheet overrides; (3) default logic (amazon/tiktok_shop/walmart.com, pos/leap -> retail, wholesale tags -> wholesale, otherwise online_dtc). Note: excluded channel is omitted from Executive Summary and LTV. |
sm_default_channel | STRING | Default channel before overrides, from source name and tags: amazon/tiktok_shop/walmart.com; pos/leap -> retail; wholesale tags -> wholesale; otherwise online_dtc. See sm_channel for final channel. |
sm_fbclid | STRING | Facebook Click Identifier (FBCLID) from Meta/Facebook ad campaigns, used to track social media conversions. Present when order originated from Facebook/Instagram ad click-through. |
sm_gclid | STRING | Google Click Identifier (GCLID) from Google Ads campaigns, used to track paid search conversions. Present when order originated from Google Ads click-through. |
sm_order_landing_page | STRING | Path of the page where the buyer landed when they entered the shop (/products/x). Never a scheme+host URL. Checkout, invoice and cart URLs collapse to /checkouts, /invoices and /cart. |
sm_order_referrer_domain | STRING | Domain derived from order_referring_site. |
sm_order_sales_channel | STRING | Raw sales channel from Shopify specifically (e.g., ‘TikTok Shop’, ‘Instagram Shop’). Some values are used as input dimension for sm_channel mapping. See sm_channel for final classification. Others are used for analysis. |
sm_order_type | STRING | Order classification (subscription vs one-time) derived from order attributes, tags, or subscription platforms (Shopify Subscription Contract, ReCharge, Skio, Loop, Stay AI). |
sm_sub_channel | STRING | Sub-channel from source/tags with config overrides (e.g., Facebook & Instagram, Google, Amazon FBA/Fulfilled by Merchant). |
sm_ttclid | STRING | TikTok Click Identifier (TTCLID) captured from the selected pre-purchase event or order referring URL. The original case-sensitive token is preserved for downstream click-log joins. |
sm_utm_campaign | STRING | Last-click UTM campaign from attribution waterfall (Shopify visits/landing/order attributes → website events → GA/GA4 → referrer). Native on Shopify/Chargebee; enriched via website tracking (Elevar, Blotout, Snowplow). Limited for marketplaces. |
sm_utm_content | STRING | Last-click UTM content from attribution waterfall (Shopify visits/landing/order attributes → website events → GA/GA4 → referrer). Native on Shopify/Chargebee; enriched via website tracking (Elevar, Blotout, Snowplow). Limited for marketplaces. |
sm_utm_id | STRING | SourceMedium-generated unique identifier for UTM parameter combinations on this order. Used to link orders to specific marketing campaigns via UTM tracking. |
sm_utm_medium | STRING | Last-click UTM medium from attribution waterfall (Shopify visits/landing/order attributes → website events → GA/GA4 → referrer). Native on Shopify/Chargebee; enriched via website tracking (Elevar, Blotout, Snowplow). Limited for marketplaces. |
sm_utm_source | STRING | Last-click UTM source from attribution waterfall (Shopify visits/landing/order attributes → website events → GA/GA4 → referrer). For Shopify, order-level attribution includes allowlisted order customAttributes and legacy note_attributes, including parsing aggregate utmParams/GE_utmParams; if explicit utm_source is missing, sm_utm_source may be inferred from click IDs (e.g., gclid → google, fbclid → meta). When order-level attribution is set via Shopify order customAttributes (V3) using sm_utm_* or utm_* / (sm_)utmParams, it is treated as an explicit override and takes precedence over the default waterfall; keys and query-string parameters are parsed in a snake/camel-case agnostic way. Native on Shopify/Chargebee; enriched via website tracking (Elevar, Blotout, Snowplow). Limited for marketplaces. |
sm_utm_source_medium | STRING | Concatenation of source / medium (e.g., ‘google / cpc’). Shows ‘(none) / (none)’ when null. |
sm_utm_term | STRING | Last-click UTM term from attribution waterfall (Shopify visits/landing/order attributes → website events → GA/GA4 → referrer). Native on Shopify/Chargebee; enriched via website tracking (Elevar, Blotout, Snowplow). Limited for marketplaces. |
sm_valid_order_index | INT64 | Ordered index identifying the sequential position of a valid order in a customer’s valid order history. Only counts orders where is_order_sm_valid = TRUE. See order_sequence for all orders. |
sm_valid_order_index_reversed | INT64 | An ordered index that can be used to identify the sequential position of a valid order relative to a customer’s valid order history, in reverse order. |
sm_valid_order_latency_days | INT64 | The number of days between the process date of a valid order and the process date of the most recent preceding valid order for a customer. |
sm_valid_order_sequence | STRING | Whether a valid order is the first valid order or a repeat valid order. |
sm_zero_party_attribution_source | STRING | Attributable source from post‑purchase survey tags (e.g., Fairing/Enquire). |
source_system | STRING | Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage. |
source_system_sales_channel | STRING | Original source reported by the platform (e.g., Shopify sales channel/app name). |
subscription_order_index | INT64 | Ordered index identifying the sequential position of a subscription order in a customer’s subscription order history when a reliable subscription identifier or line-level subscription mapping is available. |
subscription_order_sequence | STRING | Subscription lifecycle classification: ‘First Subscription Order’ for initial subscription purchase, ‘Repeat Subscription Order’ for renewals. Based on subscription order index when available, otherwise inferred from order tags. Use for subscription cohort analysis. |
When reporting-currency conversion is enabled, standard order money fields such as
order_net_revenue and order_total_revenue use the workspace reporting currency. Use the order_original_* fields to reconcile against the source. See Reporting Currency.