Promotion Data Subject Areas

Promotion Insights—Evaluate the performance of your B2C Commerce promotions. For example, identify your top-three promotions by customer registration type, look for correlations with promotion classes and source codes, or visualize the link between promotion class and revenue.

Attribute (Dimension) Description
Order Placed Date Calendar date when a customer places an order
Site Name Name of the site where a customer places an order
Order Channel Channel from where an order originates Channels include Storefront, Endless Aisle, and Customer Service Center.
Business Channel Business channel from where an order originates The business channels are B2C or B2B.
Device Type Device type used to place an order
Customer Type

Customer type: New or Returning

Returning customers have placed one or more registered orders.

Customer Registration

Site registration status of a customer

  • Registered–Customers who placed an order with a registered account
  • Unregistered–Customers who placed an order without using a registered account
Local Code Site locale code
Local Name Site locale name
Realm Currency Reporting currency used for all currency measures
Product ID Product ID
Product Name Product name
Product Bundle True if the product is a product bundle
Base Product True if the product is a base product
SKU ID Product SKU ID
SKU Name Product SKU name
Promotion ID Promotion ID
Promotion Name Promotion name
Promotion Class

Promotion class

The class includes Order, Product, and Shipping

Campaign ID Campaign ID
Coupon ID Coupon ID
Metric (Measure) Description Type
Units Sold Number of units sold This metric is available only at an individual promo level. Due to double counting, it can’t be aggregated. Units
Revenue Impact

Value of goods and services discounted by the promotion

  • Product class promotions Revenue is calculated using the value of the goods and services that the promotion applies to.
  • Order and shipping class promotions Revenue is calculated using the value of the order.
Note
Note When a shopper applies multiple promotions to an order, the value of the affected goods and services is prorated uniformly between the promotions. Prorating prevents the same revenue from being attributed to more than one promotion.
Currency
Orders Placed

Total number of orders

This metric is available only at an individual promo level. Due to double counting, it can’t be aggregated.

Units
Uses Number of times shoppers use a promotion Count
Promotional Order Discounts Sum of all order class promotion discounts Currency
Promotional Shipping Discounts Sum of all shipping class promotion discounts Currency
Promotional Product Discounts Sum of all product class promotion discounts Currency