The "Negative margin products" tab on the Business Analytics Dashboard highlights the most underperforming products by identifying those where the estimated margin is less than or equal to the associated expenses.
Note: The data in the table is blurred in the Freemium mode.
Table fields
The “Negative margin products“ table features interactive column headers that support sorting and filtering to help you customize the displayed data to your preferences. This ensures that you can view and manage the needed product information or export all products from the table.
- Sorting options: Each column header provides “Ascending” and “Descending” sorting options to quickly reorganize product data in a meaningful order. Sorting can be applied to only one column at a time. Applying sorting to a different column will override any previously applied sort order.
- Filtering options: Each column header, except "Image", includes an inline filter, presented as either a dropdown list or text input field for a live search, depending on the data type. Filtering allows you to narrow down the data displayed in a table by providing specific values within column headers. Multiple column filters can be applied simultaneously.
For more information, see General | Common service features
Below is a table listing all fields available in the "Negative margin products" table, along with their respective descriptions.
| Column header | Description | Column header filter |
|---|---|---|
| Title | Displays the product's name or a short description. | Live search |
| Image | Shows the product image as provided by Amazon. | |
| ASIN | The Amazon Standard Identification Number (ASIN) is a 10-digit alphanumeric product identification number with a link to the product page on Amazon. One ASIN may cover multiple SKUs. | Live search |
| SKU |
The Stock Keeping Unit (SKU) is the unique alphanumeric code used by Amazon to identify a product for inventory and sales purposes. On rare occasions, two different marketplaces may have the same SKU. The value in this column is clickable and opens the “Product costs” page in a new browser tab, prefiltered by the selected SKU and its marketplace. At the same time, the “Product details” drawer is displayed to highlight cost settings related to this product. This functionality is not available in Freemium mode. |
Live search |
| Marketplace | Identifies the Amazon marketplace where the product is listed. | Dropdown list |
| Brand | Displays the name of the brand associated with the product. | Live search |
| Revenue | Revenue includes product sales and other income-related transactions. The value is clickable and opens the “Transactions“ page in a new browser tab, prefiltered by the selected Amazon account, SKU, selected date range, marketplace, and KPI type. | Live search |
| Total income | The total sum of all positive transactions. The value is clickable and opens the “Transactions“ page in a new browser tab, prefiltered by the selected Amazon account name, SKU, selected date range, marketplace, and KPI type. | Live search |
| Total expenses | The total sum of all negative transactions. The value is clickable and opens the “Transactions“ page in a new browser tab, prefiltered by the selected Amazon account name, SKU, selected date range, order purchase date, marketplace, and KPI type. | Live search |
| Estimated margin | The estimated net margin, calculated as total income minus total expenses. This column is automatically sorted by ascending. | Live search |
| Order items | The total number of items across all orders. The value is clickable and opens the “Orders“ page in a new browser tab, prefiltered by all orders statuses without “Cancelled“, Amazon account name, marketplace, and SKU. | Live search |
| Units | The number of ordered units. The value is clickable and opens the “Orders“ page in a new browser tab, prefiltered by all orders statuses without “Cancelled“, Amazon account name, marketplace, and SKU. | Live search |
| Promotion | The number of orders with promotions applied. | Live search |
| Refunds | The number of refunded units. The value is clickable and opens the “Orders“ page in a new browser tab, prefiltered by all orders statuses without “Cancelled“, Amazon account name, marketplace, SKU, and refunded units >0. | Live search |
| BSR |
Best Seller Rank (BSR) represents the product's performance relative to others in the same category. When hovering over the BSR value, a tooltip appears, showing the percentage change compared to the previous similar period. |
Live search |
| Estimated margin % |
The percentage of the estimated margin in the revenue. Ranged form -100% to 100% If the revenue = 0, it is impossible to calculate the margin. In this case, the “Margin“ will be displayed as “N/A“. |
Live search |
| ROI | Return on Investment (ROI) is calculated as the ratio of net margin to total expenses. | Live search |
| Markup | The percentage increase of the net margin over the net purchase price. | Live search |
| Amazon account name |
The name of the Amazon sellert account associated with the product. It is hidden if only one account is connected to Business Analytics. |
Live search |
Pagination and table controls
The lower section of the page facilitates navigation through large datasets and offers tools to customize the table view.
Table controls: Located in the bottom-right corner, table controls provide options to adjust the display and content of the table according to your preferences:
- Table settings: Opens an edit mode that allows manual adjustment of column widths.
- Table content: Opens a configuration modal where users can define the order and visibility of columns. Columns can be toggled using checkboxes and reordered via drag-and-drop.
Pagination and display count: In the bottom-left corner, the display count control allows selecting the number of entries per page (10, 25, 50, 75, or 100), shows the current range of visible results, the total number of entries, and provides navigation through pages using arrow buttons or direct page number input.