Store Sales Report

Learn how to use the Store Sales Report dashboard

Summary

The Store Sales Report helps you see which regions, formats and stores are driving your performance.  It shows trends for your sales metrics for key reporting periods broken down by store, region, format and SKU. 

• See where your products sell best, and use this understanding to inform your proposals when preparing for a range review.

• Spot product trends in different formats, such as online, to stay ahead of the curve.

Setting up the dashboard

The dashboard gives you four configuration options in the top bar, from left to right:

• Table breakdowns: change whether the tables show Store, Region, Format, Category, Subcategory, Brand or SKU. 
  • Table breakdown 1: The default setting is Store.
  • Table breakdown 2: The default setting is SKU.
• Select metric: Choose whether to display sales value or volume. The default setting is Sales Value.
• Comparison: the period selected to compare against. If you choose 'vs previous', the comparison is made against the directly preceding period of the same duration. Year to Date always compares against last year. The default setting is 'vs Last Year'
• Sort by: Sales (selected value or volume), Variance (vs selected comparison) or Variance percentage (vs selected comparison).
  
  

What's on screen

There are two components on-screen, from top to bottom:

• Key Performance Indicator (KPI) Tiles: the KPI summary tiles along the top show the selected metric over the different time periods; Year to Date, Last week, Week to Date, 52 Weeks, 12 Weeks and 4 Weeks, as well as the absolute percentage change from the selected comparison.
• Tables: based on the chosen breakdown level, the tables display the selected metric and its variance to the selected comparison in two cells. The colour indicates the variance from the selected comparison. Hover over a cell for more information. You can sort the tables by sales, variance or variance percentage enabling you to find the biggest changes.