Profit Table
In this section, you can view and compare the main KPIs (Key Performance Indicators) related to products, brands and categories for the selected period.
You can access this section from the left menu Profit >> Profit Table.
The KPIs listed in the table are:
Orders: number of orders
Refunds: number of refunds
Revenue: gross revenue made in the period
Profit: net profit amount made in the period
Margin: percentage profit margin
ROI: Return On Investment calculated as profit/product cost ratio
ACOS : (Advertising Cost of Sales) percentage indicator that highlights the cost of advertising in relation to the sales generated by it.
TACOS : (Total Advertising Cost of Sales) percentage indicator to evaluate the impact of advertising on total sales, i.e. both those generated by ads and organic (non-sponsored) sales.
Calculation of ACOS (Advertising Cost of Sale):
ACOS measures the efficiency of your advertising spend in relation to the sales it generates. Formula: ACOS = (PPC Spend / PPC Sales)
PPC Spend: The amount spent on sponsored campaigns, excluding VAT
PPC Sales: Only the sales generated through advertising, including VAT
Calculation of TACOS (Total Advertising Cost of Sale):
TACOS indicates how much your advertising spend affects your total sales (including organic sales). Formula: TACOS = (PPC Spend / Total Sales)
PPC Spend: The amount spent on sponsored campaigns, excluding VAT
Total Sales: All sales (both from advertising and organic), including VAT
In summary:
ACOS tells you how much advertising costs in relation to the sales it directly generates
TACOS tells you how much advertising impacts your total sales (including non-sponsored ones)
ACOS and TACOS values are available only if you have connected Amazon Advertising to Zon Wizard. If integration is enabled, PPC spending is measured net of VAT. If integration is not enabled, PPC costs are calculated with VAT.
The inclusion or exclusion of VAT in the calculation of ACOS and TACOS follows the same rules as how Amazon handles advertising data.
Advanced Filters
This section contains the advanced filter panel, accessible from the button with the "funnel" icon in the upper right corner.
Using this panel, you can filter the data by selecting one or more of the following parameters:
Fulfillment: FBA or FBM
Platform: Amazon or eBay
Marketplace: (e.g., amazon.de, amazon.fr…)
Category: product category detected by the marketplace
Brand: product brand
Parent: parent product of a group of ASINs
SKU - ASIN - Short Name: product
Save Filters
If you frequently use filters with many options, you can save a filter so that you can quickly recall it without having to re-enter all the options each time. Once the filter is applied, you can save it by clicking the button with the "floppy disk" icon. In the tab that opens, you can choose a name for the filter you are saving.
To recall a previously saved filter, click the down arrow next to the button to access the filter panel.
You can delete a filter using the Trash button.
Sorting
The table can be sorted based on metrics in ascending or descending order. To sort the table, click the arrows on the column header.
Explore Revenue / Costs
Clicking on the “magnifying glass” icon within the “Actions” column opens a table with a summary of revenues/costs related to the selected product, brand or category.
Clicking the “More Details” button in the lower right corner redirects you to the financial report with the breakdown of all cost items.
Explore Balance
By clicking on the “balance” icon within the “Actions” column you will be redirected to the financial report where you can view the breakdown of all revenue and cost items related to the individual item.
Explore Orders / Returns
You can view orders and returns related to the individual item by clicking the "cart" icon in the "Actions" column.
Note that the sum of the profit from orders and returns does not equal the total profit shown in the profit table because this also includes costs not related to orders, such as advertising costs, warehouse storage costs.
KPI Comparison
The profit table can be used to compare product profit results.
Product Comparison by SKU, ASIN, or Parent
Using the selection bar, you can aggregate the table results by single SKU or by ASIN, or group the results by parent.
Brand Comparison
Using the selection bar, you can aggregate the table results by brand and compare the performance of individual brands.
Category Comparison
Using the selection bar, you can aggregate the table results by category and compare the performance of individual product types.
Last updated