- campaign
- sponsored_ads_traffic
- user_id
- supply_source
The correct answer is:
- campaign
Category: Amazon Marketing Cloud Exam Answers
Iris, a consumer electronics brand, recently started using AMC to perform analytics on events related to their Amazon Ads campaigns. Why should Iris consider using the instructional query library?
- To find a searchable list of AMC tables and fields available to query, including Amazon Ads events and tables uploaded by Iris
- To ensure minimum aggregation thresholds are met on all queries
- Iris should not consider using the instructional query library as it does not apply to advertiser uploaded inputs
- To save time and reduce errors when compared to writing custom SQL queries from scratch
The correct answer is:
- To save time and reduce errors when compared to writing custom SQL queries from scratch
For sponsored ads Cost-per-Click (CPC) campaigns, only click events are eligible for attribution of conversion events.
- False
- True
The correct answer is:
- True.
You can use a _________ filter to limit your query results based on one or more conditions.
- FROM
- WHERE
- SELECT
The correct answer is:
- WHERE.
How would you adapt this query to obtain cost and impression metrics by supply_source? SELECT device_type, operating_system, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
- SELECT supply_source, SUM(total_cost)/100000000 AS total_cost_dollars, ((SUM(total_cost)/100000000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_inventory GROUP BY 1
- SELECT supply_source, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
- SELECT supply_source, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1
The correct answer is:
- SELECT supply_source, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table?
- The impressions column should not be leveraged to calculate total impressions served in the query timeframe
- The time window used for your query will apply to the time of the conversion event
- Conversions included within this table have occurred within 14 days of a traffic event
- The conversions field will always contain a value of either 1 or 0
The correct answer is:
- The conversions field will always contain a value of either 1 or 0.
Since the amazon_attributed_events_* tables contain ad-attributed conversions across all of your Amazon Ads media, you can aggregate them by sponsored ads vs. Amazon DSP using the __________.
- conversion_event_category field
- supply_source field
- ad_product_type field
- traffic_event_type field
The correct answer is:
- conversion_event_category field.
Within the amazon_attributed_events_* tables, Amazon Ads will only attribute conversion events to click events for sponsored ads CPC (cost-per-click) campaigns.
- False
- True
The correct answer is:
- True.
The _____________ field in the conversions_with_relevance table categorizes the relationship between the conversion event and the campaign it is relevant to.
- engagement_scope
- request_tag
- conversions
- purchases
The correct answer is:
- engagement_scope.
The ___________ function can be used to append a string to ID fields (such as campaign_id), preventing issues reading the accurate ID values within Excel.
- CONCAT
- COLLECT
- SUM
The correct answer is:
- CONCAT.
