“Chain sales analysis” report
The updated “Chain sales analysis” report will help you analyze your chain's performance more efficiently by conveniently comparing sales between stores in your chain.
To access the report, click on the "Reports" block and then click on "Analytics".
The “Chain sales analysis” report contains a bar chart and a summary table with data on sales and the layout of the store chain.
Important! The “Chain sales analysis” report displays data on all current store plans. Inactive plans will not be displayed in the report.
The bar chart of the “Chain sales analysis” report simplifies the process of analyzing a large amount of data.
Note! When you hover the mouse cursor over a column, an informative tooltip is displayed with the name of the dimension, the value of the metric, and the value of the metric for the previous period.
The X-axis in the visualization displays the dimension selected for the report, and the Y-axis displays the metric set in the visualization setting.
When you click on the “More” tool (vertical ellipsis) in the upper right corner of the visualization, a list of available actions with the visualization expands:
Metric - the name of the selected metric. When you hover the mouse cursor over a metric, an additional list with a list of available metrics expands to the left of the action list.
Display - the name of the selected display. When you hover the mouse cursor over an item to the left of the action list, an additional list with a list of display types will expand.
Settings - click on the button to open the Visualization Settings pop-up window, where you can set the default value, adjust the number of elements, and personalize the visualization.
Save as .png - click on this button to download the visualization as a .png image.
The summary table helps you to view store sales data to analyze your business correctly.
The data in the table are grouped by the Store plans dimension by default. Clicking on the arrow next to the name of the store plan will expand the dimension and go down to the next level.
Use the drop-down list at the top of the report page to select a different dimension:
Store Plans.
Planograms - dimension is available only when the calculation "Sales of laid out products only" is active, the calculation can be activated in the Filters.
Categories
Products.
To sort the values in a table column, click on the name of the required column:
First click – sort in ascending order.
Second click - sort in descending order.
Third click - the sorting in the column is canceled.
The toolbar is located in the upper right corner above the table:
Search - dynamic search by the name of the selected dimension (store plan, planogram, category).
Columns settings - when you click, a pop-up window "Columns settings" opens, select the columns you need to display and click the "Apply" button to change the report.
Important! Columns marked with * will be displayed in the table only if the "Sales of laid out products only" calculation type is activated, which can be enabled in the filters.
Save table template - saves the customized table view by default.
The filters of the “Chain sales analysis” report allow you to filter the data and analyze only the required sample.
When you click on the “Filters” tool at the top of the page, you open the Filters panel, where you can customize the settings:
Period - the main period of data selection.
Previous period - the previous period of data selection for comparison.
Calculation type - the type of data calculation for the bar chart and summary table. You can choose one of two types:
- All sales - the calculation is based on all sales, all products for the selected periods.
- Sales of laid out products only - the calculation is based on only the selected products on the planograms at the time of the analysis.
Planogram status - planogram statuses by which you can filter the data. The filter is available only for the Calculation type "Sales of laid out products only".
Categories
Brands
Suppliers
Store formats
Store groups
Stores
Click on the "Apply" button to apply the set filters in the report.
In order to download the report in .xls format, click on the "Download" 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 collapsed levels. You can expand only those levels that were expanded before uploading the file.
The report allows you to analyse the following indicators by group:
Product / category / brand / store / planogram name
Article
Barcode
Brand name
Product type
Turnover
The amount of cash receipts from sales of products broken down by the current period.
Turnover for prev. period
The amount of cash receipts from sales of the section in the previous period.
Change in turnover
The difference in the numerical value of turnover between the current and the previous period.
Change in turnover, %.
The percentage difference in turnover between the current and the previous period.
Turnover per linear metre of equipment
Turnover per linear metre of equipment= Turnover of products by type for the current period / Running metres of equipment on which the products are located
Turnover per linear metre of equipment for the prev. period
Turnover per linear metre of equipment for the previous period = Turnover of products by breakdown for the previous period / Linear metres of equipment on which the products are located
Turnover per square metre of display
Turnover per linear metre of display= Turnover of products in the current period / Linear metres of display of this product
Turnover per square metre of display for the previous period
Turnover per linear metre of display for the previous period = Turnover of products by product for the previous period / Linear metres of display of this product
Turnover per sq m of equipment
Turnover per sq. m. of equipment = Turnover of products in the current period / (Depth of equipment * Width of equipment)
Turnover per sq m of equipment for the previous period
Turnover per sq. m. of equipment for the previous period= Turnover per sq. m. of equipment = Turnover of products by product for the previous period / (Depth of equipment * Width of equipment)
Profit
The difference between the cash proceeds from the sale of products by type (turnover) and the cost of products by type for the current period.
Profit for the prev. period
The difference between the cash proceeds from the sale of products by type (turnover) and the cost of products by type for the previous period.
Profit change
The difference in the numerical value of profit between the current and the previous period.
Profit change, %
The percentage difference in profit between the current and the previous period.
Profit per linear m. of equipment
Profit per linear metre of equipment = Profit of products by type for the current period / Linear metres of equipment on which the products are located by type
Profit per linear m. of equipment for previous period
Profit per linear metre of equipment for the previous period= Profit of products by product for the previous period / Linear metres of equipment on which the products are located
Profit per linear m. of layout
Profit per linear metre of display= Profit of products by product for the current period / Linear metres of display of this product
Profit per linear m. of layout for previous period
Profit per linear metre of display for the previous period = Profit of products by product for the previous period / Linear metres of display of this product
Profit per square m. of equipment
Profit per square m. of equipment= Profit of products by product for the current period / (Depth of equipment * Width of equipment)
Profit per square m. of equipment for previous period
Profit per square m. of equipment for previous period = Profit of products by product for the previous period / (Equipment depth * Equipment width)
Receipts qty
The total quantity of sales receipts for the selected period, excluding return receipts.
Receipts qty for prev. period
The total quantity of sales receipts for the previous period, excluding return receipts.
Receipts qty change
The difference in quantity of cheques between the current and the previous period.
Receipts qty change, %
The difference in the percentage value of quantity of cheques between the current and the previous period.
Sales qty
The total quantity of units sold for the selected period.
Sales qty for prev. period
The total quantity of units sold in the previous period.
Sales qty change
The difference in quantity of sales between the current and the previous period.
Sales qty change, %
The percentage difference in quantity of sales between the current and the previous period.
Linear meters of equipment
Linear meters of equipment= (Number of shelves+ Base) * Equipment width.
Note! It should be noted that in the context of planograms and store plans, it displays the values "Sales of only displayed products" and "Sales of only linked products".
Linear meters of layout
Running metres of products displayed in the previous period.
For packaged products or weight products in packaging:
Linear meters of layout = Product width * Number of cases.
For weighted products in a crate:
Linear metres of the layout= (Box length - Wall thickness)
*running metres of products displayed by section.
Faces qty
The sum of the number of product faces product.
Product's stock, pcs/kg
The total number of products laid out in the planogram.
For packaged products:
Product's stock, pcs/kg= Number of cases Depth of display Height of display.
For weightlifters:
Product's stock, pcs/kg = Weight of the package or "1" if the weight of the package is not specified.
Stock qty
Quantity of products by category available in the store at the end of the selected period.
Coefficient of loading of the trading floor
The load factor of the trading floor = (Square meters of equipment+ Square meters of additional equipment) / Area of the trading floor.
To access the report, click on the "Reports" block and then click on "Analytics".
The “Chain sales analysis” report contains a bar chart and a summary table with data on sales and the layout of the store chain.
Important! The “Chain sales analysis” report displays data on all current store plans. Inactive plans will not be displayed in the report.
Bar chart
The bar chart of the “Chain sales analysis” report simplifies the process of analyzing a large amount of data.
Note! When you hover the mouse cursor over a column, an informative tooltip is displayed with the name of the dimension, the value of the metric, and the value of the metric for the previous period.
The X-axis in the visualization displays the dimension selected for the report, and the Y-axis displays the metric set in the visualization setting.
When you click on the “More” tool (vertical ellipsis) in the upper right corner of the visualization, a list of available actions with the visualization expands:
Metric - the name of the selected metric. When you hover the mouse cursor over a metric, an additional list with a list of available metrics expands to the left of the action list.
Display - the name of the selected display. When you hover the mouse cursor over an item to the left of the action list, an additional list with a list of display types will expand.
Settings - click on the button to open the Visualization Settings pop-up window, where you can set the default value, adjust the number of elements, and personalize the visualization.
Save as .png - click on this button to download the visualization as a .png image.
Summary table
The summary table helps you to view store sales data to analyze your business correctly.
The data in the table are grouped by the Store plans dimension by default. Clicking on the arrow next to the name of the store plan will expand the dimension and go down to the next level.
Use the drop-down list at the top of the report page to select a different dimension:
Store Plans.
Planograms - dimension is available only when the calculation "Sales of laid out products only" is active, the calculation can be activated in the Filters.
Categories
Products.
To sort the values in a table column, click on the name of the required column:
First click – sort in ascending order.
Second click - sort in descending order.
Third click - the sorting in the column is canceled.
The toolbar is located in the upper right corner above the table:
Search - dynamic search by the name of the selected dimension (store plan, planogram, category).
Columns settings - when you click, a pop-up window "Columns settings" opens, select the columns you need to display and click the "Apply" button to change the report.
Important! Columns marked with * will be displayed in the table only if the "Sales of laid out products only" calculation type is activated, which can be enabled in the filters.
Save table template - saves the customized table view by default.
Filters
The filters of the “Chain sales analysis” report allow you to filter the data and analyze only the required sample.
When you click on the “Filters” tool at the top of the page, you open the Filters panel, where you can customize the settings:
Period - the main period of data selection.
Previous period - the previous period of data selection for comparison.
Calculation type - the type of data calculation for the bar chart and summary table. You can choose one of two types:
- All sales - the calculation is based on all sales, all products for the selected periods.
- Sales of laid out products only - the calculation is based on only the selected products on the planograms at the time of the analysis.
Planogram status - planogram statuses by which you can filter the data. The filter is available only for the Calculation type "Sales of laid out products only".
Categories
Brands
Suppliers
Store formats
Store groups
Stores
Click on the "Apply" button to apply the set filters in the report.
In order to download the report in .xls format, click on the "Download" 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 collapsed levels. You can expand only those levels that were expanded before uploading the file.
Indicators
The report allows you to analyse the following indicators by group:
Product attributes
Product / category / brand / store / planogram name
Article
Barcode
Brand name
Product type
Turnover
Turnover
The amount of cash receipts from sales of products broken down by the current period.
Turnover for prev. period
The amount of cash receipts from sales of the section in the previous period.
Change in turnover
The difference in the numerical value of turnover between the current and the previous period.
Change in turnover, %.
The percentage difference in turnover between the current and the previous period.
Turnover per linear metre of equipment
Turnover per linear metre of equipment= Turnover of products by type for the current period / Running metres of equipment on which the products are located
Turnover per linear metre of equipment for the prev. period
Turnover per linear metre of equipment for the previous period = Turnover of products by breakdown for the previous period / Linear metres of equipment on which the products are located
Turnover per square metre of display
Turnover per linear metre of display= Turnover of products in the current period / Linear metres of display of this product
Turnover per square metre of display for the previous period
Turnover per linear metre of display for the previous period = Turnover of products by product for the previous period / Linear metres of display of this product
Turnover per sq m of equipment
Turnover per sq. m. of equipment = Turnover of products in the current period / (Depth of equipment * Width of equipment)
Turnover per sq m of equipment for the previous period
Turnover per sq. m. of equipment for the previous period= Turnover per sq. m. of equipment = Turnover of products by product for the previous period / (Depth of equipment * Width of equipment)
Profit
Profit
The difference between the cash proceeds from the sale of products by type (turnover) and the cost of products by type for the current period.
Profit for the prev. period
The difference between the cash proceeds from the sale of products by type (turnover) and the cost of products by type for the previous period.
Profit change
The difference in the numerical value of profit between the current and the previous period.
Profit change, %
The percentage difference in profit between the current and the previous period.
Profit per linear m. of equipment
Profit per linear metre of equipment = Profit of products by type for the current period / Linear metres of equipment on which the products are located by type
Profit per linear m. of equipment for previous period
Profit per linear metre of equipment for the previous period= Profit of products by product for the previous period / Linear metres of equipment on which the products are located
Profit per linear m. of layout
Profit per linear metre of display= Profit of products by product for the current period / Linear metres of display of this product
Profit per linear m. of layout for previous period
Profit per linear metre of display for the previous period = Profit of products by product for the previous period / Linear metres of display of this product
Profit per square m. of equipment
Profit per square m. of equipment= Profit of products by product for the current period / (Depth of equipment * Width of equipment)
Profit per square m. of equipment for previous period
Profit per square m. of equipment for previous period = Profit of products by product for the previous period / (Equipment depth * Equipment width)
Receipts quantity
Receipts qty
The total quantity of sales receipts for the selected period, excluding return receipts.
Receipts qty for prev. period
The total quantity of sales receipts for the previous period, excluding return receipts.
Receipts qty change
The difference in quantity of cheques between the current and the previous period.
Receipts qty change, %
The difference in the percentage value of quantity of cheques between the current and the previous period.
Number of sales
Sales qty
The total quantity of units sold for the selected period.
Sales qty for prev. period
The total quantity of units sold in the previous period.
Sales qty change
The difference in quantity of sales between the current and the previous period.
Sales qty change, %
The percentage difference in quantity of sales between the current and the previous period.
Other
Linear meters of equipment
Linear meters of equipment= (Number of shelves+ Base) * Equipment width.
Note! It should be noted that in the context of planograms and store plans, it displays the values "Sales of only displayed products" and "Sales of only linked products".
Linear meters of layout
Running metres of products displayed in the previous period.
For packaged products or weight products in packaging:
Linear meters of layout = Product width * Number of cases.
For weighted products in a crate:
Linear metres of the layout= (Box length - Wall thickness)
*running metres of products displayed by section.
Faces qty
The sum of the number of product faces product.
Product's stock, pcs/kg
The total number of products laid out in the planogram.
For packaged products:
Product's stock, pcs/kg= Number of cases Depth of display Height of display.
For weightlifters:
Product's stock, pcs/kg = Weight of the package or "1" if the weight of the package is not specified.
Stock qty
Quantity of products by category available in the store at the end of the selected period.
Coefficient of loading of the trading floor
The load factor of the trading floor = (Square meters of equipment+ Square meters of additional equipment) / Area of the trading floor.
Updated on: 09/01/2025
Thank you!