Order View

The Order view details information about orders made on your sites.

The supported filters that can be applied to this view are:

Name Data Type Description
YoY Order Created Date Date 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 Adjustment Amount Average The average of adjustment amount for all orders.
Average Amount Remaining For Payment Average The average of amount remaining for payment for all orders.
Average Discount Total Average The average of discount total for all orders.
Average Discounted Subtotal Average The average of discounted subtotal for all orders.
Average Discounted Total Average The average of discounted total for all orders.
Average Duty Amount Average The average of duty amount for all orders.
Average Duty Total Average The average of duty total amount for all orders.
Average Fee Total Average The average of fee total for all orders.
Average Handling Amount Average The average of handling amount for all orders.
Average Handling Subtotal Average The average of handling subtotal for all orders.
Average Handling Total Average The average of handling total for all orders.
Average Item Tax Total Average The average of item tax total for all orders.
Average Line Item Subtotal With Order Adjustments Average The average of line item subtotal with order adjustments amount for all orders.
Average Order Total Average The average of order total for all orders.
Average Order Value Average The total order total divided by the valid order count.
Average Shipping Subtotal Average The average of shipping subtotal amount for all orders.
Average Shipping Tax Total Average The average of shipping tax total for all orders.
Average Shipping Total Average The average of shipping total for all orders.
Average Tax Total Average The average of tax total for all orders.
Average Total Collected Average The average of total collected amount for all orders.
Average Valid Order Total Average The average of order total for all orders where valid order status is yes.
Average Valid Subtotal Average The average of order subtotal for all orders where valid order status is yes.
Distinct Date Count Count (Distinct) The count of distinct order created dates.
Fulfilled Valid Order Count Count The count of orders where valid order status is yes and fulfillment status is fulfilled.
Order Count Count The count of all orders.
Paid Valid Order Count Count The count of orders where valid order status is yes and payment status is paid.
Total Adjustment Amount Sum The sum of adjustment amount for all orders.
Total Amount Remaining For Payment Sum The sum of amount remaining for payment for all orders.
Total Discount Total Sum The sum of discount total for all orders.
Total Discounted Subtotal Sum The sum of discounted subtotal for all orders.
Total Discounted Total Sum The sum of discounted total for all orders.
Total Duty Amount Sum The sum of duty amount for all orders.
Total Duty Total Sum The sum of duty total amount for all orders.
Total Fee Total Sum The sum of fee total for all orders.
Total Handling Amount Sum The sum of handling amount for all orders.
Total Handling Subtotal Sum The sum of handling subtotal for all orders.
Total Handling Total Sum The sum of handling total for all orders.
Total Item Tax Total Sum The sum of item tax total for all orders.
Total Line Item Subtotal With Order Adjustments Sum The sum of line item subtotal with order adjustments amount for all orders.
Total Order Total Sum The sum of order total for all orders.
Total Shipping Subtotal Sum The sum of shipping subtotal amount for all orders.
Total Shipping Tax Total Sum The sum of shipping tax total amount for all orders.
Total Shipping Total Sum The sum of shipping total for all orders.
Total Subtotal Sum The sum of subtotal for all orders.
Total Tax Total Sum The sum of tax total for all orders.
Total Total Collected Sum The sum of total collected for all orders.
Total Valid Fee Total Sum The sum of fee total for all orders where valid order status is yes.
Total Valid Subtotal Sum The sum of order subtotal for all orders where valid order status is yes.
Total Valid Order Total Sum The sum of order total for all orders where valid order status is yes.
Total Valid Shipping Total Sum The sum of shipping total for all orders where valid order status is yes.
Total Valid Tax Total Sum The sum of tax total for all orders where valid order status is yes.
Valid Order Count Count (Distinct) The count of orders where valid order status is yes.

The dimensions included in this view are:

Name Data Type Description
Adjustment Amount Number Adjustment amount for an order.
Adjustment Description String Adjustment description for an order.
Amount Remaining For Payment Number Amount remaining for payment for an order.
Billing Address City String City provided in the billing address for the order.
Billing Address Country Code String Country code provided in the billing address for the order.
Billing Address Postal Code String Postal or zip code provided in the billing address for the order.
Billing Address State/Province String State or province provided in the billing address for the order.
Billing Contact Address Address1 String Address1 provided in the billing contact for the order.
Billing Contact Address Address2 String Address2 provided in the billing contact for the order.
Billing Contact Address Address3 String Address3 provided in the billing contact for the order.
Billing Contact Address Address4 String Address4 provided in the billing contact for the order.
Billing Contact Email String Email provided in the billing contact for the order.
Billing Contact First Name String First name provided in the billing contact for the order.
Billing Contact Full Name String First and last name provided in the billing contact for the order.
Billing Contact Last Name String Last name provided in the billing contact for the order.
Billing Contact Middle Name Or Initial String Middle name or initial provided in the billing contact for the order.
Billing Info Custom Credit Type String Custom credit type provided in the billing information for the order.
Billing Info External Transaction ID String External transaction id provided in the billing information for the order.
Billing Payment Or Card Type String Payment or card type provided in the billing information for the order.
Cancelled Date Datetime Date when the order was cancelled.
Channel Code String Code that identifies the channel associated with the site for the shopper’s order.
Closed Date Datetime Date when the order was closed. A closed order is an order that has been processed and the items shipped.
Customer Email String Email address provided by the user when submitting the order.
Customer Interaction Type String The type of customer interaction used to create the order. Possible values are Website, Call, Store, or Unknown.
Customer User ID String Unique identifier of the customer account. If the shopper user is anonymous, the user ID represents a system-generated user ID string.
Discount Total Number Amount of discounts applied to all items in the order.
Discounted Subtotal Number The subtotal after discounts are applied.
Discounted Total Number Discounted total for an order.
Duty Amount Number Duty amount for an order.
Duty Total Number Duty total for an order.
External Order ID String Unique identifier used by an external program to identify a Kibo order.
Fee Total Number The monetary sum of all fees incurred in the 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.
Handling Amount Number Handling amount for an order.
Handling Subtotal Number Handling subtotal for an order.
Handling Total Number Handling total for an order.
Is Date In Year-Over-Year Range Yes/No Returns yes if the YoY Order Created Date falls in the selected date range for the current or previous year.
Is Discounted Yes/No Whether a discount has been applied to this order.
Is Unified Yes/No If yes, then the order was placed on the Kibo Composable Commerce Platform.
Item Tax Total Number The total amount of calculated tax for items in the order.
Line Item Subtotal With Order Adjustments Number Line item subtotal with order adjustments for an order.
Location Code String The unique user-defined code that identifies the location where the order was entered.
Opted In For SMS Yes/No If yes, the customer opted in for SMS.
Order Accepted Date Datetime The date and time the order was accepted.
Order Created Date Datetime The timestamp of the date and time the order was created.
Order Created Month String Three character textual abbreviation for the month when the order was created (e.g., JAN).
Order Created Month (Numeric) Number Two digit number representing the month when the order was created (e.g., 01).
Order Created Week Of The Year Number Two digit number representing the week of the year when the order was created (e.g., 01).
Order Status String The current status of the order. Possible values include Abandoned, Accepted, Cancelled, Completed, Errored, Pending, PendingReview, Processing, and Validated.
Order Total Number The total monetary amount of the order including items, sales tax, shipping costs, and other fees.
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.
Parent Return ID String If this order was created to fulfill an item replacement as part of a return merchandise authorization (RMA), the unique identifier of the return.
Payment Status String The status of the payment for the order such as "Credited," "Paid," "Pending," "Unpaid," or "Voided."
Payment Term String The payment term for a purchase order (e.g., net 30) used as payment for the order.
Payment Term Code String Unique identifier that corresponds to the payment term description for a purchase order used as payment for the order.
Purchase Order Number String The storefront identifier of the purchase order used as payment for the order.
Reporting Currency Code String Represents the monetary currency in which monetary amounts are shown.
Return Status String Status of any returns associated with this order after it was completed.
Shipment Method Name String The carrier-supplied name for the shipping service type, such as "UPS Ground" or "2nd Day Air."
Shipping Address Country Code String Country code provided in the shipping address for the order.
Shipping Address Postal Code String Postal or zip code provided in the shipping address for the order.
Shipping Address State/Province String State or province provided in the shipping address for the order.
Shipping Subtotal Number Shipping subtotal for an order.
Shipping Tax Total Number Shipping tax total for an order.
Shipping Total Number The calculated total shipping amount estimated for the order 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.
Source Device String Source device for an order.
Subtotal Number Amount of the order without sales tax, shipping costs, and other fees.
Tax Total Number The total monetary sum of sales tax for an order.
Total Collected Number Total collected for an order.
Transactional Currency Code String The currency used for the original transaction.
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.