Promotions Dashboard Metric Definitions

Use the Promotions Dashboard to evaluate promotion performance or individual promotion results. The Promotions Dashboard shows you reports on the Most Used Promotions, Total Promotion Discount, Promotion Combination, the Average Order Discount, Used by Promotion Class and Revenue Impact by Promotion Discount.

Business Metrics

Each Section of the promotions dashboard tracks a mix of business metrics that are displayed as dashboard attributes.

This table describes the metrics for the Promotions dashboard.

Metric Description
Uses The number of times a promotion applies a discount to orders.

If a promotion allows for more than one application in an order, The reported uses can include multiple applications of that promotion in a single order.

For example, a product class promotion counts for two uses in a single order when the order contains two different products that both qualify for the promotion. If the two products are the same SKU, and they appear as a single line item in the order, the promotion is only applied once, to the line item, and is reported as one use.

Discount The amount of discount applied by the promotion.
Total Promotion Discount

The sum of all discounts applied to all orders. Applied discounts include automated product, order, and shipping discounts, and manual price adjustments. For example, a discount offered by a customer service agent.

Average Total Promotion Discount Shown as a daily average. The average of all discounts applied to orders created in the selected time period. For example, the daily average for the past seven days is calculated as:Total Promotion Discount / 7
Promotion Combination Frequency The percentage of all orders to which the same two promotions are applied.
Average Order Discount The average discount applied to orders.

For example,

Discount applied to all orders / Number of orders
Most Used Coupons

The number of times a coupon is combined with a promotion as the promotion qualifier, and is applied to an order.

Note: The metric reports on promotion uses when the coupon was the qualifier and not coupon redemptions.
Revenue Impact The value of goods and services discounted by the promotion.
  • Product Class Promotions

    Revenue for product class promotions is calculated using the value of the goods and services the promotion is applied to.

  • Order and Shipping Class Promotions

    Revenue for order and shipping class promotions is calculated using the value of the order.

Note: When multiple promotions are applied to an order, the value of the affected goods and services is prorated uniformly between those promotions, ensuring the same revenue is not attributed to more than one promotion.

Promotions Detail

This table describes the supporting metrics for the Promotion Detail dashboard.

Metric Description
Uses

The number of times a promotion applies a discount to orders.

If a promotion allows for more than one application in an order, The reported uses can include multiple applications of that promotion in a single order.

For example, a product class promotion counts for two uses in a single order when the order contains two different products that both qualify for the promotion. If the two products are the same SKU, and they appear as a single line item in the order, the promotion is only applied once, to the line item, and is reported as one use.

Number of Orders

The number of orders that received a discount from the promotion.

Number of Units

The number of product or service units discounted by the promotion. The number of units for Product class promotions is the sum of the units to which the promotion is applied. The number of Order and shipping class promotions is the sum of units in the order to which the promotion is applied.

Note: If the order contains two or more units of the same SKU listed as one line item, all the units are attributed to the product promotion even if only one was discounted. For example, a BOGO promotion
Average Unit Revenue The average revenue generated per unit. Calculated as: Revenue Impact / Number of Units
Average Unit Discount The average unit discount applied by the promotion. Calculated as: Total Promotion Discount / Number of Units
Total Promotion Discount The sum of all the promotion discounts applied to orders.
Average Promotion Discount The average daily discount applied by the promotion to orders. Calculated as: Total Promotion Discount / Number of Days in Selected Time Period
Top Products Using the Promotion The products and services to which the promotion is most often applied.
  • Product Class Promotions

    Reports the products and services to which the promotion is most often applied.

  • Order and Shipping Class Promotions

    Reports the product and services most often included in orders to which the promotion is applied.

Co-Promotion Frequency The percentage of orders to which the promotion was applied and the second (listed) promotion was also applied.
Revenue Impact The value of goods and services discounted by the promotion.
  • Product Class Promotions

    Revenue for product class promotions is calculated using the value of the goods and services the promotion is applied to.

  • Order and Shipping Class Promotions

    Revenue for order and shipping class promotions is calculated using the value of the order.

Note: When multiple promotions are applied to an order, the value of the affected goods and services is prorated uniformly between those promotions, ensuring the same revenue is not attributed to more than one promotion.

Source Code

This table describes the metrics for the Promotions Source Code dashboard.

Metric Description
Activations The number of times the source code group was activated. A source code group is activated when the site is accessed using a source code from that group.
Orders The number of orders created with this source code group.
Merchandise Total The merchandise value from orders created with this source code group.
Average Merchandise Total per Usage The average merchandise value per source code activation. Calculated as: Merchandise Total / Activations.
Average Merchandise Total per Order The average merchandise value per source code order. Calculated as: Merchandise Total / Orders.
Items Per Order The average number of items per source code order.
Order Conversion The conversion rate of the source code group. Calculated as: Orders / Activations.
Active Source Code A source code enabled and scheduled at the time of the activation. For example, live source code is activated.
Inactive Source Code A source code that was disabled or not scheduled at the time of the activation. For example inactive source code is not activated.
Invalid Source Code A source code that was referenced in the source code parameter of the URL, but does not exist in Business Manager.

Conversions

This table describes the promotion summary metrics for the Promotions Conversions dashboard.

Metric Description
Visits Visits with at least one promotion of specified promotion class applied.
Orders An order with more than one class of promotion applied is tracked under each applicable class. An order with more than one promotion of a single class applied is still tracked as one order under the applicable class.
Order Conv Number of Orders / Number of Visits
Merch Total Total value of merchandise (excluding tax and shipping) of all orders to which the promotion class is applied.
Avg Merch Total per Order Merchandise Total / Number of Orders
Avg Merch Total Per Visit Merchandise Total / Number of Visits
Items per Order Average number of items across all orders to which the promotion class was applied.
Promo Merch Total Promotional Merchandise Total: Total value of merchandise (excluding tax and shipping) discounted by all promotions by promotion class. The value of any merchandise discounted by promotions from more than one class is tracked under each applicable class.
Avg Promo Merch per Order Promotional Merchandise Total / Number of Orders
Avg Merch per Visit Promotional Merchandise Total / Number of Visits
Shipping Total Total value of shipping from all orders to which the promotion class was applied.
Discount Total Total discount value applied to orders by promotion class.
Avg Disc per Order Discount Total / Number of Orders
Avg Disc per Visit Discount Total / Number of Visits
Avg Promo Items per Order Average number of items discounted by promotion class.

This table describes the promotion details metrics for the Promotions Conversions dashboard.

Metric Label Description
Campaign ID The campaign ID
Site The site selected in the dashboard filters.
Promotion ID The promotion ID
Visits A promotion visit is tracked when the promotional discount is activated and is dependent on the setup of the promotion and its qualifiers.
Orders Total number of orders placed with the promotion and campaign. A single order with multiple promotions is tracked against each applicable promotion.
Order Conv Number of Orders / Number of Visits
Merch Total Total value of merchandise excluding tax and shipping of all orders placed with the promotion and campaign. Hover over # Orders definition for details.
Avg Merch Total per Order Merchandise Total / Total Orders
Items per Order Average number of items across all orders placed with the promotion and campaign.
Promo Merch Total Promotional Merchandise Total: Total value of merchandise (excluding tax) discounted by the promotion and campaign. The value of any merchandise discounted by more than one promotion is tracked on each promotion.
Discount Total Total discount value applied to orders by the promotion and campaign.

Promotion Dashoard and CSV File Metrics

These tables show the relationship between the Promotion dashboard report metrics and the date points listed their corresponding CSV file downloads.

Most Used Promotions and most_used_promotions_by_date <date>.csv

Report Metric CSV Data Point
Promotion ID npromotionId
Class promotionClass
Uses uses
Discount std_totalDiscount–when filtered by realm.

ste_totalDiscount–when filtered by sites.

Device deviceType–when By Device Type is selected from the dropdown.
Customer registerd–Registration–when By Customer Registration is selected from the dropdown.
Customer firstTimeBuyer–when By Customer is selected from the dropdown.
Channel channel–when By Channel is selected from the dropdown.
  site–when By Site is selected from the dropdown.

Total Promotion Discount and total_promotion_discount.csv

Report Metric CSV Data Point
Total Promotion Discount std_totalDiscount–when filtered by realm.

ste_totalDiscount–when filitered by site.

Total

Order

Product

Shipping

Unknown

promotionClass
Average Discount std_averageOrderDiscount–when filtered by realm.

ste_averageOrderDiscount–when filtered by site.

Total Discount std_totalDiscount–when filtered by realm.

ste_totalDiscount–when filtered by site.

Most Used Coupons and most_used_coupons.csv

Report Metric CSV Data Point
Coupon ID couponId
Promotion ID promotionId
Uses uses

Promotion Combination and combination_frequency.csv

Report Metric CSV Data Point
Promotion ID promotionOneName

promotionTwoName

Class promotionOneClass

promotionTwoClass

Frequency combinationFrequencyRatio

Average Order Discount and total_promotion_discount.csv

Report Metric CSV Data Point
Average Order Discount ste_averageOrderDiscount-when filtered by realm.

ste_averageOrderDiscount-when filtered by site.

Used by Promotion Class and uses_by_promotion_class.csv

Report Metric CSV Data Point
Order usesRatio
Product UsesRatio
Shipping UsesRatio

Revenue Impact By Promotion Discount and revenue_impact_by_discount.csv

Report Metric CSV Data Point
Promotion npromotionId
Class PromotionClass
Revenue std_revenue–when filtered by realm.

ste_revenue–when filtered by site.

Discount std_totalDiscount–when filtered by realm.

ste_totalDiscount–when filtered by site.

Promotions Details

Total Promotions Discount and promotions-promotion-most-purchased-products.csv

Report Metric CSV Data Point
Total Promotion Discount std_totalDiscount–when filtered by realm.

ste_totalDiscount–when filtered by site.

Co-Promotion Frequency and promotions-promotion-co-use-confindence.csv

Report Metric CSV Data Point
ID promotionTwoId
Class promtionTwoClass
Frequency confidenceRatio

Revenue Impact and CVS promotions-promotion-most-purchased-products.csv

Report Metric CSV Data Point
Total Revenue std_totalRevenue-when filterd by realm.

ste_totalRevenue–when filtered by site.

Average Revenue std_avgUnitRevenue–when filtered by realm.

ste_avgUnitRevenue–when filtered by site.

Top Products Using the Promotion and promotions-promotion-most-purchased-products.csv

Report Metric CSV Data Point
Id nproductID
Name ProductDisplayName
Units unitsPurcahsed
Revenue std_revenue–when filtered by realm.

ste_revenue–when filtered by site.

Discount std_discount–when filtered by realm.

ste_discount–when filtered by site.

Average Promotion Discount and promotions-promotion-most-purchased-products.csv

Note: Average Promotions Discount and Top Products Using the Promotion generate CSV files with the same name. However, these two files are populated with different data sets and are not identical.
Report Metric CSV Data Point
Average Promotion Discount std_averageUnitDiscount–when filtered by realm.

ste_averageUnitDiscount–when filtered by site.

Promotions Source Code Dashboard

Source Code Activations and source-code_groups.csv

Report Metric CSV Data Point
Active Source Codes status

activations

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Inactive Source Codes status

orders

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Invalid Source Codes activations

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Source Code Orders and source-code_groups.csv

Report Metric CSV Data Point
Active Source Codes status

activations

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Inactive Source Codes status

orders

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Invalid Source Codes activations

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Source Code Order Conversion Results and source-code_groups.csv

Report Metric CSV Data Point
Active Source Codes status

activations

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Inactive Source Codes status

orders

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Invalid Source Codes activations

std_revenue–when filtered by realm

ste_revenue–when filtered by site

Conversion of Source Codes–Activ, Inactive, Invalid and source-code_groups

Report Metric CSV Data Point
Group group
Site site
Orders orders
Merchandise Total std_revenue–when filtered by realm.

ste_revenue–when filtered by site.

Average Merchandise Per Usage activations

std_revenue–when filtered by realm.

ste_revenue–when filtered by site.

Average Merchandise Total Per Order orders

std_revenue–when filtered by realm.

ste_revenue–when filtered by site.

Items Per Order orders

units

Order Conversion activations

orders

Promotion Conversion Dashboard

Conversion Rate and promotions-conversion-by.csv

Report Metric CSV Data Point
Conversion Rate date

promotion_type

promotion_conversion_rate

Conversion Summary and promotion-conversion-summary.csv

Report Metric CSV Data Point
Visits visits
Orders orders
Order Conversion orders

visits

Merchandise Total std_merch_total–when filtered for realm.

ste_merch_total–when filtered for site.

Average Merchandise Total Per Order order

std_merch_total–when filtered for realm.

ste_merch_total–when filtered for site.

Average Merchandise Total Per Visit visits

std_merch_total–when filtered for realm.

ste_merch_total–when filtered for site.

Items Per Order orders

units

Promo Merchandise Total std_promo_impacted_merchandise_value–when filtered by realm.

ste_promo_impacted_merchandise_value–when filtered by site.

Average Promo Merchandise Per Order order

std_merch_total–when filtered for realm.

ste_merch_total–when filtered for site.

Average Promo Merchandise Per Visit visit

std_merch_total–when filtered for realm.

ste_merch_total–when filtered for site.

Shipping Total std_total_shipping–when filtered for realm.

ste_total_shipping–when filtered for site.

Discount Total std_total_discount–when filtered for realm.

ste_total_dicsount–when filtered for site.

Average Discount Per Order Orders

std_total_discount–when filtered for realm.

ste_total_discount–when filtered for site.

Average Discount Per Visit visits

std_total discount–when filtered by realm.

ste_total_discount–when filtered by site.

Average Promotion Items Per Order orders

promo_impacted_units

Conversion Detailsz-Orders, Product, Shipping, Unknown and promotion-conversion-by-promotion.csv

Report Metric CSV Data Point
Campaign ID campaign_Id
Site site
Promotion ID promotion_Id
Visits visits_with_promotion_count
Orders orders_with_promotin_count
Order Conversion visits_with_promotion_count

orders_with_promotion_count

Merchandise Total std_order_net–when filter for realm.

ste_order_netz-when filtered for site.

Average Merchandise Total Per Order Orders

std_order_net–when filtered for realm.

ste_order_net–when filtered for site.

Items Per Order units_per_order
Promo Merchandise Total std_revenue–when filtered for realm

ste_revenue–when filtered for site.

Discount Total std_discount–when filtered for realm.

ste_discount–when filtered for site.