Analysis of laid out products

The "Analysis of laid out products" report allows you to analyze in detail the products laid out on all planograms in the store and helps visualize key indicators using color highlighting, so you can quickly identify which shelving units are the most effective or require optimization.

In this article we will review the "Analysis of laid out products" report: how to configure it and what indicators are available.

Contents

How to configure the report
General indicators used in analytics
Indicators table

How to configure the report

To open the report, click "Analytics" → "Analysis of laid out products" on the left toolbar.

In the "Report settings" panel:

1. Click the "Period" field and select the required date range in the calendar or use one of the ready-made options. The last 30 days are set automatically;
2. Select the indicator for analysis:
3. • Linear metres of equipment;
   • Linear metres of display;
   • Product quantity;
   • Planogram fill rate, % (set automatically);
   • Turnover per linear m of equipment;
   • Profit per linear m of equipment;
   • Turnover efficiency ratio;
   • Profit efficiency ratio.
3. If needed, change the highlight color — click the color circle and select a color from the palette or enter a hexadecimal code;
4. Select the planogram type: Basic (set automatically) or Additional;
5. Click "Apply" to update the data.

After configuring the report, planograms on the store plan are highlighted in colors depending on the value of the selected indicator:

• Saturated color — the highest indicator values;
• Transparent (almost white) color — values close to zero.

This allows you to visually determine the effectiveness of each planogram.

To view the planogram ranking chart, click the corresponding icon in the top right corner:

The chart displays the planogram ranking according to the selected indicator.

General indicators used in analytics

• Turnover — the sum of monetary receipts from sales for the selected period;
• Profit — the difference between turnover and product cost;
• Sales qty — the total number of product units sold during the selected period;
• Receipts qty — the total number of sales receipts for the selected period, excluding return receipts;
• Stock qty — the quantity of products in the store and/or warehouse at the end of the last day of the selected period.

Indicators table

At the bottom of the page, a table with data for the selected period is displayed:

1. Product attributes:
2. • Product name;
   • Planogram name;
   • Planogram type;
   • Planogram category;
   • Laid out products category;
   • Article;
   • Product type;
   • Barcode;
   • Category;
   • Brand;
   • Supplier.
2. Layout indicators:
3. • Planogram fill rate, % = Linear metres of display / Linear metres of planogram;
   • Facings qty — the sum of the product's facings qty from all planogram shelves;
   • Recommended facings qty;
   • Shelf stock, pcs/kg — the total quantity of laid-out product on the planogram:

For packaged products:
Product stock, pcs = Facings qty * Display depth * Display height.

For weighted products:
Product stock, kg = Package weight, or "1" if the package weight is not specified.

• Shelf stock, days — how many days the laid-out product will last.
• Stock qty — the remaining laid-out product at the end of the selected period;
• Linear metres of product layout on the equipment:

For packaged products = Product width * Facings qty;

For weighted products in a box = Box length − wall thickness.

• Share of layout from equipment = (Linear metres of product layout * 100) / Linear metres of equipment on which the product is located.

3. Sales indicators:
4. • Turnover;
   • Turnover per linear m of equipment = Product turnover / Linear metres of equipment;
   • Turnover per linear m of layout = Product turnover / Linear metres of product display;
   • Turnover share from planogram, % = (Product turnover / Sum of turnover of laid-out products on the planogram) * 100;
   • Turnover efficiency ratio = Turnover share from planogram / Display percentage from equipment;
   • Profit;
   • Profit per linear m of equipment = Product profit / Linear metres of equipment;
   • Profit per linear m of display = Product profit / Linear metres of product display;
   • Profit share from planogram, % = (Product profit / Sum of profit of laid-out products on the planogram) * 100;
   • Profit efficiency ratio = Profit share from planogram / Display percentage from equipment;
   • Sales qty;
   • Receipts qty;
   • Average sales qty per day = Sales qty / Number of days in the selected period.

To download the report in .xls format, click "Download report" on the top toolbar.

Updated on: 21/08/2026