• 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

Big $ Question: Syndicated Database or Custom Database?

November 8, 2012 By Sally Martin Leave a Comment

Print Friendly, PDF & Email

Every company and every analyst wants to looks at their retail data a little differently.  And Nielsen and IRI are both happy to deliver customized views of their information (for a price).  This is the option chosen by most large CPG companies: a custom database. But to provide a cost effective option, Nielsen and IRI […]

Filed Under: How To Get Started with Nielsen/IRI Tagged With: Custom, Database, Syndicated

The 2nd Most Important Measure: % ACV Distribution

November 7, 2012 By Robin Simon 53 Comments

Print Friendly, PDF & Email

You probably consider dollars the most important measure and it IS the bottom line.  But the number one driver of dollar sales is distribution.  After all, shoppers cannot buy something that’s not in the store! Used properly, % ACV Distribution will give you the answer to crucial business questions like: Are there any retailers that […]

Filed Under: Know Your Measures: Distribution Tagged With: ACV, distribution

The 4 Key Dimensions In Every Nielsen/IRI Database

November 6, 2012 By Sally Martin 2 Comments

Print Friendly, PDF & Email

Does it seem nerdy to worry about data structure when your goal is business insight? It’s not (I promise).  Understanding the nitty gritty of your IRI or Nielsen data will ensure you buy the right information and interpret it correctly. The 4 Dimensions are the grammar of the scanner data language. They impact the price […]

Filed Under: How To Understand Your Database Tagged With: Facts, markets, Measures, periods, products

% ACV Distribution

July 1, 2012 By Steven O'Sullivan 6 Comments

Print Friendly, PDF & Email

Measures the breadth of distribution of a product.  Kind of like % of stores selling, but bigger stores get heavier weight. A point of distribution in the Total US is worth more than a point of distribution in Chicago, which is worth more than a point of distribution in Des Moines.  Keep in mind that […]

Filed Under: Glossary, Know Your Measures: Distribution

% ACV with Merchandising

July 1, 2012 By Robin Simon 13 Comments

Print Friendly, PDF & Email

Measures the breadth of merchandising support.  Can be used with any of the Merchandising Conditions (Price Reduction Only, Feature Only, Display Only, or Feature & Display).  Same measure as % ACV Promo. Reference articles: The Beginner’s Guide to Trade Merchandising Measurement, All About ACV

Filed Under: Glossary, Know Your Measures: Pricing and Promotion

% Discount

July 1, 2012 By Robin Simon 2 Comments

Print Friendly, PDF & Email

Amount that the promoted price drops below the regular price, expressed as a percentage.  Calculated as (Base Price – Promoted Price)/Base Price.  A higher number means a deeper discount.  A deeper discount for the same tactic almost always results in a higher lift.  % Discount is available by merchandising tactic on custom databases. Reference article: […]

Filed Under: Glossary, Know Your Measures: Pricing and Promotion

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 17
  • Page 18
  • Page 19
  • Page 20
  • Page 21
  • 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