- WHERE filters
- JOIN functions
- first-party insights
- third-party insights
or
- first-party insights
- aggregation functions such as SUM or AVG
- WHERE filters with literal (static) values
- UNION or JOIN functions
Category: Amazon Marketing Cloud Exam Answers
The __________ field functions as a grouping indicator for the impression and any associated clicks, view events, or conversion events.
- conversions
- purchases
- request_tag
- engagement_scope
The correct answer is:
- request_tag.
The _________________ panel within AMC is a repository of Amazon-authored SQL templates and includes associated use cases, instructions, and a guide to interpret the results.
- Instructional queries
- Paid features
- Query editor
- Schema explorer
The correct answer is:
- Instructional queries.
The _________ field contains the pseudonymous ad identifier associated with a given impression. It is often used in calculations to understand unique reach volumes.
- purchases
- halo_code
- request_tag
The correct answer is:
- halo_code
How would you adapt this query to limit results to Sponsored Products keyword targeting only? SELECT ad_product_type, targeting, customer_search_term, match_type, SUM(spend)/100000000 AS total_cost_dollars,((SUM(spend)/100000000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions, SUM(clicks) AS clicks, (SUM(clicks)/SUM(impressions)) AS ctr FROM sponsored_ads_traffic WHERE match_type IN(‘PHRASE’, ‘BROAD’, ‘EXACT’) GROUP BY 1,2,3,4
- Adjust FROM statement to: FROM sponsored_products
- Adjust WHERE statement to: WHERE match_type IN(‘PHRASE’, ‘BROAD’, ‘EXACT’) AND ad_product_type = ‘sponsored_products’
- Add LIMIT clause: LIMIT sponsored_products
- Adjust SELECT statement to include the sponsored_products field
The correct answer is:
- Adjust WHERE statement to: WHERE match_type IN(‘PHRASE’, ‘BROAD’, ‘EXACT’) AND ad_product_type = ‘sponsored_products’
user_id values cannot be viewed in the AMC user interface or downloaded from AMC.
- True
- False
The correct answer is:
- True.
Why are developer resources required for creating first-party tables in AMC?
- Because first-party table creation is an API-only feature
- Because you must build a custom architecture for automating table creation
- Developer resources are not required for creating first-party tables in AMC
The correct answer is:
- Because first-party table creation is an API-only feature.
