vmartinez

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

 

Which action can be used to determine if NULL values are a natural occurrence within your report or the result of aggregation thresholds?

 

• Using the Append aggregation threshold columns option in *the Query editor*
• Checking the aggregation thresholds for the event tables in the Schema explorer
• Running the report multiple times and look for a variance in the results

 

How long can AMC accrue and retain Amazon Ads events?

 

• 12.5 months
• 90 days
• 6 months