Advertisement
Exam Name: Amazon Marketing Cloud Certification
- Why are developer resources required for creating first-party tables in AMC?
- For sponsored ads Cost-per-Click (CPC) campaigns, only click events are eligible for attribution of conversion events.
- 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?
- There is not a field for campaign ID in the sponsored_ads_traffic table, so the _____________ field can be used to filter to traffic events from the relevant sponsored ads campaigns.
- If 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?
- Super 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?
- How can you determine if NULL values are the result of aggregation thresholds or a natural occurrence within your report?
- In AMC, a conversion is defined as an Amazon.com purchase event.
- Which value is not available for Sponsored Products?
- Which AWS service can be leveraged by the AWS Admin to provide appropriate permissions and access keys to AMC API users?
- What types of Sponsored Products records will have spend metrics?
- Why is it considered a good best practice to exclude NULL user_id values from reach and frequency queries?
- Which of the following Amazon services can be used to visualize aggregated AMC reports in a dashboard?
- Which two functions can be used together to filter records based on presence of a string within a column’s values?
- user_id values cannot be viewed in the AMC user interface or downloaded from AMC.
- Which table would you leverage for a query when your objective is to understand how your current audience strategy is performing for your campaigns?
- Which AMC tables would be required for determining the Amazon-attributed conversion volumes per frequency bucket (including Amazon DSP traffic only)?
- Which of the following business questions can be answered with an overlap analysis?
- Why should you wait until 14 days after the end date of your query date range to run analyses that leverage the amazon_attributed_events_by_traffic_time table?
- How would you adapt this query to limit results to Sponsored Products keyword targeting only?
- Which table should you use in a query meant to help you choose new Amazon audiences that may benefit your Amazon DSP campaign performance?
- The LIKE function is unsupported by AMC. Which of the following AMC-supported functions can serve as a substitute?
- The _________ field contains the pseudonymous ad identifier associated with a given impression. It is often used in calculations to understand unique reach volumes.
- Overlap analyses enable you to generate insights by comparing different groups of __________ values in isolation and when overlapped.
- Which of these queries will only include purchase records from the underlying table?
- AMC can be used by brands that don’t sell their products directly in the Amazon store.
- 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.
- New-to-brand metrics are only relevant for __________.
- AMC users have access to all AMC instances in an account by default.
- This 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.
- Which event table can be used when attributing conversions to your campaign using custom logic (e.g., 28 day lookback window)?
- Which of the following statements is true about using queries within the instructional query library?
- What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?
- Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions
- The __________ field functions as a grouping indicator for the impression and any associated clicks, view events, or conversion events.
- Which signals are not available within AMC?
- Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying ____________ to your query.
- You must connect your organization’s AWS account to AMC in order to leverage the AMC APIs.
- What are the two ways to access AMC?
- You can use a _________ filter to limit your query results based on one or more conditions.
- What is a primary usage of the UNION ALL function in AMC queries?
- Rule-based audience creation leverages a separate set of tables than those utilized for AMC reporting.
- When determining total impressions served over a given date range, you can use dsp_impressions or dsp_views.
- What is one limitation of AMC SQL?
- AMC supports most common SQL functions, but there are some unsupported SQL functions.
- Which of these use cases can be achieved when using Amazon Ads events in conjunction with first-party inputs?
- To minimize the number of values rendered NULL due to aggregation thresholds, you can:
- Where can you activate AMC rule-based audiences?
- Which of these statements is true regarding recurring query automation?
- Nutrition Co., a health snack company, would like to know the total impressions that have been delivered per campaign, per supply_source, per device_type. Which of the following represents how to write this query?
- How would you adapt this query to obtain cost and impression metrics by supply_source?
- Why would this query fail?
- The Path to Conversion by Campaign Groups IQ considers all touch points but the output is based on the timing of the first impression of the campaign group.
- What is an exploratory query?
- What is the max window over which AMC can accrue Amazon Ads events?
- There is no universal methodology or join key that can be used to combine tables in all query scenarios.
- The submitted queries table provides details of the query executed and a link to download your aggregated report as a _______ when it’s ready.
- The _____________ field in the conversions_with_relevance table categorizes the relationship between the conversion event and the campaign it is relevant to.
- Clicks are considered conversion events and appear as individual records within the amazon_attributed_events_* tables.
- What is the Amazon Ads attribution lookback window?
- Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
- Which of these statements is false regarding rule-based audiences?
- What is required to access AMC APIs?
- When analyzing the relationship between frequency and purchase rate, what actionable insight can you leverage for campaign optimization?
- A single on-Amazon transaction that includes multiple ASINs from your brand will be represented by a single conversion event within each of the amazon_attributed_events_* tables.
- 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.
- This table contains impression and click events from Sponsored Products (SP), Sponsored Brands (SB), and Sponsored Display (SD) campaigns.
- If you want to understand more about which product or pixel your conversion events are associated with, which field in the amazon_attributed_events_* tables should you leverage?
- Cost and fee fields are always reported in microcents.
- Which of the following statements about paid features (beta) is false?
- Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table?
- Which of the following statements about the amazon_attributed_events_* tables is true.
- Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?
- Performance reporting, such as Path to Conversion reporting, can be constrained to specific conversion events (e.g. purchases of a specific ASIN).
- 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 __________.
- 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
- Within the amazon_attributed_events_* tables, Amazon Ads will only attribute conversion events to click events for sponsored ads CPC (cost-per-click) campaigns.
Join our list
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.