• 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
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

Promoted Sales

Presence vs. Impact: Why Non-Promoted Sales ≠ Base Sales

September 30, 2013 By Sally Martin 14 Comments

Print Friendly, PDF & Email

In my last post, I laid out how Nielsen/IRI define each promotion condition they measure. Today I’ll tackle the difference between promotion presence measures and promotion impact measures.  Understanding this distinction will help you sort through the long list of promotion facts and avoid common errors. In brief, presence measures tell you how much and […]

Filed Under: Know Your Measures: Pricing and Promotion Tagged With: trade promotion

Trade Promotion Evaluation

The Beginner’s Guide to Trade Merchandising Measurement

September 16, 2013 By Sally Martin 31 Comments

Print Friendly, PDF & Email

Trade promotion evaluation is one of the primary reasons CPG companies buy IRI and Nielsen data. At 10-20% of gross sales, trade funds are a big investment for most manufacturers. And even companies that don’t have direct-to-consumer marketing will still often have retailer driven in-store merchandising. IRI and Nielsen databases can include literally hundreds of […]

Filed Under: How To Get Started with Nielsen/IRI, How To Understand Your Database Tagged With: trade promotion

Total Distribution Points: Master of All Distribution Measures

September 2, 2013 By Robin Simon 74 Comments

Print Friendly, PDF & Email

We have already discussed 2 key measures relating to distribution:  % ACV Distribution and Average Items Carried.  For product aggregations above the item level, % ACV Distribution provides a measure of distribution breadth and Average Items Carries covers depth. But what if you want to have one measure that summarizes distribution, taking into account both […]

Filed Under: Know Your Measures: Distribution Tagged With: distribution, TDP, Total Distribution Points, TPD

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 13
  • Page 14
  • Page 15
  • Page 16
  • Page 17
  • 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

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