What is this for?
For shelf studies involving P&G we typically modify the tables provided by tabulations and normalize the spend/person metric to make it clearer/easier to understand in our reports so that it is easy to see the products/nets which are significantly different from one shelf to the other. This process involves averaging the base sizes for each column grouping or selecting a common base size and then multiplying the cell values by the appropriate average base size, while retaining the sigTest scores and cell formatting. After spend has been normalized, we index each test shelf back to control (test shelf $/control shelf$ X 100) – scores of 110+ are highlighted green, below 90 are pink. These indices represent directional changes across shelves and can help build out a story when there are very few statistically significant differences. Manually, this is painful, time-consuming and prone to error.
How do I use it?
Use the provided template as a guide when generating your file to upload. Your control to index against should be in the first “A” column. Simply upload the file and it will run the calculations for you, apply the formatting (green for cells that index over 109% and red for cells that index under 91%) and stream the file back to you.
Who do I ask if I have questions/issues?
Rhian, Val, Gill, Kat, Toby