Products rating
The 'Products Rating' report is designed to quickly analyze the recommended and actual % of products laid out on the planogram, taking into account the selected section and sales period.
To set up the period for calculation and coefficients for the metrics (turnover, profit, receipts qty, and sales qty), click on the filter icon in the upper panel and enter the desired values.
If the planogram is located on several active store plans, you can use the average value for the rest of the stores in the calculation of historical sales. By default, the information for the current store is used.
To change the display of the report by section, click on the drop-down box in the top panel and select the desired section. By default, use section is products.
To quickly delete a product, click on the checkbox to the left of the product name and use the Delete button. Deletion is available only in the Products Rating section.
To download the report in Excel format, just click on the corresponding button in the upper right corner.
The report makes it possible to analyze the following metrics:
Article
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.
To set up the period for calculation and coefficients for the metrics (turnover, profit, receipts qty, and sales qty), click on the filter icon in the upper panel and enter the desired values.
If the planogram is located on several active store plans, you can use the average value for the rest of the stores in the calculation of historical sales. By default, the information for the current store is used.
To change the display of the report by section, click on the drop-down box in the top panel and select the desired section. By default, use section is products.
To quickly delete a product, click on the checkbox to the left of the product name and use the Delete button. Deletion is available only in the Products Rating section.
To download the report in Excel format, just click on the corresponding button in the upper right corner.
Metrics for analyze
The report makes it possible to analyze the following metrics:
Article
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.
Updated on: 18/02/2025
Thank you!