One of the 4 dimensions on every database is Measures (or Facts). This post is your one-stop shop for Measures in CPG Data Tip Sheet. Measures fall into a few key groups and they often appear that way on your database to make them easier to find. Keep in mind that these […]
Timing is Everything: Which Time Periods Should You Get on Your Database?
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 […]
The 2nd Most Important Measure: % ACV Distribution (Part 2)
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 […]
The 2nd Most Important Measure: % ACV Distribution
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 […]
% ACV with Merchandising
Measures the breadth of merchandising support. Can be used with any of the Merchandising Conditions (Price Reduction Only, Feature Only, Display Only, or Feature & Display). Same measure as % ACV Promo. Reference articles: The Beginner’s Guide to Trade Merchandising Measurement, All About ACV
% Discount
Amount that the promoted price drops below the regular price, expressed as a percentage. Calculated as (Base Price – Promoted Price)/Base Price. A higher number means a deeper discount. A deeper discount for the same tactic almost always results in a higher lift. % Discount is available by merchandising tactic on custom databases. Reference article: […]