Planogram analytics
Planogram analytics
To go to Analytics, click on the button "Analytics" on the left side panel, which opens a drop-down list of analytical reports to analyze sales of goods displayed on the equipment.
Discrete / continuous distribution
The report provides an opportunity to analyze sales for each product on the planogram.
The indicator for analysis, period and type of distribution can be selected in "Filters".
Discrete distribution - goods are divided into four groups depending on the share of the selected indicator. Each group is highlighted in a different color. The distribution percentages can be changed in the analysis filters.
Continuous distribution - goods are also divided into four groups, but highlighted in one color, but with different saturation, which depends on the size of the indicator.
At the bottom of the page, there is a table that contains all the indicators of the analysis:
Turnover;
Turnover share of planogram;
Turnover per linear m. of layout;
Sales quantity;
Sales quantity share of planogram;
Receipts quantity;
Receipts quantity share of planogram;
Profit;
Profit share of planogram;
Profit per linear m. of layout;
Stocks quantity;
Stocks price;
Average turnover;
Average share of turnover from planogram;
Average turnover per layout linear meter m.;
Average quantity of sales;
Average share of sales from the planogram;
Average receipts quantity;
Average share of the receipts quantity from the planogram;
Average profit;
Average profit share from the planogram;
Average profit per layout linear meter m.
To set the columns in the table, click "Columns setttings".
To download the * .xls report to your computer, click "Download" on the top toolbar.
Quadrant analysis
Quadrant analysis makes it possible to analyze the planogram on two indicators. You can select metrics from the filter bar that opens on the right using the button on the right side of the toolbar.
The goods will change color according to the indicators. If, for example, the product has the first and second indicators above the average, it will be green. If the first indicator is below average and the second one is higher, it will be yellow.
For convenience, the filter panel has a coordinate axis with a hint in which color the product will be colored depending on the indicators.
When hovering over the product, a hint will appear with the article, product name, price, and values of the two indicators.
At the bottom of the page, there is a table that collects all the data of quadrant analysis. To set the columns in the table, click "Columns setttings".
The table shows the following indicators:
Turnover;
Turnover per linear m.;
Sales quantity;
Receipts quantity;
Profit;
Profit per linear m.;
Stocks quantity;
Stocks price;
Average turnover;
Average turnover per layout linear meter m.;
Average quantity of sales;
Average receipts quantity;
Average profit;
Average profit per layout linear meter m.
To download the * .xls report to your computer, click "Download" on the top toolbar.
Lost Sales
The "Lost Sales" report shows the number of days when the product was not sold or sales were abnormally low during the selected period.
To set the period for analysis, click on "Settings" in the right panel. To select a period, click on the date field, then select the start and end dates of the period to analyze and click "Apply".
Goods with lost sales will be highlighted in red. After hovering the mouse over the highlighted product, there will appear a hint with indicators: layout depth, quantity of losing days and product's stock.
At the bottom of the page, there is a table that collects all the lost sales from the current rack. To set the columns in the table, click "Columns setttings".
The table shows the following indicators:
Lost days quantity;
Average sales quantity per day;
Lost turnover;
Product stock on the shelf, psc;
Quantity of out of stock days;
Lost sales quantity;
Faces quantity.
To download the * .xls report to your computer, click "Download" on the top toolbar.
ABC analysis
ABC analysis allows you to divide the goods from the layout into groups on four indicators: Turnover, Profit, Sales quantity and Receipts quantity.
You can configure ABC analysis in the Filters panel, which is opened by clicking "Settings" on the right sidebar.
In the "Filters" panel, you can select the period for analysis, specify the percentage for each group of the distribution of ABC analysis for each indicator. Click the colored circle to the right of the group to change the color of that group. Click "Apply" to save the changes.
When you hover the mouse cursor over the product, there appears a hint with the article and product name, the layout depth parameter and the ABC analysis group.
At the top of the equipment, there is the "Display" switch to change the indicator, which is displayed on the layout.
At the bottom of the page, there is a table that collects all indicators of ABC analysis of the current rack. To set the columns in the table, click "Columns setttings".
The table shows the following indicators:
Turnover;
Turnover ABC;
Profit;
Profit ABC;
Receipts quantity;
Receipts quantity АВС;
Sales quantity;
Sales quantity АВС;
Product stock on the shelf, psc;
Average turnover
ABC by average turnover
Average profit
ABC by average profit
Average receipts quantity
ABC by average receipts quantity
Average quantity of sales
ABC by average sales
To download the .xls report to your computer, click "Download" on the top toolbar.
Shelf stocks analysis
The analysis shows the percentage of excess and lack of goods on the planogram in accordance with the established interval.
You can configure the stock analysis in the Filters panel, which is opened by clicking "Settings" in the right panel.
In the "Filters" panel, you can select the period and interval for analysis and configure the percentage between excess and large excess, lack and large lack of goods.
You can also change the colors of the goods on the planogram by clicking on the colored circle next to the indicator. Click "Apply" to save changes.
When you hover the mouse cursor over the product, there will appear a hint with the article, product name, parameter of excess or lack in percentage and product's stock.
At the bottom of the page, there is a table that collects all indicators of the stock analysis of the current rack.
The table shows the following indicators:
Faces quantity;
Stock of goods, pcs.;
Stock of goods, days (weeks, months);
Average number of product sales per day;
Excess / Lack (%);
Stocks quantity;
Stock cost.
To download the .xls report to your computer, click "Download" on the top toolbar.
Updated on: 01/09/2022
Thank you!