Transforming your syndicated data into business insight
Recently, we received a question from a reader who was puzzled because he was seeing negative numbers for subsidized volume. If you’ve also wondered about this, take a look at his question and our answer. If you don’t know what we’re talking about, you might be interested in this post all about Subsidized Volume. […]
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 […]
If you define your product category well, you lay the foundation for successful analysis. If you don’t, your analysis can be misleading or useless. Hmm, which is worse? Misleading or useless? What is the “right” way to define a category? Seems like a simple question but, for some products, there’s not a simple answer. Here are […]
Did you check out my post about automating reports in Excel? I showed the right way to set up reports (so you won’t have to reformat when you get new data). Now I want to share more about two handy Excel functions: RIGHT and PROPER. I used these for the retailer name, date and […]
Nielsen and IRI applications make it easy to create spreadsheet based reports that can be refreshed every month. But in their older systems like Nielsen Nitro and IRI XLerate, there is minimal formatting. Their newer web-based systems like Nielsen Answers and IRI Liquid Data apply more formatting but that formatting doesn’t necessarily look […]
Want to know how the heck % ACV Distribution is actually calculated? Read Part 1 here. % ACV Distribution is a really basic measure but it can be tricky to use in analysis. Here are the 5 most important things to remember about % ACV Distribution: It gets triggered by a SCAN, not by […]
