Harmonising data to make it sing

It is not unusual for data to have discrepancies in consistency, modes of measurement and coverage. This is a challenge when trying to get an accurate picture of the FMCG market and its consumers. Among the most long-standing and basic data in its vast library of data sets, IRI uses point-of-sale (POS) and Shopper Panel data in a complementary fashion to provide clients with a well-rounded view of attitudes and behaviours, down to the household level.

To ensure maximum data accuracy and usability, IRI adjusts and aligns this data through complex statistical processes. One of these processes is negative binomial distribution (NBD) adjustment. NBD is a widely accepted probability distributional model that can be used on observed or sampled data to provide alignment with other data sets.

Rising to the next level of accuracy

IRI moves to the next level of accuracy through the use of a complementary process known as NBD adjustment. Examples of this type of data include the frequency of purchases made by a given household, number of children in a household, etc. By applying NBD after panel data are weighted demographically, coverage becomes consistent and year-over-year variability is eliminated. And by using NBD to adjust penetration and buy rate, the internal consistency of the data is maintained.

In the FMCG world, IRI’s NBD adjustment methodology resolves any misalignment between panel and POS data, ensuring that various household-level statistics, including buy rate and penetration, are consistent with POS sales. And, since sales is equivalent to buy rate times penetration, the product of the two is perfectly aligned to the sales implied by POS. Similarly, statistics such as repeat purchasers and cross-purchasers, post-NBD adjustment, should likewise be consistent with POS.

Harmonising these data sets allows the emergence of a complete and accurate measure of product sales and consumer-level details associated with those sales, bringing to life not just the story of products being purchased, but also the consumers making those purchases and the influencers of those purchase behaviours. In short, NBD adjustment ensures the granularity of panel data with the accuracy of POS.

Constantly adjusting NBD to the evolving landscape

IRI is continually working to appropriately address ongoing complexities inherent in NBD, including those related to the reduced coverage in the beer/wine/ spirits channel and the convenience store geography. Our statisticians are actively testing the fundamental assumptions of zero-inflation and heterogeneity adjustment methodologies to understand the robustness of these models in low-coverage situations and assessing extended versions of NBD that allow coverage to be estimated.

The team is also exploring the utility of new and alternative data sources, such as convenience channel frequent shopper program (FSP) and shipment data, as a means of improving the adjustment of panel data, and analysing the multivariate time-series aspect of the data to incorporate the past, to inform the future and fuse multiple data sources to better stabilize estimates.

In other words, we are hard at work to ensure that NBD also means “now, better data!”

Learn more about IRI here.

Tom Doolan is IRI’s Asia Pacific operations director.

You have 7 articles remaining. Unlock 15 free articles a month, it’s free.