Category: Amazon Marketing Cloud Exam Answers

Download Amazon Marketing Cloud Certification Exam Answers

Posted on

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
Posted on

Which of the following statements about the amazon_attributed_events_* tables is true.

  • Conversions are only available for on-Amazon events, such as purchases and detail page views
  • Tables may include multiple records for each conversion
  • Conversions can be attributed to Amazon DSP or sponsored ads campaign traffic
  • Amazon Ads attribution logic allows a conversion to be attributed to multiple traffic events

The correct answer is:

  • Conversions can be attributed to Amazon DSP or sponsored ads campaign traffic
Posted on

Which of the following statements about paid features (beta) is false?

  • Paid features are offered as a monthly subscription and can be managed by the administrator of your AMC account
  • Paid features allow advertisers to upload their own first-party insights to better understand the shopping journey
  • Paid features provide access to subscription-based tables that can be used in conjunction with the standard tables available in AMC

The correct answer is:

  • Paid features allow advertisers to upload their own first-party insights to better understand the shopping journey
Posted on

When analyzing the relationship between frequency and purchase rate, what actionable insight can you leverage for campaign optimization?

  • Removing the frequency cap because more impressions always leads to more conversions
  • Setting the frequency cap to maximize reach
  • Setting the frequency cap to maximize purchase rate while limiting waste or over delivery

The correct answer is:

  • Setting the frequency cap to maximize purchase rate while limiting waste or over delivery