The Shipment view provides dimensions and measures for shipments and fulfillment.
The supported filters that can be applied to this view are:
| Name | Data Type | Description |
|---|---|---|
| YoY Order Created Date Filter | Datetime | When creating a report with year-over-year series, many of the Period Over Period dimensions use this filter as an input to calculate related date ranges. |
| YoY Shipment Created Date Filter | Datetime | When creating a report with year-over-year series, many of the Period Over Period dimensions use this filter as an input to calculate related date ranges. |
The measures calculated by this view are:
| Name | Measure Type | Description |
|---|---|---|
| Average Days Since Ready For Pickup | Average | Average number of days elapsed since the ready for pickup date. |
| Average Fulfilled Days Ready | Average | Average number of days elapsed since the ready for pickup date where the shipment status is fulfilled. |
| Average Fulfilled Line Item Subtotal | Average | Average of line item subtotal for all shipments where the shipment status is fulfilled. |
| Average Fulfilled Line Item Tax Total | Average | Average of line item tax total for all shipments where the shipment status is fulfilled. |
| Average Fulfilled Shipment Adjustment | Average | Average shipment adjustment for all shipments where the shipment status is fulfilled. |
| Average Fulfilled Shipping Tax Adjustment | Average | Average shipping tax adjustment for all shipments where the shipment status is fulfilled. |
| Average Fulfilled Shipping Total | Average | Average of shipping total for all shipments where the shipment status is fulfilled. |
| Average Hours To Fulfill | Average | Average number of hours from shipment placement to fulfillment for all shipment types. |
| Average Hours To Fulfill (BOPIS) | Average | Average number of hours from shipment placement to fulfillment where the shipment type is In-Store Pickup. |
| Average Hours To Fulfill (STH) | Average | Average number of hours from shipment placement to fulfillment where the shipment type is Ship To Home. |
| Average Line Item Subtotal | Average | Average of line item subtotal for all shipments. |
| Average Line Item Tax Total | Average | Average of line item tax total for all shipments. |
| Average Line Item Total | Average | Average line item total for all shipments. |
| Average Order Value | Average | The total order total divided by the valid order count. |
| Average Shipment Adjustment | Average | Average shipment adjustment for all shipments. |
| Average Shipment Total | Average | Average of total for all shipments. |
| Average Shipping Adjustment | Average | Average shipping adjustment for all shipments. |
| Average Shipping Tax Adjustment | Average | Average shipping tax adjustment for all shipments. |
| Average Shipping Total | Average | Average of shipping total for all shipments. |
| Canceled Order Count | Count | Count of all orders where the order status is canceled. |
| Canceled Shipment Count | Count | Count of all shipments where the shipment status is canceled. |
| Distinct Shipment Created Date Count | Count | The count of distinct shipment created dates. |
| Fulfilled Order Count | Count | Count of all orders where the fulfillment status is fulfilled. |
| Fulfilled Shipment Count | Count | Count of all shipments where the shipment status is fulfilled. |
| Fulfilled Shipment Item Total | Sum | Sum of line item total for all shipments where the shipment status is fulfilled. |
| Order Count | Count | The count of all orders. |
| Order Fill Rate | Number | The fulfilled order count divided by the order count. |
| Rejected Shipment Count | Count | Count of all shipments where Was Shipment Reassigned is yes. |
| Rejection Percentage | Number | The rejected shipment count as a percentage of the shipment count. |
| Shipment Count | Count | Count of all shipments. |
| Shipment Fill Rate | Number | The fulfilled shipment count divided by the shipment count. |
| Total Fulfilled Line Item Subtotal | Sum | Sum of line item subtotal for all shipments where the shipment status is fulfilled. |
| Total Fulfilled Line Item Tax Total | Sum | Sum of line item tax total for all shipments where the shipment status is fulfilled. |
| Total Fulfilled Line Item Total | Sum | Sum of line item total for all shipments where the shipment status is fulfilled. |
| Total Fulfilled Shipment Adjustment | Sum | Total shipment adjustment for all shipments where the shipment status is fulfilled. |
| Total Fulfilled Shipping Adjustment | Sum | Total shipping adjustment for all shipments where the shipment status is fulfilled. |
| Total Fulfilled Shipping Tax Adjustment | Sum | Total shipping tax adjustment for all shipments where the shipment status is fulfilled. |
| Total Fulfilled Shipping Total | Sum | Sum of shipping total for all shipments where the shipment status is fulfilled. |
| Total Line Item Subtotal | Sum | Sum of line item subtotal for all shipments. |
| Total Line Item Tax Total | Sum | Sum of line item tax total for all shipments. |
| Total Line Item Total | Sum | Sum of line item total for all shipments. |
| Total Shipment Adjustment | Sum | Total shipment adjustment for all shipments. |
| Total Shipment Collected | Sum | Sum of total for all shipments where the order payment status is Collected. |
| Total Shipment Total | Sum | Sum of total for all shipments. |
| Total Shipping Adjustment | Sum | Total shipping adjustment for all shipments. |
| Total Shipping Tax Adjustment | Sum | Total shipping tax adjustment for all shipments. |
| Total Shipping Total | Sum | Sum of shipping total for all shipments. |
The dimensions included in this view are:
| Name | Data Type | Description |
|---|---|---|
| Customer Email | String | Email address provided by the user when submitting the order. |
| Days Since Ready For Pickup | Number | The number of days elapsed since the ready for pickup date. |
| External Order ID | String | Unique identifier used by an external program to identify a Kibo order. |
| Fulfillment Status | String | The current fulfillment status of the order, which is Fulfilled, NotFulfilled, or PartiallyFulfilled. The order is considered fulfilled when all packages or shipments are shipped or all pickups are picked up. |
| Is Express | Yes/No | Whether or not locations that support express shipping should be filtered. |
| Is Order Created Date In Year-Over-Year Range | Yes/No | Will be yes if the order created date falls in the selected date range or in the same dates one year previous. |
| Is Shipment Created Date In Year-Over-Year Range | Yes/No | Will be yes if the shipment created date falls in the selected date range or in the same dates one year previous. |
| Line Item Subtotal | Number | Estimated amount of the line item without sales tax, shipping costs, and other fees. |
| Line Item Tax Total | Number | The total monetary sum of tax for line items. |
| Line Item Total | Number | The monetary estimated total amount including items, sales tax, shipping costs, and other fees. |
| Location Code | String | The unique user-defined code that identifies the location where the products are fulfilled. |
| Modified Reason Code | String | The explanation of why the shipment is being reassigned. |
| Order Created Date | Datetime | The timestamp of the date and time the order was create. |
| Order ID | String | Internal unique identifier of the order. |
| Order Number | String | Storefront identifier of the order. |
| Order Payment Status | String | The payment status on the associated order. Possible values include: Credited, Errored, Paid, Pending, Unpaid, or Voided. |
| Order Submitted Date | Datetime | The date and time the order was submitted. |
| Order Updated Date | Datetime | The timestamp of the date and time the order was most recently updated. |
| Ready For Pickup | Yes/No | Value will be yes once a shipment is ready to be picked up. |
| Ready For Pickup Date | Datetime | The date and time that a shipment was ready to be picked up. |
| Reassignment Reason | String | The explanation of why the shipment is being reassigned. |
| Shipment Adjustment | Number | The amount of the shipment-level adjustment. |
| Shipment Created Date | Datetime | The timestamp of the date and time the shipment was created. |
| Shipment Created Month | String | Three character textual abbreviation for the month when the shipment was created (e.g., JAN). |
| Shipment Created Month (Numeric) | Number | Two digit number representing the month when the shipment was created (e.g., 01). |
| Shipment Created Week Of The Year | Number | Two digit number representing the week of the year when the shipment was created (e.g., 01). |
| Shipment Currency Code | String | Represents the currency used for the shipment. |
| Shipment Fulfillment Date | Datetime | The date and time when a shipment was fulfilled. |
| Shipment Method Code | String | The code associated with a carrier's shipping method service type used during fulfillment of shipments. Service type codes include a prefix that indicates the carrier. For example: FEDEX_INTERNATIONAL_STANDARD and UPS_GROUND. |
| Shipment Method Name | String | The carrier-supplied name for the shipping service type, such as UPS Ground or 2nd Day Air. |
| Shipment Number | String | Storefront identifier of the shipment. |
| Shipment Status | String | The current status of the shipment. Possible values include: Canceled, Customer Care, Fulfilled, Ready, or Reassigned. |
| Shipment Type Code | String | The abbreviation used to represent a type of shipment workflow such as STH or BOPIS. |
| Shipment Type Name | String | The descriptive name for a shipment workflow such as Ship To Home. |
| Shipment Updated Date | Datetime | The timestamp of the date and time the shipment was most recently updated. |
| Shipping Adjustment | Number | The amount of the adjustment to the shipping amount. |
| Shipping Tax Adjustment | Number | The calculated tax on the shipping adjustment. |
| Shipping Total | Number | The calculated total shipping amount estimated including tax. |
| Site ID | Number | Unique identifier for the site. This ID is used at all levels of a store and catalog to associate objects to a site. |
| Site Name | String | The human readable name for the site associated with the Site ID. |
| Subtotal | Number | Estimated amount of the items without sales tax, shipping costs, and other fees. |
| Tax Total | Number | The total amount of calculated tax. |
| Total | Number | The total monetary amount including items, sales tax, shipping costs, and other fees. |
| Was Shipment Reassigned | Yes/No | Returns yes if a shipment was reassigned during fulfillment. |
| YoY Previous Year Order Created End Date | Datetime | The end of the date range from YoY Order Created Date. |
| YoY Previous Year Order Created Start Date | Datetime | The beginning of the date range from YoY Order Created Date. |
| YoY Previous Year Shipment Created End Date | Datetime | The end of the date range from YoY Shipment Created Date. |
| YoY Previous Year Shipment Created Start Date | Datetime | The beginning of the date range from YoY Shipment Created Date. |