Skip to main content
Docs
Cookies
AnalysisMenu

Analysis

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.


Analysis tab

  • 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.

  • Each is a drop down menu. The metrics are Share of Facings, Share of SKUs, Share of Linear Space, Share of Quadratic Space and Sales.
  • 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.

Search the Ask, Coplan, Studio and Account guides and the glossary