Shipment View - Kibo Documentation

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.