Order Discount View

The Order Discount view provides dimensions and measures for discounts that have been applied to orders.

The measures calculated by this view are as follows:

Name Measure Type Description
Average Impact Average The average of impact for all orders.
Average Order Value Number The total collected divided by the valid order count.
Discounted Orders Count Count (Distinct) The count of all orders with a discount applied.
Order Discount Count Count The count of all discounts applied to orders.
Total Impact Sum The sum of impact for all orders.
Total Order Subtotal Sum (Distinct) The sum of order subtotal for all orders.

The dimensions included in this view are:

Name Data Type Description
Coupon Code String The coupon code that a shopper uses to redeem an associated discount on a purchase.
Coupon Set ID String Internal unique identifier of the coupon set with which the applied discount is associated.
Discount ID String Internal unique identifier of the discount.
Discount Level String Whether the discount was applied to an order or to an order item.
Discount Name String The user supplied name for the discount.
Discount Type String Whether the discount is applied to shipping, product, or order.
Impact Number The currency amount of the discount applied to the order.
Order Created Date Datetime The timestamp of the date and time the order was created.
Order ID String Internal unique identifier of the order.
Order Status String The current status of the order such as "Abandoned," "Accepted," "Cancelled," "Completed," "Errored," "Pending," "PendingReview," "Processing," or "Validated."
Order Total Number Order total after discount applied to the order.
Order Updated Date Datetime The timestamp of the date and time the order was most recently updated.
Reporting Currency Code String Currency in which monetary amounts are displayed in reporting.
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.
Transactional Currency Code String The currency in which the original transaction took place.