The Orders table is the canonical record of revenue and purchases across all connected sales platforms. One row per order.

📋
Table Guide
What You Can Answer With This Table

What is total revenue, gross sales, or order count for a time period? — use order_revenue, gross_product_sales, orders

How do revenue, AOV, or LTV split between new and returning customers? — use new_customer_revenue, returning_customer_revenue, is_new_customer, aov, ltv

What drives order revenue by platform, product, or discount code? — group by platform, products_info.product_name, or discount_code

Before You Query

Required field: event_date

This table includes orders from your main sales platform (e.g., Shopify, BigCommerce, WooCommerce) and any connected marketplaces (e.g., Amazon, TikTok Shop). Filter by platform to isolate a specific source.

Refund amounts (refund_money) are calculated based on the original order date, not the refund date. For line-item refund detail or refund-date-based analysis, use the Refunds table.

Key Relationships

Table Join Key Use This Join To
Pixel Orders order_id Analyze which channels, campaigns, or ads drove each order
Refunds order_id Explain the order-level refund_money total with line-item refund detail
Reviews order_id Analyze customer feedback on specific purchases
Customer Journey order_id Analyze the touchpoint paths and UTM parameters that led to each purchase
Customers customer_id_key Segment order behavior by customer attributes and lifetime metrics
Customer Segmentation customer_id or customer_email to customer_identity Compare purchase behavior across customer cohorts

When to Use a Different Table

Use Pixel Orders table when you need attribution context for which channel, campaign, ad set, or ad drove an order. The Orders table is the transactional order record without attribution context.

Use Product Analytics table when you need product-level performance aggregates such as top SKUs or variant comparisons. The Orders table keeps product detail per order in products_info.

Use Shipping table when you need carrier-level shipping detail such as tracking status, fulfillment timing, destination, or carrier costs. The Orders table has order-level shipping amounts but not carrier integration detail.

Use Refunds table when you need refund-date analysis, such as when a refund was processed. The Orders table's refund_money is keyed to the order date.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
Pixel Orders	`order_id`	Analyze which channels, campaigns, or ads drove each order
Refunds	`order_id`	Explain the order-level `refund_money` total with line-item refund detail
Reviews	`order_id`	Analyze customer feedback on specific purchases
Customer Journey	`order_id`	Analyze the touchpoint paths and UTM parameters that led to each purchase
Customers	`customer_id_key`	Segment order behavior by customer attributes and lifetime metrics
Customer Segmentation	`customer_id` or `customer_email` to `customer_identity`	Compare purchase behavior across customer cohorts

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Hour	`event_hour`	string	The hour of the day the order was placed, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: `07`, `16`, `21`
Event Date	`event_date`	date	The date the order was placed. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	The day on which the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	The year during which the event occurred. Derived from `event_date`.
Amazon Fulfillment Channel	`amazon_fulfillment_channel`	string	The fulfillment channel of the Amazon order. Example values: `FBA`, `FBM`
Amazon Fulfillment Status	`amazon_fulfillment_status`	string	The fulfillment status of the Amazon order. Example values: `Pending`, `Unshipped`, `PartiallyShipped`, `Shipped`, `Canceled`, `Unfulfillable`, `InvoiceUnconfirmed`, `PendingAvailability`
Amazon Is Business Order	`amazon_is_business_order`	boolean	Indicates if the order is a business order on Amazon. Possible values: `true`, `false`
Amazon Marketplace ID	`amazon_marketplace_id`	string	The Amazon marketplace ID for the marketplace associated with the order. See list of marketplace IDs.
Amazon Marketplace Name	`amazon_marketplace_name`	string	The human-readable name of the Amazon marketplace associated with the order (e.g., "United States of America", "United Kingdom").
Amazon Region	`amazon_region`	string	The Amazon region for the marketplace associated with the order (e.g., "North America", "Europe", "Far East").
Billing City	`billing_city`	string	The city of the customer's billing address. Example value: `San Francisco`
Billing Country	`billing_country`	string	The full name of the customer's billing country. See list of countries. Example values: `United States`, `Canada`, `United Kingdom`
Billing Country Code	`billing_country_code`	string	The country code of the customer's billing address. See list of countries. Example values: `US`, `CA`, `GB`
Billing State	`billing_province`	string	The state or province of the customer's billing address. Example values: `Oregon`, `British Columbia`, `Michigan`
Canceled Date	`cancelled_at`	timestamp	The time at which the order was canceled. Formatted according to the ISO 8601 international standard. NULL if the order was not canceled. Example value: `2023-06-15T19:26:30.000Z`
Order Created Date	`created_at`	timestamp	The time at which the order record was created. Formatted according to the ISO 8601 international standard. Example value: `2022-06-15T19:26:30.000Z`
Order Currency	`currency`	string	The original currency of the order, before conversion to the shop's currency. All monetary values are automatically converted to the shop's selected currency for display. Example values: `USD`, `GBP`, `EUR`
Customer Email	`customer_email`	string	The customer's email address. Example value: `[email protected]`
Customer First Name	`customer_first_name`	string	The customer's first name. Example value: `John`
Customer City	`customer_from_city`	string	The city of the customer's default address. Example value: `San Francisco`
Customer Country Code	`customer_from_country_code`	string	The country code of the customer's default address. See list of countries. Example values: `US`, `CA`, `GB`
Customer Country Name	`customer_from_country_name`	string	The full name of the customer's country. See list of countries. Example values: `United States`, `Canada`, `United Kingdom`
Customer State Code	`customer_from_state_code`	string	The state or province code of the customer's default address. Example value: `CA`
Customer ID	`customer_id`	string	The unique identifier for the customer, assigned by the main sales platform. Example value: `5209503793328`
Customer ID Key	`customer_id_key`	string	Join key for connecting this table to the Customers table. Contains `customer_id` for Shopify shops and `customer_email` for non-Shopify shops (e.g., Amazon, BigCommerce, WooCommerce). Example values: `5209503793328`, `[email protected]`
Customer Last Name	`customer_last_name`	string	The last name of the customer. Example value: `Doe`
Customer Tags	`customer_tags`	repeated string	Tags associated with the customer, set in the main sales platform. Example values: `Active Subscriber`, `PayPal_user`, `Login with FB`
Discount Code	`discount_code`	string	The discount code or promotion name used in the order. Set by the seller in the main sales platform. Example values: `WELCOME10`, `Replacement for defective item`, `807QRWMNK2`
Discount Type	`discount_type`	string	The type of discount received by the customer in the order. Example values: `fixed_amount`, `percentage`
Fulfillment Status	`fulfillment_status`	string	The fulfillment status of the order. Example values: `fulfilled`, `partial`, `restocked`
Integration Shipping Status	`integration_shipping_status`	string	The shipping status of the order, according to the integrated shipping provider. Example values: `LabeledCreated`, `Completed`
Is First Order in Subscription	`is_first_order_in_subscription`	boolean	True if the order is the first in a subscription series. Possible values: `true`, `false`
Is New Customer	`is_new_customer`	boolean	True if this is the customer's first order. Possible values: `true`, `false` Learn how Triple Whale classifies new/returning customers.
Is Subscription Order	`is_subscription_order`	boolean	True if the order is part of a subscription. Possible values: `true`, `false`
Metafields	`metafields`	record repeated	Custom key–value pairs attached to each order record, used to store additional structured or unstructured data beyond standard fields.
Metafield ID	`metafields.metafield_id`	string	The unique identifier of the metafield record. Example value: `44187839136031`
Metafield Key	`metafields.key`	string	The unique key of the metafield within its namespace, indicating what data it holds. Example values: `promised_delivery_date`, `zone`, `agree_to_terms`
Metafield Value	`metafields.value`	string	The raw stored value of the metafield. Format depends on the metafield type (e.g., text, date, boolean, JSON). Example values: `2025-11-10`, `true`, `#241194`, `5a`
Metafield Namespace	`metafields.namespace`	string	Logical grouping used to organize metafields by source or purpose. Example values: `custom`, `klaviyo`, `checkoutblocks`
Metafield Type	`metafields.type`	string	The data type of the metafield value (e.g., text, date, boolean, JSON, reference). Example values: `date`, `boolean`, `json`, `single_line_text_field`, `customer_reference`
Metafield Updated Date	`metafields.updated_at`	timestamp	When the metafield was last updated, in shop time zone. Example value: `2025-10-21 07:08:01`
Metafield Created Date	`metafields.created_at`	timestamp	When the metafield was first created, in shop time zone. Example value: `2025-10-21 07:08:01`
Order ID	`order_id`	string	The unique order ID, assigned by the main sales platform. Example value: `4930225799243`
Order Name	`order_name`	string	The name of the order as assigned by the seller on the main sales platform. Example values: `#2188464`, `Ex-2163819-9`
Sales Platform	`platform`	string	The sales platform where the order was processed. Example values: `Shopify`, `BigCommerce`, `WooCommerce`, `Amazon`
Products	`products_info`	record repeated	Details about the products associated with the order (at the level of the variant), including name, product ID, variant ID, type, SKU, etc. Returns the latest product information, not necessarily the data at the time the order was placed.
Product ID	`products_info.product_id`	string	The unique ID of the product as set within the main sales platform. Example value: `3891505496131`
Product Name	`products_info.product_name`	string	The name of the product as set within the main sales platform. Example values: `Green Soft Socks 3-Pack`, `Paring Knife Travel Case`, `Gift Subscription`
Product Vendor	`products_info.vendor`	string	The vendor of the product as set within the main sales platform. Example values: `Acme`, `XYZ Corp`, `Brandless`
Product Type	`products_info.product_type`	string	The product type as set within the main sales platform. Example values: `Jackets`, `Coffee Mugs`, `Books`
Product Tags	`products_info.product_tags`	repeated string	Tags associated with the product, set in the main sales platform. Example values: `Upsell`, `Order Credits`, `discount_eligible`
Product SKU	`products_info.product_sku`	string	The SKU (Stock Keeping Unit) for the product as set within the main sales platform. Example values: `GP-BACK-02`, `A02630`, `POP200NAVY`
Product Variant ID	`products_info.variant_id`	string	The unique identifier for a specific variant of a product as set within the main sales platform. Example value: `29275946877001`
Is Gift Card	`products_info.is_gift_card`	boolean	True if the product purchased is a gift card. Possible values: `true`, `false`
Product Properties	`products_info.properties`	record repeated	Custom key–value properties attached to the product line item (e.g., personalization details, bundle metadata, app-specific fields).
Product Property Name	`products_info.properties.name`	string	The name or key of the product property.
Product Property Value	`products_info.properties.value`	string	The value assigned to the product property.
Product Duties	`products_info.duties`	record repeated	Import duties or tariffs applied to the product.
Product Duty ID	`products_info.duties.duty_id`	string	The unique identifier of the duty applied to the product.
Product Duty Tax Lines	`products_info.duties.tax_lines`	record repeated	Tax lines charged on the product duty.
Product Duty Tax Line Amount	`products_info.duties.tax_lines.price`	numeric	The tax amount charged on the product duty per tax line.
Product Duty Amount	`products_info.duties.price`	numeric	The monetary amount of duty charged for the product.'
Product Price	`products_info.product_name_price`	numeric	The price of a single product (to the buyer), before discounts. By default shown in the shop's currency. Note: Tax will be included in the product price if the seller has configured the sale to require taxes in the main sales platform.
Total Product Discount	`products_info.discount_amount_for_product`	numeric	The amount discounted from the product price, before taxes. By default shown in the shop's currency.
Net Product Discount	`products_info.net_discount_amount_for_product`	numeric	The amount discounted from the product price, after taxes. By default shown in the shop's currency.
Product Units Sold	`products_info.product_name_quantity_sold`	numeric	The total number of individual units sold for the product.
Product Cost	`products_info.single_product_cost`	numeric	The cost of a single product (to the seller). By default shown in the shop's currency.
Shipping City	`shipping_city`	string	The city of the shipping address. Example value: `San Francisco`
Shipping Country Code	`shipping_country_code`	string	The country code of the shipping address. See list of countries. Example values: `US`, `CA`, `GB`
Shipping Country Name	`shipping_country_name`	string	The full name of the shipping country. See list of countries. Example values: `United States`, `Canada`, `United Kingdom`
Shipping Date	`shipping_date`	date	The most recent shipping-related date (in case of multiple shipments for the same order), selected from fields supported by the connected shipping platform (e.g., shipped, fulfilled, or shipping label created). Example value: `2024-12-25`
Shipping Provider	`shipping_provider_id`	string	The integrated shipping provider that manages and processes the order's shipment. Example values: `shipbob`, `shipstation`
Shipping State	`shipping_state`	string	The province or state of the shipping address. Example value: `California`
Shipping State Code	`shipping_state_code`	string	The province or state code of the shipping address. Example value: `CA`
Shipping Zip Code	`shipping_zip`	string	The zip/postal code of the customer's shipping address. Example values: `48104`, `18235-2239`, `CH25 9BH`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`
Shop Timezone	`shop_timezone`	string	The designated timezone of the shop according to the timezone database .
Source	`source_name`	string	The origin of the order as designated by the seller on the main sales platform. Example values: `web`, `pos`, `tiktok`
Tags	`tags`	repeated string	Tags associated with the order, assigned by the seller on the main sales platform. Example values: `Upsell`, `Order Credits`, `discount_eligible`
Transactions	`transactions`	record repeated	Details about transactions associated with the order, including payment information and status.
Transaction Created Date	`transactions.created_at`	timestamp	The time at which the transaction record was created. Formatted according to the ISO 8601 international standard. Example value: `2024-12-25 11:30:09`
Transaction Processed Date	`transactions.processed_at`	timestamp	The time at which the transaction was processed. Formatted according to the ISO 8601 international standard. Example value: `2024-12-25 11:30:09`
Transaction Payment Gateway	`transactions.payment_gateway_name`	string	The payment gateway used for the transaction. Example values: `shopify_payments`, `paypal`, `gift_card`
Transaction Currency	`transactions.currency`	string	The currency in which the transaction was processed. Example values: `USD`, `EUR`
Transaction Status	`transactions.status`	string	The status of the transaction. Example values: `SUCCESS`, `FAILURE`, `AWAITING_RESPONSE`, `PENDING`, `ERROR`
Transaction Amount	`transactions.amount`	numeric	The amount of the transaction.
Transaction Fees	`transactions.fees`	numeric	The fees associated with the transaction.

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Amazon Estimated Fees	`amazon_estimated_fees`	numeric	The estimated fees to be charged by Amazon for the order, based on products purchased. Note that this amount is an estimate and is not final until Amazon reports on actual fees.
Cost of Goods (COGS)	`cost_of_goods`	numeric	The cost of goods for orders within the selected time frame (before refunds). Imported from the main sales platform, or edit these in Cost Settings > Cost of Goods.
Currency Rate	`currency_rate`	numeric	The rate used to convert monetary values to the shop's currency. If no conversion was applied, the value is `1`. To convert back to the original currency, divide by this rate.
Custom Expenses	`custom_expenses`	numeric	Additional custom expenses associated with individual orders. Import using the Enrich Orders Data API endpoint.
Custom Gross Profit	`custom_gross_profit`	numeric	Custom gross profit for individual orders. Import using the Enrich Orders Data API endpoint.
Custom Gross Sales	`custom_gross_sales`	numeric	Custom gross sales for individual orders. Import using the Enrich Orders Data API endpoint.
Custom Net Revenue	`custom_net_revenue`	numeric	Custom net revenue for individual orders. Import using the Enrich Orders Data API endpoint.
Custom Orders Quantity	`custom_orders_quantity`	numeric	The custom-defined quantity of orders to count for the single `order_id`. Possible values: `0`, `1` Import using the Enrich Orders Data API endpoint.
Custom Total Items	`custom_total_items_quantity`	numeric	The custom-defined total number of items in the order. Import using the Enrich Orders Data API endpoint.
Discounts	`discount_amount`	numeric	The total discount amount applied to the order, including shipping discounts.
Product Discount Amount	`discount_amount_for_product`	numeric	The total product discount amount applied to the order.
Shipping Discount Amount	`discount_amount_for_shipping`	numeric	The total shipping discount amount applied to the order.
Estimated Shipping Costs	`estimated_shipping_costs`	numeric	Estimated shipping costs paid by the seller for orders within the select timeframe. Edit these in: Cost Settings > Shipping
Gross Sales	`gross_product_sales`	numeric	Gross sales revenue (before shipping, taxes, discounts, or refunds). Gross Sales = Product Price x Units Sold
Handling Fees	`handling_fees`	numeric	Handling fees (e.g. boxing, packaging, or “pick & pack” services) paid by the seller for orders in the selected time frame. Edit these in Cost Settings > Cost of Goods.
Order Revenue	`order_revenue`	numeric	Revenue earned after shipping, taxes, and discounts (before refunds). Order Revenue = Gross Sales + Shipping + Taxes − Discounts
Payment Gateway Costs	`payment_gateway_costs`	numeric	Payment processing fees (not including currency conversion fees) paid by the seller. Edit these in Cost Settings > Gateway Costs.
Units Sold	`product_quantity_sold_in_order`	numeric	The total number of individual product units sold in the order.
Refunds	`refund_money`	numeric	Total amount returned to customers for refunded sales, refunded taxes, and refunded shipping. Calculated based on the order date. Note that Triple Whale does not track refunds from third-party return management apps (e.g., Loop), so totals may vary from the sales platform. Refunds = Refunded Sales + Refunded Shipping + Refunded Tax
Shipping Costs	`shipping_costs`	numeric	Shipping costs paid by the seller for orders within the select timeframe. Edit these in Cost Settings > Shipping.
Shipping Price	`shipping_price`	numeric	The total shipping price of the order (paid by the buyer), including shipping taxes and shipping discounts.
Sale Taxes	`taxes`	numeric	Total amount customers paid in taxes, before refunds.

Derived

Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.

Title	ID	Type	Description
Average Order Value	`aov`	formula	The average order value (before shipping or taxes), as reported by the sales platform. AOV = (Order Revenue - Shipping Price - Taxes) / Number of Orders
Lifetime Value	`ltv`	formula	The average order revenue per customer, for orders placed within the selected timeframe. LTV = Order Revenue / Unique Customers
New Customer Orders	`new_customer_orders`	formula	The total number of orders placed by new customers within the selected time frame. Learn how Triple Whale classifies new/returning customers.
New Customer Revenue	`new_customer_revenue`	formula	The total revenue derived from orders by new customers. Learn how Triple Whale classifies new/returning customers.
New Customers Percent	`new_customers_percent`	formula	The percentage of purchases made by new customers. New Customers % = Number of New Customer Orders / Total Orders Learn how Triple Whale classifies new/returning customers.
Orders	`orders`	formula	The total number of orders placed within the selected timeframe.
Non-Zero Orders	`orders_with_amount`	formula	The total number of orders with a revenue greater than zero. Non-Zero Orders = Count of Orders where Order Revenue > $0
Returning Customer Orders	`returning_customer_orders`	formula	Number of orders placed by Returning Customers. Learn how Triple Whale classifies new/returning customers.
Returning Customer Revenue	`returning_customer_revenue`	formula	Amount of revenue derived from Returning Customers. Learn how Triple Whale classifies new/returning customers.
Returning Customers Percent	`returning_customers_percent`	formula	Percentage of orders placed by Returning Customers. Returning Customers % = Number of Returning Customer Orders / Total Orders Learn how Triple Whale classifies new/returning customers.
True Average Order Value	`true_aov`	formula	The average non-zero order value (before shipping or taxes), as reported by the sales platform. True AOV = (Order Revenue - Shipping Price - Taxes) / Number of Orders > $0
Unique Customers	`unique_customers`	formula	Number of unique customers who placed orders within the selected timeframe.