Questions

Which field can be used to filter to traffic events from the relevant sponsored ads campaigns?

 

• campaign
• supply_source
• user_id

 

Considering the amazon_attributed_events_ tables contain ad-attributed conversions across all of your Amazon Ads media, which of the following fields would allow you to aggregate them by sponsored ads vs. Amazon DSP?

 

• ad_product_type
• supply_source
• traffic_event_type

 

You can activate AMC rule-based audiences on _____________.

 

• Amazon DSP
• Amazon Ad Server
• Seller Central

 

Which statement about rule-based audiences is incorrect?

 

• Audiences cannot exceed 2000 records
• Audiences cannot be modified once created
• Audiences are created via SQL logic

 

Which field in the amazon_attributed_events_ tables should you leverage if you want to understand more about which product or pixel your conversion events are associated with?

 

• tracked_item
• tracked_asin
• ad_product_type

 

Iris, a consumer electronics brand, would like to modify a query to only include purchase records from the underlying table. Which of the following represents how the query should be written?

 

• SELECT campaign, COUNT(DISTINCT user_id) AS purchasers, SUM(purchases) AS purchases FROM amazon_attributed_events_by_traffic_time WHERE purchases = 1 GROUP BY 1
• SELECT campaign, COUNT(DISTINCT user_id) AS purchasers, SUM(purchases) AS purchases FROM amazon_attributed_events_by_traffic_time GROUP BY 1
• SELECT campaign, COUNT(DISTINCT user_id) AS purchasers, SUM(purchases) AS purchases FROM conversions GROUP BY 1