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.

Catalog

Customers

B2B

Fulfillment

Inventory

Locations

Marketing

Orders

Publishing

Order Routing

Reporting

Search

Subscriptions

System

Call Center

Content

Import/Export