Metrics - group of metrics on Datawiz BI service
There is a list of metrics of the group "Assortment activity".
Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.
Identifier
number code of product, which is used in chain account system.
Note! On the "Recommended % of Layout" report the metric is displayed only at the Product level.
Barcode
a number affixed to a product or its packaging in the form of a machine-readable barcode.
Note! On the "Recommended % of Layout" report, the metric is displayed only at the Product level.
ABC on sales (qty of sales, qty of receipts, profits)
shows to which group of sales (A, B or C) the product belongs (qty of sales, qty of receipts, profits) over the selected period.
Available metrics: Turns, Sales Qty, Receipts Qty, Profit, Stock Qty at the end of the day, Primecost of balances at the end of the day.
Default values:
- A = 80% - goods that make up 80% of total.
- B = 15% - products that include the remaining 15% of total.
- C = 5% - products that include the last 5% of total (recommended to be removed from the assortment).
XYZ Analysis
indicates to which group (X, Y or Z) a product belongs according to sales stability index over the selected period. Stability means calculating the coefficient of variation of sales fluctuations.
Recommended benchmarks for this analysis:
- X = 0.4 - products with stable sales;
- Y = 0.6 - products with slight fluctuations in sales;
- Z = 10 - products with the largest fluctuations in sales (unstable sales dynamics).
Distribution by price
shows to which price group I, II or III products belong according to the parameters specified in the filters over the selected period.
Assortment type
Product assortment type (Active, Inactive) according to the data provided by the client.
SKU Amount
number of unique product items (articles).
Qty of new SKU
qty of SKUs that were introduced into the assortment of the chain (store) for the selected period.
Qty of active SKU
number of SKUs sold for the selected period.
Qty of active SKU Change
the difference between the qty of active SKUs metrics for the selected period and for the previous period.
Qty of active SKU Change, %
the difference between the qty of active SKUs for the selected period and for the previous period, calculated as a percentage.
% of active SKU Qty
the percentage of active SKUs from the total qty of SKUs for the selected period.
Promo SKU Qty
qty of SKUs participating in promotions for the selected period.
Promo SKU Qty Change
the difference between the promo SKU qty for the selected period and for the previous period.
Promo SKU Qty Change, %
the difference between the promo SKU qty for the selected period and for the previous period, calculated as a percentage.
Active Promo SKU Qty
SKU Qty included in the promotions and sold in the selected period.
Promo active SKU Qty Change
the difference between the promo active SKU qty for the selected period metrics and for the previous period.
Promo active SKU Qty Change, %
the difference between the promo active SKU qty for the selected period metrics and for the previous period, calculated as a percentage.
% of active Promo SKU Qty
the percentage of active promo SKUs from the qty of active SKUs for the selected period.
Qty of SKU on stock
the qty of SKUs available on the stock for the selected period.
Qty of SKU on stock Change
the difference between the qty of SKU on stock for the selected period and for the previous period.
Qty of SKU on stock Change, %
the difference between the qty of SKU on stock for the selected period and for the previous period, calculated as a percentage.
Qty of non-active SKU
qty of SKU in the category that were not sold for the selected period and are on the stock.
Qty of non-active SKU Change
the difference between the qty of non-active SKU for the selected period and for the previous period.
Qty of non-active SKU Change, %
the difference between the qty of non-active SKU for the selected period and for the previous period, calculated as a percentage.
% of inactive SKUs
the percentage of inactive SKUs from total qty of SKUs for the selected period.
Change of inactive SKUs, %
the difference between the % of inactive SKUs for the selected period and for the previous period.
Qty of active brands
qty of brands were sold at least once for the selected period.
Qty of active brands Change
the difference between the qty of active brands for the selected period and for the previous period.
Qty of active brands change, %
the difference between the qty of active brands for the selected period and for the previous period, calculated as a percentage.