Advertising
Amazon DSP schema
SightShark syncs Amazon DSP into a data warehouse you own. It creates 58 tables holding 1156 fields, refreshed daily. Programmatic delivery across campaign, audience, geography, product, technology and inventory reports, plus the full order and line item structure, creatives, and brand lift studies.
58 tables / 1156 fields / Tables from the production sync
Tables and fields
Every table this connector creates. Field lists come from the production sync where we publish it, and otherwise from the documented schema, marked on the table.
campaign
19 fields
- advertiser_id
- order_id
- order_name
- line_item_id
- creative_id
- date
- total_cost
- gross_impressions
- measurable_impressions
- invalid_impressions
- gross_click_throughs
- click_through_rate
- total_purchases
- total_sales
- total_units_sold
- detail_page_views
- new_to_brand_detail_page_views
- viewability_rate
- third_party_fees
inventory
11 fields
- supply_source
- site
- placement
- deal_id
- creative_type
- total_cost
- supply_cost
- impressions
- measurable_rate
- roas
- total_roas
product
9 fields
- asin
- parent_asin
- product_name
- brand_name
- product_category
- purchases
- purchases_brand_halo
- units_sold
- sales_clicks
ad_group
12 fields
- id
- campaign_id
- name
- state
- delivery_status
- inventory_type
- budget_amount
- bid_base_bid
- bid_max_average_cpm
- optimization_bid_strategy
- pacing_delivery_profile
- start_date_time
ad_group_fee
5 fields
- ad_group_id
- fee_type
- fee_value
- fee_value_type
- third_party_provider
audience
262 fields, documented schema
- line_item_id
- order_id
- profile_id
- add_to_cart
- add_to_cart_clicks
- add_to_cart_rate
- add_to_cart_views
- add_to_list
- add_to_list_clicks
- add_to_list_rate
- add_to_list_views
- add_to_shopping_cart
- add_to_shopping_cart_clicks
- add_to_shopping_cart_cpa
- add_to_shopping_cart_cvr
- add_to_shopping_cart_value_average
- add_to_shopping_cart_value_sum
- add_to_shopping_cart_views
- add_to_watchlist
- add_to_watchlist_clicks
- add_to_watchlist_rate
- add_to_watchlist_views
- advertiser_id
- amazon_dsp_audience_fee
- amazon_dsp_console_fee
- application
- application_clicks
- application_cpa
- application_cvr
- application_value_average
- application_value_sum
- application_views
- audio_ad_companion_banner_clicks
- audio_ad_companion_banner_views
- audio_ad_completion_rate
- audio_ad_completions
- audio_ad_first_quartile
- audio_ad_midpoint
- audio_ad_mute
- audio_ad_pause
- audio_ad_progression
- audio_ad_resume
- audio_ad_rewind
- audio_ad_skip
- audio_ad_start
- audio_ad_third_quartile
- audio_ad_unmute
- audio_ad_views
- average_cost_per_click_to_apply
- average_cost_per_kindle_detail_page_view
- brand_search_rate
- brand_searches
- brand_searches_clicks
- brand_searches_views
- checkout
- checkout_clicks
- checkout_cpa
- checkout_cvr
- checkout_value_average
- checkout_value_sum
- checkout_views
- click_through_rate
- click_to_apply
- click_to_apply_clicks
- click_to_apply_conversion_rate
- click_to_apply_views
- clicks
- contact
- contact_clicks
- contact_cpa
- contact_cvr
- contact_value_average
- contact_value_sum
- contact_views
- detail_page_view_clicks
- detail_page_view_rate
- detail_page_view_rate_promoted_clicks
- detail_page_view_views
- detail_page_views
- downloaded_video_play_rate
- downloaded_video_plays
- downloaded_video_plays_clicks
- downloaded_video_plays_views
- ecp_add_to_cart
- ecp_add_to_list
- ecp_add_to_watchlist
- ecp_audio_ad_completion
- ecp_brand_search
- ecp_detail_page_view
- ecp_downloaded_video_plays
- ecp_free_trial_subscription_signup
- ecp_new_subscribe_and_save
- ecp_paid_subscription_signup
- ecp_play_trailer
- ecp_product_review_page_visit
- ecp_rental
- ecp_subscription_signup
- ecp_video_ad_completion
- ecp_video_download
- ecp_video_stream
- ecpc
- ecpm
- ecpp
- effective_cost_per_detail_page_view_promoted_clicks
- effective_cost_per_purchase_promoted_clicks
- effective_cost_per_skill_invocation
- free_trial_subscription_signup_clicks
- free_trial_subscription_signup_rate
- free_trial_subscription_signup_views
- free_trial_subscription_signups
- impressions
- interactive_impressions
- interval_end
- interval_start
- kindle_detail_page_view
- kindle_detail_page_view_clicks
- kindle_detail_page_view_rate
- kindle_detail_page_view_views
- lead
- lead_clicks
- lead_cpa
- lead_cvr
- lead_value_average
- lead_value_sum
- lead_views
- line_item_comments
- line_item_name
- line_item_type
- master_clicks
- master_impressions
- mobile_app_first_start_clicks
- mobile_app_first_start_cpa
- mobile_app_first_start_cvr
- mobile_app_first_start_views
- mobile_app_first_starts
- new_subscribe_and_save
- new_subscribe_and_save_clicks
- new_subscribe_and_save_rate
- new_subscribe_and_save_views
- new_to_brand_detail_page_view_clicks
- new_to_brand_detail_page_view_rate
- new_to_brand_detail_page_view_views
- new_to_brand_detail_page_views
- new_to_brand_ecp_detail_page_view
- new_to_brand_ecpp
- new_to_brand_purchase_rate
- new_to_brand_purchases
- new_to_brand_purchases_clicks
- new_to_brand_purchases_percentage
- new_to_brand_purchases_views
- notification_clicks
- notification_opens
- off_amazon_clicks
- off_amazon_ecpp
- off_amazon_purchases_clicks
- off_amazon_purchases_views
- off_amazon_views
- oms_line_item_id
- oms_proposal_id
- order_currency
- order_name
- other
- other_clicks
- other_cpa
- other_cvr
- other_value_average
- other_value_sum
- other_views
- page_view_clicks
- page_view_cpa
- page_view_cvr
- page_view_value_average
- page_view_value_sum
- page_view_views
- page_views
- paid_subscription_signup_clicks
- paid_subscription_signup_rate
- paid_subscription_signup_views
- paid_subscription_signups
- play_trailer_rate
- play_trailers
- play_trailers_clicks
- play_trailers_views
- product_review_page_visit_rate
- product_review_page_visits
- product_review_page_visits_clicks
- product_review_page_visits_views
- purchase_rate
- purchases
- purchases_clicks
- purchases_clicks_rate
- purchases_views
- rental_rate
- rentals
- rentals_clicks
- rentals_views
- search
- search_clicks
- search_cpa
- search_cvr
- search_value_average
- search_value_sum
- search_views
- segment_class_code
- segment_id
- segment_marketplace_id
- segment_name
- segment_source
- segment_type
- sign_up_cpa
- sign_up_cvr
- sign_up_value_average
- sign_up_value_sum
- sign_up_views
- skill_invocation
- skill_invocation_clicks
- skill_invocation_rate
- skill_invocation_views
- subscribe
- subscribe_clicks
- subscribe_cpa
- subscribe_cvr
- subscribe_value_average
- subscribe_value_sum
- subscribe_views
- subscription_signup_clicks
- subscription_signup_rate
- subscription_signup_views
- subscription_signups
- supply_cost
- targeting_method
- total_cost
- total_new_to_brand_dpv_clicks
- total_new_to_brand_dpv_rate
- total_new_to_brand_dpv_views
- total_new_to_brand_dpvs
- total_new_to_brand_ecp_detail_page_view
- video_ad_clicks
- video_ad_complete
- video_ad_completion_rate
- video_ad_creative_views
- video_ad_end_state_clicks
- video_ad_first_quartile
- video_ad_impressions
- video_ad_midpoint
- video_ad_mute
- video_ad_pause
- video_ad_replays
- video_ad_resume
- video_ad_skip_backs
- video_ad_skip_forwards
- video_ad_start
- video_ad_third_quartile
- video_ad_unmute
- video_download_rate
- video_downloads
- video_downloads_clicks
- video_downloads_views
- video_streams
- video_streams_clicks
- video_streams_rate
- video_streams_views
geo
255 fields, documented schema
- line_item_id
- order_id
- profile_id
- add_to_cart
- add_to_cart_clicks
- add_to_cart_views
- add_to_list
- add_to_list_clicks
- add_to_list_views
- add_to_shopping_cart
- add_to_shopping_cart_clicks
- add_to_shopping_cart_value_average
- add_to_shopping_cart_value_sum
- add_to_shopping_cart_views
- add_to_watchlist
- add_to_watchlist_clicks
- add_to_watchlist_views
- advertiser_id
- agency_fee
- app_subscription_cost
- app_subscription_free_trial_cost
- app_subscription_sign_up
- app_subscription_sign_up_clicks
- app_subscription_sign_up_free_trial
- app_subscription_sign_up_free_trial_clicks
- app_subscription_sign_up_free_trial_rate
- app_subscription_sign_up_free_trial_views
- app_subscription_sign_up_paid
- app_subscription_sign_up_paid_clicks
- app_subscription_sign_up_paid_cost
- app_subscription_sign_up_paid_rate
- app_subscription_sign_up_paid_views
- app_subscription_sign_up_rate
- app_subscription_sign_up_views
- application
- application_clicks
- application_value_average
- application_value_sum
- application_views
- audio_ad_companion_banner_clicks
- audio_ad_companion_banner_views
- audio_ad_completion_rate
- audio_ad_completions
- audio_ad_first_quartile
- audio_ad_midpoint
- audio_ad_mute
- audio_ad_pause
- audio_ad_progression
- audio_ad_resume
- audio_ad_rewind
- audio_ad_skip
- audio_ad_start
- audio_ad_third_quartile
- audio_ad_unmute
- audio_ad_views
- brand_search_rate
- brand_searches
- brand_searches_clicks
- brand_searches_views
- checkout
- checkout_clicks
- checkout_value_average
- checkout_value_sum
- checkout_views
- city
- click_through_rate
- click_to_apply
- click_to_apply_clicks
- click_to_apply_views
- clicks
- combined_product_sales
- combined_purchases
- combined_purchases_clicks
- combined_purchases_views
- combined_units_sold
- contact
- contact_clicks
- contact_value_average
- contact_value_sum
- contact_views
- country
- detail_page_view_clicks
- detail_page_view_views
- detail_page_views
- dma_code
- dma_name
- downloaded_video_plays
- downloaded_video_plays_clicks
- downloaded_video_plays_views
- ecp_audio_ad_completion
- ecp_brand_search
- ecp_skill_invocation
- ecpc
- ecpm
- free_trial_subscription_signup_clicks
- free_trial_subscription_signup_views
- free_trial_subscription_signups
- gross_click_throughs
- gross_impressions
- impressions
- interactive_impressions
- interval_end
- interval_start
- invalid_click_through_rate
- invalid_click_throughs
- invalid_impression_rate
- invalid_impressions
- kindle_detail_page_view
- kindle_detail_page_view_clicks
- kindle_detail_page_view_views
- lead
- lead_clicks
- lead_value_average
- lead_value_sum
- lead_views
- line_item_budget
- line_item_comments
- line_item_end_date
- line_item_name
- line_item_start_date
- mobile_app_first_start_average
- mobile_app_first_start_clicks
- mobile_app_first_start_sum
- mobile_app_first_start_views
- mobile_app_first_starts
- new_subscribe_and_save
- new_subscribe_and_save_clicks
- new_subscribe_and_save_views
- new_to_brand_detail_page_view_clicks
- new_to_brand_detail_page_view_rate
- new_to_brand_detail_page_view_views
- new_to_brand_detail_page_views
- new_to_brand_ecp_detail_page_view
- new_to_brand_purchases
- new_to_brand_purchases_clicks
- new_to_brand_purchases_views
- new_to_brand_units_sold
- notification_clicks
- notification_opens
- off_amazon_clicks
- off_amazon_purchases_clicks
- off_amazon_purchases_views
- off_amazon_units_sold
- off_amazon_views
- oms_line_item_id
- order_budget
- order_currency
- order_end_date
- order_name
- order_start_date
- other
- other_clicks
- other_value_average
- other_value_sum
- other_views
- page_view_clicks
- page_view_value_average
- page_view_value_sum
- page_view_views
- page_views
- paid_subscription_signup_clicks
- paid_subscription_signup_views
- paid_subscription_signups
- play_trailers
- play_trailers_clicks
- play_trailers_views
- postal_code
- product_review_page_visits
- product_review_page_visits_clicks
- product_review_page_visits_views
- purchases
- purchases_clicks
- purchases_views
- region
- rentals
- rentals_clicks
- rentals_views
- sales_clicks
- sales_promoted_clicks
- search
- search_clicks
- search_value_average
- search_value_sum
- search_views
- sign_up_value_average
- sign_up_value_sum
- sign_up_views
- skill_invocation
- skill_invocation_clicks
- skill_invocation_rate
- skill_invocation_views
- subscribe
- subscribe_clicks
- subscribe_value_average
- subscribe_value_sum
- subscribe_views
- subscription_signup_clicks
- subscription_signup_views
- subscription_signups
- total_add_to_cart
- total_add_to_cart_clicks
- total_add_to_cart_views
- total_add_to_list
- total_add_to_list_clicks
- total_add_to_list_views
- total_cost
- total_detail_page_view
- total_detail_page_view_clicks
- total_detail_page_view_views
- total_new_to_brand_dpv_clicks
- total_new_to_brand_dpv_rate
- total_new_to_brand_dpv_views
- total_new_to_brand_dpvs
- total_new_to_brand_ecp_detail_page_view
- total_new_to_brand_purchases
- total_new_to_brand_purchases_clicks
- total_new_to_brand_purchases_views
- total_new_to_brand_units_sold
- total_product_review_page_visits
- total_product_review_page_visits_clicks
- total_product_review_page_visits_views
- total_purchases
- total_purchases_clicks
- total_purchases_views
- total_subscribe_and_save
- total_subscribe_and_save_clicks
- total_subscribe_and_save_views
- total_units_sold
- units_sold
- units_sold_clicks
- units_sold_promoted_clicks
- video_ad_clicks
- video_ad_complete
- video_ad_completion_rate
- video_ad_creative_views
- video_ad_end_state_clicks
- video_ad_first_quartile
- video_ad_impressions
- video_ad_midpoint
- video_ad_mute
- video_ad_pause
- video_ad_replays
- video_ad_resume
- video_ad_skip_backs
- video_ad_skip_forwards
- video_ad_start
- video_ad_third_quartile
- video_ad_unmute
- video_downloads
- video_downloads_clicks
- video_downloads_views
- video_streams
- video_streams_clicks
- video_streams_views
- viewable_impressions
tech
190 fields, documented schema
- line_item_id
- order_id
- profile_id
- add_to_cart
- add_to_cart_clicks
- add_to_cart_views
- add_to_list
- add_to_list_clicks
- add_to_list_views
- add_to_shopping_cart
- add_to_shopping_cart_clicks
- add_to_shopping_cart_value_average
- add_to_shopping_cart_value_sum
- add_to_shopping_cart_views
- add_to_watchlist
- add_to_watchlist_clicks
- add_to_watchlist_views
- advertiser_id
- application
- application_clicks
- application_value_average
- application_value_sum
- application_views
- audio_ad_companion_banner_clicks
- audio_ad_companion_banner_views
- audio_ad_completion_rate
- audio_ad_completions
- audio_ad_first_quartile
- audio_ad_midpoint
- audio_ad_mute
- audio_ad_pause
- audio_ad_progression
- audio_ad_resume
- audio_ad_rewind
- audio_ad_skip
- audio_ad_start
- audio_ad_third_quartile
- audio_ad_unmute
- audio_ad_views
- brand_search_rate
- brand_searches
- brand_searches_clicks
- brand_searches_views
- browser_name
- browser_version
- checkout
- checkout_clicks
- checkout_value_average
- checkout_value_sum
- checkout_views
- click_through_rate
- click_to_apply
- click_to_apply_clicks
- click_to_apply_views
- clicks
- contact
- contact_clicks
- contact_value_average
- contact_value_sum
- contact_views
- detail_page_view_clicks
- detail_page_view_views
- detail_page_views
- device_name
- downloaded_video_plays
- downloaded_video_plays_clicks
- downloaded_video_plays_views
- e_cpc
- e_cpm
- ecp_audio_ad_completion
- ecp_brand_search
- ecp_skill_invocation
- environment_name
- free_trial_subscription_signup_clicks
- free_trial_subscription_signup_views
- free_trial_subscription_signups
- impressions
- interactive_impressions
- interval_end
- interval_start
- kindle_detail_page_view
- kindle_detail_page_view_clicks
- kindle_detail_page_view_views
- lead
- lead_clicks
- lead_value_average
- lead_value_sum
- lead_views
- line_item_comments
- line_item_name
- mobile_app_first_start_average
- mobile_app_first_start_clicks
- mobile_app_first_start_sum
- mobile_app_first_start_views
- mobile_app_first_starts
- new_subscribe_and_save
- new_subscribe_and_save_clicks
- new_subscribe_and_save_views
- new_to_brand_detail_page_view_clicks
- new_to_brand_detail_page_view_rate
- new_to_brand_detail_page_view_views
- new_to_brand_detail_page_views
- new_to_brand_ecp_detail_page_view
- new_to_brand_purchases
- new_to_brand_purchases_clicks
- new_to_brand_purchases_views
- notification_clicks
- notification_opens
- off_amazon_clicks
- off_amazon_purchases_clicks
- off_amazon_purchases_views
- off_amazon_views
- oms_line_item_id
- operating_system_name
- order_currency
- order_name
- other
- other_clicks
- other_value_average
- other_value_sum
- other_views
- page_view_clicks
- page_view_value_average
- page_view_value_sum
- page_view_views
- page_views
- paid_subscription_signup_clicks
- paid_subscription_signup_views
- paid_subscription_signups
- play_trailers
- play_trailers_clicks
- play_trailers_views
- product_review_page_visits
- product_review_page_visits_clicks
- product_review_page_visits_views
- purchases
- purchases_clicks
- purchases_views
- rentals
- rentals_clicks
- rentals_views
- search
- search_clicks
- search_value_average
- search_value_sum
- search_views
- sign_up_value_average
- sign_up_value_sum
- sign_up_views
- skill_invocation
- skill_invocation_clicks
- skill_invocation_rate
- skill_invocation_views
- subscribe
- subscribe_clicks
- subscribe_value_average
- subscribe_value_sum
- subscribe_views
- subscription_signup_clicks
- subscription_signup_views
- subscription_signups
- total_cost
- total_new_to_brand_dpv_clicks
- total_new_to_brand_dpv_rate
- total_new_to_brand_dpv_views
- total_new_to_brand_dpvs
- total_new_to_brand_ecp_detail_page_view
- video_ad_clicks
- video_ad_complete
- video_ad_completion_rate
- video_ad_creative_views
- video_ad_end_state_clicks
- video_ad_first_quartile
- video_ad_impressions
- video_ad_midpoint
- video_ad_mute
- video_ad_pause
- video_ad_replays
- video_ad_resume
- video_ad_skip_backs
- video_ad_skip_forwards
- video_ad_start
- video_ad_third_quartile
- video_ad_unmute
- video_downloads
- video_downloads_clicks
- video_downloads_views
- video_streams
- video_streams_clicks
- video_streams_views
ad_group_budget_cap
8 fields, documented schema
- index
- ad_group_id
- advertiser_id
- campaign_id
- profile_id
- amount
- currency_code
- recurrence_time_period
ad_group_frequency
10 fields, documented schema
- index
- ad_group_id
- advertiser_id
- campaign_id
- profile_id
- frequency_type
- level_type
- max_impressions
- time_unit
- time_unit_count
ad_group_advertised_product_category
5 fields, documented schema
- ad_group_id
- advertiser_id
- campaign_id
- id
- profile_id
campaign_list
25 fields, documented schema
- id
- advertiser_id
- profile_id
- skan_app_id
- agency_fee_percentage
- comment
- creation_date_time
- delivery_status
- end_date_time
- last_updated_date_time
- name
- optimization_automate_bid_allocation
- optimization_automate_budget_allocation
- optimization_automated_adgroup_creation_setting_performance_plus_inventory_type
- optimization_bid_strategy
- optimization_flight_budget_rollover_setting_rollover_strategy
- optimization_goal_setting_currency_code
- optimization_goal_setting_goal
- optimization_goal_setting_kpi
- optimization_goal_setting_target_kpi
- optimization_primary_inventory_type
- purchase_order_number
- start_date_time
- state
- target_amazon_deal
campaign_list_budget_cap
7 fields, documented schema
- index
- advertiser_id
- campaign_list_id
- profile_id
- amount
- currency_code
- recurrence_time_period
campaign_list_flight
9 fields, documented schema
- index
- advertiser_id
- campaign_list_id
- profile_id
- budget_amount
- currency_code
- end_date_time
- flight_id
- start_date_time
campaign_list_frequency
9 fields, documented schema
- index
- advertiser_id
- campaign_list_id
- profile_id
- frequency_type
- level_type
- max_impressions
- time_unit
- time_unit_count
ad_creative
27 fields, documented schema
- id
- advertiser_id
- profile_id
- accessibility_text
- ad_choice_position
- additional_html
- attribute
- auto_localization_state
- category
- country
- created_date_time
- external_id
- format_properties_ad_creative_format_type
- format_properties_additional_attribute_allow_third_party_seller
- format_properties_additional_attribute_allowed_retail_format
- format_properties_additional_attribute_creative_content_type
- format_properties_additional_attribute_optimization_goal
- format_properties_additional_attribute_render_optimization
- format_properties_additional_attribute_target_placement
- format_properties_skippability_setting_skippable_type
- format_properties_third_party_tag_destination_on_amazon
- format_properties_third_party_tag_source
- format_properties_third_party_tag_type
- hosted_type
- languages
- last_updated_date_time
- name
ad_creative_format_property_ad_copy
6 fields, documented schema
- index
- ad_creative_id
- advertiser_id
- profile_id
- type
- value
ad_creative_format_property_asset
9 fields, documented schema
- index
- ad_creative_id
- advertiser_id
- profile_id
- apply_border
- associated_ad_experience
- id
- url
- version
ad_creative_format_property_click_action
8 fields, documented schema
- index
- ad_creative_id
- advertiser_id
- profile_id
- associated_ad_experience
- enable_deep_linking
- type
- url_destination
ad_creative_format_property_creative_size
7 fields, documented schema
- index
- ad_creative_id
- advertiser_id
- profile_id
- height
- responsive
- width
ad_creative_format_property_product
9 fields, documented schema
- index
- ad_creative_id
- advertiser_id
- profile_id
- id
- review_text
- review_url
- title
- type
ad_creative_format_property_tracking_url
7 fields, documented schema
- index
- ad_creative_id
- advertiser_id
- profile_id
- associated_ad_experience
- type
- url
ad_creative_moderation_ad_experience
7 fields, documented schema
- ad_creative_id
- advertiser_id
- index
- profile_id
- ad_experience
- moderation_status
- reason
ad_creative_ad_group_association
6 fields, documented schema
- ad_creative_id
- ad_group_id
- advertiser_id
- profile_id
- creative_association_status
- state
app
5 fields, documented schema
- advertiser_id
- id
- profile_id
- legacy_id
- name
domain_list
5 fields, documented schema
- id
- profile_id
- count
- last_updated_date_time
- name
third_party_target_segment
6 fields, documented schema
- id
- advertiser_id
- profile_id
- description
- name
- target_type
advertised_product_category
4 fields, documented schema
- id
- profile_id
- parent_id
- name
iab_content_category
4 fields, documented schema
- id
- profile_id
- parent_id
- name
inventory_source_exchange
9 fields, documented schema
- id
- advertiser_id
- profile_id
- country
- device_type
- inventory_source_type
- inventory_type
- mobile_environment
- name
measurement_brand_lift_study
19 fields, documented schema
- id
- advertiser_id
- profile_id
- benchmark_category
- brand_name
- comment
- create_date
- end_date
- external_reference_id
- last_updated_date
- name
- product_category
- review_date
- start_date
- status
- study_result_status
- survey_id
- vendor_product_id
- verb
brand_lift_study_status_reason
3 fields, documented schema
- index
- brand_lift_study_id
- status_reason
brand_lift_study_rejection_reason
3 fields, documented schema
- index
- brand_lift_study_id
- rejection_reason
brand_lift_study_link
4 fields, documented schema
- index
- brand_lift_study_id
- name
- url
brand_lift_study_excluded_line_item
3 fields, documented schema
- index
- brand_lift_study_id
- excluded_line_item_id
brand_lift_study_order
3 fields, documented schema
- index
- brand_lift_study_id
- order_id
brand_lift_study_peer_name
3 fields, documented schema
- index
- brand_lift_study_id
- peer_name
measurement_study
15 fields, documented schema
- id
- advertiser_id
- profile_id
- comment
- create_date
- end_date
- external_reference_id
- last_updated_date
- name
- review_date
- start_date
- status
- study_result_status
- survey_id
- vendor_product_id
measurement_study_status_reason
3 fields, documented schema
- index
- measurement_study_id
- status_reason
measurement_study_rejection_reason
3 fields, documented schema
- index
- measurement_study_id
- rejection_reason
measurement_study_link
4 fields, documented schema
- index
- measurement_study_id
- name
- url
measurement_creative_testing_study
17 fields, documented schema
- id
- advertiser_id
- profile_id
- brand_name
- comment
- create_date
- end_date
- external_reference_id
- last_updated_date
- name
- product_category
- review_date
- start_date
- status
- study_result_status
- survey_id
- vendor_product_id
measurement_creative_testing_study_status_reason
3 fields, documented schema
- index
- measurement_creative_testing_study_id
- status_reason
measurement_creative_testing_study_asset
4 fields, documented schema
- asset_id
- measurement_creative_testing_study_id
- asset_type
- version
measurement_survey_question_template
14 fields, documented schema
- id
- profile_id
- category
- locale
- maximum_qualifying_responses
- maximum_question_responses
- minimum_qualifying_responses
- minimum_question_responses
- objective_type
- priority
- question_text
- sub_category
- type
- vendor_product_id
survey_question_qualifying_response
3 fields, documented schema
- index
- measurement_survey_question_template_id
- qualifying_response
survey_question_response
3 fields, documented schema
- index
- measurement_survey_question_template_id
- question_response
survey_question_placeholder_candidate
7 fields, documented schema
- index
- measurement_survey_question_template_id
- allow_custom_value
- field_name
- maximum_value_length
- minimum_value_length
- value_type
placeholder_candidate_allowed_value
6 fields, documented schema
- index
- measurement_survey_question_template_id
- parent_field
- parent_value
- survey_question_placeholder_candidate_index
- value
placeholder_candidate_allowed_value_range
7 fields, documented schema
- index
- measurement_survey_question_template_id
- survey_question_placeholder_candidate_index
- maximum_value
- minimum_value
- parent_field
- parent_value
placeholder_candidate_inferred_field
4 fields, documented schema
- index
- measurement_survey_question_template_id
- survey_question_placeholder_candidate_index
- inferred_field
placeholder_candidate_default_value
4 fields, documented schema
- index
- measurement_survey_question_template_id
- survey_question_placeholder_candidate_index
- default_value
audio_and_video
19 fields, documented schema
- creative_id
- line_item_id
- order_id
- profile_id
- advertiser_id
- advertiser_name
- content_genre
- content_rating
- cost_per_thousand_impressions
- creative_name
- gross_impressions
- impressions
- interval_end
- interval_start
- invalid_impressions
- line_item_name
- order_name
- supply_source
- supply_source_id
reach_and_frequency
9 fields, documented schema
- profile_id
- advertiser_id
- date
- frequency_average
- frequency_group_id
- frequency_group_name
- interval_end
- interval_start
- reach
bid_adjustment
15 fields, documented schema
- profile_id
- advertiser_id
- bid_adjustment
- bid_adjustment_matched_term
- bid_adjustment_matched_term_id
- bid_adjustment_rule
- bid_adjustment_rule_id
- bid_adjustment_rule_version_id
- bids
- date
- line_item_id
- line_item_name
- match_rate
- order_id
- win_rate
profile
10 fields, documented schema
- id
- account_id
- account_marketplace_string_id
- account_name
- account_sub_type
- account_type
- account_valid_payment_method
- country_code
- currency_code
- timezone
advertiser
7 fields, documented schema
- id
- profile_id
- country
- currency
- name
- timezone
- url
campaign_conversion_tracking_product
6 fields, documented schema
- product_id
- advertiser_id
- campaign_list_id
- profile_id
- domain
- product_association
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Every ad platform names the same number differently and reports it in its own currency and its own time zone. Put two of them in one report without reconciling that and the totals disagree.
Questions people ask
What tables does SightShark create from Amazon DSP?
58 tables, including campaign, inventory, product. campaign is one row per line item, per creative, per day. Every one is listed on this page, with its fields.
Which Amazon DSP fields can I get?
The 1156 fields on this page, table by table. Lists marked documented schema follow the published schema for Amazon DSP, and your own warehouse may carry a few more or fewer.
How often does Amazon DSP data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Amazon DSP data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Amazon DSP and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 6 min read
Budget pacing: the formula, and the report.
Spend against plan, while there is still time to do something about it.
Read it - 5 min read
How often marketing data should refresh.
Almost always daily. Here is why more often is usually worse, not better.
Read it - 7 min read
Reporting across currencies and time zones.
Both are the same failure. A number that means something different depending on where it was read, and no error either way.
Read it
Get started
Want Amazon DSP in your own warehouse?
A call with someone who can answer the schema questions.