Products
The Products group contains four dashboards that analyze performance at individual SKU level: how products are classified and ranked, how they evolve from launch, which products are bought together in the same cart, and how replaceable each product is in the assortment.
Navigate to Retail Analytics → Products and select the relevant tab.
Products by Classification
Path: Retail Analytics → Products → Products by Classification tab
A comprehensive product-level ranking table showing all commercial KPIs per SKU. The primary reference for category managers and trade marketing teams to understand which products are driving growth and which are declining.
Key Metrics
Per-product detail table with 30 metrics:
| Metric | Description |
|---|---|
| Sales | Total sales for the product in the base period, with % variation |
| Units | Units sold, with % variation |
| Unitary Price | Sales / Units |
| Purchases | Ticket count containing the product, with % variation |
| Average Purchase | Sales / Purchases |
| Customers | Unique customers who bought the product |
| Margin | Sales − tax − cost |
| % Margin | Margin / Sales |
| Average Expenditure | Identified Sales / Unique customers |
| Frequency | Identified purchases / Unique customers |
| UMS | Units per Month per Store — avg units sold per store per month |
| UPT | Units per Transaction — avg units of this product per cart |
| % Promotional Sales | % of sales where a promotion was applied |
| % Purchases 1 Unit / 2 Units / 3 Units / 4–6 / 6+ | Distribution of cart sizes (how often customers buy 1, 2, 3, etc. units) |
All metrics include period-over-period % variation.
The dashboard also includes a period validity indicator showing how many stores had sales in both the base and compared periods — useful for assessing whether variations may be biased by different store coverage.
Filters
Base date period, Compared date period, Audience, Taxonomy, Product Categories (mandatory), Products, Supplier, Brand type, Store categories, Stores, Carts (all/identified/unidentified), ID/EAN display option, Company currency.
Products Evolution
Path: Retail Analytics → Products → Products Evolution tab
Tracks the market trajectory of a single product from its launch date. Shows how it performed compared to other products launched in the same period, and analyses customer repeat-purchase behavior (first-time buyers vs. repeaters).
Key Metrics
Tile 1 — Launch context:
| Metric | Description |
|---|---|
| New Products | Count of products launched in the same period as the selected product |
| Total New Products Sales | Total sales of all products launched in the same period |
| Sales (Selected Product) | Sales of the selected product in the analysis window |
| % Sales Weight | Selected product sales / Total new products sales |
| Margin (Selected Product) | Sales − tax − cost for the selected product |
Tile 2 — Purchase frequency distribution (total period):
Bar chart showing how many unique customers bought the product 1 time, 2 times, 3 times, 4 times, 5–10 times, or more than 10 times during the selected period.
Tile 3 — Repeat purchase behavior (monthly evolution):
Month-by-month view showing:
- First-time buyers — customers buying the product for the first time each month
- Repeater customers — customers who bought at least twice (either within the month or having purchased previously and returning)
Filters
Monthly evolution (1–12 months from launch date), Taxonomy, Product Category, Product (mandatory — single select). The analysis window is built automatically from the product's first historical purchase date.
Product Concurrency
Path: Retail Analytics → Products → Product Concurrency tab
Measures how often a product or category appears in purchase acts — what percentage of carts include a given SKU or category. Helps identify highly recurrent products (essentials) vs. occasional purchases.
Key Metrics
Table 1 — Product Penetration:
| Metric | Description |
|---|---|
| % Total Penetration | Tickets containing the product / Total tickets. What % of all carts include this product |
| % Relative Incidence by Product | Tickets containing the product / Tickets containing the product's category. How often the product appears within its category's carts |
Table 2 — Product Category Penetration:
| Metric | Description |
|---|---|
| Relative Incidence by Category | Tickets containing the category / Total tickets. What % of all carts include any product from this category |
Filters
Date period, Audience, Taxonomy, Product Categories, Products, Supplier, Brand type, Store categories, Stores, ID/EAN display option.
Product Substitutability
Path: Retail Analytics → Products → Products Substitutability tab
Evaluates the importance of each product in the assortment based on a configurable substitutability score. Helps make assortment decisions: which products can be removed with minimal impact vs. which are essential and hard to substitute.
The score is defined by the company using a weighted combination of metrics (default: Sales, Units, Customers). Higher score = more important in the assortment.
Score formula: Score = (Weight₁ × Metric₁) + (Weight₂ × Metric₂) + (Weight₃ × Metric₃) where all metrics are normalized before weighting.
Key Metrics
Per-product table:
| Metric | Description |
|---|---|
| Score | Weighted composite score. Higher = harder to substitute |
| Variable 1 / 2 / 3 | The three metrics selected for the score formula (e.g. Sales, Units, Customers) |
| % Var. Score | Score variation vs. compared period |
The dashboard also shows context information about the selected features and category at the top.
:::note Configuration required The score formula (metrics and weights) must be defined per company before this dashboard is available. Contact Customer Success to set up or adjust the substitutability score configuration. :::
Filters
Base date period, Compared date period, Audience, Taxonomy, Product Categories (mandatory), Products, Supplier, Brand, Brand type, Store categories, Stores, Carts (all/identified/unidentified).