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. |