Amazon Marketing Cloud Certification
Nutrition Co., a health snack company, would like to know the total impressions that have been delivered per campaign, per supply_source, per device_type. Which of the following represents how to write this query?
Select all correct answers
It selects the three dimensions ( campaign , supply_source , and device_type ) that you want to see individually.
It uses the aggregation function SUM(impressions) to calculate the total number of impressions for each unique combination of the three dimensions.
AS impressions gives the aggregated result column a clear name.
Correct Answers
It selects the three dimensions ( campaign , supply_source , and device_type ) that you want to see individually.
It uses the aggregation function SUM(impressions) to calculate the total number of impressions for each unique combination of the three dimensions.
AS impressions gives the aggregated result column a clear name.