We’ve written before about why Sales per Store per Week ($PSPW or UPSPW) can be a flawed velocity measure. Our primer on this topic explains the problem. For example, a Walmart store and a 7-Eleven store each count as one store, so per-store velocity is biased toward items sitting in big box retail, since larger-format […]
Know Your Measures: Distribution
Tip Sheet Mailbag: Velocity Q&A – The Sequel
We hope you aren’t tired of reading about velocity! Velocity and distribution (which go hand in hand, as you’ll see below) are the topics we are asked about most often. We’ve reviewed our reader correspondence and pulled out a few more key points we wanted to share: Question 1: Is Velocity Independent of Distribution? Q. […]
Who’s NOT Selling My Products? or How to Identify Distribution Voids
Let’s start with stating the obvious: Shoppers cannot buy your products if they are not available where they shop. Even though your brand may have 12 different items in its product line, not every retailer carries every item. You can identify which retailers sell which items using a relatively straightforward data pull from IRI or […]
Estimating Brand Distribution If You Only Have Item Level Data
Here’s a recent question we received from a CPG Data Insights reader: “I know that ACV is not additive, but is there a way to calculate total ACV for a Brand when you have 5 UPCs with ACV measure? Can you average the ACV of the 5 UPCs for total Brand ACV?” Before I answer […]
What’s With All These Similar Distribution Measures?? (Max, Reach, Average Weekly, etc.)
We’ve had several questions over the last few months regarding some facts that people are starting to notice are available in their Nielsen, IRI and/or SPINS databases. The names are very similar, but it’s not obvious how the measures are different or when you’d want to use one or the other. (With apologies to Homer […]
Enhancing Your Analysis with TDP, Part 2: Explaining Sales Trends
In a recent post, I illustrated the most common usage of Total Points of Distribution (TDP) – as a substitute for % ACV in velocity calculations. In this post, I’ll share another one of my favorite ways to leverage the TDP data metric, which is explaining sales trends. If you aren’t familiar with TDP, read […]




