1. Home
  2. DotActiv - Basic & Advanced Reporting
  3. How To Analyze Data On Your Planogram
  1. Home
  2. DotActiv - Custom Reporting
  3. How To Analyze Data On Your Planogram

How To Analyze Data On Your Planogram

The purpose of this article is to provide you with an explanation on how to analyze data in DotActiv and where to access it.

Applicable Products: DotActiv Pro, DotActiv Enterprise

Planogram Analyzer Function

The ‘Analyzer’ function, found under the ‘Tools’ tab, is a function that evaluates the quality of your built planogram according to certain criteria. Criteria include:

  • Product attributes such as correct dimensions and presence of images, allocation and usage of space
  • The thoroughness of product classifications (according to the DotActiv hierarchy).
  • Days Of Supply alignment (making sure all products’ days of supply are more or less in the same ballpark, with no or minimum outliers).
  • Overall planogram neatness (making sure product tops are aligned, shelves are evenly spaced etc.)

On each of the criteria points, DotActiv will elaborate how you can improve your score if you click on the desired field. See image below.

Equalising Days of Supply

Days of Supply alignment is something that is of interest to any retailer. By equalizing your days of supply, you can ensure efficient stock replenishment rates.

Furthermore, it avoids unnecessary traffic of shelf packers running between point A and B between customers to fill certain parts of shelves numerous times during the week.

By equalizing days of supply, you ensure that all/most items in a category are replenished at more or less the same time.

Days of supply is directly related to space allocation on a shelf. The more facings you add, the longer your stock will be on the shelf before it is cleared out and thus the days of supply will be higher (and vice versa). You can view days of supply in 2 ways:

  • Average days of supply of the entire gondola. Do this by hovering over a blank space on the gondola, to see the statistic in the status bar at the bottom. See image below.
  • Days of Supply of a single product. This can help with equalizing days of supply by ensuring that each product’s days of supply are more or less in the same ballpark as the other products’ days of supply. The days of supply of a single product can be viewed in the following ways:
  • Status bar – do this by inserting days of supply as one of the fields you want to see in your status bar when hovering over a product. Do this by selecting File -> Setup -> Application Settings -> Status Text -> Status Bar -> double-click on ‘Days of Supply’ under the ‘Facts’ field to add it to the Status Bar -> ‘OK’

Please note that you can remove a field from the status bar by double-clicking on the relevant field in the ‘Status Bar’ window of the ‘Status Bar Setup’ pop-up window.

  • Floating status – do this by inserting days of supply as one of the fields you want to see next to the cursor when hovering over a product. Do this by selecting File -> Setup -> Application Settings -> Status Text -> Floating Status -> double-click on ‘Days of Supply’ under the ‘Facts’ field to add it to the Status Bar -> ‘OK’

Planogram Reports

Another way to analyze planogram data is by means of planogram reports. DotActiv provides various types of reports on which data can be analyzed. Some of these include:

Each of these reports has its own focus points on which you can analyze and review certain data related to the planogram.

The product report, for example, allows you to view various data such as Sales (Value & Percentage), Units (Value & Percentage), Forward Share, Actual Facings Deep and Capacity to name just a few. These are all dependent on what data you have imported and which columns you decide to show in the product report itself.

Highlights

The highlight function in DotActiv helps to organise, group and analyze planogram data. You can highlight the top/bottom sellers or the slow/fast movers which can help determine what products to remove from a range or add more facings to. It can also help gain insight on which products to place both on macro-level (floorplan) and micro-level (on shelf).

You can find this function in the ‘Tools’ tab under the ‘Planogram Analysis’ section.

Lastly, the ‘Guide’ function, in the ‘Planogram Analysis’ section, under the ‘Tools’ tab also helps to group products on the planogram according to certain characteristics. Just like with the highlight function, you will be able to identify groupings of products with the ‘Guide’ function.

Should the above steps not work for you, please create a support ticket and DotActiv support will assist you in uncovering the issue.

Updated on May 5, 2020

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support