The Shipping table tracks shipment status, cost, and destination from your shipping platform (e.g., ShipStation, ShipBob). One row per shipment.

📋
Table Guide
What You Can Answer With This Table

What percentage of orders are fulfilled on time, and what are average shipping costs? — use percent_fulfilled_on_time, avg_cost_per_shipment

Where are shipments being delivered? — group by to_country, to_state, to_city

Before You Query

Required field: event_date

Data is only available via a connected shipping integration (e.g., ShipStation, ShipBob). Manually set shipping costs in Triple Whale Admin will not appear here.

When to Use a Different Table

Use Orders table when you need order-level shipping amounts without carrier integration detail. The Shipping table is for shipment status, fulfillment timing, destination, and per-shipment carrier costs.

View the full Triple Whale Data Ontology →

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 shipment was processed, according to a 24-hour clock. Based on the timezone of the shipping platform. Example values: `07`, `16`, `21`
Event Date	`event_date`	date	The date the shipment label was created. Based on the timezone of the shipping platform.
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`.
Shipment Created Date	`created_at`	timestamp	The time when the shipment record was created in the shipping platform. Formatted according to the ISO 8601 international standard . Example value: `2022-06-15T19:26:30.000Z`
Estimated Fulfillment Date Status	`estimated_fulfillment_date_status`	string	The status of the shipment's estimated fulfillment date. Example value: `FulfilledOnTime`
Is Return Shipment	`is_return`	boolean	True if the shipment is a return to the sender. Possible values: `true`, `false`
Is Voided Shipment	`is_voided`	boolean	True if the shipment is voided. Possible values: `true`, `false`
Shipment Date	`shipment_date`	timestamp	The time when the shipment was actually shipped. Formatted according to the ISO 8601 international standard . Example value: `2022-06-15T19:26:30.000Z`
Shipment Status	`shipment_status`	string	The current status of the shipment. Example values: `LabeledCreated`, `Completed`
Shipping Platform	`shipping_platform`	string	The platform used to manage and process the shipment. Example values: `shipbob`, `shipstation`
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`
Destination Ciy	`to_city`	string	The destination city of the shipment. Example values: `MANCHESTER`, `SAN JOSE`, `OROVILLE`
Destination Country	`to_country`	string	The destination country code of the shipment. See list of countries. Example values: `US`, `CA`, `GB`
Destination Country Name	`to_country_name`	string	The full name of the destination country of the shipment. See list of countries. Example values: `United States`, `Canada`, `United Kingdom`
Destination State	`to_state`	string	The destination state of the shipment. Example values: `WA`, `FL`, `ON`
Shipment Updated Date	`updated_at`	timestamp	The time when the shipment record was last updated in the shipping platform. Formatted according to the ISO 8601 international standard . Example value: `2022-06-15T19:26:30.000Z`

Measures

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

Title	ID	Type	Description
Number of Items	`number_of_items`	numeric	The number of items contained in the shipment.
Shipment Cost (Label Date)	`shop_shipment_cost`	numeric	Cost of the shipment to the seller from connected shipping platforms (when Integrations → Shipping Platform → Manage → Settings is set to Label Date). By default shown in the shop's currency.

Derived

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

Title	ID	Type	Description
Avg Cost Per Shipment	`avg_cost_per_shipment`	formula	Average shipping cost for each shipment during the selected timeframe.
Shipments Fulfilled On Time	`fulfilled_on_time`	formula	The number of shipments whose estimated fulfillment date status is `FulfilledOnTime` (fulfillment completed on or before the provider's promised fulfillment date). Only populated when the shipping platform reports estimated fulfillment status.
% Fulfilled On Time	`percent_fulfilled_on_time`	formula	The share of shipments whose estimated fulfillment date status is `FulfilledOnTime` (fulfillment completed on or before the provider's promised fulfillment date). Only populated when the shipping platform reports estimated fulfillment status. % Fulfilled On Time = Shipments Fulfilled On Time / Shipments