Image
Excel
Use Analysis to chart share of products, facings, linear space, quadratic space or sales by tag, and download the results as Excel or a chart image.
Select Analysis under Studio in the navigation panel to find data from the planogram.
This is done by adding KPI and tags that you are interested in. The tags will be from the input file and can include brand, category, subcategory and segmentation.
It can calculate share of products, facings, linear space and quadratic space
for the planogram, and sales if the input file has a tags.sales column (see
Tags and segmentation). Quadratic space uses each
product’s width and height, not its depth.
Choose what the analysis shows:
Choose the scenario fixture, or All Fixtures to analyse every fixture in the project together. All Fixtures adds up the facings, space and sales of every fixture, and counts a product on several fixtures once in Share of SKUs.
Choose a bay, or All Bays, to analyse one bay of the fixture. Then choose a shelf in that bay, or All Shelves. You can choose a shelf only once you have chosen a bay. Bay and Shelf are only available when you choose a single fixture, not All Fixtures. Choosing another fixture sets Bay and Shelf back to All Bays and All Shelves.
Choose the metrics that you want to be shown on the graphs
Choose the brand/subgroup that you would like to compare data.
Choose whether you would like the graph to show numbers or percentages.
Select Download, then Excel, to download an Excel file with all of the analysed data. The Excel file always covers whole fixtures, whichever bay or shelf you chose.
Analysis shows this information as a graph too. Select Download, then Image, and the chart on screen will download as a PNG image. Its title names the bay and shelf you chose.
Once all parameters have been chosen, the graph shows a group of bars for each value of the tag, for example each product subgroup, with one bar for each metric you chose.
The side panel’s Detail for a fixture, bay or shelf also shows its analysis. Select Charts beside its Analysis heading to open Analysis on that fixture, bay or shelf.