Articles on: Planogram editing

Products rating

In this article 

We will review how to work with the "Product rating" report: how to open the report, configure analysis parameters, view product performance indicators, change the data display type, and download the report in Excel format. 

Contents

Working with the "Product rating" report

Metrics for analyze

Working with the "Product rating" report 

The "Product Rating" report is used for quick analysis of the recommended and actual product placement percentage on a planogram based on the selected dimensions and sales period.


To open the report, go to the planogram editing mode and click the "Analytics" icon → "Product rating" on the right sidebar: 



To configure the report parameters, click "Filters" at the top of the panel:



The following settings are available in the "Filters" panel:

  1. Coefficients settings:
  • Period;
  • Turnover coef.;
  • Profit coef.;
  • Receipts quantity coef.;
  • Sales quantity coef.


Note! The sum of all coefficients must equal one.


  1. Calculation type:
  • Store — if the planogram is placed in several active store plans, sales history and data from other stores can be used in calculations as average values. By default, information from the current store is used. 


To change the report view, click the dropdown list at the top of the page and select the required data display option: 

  • Products rating;
  • Brands rating;
  • Category rating;
  • Supplier rating.


Note! "Product rating" is used by default. Some view options may not be displayed if the required data is not uploaded in the product bindings.


To remove a product, select the required product and click "Remove". The product will be removed from the report, the planogram, and the product list: 



Note! Deletion is available only in the "Product rating" view.


To return to planogram editing, click "Back to the planogram" at the top of the panel.


To download the report in Excel format, click "Download report" in the upper-right part of the panel.


Metrics for analyze

The report makes it possible to analyze the following metrics:

  • Recommended % of equipment


The recommended percentage of product layout on the equipment is calculated based on historical sales data.


Note! If the store plan is not active, the value of the metric will be distributed equally among all products


  • Actual % of equipment

Displays the proportion of the product layout from the equipment.

Actual % of equipment = (Linear meters of product layout × 100) / Linear meters of equipment.

  • Facingss qty

Quantity of product facings laid out.

  • Linear meters of layout

Displays the linear meters of product layout on the equipment. Linear meters of layout on equipment = Product width × Facings qty.

  • Turnover

The amount of cash receipts from sales of products for the selected period.

  • Turnover, %

Turnover, % = (Product turnover × 100) / Sum of turnovers of all products in the planogram

  • Sales qty

Shows how many times a certain product or products from a certain category/brand/supplier were sold during the selected period.

  • Receipts quantity

The total number of sales receipts (excluding Quantity of return receipts) for the selected period.

  • Profit

The difference between revenue from the sale of products (turnover) and the cost of products.

  • Profit, %

Profit, % = (Product profit × 100) / Sum of profits of all products in the planogram.


Note! In the "Brand rating", "Category rating", and "Supplier rating" views, the calculation is performed similarly, but the corresponding brand, category, or supplier is used instead of the product.

Updated on: 10/06/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!