Shipment View

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.