CPCM Syndicated Scanner data
UPDATED Study Guide QUESTIONS
AND CORRECT ANSWERS
•Which of the following is not one of the typical types of custom aggregates that
can be provided by syndicated data providers such as Nielsen and IRI? -
CORRECT ANSWERS Measures
•Scenario 1: Six retailers participated in a special sweepstakes promotion
Scenario 2: Our retailer promotes all of the 12oz flavors together at the same
time Scenario 3: Summer grilling season starts on Memorial Day and runs until
Labor Day For each scenario listed above, sequence the custom aggregates
below in correct order to match. - CORRECT ANSWERS Market,
product, period
•Your team has asked you to create a recurring monthly product dollar sales
ranking list for your retailer compared to the remaining market. When you
update the report each month, which dimensions might be most impacted by
new introductions? (Select all that apply) - CORRECT ANSWERS
Product, market
•Knowing what the key differences are between VLOOKUP and INDEX
MATCH functions, please sequence the two characteristics below to the correct
function listed above. - CORRECT ANSWERS Static column reference,
dynamic column reference
•Which of the following techniques would be least effective when trying to
analyze large volumes of syndicated scanner data in Microsoft Excel? -
CORRECT ANSWERS Multiple workbooks
•If you wanted to match up product level data by integrating syndicated scanner
data with your retailer's planogram data, which product attribute below would
UPDATED Study Guide QUESTIONS
AND CORRECT ANSWERS
•Which of the following is not one of the typical types of custom aggregates that
can be provided by syndicated data providers such as Nielsen and IRI? -
CORRECT ANSWERS Measures
•Scenario 1: Six retailers participated in a special sweepstakes promotion
Scenario 2: Our retailer promotes all of the 12oz flavors together at the same
time Scenario 3: Summer grilling season starts on Memorial Day and runs until
Labor Day For each scenario listed above, sequence the custom aggregates
below in correct order to match. - CORRECT ANSWERS Market,
product, period
•Your team has asked you to create a recurring monthly product dollar sales
ranking list for your retailer compared to the remaining market. When you
update the report each month, which dimensions might be most impacted by
new introductions? (Select all that apply) - CORRECT ANSWERS
Product, market
•Knowing what the key differences are between VLOOKUP and INDEX
MATCH functions, please sequence the two characteristics below to the correct
function listed above. - CORRECT ANSWERS Static column reference,
dynamic column reference
•Which of the following techniques would be least effective when trying to
analyze large volumes of syndicated scanner data in Microsoft Excel? -
CORRECT ANSWERS Multiple workbooks
•If you wanted to match up product level data by integrating syndicated scanner
data with your retailer's planogram data, which product attribute below would
