Shipping

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.

Name	Type	Description	Source
event_date	date	The date the shipment label was created. Based on the shipping platform's timezone.	ShipStation, ShipBob
event_date.day	date	The day the shipment was processed. Derived from event_date.	ShipStation, ShipBob
event_date.week	date	The Sunday of the week during which the shipment was processed. Derived from event_date.	ShipStation, ShipBob
event_date.month	date	The month during which the shipment was processed. Derived from event_date.	ShipStation, ShipBob
event_date.quarter	date	The first month of the quarter during which the shipment was processed. Derived from event_date.	ShipStation, ShipBob
event_date.year	date	The year during which the shipment was processed. Derived from event_date.	ShipStation, ShipBob
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	ShipStation, ShipBob
shipment_id	string	The unique ID for the shipment. Example value: 161327771	ShipStation, ShipBob
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	ShipStation, ShipBob
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	ShipStation, ShipBob
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	ShipStation, ShipBob
expected_ship_date	timestamp	The expected time of the shipment as planned by the shipping platform. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z	ShipStation, ShipBob
shipment_status	string	The current status of the shipment. Example values: LabeledCreated, Completed	ShipBob
to_country	string	The destination country of the shipment. Example values: CA, US, GB	ShipStation, ShipBob
to_state	string	The destination state of the shipment. Example values: WA, FL, ON	ShipStation, ShipBob
to_city	string	The destination city of the shipment. Example values: MANCHESTER, SAN JOSE, OROVILLE	ShipStation, ShipBob
is_return	boolean	True if the shipment is a return to the sender.	ShipStation, ShipBob
is_voided	boolean	True if the shipment is voided.	ShipStation
order_status	string	The status of the order associated with the shipment. Example values: Processing, Fulfilled	ShipBob
shipping_platform	string	The platform used to manage and process the shipment. Example values: shipbob, shipstation	ShipStation, ShipBob
estimated_fulfillment_date_status	string	The status of the shipment's estimated fulfillment date. Example value: FulfilledOnTime	ShipBob

Measures

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

Name	Type	Description	Source
shop_shipment_cost	numeric	The cost of the shipment to the shop. By default shown in the shop's currency.	ShipStation, ShipBob
number_of_items	numeric	The number of items contained in the shipment.	ShipBob