- dsp_impressions_by_matched_segments, amazon_attributed_events_*
- dsp_impressions_by_user_segments, amazon_attributed_events_*
- dsp_impressions, amazon_attributed_events_*
The correct answer is: dsp_impressions, amazon_attributed_events_*
Explanation: To determine the Amazon-attributed conversion volumes per frequency bucket for Amazon DSP traffic only, you need to use both the dsp_impressions table and the amazon_attributed_events_* tables.
- dsp_impressions: This table provides detailed records of Amazon DSP impression events, including user identifier, frequency data, and campaign metadata.
- amazon_attributed_events_*: These tables (notably amazon_attributed_events_by_conversion_time and amazon_attributed_events_by_traffic_time) contain conversion events attributed to Amazon ads, including which traffic events (impressions or clicks) led to conversions. By joining these with frequency data from dsp_impressions, you can group conversions by the frequency with which users saw ads.
Reference content: From the official Amazon documentation:
- “[The dsp_impressions table] contains the most granular record of every impression delivered, allowing you to query the all viewers reached through an Amazon DSP campaign.” (dsp_impressions)
- “Amazon attributed events tables … contain pairs of traffic and conversion events. ‘Traffic events’ are impressions and clicks. ‘Conversion events’ include purchases, page views, and other interactions … Each conversion event in the table is attributed to its corresponding traffic event.” (amazon_attributed_events_by_conversion_time)