Shipping Table

shipping_table

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 is the status of shipments over time? — group by status with event_date

Where are shipments going? — group by shipping_country, shipping_state, shipping_city

What are shipping costs by platform? — group by shipping_platform

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.

Key Relationships
Table Join Key What the Join Enables
Orders Shared dimensions (event_date, shop_id) Compare shipment data with order-level revenue and fulfillment

When to Use a Different Table

Need order-level shipping price (what the customer paid for shipping) → Orders table. The Shipping table tracks carrier-side shipment data; Orders has the customer-facing shipping price.

View the full Triple Whale Data Ontology →

Table	Join Key	What the Join Enables
Orders	Shared dimensions (`event_date`, `shop_id`)	Compare shipment data with order-level revenue and fulfillment

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 To Shop	`shop_shipment_cost`	numeric	The cost of the shipment to the seller. By default shown in the shop's currency.

Updated 9 days ago