Transforming your syndicated data into business insight
Velocity questions have dominated the CPG Data Tip Sheet inbox this month, with a number of readers posting comments or writing with questions about this important measure. So we decided it’s time to turn our attention to what is, after all, the third most important measure in your database. Why is velocity the #3 measure? […]
One of the key steps in an IRI/Nielsen pricing analysis is drilling down to look at regular price vs. sale price. Syndicated databases are chock full of price measures and, even for regular price, you still have a choice to make. There are two proxies for regular price: Non-Promoted Price and Base Price. In this post, […]
For many years, I used Excel and never knew about VLOOKUP. Oh, the hours I wasted! I’m writing this post to save you from the same sad, productivity-sapping fate. What is VLOOKUP? It’s a simple Excel function that allows you to pull information from one data set to another, based on some matching value. While […]
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 […]
If you are a CPG company with significant trade promotion spending, you probably already buy IRI/Nielsen data or are seriously considering it. Both IRI and Nielsen measure Incremental Volume: how much extra volume you sold due to trade merchandising. If you’re not sure what incremental volume is, read this first. If you’ve already got the […]
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 […]
