AC

Amazon Marketing Cloud Certification Questions

Page 2 of 2 · 94 questions

  1. 51What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?
  2. 52Which event table can be used when attributing conversions to your campaign using custom logic (e.g., 28 day lookback window)?
  3. 53Which of the following statements is true about using queries within the instructional query library?
  4. 54What is an AMC sandbox?
  5. 55This UI component is considered the day-to-day operating room for the analytics practitioner and is used to author and execute SQL queries, as well as download the results.
  6. 56What can Amazon shopping insights be used for?
  7. 57The _________________ panel within AMC is a repository of Amazon-authored SQL templates and includes associated use cases, instructions, and a guide to interpret the results.
  8. 58The submitted queries table provides details of the query executed and a link to download your aggregated report as a _______ when it’s ready.
  9. 59Which of these analyses can be accomplished with an overlap query?
  10. 60What is SQL optimization in the context of AMC?
  11. 61This panel provides access to additional subscription-based insights from Amazon or third parties; these insights can be joined with your Amazon Ads events that are already available in AMC.
  12. 62New-to-brand metrics are only relevant for __________.
  13. 63AMC users have access to all AMC instances in an account by default.
  14. 64AMC can be used by brands that don’t sell their products directly in the Amazon store.
  15. 65The __________ field functions as a grouping indicator for the impression and any associated clicks, view events, or conversion events.
  16. 66Overlap analyses enable you to generate insights by comparing different groups of __________ values in isolation and when overlapped.
  17. 67How 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
  18. 68The _________ field contains the pseudonymous ad identifier associated with a given impression. It is often used in calculations to understand unique reach volumes.
  19. 69Which of these queries will only include purchase records from the underlying table?
  20. 70Which AMC tables would be required for determining the Amazon-attributed conversion volumes per frequency bucket (including Amazon DSP traffic only)?
  21. 71Which table would you leverage for a query when your objective is to understand how your current audience strategy is performing for your campaigns?
  22. 72AMC supports most common SQL functions, but there are some unsupported SQL functions.
  23. 73What is one limitation of AMC SQL?
  24. 74What are custom parameters?
  25. 75AMC audiences is an API-only feature.
  26. 76Which two functions can be used together to filter records based on presence of a string within a column’s values?
  27. 77Which of the following Amazon services can be used to visualize aggregated AMC reports in a dashboard?
  28. 78What types of Sponsored Products records will have spend metrics?
  29. 79Which value is not available for Sponsored Products?
  30. 80Which of these statements is false regarding AMC audiences?
  31. 81Paid features tables are only available in advertiser instances.
  32. 82In AMC, a conversion is defined as an Amazon.com purchase event.
  33. 83Super Power Batteries, a consumer-packaged goods brand, is new to AMC and wants to learn more about what tables are available to query. Where in the AMC UI can they find this information?
  34. 84Which of the following business questions can be answered with an overlap analysis?
  35. 85If you run multiple Amazon DSP and sponsored ads campaigns and reached similar audiences, which query can help you understand your customers’ conversion paths that have the highest conversion rate?
  36. 86Which table should you use in a query meant to help you choose new Amazon audiences that may benefit your Amazon DSP campaign performance?
  37. 87Where can you activate AMC audiences?
  38. 88This table contains impression and click events from Sponsored Products (SP), Sponsored Brands (SB), and Sponsored Display (SD) campaigns.
  39. 89Iris, 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?
  40. 90Iris, 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?
  41. 91Which field can be used to filter to traffic events from the relevant sponsored ads campaigns?
  42. 92Within the amazon_attributed_events_* tables, Amazon Ads will only attribute conversion events to click events for sponsored ads CPC (cost-per-click) campaigns.
  43. 93Why are developer resources required for creating first-party tables in AMC?
  44. 94SELECT 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 Explanation: That’s the correct query. Here is an explanation of the adaptation and why it works: The adapted query focuses on aggregating the desired metrics at the supply_source level, utilizing fields available in the dsp_impressions table: SQL 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 🔍 Explanation of Changes The core principle of the adaptation is to replace the previous grouping dimensions with the single dimension required: supply_source .Multiple correct