With the Store Perf screen, you can check a store's commercial performance. But what about its efficiency in relation to the resources, items, and stock you’ve provided?
That is exactly the purpose of the Store Means Perf screen.
First, you can define your analysis context, just like with all other nostress screens.
You can filter and group the analyzed stores based on criteria that are relevant to you (region, country, concepts...) and finally segment the data according to the dimensions available in your system, such as activity.
This screen also allows you to select and customize the order of the columns you want to display.
All commercial data for the store is at your disposal: revenue, traffic, conversion rate...
I encourage you to refer to the glossary for further information.
First, a clarification about the limitation to active items:
This screen allows you to verify the efficiency of your resources, whether in terms of the number of items or stock units.
Data quality is therefore critical. To ensure this, we have included an option that restricts the analysis to what can be considered "active" resources.
The "Active Items" option is checked by default. While it depends on the retailer, it typically limits the items and stock to active and future collections for each day of analysis.
For example, September 10, 2024, falls under the H24 season. The active collection is H24. By selecting "Active Items," the analysis only considers items from the H24 collection and onward, such as SS25.
However, this screen also provides you with more strategic insights :
Discounted revenue : Products not sold at full price.
Quantity: The sum of quantities sold. This information is not new but is crucial here as it is used to weight the average of items sold, whether for totals or grouping values (more details at the end of the article).
Stock: This refers to the in-store stock at the end date of the selected time period (note that transit is not included).
Revenue/m²: Revenue per square meter (or ft²) of the store or the sum of grouped stores. Be aware that when splitting by activity or applying a product filter, since only the total store surface is known, revenue is always calculated based on the total store surface (which explains why figures are always lower when splitting).
Items in stock: The number of items that were in stock in the store during the selected period. Note that only items with a positive total sales quantity are counted (this automatically excludes items in stock due to returns only).
Items sold: The number of items sold in the store during the selected period. Again, only items with a positive total sales quantity are considered (this excludes items sold due to returns only).
Total items: The number of items either sold or in stock in the store during the selected period. If this number exceeds the number of items in stock, it is not unusual; items can be sold without being in store stock (e.g., via tablets).
Revenue per item in stock: Revenue divided by the number of items in stock. The aim is to assess the efficiency of resources, using the number of items in stock rather than the total number of items.
Items/m²: The number of items in stock per square meter (or ft²) of the store or grouped stores. Be cautious when splitting by activity or applying a product filter, as the specific surface area is not known. The number of items in stock is then calculated based on the store's total surface area, which explains why figures are typically lower in this case. This allows you to assess the store’s offer density in terms of item count.
Item efficiency: This metric measures whether your store is more or less efficient relative to the available offer.
Formula: progression in items in stock + progression in revenue per item in stock.
If positive, it means that the revenue progression per item in stock exceeds the overall revenue progression per item, indicating that your resources are more efficient in this configuration compared to Y-1 or Y-2.
If negative, it means that the revenue progression per item in stock is lower than the overall revenue progression per item, suggesting less efficient resource usage in this configuration compared to Y-1 or Y-2.
Example:
If the number of items in stock decreases by 25%, but revenue per item decreases by only 10%, your efficiency is +15%.
Conversely, if the number of items in stock increases by 5%, but revenue per item decreases by 7%, your efficiency is -2%.
Stock/m²: The number of items in stock relative to the store's area in m² (or ft²), whether for a single store or a group of stores. Note that if you split by activity or apply a product filter, the specific dedicated area is not known, so the stock is calculated relative to the store's total surface area. This often results in lower figures. This metric helps visualize the density of the store's offering in terms of items.
Stock Efficiency: This indicator measures whether your store is more or less efficient relative to the number of items available in stock.
Formula: revenue growth - stock growth.
If positive, it means that revenue growth exceeds the growth in the number of items in stock. Your resources are therefore more efficient in this setup compared to Y-1 or Y-2.
If negative, it means that revenue growth is lower than the growth in the number of items in stock. Your resources are therefore less efficient in this setup compared to Y-1 or Y-2.
Note on groupings and totals:
The goal is to provide an overall view of average efficiency across groups and totals.
Data on item counts are therefore not simple sums or arithmetic averages but weighted averages based on the quantities sold per store.
Example:
Store A: 1000 items in stock and 100 units sold.
Store B: 100 items in stock (entirely different from Store A) and 10 units sold.
In the grouped view, the number of items in stock is not 1100 (sum) or 550 (arithmetic average) but calculated as:
((1000 * 100) + (100 * 10)) / (100 + 10) = 918 items.
Do not confuse this figure with the number of items visible in other screens like Product Perf, which corresponds to the total number of items sold.