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.

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

Measures

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

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