• 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 » How To Understand Your Database » Page 2

How To Understand Your Database

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

3 Important Facts About Incremental Volume

December 2, 2013 By Sally Martin 8 Comments

Print Friendly, PDF & Email

Trade promotion evaluation is a big selling point for Nielsen and IRI data.  Both vendors provide a key piece of the promotion evaluation puzzle: estimates of Incremental Volume.  Incremental Volume tells you how much extra volume you sold due to trade merchandising.  Here are a few things you should know about this important but sometimes […]

Filed Under: How To Understand Your Database, Know Your Measures: Pricing and Promotion, Know Your Measures: Sales Tagged With: base, incremental, 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

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

xAOC and MULO: Multi-Channel Markets in Nielsen & IRI

April 29, 2013 By Robin Simon 38 Comments

Print Friendly, PDF & Email

Are you confused by the terms “xAOC” or “MULO?”  Do you wonder what happened to FDMx?  (Do you even know what FDMx is?)  This post will clear things up for you!   These are the terms that IRI and Nielsen use for  their multi-channel markets.  These markets are designed to provide an estimate of sales across […]

Filed Under: How To Get Started with Nielsen/IRI, How To Understand Your Database Tagged With: FDM, FDMx, markets, markets available, MULO, xAOC

Timing is Everything: Which Time Periods Should You Get on Your Database?

February 4, 2013 By Robin Simon 1 Comment

Print Friendly, PDF & Email

  Learn about the “standard” option for time periods that many companies get, plus available upgrades (for more money) and downgrades (to save money). Standard Option The standard option for time periods from IRI and Nielsen is 2 years of rolling history of weeks and quad-weeks, updated monthly.  So what do these things mean? The […]

Filed Under: How To Get Started with Nielsen/IRI, How To Understand Your Database Tagged With: Database, periods, time, time period

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

  • « Go to Previous Page
  • Page 1
  • Page 2

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