Analysis

POS data vs panel data: Key differences

Analysis

POS data vs panel data: Key differences


The number one challenge we hear from small businesses is not that the CPG industry lacks data—it’s that there is too much data available. From POS data to panel data to digital analytics, it can be overwhelming for a small CPG company.

If you’re a CPG manufacturer trying to tackle the foundations of retail data, it’s hard to know where to begin. Learning the CPG retail data landscape can feel like studying for a doctoral degree, but it doesn’t have to be so complicated.

A good place to start is understanding the types of data your brand should be measuring. What can POS (point-of-sale) data tell you? And what can panel (household) data tell you?

Keep reading to learn more about POS data and panel data, what they’re used for, and where to get them.


What Is POS data?

POS data, or point-of-sale data, is transaction-level data collected at a retail store. You may recognize the word “POS” as the electronic system we often call a register. As the customer gets checked out, the data from each item scanned is logged into the POS system and fed through several categories. This includes automatically adjusting inventory levels, sales figures, product rankings, and more. This is the most well-known form of retail data analytics.


What is panel data?

Panel data, or household data, is self-reported purchasing data collected by third-party companies like NielsenIQ. This data offers a much wider look at sales trends and lets brands get info from the consumers themselves.


POS data vs panel data collection

As CPG industry professionals, we know that we need both POS (point-of-sale) data and panel (household, or consumer-level) data in order to make the best decisions for our business.

POS data is what’s collected at the time of sale. Every bar code the cashier scans can tell us something. This includes the price, quantity sold, time of sale, whether a product was purchased on promotion, what retailer the product was purchased at, etc.

Panel data, on the other hand, comes from NielsenIQ’s panel of households. They provide their purchasing data by scanning the barcodes on products they purchase and indicate where they bought them. This allows NielsenIQ to track consumer behavior for more than 250,000 households in 25 countries. It also grants CPG data professionals insights like customer loyalty, consumer demographics, and the purchase cycle of a given product.

There are so many metrics available to us from looking at POS and panel data. So, how do we know what to focus on to derive the most value in an industry in which we need quick, simple answers now?

A streamlined look at the value and purpose of POS and panel data can point us in the right direction. Understanding where POS and panel data comes from and how to use it will pay dividends.


What Questions can POS data vs panel data answer?

Sales can be “decomposed” based on POS or panel metrics. A POS decomposition will focus on the tactical levers of “The 4 P’s” (Price, Promotion, Product, and Place). But, a panel decomposition will focus on who buys your product and how they shop.


POS Data

Also referred to as retail measurement data, can provide a wealth of insights. The easiest way to begin is by having a look at a Byzzer report called Promo versus Non-Promo Decomposition Tree.

Whether your sales are up or down, looking at the “decomposition” of your data (i.e., those factors that could drive changes in your total retail sales), will help identify possible sources of a change in sales.


Non-promo sales versus promo sales

Non-promo sales refer to products sold at your everyday price. Promotion sales refer to merchandising and includes product sold that was on a display, in a feature, or offered at a discount. By tracking this data you can create a more effective CPG pricing strategy.


Non-promo sales

One helpful way to examine the sales of your product at everyday prices is to take a closer look at distribution and velocity of sales. These two are directly related to each other—for folks interested in the math, your sales equal your distribution multiplied by your velocity. They work hand-in-hand because distribution is how widely available your product is, versus velocity, which is how quickly your product sells where it’s available. Using this visual, you can see if your product has lost or gained shelf space, or if sales are slowing or gaining steam.

On their own, these measures can give you a top-line overview of how your product is selling. To dig deeper for a diagnosis, you’ll want to look underneath the hood of your velocity and distribution. Remember, velocity equals sales divided by distribution, so if your velocity has dropped, could it be a problem of distribution? If so, distribution where? In a single city or state? In a region? In a retailer? You’ll want to take a closer look using a Byzzer report like Market Opportunity.


Promo sales by type

Display: Ever been enticed by a product because it was displayed at the end of an aisle or in its own special little section at the grocery store? These kinds of secondary displays are one way to drive promo sales.

Feature: A feature could comprise your product being included in the retailer’s weekly flyer or circular, often featured in a retailer’s email campaigns.

Discount: A temporary price reduction (often referred to as TPR, as in the chart above) can help drive promo sales, too.

Note that any single or combination of these three efforts constitutes a promotion. So, a product could be on the same shelf as usual at a discount, or it could be on a display—and priced the same, at discount, or even higher than usual. That’s why it’s vital to understand the objectives of your trade promotions and know how to measure trade promotion effectiveness.


Incremental vs non-incremental sales

Congratulations—you implemented a promotion and your sales went up! It’s because you did such a great job on your promotional activity, right? Not necessarily. Incremental versus non-incremental sales will tell you how much product you sold due to the promotion itself (incremental) versus how much product would have sold anyway had you done no promotion at all (non-incremental).

To dissect your promotional performance, trend your promotional performance with the Byzzer report Promotional Incremental Sales Trend or check out your subsidized volume by market with the Byzzer report Promotion Efficiency Comparison.


What about panel (household) data?

Comparing penetration to spend per household is a little bit like comparing distribution to velocity in your POS data. Sales trends can be due to either a change in how many households are buying the product (penetration) or current buyers spending less or more ($ per household). Declining penetration indicates that you are losing your share of households. Dollar per household changes could indicate a change in category usage and may be driven by shoppers buying the product on fewer trips (frequency) or spending less per trip ($ per trip). That means, for example, that panel data can give us insights like: “The average household spent $100 on dog treats in 2020 across 5 trips with an average spend of $20 per trip.”

Using the decomposition above, we could identify problems and formulate potential solutions with the right marketing strategy. For example:

  • If penetration has decreased, a CPG manufacturer could try new customer acquisition tactics, such as influencer marketing or programmatic ads.
  • If the frequency of trips has dropped, a manufacturer could deploy discounts instead of Buy-1-Get-1 deals.
  • If dollars spent per trip have dropped, a manufacturer could implement “must-buy” deals such as 2 for $4.

A closer look at Byzzer’s reports can inspire which potential action to take – and you’ll be able to justify any new marketing initiatives by showing the size of an opportunity. Start with Shopper Sales Decomposition Tree to see what you can glean from top-line panel data intel and move on to a report such as Shopper New, Lost and Retained or the Leakage Tree to pinpoint where you should take action.


Data makes all the difference

36% of smaller companies said their traditional competitors have already gained a material edge by integrating data and analytics into their core business. By utilizing both POS and panel data, you can take advantage of shifts in the market to gain shelf space and market share.

Byzzer by NielsenIQ has all the tools necessary to help you in your growth journey. With our comprehensive reports, you can have all the right data at your fingertips, including breakdowns and insights to help you understand what it all means. We can even help with education around CPG data and analytics.

Sign up for a free account with Byzzer today!