Skip to main content
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:
NameMeasure TypeDescription
Average ImpactAverageThe average of impact for all orders.
Average Order ValueNumberThe total collected divided by the valid order count.
Discounted Orders CountCount (Distinct)The count of all orders with a discount applied.
Order Discount CountCountThe count of all discounts applied to orders.
Total ImpactSumThe sum of impact for all orders.
Total Order SubtotalSum (Distinct)The sum of order subtotal for all orders.
The dimensions included in this view are:
NameData TypeDescription
Coupon CodeStringThe coupon code that a shopper uses to redeem an associated discount on a purchase.
Coupon Set IDStringInternal unique identifier of the coupon set with which the applied discount is associated.
Discount IDStringInternal unique identifier of the discount.
Discount LevelStringWhether the discount was applied to an order or to an order item.
Discount NameStringThe user supplied name for the discount.
Discount TypeStringWhether the discount is applied to shipping, product, or order.
ImpactNumberThe currency amount of the discount applied to the order.
Order Created DateDatetimeThe timestamp of the date and time the order was created.
Order IDStringInternal unique identifier of the order.
Order StatusStringThe current status of the order such as “Abandoned,” “Accepted,” “Cancelled,” “Completed,” “Errored,” “Pending,” “PendingReview,” “Processing,” or “Validated.”
Order TotalNumberOrder total after discount applied to the order.
Order Updated DateDatetimeThe timestamp of the date and time the order was most recently updated.
Reporting Currency CodeStringCurrency in which monetary amounts are displayed in reporting.
Site IDNumberUnique identifier for the site. This ID is used at all levels of a store and catalog to associate objects to a site.
Site NameStringThe human readable name for the site associated with the Site ID.
Transactional Currency CodeStringThe currency in which the original transaction took place.