Shipping Table
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 | shop_shipment_cost | numeric | The amount the connected shipping platform billed for shipments. Based on the date the shipping platform created the label or completed fulfillment. |
Derived
Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.
| Title | ID | Type | Description |
|---|---|---|---|
| Avg Cost Per Shipment | avg_cost_per_shipment | formula | Average shipping platform cost per fulfilled shipment. Based on the date the shipping platform created the label or completed fulfillment. Uses the Order Date vs Label Date setting in Integrations > Shipping Platform > Manage > Settings. On Order Date, the cost can come from the order rather than each shipment row. Avg Cost Per Shipment = Shipping Platform Costs / Shipments Fulfilled |
| Shipments Fulfilled On Time | fulfilled_on_time | formula | The number of shipment records whose estimated fulfillment date status is FulfilledOnTime (fulfillment completed on or before the shipping platform's promised fulfillment date). Only populated when the shipping platform reports estimated fulfillment status. |
| % Fulfilled On Time | percent_fulfilled_on_time | formula | The share of shipments whose estimated fulfillment date status is FulfilledOnTime (fulfillment completed on or before the shipping platform's promised fulfillment date). Only populated when the shipping platform reports estimated fulfillment status.% Fulfilled On Time = Shipments Fulfilled On Time / Shipments Fulfilled |
Updated 11 days ago