--- schema_version: "1" id: ac3fc3e17602f6b5fbc288aec5d4df443b5dfc03d1e154258bde9341a38914ec title: Promotions Dashboard Metric Definitions collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_reports_dashboards_metric_definitions_promotions.md canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_reports_dashboards_metric_definitions_promotions.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: a2395441dd31a63178cfb5fb9a1052c7623d14f7b75bbc712a0dad9cb5add176 description: Use the B2C Commerce Reports & Dashboards 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. products: - Commerce - B2C Commerce release: "264" --- # Promotions Dashboard Metric Definitions Use the B2C Commerce Reports & Dashboards 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 and displays them 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 combines with a promotion as the promotion qualifier, and applies 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 applies 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 apply to an order, the value of the affected goods and services is prorated uniformly between those promotions, ensuring the same revenue isn’t 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 the system reports it 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 applies. The number of Order and shipping class promotions is the sum of units in the order to which the promotion applies. Note If the order contains two or more units of the same SKU listed as one line item, the system attributes all the units to the product promotion even if only one was discounted. For example, a buy one get one (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 the promotion most often applies to. Product Class Promotions Reports the products and services the promotion most often applies to. Order and Shipping Class Promotions Reports the product and services most often included in orders to which the promotion applies.
Co-Promotion Frequency	The percentage of orders where the promotion applied and the second (listed) promotion 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 applies 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 apply to an order, the value of the affected goods and services is prorated uniformly between those promotions, ensuring the same revenue is attributed to more than one promotion.

## Source Code Thisn’t table describes the metrics for the Promotions Source Code dashboard. | Metric | Description | | --- | --- | | Activations | The number of times the source code group activated. A source code group activates 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 activates. | | Inactive Source Code | A source code that was disabled or not scheduled at the time of the activation. For example inactive source code is activated. | | Invalid Source Code | A source code that was referenced in the source code parameter of the URL, but doesn’t exisn’tt 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 applies. | | 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 where the promotion class 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 where the promotion class 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. The system tracks a single order with multiple promotions 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 .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 the user selects By Device Type from the dropdown.
Customer	registerd–Registration–when the user selects By Customer Registration from the dropdown.
Customer	firstTimeBuyer–when the user selects By Customer from the dropdown.
Channel	channel–when the user selects By Channel from the dropdown.
	site–when the user selects By Site 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

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.

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.

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.

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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/images/icon_note.png) Note Average Promotions Discount and Top Products Using the Promotion generate CSV files with the same name. However, these two files contain 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.

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

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

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

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

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