Versions Compared

Old Version 9

changes.mady.by.user Brian Au

Saved on

compared with

New Version Current

changes.mady.by.user Brian Au

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. As a store manager, if you want to check which promotion is effective, this report is for you

  2. To access the Sale by Promotion report: Omni-channel Reports > Report Dashboard > All reports > Sales reports > Sales by PromotionCoupon or Omni-channel Reports > Sales → Sales by PromotionCoupon

The Sales by Promotion Report page is displayed with the default view as below:

...

image-20240709-043555.pngImage Added

  1. Report details

On the main page, you can select metrics of the orders you would like to see in the report, based on the information you would like to see, including:

...

Include all the available locations where you use POS. You can select the location to show the data based on the selected location.

...

There are 3 options: Coupon, Cart Price Rule, Catalog Price Rule that you can select to show the data based the selected promotion.

  • Data detail

On this report, there will be 2 types of columns: columns that are shown by default and columns that are hidden by default when you access the report

...

Coupon

  • The name of the Coupon.

  • Shown when Report by = "Coupon"

Type of Discount

  • The type of discount of this coupon

Customer Group

  • The customer group can apply this coupon

  • Each customer group will be shown in a separated row.

Number of Orders

  • The number of orders applied this coupon during the selected report period.

Discounted by Coupon

  • The total Discounts from this coupon during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • Only show when Report = "Coupon".

Grand Total

  • The total Grand Total of all orders applied this coupon during the selected report period.

  • Grand Total = Subtotal + Tax - Discount + Shipping.

  • The currency will follow the Base Currency of the magento site.

Refunded

  • The total Refunded amount of all orders applied this coupon /cart price rule/catalog price rule during the selected report period.

  • The currency will follow the Base Currency of the magento site.

Revenue (excl. Tax)

  • The total revenue excluding the tax of all orders applied this coupon /cart price rule/catalog price rule during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • Revenue (incl. Tax) = Total Paid - Total Refunded - Tax - Shipping.

Average Order Value

  • The average order value applied this coupon /cart price rule/catalog price rule the during the selected report period.

  • Value = Revenue (excl. Tax) / Number of Orders

  • The currency will follow the Base Currency of the magento site.

...