CPG Fundamentals: What Is Syndicated Retail Sales Data?

Syndicated Data VendorsCPG Data Tip Sheet focuses on education and best practices for analyzing syndicated retail sales data from IRI and Nielsen (and SPINS for those of you in the Natural/Organic sector). But syndicated data is not the only type of CPG data you’ll encounter. In fact, it’s not even the only type of retail sales data! This post takes a step back to describe where syndicated data fits in to the bigger CPG data picture. Understanding this will help you:

  • Determine which data source you should use to answer different questions
  • Understand the strengths and weaknesses of each data source (and how that might impact your analysis) and
  • Decide whether syndicated data is something you need in your data arsenal (and budget)

The Benefits of Retail Sales Data

Syndicated data is one type of retail sales data. I’ll talk below about the differences between syndicated and retailer direct data, which is another major type. But first, let’s cover some of the special qualities of all retail sales data.

Not everyone needs retail data to measure sales. CPG manufacturers already know exactly what they shipped to each retailer and when. So why are CPG manufacturers the primary buyers of retail sales data? Because shipments are distant from consumer behavior—a lot can happen in the time between when a product is shipped from a plant and bought at a store. Shipments don’t tell you what price a shopper paid, when they bought or what type of in-store conditions influenced the sale. For that, you need retail sales level information, which is also called “consumption data.” Other terms for it are takeaway, off-take, downstream  and POS data.

Retail sales data also provides insights not available through market research methods such as consumer surveys. CPG manufacturers can gather valuable data through survey research. They segment buyers into different groups based on attitude, ask buyers about their product feature preferences, test their responses to different package graphics, and much more. But retail sales data is different from all these sources of consumer insight because it reflects actual behavior. It measures not what people think or feel, but rather what they purchased at a particular moment in a particular store under a particular set of market and competitive conditions.

The Retail Sales Data Landscape

It helps to know that all retail sales data can be divided into four buckets, based on a combination of two parameters.

  1. Data Source: Did it come directly from the retailer (like Walmart or Meijer) and therefore reflects only sales for that retailer? Or did it come through a syndicated vendor (like IRI or Nielsen) which pools data from many retailers to create a picture of the total market?
  2. Data Focus: Is the data focused on store level sales, combining the transactions of all individual shoppers? Or is the data giving you insights on individual behavior at the shopper or household level?

The graphic below illustrates how these parameters combine to create four types of retail sales data.
Four Types of Retail Sales Data
Here are the key differences between each of the four types of retail sales data:

Syndicated Store Data

  • Best applications: general learning on sales trends, competitive analysis, distribution, price, and trade promotion.
  • Available from Nielsen, IRI, and SPINS for most major retailers in the Food, Drug, Dollar, Mass, Convenience, Club and Military channels.
  • Data available on hundreds of markets across hundreds of categories for all UPC’s in the category. Consistency allows easy comparison across products, retailers, and markets.

Retailer Direct Store Data

  • Best applications: retailer collaboration, category and supply chain management. It’s the retailers’ actual data, organized the way they want to see it.
  • Available from many retailers, large and small.
  • Data availability and format varies.
  • Data will never include competitive retailers and often won’t cover full category, only your own products

Syndicated Panel Data

  • Best applications: understanding buyer behaviors such as store and brand loyalty, share of wallet, cross-purchasing, channel-shifting, demographics and purchase frequency
  • Available from Nielsen, IRI, and SPINS for demographically balanced sample of 120,000 households who scan UPC coded purchases in-home.
  • Provides a complete picture of household buying behavior across all retailers, even those who don’t provide store data to the vendors. However, sample size can be an issue for some products with low penetration.

Retailer Direct Panel Data

  • Best applications: understanding buyer behaviors such as basket size, trips, purchase frequency, and cross-purchasing at a particular retailer
  • Available only from large retailers.
  • Sample sizes will not be an issue for most products but behavioral picture is incomplete and questions like loyalty and share of wallet cannot be addressed since there is no information about what shoppers are doing outside of that retailer.

Did this post give you a better picture of what syndicated data is and where it fits into the CPG data landscape? Leave a comment below or contact me by email to let me know what you think. Stay tuned for future posts where I will talk about each of these four types of retail sales data in more detail.

Did you find this article useful? Subscribe to CPG Data Tip Sheet to get future posts delivered to your email in-box. We publish articles once or twice a month. We will not share your email address with anyone.

PrintFriendly and PDF

Discount: The Often-Overlooked Pricing Measure

discount pic

In this post I’ll explain why discount is an important element of your pricing-trade strategy and the correct way to calculate it. (You may want to review these previous posts before continuing: retail pricing in general, base price and trade … [Continue reading]

How to Build an Argument for Increased Retail Distribution

Case Study 5 Dollars per Million Comparison

Over the last year, we’ve written lots of articles showing you how to use key IRI/Nielsen measures. In this post, I’ll pull together several of those lessons in a step-by-step mini case study. The goal of this analysis is a common one: convince a … [Continue reading]

Promoted Price: It Pays to Look Deeper

sale logos

Trade spending is a huge/the biggest item in the budget for [almost] all consumer packaged goods brands.  As explained in this previous post, all those trade dollars go towards reducing your retail price and, sometimes, gaining feature and/or display … [Continue reading]

Velocity: How Well Your Product REALLY Sells

Velocity Symbol

Velocity questions have dominated the CPG Data Tip Sheet inbox this month, with a number of readers posting comments or writing with questions about this important measure. So we decided it’s time to turn our attention to what is, after all, the … [Continue reading]