• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

CPG Data Tip Sheet

Transforming your syndicated data into business insight

  • Home
  • Glossary
  • About Robin Simon
  • About Sally Martin
  • Contact
Blog » average items

average items

Featured Article

Thank You, Readers on Our 10th Anniversary!...

Robin Simon

Miscellaneous

Featured Article

20 Golden Rules to Help You Shine As An Analyst

Sally Martin

How To Answer Business Questions

Featured Article

Visualization: A Picture Is Worth A Thousand Numbers...

Robin Simon

How To Communicate Insights

Featured Article

Syndicated Retail Sales Data 101...

Sally Martin

How To Get Started with Nielsen/IRI

6 Common Questions About Average Items Carried

August 5, 2013 By Robin Simon Leave a Comment

Learn why Average Items Carried is important in this previous post. Even though Average Items Carried is pretty straightforward, here are some questions (and answers!) that often come up when the measure is new to an organization. Can I add together Average Items Carried across periods or geographies? NO!  It is a non-additive fact , since it is […]

Filed Under: Know Your Measures: Distribution Tagged With: AIC, AIS, average items, distribution

How To Identify Distribution Opportunities When Your Brand Is Already “Everywhere”

July 22, 2013 By Robin Simon 8 Comments

As mentioned in a previous post, shoppers cannot buy something if it’s not in the store!  That’s why having good distribution is so important to your business.  What can you do to increase distribution when your brand is already in at least 90% ACV distribution? Let’s look at an example.  Say there are 3 brands […]

Filed Under: Know Your Measures: Distribution Tagged With: average items, distribution

How to Calculate Average Items Carried

July 22, 2013 By Robin Simon 28 Comments

If Average Items Carried (or Average Items Selling) is not available on your database, it is easy to calculate in Excel.  It is just the sum of % ACV Distribution of all the items divided by the % ACV Distribution of the brand. Here is an example: Say a brand is made up of 4 […]

Filed Under: Know Your Measures: Distribution Tagged With: AIC, AIS, average items, distribution

Primary Sidebar

Top Posts

  • The 2nd Most Important Measure: % ACV Distribution
  • Velocity: How Well Your Product REALLY Sells
  • Total Distribution Points: Master of All Distribution Measures
  • xAOC and MULO: Multi-Channel Markets in Nielsen & IRI
  • The Beginner’s Guide to Trade Merchandising Measurement

Search CPG Data Tip Sheet

Subscribe to New Posts

Get new posts delivered straight to your inbox. We won't share your email address with anyone.

Thank you for subscribing!

Subscribe

About CPG Data Tip Sheet

We (Sally Martin and Robin Simon) first met in business school and bonded over our interest in geeky marketing stuff. Eventually we both started independent consulting practices. Now we’ve reunited to share with you some of what we’ve learned in our decades of experience working with syndicated CPG data.

Categories

  • Glossary (79)
  • How To Answer Business Questions (42)
  • How To Communicate Insights (17)
  • How To Get Started with Nielsen/IRI (22)
  • How To Understand Your Database (12)
  • Know Your Measures: Distribution (24)
  • Know Your Measures: Pricing and Promotion (45)
  • Know Your Measures: Sales (21)
  • Miscellaneous (6)

Tags

ACV analysis examples analytic skills attributes average items base base weighted weeks career development category management channels characteristics coronavirus coverage factor covid-19 Database distribution due-to Excel tips Facts incremental markets Measures merchandising new items panel data periods pricing pricing strategy products promoted price quantify opportunity retailer direct data retailer markets shopper data store data Syndicated TDP the basics trade promotion trading areas velocity visualization visualizations volume bridge volume decomposition

Footer

Categories

  • Glossary (79)
  • How To Answer Business Questions (42)
  • How To Communicate Insights (17)
  • How To Get Started with Nielsen/IRI (22)
  • How To Understand Your Database (12)
  • Know Your Measures: Distribution (24)
  • Know Your Measures: Pricing and Promotion (45)
  • Know Your Measures: Sales (21)
  • Miscellaneous (6)

Search CPG Data Tip Sheet

Tags

ACV analysis examples analytic skills attributes average items base base weighted weeks career development category management channels characteristics coronavirus coverage factor covid-19 Database distribution due-to Excel tips Facts incremental markets Measures merchandising new items panel data periods pricing pricing strategy products promoted price quantify opportunity retailer direct data retailer markets shopper data store data Syndicated TDP the basics trade promotion trading areas velocity visualization visualizations volume bridge volume decomposition

Terms of Use | Copyright © 2025 CPG Data Insights · Log in