Let's look at a Promotions Manager Summary Report for two promotions. Both promotions ran from 9/5 to 9/10.
The first promotion is a Buy 1, Get 2 at 50% Off promotion.
Three sales were made during the promotion period, however only Item 3 triggered a discount during the promotion:
Item |
Price |
Sale Date |
Qty Sold |
Total Revenue |
---|---|---|---|---|
Item 1 | $2 | 9/1 | 1 | $2 |
Item 2 | $2 | 9/6 | 1 | $2 |
Item 3 | $2 | 9/10 | 2 | $1.50 |
Item 4 | $12 | 9/10 | 1 | $12 |
The second promotion is a Spend $10, Get $5 Off promotion.
There were two sales during this promotion period but only Item 6 triggered a promotional discount:
Item |
Price |
Sale Date |
Qty Sold |
Total Revenue |
---|---|---|---|---|
Item 5 | $6 | 9/2 | 3 | $18 |
Item 6 | $6 | 9/5 | 3 | $13 |
Item 7 | $6 | 9/9 | 1 | $6 |
Promotion Summary Report results
The sections below show how the baseSale, promotionSale, and precentageSalesLift values are calculated in the Summary Report.
Base Sale calculation
The baseSale value for the two promotions is $20.00
, which is the total revenue from all the sales that did not trigger the promotion during the report period.
Item |
Price |
Sale Date |
Qty Sold |
Total Revenue |
Notes |
---|---|---|---|---|---|
Item 1 | $2 | 9/1 | 1 | Not counted - out of promotion period | |
Item 2 | $2 | 9/6 | 1 | $2 | |
Item 3 | $2 | 9/10 | 2 | Not counted - triggered promotion | |
Item 4 | $12 | 9/10 | 1 | $12 | |
Item 5 | $6 | 9/2 | 3 | Not counted - out of promotion period | |
Item 6 | $6 | 9/5 | 3 | Not counted - triggered promotion | |
Item 7 | $6 | 9/9 | 1 | $6 | |
$20.00 |
Promotion Sale calculation
The promotionSale value is $14.50
, which is the total revenue from all the sales that triggered the promotion during the report period.
Item |
Price |
Sale Date |
Qty Sold |
Total Revenue |
Notes |
---|---|---|---|---|---|
Item 1 | $2 | 9/1 | 1 | Not counted - out of promotion period | |
Item 2 | $2 | 9/6 | 1 | Not counted - did not trigger promotion | |
Item 3 | $2 | 9/10 | 2 | $1.50 | |
Item 4 | $12 | 9/10 | 1 | Not counted - did not trigger promotion | |
Item 5 | $6 | 9/2 | 3 | Not counted - out of promotion period | |
Item 6 | $6 | 9/5 | 3 | $13 | |
Item 7 | $6 | 9/9 | 1 | Not counted - did not trigger promotion | |
$14.50 |
Percentage Sales Lift calculation
The precentageSalesLift represents the percentage of the total dollar amount gained due to promotions, which is calculated as follows:
precentageSalesLift = promotionSale / (baseSale + promotionSale)
In this example, the precentageSalesLift is 42%
during the report period:
precentageSalesLift = $14.50 / ($20.00 + $14.50) = 42.03%