Retail Analytics — Customer-level Data

The tools and techniques for retail analysis of customer-level data are the same as the ones used for consumer analysis. The focus however shifts from brands to outlets.

Analytics Suite

The range of commonly used analysis for customer-level retail analytics includes:

  • Customer (shopper) profile analysis
  • Loyalty and propensity
  • Assortment analysis
  • Overlap analysis
  • Outlet group analysis
  • Outlet repertoire analysis
  • Gain–loss analysis
  • Trial and repeat visit analysis for new outlets
  • Penetration and repeat rate
  • Sales forecasting (relevant for new outlets)

In consumer analytics the focus is on brands. For instance, profile analysis in consumer analytics pertains to consumer profile of brand users, whereas profile analysis in retail analytics pertains to customer (shopper) profile at outlets, where depending on the industry, outlets could be retail stores or bank branches or petrol stations etc.

Gain–loss in retail analytics examines outlet switching, whereas gain–loss in consumer analytics examines brand switching.

Similarly, in retail analytics, loyalty is in relation to banners, or stores or branches, and not brands.

Since the above-listed techniques have already been covered in Chapter Consumer Panels and Consumer Analytics, this chapter will not dwell on their methodology.

The case example, Evaluation of Opening of New Petrol Station , which comes later in this chapter, illustrates the application of some of these analyses.

Loyalty Panel Data and Consumer Panel Data

Data confined only to the retailer’s own transactions, as is the case with loyalty panels, curtails the scope of the above-listed techniques. Analysis of such data is restricted in context to the retailer’s customers and their transactions at the retailer’s outlets.

For example, penetration would be measured as the proportion of loyalty card holders. Analysis of gain–loss will not capture gains from and losses to competing chains. Forecasts would be confined within the boundaries of the retail chain. And metrics such as loyalty and propensity cannot be computed. Both these measures require an assessment of customers’ transaction across the entire market.

Consumer panels which are prevalent in the FMCG sector, provide a holistic view of the market and do not suffer the limitations of loyalty panels or CRM transaction data. They are however expensive to set up and maintain, and their sample size would tend to be relatively small compared to sales transaction data or loyalty panel data. So, while consumer panels can provide for better diagnostics, their samples sizes may be inadequate for analysis at the granular level.


Previous     Next

Use the Search Bar to find content on MarketingMind.







Marketing Analytics Workshop

Marketing Analytics Workshop

In an analytics-driven business environment, this analytics-centred consumer marketing workshop is tailored to the needs of consumer analysts, marketing researchers, brand managers, category managers and seasoned marketing and retailing professionals.


Digital Marketing Workshop

Digital Marketing Workshop

Unlock the Power of Digital Marketing: Join us for an immersive online experience designed to empower you with the skills and knowledge needed to excel in the dynamic world of digital marketing. In just three days, you will transform into a proficient digital marketer, equipped to craft and implement successful online strategies.


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.