Versions Compared

Old Version 1

changes.mady.by.user Brian Au

Saved on

compared with

New Version 2

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 Time-frame Promotion report: Omni-channel Reports > Report Dashboard > All reports > Sales reports > Sales by Promotion or Omni-channel Reports > Sales → Sales by Promotion

...

Columns that are shown by default

Coupon

  • The name of the Coupon.

  • Shown when Report by = "Coupon"

Rules Name

  • The name of the price rule (cart price rule or catalog price rule).

  • Shown when Report by = "Cart price rule" or "Catalog price rule".

Type of Discount

  • The type of discount of this coupon/cart price rule/catalog price rule.

Customer Group

  • The customer group can apply this coupon/cart price rule/catalog price rule.

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

Number of Orders

  • The number of orders applied this coupon/cart price rule/catalog price rule 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/cart price rule/catalog price rule 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.

Columns that are hidden by default

Subtotal

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

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

  • This column is hidden by default.

Tax

  • The total 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.

  • This column is hidden by default.

Shipping

  • The total Shipping fee 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.

  • This column is hidden by default.

Discount

  • The total Discounts 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.

  • This column is hidden by default.

Invoiced

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

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

  • This column is hidden by default.

Qty Invoiced

  • The qty of items that has been invoiced of all orders applied this coupon/cart price rule/catalog price rule during the selected report period.

  • Note: For bundle item, calculate by its child products.

  • This column is hidden by default.

Qty Refunded

  • The qty of items that has been refunded of all orders applied this coupon/cart price rule/catalog price rule during the selected report period.

  • Note: For bundle item, calculate by its child products.

  • This column is hidden by default.

Revenue (incl. Tax)

  • The total revenue including 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 - Shipping.

  • This column is hidden by default.

COGS

  • The total cost recorded in the invoice 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.

  • COGS = Total Cost recorded when invoiced - (Total Cost recorded when invoiced / Unit Invoiced * Qty Refunded). Note: The calculation is for each product in each order.

  • This column is hidden by default.

Profit

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

  • Profit = Revenue (excl. Tax) - COGS.

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

  • This column is hidden by default.

Margin (%)

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

  • Margin (%) = Profit / Revenue (excl. Tax) * 100%.

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

  • This column is hidden by default.

Start Date

  • The date this coupon/cart price rule/catalog price rule started to be applied.

  • The column is hidden by default.

End Date

  • The date this coupon/cart price rule/catalog price rule stop being applied.

  • The column is hidden by default.

II/ Filter Report Data

III/ Chart

...