Stores
The Stores group contains three dashboards that analyze commercial performance at location level: a full KPI breakdown per store, a cross-store × category analysis, and a product assortment view showing which products are sold at each location.
Navigate to Retail Analytics → Stores and select the relevant tab.
Detail by Store
Path: Retail Analytics → Stores → Detail by Store tab (default)
The primary store performance dashboard. Shows all key commercial metrics for each location side by side, enabling users to identify top-performing and underperforming stores and compare each location against the company average.
Key Metrics
Summary KPIs (top of dashboard):
| Metric | Description |
|---|---|
| Total Sales | Sales for selected stores and period, with % variation |
| Total Purchases | Ticket count with % variation |
| Average Ticket | Sales / Purchases |
| Total Customers | Unique loyalty members who purchased |
| Frequency | Average purchases per customer |
| Penetration | % of active customers who purchased in the selected period |
| % Private Label | Private label sales weight within selected stores |
Detail table — one row per store with 25+ metrics:
| Metric | Description |
|---|---|
| Sales | Total sales at the store in the base period |
| % Var. Sales | Variation vs. compared period |
| Identified Sales | Sales attributed to loyalty members |
| % Var. Identified Sales | Variation in identified sales |
| % Sales Weight | Store sales / Total company sales |
| Units | Product units sold |
| Unitary Price | Sales / Units |
| Purchases | Total checkout transactions |
| Identified Purchases | Transactions with a loyalty member identified |
| Average Total Ticket | Sales / Purchases |
| Customers | Unique customers who bought at the store |
| Margin | Sales − tax − cost |
| % Margin | Margin / Sales |
| Average Expenditure | Identified Sales / Unique customers |
| Frequency | Identified purchases / Unique customers |
| Penetration | Customers at this store / Total active customers |
| New Registrations | New loyalty members registered at this store |
| Active Customers | Members with at least one purchase in the period |
| % Private Label | Own-brand sales share |
Evolution chart — metric over time for selected stores (one line per store). Configurable metric and granularity.
Average comparison panel — shows each store's metric relative to the company average, making outliers immediately visible.
Filters
Base date period, Compared date period, Audience, Taxonomy, Product Categories, Products, Supplier, Brand type, Store categories, Stores, Carts (all/identified/unidentified), Chart Metric, Chart granularity, Comparable stores only.
Category KPIs by Store
Path: Retail Analytics → Stores → Category's Contribution tab
A cross-dimensional dashboard that shows how each category performs across each store. Enables comparison of the same category across locations and comparison of different categories within the same location.
Use cases:
- Identify stores where specific categories are underperforming to adjust assortment or launch geo-targeted promotions
- Find categories with low penetration across stores to build targeted campaigns
- Compare category contribution across store formats
Key Metrics
Bar Chart — shows the selected metric for the top 10 categories across the top 50 stores (one grouped bar per store, one bar per category).
Heatmap — stores (rows) × categories (columns), with cell color intensity reflecting the selected metric. Makes outlier store/category combinations instantly visible.
Detail Table — per store × per category with 18 metrics:
| Metric | Description |
|---|---|
| Sales | Category sales at the store |
| % Var. Sales | Variation vs. compared period |
| Identified Sales | Sales from loyalty members |
| Units | Units sold |
| Purchases | Ticket count |
| Identified Average Purchases | Identified Sales / Identified Purchases |
| Average Expenditure | Identified Sales / Customers |
| Customers | Unique customers who bought the category at this store |
| % Categories Penetration | Customers / Total active customers in period |
| Frequency | Identified purchases / Customers |
| % Sales Weight | Category sales at store / Total company sales |
Selectable metric (applies to chart and heatmap): Sales, Identified Sales, Sales Weight, Units, Carts, Average Identified Purchase, Average Expenditure, Customers, % Category Penetration, Frequency.
Filters
Base date period, Compared date period, Audience, Taxonomy, Product Categories, Supplier, Brand, Store categories, Stores, Metric Selector.
Assortment by Store
Path: Retail Analytics → Stores → Assortment by Store tab
Shows the product catalog sold at each store and, conversely, the list of stores where each product has been sold. A dual-view tool for assortment management: quickly see which products are present at which locations and compare their sales performance.
Key Metrics
View 1 — By Product (product rows → store drill-down):
For each product: Sales, % Var Sales, Units, % Var Units in the base period. Clicking on a product expands to show every store where it was sold, with per-store: Sales, % Var Sales, Units, % Var Units, % Sales Weight (product sales at store / total product sales), % Quantity Weight (units at store / total units).
View 2 — By Store (store rows → product drill-down):
For each store: Sales, % Var Sales, Product Units, % Var Product Units. Clicking on a store expands to show every product sold at that location, with: Sales, % Var Sales, Product Units, % Var Units, % Sales Weight (product sales / total store sales), % Quantity Weight (product units / total store units).
Summary chart — sales and % variation aggregated by product or store, with a visual bar for rapid comparison.
Filters
Base date period, Compared date period, Audience, Taxonomy, Product Categories, Products, Supplier, Brand type, Store categories, Stores, Carts (all/identified/unidentified), Comparable stores only.