# Amazon DSP schema ERD

Table and field reference for the Fivetran Amazon DSP connector.

## 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 | PK, FK |
| 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 | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| parent_id | String | FK |
| name | String |  |

### brand_lift_study_status_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| brand_lift_study_id | Unknown | PK, FK |
| status_reason | Unknown |  |

### brand_lift_study_rejection_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| brand_lift_study_id | Unknown | PK, FK |
| rejection_reason | Unknown |  |

### brand_lift_study_link

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| brand_lift_study_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### brand_lift_study_excluded_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| brand_lift_study_id | Unknown | PK, FK |
| excluded_line_item_id | Unknown | FK |

### brand_lift_study_order

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| brand_lift_study_id | Unknown | PK, FK |
| order_id | Unknown | FK |

### brand_lift_study_peer_name

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| brand_lift_study_id | Unknown | PK, FK |
| 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 | PK, FK |
| ad_group_id | String | PK, FK |
| advertiser_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |
| creative_association_status | String |  |
| state | String |  |

### iab_content_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| profile_id | Unknown | PK, FK |
| parent_id | String | FK |
| name | String |  |

### measurement_study_status_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| measurement_study_id | Unknown | PK, FK |
| status_reason | Unknown |  |

### measurement_study_rejection_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| measurement_study_id | Unknown | PK, FK |
| rejection_reason | Unknown |  |

### measurement_study_link

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| measurement_study_id | Unknown | PK, FK |
| 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 | PK, FK |
| advertiser_id | String | PK, FK |
| campaign_id | String | PK, FK |
| id | String | PK, FK |
| profile_id | Unknown | PK, FK |

### ad_group_budget_cap

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_group_id | String | PK, FK |
| advertiser_id | String | PK, FK |
| campaign_id | String | PK, FK |
| profile_id | Unknown | PK, FK |
| amount | Double |  |
| currency_code | String |  |
| recurrence_time_period | String |  |

### ad_group_frequency

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_group_id | String | PK, FK |
| advertiser_id | String | PK, FK |
| campaign_id | String | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| advertiser_id | String | PK, FK |
| campaign_id | String | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| campaign_id | String | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| campaign_list_id | String | PK, FK |
| profile_id | Unknown | PK, FK |
| amount | Double |  |
| currency_code | String |  |
| recurrence_time_period | String |  |

### campaign_list_flight

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| advertiser_id | String | PK, FK |
| campaign_list_id | String | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| campaign_list_id | String | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| status_reason | Unknown |  |

### measurement_creative_testing_study_asset

| Column | Type | Keys |
| --- | --- | --- |
| asset_id | Unknown | PK |
| measurement_creative_testing_study_id | Unknown | PK, FK |
| asset_type | Unknown |  |
| version | Unknown |  |

### measurement_creative_testing_study

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | PK, FK |
| 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 | PK, FK |
| advertiser_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |
| type | String |  |
| value | String |  |

### ad_creative_format_property_asset

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ad_creative_id | String | PK, FK |
| advertiser_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| advertiser_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| advertiser_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |
| height | Int |  |
| responsive | Boolean |  |
| width | Int |  |

### ad_creative_format_property_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ad_creative_id | String | PK, FK |
| advertiser_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| advertiser_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |
| associated_ad_experience | String |  |
| type | String |  |
| url | String |  |

### ad_creative

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advertiser_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| qualifying_response | Unknown |  |

### survey_question_response

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| measurement_survey_question_template_id | Unknown | PK, FK |
| 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 | PK, FK |
| survey_question_placeholder_candidate_index | Unknown | PK, FK |
| 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 | PK, FK |
| survey_question_placeholder_candidate_index | Unknown | PK, FK |
| inferred_field | Unknown |  |

### placeholder_candidate_default_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| measurement_survey_question_template_id | Unknown | PK, FK |
| survey_question_placeholder_candidate_index | Unknown | PK, FK |
| default_value | Unknown |  |

### survey_question_placeholder_candidate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| measurement_survey_question_template_id | Unknown | PK, FK |
| 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 | PK, FK |
| campaign_list_id | String | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- domain_list(profile_id) → profile(id)
- third_party_target_segment(profile_id) → advertiser(profile_id)
- third_party_target_segment(advertiser_id) → advertiser(id)
- advertised_product_category(parent_id) → advertised_product_category(id)
- advertised_product_category(profile_id) → profile(id)
- brand_lift_study_status_reason(brand_lift_study_id) → measurement_brand_lift_study(id)
- brand_lift_study_rejection_reason(brand_lift_study_id) → measurement_brand_lift_study(id)
- brand_lift_study_link(brand_lift_study_id) → measurement_brand_lift_study(id)
- brand_lift_study_excluded_line_item(excluded_line_item_id) → ad_group(id)
- brand_lift_study_excluded_line_item(brand_lift_study_id) → measurement_brand_lift_study(id)
- brand_lift_study_order(order_id) → campaign_list(id)
- brand_lift_study_order(brand_lift_study_id) → measurement_brand_lift_study(id)
- brand_lift_study_peer_name(brand_lift_study_id) → measurement_brand_lift_study(id)
- measurement_brand_lift_study(advertiser_id) → advertiser(id)
- measurement_brand_lift_study(profile_id) → advertiser(profile_id)
- ad_creative_ad_group_association(ad_creative_id) → ad_creative_moderation_ad_experience(ad_creative_id)
- ad_creative_ad_group_association(ad_group_id) → ad_group(id)
- ad_creative_ad_group_association(advertiser_id) → advertiser(id)
- ad_creative_ad_group_association(profile_id) → advertiser(profile_id)
- iab_content_category(parent_id) → iab_content_category(id)
- iab_content_category(profile_id) → profile(id)
- measurement_study_status_reason(measurement_study_id) → measurement_study(id)
- measurement_study_rejection_reason(measurement_study_id) → measurement_study(id)
- measurement_study_link(measurement_study_id) → measurement_study(id)
- measurement_study(profile_id) → advertiser(profile_id)
- measurement_study(advertiser_id) → advertiser(id)
- ad_group_advertised_product_category(id) → advertised_product_category(id)
- ad_group_advertised_product_category(ad_group_id) → ad_group(id)
- ad_group_advertised_product_category(campaign_id) → ad_group(campaign_id)
- ad_group_advertised_product_category(profile_id) → ad_group(profile_id)
- ad_group_advertised_product_category(advertiser_id) → ad_group(advertiser_id)
- ad_group_budget_cap(ad_group_id) → ad_group(id)
- ad_group_budget_cap(campaign_id) → ad_group(campaign_id)
- ad_group_budget_cap(profile_id) → ad_group(profile_id)
- ad_group_budget_cap(advertiser_id) → ad_group(advertiser_id)
- ad_group_frequency(ad_group_id) → ad_group(id)
- ad_group_frequency(campaign_id) → ad_group(campaign_id)
- ad_group_frequency(profile_id) → ad_group(profile_id)
- ad_group_frequency(advertiser_id) → ad_group(advertiser_id)
- ad_group_fee(ad_group_id) → ad_group(id)
- ad_group_fee(campaign_id) → ad_group(campaign_id)
- ad_group_fee(profile_id) → ad_group(profile_id)
- ad_group_fee(advertiser_id) → ad_group(advertiser_id)
- ad_group(campaign_id) → campaign_list(id)
- ad_group(profile_id) → campaign_list(profile_id)
- ad_group(advertiser_id) → campaign_list(advertiser_id)
- advertiser(profile_id) → profile(id)
- campaign_list_budget_cap(campaign_list_id) → campaign_list(id)
- campaign_list_budget_cap(advertiser_id) → campaign_list(advertiser_id)
- campaign_list_budget_cap(profile_id) → campaign_list(profile_id)
- campaign_list_flight(campaign_list_id) → campaign_list(id)
- campaign_list_flight(advertiser_id) → campaign_list(advertiser_id)
- campaign_list_flight(profile_id) → campaign_list(profile_id)
- campaign_list_frequency(campaign_list_id) → campaign_list(id)
- campaign_list_frequency(advertiser_id) → campaign_list(advertiser_id)
- campaign_list_frequency(profile_id) → campaign_list(profile_id)
- campaign_list(advertiser_id) → advertiser(id)
- campaign_list(skan_app_id) → app(id)
- campaign_list(profile_id) → advertiser(profile_id)
- inventory_source_exchange(profile_id) → advertiser(profile_id)
- inventory_source_exchange(advertiser_id) → advertiser(id)
- measurement_creative_testing_study_status_reason(measurement_creative_testing_study_id) → measurement_creative_testing_study(id)
- measurement_creative_testing_study_asset(measurement_creative_testing_study_id) → measurement_creative_testing_study(id)
- measurement_creative_testing_study(advertiser_id) → advertiser(id)
- measurement_creative_testing_study(profile_id) → advertiser(profile_id)
- ad_creative_format_property_ad_copy(ad_creative_id) → ad_creative(id)
- ad_creative_format_property_ad_copy(profile_id) → ad_creative(profile_id)
- ad_creative_format_property_ad_copy(advertiser_id) → ad_creative(advertiser_id)
- ad_creative_format_property_asset(ad_creative_id) → ad_creative(id)
- ad_creative_format_property_asset(profile_id) → ad_creative(profile_id)
- ad_creative_format_property_asset(advertiser_id) → ad_creative(advertiser_id)
- ad_creative_format_property_click_action(ad_creative_id) → ad_creative(id)
- ad_creative_format_property_click_action(profile_id) → ad_creative(profile_id)
- ad_creative_format_property_click_action(advertiser_id) → ad_creative(advertiser_id)
- ad_creative_format_property_creative_size(ad_creative_id) → ad_creative(id)
- ad_creative_format_property_creative_size(profile_id) → ad_creative(profile_id)
- ad_creative_format_property_creative_size(advertiser_id) → ad_creative(advertiser_id)
- ad_creative_format_property_product(ad_creative_id) → ad_creative(id)
- ad_creative_format_property_product(profile_id) → ad_creative(profile_id)
- ad_creative_format_property_product(advertiser_id) → ad_creative(advertiser_id)
- ad_creative_format_property_tracking_url(ad_creative_id) → ad_creative(id)
- ad_creative_format_property_tracking_url(profile_id) → ad_creative(profile_id)
- ad_creative_format_property_tracking_url(advertiser_id) → ad_creative(advertiser_id)
- ad_creative(profile_id) → advertiser(profile_id)
- ad_creative(advertiser_id) → advertiser(id)
- survey_question_qualifying_response(measurement_survey_question_template_id) → measurement_survey_question_template(id)
- survey_question_response(measurement_survey_question_template_id) → measurement_survey_question_template(id)
- placeholder_candidate_allowed_value_range(measurement_survey_question_template_id) → survey_question_placeholder_candidate(measurement_survey_question_template_id)
- placeholder_candidate_allowed_value_range(survey_question_placeholder_candidate_index) → survey_question_placeholder_candidate(index)
- placeholder_candidate_inferred_field(measurement_survey_question_template_id) → survey_question_placeholder_candidate(measurement_survey_question_template_id)
- placeholder_candidate_inferred_field(survey_question_placeholder_candidate_index) → survey_question_placeholder_candidate(index)
- placeholder_candidate_default_value(measurement_survey_question_template_id) → survey_question_placeholder_candidate(measurement_survey_question_template_id)
- placeholder_candidate_default_value(survey_question_placeholder_candidate_index) → survey_question_placeholder_candidate(index)
- survey_question_placeholder_candidate(measurement_survey_question_template_id) → measurement_survey_question_template(id)
- measurement_survey_question_template(profile_id) → advertiser(profile_id)
- campaign_conversion_tracking_product(campaign_list_id) → campaign_list(id)
- campaign_conversion_tracking_product(profile_id) → campaign_list(profile_id)
- campaign_conversion_tracking_product(advertiser_id) → campaign_list(advertiser_id)
- audio_and_video(order_id) → campaign_list(id)
- audio_and_video(creative_id) → ad_creative(id)
- audio_and_video(line_item_id) → ad_group(id)
- audio_and_video(profile_id) → advertiser(profile_id)
- tech(order_id) → campaign_list(id)
- tech(line_item_id) → ad_group(id)
- tech(profile_id) → advertiser(profile_id)
- reach_and_frequency(profile_id) → advertiser(profile_id)
- audience(order_id) → campaign_list(id)
- audience(line_item_id) → ad_group(id)
- audience(profile_id) → advertiser(profile_id)
- campaign(advertiser_id) → advertiser(id)
- campaign(order_id) → campaign_list(id)
- campaign(creative_id) → ad_creative(id)
- campaign(profile_id) → advertiser(profile_id)
- inventory(order_id) → campaign_list(id)
- inventory(line_item_id) → ad_group(id)
- inventory(profile_id) → advertiser(profile_id)
- bid_adjustment(profile_id) → advertiser(profile_id)
- geo(order_id) → campaign_list(id)
- geo(line_item_id) → ad_group(id)
- geo(profile_id) → advertiser(profile_id)
- product(order_id) → campaign_list(id)
- product(line_item_id) → ad_group(id)
- product(profile_id) → advertiser(profile_id)