Scan sales data, captured at the point-of-sale (POS) terminals, is usually broken down by weeks. The weekly cycle should preferably coincide with the chain’s promotional week.
Scan data provides volume and value sales, and price information. It does not provide us with stock or purchase data. Distribution is based on sales (sales distribution), i.e., no sales for a time period means no sales distribution.
Data collection for manual audits is conducted on a monthly cycle by field personnel called retail auditors. They collect the following information from each store in the retail sample:
The auditors have monthly work cycle plans, and they usually audit the same stores on the same day of the month. In the example in Exhibit 28.8 , a new store is added to the retail panel in January. The auditor conducts the first audit for the store on 25 January at which time information on purchases is not available. The store is re-visited on the 25th of each month. The stock count on 25 January becomes the opening stock for the period 25 January to 25 February. Stock count on 25 February is the closing stock for the same period, and the opening stock for the period 25 February to 25 March.
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.
Suite of interactive, online dashboards that seamlessly integrate retail and consumer data sources in a manner that makes it easier to glean insights.
Suite of dashboards to visualize/analyse retail scan data.
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.