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 Simpson, who probably never had to use a Nielsen or IRI database!)

Since these potentially confusing facts are all related to or derived from ACV, you may want to read these previous posts that talk about ACV and other Distribution measures:

  1. All About ACV
  2. The 2 Most Important Measure %ACV Distribution, Part 1 and Part 2
  3. Total Distribution Points:  Master of All Distribution Measures

Now that you’re an expert on ACV, Average Items and Total Distribution Points (TDP), I’ll get to the point of this post!

First of all, as with lots of terminology in the world of CPG data, there are differences between the different data suppliers.  If you have access to Nielsen data, you may have seen many facts with the word “Reach” in the name.  If, however, you are an IRI client, then the equivalent term in fact names is “Max.”  Note that if you are a SPINS client and get any data for the Conventional channel then you will also see “Max” in some fact names (because IRI actually supplies the Conventional data for SPINS).  You may see the word “Avg Weekly” in front of distribution measures from all 3 suppliers.  Warning:  The terminology in this post may not be exactly correct here for all suppliers, so check your database for what’s there and ask your client service rep if you have specific questions about your database.

2 Versions of Each Measure

Let’s look at some real data for the measure “%ACV” for one brand in one retailer.  Here’s data for 4 different periods – 1-week, 4-week, 12-week and 52-week:

Brand A in Simon’s Supermarkets
Comparison of %ACV Measures
Periods ending 10/28/17

Things to notice about the numbers:

  • For a single week, the 2 measures are always the same – in this case 78.
  • For all periods longer than 1 week, the measure on the right is larger than the one on the left – for 4-weeks 82 vs. 76, for 12-weeks it’s 89 vs. 81 and for 52-weeks it’s 93 vs. 83.
  • The values of the measure on the left are all pretty similar – ranging between 78 and 83.
  • The measure on the right gets bigger the longer the period – 78 for 1-week up to 93 for 52-weeks.

Using the 52-week period as an example, the key concept here is:

So over the course of the whole year, Brand A sold, on average, in 83% of Simon’s Supermarkets in a week but sold in 93% of Simon’s Supermarkets at some point during the year.

 Here’s a very extreme example:  Say you’re looking at a 52-week period.  If the product sold in 20% of the ACV during the first week of the period, in 10% the 2nd week, 5% third week and then 0 the other 49 weeks then Max ACV for the product would be 20 but average weekly ACV would only be 0.7 (= (20+10+5)/52 wks).

Which to Use When?

This basically depends on a combination of:

  1. The purchase cycle for the product
  2. Where the product is in it’s life cycle – new, stable, declining

As we saw in the graph above, the longer the period gets, the more different the 2 measures will be.  That means if a product has a long purchase cycle then the avg weekly and Max ACV will be more different – it’s possible for an item to sit on the shelf and not sell in every single week if people don’t buy the category that often.  This is less of an issue for refrigerated products with a shorter shelf life and more of an issue for things like cleaning products that people may only buy a few times a year.

If a product is steadily gaining or losing distribution over a period, then be careful about which measure you use!  Using Max would be better for a new product that had much lower distribution at the beginning than at the the end of a period.  But looking at Max for a product that has been discontinued or delisted would be artificially high since distribution would be much lower at the end than at the start of the period.

Same Concept for Other Distribution Measures

Since many other measures are derived from ACV, they also have 2 different versions.  Here are examples for Avg # Items and TDPs:

Brand A in Simon’s Supermarkets
Periods ending 10/28/17

These same principles hold for Avg # Items and TDPs:

  • For a single week, the 2 types of measures are always the same
  • For all periods longer than 1 week, the measure on the right is larger than the one on the left
  • The values of the measure on the left are much closer together than those on the right
  • The measure on the right clearly increases the longer the period

Here’s how to describe what’s happening with Avg # Items over the last year using the data above:  On average over the last year, Simon’s Supermarkets sold between 15 and 16 items every week.  Between 19 and 20 items sold at Simon’s Supermarkets sold at some point during the last year.

I hope this helps to clear up the differences between the versions of the distribution measures.

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 about once a month. We will not share your email address with anyone.

Print Friendly, PDF & Email

Base Weighted Weeks (Part 2 of 2): What Will Happen to Sales If…

We’re delighted to once again have Mark Laceky, President of mLogic Consulting as guest blogger.  mLogic's previous post explained one of their favorite measures, Base Weighted Weeks (BWW).  This follow-up post gives a concrete example of how to use … [Continue reading]

CPG Data Tip Sheet’s Favorite Things

Tip Sheet readers frequently write us and ask for suggestions on how to find training classes, what reading we recommend, and what other resources are out there to help them on their path to CPG Data Guru status. Here are our recommendations. We … [Continue reading]

Base Weighted Weeks (Part 1 of 2): How Much Trade Promotion Support Are You Really Getting?

We’re delighted to have guest contributors Mark Laceky (President) and Mike Fridholm (SVP, Client Service) from mLogic Consulting introducing one of their favorite measures.  Keep in mind that this article is most relevant for use in more strategic … [Continue reading]

How To Get More From TDP, Part 3: Sales Productivity

Hello, fellow analysts! Ready to add another tool to your kit? This is the third and final part of my series on how to use TDP to enhance your work. If you are new here, and not yet familiar with TDP, start with this basic introduction or my first … [Continue reading]