I want to wholeheartedly thank Robin and Sally for trusting me as the new steward of the incredible CPG Data Tip Sheet. As they mentioned in their post last week, the site truly helped me get up to speed on CPG analytics, fundamentals, and terminology when I started my career at Nielsen over a decade […]
How To Understand Your Database
From Syndicated to Custom: Transform Your Nielsen/IRI Product Data – Part 2
In my previous blog post, I described two ways to customize your Nielsen/IRI product data by renaming and grouping product values. In a continuation of that post, I’ll now describe a third way of customizing your data—by creating new attributes. 3. Create New Attributes We’re all accustomed to creating new measures, like dividing dollars by units […]
From Syndicated to Custom: Transform Your Nielsen/IRI Product Data – Part 1
The “syndicatedness” of IRI/Nielsen data is one thing that makes it so powerful. Think about it: IRI and Nielsen capture, label and organize millions of product transactions across hundreds of retailers and then distribute a comprehensive dataset set to thousands of businesses. As a result, everyone can start with the same data, making it easier […]
New Age Panels: The Next Gold Standard for Shopper Data?
We are delighted to share this guest post from panel data guru Paul Hunter. Paul is the Markley Visiting Professor at Miami University (Oxford, Ohio) where he teaches courses in marketing. In addition, he is the principal of Oxford Analytics consultancy. Paul also serves as a board member of Market Research Institute International (MRII). Previously, […]
CPG Syndicated Data Markets: Part 2 – The Nitty-Gritty
Markets are one of the four dimensions that are fundamental to CPG data. I’ve written a two-part series to cover all aspects of the topic. Who should read this post (Part 2)? Anyone interested in the details about how Nielsen/IRI/SPINS cover the following brick & mortar channels: Grocery/Food Mass Merchandise/Walmart Drug Dollar Club Military […]
Product Attributes: The Key to Meaningful Analysis
A product’s attributes are what makes it distinct from other products. Attributes include things like size, color, flavor, package type and other features that are relevant to the category. From a consumer perspective, these attributes are what determine the consideration set and influence the ultimate purchase decision. From a retail perspective, product attributes help define […]




