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:
|The average of impact for all orders.
|Average Order Value
|The total collected divided by the valid order count.
|Discounted Orders Count
|The count of all orders with a discount applied.
|Order Discount Count
|The count of all discounts applied to orders.
|The sum of impact for all orders.
|Total Order Subtotal
|The sum of order subtotal for all orders.
The dimensions included in this view are:
|The coupon code that a shopper uses to redeem an associated discount on a purchase.
|Coupon Set ID
|Internal unique identifier of the coupon set with which the applied discount is associated.
|Internal unique identifier of the discount.
|Whether the discount was applied to an order or to an order item.
|The user supplied name for the discount.
|Whether the discount is applied to shipping, product, or order.
|The currency amount of the discount applied to the order.
|Order Created Date
|The timestamp of the date and time the order was created.
|Internal unique identifier of the order.
|The current status of the order such as "Abandoned," "Accepted," "Cancelled," "Completed," "Errored," "Pending," "PendingReview," "Processing," or "Validated."
|Order total after discount applied to the order.
|Order Updated Date
|The timestamp of the date and time the order was most recently updated.
|Reporting Currency Code
|Currency in which monetary amounts are displayed in reporting.
|Unique identifier for the site. This ID is used at all levels of a store and catalog to associate objects to a site.
|The human readable name for the site associated with the Site ID.
|Transactional Currency Code
|The currency in which the original transaction took place.