Shipping Table

The Shipping table provides comprehensive details on shipments including timestamps, statuses, and destination details, as well as cost and shipment size. Querying this table can help businesses understand shipping patterns, evaluate carrier performance, and improve overall logistics strategies.

📘
Note
event_date is a required field for queries on this table.
Data is only available via shipping integration. If you have set shipping charges as shipping cost, or manually set shipping costs in Triple Whale Admin, shipping data will not appear.

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 time zone of the shop at the time the shipment was processed. 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 ID	`shipment_id`	string	The unique ID for the shipment. Example value: `161327771`
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`
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 of the shipment. Example values: `CA`, `US`, `GB`
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 about 1 month ago