The "Negative margin products" widget 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. 

The widget header indicates the time period for the filtered data, which corresponds to your selection in the “Filters” form of the sidebar menu. Hover over the info icon next to the header to see the date and time when the data was last updated.

The widget's data automatically updates to reflect the filters you apply through the dashboard’s sidebar. For more details on how to use the filters, see Business Analytics | Dashboard | Sidebar menu. You can scroll within the widget to view additional products.

Chart overview

The widget visualizes the performance of the 50 most underperforming products using stacked bars. You can scroll within the widget to view all 50 products. To explore data on additional underperforming products, click the expand icon in the widget's top-right corner to open the "Negative margin products" modal. For more information, see Business Analytics | Dashboard | "Negative margin products" modal.

The chart bars break down the data into two parts:

• Revenue (dark blue bar): Represents the total income that includes product sales and other income-related metrics.
• Expenses (light blue bar): Shows the total cost that includes all expense-related metrics.

Chart axis

Product rating (left axis): Indicates the product’s rating based on its estimated margin. A lower margin results in a higher rating number, indicating worse performance.

Estimated margin (right axis): Displays the estimated margin for each product, shown in the currency that corresponds to your selection in the “Filters” form of the sidebar menu.

Tooltip with product data

When you hover over a product bar, a tooltip will appear with the following product information:

• Product image: A small image of the product for easy identification.
• Product title: The name or a short description of the product.
• Marketplace: The marketplace where the product is listed.
• ASIN: The Amazon Standard Identification Number (ASIN) for the product.
• SKU: The Stock Keeping Unit (SKU) associated with the product.
• Estimated margin: The product’s estimated margin value.
• Expenses: The total expenses and costs associated with the product.
• Revenue: The product's revenue.

Export chart data

You can export the current view of the "Negative margin products" widget by clicking the three dots icon in the top-right corner of the chart. Available export options include:

• “Export data”: Download the chart data in CSV or XLSX file formats.
• “Download chart”: Download the chart image in PNG or PDF file formats.

"Negative margin products" modal

The “Negative margin products” modal form is an expanded view of the widget, designed to provide a complete list of underperforming products. It visualizes the product performance in a detailed table and chart format. The modal uses the same time period as the widget, which corresponds to your selection in the “Filters” form of the sidebar menu.

To access the “Negative margin products” modal form, click the expand icon in the widget's top-right corner. 

Sorting options

You can customize the display order of the product list via the “Sort by” dropdown menu:

• Lowest margin to highest (default): Displays products starting with the lowest estimated margin.
• Highest margin to lowest: Displays products starting with the highest estimated margin.

Table fields

Below is a table listing all fields available in the "Negative margin products" table, along with their respective descriptions.