Outlet Group Analysis (Retail Tracking Data)

Exhibit 21.1   Forming outlet groups.

Retail analytics using tracking data (retail audit/scan data) essentially involves filtering the data to form one or more outlet groups (refer to Exhibit 29.1). The groups may be defined based on the physical characteristics of the outlets (e.g. location, size, type of outlet, type of facilities etc.) or on the sale and distribution of products.

Outlet grouping serves the purpose of drilling into relevant data. If a particular retail issue is to be evaluated, the groups are configured so that they provide a deeper understand of that issue. For example:

  • Handlers’ analysis: Outlets are filtered according to whether they stock a product, or any combination of products.
  • Assortment analysis: E.g. outlets that stock 1 or 2 models of Sony TVs, outlets that stock 3 to 6 models, and outlets that stock more than 6 models.
  • Brand overlap: E.g. outlets that only distribute Coca-Cola, outlets that only distribute Pepsi and outlets that distribute both Coca-Cola and Pepsi.
  • Shelf space analysis: E.g. in the breakfast cereals category, outlets with less than 10% forward stock and outlets with more than 10% forward stock of health cereals.
  • Pricing: Group stores according to the average price at which some product was sold. Or group according to comparative pricing, e.g. stores where Pantene shampoo is cheaper than Sunsilk, and stores where it is more expensive.
  • Promotion: E.g. petrol stations that promoted RON 92 fuel and those that did not promote.
  • Rate of sale: Group stores into heavy, medium and light on the basis of their rate of sales for a category.


Previous     Next

Note: To find content on MarketingMind type the acronym ‘MM’ followed by your query into the search bar. For example, if you enter ‘mm consumer analytics’ into Chrome’s search bar, relevant pages from MarketingMind will appear in Google’s result pages.

Online Apps to train Category Managers

Online Apps to train Category Managers

The Plannogrammer is an experiential learning facility for category managers, trade marketers, and retailers in consumer markets. Ideally suited for hybrid learning programmes, Plannogrammer imparts hands-on training in the planning and evaluation of promotions and merchandising.

It supports a collection of simulation and analysis platforms such as Promotions and Space Planner for optimizing space and promotions, Plannogram for populating shelves and merchandising, a Due To Analysis dashboard that decomposes brand sales into the factors driving sales, and a Promotion Evaluator to evaluate the volume, value and profit impact of promotion plans.