Layout analysis
The “Layout analysis” report helps you analyze the number and efficiency of linear meters of layout taken up by each product group on the planogram.
To open the report, you need to go to analytical reports “Reports” > “Analytics” and use the top switch on the page Chain sales analysis > Layout analysis.
The bar chart of the “Layout analysis” report simplifies the process of analyzing a large amount of data.
The X-axis in the visualization displays the dimension selected for the report, and the Y-axis displays the metric set in the visualization settings.
To configure the visualization, click on the “Actions” tool (vertical ellipsis) at the top of the bar graph and select the appropriate action:
Metric - to select a metric, move the mouse cursor over the corresponding line and select another available metric in the list.
Display - to select the display, you need to move the mouse cursor over the corresponding line and select another type of display in the list.
Settings - to set the default metric, configure the display of the quantity of elements, and personalize the visualization.
Save as PNG - to download the visualization as a .png image.
The summary table helps you to view data for the selected dimension to ensure correct business analysis.
To analyze the data by Brands, Categories, Suppliers, Store Plans, Planograms, or Products, use the switch on the top panel.
To sort the values in a table column, it is enough to click on the name of the required column:
First click* - sorting in ascending order.
Second click* - sorting in descending order.
Third click* - sorting in the column is canceled.
To configure the display of columns or save the table's current view template by default, use the corresponding tools in the panel above the table.
Filters allow you to configure the report to compare different versions of the layouts and analyze the effectiveness of changes made to the planograms.
To apply filters, click on the “Filters” tool at the top of the page and select it:
Period* - the main period of sample data.
Previous period* - the previous period of sample data for comparison.
Planogram status* - the status of the planogram version according to the action performed: In progress, On execution, For check, Returned for execution, Confirmed.
Categories *
Brands *
Suppliers *
Store formats*
Store groups*
Shops*
The filtered data sample by version status will contain products from the planograms for which the corresponding status was the closest (last) to the last day of the selected main and previous period.
For example, if you set the period 01.01.2022 - 01.02.2022, then a planogram that received the status "On execution" on 01.31.2022, and then was executed and received the status "For check" on 05.02.2022 will be displayed in the selected period using the filter by the status "On execution", without taking into account later status changes.
If you set the period 01.02.2022-05.02.2022, this planogram will be displayed using the filter by the status "For check".
To download the report in .xls format, click on the Download report button on the top panel of the report page. The downloaded file will contain two sheets: Histogram (a bar chart image in .png format) and Table (a summary table of data).
Important! The table in the uploaded file is displayed with closed levels. You can expand only those levels that were expanded before uploading the file.
The report allows you to analyse the following metrics by group:
Product / category / brand / store plan / planogram / supplier name
Article
Barcode
Product type
Brand name
Plan name (the metric is displayed in case of the selected section "Planogram")
Share of the layout, %
Running meters of display of products in the current period / running meters of display of all products in the current period * 100%.
Share of the total amount laid out in the previous period, %
Running meters of products displayed in the previous period / running meters of all products displayed in the previous period * 100%.
Linear meters of layout
Running meters of products displayed in the current period.
For packaged products or weight products in packaging:
Running meters of display = Product width * quantity of cases.
For weighted products in a crate:
Linear meters of layout= Box length - Wall thickness.
Linear meters of layout for prev. period
SKU qty
The total quantity of unique products in the current period (the metric is not displayed if the selected section is "Products").
SKU qty for prev. period
The total quantity of unique products in the previous period (the metric is not displayed if the selected section is "Products").
Faces qty
Quantity of product faces posted in the current period.
Faces qty for prev. period
Quantity of product faces posted in the previous period.
Product's stock, pcs/kg
The total quantity of products displayed in the planogram for the current period.
For packaged products:
Product's stock, pcs = Quantity of cases Depth of display Height of display.
For weightlifters:
Product's stock, kg = Weight of the package or "1" if the weight of the package is not specified.
Product stock for prev. period, pcs/kg
The total quantity of products displayed in the planogram for the previous period.
For packaged products:
Product stock for prev. period, pcs.= Quantity of cases Depth of display Height of the display.
For weighing scales :
Product stock for prev. period, kg = Weight of the package or "1" if the weight of the package is not specified.
Stock qty
Quantity of balances of products by product available in the store at the end of the selected period.
Turnover per linear m. of display
Turnover per linear meter of display= Turnover of products by type for the current period / meters of display by type.
Turnover per linear m. of layout for prev. period
Turnover per linear m of layout for prev. period= Turnover of products by breakdown for the previous period / Linear meters of display of this product.
Turnover per linear m. of layout change
The difference in the numerical value of turnover per linear meter between the current and the previous period.
Turnover per linear m of layout change, %
The difference in the percentage of turnover per linear meter between the current and the previous period.
Share of total turnover, %.
Share of total turnover, % = (Turnover of products by category * 100) / Sum of turnover of all products by category.
Profit per linear m. of layout
Profit per linear m. of layout= Profit of products by product for the current period / Linear meters of display by product.
Receipts qty per linear m of layout for prev. period
Receipts qty per linear m of layout for prev. period = Profit of products by category for the previous period / meters of display by category.
Receipts qty per linear m of layout change
The difference in the numerical value of profit per square meter between the current and the previous period.
Receipts qty per linear m of layout change, %
The difference in the percentage of profit per square meter between the current and the previous period.
Share of total receipts qty, %
Share of total receipts qty, % = (Profit of products by product * 100) / The sum of the profits of all products.
Receipts qty per linear m of layout
Receipts qty per linear m of layout = Unique quantity of entries of products by category in receipts for the current period / Linear meters of display of products by category.
Receipts qty per linear m of layout for prev. period
Quantity of receipts per linear meter of display for the previous period = Unique quantity of entries of products by category in receipts for the previous period / Linear meters of display by category.
Receipts qty per linear m of layout change
The difference in the quantity of receipts per square meter between the current and the previous period.
Receipts qty per linear m of layout change, %
Difference in the percentage of checks per square meter of display between the current and the previous period.
Share of total receipts qty, %
Share of total receipts qty, % = (Unique quantity of products entries per receipt * 100) / Sum of receipts of all products
Sales qty per linear m of layout
Sales qty per linear m of layout = Quantity of sales of products by category for the current period / Linear meters of display by category
Sales qty per linear m of layout for prev. period
Sales qty per linear m of layout for prev. period = Quantity of sales of products by category for the previous period / Square meters of display by category.
Sales qty per linear m of layout change
The difference in the quantity of sales per square meter between the current and the previous period.
Sales qty per linear m of layout change, %
The percentage difference in the quantity of sales per square meter of display between the current and the previous period.
Share of total sales qty, %.
Share of total sales qty, % = (Quantity of sales of products by category * 100) / Total sales of all products
To open the report, you need to go to analytical reports “Reports” > “Analytics” and use the top switch on the page Chain sales analysis > Layout analysis.
Bar chart
The bar chart of the “Layout analysis” report simplifies the process of analyzing a large amount of data.
The X-axis in the visualization displays the dimension selected for the report, and the Y-axis displays the metric set in the visualization settings.
To configure the visualization, click on the “Actions” tool (vertical ellipsis) at the top of the bar graph and select the appropriate action:
Metric - to select a metric, move the mouse cursor over the corresponding line and select another available metric in the list.
Display - to select the display, you need to move the mouse cursor over the corresponding line and select another type of display in the list.
Settings - to set the default metric, configure the display of the quantity of elements, and personalize the visualization.
Save as PNG - to download the visualization as a .png image.
Summary table
The summary table helps you to view data for the selected dimension to ensure correct business analysis.
To analyze the data by Brands, Categories, Suppliers, Store Plans, Planograms, or Products, use the switch on the top panel.
To sort the values in a table column, it is enough to click on the name of the required column:
First click* - sorting in ascending order.
Second click* - sorting in descending order.
Third click* - sorting in the column is canceled.
To configure the display of columns or save the table's current view template by default, use the corresponding tools in the panel above the table.
Filters
Filters allow you to configure the report to compare different versions of the layouts and analyze the effectiveness of changes made to the planograms.
To apply filters, click on the “Filters” tool at the top of the page and select it:
Period* - the main period of sample data.
Previous period* - the previous period of sample data for comparison.
Planogram status* - the status of the planogram version according to the action performed: In progress, On execution, For check, Returned for execution, Confirmed.
Categories *
Brands *
Suppliers *
Store formats*
Store groups*
Shops*
The filtered data sample by version status will contain products from the planograms for which the corresponding status was the closest (last) to the last day of the selected main and previous period.
For example, if you set the period 01.01.2022 - 01.02.2022, then a planogram that received the status "On execution" on 01.31.2022, and then was executed and received the status "For check" on 05.02.2022 will be displayed in the selected period using the filter by the status "On execution", without taking into account later status changes.
If you set the period 01.02.2022-05.02.2022, this planogram will be displayed using the filter by the status "For check".
To download the report in .xls format, click on the Download report button on the top panel of the report page. The downloaded file will contain two sheets: Histogram (a bar chart image in .png format) and Table (a summary table of data).
Important! The table in the uploaded file is displayed with closed levels. You can expand only those levels that were expanded before uploading the file.
Metrics
The report allows you to analyse the following metrics by group:
Product attributes
Product / category / brand / store plan / planogram / supplier name
Article
Barcode
Product type
Brand name
Plan name (the metric is displayed in case of the selected section "Planogram")
Layout
Share of the layout, %
Running meters of display of products in the current period / running meters of display of all products in the current period * 100%.
Share of the total amount laid out in the previous period, %
Running meters of products displayed in the previous period / running meters of all products displayed in the previous period * 100%.
Linear meters of layout
Running meters of products displayed in the current period.
For packaged products or weight products in packaging:
Running meters of display = Product width * quantity of cases.
For weighted products in a crate:
Linear meters of layout= Box length - Wall thickness.
Linear meters of layout for prev. period
SKU qty
The total quantity of unique products in the current period (the metric is not displayed if the selected section is "Products").
SKU qty for prev. period
The total quantity of unique products in the previous period (the metric is not displayed if the selected section is "Products").
Faces qty
Quantity of product faces posted in the current period.
Faces qty for prev. period
Quantity of product faces posted in the previous period.
Product's stock, pcs/kg
The total quantity of products displayed in the planogram for the current period.
For packaged products:
Product's stock, pcs = Quantity of cases Depth of display Height of display.
For weightlifters:
Product's stock, kg = Weight of the package or "1" if the weight of the package is not specified.
Product stock for prev. period, pcs/kg
The total quantity of products displayed in the planogram for the previous period.
For packaged products:
Product stock for prev. period, pcs.= Quantity of cases Depth of display Height of the display.
For weighing scales :
Product stock for prev. period, kg = Weight of the package or "1" if the weight of the package is not specified.
Stock qty
Quantity of balances of products by product available in the store at the end of the selected period.
Turnover
Turnover per linear m. of display
Turnover per linear meter of display= Turnover of products by type for the current period / meters of display by type.
Turnover per linear m. of layout for prev. period
Turnover per linear m of layout for prev. period= Turnover of products by breakdown for the previous period / Linear meters of display of this product.
Turnover per linear m. of layout change
The difference in the numerical value of turnover per linear meter between the current and the previous period.
Turnover per linear m of layout change, %
The difference in the percentage of turnover per linear meter between the current and the previous period.
Share of total turnover, %.
Share of total turnover, % = (Turnover of products by category * 100) / Sum of turnover of all products by category.
Profit
Profit per linear m. of layout
Profit per linear m. of layout= Profit of products by product for the current period / Linear meters of display by product.
Receipts qty per linear m of layout for prev. period
Receipts qty per linear m of layout for prev. period = Profit of products by category for the previous period / meters of display by category.
Receipts qty per linear m of layout change
The difference in the numerical value of profit per square meter between the current and the previous period.
Receipts qty per linear m of layout change, %
The difference in the percentage of profit per square meter between the current and the previous period.
Share of total receipts qty, %
Share of total receipts qty, % = (Profit of products by product * 100) / The sum of the profits of all products.
Sales quantity
Receipts qty per linear m of layout
Receipts qty per linear m of layout = Unique quantity of entries of products by category in receipts for the current period / Linear meters of display of products by category.
Receipts qty per linear m of layout for prev. period
Quantity of receipts per linear meter of display for the previous period = Unique quantity of entries of products by category in receipts for the previous period / Linear meters of display by category.
Receipts qty per linear m of layout change
The difference in the quantity of receipts per square meter between the current and the previous period.
Receipts qty per linear m of layout change, %
Difference in the percentage of checks per square meter of display between the current and the previous period.
Share of total receipts qty, %
Share of total receipts qty, % = (Unique quantity of products entries per receipt * 100) / Sum of receipts of all products
Sales quantity
Sales qty per linear m of layout
Sales qty per linear m of layout = Quantity of sales of products by category for the current period / Linear meters of display by category
Sales qty per linear m of layout for prev. period
Sales qty per linear m of layout for prev. period = Quantity of sales of products by category for the previous period / Square meters of display by category.
Sales qty per linear m of layout change
The difference in the quantity of sales per square meter between the current and the previous period.
Sales qty per linear m of layout change, %
The percentage difference in the quantity of sales per square meter of display between the current and the previous period.
Share of total sales qty, %.
Share of total sales qty, % = (Quantity of sales of products by category * 100) / Total sales of all products
Updated on: 16/01/2025
Thank you!