What’s Your Data Focus? Retail Store Data or Shopper Panel Data?

Store vs. Shopper DataFor my last couple of posts, I’ve been talking about the four types of retail sales data, formed by a combination of two parameters: data source (syndicated vs. retailer direct) and data focus (store vs. shopper).  In this post, I’ll discuss data focus in detail, laying out the strengths and weaknesses of each data type for answering your business questions.

Retail sales data can focus on either stores (where all the transactions for a specific UPC are grouped together) or shoppers (where individual transactions by individual consumers are analyzed).

IMO, the difference between store and shopper is even bigger than the difference between syndicated and retailer direct because the size and structure of the underlying data and the questions it answers are so very distinct.

In the syndicated world of Nielsen, IRI, and SPINS, the shopper data is called household panel data. In the retailer direct world, it would typically be loyalty card or frequent shopper program data.

Store Data

Store data is the most easily accessed and commonly used data. It’s collected through POS (point-of-sale) in-store systems. You’ll also hear this type of data referred to as “scanner data”.

Retailer direct data store may provide information on individual stores (though that’s rarely useful for market research, as opposed to supply chain or logistics, purposes). Syndicated store data will rarely be available for individual stores. Instead, syndicated data groups stores into various types of markets (geographic markets, channel totals, individual retailers).  Comparing market sizes is one of the strengths of syndicated data.

Store data is great for understanding sales trends and analyzing distribution, price and trade promotion. Once you have the data, you can analyze any time period, from one week to multiple years. The data is incredibly robust—you never have to worry about things like sample size!  It’s also generally less expensive to purchase and easier to manage and analyze.

There are many articles in this blog about syndicated store data and many of those concepts will apply to working with retailer direct store data. Distribution, price, and trade promotion are the three business areas most commonly and most effectively addressed with store data.  Here is one article for each topic to get you started:

Shopper Data

The defining characteristic of this type of data is that it links purchases to a specific individual or household over some period of time. Syndicated panel data is at the household level. Retailer direct data varies but can sometimes focus on individual shoppers rather than grouping them into multi-shopper households.

Shopper data analysis focuses on issues like loyalty, purchasing patterns over time, share of wallet, cross purchasing, and buyer demographics. Usually shopper data analysis focuses on longer periods of time to capture those nuances and changes in consumer behavior.

Syndicated household panel data from Nielsen, IRI, and SPINS relies on a relatively small but very representative set of consumers.  Sample sizes can be an issue depending on your products and questions.  But the completeness of the buying behavior picture is unparalleled.  In fact, since syndicated panel data covers all purchases for a specific group of households, you may be able to get information about retailers that don’t provide store data (like Whole Foods) or, occasionally, channels not covered by store data (like Office Supply).

Retailer direct loyalty card or FSP data, when available, is voluminous. It can include every transaction for every shopper at that chain. So a picture of buying behavior, at that retailer, can be obtained for even small and infrequently purchased products. However, certain types of questions cannot be addressed since it’s only a piece of the shopper’s behavior. For example, you cannot look at share of wallet since you don’t know what the shopper spent in other retailers and other channels.

To learn more about shopper data metrics, take a look at these past blog articles:

Household panel and shopper data is incredibly powerful but can be tricky to analyze. Need help with your household panel data?  We’re experts!  Contact us to discuss how we can help you gain more consumer insights from your syndicated data.

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 won’t share your email address with anyone.

PrintFriendly and PDF

What’s New, Part II: What to Know About New Items

new items table

This is the second in a series of posts that show how you can use your IRI or Nielsen POS database to conduct an annual analysis of all the new products introduced in your category.  In this previous post I showed a way to identify the new items in a … [Continue reading]

What’s New, Part I: How to Identify New Items in Your Category

new icons

Manufacturers are constantly introducing new products. Although you know which new products your own company is introducing and when, it is also important for you to keep informed about your competitors’ activity. Depending on the resources at your … [Continue reading]

The Top Posts From Our First Two Years

Second Birthday

Robin and I have thoroughly enjoyed our first two years as bloggers! Thanks so much to the many readers who have entrusted us with their questions and added their own expertise to the conversation. We now have nearly 1500 email subscribers and over … [Continue reading]

What’s the Best Data Source? Retailer Direct or Syndicated Nielsen/IRI Data?

Retailer vs. Syndicated Data

A few weeks ago, I wrote about the benefits of retail sales data for CPG manufacturers.  And I summarized the four types of retail sales data which are formed by a combination of two parameters: data source (syndicated vs. retailer direct) and data … [Continue reading]