...
Qty Refunded | The qty of items that has been refunded of all orders of this country 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 of this country 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.
|
% Total Revenue | |
COGS | The total cost recorded in the invoice of all orders of this country 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 of this country 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.
|
% Total Profit | |
Margin (%) | The Margin of all orders of this country 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.
|
...
On this report, you can filter by Country, Subtotal, Tax, Shipping, Grand Total, Refunded
III/ Chart
Image Removed
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, Number of Customer, Subtotal, Tax, Shipping (excl. Tax), Discount, Grand Total, Average Order Value, RefundedInvoiced, Qty Refunded, Revenue (incl. Tax), Revenue (excl. Tax), % Total Revenue, Average Order Value, COGS, Profit, Margin (% Total Profit, Margin (%) ).), Tax, Shipping (excl. Tax), Discount, % Subtotal, % Grand Total, Qty Invoiced, % Total Revenue, Qty Refunded).
For the metrics that display the contribution of the data over the total, they will be shown by the pie chart, and the rest is shown by bar chart.
Image Added
Image Added