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_dateis 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. |