• SELECT creative, creative_id, SUM (impressions) AS impressions FROM sponsored_ads_traffic GROUP BY 1,2
• SELECT creative, creative_id, SUM (impressions) AS impressions FROM dsp_impressions WHERE creative IS LIVE GROUP BY 1,2
• SELECT creative, creative_id, SUM (impressions) AS impressions FROM amazon_attributed_events_by_traffic_time GROUP BY 1,2
• SELECT creative, creative_id, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2

The correct answer is: SELECT creative, creative_id, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2

Explanation: To generate a list of all Amazon DSP creative active during your chosen time window, you would run the following exploratory query in AMC:

SELECT creative, creative_id, SUM(impressions) AS impressions
FROM dsp_impressions
GROUP BY 1,2

This query:

• Uses the dsp_impressions table (which contains the most granular record of every impression delivered).
• Selects the creative name and creative_id.
• Aggregates total impressions for each creative during the specified time window.
• The GROUP BY 1,2 groups the output by creative and creative_id, listing all active creatives during your time window.

Reference content: DSP impressions table reference

“creative: Name of the Amazon DSP creative/ad.

creative_id: Unique identifier for the Amazon DSP creative/ad.

impressions: Count of Amazon DSP impressions … This table contains the most granular record of every impression delivered.”