Kantar Market Data: Consumer Panel Data Terms Explained

Published on: 28th April 2015, Updated on: 14th November 2024

Written By:

Andy started at the coal face with eight years in food retailing. Prior to joining MBM he then spent five years in the supply base in positions of category analysis, category management and account management. He works as part of the team enabling suppliers to UK supermarkets to secure more profitable wins through people development. He specialises in Category Management Training and is a qualified HBDI practitioner. Connect with Andy on LinkedIn.

Decode the Kantar Market Data Panel

The Kantar consumer panel data can be confusing. Below is an overview of the basic measures used within Kantar market data.

A list of this nature could be endless because there are so many measures and more seem to arrive each day! Here are the most common five and often most misunderstood measures used in the Kantar market data.

Net Revenue Management Training Course — Click the green button to learn more

#1: Penetration – Shoppers Buying

The percentage of GB households purchasing in the chose category at least once in that time period. For example, your penetration might be 21%. This means that 21% of the GB households have purchased at least once in the chosen time period, which is normally 4, 12, or 52 weeks.

#2: Frequency – How Often they Bought

The average number of occasions that the chosen category was purchased by a market buyer in that time period. For example, your frequency might be 4.5. This means that your category of buyers bought that product four and a half times in the chosen period, which is normally 12 months. Chips are probably bought once per month, so have a frequency of 12 and mangoes are probably bought 4 times per year, so they have a frequency of 4.

Pardon the Interruption: Checkout our Nielsen Products in the Shop

#3: Average Weight of Purchase – How Much they Bought

Gold and bronze coin piles on weight scale — One of the measures used by Kantar is the average weight of the purchase

The average amount bought by each household which purchased the product in that time period. This can be expressed in terms of Spend (Expenditure), Volume (Kgs) or Units (Packs). For example, the AWP might be £2.10 for oranges, meaning that the sopper bought £2.10 worth of oranges each time they shopped. If the average price for a pack of oranges is £1.05, then they are buying two packs on each shopping trip.

#4: Amount Spent /Volume per trip – How Much they Bought

The average sterling value per transaction or the average purchase weight per transaction. For example, you might have a statistic of 1.7 packs from the Kantar market data. This means that the shopper bought just under two packs on their shopping trip.