Transforming your syndicated data into business insight
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 Circana applications make it easy to create spreadsheet based reports that can be refreshed every month. But in some of their systems, there is minimal formatting, or you may be using they data in a way the leads you to export information and format it outside the Nielsen/Circana application. Luckily, you can easily […]
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 […]
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 […]
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 […]
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 […]
