Amazon DSP

Explore the interactive ERD

Table & Field Reference

app

Column	Type	Keys
`advertiser_id`	Unknown	PK
`id`	String	PK
`profile_id`	Unknown	PK
`legacy_id`	String
`name`	String

domain_list

Column	Type	Keys
`id`	String	PK
`profile_id`	Unknown	PKFK
`count`	Int
`last_updated_date_time`	Instant
`name`	String

profile

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown
`account_marketplace_string_id`	Unknown
`account_name`	Unknown
`account_sub_type`	Unknown
`account_type`	Unknown
`account_valid_payment_method`	Unknown
`country_code`	Unknown
`currency_code`	Unknown
`timezone`	Unknown

third_party_target_segment

Column	Type	Keys
`id`	String	PK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`description`	String
`name`	String
`target_type`	String

ad_creative_moderation_ad_experience

Column	Type	Keys
`ad_creative_id`	String	PK
`advertiser_id`	Unknown	PK
`index`	Unknown	PK
`profile_id`	Unknown	PK
`ad_experience`	String
`moderation_status`	String
`reason`	Json

advertised_product_category

Column	Type	Keys
`id`	String	PK
`profile_id`	Unknown	PKFK
`parent_id`	String	FK
`name`	String

brand_lift_study_status_reason

Column	Type	Keys
`index`	Unknown	PK
`brand_lift_study_id`	Unknown	PKFK
`status_reason`	Unknown

brand_lift_study_rejection_reason

Column	Type	Keys
`index`	Unknown	PK
`brand_lift_study_id`	Unknown	PKFK
`rejection_reason`	Unknown

brand_lift_study_link

Column	Type	Keys
`index`	Unknown	PK
`brand_lift_study_id`	Unknown	PKFK
`name`	Unknown
`url`	Unknown

brand_lift_study_excluded_line_item

Column	Type	Keys
`index`	Unknown	PK
`brand_lift_study_id`	Unknown	PKFK
`excluded_line_item_id`	Unknown	FK

brand_lift_study_order

Column	Type	Keys
`index`	Unknown	PK
`brand_lift_study_id`	Unknown	PKFK
`order_id`	Unknown	FK

brand_lift_study_peer_name

Column	Type	Keys
`index`	Unknown	PK
`brand_lift_study_id`	Unknown	PKFK
`peer_name`	Unknown

measurement_brand_lift_study

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown	FK
`profile_id`	Unknown	FK
`benchmark_category`	Unknown
`brand_name`	Unknown
`comment`	Unknown
`create_date`	Unknown
`end_date`	Unknown
`external_reference_id`	Unknown
`last_updated_date`	Unknown
`name`	Unknown
`product_category`	Unknown
`review_date`	Unknown
`start_date`	Unknown
`status`	Unknown
`study_result_status`	Unknown
`survey_id`	Unknown
`vendor_product_id`	Unknown
`verb`	Unknown

ad_creative_ad_group_association

Column	Type	Keys
`ad_creative_id`	String	PKFK
`ad_group_id`	String	PKFK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`creative_association_status`	String
`state`	String

iab_content_category

Column	Type	Keys
`id`	String	PK
`profile_id`	Unknown	PKFK
`parent_id`	String	FK
`name`	String

measurement_study_status_reason

Column	Type	Keys
`index`	Unknown	PK
`measurement_study_id`	Unknown	PKFK
`status_reason`	Unknown

measurement_study_rejection_reason

Column	Type	Keys
`index`	Unknown	PK
`measurement_study_id`	Unknown	PKFK
`rejection_reason`	Unknown

measurement_study_link

Column	Type	Keys
`index`	Unknown	PK
`measurement_study_id`	Unknown	PKFK
`name`	Unknown
`url`	Unknown

measurement_study

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown	FK
`profile_id`	Unknown	FK
`comment`	Unknown
`create_date`	Unknown
`end_date`	Unknown
`external_reference_id`	Unknown
`last_updated_date`	Unknown
`name`	Unknown
`review_date`	Unknown
`start_date`	Unknown
`status`	Unknown
`study_result_status`	Unknown
`survey_id`	Unknown
`vendor_product_id`	Unknown

ad_group_advertised_product_category

Column	Type	Keys
`ad_group_id`	String	PKFK
`advertiser_id`	String	PKFK
`campaign_id`	String	PKFK
`id`	String	PKFK
`profile_id`	Unknown	PKFK

ad_group_budget_cap

Column	Type	Keys
`index`	Int	PK
`ad_group_id`	String	PKFK
`advertiser_id`	String	PKFK
`campaign_id`	String	PKFK
`profile_id`	Unknown	PKFK
`amount`	Double
`currency_code`	String
`recurrence_time_period`	String

ad_group_frequency

Column	Type	Keys
`index`	Int	PK
`ad_group_id`	String	PKFK
`advertiser_id`	String	PKFK
`campaign_id`	String	PKFK
`profile_id`	Unknown	PKFK
`frequency_type`	String
`level_type`	String
`max_impressions`	Int
`time_unit`	String
`time_unit_count`	Int

ad_group_fee

Column	Type	Keys
`index`	Int	PK
`ad_group_id`	String	PKFK
`advertiser_id`	String	PKFK
`campaign_id`	String	PKFK
`profile_id`	Unknown	PKFK
`add_to_budget_spent_amount`	Boolean
`currency_code`	String
`fee_type`	String
`fee_value`	String
`fee_value_type`	String
`third_party_provider`	String

ad_group

Column	Type	Keys
`id`	String	PK
`advertiser_id`	String	PKFK
`campaign_id`	String	PKFK
`profile_id`	Unknown	PKFK
`bid_base_bid`	Double
`bid_currency_code`	String
`bid_max_average_cpm`	Double
`budget_amount`	Double
`comment`	String
`creation_date_time`	Instant
`creative_rotation_type`	String
`delivery_status`	String
`digital_out_of_home_product_locations`	Json
`end_date_time`	Instant
`inventory_type`	String
`last_updated_date_time`	Instant
`name`	String
`optimization_automate_budget_allocation`	Boolean
`optimization_bid_strategy`	String
`optimization_daily_min_spend_amount`	Double
`pacing_catch_up_boost_percentage`	Int
`pacing_delivery_profile`	String
`purchase_order_number`	String
`start_date_time`	Instant
`state`	String
`targeting_settings_amazon_viewability_include_unmeasurable_impressions`	Boolean
`targeting_settings_amazon_viewability_viewability_tier`	String
`targeting_settings_automated_targeting_tactic`	String
`targeting_settings_default_audience_targeting_match_type`	String
`targeting_settings_enable_language_targeting`	Boolean
`targeting_settings_site_language`	String
`targeting_settings_tactics_converters_exclusion_type`	String
`targeting_settings_targeted_pg_deal_id`	String
`targeting_settings_time_zone_type`	String
`targeting_settings_user_location`	String
`targeting_settings_user_location_signal`	String
`targeting_settings_video_completion_tier`	String

advertiser

Column	Type	Keys
`id`	Unknown	PK
`profile_id`	Unknown	FK
`country`	Unknown
`currency`	Unknown
`name`	Unknown
`timezone`	Unknown
`url`	Unknown

campaign_list_budget_cap

Column	Type	Keys
`index`	Int	PK
`advertiser_id`	String	PKFK
`campaign_list_id`	String	PKFK
`profile_id`	Unknown	PKFK
`amount`	Double
`currency_code`	String
`recurrence_time_period`	String

campaign_list_flight

Column	Type	Keys
`index`	Int	PK
`advertiser_id`	String	PKFK
`campaign_list_id`	String	PKFK
`profile_id`	Unknown	PKFK
`budget_amount`	Double
`currency_code`	String
`end_date_time`	Instant
`flight_id`	String
`start_date_time`	Instant

campaign_list_frequency

Column	Type	Keys
`index`	Int	PK
`advertiser_id`	String	PKFK
`campaign_list_id`	String	PKFK
`profile_id`	Unknown	PKFK
`frequency_type`	String
`level_type`	String
`max_impressions`	Int
`time_unit`	String
`time_unit_count`	Int

campaign_list

Column	Type	Keys
`id`	String	PK
`advertiser_id`	String	PKFK
`profile_id`	Unknown	PKFK
`skan_app_id`	String	FK
`agency_fee_percentage`	Double
`comment`	String
`creation_date_time`	Instant
`delivery_status`	String
`end_date_time`	Instant
`last_updated_date_time`	Instant
`name`	String
`optimization_automate_bid_allocation`	Boolean
`optimization_automate_budget_allocation`	Boolean
`optimization_automated_adgroup_creation_setting_performance_plus_inventory_type`	Json
`optimization_bid_strategy`	String
`optimization_flight_budget_rollover_setting_rollover_strategy`	String
`optimization_goal_setting_currency_code`	String
`optimization_goal_setting_goal`	String
`optimization_goal_setting_kpi`	String
`optimization_goal_setting_target_kpi`	Double
`optimization_primary_inventory_type`	Json
`purchase_order_number`	String
`start_date_time`	Instant
`state`	String
`target_amazon_deal`	Boolean

inventory_source_exchange

Column	Type	Keys
`id`	String	PK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`country`	Json
`device_type`	String
`inventory_source_type`	String
`inventory_type`	String
`mobile_environment`	Json
`name`	String

measurement_creative_testing_study_status_reason

Column	Type	Keys
`index`	Unknown	PK
`measurement_creative_testing_study_id`	Unknown	PKFK
`status_reason`	Unknown

measurement_creative_testing_study_asset

Column	Type	Keys
`asset_id`	Unknown	PK
`measurement_creative_testing_study_id`	Unknown	PKFK
`asset_type`	Unknown
`version`	Unknown

measurement_creative_testing_study

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	FK
`brand_name`	Unknown
`comment`	Unknown
`create_date`	Unknown
`end_date`	Unknown
`external_reference_id`	Unknown
`last_updated_date`	Unknown
`name`	Unknown
`product_category`	Unknown
`review_date`	Unknown
`start_date`	Unknown
`status`	Unknown
`study_result_status`	Unknown
`survey_id`	Unknown
`vendor_product_id`	Unknown

ad_creative_format_property_ad_copy

Column	Type	Keys
`index`	Unknown	PK
`ad_creative_id`	String	PKFK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`type`	String
`value`	String

ad_creative_format_property_asset

Column	Type	Keys
`index`	Unknown	PK
`ad_creative_id`	String	PKFK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`apply_border`	Boolean
`associated_ad_experience`	String
`id`	String
`url`	String
`version`	String

ad_creative_format_property_click_action

Column	Type	Keys
`index`	Unknown	PK
`ad_creative_id`	String	PKFK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`associated_ad_experience`	String
`enable_deep_linking`	Boolean
`type`	String
`url_destination`	String

ad_creative_format_property_creative_size

Column	Type	Keys
`index`	Unknown	PK
`ad_creative_id`	String	PKFK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`height`	Int
`responsive`	Boolean
`width`	Int

ad_creative_format_property_product

Column	Type	Keys
`index`	Unknown	PK
`ad_creative_id`	String	PKFK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`id`	String
`review_text`	String
`review_url`	String
`title`	String
`type`	String

ad_creative_format_property_tracking_url

Column	Type	Keys
`index`	Unknown	PK
`ad_creative_id`	String	PKFK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`associated_ad_experience`	String
`type`	String
`url`	String

ad_creative

Column	Type	Keys
`id`	String	PK
`advertiser_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`accessibility_text`	String
`ad_choice_position`	String
`additional_html`	String
`attribute`	Json
`auto_localization_state`	String
`category`	Json
`country`	String
`created_date_time`	Instant
`external_id`	String
`format_properties_ad_creative_format_type`	String
`format_properties_additional_attribute_allow_third_party_seller`	Boolean
`format_properties_additional_attribute_allowed_retail_format`	Json
`format_properties_additional_attribute_creative_content_type`	String
`format_properties_additional_attribute_optimization_goal`	String
`format_properties_additional_attribute_render_optimization`	Json
`format_properties_additional_attribute_target_placement`	Json
`format_properties_skippability_setting_skippable_type`	String
`format_properties_third_party_tag_destination_on_amazon`	String
`format_properties_third_party_tag_source`	String
`format_properties_third_party_tag_type`	String
`hosted_type`	String
`languages`	String
`last_updated_date_time`	Instant
`name`	String

survey_question_qualifying_response

Column	Type	Keys
`index`	Unknown	PK
`measurement_survey_question_template_id`	Unknown	PKFK
`qualifying_response`	Unknown

survey_question_response

Column	Type	Keys
`index`	Unknown	PK
`measurement_survey_question_template_id`	Unknown	PKFK
`question_response`	Unknown

placeholder_candidate_allowed_value

Column	Type	Keys
`index`	Unknown	PK
`measurement_survey_question_template_id`	Unknown
`parent_field`	Unknown
`parent_value`	Unknown
`survey_question_placeholder_candidate_index`	Unknown
`value`	Unknown

placeholder_candidate_allowed_value_range

Column	Type	Keys
`index`	Unknown	PK
`measurement_survey_question_template_id`	Unknown	PKFK
`survey_question_placeholder_candidate_index`	Unknown	PKFK
`maximum_value`	Unknown
`minimum_value`	Unknown
`parent_field`	Unknown
`parent_value`	Unknown

placeholder_candidate_inferred_field

Column	Type	Keys
`index`	Unknown	PK
`measurement_survey_question_template_id`	Unknown	PKFK
`survey_question_placeholder_candidate_index`	Unknown	PKFK
`inferred_field`	Unknown

placeholder_candidate_default_value

Column	Type	Keys
`index`	Unknown	PK
`measurement_survey_question_template_id`	Unknown	PKFK
`survey_question_placeholder_candidate_index`	Unknown	PKFK
`default_value`	Unknown

survey_question_placeholder_candidate

Column	Type	Keys
`index`	Unknown	PK
`measurement_survey_question_template_id`	Unknown	PKFK
`allow_custom_value`	Unknown
`field_name`	Unknown
`maximum_value_length`	Unknown
`minimum_value_length`	Unknown
`value_type`	Unknown

measurement_survey_question_template

Column	Type	Keys
`id`	Unknown	PK
`profile_id`	Unknown	FK
`category`	Unknown
`locale`	Unknown
`maximum_qualifying_responses`	Unknown
`maximum_question_responses`	Unknown
`minimum_qualifying_responses`	Unknown
`minimum_question_responses`	Unknown
`objective_type`	Unknown
`priority`	Unknown
`question_text`	Unknown
`sub_category`	Unknown
`type`	Unknown
`vendor_product_id`	Unknown

campaign_conversion_tracking_product

Column	Type	Keys
`product_id`	String	PK
`advertiser_id`	String	PKFK
`campaign_list_id`	String	PKFK
`profile_id`	Unknown	PKFK
`domain`	String
`product_association`	String

audio_and_video

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Unknown	FK
`line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`profile_id`	Unknown	FK
`advertiser_id`	Unknown
`advertiser_name`	Unknown
`content_genre`	Unknown
`content_rating`	Unknown
`cost_per_thousand_impressions`	Unknown
`creative_name`	Unknown
`gross_impressions`	Unknown
`impressions`	Unknown
`interval_end`	Unknown
`interval_start`	Unknown
`invalid_impressions`	Unknown
`line_item_name`	Unknown
`order_name`	Unknown
`supply_source`	Unknown
`supply_source_id`	Unknown

tech

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`profile_id`	Unknown	FK
`add_to_cart`	Unknown
`add_to_cart_clicks`	Unknown
`add_to_cart_views`	Unknown
`add_to_list`	Unknown
`add_to_list_clicks`	Unknown
`add_to_list_views`	Unknown
`add_to_shopping_cart`	Unknown
`add_to_shopping_cart_clicks`	Unknown
`add_to_shopping_cart_value_average`	Unknown
`add_to_shopping_cart_value_sum`	Unknown
`add_to_shopping_cart_views`	Unknown
`add_to_watchlist`	Unknown
`add_to_watchlist_clicks`	Unknown
`add_to_watchlist_views`	Unknown
`advertiser_id`	Unknown
`application`	Unknown
`application_clicks`	Unknown
`application_value_average`	Unknown
`application_value_sum`	Unknown
`application_views`	Unknown
`audio_ad_companion_banner_clicks`	Unknown
`audio_ad_companion_banner_views`	Unknown
`audio_ad_completion_rate`	Unknown
`audio_ad_completions`	Unknown
`audio_ad_first_quartile`	Unknown
`audio_ad_midpoint`	Unknown
`audio_ad_mute`	Unknown
`audio_ad_pause`	Unknown
`audio_ad_progression`	Unknown
`audio_ad_resume`	Unknown
`audio_ad_rewind`	Unknown
`audio_ad_skip`	Unknown
`audio_ad_start`	Unknown
`audio_ad_third_quartile`	Unknown
`audio_ad_unmute`	Unknown
`audio_ad_views`	Unknown
`brand_search_rate`	Unknown
`brand_searches`	Unknown
`brand_searches_clicks`	Unknown
`brand_searches_views`	Unknown
`browser_name`	Unknown
`browser_version`	Unknown
`checkout`	Unknown
`checkout_clicks`	Unknown
`checkout_value_average`	Unknown
`checkout_value_sum`	Unknown
`checkout_views`	Unknown
`click_through_rate`	Unknown
`click_to_apply`	Unknown
`click_to_apply_clicks`	Unknown
`click_to_apply_views`	Unknown
`clicks`	Unknown
`contact`	Unknown
`contact_clicks`	Unknown
`contact_value_average`	Unknown
`contact_value_sum`	Unknown
`contact_views`	Unknown
`detail_page_view_clicks`	Unknown
`detail_page_view_views`	Unknown
`detail_page_views`	Unknown
`device_name`	Unknown
`downloaded_video_plays`	Unknown
`downloaded_video_plays_clicks`	Unknown
`downloaded_video_plays_views`	Unknown
`e_cpc`	Unknown
`e_cpm`	Unknown
`ecp_audio_ad_completion`	Unknown
`ecp_brand_search`	Unknown
`ecp_skill_invocation`	Unknown
`environment_name`	Unknown
`free_trial_subscription_signup_clicks`	Unknown
`free_trial_subscription_signup_views`	Unknown
`free_trial_subscription_signups`	Unknown
`impressions`	Unknown
`interactive_impressions`	Unknown
`interval_end`	Unknown
`interval_start`	Unknown
`kindle_detail_page_view`	Unknown
`kindle_detail_page_view_clicks`	Unknown
`kindle_detail_page_view_views`	Unknown
`lead`	Unknown
`lead_clicks`	Unknown
`lead_value_average`	Unknown
`lead_value_sum`	Unknown
`lead_views`	Unknown
`line_item_comments`	Unknown
`line_item_name`	Unknown
`mobile_app_first_start_average`	Unknown
`mobile_app_first_start_clicks`	Unknown
`mobile_app_first_start_sum`	Unknown
`mobile_app_first_start_views`	Unknown
`mobile_app_first_starts`	Unknown
`new_subscribe_and_save`	Unknown
`new_subscribe_and_save_clicks`	Unknown
`new_subscribe_and_save_views`	Unknown
`new_to_brand_detail_page_view_clicks`	Unknown
`new_to_brand_detail_page_view_rate`	Unknown
`new_to_brand_detail_page_view_views`	Unknown
`new_to_brand_detail_page_views`	Unknown
`new_to_brand_ecp_detail_page_view`	Unknown
`new_to_brand_purchases`	Unknown
`new_to_brand_purchases_clicks`	Unknown
`new_to_brand_purchases_views`	Unknown
`notification_clicks`	Unknown
`notification_opens`	Unknown
`off_amazon_clicks`	Unknown
`off_amazon_purchases_clicks`	Unknown
`off_amazon_purchases_views`	Unknown
`off_amazon_views`	Unknown
`oms_line_item_id`	Unknown
`operating_system_name`	Unknown
`order_currency`	Unknown
`order_name`	Unknown
`other`	Unknown
`other_clicks`	Unknown
`other_value_average`	Unknown
`other_value_sum`	Unknown
`other_views`	Unknown
`page_view_clicks`	Unknown
`page_view_value_average`	Unknown
`page_view_value_sum`	Unknown
`page_view_views`	Unknown
`page_views`	Unknown
`paid_subscription_signup_clicks`	Unknown
`paid_subscription_signup_views`	Unknown
`paid_subscription_signups`	Unknown
`play_trailers`	Unknown
`play_trailers_clicks`	Unknown
`play_trailers_views`	Unknown
`product_review_page_visits`	Unknown
`product_review_page_visits_clicks`	Unknown
`product_review_page_visits_views`	Unknown
`purchases`	Unknown
`purchases_clicks`	Unknown
`purchases_views`	Unknown
`rentals`	Unknown
`rentals_clicks`	Unknown
`rentals_views`	Unknown
`search`	Unknown
`search_clicks`	Unknown
`search_value_average`	Unknown
`search_value_sum`	Unknown
`search_views`	Unknown
`sign_up_value_average`	Unknown
`sign_up_value_sum`	Unknown
`sign_up_views`	Unknown
`skill_invocation`	Unknown
`skill_invocation_clicks`	Unknown
`skill_invocation_rate`	Unknown
`skill_invocation_views`	Unknown
`subscribe`	Unknown
`subscribe_clicks`	Unknown
`subscribe_value_average`	Unknown
`subscribe_value_sum`	Unknown
`subscribe_views`	Unknown
`subscription_signup_clicks`	Unknown
`subscription_signup_views`	Unknown
`subscription_signups`	Unknown
`total_cost`	Unknown
`total_new_to_brand_dpv_clicks`	Unknown
`total_new_to_brand_dpv_rate`	Unknown
`total_new_to_brand_dpv_views`	Unknown
`total_new_to_brand_dpvs`	Unknown
`total_new_to_brand_ecp_detail_page_view`	Unknown
`video_ad_clicks`	Unknown
`video_ad_complete`	Unknown
`video_ad_completion_rate`	Unknown
`video_ad_creative_views`	Unknown
`video_ad_end_state_clicks`	Unknown
`video_ad_first_quartile`	Unknown
`video_ad_impressions`	Unknown
`video_ad_midpoint`	Unknown
`video_ad_mute`	Unknown
`video_ad_pause`	Unknown
`video_ad_replays`	Unknown
`video_ad_resume`	Unknown
`video_ad_skip_backs`	Unknown
`video_ad_skip_forwards`	Unknown
`video_ad_start`	Unknown
`video_ad_third_quartile`	Unknown
`video_ad_unmute`	Unknown
`video_downloads`	Unknown
`video_downloads_clicks`	Unknown
`video_downloads_views`	Unknown
`video_streams`	Unknown
`video_streams_clicks`	Unknown
`video_streams_views`	Unknown

reach_and_frequency

Column	Type	Keys
`_fivetran_id`	String	PK
`profile_id`	Unknown	FK
`advertiser_id`	Unknown
`date`	Unknown
`frequency_average`	Unknown
`frequency_group_id`	Unknown
`frequency_group_name`	Unknown
`interval_end`	Unknown
`interval_start`	Unknown
`reach`	Unknown

audience

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`profile_id`	Unknown	FK
`add_to_cart`	Unknown
`add_to_cart_clicks`	Unknown
`add_to_cart_rate`	Unknown
`add_to_cart_views`	Unknown
`add_to_list`	Unknown
`add_to_list_clicks`	Unknown
`add_to_list_rate`	Unknown
`add_to_list_views`	Unknown
`add_to_shopping_cart`	Unknown
`add_to_shopping_cart_clicks`	Unknown
`add_to_shopping_cart_cpa`	Unknown
`add_to_shopping_cart_cvr`	Unknown
`add_to_shopping_cart_value_average`	Unknown
`add_to_shopping_cart_value_sum`	Unknown
`add_to_shopping_cart_views`	Unknown
`add_to_watchlist`	Unknown
`add_to_watchlist_clicks`	Unknown
`add_to_watchlist_rate`	Unknown
`add_to_watchlist_views`	Unknown
`advertiser_id`	Unknown
`amazon_dsp_audience_fee`	Unknown
`amazon_dsp_console_fee`	Unknown
`application`	Unknown
`application_clicks`	Unknown
`application_cpa`	Unknown
`application_cvr`	Unknown
`application_value_average`	Unknown
`application_value_sum`	Unknown
`application_views`	Unknown
`audio_ad_companion_banner_clicks`	Unknown
`audio_ad_companion_banner_views`	Unknown
`audio_ad_completion_rate`	Unknown
`audio_ad_completions`	Unknown
`audio_ad_first_quartile`	Unknown
`audio_ad_midpoint`	Unknown
`audio_ad_mute`	Unknown
`audio_ad_pause`	Unknown
`audio_ad_progression`	Unknown
`audio_ad_resume`	Unknown
`audio_ad_rewind`	Unknown
`audio_ad_skip`	Unknown
`audio_ad_start`	Unknown
`audio_ad_third_quartile`	Unknown
`audio_ad_unmute`	Unknown
`audio_ad_views`	Unknown
`average_cost_per_click_to_apply`	Unknown
`average_cost_per_kindle_detail_page_view`	Unknown
`brand_search_rate`	Unknown
`brand_searches`	Unknown
`brand_searches_clicks`	Unknown
`brand_searches_views`	Unknown
`checkout`	Unknown
`checkout_clicks`	Unknown
`checkout_cpa`	Unknown
`checkout_cvr`	Unknown
`checkout_value_average`	Unknown
`checkout_value_sum`	Unknown
`checkout_views`	Unknown
`click_through_rate`	Unknown
`click_to_apply`	Unknown
`click_to_apply_clicks`	Unknown
`click_to_apply_conversion_rate`	Unknown
`click_to_apply_views`	Unknown
`clicks`	Unknown
`contact`	Unknown
`contact_clicks`	Unknown
`contact_cpa`	Unknown
`contact_cvr`	Unknown
`contact_value_average`	Unknown
`contact_value_sum`	Unknown
`contact_views`	Unknown
`detail_page_view_clicks`	Unknown
`detail_page_view_rate`	Unknown
`detail_page_view_rate_promoted_clicks`	Unknown
`detail_page_view_views`	Unknown
`detail_page_views`	Unknown
`downloaded_video_play_rate`	Unknown
`downloaded_video_plays`	Unknown
`downloaded_video_plays_clicks`	Unknown
`downloaded_video_plays_views`	Unknown
`ecp_add_to_cart`	Unknown
`ecp_add_to_list`	Unknown
`ecp_add_to_watchlist`	Unknown
`ecp_audio_ad_completion`	Unknown
`ecp_brand_search`	Unknown
`ecp_detail_page_view`	Unknown
`ecp_downloaded_video_plays`	Unknown
`ecp_free_trial_subscription_signup`	Unknown
`ecp_new_subscribe_and_save`	Unknown
`ecp_paid_subscription_signup`	Unknown
`ecp_play_trailer`	Unknown
`ecp_product_review_page_visit`	Unknown
`ecp_rental`	Unknown
`ecp_subscription_signup`	Unknown
`ecp_video_ad_completion`	Unknown
`ecp_video_download`	Unknown
`ecp_video_stream`	Unknown
`ecpc`	Unknown
`ecpm`	Unknown
`ecpp`	Unknown
`effective_cost_per_detail_page_view_promoted_clicks`	Unknown
`effective_cost_per_purchase_promoted_clicks`	Unknown
`effective_cost_per_skill_invocation`	Unknown
`free_trial_subscription_signup_clicks`	Unknown
`free_trial_subscription_signup_rate`	Unknown
`free_trial_subscription_signup_views`	Unknown
`free_trial_subscription_signups`	Unknown
`impressions`	Unknown
`interactive_impressions`	Unknown
`interval_end`	Unknown
`interval_start`	Unknown
`kindle_detail_page_view`	Unknown
`kindle_detail_page_view_clicks`	Unknown
`kindle_detail_page_view_rate`	Unknown
`kindle_detail_page_view_views`	Unknown
`lead`	Unknown
`lead_clicks`	Unknown
`lead_cpa`	Unknown
`lead_cvr`	Unknown
`lead_value_average`	Unknown
`lead_value_sum`	Unknown
`lead_views`	Unknown
`line_item_comments`	Unknown
`line_item_name`	Unknown
`line_item_type`	Unknown
`master_clicks`	Unknown
`master_impressions`	Unknown
`mobile_app_first_start_clicks`	Unknown
`mobile_app_first_start_cpa`	Unknown
`mobile_app_first_start_cvr`	Unknown
`mobile_app_first_start_views`	Unknown
`mobile_app_first_starts`	Unknown
`new_subscribe_and_save`	Unknown
`new_subscribe_and_save_clicks`	Unknown
`new_subscribe_and_save_rate`	Unknown
`new_subscribe_and_save_views`	Unknown
`new_to_brand_detail_page_view_clicks`	Unknown
`new_to_brand_detail_page_view_rate`	Unknown
`new_to_brand_detail_page_view_views`	Unknown
`new_to_brand_detail_page_views`	Unknown
`new_to_brand_ecp_detail_page_view`	Unknown
`new_to_brand_ecpp`	Unknown
`new_to_brand_purchase_rate`	Unknown
`new_to_brand_purchases`	Unknown
`new_to_brand_purchases_clicks`	Unknown
`new_to_brand_purchases_percentage`	Unknown
`new_to_brand_purchases_views`	Unknown
`notification_clicks`	Unknown
`notification_opens`	Unknown
`off_amazon_clicks`	Unknown
`off_amazon_ecpp`	Unknown
`off_amazon_purchases_clicks`	Unknown
`off_amazon_purchases_views`	Unknown
`off_amazon_views`	Unknown
`oms_line_item_id`	Unknown
`oms_proposal_id`	Unknown
`order_currency`	Unknown
`order_name`	Unknown
`other`	Unknown
`other_clicks`	Unknown
`other_cpa`	Unknown
`other_cvr`	Unknown
`other_value_average`	Unknown
`other_value_sum`	Unknown
`other_views`	Unknown
`page_view_clicks`	Unknown
`page_view_cpa`	Unknown
`page_view_cvr`	Unknown
`page_view_value_average`	Unknown
`page_view_value_sum`	Unknown
`page_view_views`	Unknown
`page_views`	Unknown
`paid_subscription_signup_clicks`	Unknown
`paid_subscription_signup_rate`	Unknown
`paid_subscription_signup_views`	Unknown
`paid_subscription_signups`	Unknown
`play_trailer_rate`	Unknown
`play_trailers`	Unknown
`play_trailers_clicks`	Unknown
`play_trailers_views`	Unknown
`product_review_page_visit_rate`	Unknown
`product_review_page_visits`	Unknown
`product_review_page_visits_clicks`	Unknown
`product_review_page_visits_views`	Unknown
`purchase_rate`	Unknown
`purchases`	Unknown
`purchases_clicks`	Unknown
`purchases_clicks_rate`	Unknown
`purchases_views`	Unknown
`rental_rate`	Unknown
`rentals`	Unknown
`rentals_clicks`	Unknown
`rentals_views`	Unknown
`search`	Unknown
`search_clicks`	Unknown
`search_cpa`	Unknown
`search_cvr`	Unknown
`search_value_average`	Unknown
`search_value_sum`	Unknown
`search_views`	Unknown
`segment_class_code`	Unknown
`segment_id`	Unknown
`segment_marketplace_id`	Unknown
`segment_name`	Unknown
`segment_source`	Unknown
`segment_type`	Unknown
`sign_up_cpa`	Unknown
`sign_up_cvr`	Unknown
`sign_up_value_average`	Unknown
`sign_up_value_sum`	Unknown
`sign_up_views`	Unknown
`skill_invocation`	Unknown
`skill_invocation_clicks`	Unknown
`skill_invocation_rate`	Unknown
`skill_invocation_views`	Unknown
`subscribe`	Unknown
`subscribe_clicks`	Unknown
`subscribe_cpa`	Unknown
`subscribe_cvr`	Unknown
`subscribe_value_average`	Unknown
`subscribe_value_sum`	Unknown
`subscribe_views`	Unknown
`subscription_signup_clicks`	Unknown
`subscription_signup_rate`	Unknown
`subscription_signup_views`	Unknown
`subscription_signups`	Unknown
`supply_cost`	Unknown
`targeting_method`	Unknown
`total_cost`	Unknown
`total_new_to_brand_dpv_clicks`	Unknown
`total_new_to_brand_dpv_rate`	Unknown
`total_new_to_brand_dpv_views`	Unknown
`total_new_to_brand_dpvs`	Unknown
`total_new_to_brand_ecp_detail_page_view`	Unknown
`video_ad_clicks`	Unknown
`video_ad_complete`	Unknown
`video_ad_completion_rate`	Unknown
`video_ad_creative_views`	Unknown
`video_ad_end_state_clicks`	Unknown
`video_ad_first_quartile`	Unknown
`video_ad_impressions`	Unknown
`video_ad_midpoint`	Unknown
`video_ad_mute`	Unknown
`video_ad_pause`	Unknown
`video_ad_replays`	Unknown
`video_ad_resume`	Unknown
`video_ad_skip_backs`	Unknown
`video_ad_skip_forwards`	Unknown
`video_ad_start`	Unknown
`video_ad_third_quartile`	Unknown
`video_ad_unmute`	Unknown
`video_download_rate`	Unknown
`video_downloads`	Unknown
`video_downloads_clicks`	Unknown
`video_downloads_views`	Unknown
`video_streams`	Unknown
`video_streams_clicks`	Unknown
`video_streams_rate`	Unknown
`video_streams_views`	Unknown

campaign

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Unknown	FK
`creative_id`	Unknown	FK
`order_id`	Unknown	FK
`profile_id`	Unknown	FK
`add_to_list_clicks`	Unknown
`add_to_shopping_cart_clicks`	Unknown
`add_to_watchlist_rate`	Unknown
`app_store_first_opens_views`	Unknown
`app_store_opens`	Unknown
`application_clicks`	Unknown
`application_value_average`	Unknown
`audio_ad_companion_banner_views`	Unknown
`audio_ad_completion_rate`	Unknown
`audio_ad_first_quartile`	Unknown
`audio_ad_midpoint`	Unknown
`audio_ad_rewind`	Unknown
`audio_ad_unmute`	Unknown
`checkout_clicks`	Unknown
`checkout_value_average`	Unknown
`checkout_value_sum`	Unknown
`checkout_views`	Unknown
`click_through_rate`	Unknown
`combined_purchases_views`	Unknown
`contact_cvr`	Unknown
`contact_value_average`	Unknown
`creative_ad_id`	Unknown
`date`	Unknown
`detail_page_view_clicks`	Unknown
`detail_page_views`	Unknown
`downloaded_video_plays`	Unknown
`ecp_add_to_cart`	Unknown
`ecp_add_to_list`	Unknown
`ecp_app_store_first_opens`	Unknown
`ecp_paid_subscription_signup`	Unknown
`free_trial_subscription_signup_rate`	Unknown
`gross_click_throughs`	Unknown
`gross_impressions`	Unknown
`household_frequency_average`	Unknown
`impression_frequency_average`	Unknown
`interval_end`	Unknown
`interval_start`	Unknown
`invalid_click_throughs`	Unknown
`invalid_impressions`	Unknown
`lead_cpa`	Unknown
`line_item_external_id`	Unknown
`line_item_id`	Unknown
`measurable_impressions`	Unknown
`mobile_app_first_start_clicks`	Unknown
`mobile_app_first_start_cvr`	Unknown
`mobile_app_first_starts`	Unknown
`new_to_brand_detail_page_view_clicks`	Unknown
`new_to_brand_detail_page_view_rate`	Unknown
`new_to_brand_detail_page_views`	Unknown
`new_to_brand_ecp_detail_page_view`	Unknown
`new_to_brand_erpm`	Unknown
`notification_opens`	Unknown
`off_amazon_cpa`	Unknown
`off_amazon_erpm`	Unknown
`off_amazon_roas`	Unknown
`omnichannel_metrics_fee`	Unknown
`order_budget`	Unknown
`order_name`	Unknown
`other_clicks`	Unknown
`other_cpa`	Unknown
`page_view_cvr`	Unknown
`page_view_value_average`	Unknown
`paid_subscription_signup_clicks`	Unknown
`paid_subscription_signup_views`	Unknown
`play_trailers_clicks`	Unknown
`product_review_page_visits_views`	Unknown
`proposal_id`	Unknown
`rental_rate`	Unknown
`search`	Unknown
`search_cvr`	Unknown
`sign_up_cpa`	Unknown
`skill_invocation_clicks`	Unknown
`skill_invocation_rate`	Unknown
`skill_invocation_views`	Unknown
`subscribe_clicks`	Unknown
`subscribe_cpa`	Unknown
`subscription_signup_rate`	Unknown
`third_party_fee_automotive_absorbed`	Unknown
`third_party_fee_com_score`	Unknown
`third_party_fee_com_score_absorbed`	Unknown
`third_party_fee_cpm_1_absorbed`	Unknown
`third_party_fees`	Unknown
`third_party_pre_bid_fee`	Unknown
`total_add_to_list_views`	Unknown
`total_cost`	Unknown
`total_ecp_add_to_list`	Unknown
`total_ecp_detail_page_view`	Unknown
`total_new_to_brand_ecp_detail_page_view`	Unknown
`total_new_to_brand_purchases_clicks`	Unknown
`total_new_to_brand_purchases_percentage`	Unknown
`total_product_review_page_visits`	Unknown
`total_product_review_page_visits_clicks`	Unknown
`total_purchase_rate`	Unknown
`total_purchases`	Unknown
`total_purchases_clicks`	Unknown
`total_purchases_views`	Unknown
`total_sales`	Unknown
`total_units_sold`	Unknown
`units_sold`	Unknown
`video_ad_complete`	Unknown
`video_ad_completion_rate`	Unknown
`video_ad_first_quartile`	Unknown
`video_ad_midpoint`	Unknown
`video_ad_start`	Unknown
`video_ad_third_quartile`	Unknown
`video_ad_unmute`	Unknown
`video_downloads_clicks`	Unknown
`video_downloads_views`	Unknown
`viewability_rate`	Unknown

inventory

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`profile_id`	Unknown	FK
`add_to_cart`	Unknown
`add_to_cart_clicks`	Unknown
`add_to_cart_rate`	Unknown
`add_to_cart_views`	Unknown
`add_to_list`	Unknown
`add_to_list_clicks`	Unknown
`add_to_list_rate`	Unknown
`add_to_list_views`	Unknown
`add_to_shopping_cart`	Unknown
`add_to_shopping_cart_clicks`	Unknown
`add_to_shopping_cart_cpa`	Unknown
`add_to_shopping_cart_cvr`	Unknown
`add_to_shopping_cart_value_average`	Unknown
`add_to_shopping_cart_value_sum`	Unknown
`add_to_shopping_cart_views`	Unknown
`add_to_watchlist`	Unknown
`add_to_watchlist_clicks`	Unknown
`add_to_watchlist_rate`	Unknown
`add_to_watchlist_views`	Unknown
`advertiser_country`	Unknown
`advertiser_id`	Unknown
`advertiser_timezone`	Unknown
`agency_fee`	Unknown
`amazon_dsp_audience_fee`	Unknown
`amazon_dsp_console_fee`	Unknown
`application`	Unknown
`application_clicks`	Unknown
`application_cpa`	Unknown
`application_cvr`	Unknown
`application_value_average`	Unknown
`application_value_sum`	Unknown
`application_views`	Unknown
`audio_ad_companion_banner_clicks`	Unknown
`audio_ad_companion_banner_views`	Unknown
`audio_ad_completion_rate`	Unknown
`audio_ad_completions`	Unknown
`audio_ad_first_quartile`	Unknown
`audio_ad_midpoint`	Unknown
`audio_ad_mute`	Unknown
`audio_ad_pause`	Unknown
`audio_ad_progression`	Unknown
`audio_ad_resume`	Unknown
`audio_ad_rewind`	Unknown
`audio_ad_skip`	Unknown
`audio_ad_start`	Unknown
`audio_ad_third_quartile`	Unknown
`audio_ad_unmute`	Unknown
`audio_ad_views`	Unknown
`brand_search_rate`	Unknown
`brand_searches`	Unknown
`brand_searches_clicks`	Unknown
`brand_searches_views`	Unknown
`checkout`	Unknown
`checkout_clicks`	Unknown
`checkout_cpa`	Unknown
`checkout_cvr`	Unknown
`checkout_value_average`	Unknown
`checkout_value_sum`	Unknown
`checkout_views`	Unknown
`click_through_rate`	Unknown
`clicks`	Unknown
`combined_ecpp`	Unknown
`combined_erp_m`	Unknown
`combined_product_sales`	Unknown
`combined_purchase_rate`	Unknown
`combined_purchases`	Unknown
`combined_purchases_clicks`	Unknown
`combined_purchases_views`	Unknown
`combined_roas`	Unknown
`combined_units_sold`	Unknown
`contact`	Unknown
`contact_clicks`	Unknown
`contact_cpa`	Unknown
`contact_cvr`	Unknown
`contact_value_average`	Unknown
`contact_value_sum`	Unknown
`contact_views`	Unknown
`creative_id`	Unknown
`creative_type`	Unknown
`deal_id`	Unknown
`detail_page_view_clicks`	Unknown
`detail_page_view_rate`	Unknown
`detail_page_view_views`	Unknown
`detail_page_views`	Unknown
`downloaded_video_play_rate`	Unknown
`downloaded_video_plays`	Unknown
`downloaded_video_plays_clicks`	Unknown
`downloaded_video_plays_views`	Unknown
`ecp_add_to_cart`	Unknown
`ecp_add_to_list`	Unknown
`ecp_add_to_watchlist`	Unknown
`ecp_audio_ad_completion`	Unknown
`ecp_brand_search`	Unknown
`ecp_detail_page_view`	Unknown
`ecp_downloaded_video_plays`	Unknown
`ecp_free_trial_subscription_signup`	Unknown
`ecp_new_subscribe_and_save`	Unknown
`ecp_paid_subscription_signup`	Unknown
`ecp_play_trailer`	Unknown
`ecp_product_review_page_visit`	Unknown
`ecp_rental`	Unknown
`ecp_skill_invocation`	Unknown
`ecp_subscription_signup`	Unknown
`ecp_video_ad_completion`	Unknown
`ecp_video_download`	Unknown
`ecp_video_stream`	Unknown
`ecpc`	Unknown
`ecpm`	Unknown
`ecpp`	Unknown
`entity_id`	Unknown
`erp_m`	Unknown
`free_trial_subscription_signup_clicks`	Unknown
`free_trial_subscription_signup_rate`	Unknown
`free_trial_subscription_signup_views`	Unknown
`free_trial_subscription_signups`	Unknown
`gross_click_throughs`	Unknown
`gross_impressions`	Unknown
`impressions`	Unknown
`interactive_impressions`	Unknown
`interval_end`	Unknown
`interval_start`	Unknown
`invalid_click_through_rate`	Unknown
`invalid_click_throughs`	Unknown
`invalid_impression_rate`	Unknown
`invalid_impressions`	Unknown
`lead`	Unknown
`lead_clicks`	Unknown
`lead_cpa`	Unknown
`lead_cvr`	Unknown
`lead_value_average`	Unknown
`lead_value_sum`	Unknown
`lead_views`	Unknown
`line_item_external_id`	Unknown
`marketplace`	Unknown
`measurable_impressions`	Unknown
`measurable_rate`	Unknown
`mobile_app_first_start_clicks`	Unknown
`mobile_app_first_start_cpa`	Unknown
`mobile_app_first_start_cvr`	Unknown
`mobile_app_first_start_views`	Unknown
`mobile_app_first_starts`	Unknown
`new_subscribe_and_save`	Unknown
`new_subscribe_and_save_clicks`	Unknown
`new_subscribe_and_save_rate`	Unknown
`new_subscribe_and_save_views`	Unknown
`new_to_brand_detail_page_view_clicks`	Unknown
`new_to_brand_detail_page_view_rate`	Unknown
`new_to_brand_detail_page_view_views`	Unknown
`new_to_brand_detail_page_views`	Unknown
`new_to_brand_ecp_detail_page_view`	Unknown
`new_to_brand_ecpp`	Unknown
`new_to_brand_erp_m`	Unknown
`new_to_brand_product_sales`	Unknown
`new_to_brand_purchase_rate`	Unknown
`new_to_brand_purchases`	Unknown
`new_to_brand_purchases_clicks`	Unknown
`new_to_brand_purchases_views`	Unknown
`new_to_brand_roas`	Unknown
`new_to_brand_units_sold`	Unknown
`notification_clicks`	Unknown
`notification_opens`	Unknown
`off_amazon_clicks`	Unknown
`off_amazon_conversions`	Unknown
`off_amazon_cpa`	Unknown
`off_amazon_cvr`	Unknown
`off_amazon_ecpp`	Unknown
`off_amazon_erp_m`	Unknown
`off_amazon_product_sales`	Unknown
`off_amazon_purchase_rate`	Unknown
`off_amazon_purchases`	Unknown
`off_amazon_purchases_clicks`	Unknown
`off_amazon_purchases_views`	Unknown
`off_amazon_roas`	Unknown
`off_amazon_units_sold`	Unknown
`off_amazon_views`	Unknown
`order_external_id`	Unknown
`other`	Unknown
`other_clicks`	Unknown
`other_cpa`	Unknown
`other_cvr`	Unknown
`other_value_average`	Unknown
`other_value_sum`	Unknown
`other_views`	Unknown
`page_view_clicks`	Unknown
`page_view_cpa`	Unknown
`page_view_cvr`	Unknown
`page_view_value_average`	Unknown
`page_view_value_sum`	Unknown
`page_view_views`	Unknown
`page_views`	Unknown
`paid_subscription_signup_clicks`	Unknown
`paid_subscription_signup_rate`	Unknown
`paid_subscription_signup_views`	Unknown
`paid_subscription_signups`	Unknown
`placement`	Unknown
`play_trailer_rate`	Unknown
`play_trailers`	Unknown
`play_trailers_clicks`	Unknown
`play_trailers_views`	Unknown
`product_review_page_visit_rate`	Unknown
`product_review_page_visits`	Unknown
`product_review_page_visits_clicks`	Unknown
`product_review_page_visits_views`	Unknown
`purchase_rate`	Unknown
`purchases`	Unknown
`purchases_clicks`	Unknown
`purchases_views`	Unknown
`rental_rate`	Unknown
`rentals`	Unknown
`rentals_clicks`	Unknown
`rentals_views`	Unknown
`roas`	Unknown
`sales`	Unknown
`search`	Unknown
`search_clicks`	Unknown
`search_cpa`	Unknown
`search_cvr`	Unknown
`search_value_average`	Unknown
`search_value_sum`	Unknown
`search_views`	Unknown
`sign_up_cpa`	Unknown
`sign_up_cvr`	Unknown
`sign_up_value_average`	Unknown
`sign_up_value_sum`	Unknown
`sign_up_views`	Unknown
`site`	Unknown
`skill_invocation`	Unknown
`skill_invocation_clicks`	Unknown
`skill_invocation_rate`	Unknown
`skill_invocation_views`	Unknown
`subscribe`	Unknown
`subscribe_clicks`	Unknown
`subscribe_cpa`	Unknown
`subscribe_cvr`	Unknown
`subscribe_value_average`	Unknown
`subscribe_value_sum`	Unknown
`subscribe_views`	Unknown
`subscription_signup_clicks`	Unknown
`subscription_signup_rate`	Unknown
`subscription_signup_views`	Unknown
`subscription_signups`	Unknown
`supply_cost`	Unknown
`supply_source`	Unknown
`three_p_fee_automotive`	Unknown
`three_p_fee_automotive_absorbed`	Unknown
`three_p_fee_com_score`	Unknown
`three_p_fee_com_score_absorbed`	Unknown
`three_p_fee_cpm_1`	Unknown
`three_p_fee_cpm_1_absorbed`	Unknown
`three_p_fee_cpm_2`	Unknown
`three_p_fee_cpm_2_absorbed`	Unknown
`three_p_fee_cpm_3`	Unknown
`three_p_fee_cpm_3_absorbed`	Unknown
`three_p_fee_double_verify`	Unknown
`three_p_fee_double_verify_absorbed`	Unknown
`three_p_fee_doubleclick_campaign_manager`	Unknown
`three_p_fee_doubleclick_campaign_manager_absorbed`	Unknown
`three_p_fee_integral_ad_science`	Unknown
`three_p_fee_integral_ad_science_absorbed`	Unknown
`three_p_fees`	Unknown
`total_add_to_cart`	Unknown
`total_add_to_cart_clicks`	Unknown
`total_add_to_cart_rate`	Unknown
`total_add_to_cart_views`	Unknown
`total_add_to_list`	Unknown
`total_add_to_list_clicks`	Unknown
`total_add_to_list_rate`	Unknown
`total_add_to_list_views`	Unknown
`total_cost`	Unknown
`total_detail_page_view`	Unknown
`total_detail_page_view_clicks`	Unknown
`total_detail_page_view_rate`	Unknown
`total_detail_page_view_views`	Unknown
`total_ecp_add_to_cart`	Unknown
`total_ecp_add_to_list`	Unknown
`total_ecp_detail_page_view`	Unknown
`total_ecp_product_review_page_visit`	Unknown
`total_ecp_subscribe_and_save`	Unknown
`total_ecpp`	Unknown
`total_erp_m`	Unknown
`total_fee`	Unknown
`total_new_to_brand_dp_vs`	Unknown
`total_new_to_brand_dpv_clicks`	Unknown
`total_new_to_brand_dpv_rate`	Unknown
`total_new_to_brand_dpv_views`	Unknown
`total_new_to_brand_ecp_detail_page_view`	Unknown
`total_new_to_brand_ecpp`	Unknown
`total_new_to_brand_erp_m`	Unknown
`total_new_to_brand_purchase_rate`	Unknown
`total_new_to_brand_purchases`	Unknown
`total_new_to_brand_purchases_clicks`	Unknown
`total_new_to_brand_purchases_views`	Unknown
`total_new_to_brand_roas`	Unknown
`total_new_to_brand_sales`	Unknown
`total_new_to_brand_units_sold`	Unknown
`total_product_review_page_visit_rate`	Unknown
`total_product_review_page_visits`	Unknown
`total_product_review_page_visits_clicks`	Unknown
`total_product_review_page_visits_views`	Unknown
`total_purchase_rate`	Unknown
`total_purchases`	Unknown
`total_purchases_clicks`	Unknown
`total_purchases_views`	Unknown
`total_roas`	Unknown
`total_sales`	Unknown
`total_subscribe_and_save`	Unknown
`total_subscribe_and_save_clicks`	Unknown
`total_subscribe_and_save_rate`	Unknown
`total_subscribe_and_save_views`	Unknown
`total_units_sold`	Unknown
`units_sold`	Unknown
`video_ad_clicks`	Unknown
`video_ad_complete`	Unknown
`video_ad_completion_rate`	Unknown
`video_ad_creative_views`	Unknown
`video_ad_end_state_clicks`	Unknown
`video_ad_first_quartile`	Unknown
`video_ad_impressions`	Unknown
`video_ad_midpoint`	Unknown
`video_ad_mute`	Unknown
`video_ad_pause`	Unknown
`video_ad_replays`	Unknown
`video_ad_resume`	Unknown
`video_ad_skip_backs`	Unknown
`video_ad_skip_forwards`	Unknown
`video_ad_start`	Unknown
`video_ad_third_quartile`	Unknown
`video_ad_unmute`	Unknown
`video_download_rate`	Unknown
`video_downloads`	Unknown
`video_downloads_clicks`	Unknown
`video_downloads_views`	Unknown
`video_streams`	Unknown
`video_streams_clicks`	Unknown
`video_streams_rate`	Unknown
`video_streams_views`	Unknown
`viewability_rate`	Unknown
`viewable_impressions`	Unknown

bid_adjustment

Column	Type	Keys
`_fivetran_id`	String	PK
`profile_id`	Unknown	FK
`advertiser_id`	Unknown
`bid_adjustment`	Unknown
`bid_adjustment_matched_term`	Unknown
`bid_adjustment_matched_term_id`	Unknown
`bid_adjustment_rule`	Unknown
`bid_adjustment_rule_id`	Unknown
`bid_adjustment_rule_version_id`	Unknown
`bids`	Unknown
`date`	Unknown
`line_item_id`	Unknown
`line_item_name`	Unknown
`match_rate`	Unknown
`order_id`	Unknown
`win_rate`	Unknown

geo

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`profile_id`	Unknown	FK
`add_to_cart`	Unknown
`add_to_cart_clicks`	Unknown
`add_to_cart_views`	Unknown
`add_to_list`	Unknown
`add_to_list_clicks`	Unknown
`add_to_list_views`	Unknown
`add_to_shopping_cart`	Unknown
`add_to_shopping_cart_clicks`	Unknown
`add_to_shopping_cart_value_average`	Unknown
`add_to_shopping_cart_value_sum`	Unknown
`add_to_shopping_cart_views`	Unknown
`add_to_watchlist`	Unknown
`add_to_watchlist_clicks`	Unknown
`add_to_watchlist_views`	Unknown
`advertiser_id`	Unknown
`agency_fee`	Unknown
`app_subscription_cost`	Unknown
`app_subscription_free_trial_cost`	Unknown
`app_subscription_sign_up`	Unknown
`app_subscription_sign_up_clicks`	Unknown
`app_subscription_sign_up_free_trial`	Unknown
`app_subscription_sign_up_free_trial_clicks`	Unknown
`app_subscription_sign_up_free_trial_rate`	Unknown
`app_subscription_sign_up_free_trial_views`	Unknown
`app_subscription_sign_up_paid`	Unknown
`app_subscription_sign_up_paid_clicks`	Unknown
`app_subscription_sign_up_paid_cost`	Unknown
`app_subscription_sign_up_paid_rate`	Unknown
`app_subscription_sign_up_paid_views`	Unknown
`app_subscription_sign_up_rate`	Unknown
`app_subscription_sign_up_views`	Unknown
`application`	Unknown
`application_clicks`	Unknown
`application_value_average`	Unknown
`application_value_sum`	Unknown
`application_views`	Unknown
`audio_ad_companion_banner_clicks`	Unknown
`audio_ad_companion_banner_views`	Unknown
`audio_ad_completion_rate`	Unknown
`audio_ad_completions`	Unknown
`audio_ad_first_quartile`	Unknown
`audio_ad_midpoint`	Unknown
`audio_ad_mute`	Unknown
`audio_ad_pause`	Unknown
`audio_ad_progression`	Unknown
`audio_ad_resume`	Unknown
`audio_ad_rewind`	Unknown
`audio_ad_skip`	Unknown
`audio_ad_start`	Unknown
`audio_ad_third_quartile`	Unknown
`audio_ad_unmute`	Unknown
`audio_ad_views`	Unknown
`brand_search_rate`	Unknown
`brand_searches`	Unknown
`brand_searches_clicks`	Unknown
`brand_searches_views`	Unknown
`checkout`	Unknown
`checkout_clicks`	Unknown
`checkout_value_average`	Unknown
`checkout_value_sum`	Unknown
`checkout_views`	Unknown
`city`	Unknown
`click_through_rate`	Unknown
`click_to_apply`	Unknown
`click_to_apply_clicks`	Unknown
`click_to_apply_views`	Unknown
`clicks`	Unknown
`combined_product_sales`	Unknown
`combined_purchases`	Unknown
`combined_purchases_clicks`	Unknown
`combined_purchases_views`	Unknown
`combined_units_sold`	Unknown
`contact`	Unknown
`contact_clicks`	Unknown
`contact_value_average`	Unknown
`contact_value_sum`	Unknown
`contact_views`	Unknown
`country`	Unknown
`detail_page_view_clicks`	Unknown
`detail_page_view_views`	Unknown
`detail_page_views`	Unknown
`dma_code`	Unknown
`dma_name`	Unknown
`downloaded_video_plays`	Unknown
`downloaded_video_plays_clicks`	Unknown
`downloaded_video_plays_views`	Unknown
`ecp_audio_ad_completion`	Unknown
`ecp_brand_search`	Unknown
`ecp_skill_invocation`	Unknown
`ecpc`	Unknown
`ecpm`	Unknown
`free_trial_subscription_signup_clicks`	Unknown
`free_trial_subscription_signup_views`	Unknown
`free_trial_subscription_signups`	Unknown
`gross_click_throughs`	Unknown
`gross_impressions`	Unknown
`impressions`	Unknown
`interactive_impressions`	Unknown
`interval_end`	Unknown
`interval_start`	Unknown
`invalid_click_through_rate`	Unknown
`invalid_click_throughs`	Unknown
`invalid_impression_rate`	Unknown
`invalid_impressions`	Unknown
`kindle_detail_page_view`	Unknown
`kindle_detail_page_view_clicks`	Unknown
`kindle_detail_page_view_views`	Unknown
`lead`	Unknown
`lead_clicks`	Unknown
`lead_value_average`	Unknown
`lead_value_sum`	Unknown
`lead_views`	Unknown
`line_item_budget`	Unknown
`line_item_comments`	Unknown
`line_item_end_date`	Unknown
`line_item_name`	Unknown
`line_item_start_date`	Unknown
`mobile_app_first_start_average`	Unknown
`mobile_app_first_start_clicks`	Unknown
`mobile_app_first_start_sum`	Unknown
`mobile_app_first_start_views`	Unknown
`mobile_app_first_starts`	Unknown
`new_subscribe_and_save`	Unknown
`new_subscribe_and_save_clicks`	Unknown
`new_subscribe_and_save_views`	Unknown
`new_to_brand_detail_page_view_clicks`	Unknown
`new_to_brand_detail_page_view_rate`	Unknown
`new_to_brand_detail_page_view_views`	Unknown
`new_to_brand_detail_page_views`	Unknown
`new_to_brand_ecp_detail_page_view`	Unknown
`new_to_brand_purchases`	Unknown
`new_to_brand_purchases_clicks`	Unknown
`new_to_brand_purchases_views`	Unknown
`new_to_brand_units_sold`	Unknown
`notification_clicks`	Unknown
`notification_opens`	Unknown
`off_amazon_clicks`	Unknown
`off_amazon_purchases_clicks`	Unknown
`off_amazon_purchases_views`	Unknown
`off_amazon_units_sold`	Unknown
`off_amazon_views`	Unknown
`oms_line_item_id`	Unknown
`order_budget`	Unknown
`order_currency`	Unknown
`order_end_date`	Unknown
`order_name`	Unknown
`order_start_date`	Unknown
`other`	Unknown
`other_clicks`	Unknown
`other_value_average`	Unknown
`other_value_sum`	Unknown
`other_views`	Unknown
`page_view_clicks`	Unknown
`page_view_value_average`	Unknown
`page_view_value_sum`	Unknown
`page_view_views`	Unknown
`page_views`	Unknown
`paid_subscription_signup_clicks`	Unknown
`paid_subscription_signup_views`	Unknown
`paid_subscription_signups`	Unknown
`play_trailers`	Unknown
`play_trailers_clicks`	Unknown
`play_trailers_views`	Unknown
`postal_code`	Unknown
`product_review_page_visits`	Unknown
`product_review_page_visits_clicks`	Unknown
`product_review_page_visits_views`	Unknown
`purchases`	Unknown
`purchases_clicks`	Unknown
`purchases_views`	Unknown
`region`	Unknown
`rentals`	Unknown
`rentals_clicks`	Unknown
`rentals_views`	Unknown
`sales_clicks`	Unknown
`sales_promoted_clicks`	Unknown
`search`	Unknown
`search_clicks`	Unknown
`search_value_average`	Unknown
`search_value_sum`	Unknown
`search_views`	Unknown
`sign_up_value_average`	Unknown
`sign_up_value_sum`	Unknown
`sign_up_views`	Unknown
`skill_invocation`	Unknown
`skill_invocation_clicks`	Unknown
`skill_invocation_rate`	Unknown
`skill_invocation_views`	Unknown
`subscribe`	Unknown
`subscribe_clicks`	Unknown
`subscribe_value_average`	Unknown
`subscribe_value_sum`	Unknown
`subscribe_views`	Unknown
`subscription_signup_clicks`	Unknown
`subscription_signup_views`	Unknown
`subscription_signups`	Unknown
`total_add_to_cart`	Unknown
`total_add_to_cart_clicks`	Unknown
`total_add_to_cart_views`	Unknown
`total_add_to_list`	Unknown
`total_add_to_list_clicks`	Unknown
`total_add_to_list_views`	Unknown
`total_cost`	Unknown
`total_detail_page_view`	Unknown
`total_detail_page_view_clicks`	Unknown
`total_detail_page_view_views`	Unknown
`total_new_to_brand_dpv_clicks`	Unknown
`total_new_to_brand_dpv_rate`	Unknown
`total_new_to_brand_dpv_views`	Unknown
`total_new_to_brand_dpvs`	Unknown
`total_new_to_brand_ecp_detail_page_view`	Unknown
`total_new_to_brand_purchases`	Unknown
`total_new_to_brand_purchases_clicks`	Unknown
`total_new_to_brand_purchases_views`	Unknown
`total_new_to_brand_units_sold`	Unknown
`total_product_review_page_visits`	Unknown
`total_product_review_page_visits_clicks`	Unknown
`total_product_review_page_visits_views`	Unknown
`total_purchases`	Unknown
`total_purchases_clicks`	Unknown
`total_purchases_views`	Unknown
`total_subscribe_and_save`	Unknown
`total_subscribe_and_save_clicks`	Unknown
`total_subscribe_and_save_views`	Unknown
`total_units_sold`	Unknown
`units_sold`	Unknown
`units_sold_clicks`	Unknown
`units_sold_promoted_clicks`	Unknown
`video_ad_clicks`	Unknown
`video_ad_complete`	Unknown
`video_ad_completion_rate`	Unknown
`video_ad_creative_views`	Unknown
`video_ad_end_state_clicks`	Unknown
`video_ad_first_quartile`	Unknown
`video_ad_impressions`	Unknown
`video_ad_midpoint`	Unknown
`video_ad_mute`	Unknown
`video_ad_pause`	Unknown
`video_ad_replays`	Unknown
`video_ad_resume`	Unknown
`video_ad_skip_backs`	Unknown
`video_ad_skip_forwards`	Unknown
`video_ad_start`	Unknown
`video_ad_third_quartile`	Unknown
`video_ad_unmute`	Unknown
`video_downloads`	Unknown
`video_downloads_clicks`	Unknown
`video_downloads_views`	Unknown
`video_streams`	Unknown
`video_streams_clicks`	Unknown
`video_streams_views`	Unknown
`viewable_impressions`	Unknown

product

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`profile_id`	Unknown	FK
`add_to_cart`	Unknown
`add_to_cart_brand_halo`	Unknown
`add_to_cart_brand_halo_clicks`	Unknown
`add_to_cart_brand_halo_views`	Unknown
`add_to_cart_clicks`	Unknown
`add_to_cart_views`	Unknown
`add_to_list`	Unknown
`add_to_list_brand_halo`	Unknown
`add_to_list_brand_halo_clicks`	Unknown
`add_to_list_brand_halo_views`	Unknown
`add_to_list_clicks`	Unknown
`add_to_list_views`	Unknown
`advertiser_id`	Unknown
`app_store_first_opens`	Unknown
`app_store_first_opens_clicks`	Unknown
`app_store_first_opens_views`	Unknown
`app_store_first_session_hours`	Unknown
`app_store_first_session_hours_clicks`	Unknown
`app_store_first_session_hours_views`	Unknown
`app_store_opens`	Unknown
`app_store_opens_clicks`	Unknown
`app_store_opens_views`	Unknown
`app_store_usage_hours`	Unknown
`app_store_usage_hours_clicks`	Unknown
`app_store_usage_hours_views`	Unknown
`app_subscription_sign_up`	Unknown
`app_subscription_sign_up_clicks`	Unknown
`app_subscription_sign_up_free_trial`	Unknown
`app_subscription_sign_up_free_trial_clicks`	Unknown
`app_subscription_sign_up_free_trial_views`	Unknown
`app_subscription_sign_up_paid`	Unknown
`app_subscription_sign_up_paid_clicks`	Unknown
`app_subscription_sign_up_paid_views`	Unknown
`app_subscription_sign_up_views`	Unknown
`asin`	Unknown
`audio_ad_companion_banner_clicks`	Unknown
`audio_ad_companion_banner_views`	Unknown
`audio_ad_completion_rate`	Unknown
`audio_ad_completions`	Unknown
`audio_ad_first_quartile`	Unknown
`audio_ad_midpoint`	Unknown
`audio_ad_mute`	Unknown
`audio_ad_pause`	Unknown
`audio_ad_progression`	Unknown
`audio_ad_resume`	Unknown
`audio_ad_rewind`	Unknown
`audio_ad_skip`	Unknown
`audio_ad_start`	Unknown
`audio_ad_third_quartile`	Unknown
`audio_ad_unmute`	Unknown
`audio_ad_views`	Unknown
`brand_name`	Unknown
`click_to_apply`	Unknown
`click_to_apply_brand_halo`	Unknown
`click_to_apply_brand_halo_clicks`	Unknown
`click_to_apply_brand_halo_views`	Unknown
`click_to_apply_clicks`	Unknown
`click_to_apply_views`	Unknown
`conversion_type`	Unknown
`detail_page_view_brand_halo`	Unknown
`detail_page_view_brand_halo_clicks`	Unknown
`detail_page_view_brand_halo_views`	Unknown
`detail_page_view_clicks`	Unknown
`detail_page_view_views`	Unknown
`detail_page_views`	Unknown
`e_c_p_audio_ad_completion`	Unknown
`e_c_p_skill_invocation`	Unknown
`effective_cost_per_skill_invocation`	Unknown
`eink_detail_page_view`	Unknown
`eink_detail_page_view_brand_halo`	Unknown
`eink_detail_page_view_brand_halo_clicks`	Unknown
`eink_detail_page_view_brand_halo_views`	Unknown
`eink_detail_page_view_clicks`	Unknown
`eink_detail_page_view_views`	Unknown
`featured_asin`	Unknown
`free_trial_subscription_signup_clicks`	Unknown
`free_trial_subscription_signup_views`	Unknown
`free_trial_subscription_signups`	Unknown
`interactive_impressions`	Unknown
`interval_end`	Unknown
`interval_start`	Unknown
`line_item_budget`	Unknown
`line_item_comments`	Unknown
`line_item_end_date`	Unknown
`line_item_name`	Unknown
`line_item_start_date`	Unknown
`marketplace`	Unknown
`new_subscribe_and_save`	Unknown
`new_subscribe_and_save_brand_halo`	Unknown
`new_subscribe_and_save_brand_halo_clicks`	Unknown
`new_subscribe_and_save_brand_halo_views`	Unknown
`new_subscribe_and_save_clicks`	Unknown
`new_subscribe_and_save_views`	Unknown
`new_to_brand_detail_page_view_clicks`	Unknown
`new_to_brand_detail_page_view_rate`	Unknown
`new_to_brand_detail_page_view_views`	Unknown
`new_to_brand_detail_page_views`	Unknown
`new_to_brand_ecp_detail_page_view`	Unknown
`new_to_brand_purchase_percentage_brand_halo`	Unknown
`new_to_brand_purchases`	Unknown
`new_to_brand_purchases_brand_halo`	Unknown
`new_to_brand_purchases_brand_halo_clicks`	Unknown
`new_to_brand_purchases_brand_halo_views`	Unknown
`new_to_brand_purchases_clicks`	Unknown
`new_to_brand_purchases_percentage`	Unknown
`new_to_brand_purchases_views`	Unknown
`new_to_brand_units_sold`	Unknown
`new_to_brand_units_sold_brand_halo`	Unknown
`notification_clicks`	Unknown
`notification_opens`	Unknown
`oms_line_item_id`	Unknown
`oms_proposal_id`	Unknown
`order_budget`	Unknown
`order_currency`	Unknown
`order_end_date`	Unknown
`order_name`	Unknown
`order_start_date`	Unknown
`paid_subscription_signup_clicks`	Unknown
`paid_subscription_signup_views`	Unknown
`paid_subscription_signups`	Unknown
`parent_asin`	Unknown
`product_category`	Unknown
`product_group`	Unknown
`product_name`	Unknown
`product_review_page_view_brand_halo`	Unknown
`product_review_page_view_brand_halo_clicks`	Unknown
`product_review_page_view_brand_halo_views`	Unknown
`product_review_page_visits`	Unknown
`product_review_page_visits_clicks`	Unknown
`product_review_page_visits_views`	Unknown
`product_sub_category`	Unknown
`purchases`	Unknown
`purchases_brand_halo`	Unknown
`purchases_brand_halo_clicks`	Unknown
`purchases_brand_halo_views`	Unknown
`purchases_clicks`	Unknown
`purchases_views`	Unknown
`report_granularity`	Unknown
`sales_clicks`	Unknown
`sales_promoted_clicks`	Unknown
`skill_invocation`	Unknown
`skill_invocation_clicks`	Unknown
`skill_invocation_rate`	Unknown
`skill_invocation_views`	Unknown
`subscription_signup_clicks`	Unknown
`subscription_signup_views`	Unknown
`subscription_signups`	Unknown
`total_add_to_cart`	Unknown
`total_add_to_cart_clicks`	Unknown
`total_add_to_cart_views`	Unknown
`total_add_to_list`	Unknown
`total_add_to_list_clicks`	Unknown
`total_add_to_list_views`	Unknown
`total_detail_page_view`	Unknown
`total_detail_page_view_clicks`	Unknown
`total_detail_page_view_views`	Unknown
`total_new_to_brand_d_p_v_clicks`	Unknown
`total_new_to_brand_d_p_v_rate`	Unknown
`total_new_to_brand_d_p_v_views`	Unknown
`total_new_to_brand_d_p_vs`	Unknown
`total_new_to_brand_ecp_detail_page_view`	Unknown
`total_new_to_brand_purchases`	Unknown
`total_new_to_brand_purchases_clicks`	Unknown
`total_new_to_brand_purchases_percentage`	Unknown
`total_new_to_brand_purchases_views`	Unknown
`total_new_to_brand_units_sold`	Unknown
`total_product_review_page_visits`	Unknown
`total_product_review_page_visits_clicks`	Unknown
`total_product_review_page_visits_views`	Unknown
`total_purchases`	Unknown
`total_purchases_clicks`	Unknown
`total_purchases_views`	Unknown
`total_subscribe_and_save`	Unknown
`total_subscribe_and_save_clicks`	Unknown
`total_subscribe_and_save_views`	Unknown
`total_units_sold`	Unknown
`units_sold`	Unknown
`units_sold_brand_halo`	Unknown
`units_sold_clicks`	Unknown
`units_sold_promoted_clicks`	Unknown
`video_ad_clicks`	Unknown
`video_ad_creative_views`	Unknown
`video_ad_end_state_clicks`	Unknown
`video_ad_impressions`	Unknown
`video_ad_replays`	Unknown
`video_ad_skip_backs`	Unknown
`video_ad_skip_forwards`	Unknown