• 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 Answer Business Questions » Page 7

How To Answer Business Questions

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

The Case of the Mismatched Volume: Comparing Shipments and Retail Sales

April 16, 2014 By Robin Simon 11 Comments

Print Friendly, PDF & Email

A common question that arises, especially when your company is new to syndicated retail sales scanner data, is “how come IRI/Nielsen sales data is different than our own shipment data?”  This probably comes up most often in the context of forecasting, when you are trying to determine if you are going to “make the numbers” […]

Filed Under: How To Answer Business Questions, Know Your Measures: Sales Tagged With: coverage factor, matching up sales, shipments vs. consumption

CPG Data 911

CPG Data 911: What to Do in an Incremental Volume Emergency

February 1, 2014 By Sally Martin 3 Comments

Print Friendly, PDF & Email

If you’ve worked with CPG data for a while, you probably know that incremental volume estimates can fluctuate and look a little funky (especially in weeks with little or no trade promotion). I wrote a post about this phenomena a few weeks ago. As I stated then, usually these fluctuations are small relative to total volume […]

Filed Under: How To Answer Business Questions, Know Your Measures: Pricing and Promotion Tagged With: base, incremental

Opportunity Gap

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

Why You Need Competitive Benchmarks in a Category Assessment

May 13, 2013 By Sally Martin 8 Comments

Print Friendly, PDF & Email

Many CPG manufacturers invest in Nielsen and IRI data to create category assessments for individual retailers. These analyses are one component of the category management process. The most compelling and accurate category assessments compare individual retailers against their competitors. And the best benchmark for this comparison is the Nielsen or IRI “remaining market.” The remaining […]

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

The Panel Data Chart Every CPG Analyst Should Understand

April 8, 2013 By Sally Martin 12 Comments

Print Friendly, PDF & Email

Even if you never buy Nielsen/NIQ, IRI/Circana or Numerator panel data, you should still understand this common household level analysis.  Retailers who analyze their loyalty card data will often use this approach.  So you’re likely to be confronted by it at some point. Here’s how it works: You break down total sales for a brand […]

Filed Under: How To Answer Business Questions Tagged With: panel data

Elasticity

July 1, 2012 By Robin Simon 8 Comments

Print Friendly, PDF & Email

Elasticity is a key concept when determining how much a change in a business driver results in a change in volume.  For simplicity, you multiply the % change in the driver times the elasticity to get the % change in volume.  (The formula for applying elasticity can be more complex, especially for pricing, but this […]

Filed Under: Glossary, How To Answer Business Questions Tagged With: due-to, volume decomposition, volume impact

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 5
  • Page 6
  • Page 7

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