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