Shipping Table
The Shipping table tracks shipment status, cost, and destination from your shipping platform (e.g., ShipStation, ShipBob). One row per shipment.
Table GuideWhat You Can Answer With This Table
- What percentage of orders are fulfilled on time, and what are average shipping costs? — use
percent_fulfilled_on_time,avg_cost_per_shipment- Where are shipments being delivered? — group by
to_country,to_state,to_cityBefore You Query
- Required field:
event_date- Data is only available via a connected shipping integration (e.g., ShipStation, ShipBob). Manually set shipping costs in Triple Whale Admin will not appear here.
When to Use a Different Table
- Use Orders table when you need order-level shipping amounts without carrier integration detail. The Shipping table is for shipment status, fulfillment timing, destination, and per-shipment carrier costs.
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 timezone of the shipping platform. Example values: |
| 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: |
| Estimated Fulfillment Date Status | estimated_fulfillment_date_status | string | The status of the shipment's estimated fulfillment date. Example value: |
| Is Return Shipment | is_return | boolean | True if the shipment is a return to the sender. Possible values: |
| Is Voided Shipment | is_voided | boolean | True if the shipment is voided. Possible values: |
| Shipment Date | shipment_date | timestamp | The time when the shipment was actually shipped. Formatted according to the ISO 8601 international standard . Example value: |
| Shipment Status | shipment_status | string | The current status of the shipment. Example values: |
| Shipping Platform | shipping_platform | string | The platform used to manage and process the shipment. Example values: |
| Shop ID | shop_id | string | The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: |
| Shop Name | shop_name | string | The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: |
| Destination Ciy | to_city | string | The destination city of the shipment. Example values: |
| Destination Country | to_country | string | The destination country code of the shipment. See list of countries. Example values: |
| Destination Country Name | to_country_name | string | The full name of the destination country of the shipment. See list of countries. Example values: |
| Destination State | to_state | string | The destination state of the shipment. Example values: |
| 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: |
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 5 days ago