• 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
  • Contact Us
  • Subscribe

6 Common Questions About Average Items Carried

August 5, 2013 By Robin Simon Leave a Comment

Print Friendly, PDF & Email

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

Print Friendly, PDF & Email

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

Print Friendly, PDF & Email

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

How To Estimate Retailer ACV Using Nielsen or IRI Data

July 8, 2013 By Sally Martin 6 Comments

Print Friendly, PDF & Email

Sometimes you want to know total ACV for a retailer (in other words, not just how much they’re selling in your category, but how much they’re selling in the entire store). You need this number to assess trading area trends or to find out whether the retailer is getting their fair share of sales for […]

Filed Under: How To Understand Your Database, Know Your Measures: Sales Tagged With: ACV

Fair Share Gap Analysis: How Much Is That Opportunity Worth?

June 24, 2013 By Sally Martin 12 Comments

Print Friendly, PDF & Email

In a recent post, I wrote about the importance of including competitive benchmarks in retailer category assessments. In this post, I’ll build on this concept by showing you how to construct an Opportunity Gap Analysis. This analysis examines whether the retailer is getting its fair share of category sales, compared to competitors. And, more importantly, […]

Filed Under: How To Answer Business Questions Tagged With: category management, retailer markets, trading areas

How Do I Calculate Equivalized (EQ) Sales?

June 10, 2013 By Robin Simon 7 Comments

Print Friendly, PDF & Email

One of our readers in the UK asked the following question after my recent posting on the different sales measures: “How can I calculate equivalized sales?  If there is a formula for that, can you please send it to me?” If you have a custom database, then you probably already have EQ sales as a measure, so you don’t […]

Filed Under: Know Your Measures: Sales Tagged With: EQ, equivalized sales, equivalized units

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 14
  • Page 15
  • Page 16
  • Page 17
  • Page 18
  • Interim pages omitted …
  • Page 32
  • Go to Next Page »

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

About CPG Data Tip Sheet

The CPG Data Tip Sheet is published by Kevin Lehmann and Goods Group. It was founded in 2012 by Sally Martin and Robin Simon, two consultants who met in business school over a shared interest in the geeky side of marketing and went on to build independent practices of their own. Over more than a decade they turned hard-won experience into plain-English explanations of how CPG data actually works and how to analyze it.

Robin and Sally built this into something the CPG and consumer industry trusts. It continues in that spirit.

Categories

  • Glossary (80)
  • How To Answer Business Questions (43)
  • How To Communicate Insights (19)
  • How To Get Started with Nielsen/IRI (22)
  • How To Understand Your Database (13)
  • Know Your Measures: Distribution (25)
  • Know Your Measures: Pricing and Promotion (45)
  • Know Your Measures: Sales (21)
  • Miscellaneous (6)
  • Uncategorized (1)

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 (80)
  • How To Answer Business Questions (43)
  • How To Communicate Insights (19)
  • How To Get Started with Nielsen/IRI (22)
  • How To Understand Your Database (13)
  • Know Your Measures: Distribution (25)
  • Know Your Measures: Pricing and Promotion (45)
  • Know Your Measures: Sales (21)
  • Miscellaneous (6)
  • Uncategorized (1)

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 © 2026 CPG Data Insights · Log in