Chain sales analysis

The "Chain sales analysis" report helps you more effectively analyze network performance. Compare turnover, profit, sales quantity, and receipts between stores using a bar chart that visualizes key metrics and simplifies the analysis of large amounts of data. Track changes compared to the previous period and move from the overall picture on the chart to detailed data in the summary table for each store, planogram, category, or product.

In this article, we will review the "Chain sales analysis" report: how to configure it and which metrics are available for analysis.

Contents

How to configure the report
How to work with the bar chart
How to work with the summary table
Report metrics

How to configure the report 

To open the report, click "Reports" → "Analytics" on the top navigation bar of the service. 

The toolbar is located at the top of the page:

1. To analyze only the required data sample, click the "Filters" button and configure the parameters : 
2. • Period — the time range for which the report is generated. The last 30 days are set by default;
   • Previous period — the time range that the main period is compared to. The 30 days before the start of the main period are set by default;
   • Calculation type — the type of data calculation for the bar chart and summary table:
   • • All sales — includes all sales of all products for the selected periods;
     • Sales of laid out products only — includes only products laid out on planograms at the time of analysis;
     • Sales of products linked to blocks only — includes only products linked to blocks. Read more about blocks in the article;
   • Planogram status is active only after selecting the "Sales of laid out products only" or "Sales of products linked to blocks only" calculation:
   • • In progress;
     • Scheduled sending;
     • On execution;
     • For check;
     • Returned for execution;
     • Confirmed.
   • Categories;
   • Brands;
   • Suppliers;
   • Store formats;
   • Store groups;
   • Shops.
2. Report data is automatically grouped by the "Store plans" dimension. To change this, click the dropdown list and select a different dimension:
3. • Planograms — this dimension is only available after selecting the "Sales of laid out products only" or "Sales of products linked to blocks only" calculation (configured in Filters);
   • Categories;
   • Products.
3. To download the report in .xls format, which will contain two sheets — "Histogram" with a bar chart image in .png format and "Table", click "Download" and select: 
4. • Download current report view — the downloaded file is generated based on the applied filters, search, and manually expanded levels;
   • Download full report — the downloaded file is generated based on the applied filters, search, and all expanded levels, from general metrics to individual products.

How to work with the bar chart 

The bar chart simplifies the analysis of large amounts of data and helps to:

• Quickly compare metrics for stores, planograms, categories, and products (for example, the turnover of store №1 and №2 for the month);
• Identify leaders and laggards by the selected metric (for example, which category generates the most profit and which generates the least);
• Detect anomalies and sharp changes without having to review the entire table row by row (for example, a sharp drop in sales at a specific store);
• Compare the current and previous periods to assess metric changes (for example, whether the number of receipts increased after changing the product layout);
• Quickly present results to the team and management (for example, show a chart at a meeting instead of a table with dozens of rows).

To configure the chart, click "More options" in the upper-right corner of the visualization: 

• Metric — hover over the item to expand the list and change the chart metric: Turnover, Profit, Sales qty, or Receipts qty;
• Display — hover over the item to expand the list and select the column sort order. Select "Largest" to quickly find leaders, or "Smallest" to focus on store plans with the lowest metrics;
• Settings — click to open the "Visualization settings" modal window, where you can:
• Default indicator;
• Configure how many elements (for example, store plans) to display on the chart (from 1 to 100);
• Personalize the colors of the current and previous periods.
• Save as PNG — click to download the chart as an image.

How to work with the summary table  

At the bottom of the page, a summary table is displayed that complements the chart: use it to analyze the metrics of a specific store, planogram, category, or product in more detail and understand the reasons for changes noticed in the chart.

The following tools are available above the table for convenient data work:

• Search — depending on the selected dimension, search for the required row in the table by store plan name, planogram, category, or product name, as well as by article and barcode;
• Customize columns — select the metrics to be displayed in the table to focus only on the required data;
• Save the table template — save the column settings so you don't have to reconfigure the table every time.

In addition, the table can be flexibly configured to your needs: 

• Drag columns by name to change their order;
• Hold the right corner of the column header and drag it left or right to change the column width;
• Click the column name to switch the sort order: ascending, descending, or no sorting.

Report metrics 

The table contains metrics for sales, profitability, and efficiency of retail space use. Below is their description and calculation method. 

1. Product attributes: 
2. • Product / category / brand / store / planogram name;
   • Article;
   • Barcode;
   • Brand name;
   • Type;
   • Suppliers.
2. Turnover:
3. • Turnover — the total cash receipts from product sales for the current period;
   • Turnover for prev. period — the total cash receipts from product sales for the previous period;
   • Turnover change — the numerical difference in turnover between the current and previous period;
   • Turnover change, % — the percentage difference in turnover between the current and previous period;
   • Turnover per liner m of equipment = Product turnover for the current period / Linear meters of equipment on which the product is located;
   • Turnover per liner m of equipment for previous period = Product turnover for the previous period / Linear meters of equipment on which the product is located;
   • Turnover per liner m of layout = Product turnover for the current period / Linear meters of layout of this product;
   • Turnover per liner m of layout for previous period = Product turnover for the previous period / Linear meters of layout of this product;
   • Turnover per square m of equipment = Product turnover for the current period / (Equipment depth * Equipment width);
   • Turnover per square m of equipment for previous period = Product turnover for the previous period / (Equipment depth * Equipment width).
3. Profit:
4. • Profit — the difference between revenue from product sales (turnover) and the cost of products for the current period;
   • Profit for prev. period — the difference between revenue from product sales (turnover) and the cost of products for the previous period;
   • Profit change — the numerical difference in profit between the current and previous period;
   • Profit change, % — the percentage difference in profit between the current and previous period;
   • Profit per liner m of equipment = Product profit for the current period / Linear meters of equipment on which the product is located;
   • Profit per liner m of equipment for previous period = Product profit for the previous period / Linear meters of equipment on which the product is located;
   • Profit per liner m of layout = Product profit for the current period / Linear meters of layout of this product;
   • Profit per liner m of layout for previous period = Product profit for the previous period / Linear meters of layout of this product;
   • Profit per square m of equipment = Product profit for the current period / (Equipment depth * Equipment width);
   • Profit per square m of equipment for previous period = Product profit for the previous period / (Equipment depth * Equipment width).
4. Receipts quantity:
5. • Receipts qty — the total number of product sales receipts for the selected period, excluding return receipts;
   • Receipts qty for prev. period — the total number of product sales receipts for the previous period, excluding return receipts;
   • Receipts qty change — the numerical difference in receipts qty between the current and previous period;
   • Receipts qty change, % — the percentage difference in receipts qty between the current and previous period.
5. Sales quantity:
6. • Sales qty — the total number of product units sold for the selected period;
   • Sales qty for prev. period — the total number of product units sold for the previous period;
   • Sales qty change — the numerical difference in sales qty between the current and previous period;
   • Sales qty change, % — the percentage difference in sales qty between the current and previous period.
6. Other:
7. • Linear meters of equipment = (Number of shelves + Base) * Equipment width;
   • Linear meters of layout:
   • • For packaged or weighted product in packaging: Linear meters of layout = Product width * Facings qty;
     • For weighted product in a box: Linear meters of layout = (Box length — Wall thickness) * linear meters of product layout.
   • Faces qty — the total number of product faces;
   • Product stock, pcs/kg — the total number of products laid out on the planogram:
   • • For packaged products: Product stock on shelf, pcs = Facings qty * Layout depth * Layout height;
     • For weighted products: Product stock on shelf, kg = Packaging weight or "1" if packaging weight is not specified.
   • Stock qty — the number of products in the dimension available in the store at the end of the selected period;
   • Stocks price = Product cost * Stok qty of this product.

Updated on: 14/09/2026