vmartinez

How do you select a column named “campaign” from a table named “media”?

 

• EXTRACT campaign FROM media
• SELECT campaign FROM media
• SELECT media.campaign

 

You are writing a query and would like to know the total impressions that have been delivered per campaign, per supply_source, and per device_type. Which of the following represents how you should write the query?

 

• SELECT campaign, supply_source, device_type, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2,3
• SELECT campaign, supply_source, SUM(impressions) AS impressions FROM device_type GROUP BY 1,2
• SELECT total_impressions SUM(impressions) AS device_type FROM campaign, supply_source GROUP BY 1,2,3

 

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

 

Explanation:

The claim that “Audiences cannot exceed 2000 records” is incorrect. According to the official documentation, rule-based audience seed lists must contain a minimum of 500 user_ids and a maximum of 500,000 user_ids. If a seed audience contains fewer than 500 or more than 500,000 user_ids, creation will fail. The allowed size far exceeds 2000 records, confirming this statement is false.

Official Reference URL: https://advertising.amazon.com/API/docs/en-us/guides/amazon-marketing-cloud/audiences/rule-based-lookalike