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.

NameTypeDescriptionSource
event_datedateThe date the shipment label was created. Based on the shipping platform's timezone.ShipStation, ShipBob
event_date.daydateThe day the shipment was processed. Derived from event_date.ShipStation, ShipBob
event_date.weekdateThe Sunday of the week during which the shipment was processed. Derived from event_date.ShipStation, ShipBob
event_date.monthdateThe month during which the shipment was processed. Derived from event_date.ShipStation, ShipBob
event_date.quarterdateThe first month of the quarter during which the shipment was processed. Derived from event_date.ShipStation, ShipBob
event_date.yeardateThe year during which the shipment was processed. Derived from event_date.ShipStation, ShipBob
event_hourstringThe 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_idstringThe unique ID for the shipment.

Example value: 161327771
ShipStation, ShipBob
created_attimestampThe 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_attimestampThe 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_datetimestampThe 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_datetimestampThe 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_statusstringThe current status of the shipment.

Example values: LabeledCreated, Completed
ShipBob
to_countrystringThe destination country of the shipment.

Example values: CA, US, GB
ShipStation, ShipBob
to_statestringThe destination state of the shipment.

Example values: WA, FL, ON
ShipStation, ShipBob
to_citystringThe destination city of the shipment.

Example values: MANCHESTER, SAN JOSE, OROVILLE
ShipStation, ShipBob
is_returnbooleanTrue if the shipment is a return to the sender.ShipStation, ShipBob
is_voidedbooleanTrue if the shipment is voided.ShipStation
order_statusstringThe status of the order associated with the shipment.

Example values: Processing, Fulfilled
ShipBob
shipping_platformstringThe platform used to manage and process the shipment.

Example values: shipbob, shipstation
ShipStation, ShipBob
estimated_fulfillment_date_statusstringThe 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.

NameTypeDescriptionSource
shop_shipment_costnumericThe cost of the shipment to the shop. By default shown in the shop's currency.ShipStation, ShipBob
number_of_itemsnumericThe number of items contained in the shipment.ShipBob