How can you determine if NULL values are the result of aggregation thresholds or a natural occurrence within your report?
Check the aggregation thresholds for the event tables in the Schema explorer
Run the report multiple times and look for a variance in the results
Use the Append aggregation threshold columns option in the Query editor
NULL values don’t occur naturally within reports unless the query is invalid.
Correct Answer
Use the Append aggregation threshold columns option in the Query editor
Topics in this question
About the Amazon Marketing Cloud Certification
The Amazon Marketing Cloud Certification covers Amazon's clean-room analytics environment: how AMC data is structured, writing SQL queries against it, and turning results such as overlap and path-to-conversion analysis into audience and media decisions.
Exam guide and all 94 Amazon Marketing Cloud questions →Related Amazon Marketing Cloud questions
- 1Which action can be used to determine if NULL values are a natural occurrence within your report or the result of aggregation thresholds?
- 2To minimize the number of values rendered NULL due to aggregation thresholds, you can:
- 3Which of the following statements is true about using queries within the instructional query library?
- 4The submitted queries table provides details of the query executed and a link to download your aggregated report as a _______ when it’s ready.
- 5Performance reporting, such as Path to Conversion reporting, can be constrained to specific conversion events (e.g. purchases of a specific ASIN).
- 6Cost and fee fields are always reported in microcents.