# 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**](https://app.zonwizard.com/profit/product-table/)**.**

The KPIs listed in the table are:

* **Ordered Units:** number of orders
* **Refunded Units:** 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
* **Refund Rate**: Calculates the percentage of returns on units sold in the selected time period.
* **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.

<figure><img src="/files/PbRqx7oU7guDUveK3sVX" alt=""><figcaption></figcaption></figure>

**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)

{% hint style="danger" %}
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.
{% endhint %}

## Advanced Filters <a href="#l8nev5bvrndb" id="l8nev5bvrndb"></a>

This section contains the advanced filter panel, accessible from the button with the **"funnel"** icon in the upper right corner.

![advanced filters](/files/UVrO1uGhCDXbABBc4m9B)

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

![advanced filters panel](/files/lnHQCJmjjEyKwVKwGd7q)

### Save Filters <a href="#cai9xn8azw3i" id="cai9xn8azw3i"></a>

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.

<figure><img src="/files/BCAI3cgdiKYIA4npvJBd" alt="" width="313"><figcaption><p>save a filter</p></figcaption></figure>

To recall a previously saved filter, click the down arrow next to the button to access the filter panel.

<figure><img src="/files/uOPQCftheQNEViYf5yG7" alt="" width="375"><figcaption><p>saved filters</p></figcaption></figure>

You can delete a filter using the **Trash** button.

## **Expand or Collapse View**

By clicking on the icon in the upper-right corner, **you can expand the view of products** sold on various marketplaces so that you can see specific data for each country where they are sold.

<figure><img src="/files/cAKCJVDec6KDcitrRTPN" alt=""><figcaption></figcaption></figure>

## Search within individual columns

You can **search within individual columns**. Clicking on the column header opens a drop-down menu that allows you to filter and browse the data according to your needs.

<figure><img src="/files/F0WhCqxIJdwzTMXTBgVr" alt=""><figcaption></figcaption></figure>

## Column customization <a href="#personalizzazione-colonne" id="personalizzazione-colonne"></a>

Using the **"columns" filter** on the side, you can select or hide the columns you want to display based on your preferences.

<figure><img src="/files/2restatK8yMuijsj9MzJ" alt=""><figcaption></figcaption></figure>

## Reset columns <a href="#reimposta-colonne" id="reimposta-colonne"></a>

To **reset the column sorting**, click the **"reset columns" icon** on the side and confirm the operation by clicking the blue "reset columns" button.

<figure><img src="/files/zfGGWNKEked5HGlZU60g" alt=""><figcaption></figcaption></figure>

## Sort <a href="#x7wv8xrere-1" id="x7wv8xrere-1"></a>

Each column can be sorted by metrics, such as ascending or descending. To sort the table, click on the column header.

<figure><img src="/files/5CQi9AMCGTl71plqCEdq" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Sort the table by decreasing margin to quickly identify products with unsatisfactory results.
{% endhint %}

## Explore Revenue / Costs <a href="#jedqgxabi07s" id="jedqgxabi07s"></a>

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.

![explore revenue / costs](/files/ui9ifY5xVnLuZR3fvBhV)

<figure><img src="/files/rrEIu7wPp35PUIhwLL9i" alt="" width="563"><figcaption></figcaption></figure>

Clicking the **“More Details”** button in the lower right corner redirects you to the [financial report ](/profit/financial-report.md)with the breakdown of all cost items.

## Explore Balance <a href="#jedqgxabi07s" id="jedqgxabi07s"></a>

By clicking on the **“balance”** icon within the **“Actions”** column you will be redirected to the [financial report](/profit/financial-report.md) where you can view the breakdown of all revenue and cost amounts related to the individual item.

![explore balance](/files/7ocpfIi1C9qh7CmJZmul)

## Explore Orders / Returns <a href="#cjzcvwqgenyy" id="cjzcvwqgenyy"></a>

You can view orders and returns related to the individual item by clicking the **"cart"** icon in the **"Actions"** column.

<figure><img src="/files/qnZJJg2qba2MPpYECRff" alt=""><figcaption><p>explore orders / returns</p></figcaption></figure>

{% hint style="warning" %}
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.
{% endhint %}

## KPI Comparison <a href="#n78wh7v8f549" id="n78wh7v8f549"></a>

The profit table can be used to compare product profit results.

### Product Comparison by SKU, ASIN, or Parent <a href="#id-2rt5kctg9sn4" id="id-2rt5kctg9sn4"></a>

Using the selection bar, you can aggregate the table results by single SKU or by ASIN, or group the results by parent.

<figure><img src="/files/igBz8SL9bfUjMsTlARx1" alt="" width="563"><figcaption></figcaption></figure>

### Brand Comparison <a href="#rfegvzmjcizj" id="rfegvzmjcizj"></a>

Using the selection bar, you can aggregate the table results by brand and compare the performance of individual brands.

<figure><img src="/files/sQSOLnlfR7N1ICNN8PRl" alt="" width="536"><figcaption></figcaption></figure>

### Category Comparison <a href="#fd6sjn9m1l9r" id="fd6sjn9m1l9r"></a>

Using the selection bar, you can aggregate the table results by category and compare the performance of individual product types.

<figure><img src="/files/Z9gnJTVLN6X0KoPMwccx" alt="" width="464"><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.zonwizard.com/profit/profit-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.