...
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 | |
End Date | |
II/ Filter Report Data
On this report, you can filter by Counpon (when Report by = Coupon), Rules Name (when Report by != Coupon), Subtotal, Grand Total, Revenue (excl. Tax), Average Order Value
III/ Chart
In this chart, you can compare the data of each metric in the Report by selecting the value through the Select Metrics dropdown including (Number of Orders, Discounted by Coupon (only show when Report by = Coupon), Subtotal, Discount, Grand Total, Refunded, Revenue (excl. Tax), Average Order Value, COGS, Profit ).