> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://helpdesk.planohero.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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](#3-working-with-the-product-rating-report)
[Metrics for analyze](#3-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: 

![](https://storage.crisp.chat/users/helpdesk/website/-/e/6/4/b/e64b77ae74de2800/analitika-angl_12chcez.png)

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

![](https://storage.crisp.chat/users/helpdesk/website/-/e/6/4/b/e64b77ae74de2800/filtr_1ncg6lc.png)

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.

2. **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: 

![](https://storage.crisp.chat/users/helpdesk/website/-/e/6/4/b/e64b77ae74de2800/vidaliti_axc8x3.png)

|| 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.

${youtube}[](VLpzmQTLQ4I)
---

### 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.