# Google Display & Video 360 schema ERD

Table and field reference for the Fivetran Google Display & Video 360 connector.

## Table & Field Reference

### contact_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| first_party_and_partner_audience_id | String | PK, FK |
| country_code | String |  |
| hashed_first_name | String |  |
| hashed_last_name | String |  |

### insertion_order

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advertiser_id | String | FK |
| campaign_id | String | FK |
| bid_strategy_fixed_bid_bid_amount_micros | String |  |
| bid_strategy_maximize_spend_auto_bid_custom_bidding_algorithm_id | String |  |
| bid_strategy_maximize_spend_auto_bid_max_average_cpm_bid_amount_micros | String |  |
| bid_strategy_maximize_spend_auto_bid_performance_goal_type | String |  |
| bid_strategy_maximize_spend_auto_bid_raise_bid_for_deals | Boolean |  |
| bid_strategy_performance_goal_auto_bid_custom_bidding_algorithm_id | String |  |
| bid_strategy_performance_goal_auto_bid_max_average_cpm_bid_amount_micros | String |  |
| bid_strategy_performance_goal_auto_bid_performance_goal_amount_micros | String |  |
| bid_strategy_performance_goal_auto_bid_performance_goal_type | String |  |
| bid_strategy_youtube_and_partners_bid_ad_group_effective_target_cpa_source | String |  |
| bid_strategy_youtube_and_partners_bid_ad_group_effective_target_cpa_value | String |  |
| bid_strategy_youtube_and_partners_bid_type | String |  |
| bid_strategy_youtube_and_partners_bid_value | String |  |
| display_name | String |  |
| entity_status | String |  |
| frequency_cap_max_impressions | Int |  |
| frequency_cap_max_views | Int |  |
| frequency_cap_time_unit | String |  |
| frequency_cap_time_unit_count | Int |  |
| frequency_cap_unlimited | Boolean |  |
| insertion_order_budget_automation_type | String |  |
| insertion_order_budget_unit | String |  |
| insertion_order_type | String |  |
| integration_details_details | String |  |
| integration_details_integration_code | String |  |
| kpi_algorithm_id | String |  |
| kpi_amount_micros | String |  |
| kpi_percentage_micros | String |  |
| kpi_string | String |  |
| kpi_type | String |  |
| name | String |  |
| optimization_objective | String |  |
| pacing_daily_max_impressions | String |  |
| pacing_daily_max_micros | String |  |
| pacing_period | String |  |
| pacing_type | String |  |
| reservation_type | String |  |
| update_time | String |  |

### hashed_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| contact_info_index | Int | PK, FK |
| first_party_and_partner_audience_id | String | PK, FK |
| hashed_email | String |  |

### campaign_budget

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| campaign_id | String | FK |
| budget_amount_micros | String |  |
| budget_unit | String |  |
| date_range_end_date | LocalDate |  |
| date_range_start_date | LocalDate |  |
| display_name | String |  |
| external_budget_id | String |  |
| external_budget_source | String |  |
| invoice_grouping_id | String |  |
| prisma_config_prisma_cpe_code_prisma_client_code | String |  |
| prisma_config_prisma_cpe_code_prisma_estimate_code | String |  |
| prisma_config_prisma_cpe_code_prisma_product_code | String |  |
| prisma_config_prisma_type | String |  |
| prisma_config_supplier | String |  |

### custom_list

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| display_name | String |  |
| name | String |  |

### ad_url

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_group_ad_id | String | PK, FK |
| type | String |  |
| url | String |  |

### creative

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advertiser_id | String | FK |
| appended_tag | String |  |
| cm_placement_id | String |  |
| cm_tracking_ad_cm_ad_id | String |  |
| cm_tracking_ad_cm_creative_id | String |  |
| cm_tracking_ad_cm_placement_id | String |  |
| create_time | String |  |
| creative_type | String |  |
| dimensions_height_pixels | Int |  |
| dimensions_width_pixels | Int |  |
| display_name | String |  |
| dynamic | Boolean |  |
| entity_status | String |  |
| expand_on_hover | Boolean |  |
| expanding_direction | String |  |
| hosting_source | String |  |
| html_5_video | Boolean |  |
| ias_campaign_monitoring | Boolean |  |
| integration_code | String |  |
| js_tracker_url | String |  |
| media_duration | String |  |
| mp_3_audio | Boolean |  |
| name | String |  |
| notes | String |  |
| oba_icon_click_tracking_url | String |  |
| oba_icon_dimensions_height_pixels | Int |  |
| oba_icon_dimensions_width_pixels | Int |  |
| oba_icon_landing_page_url | String |  |
| oba_icon_position | String |  |
| oba_icon_program | String |  |
| oba_icon_resource_mime_type | String |  |
| oba_icon_resource_url | String |  |
| oba_icon_view_tracking_url | String |  |
| ogg_audio | Boolean |  |
| progress_offset_percentage | String |  |
| progress_offset_seconds | String |  |
| require_html_5 | Boolean |  |
| require_mraid | Boolean |  |
| require_ping_for_attribution | Boolean |  |
| review_status_approval_status | String |  |
| review_status_content_and_policy_review_status | String |  |
| review_status_creative_and_landing_page_review_status | String |  |
| skip_offset_percentage | String |  |
| skip_offset_seconds | String |  |
| skippable | Boolean |  |
| third_party_tag | String |  |
| universal_ad_id | String |  |
| universal_ad_id_registry | String |  |
| update_time | String |  |
| vast_tag_url | String |  |
| vpaid | Boolean |  |

### insertion_order_budget_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| insertion_order_id | String | PK, FK |
| campaign_budget_id | String | FK |
| budget_amount_micros | String |  |
| date_range_end_date | LocalDate |  |
| date_range_start_date | LocalDate |  |
| description | String |  |

### line_item_assigned_google_audience

| Column | Type | Keys |
| --- | --- | --- |
| google_audience_id | String | PK, FK |
| line_item_assigned_targeting_option_id | String | PK, FK |
| line_item_id | String | PK, FK |
| is_included | Boolean |  |

### ad_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advertiser_id | String | FK |
| line_item_id | String | FK |
| ad_group_format | String |  |
| bid_strategy_fixed_bid_bid_amount_micros | String |  |
| bid_strategy_maximize_spend_auto_bid_custom_bidding_algorithm_id | String |  |
| bid_strategy_maximize_spend_auto_bid_max_average_cpm_bid_amount_micros | String |  |
| bid_strategy_maximize_spend_auto_bid_performance_goal_type | String |  |
| bid_strategy_maximize_spend_auto_bid_raise_bid_for_deals | Boolean |  |
| bid_strategy_performance_goal_auto_bid_custom_bidding_algorithm_id | String |  |
| bid_strategy_performance_goal_auto_bid_max_average_cpm_bid_amount_micros | String |  |
| bid_strategy_performance_goal_auto_bid_performance_goal_amount_micros | String |  |
| bid_strategy_performance_goal_auto_bid_performance_goal_type | String |  |
| bid_strategy_youtube_and_partners_bid_ad_group_effective_target_cpa_source | String |  |
| bid_strategy_youtube_and_partners_bid_ad_group_effective_target_cpa_value | String |  |
| bid_strategy_youtube_and_partners_bid_type | String |  |
| bid_strategy_youtube_and_partners_bid_value | String |  |
| display_name | String |  |
| entity_status | String |  |
| name | String |  |
| product_feed_data_is_feed_disabled | Boolean |  |
| product_feed_data_product_match_type | String |  |
| targeting_expansion_audience_expansion_level | String |  |
| targeting_expansion_audience_expansion_seed_list_excluded | Boolean |  |
| targeting_expansion_enable_optimized_targeting | Boolean |  |

### inventory_source

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| read_write_accessors_partner_id | String | FK |
| commitment | String |  |
| deal_id | String |  |
| display_name | String |  |
| exchange | String |  |
| guaranteed_order_id | String |  |
| inventory_source_product_type | String |  |
| inventory_source_type | String |  |
| name | String |  |
| publisher_name | String |  |
| rate_details_inventory_source_rate_type | String |  |
| rate_details_minimum_spend_currency_code | String |  |
| rate_details_minimum_spend_nanos | Int |  |
| rate_details_minimum_spend_units | String |  |
| rate_details_rate_currency_code | String |  |
| rate_details_rate_nanos | Int |  |
| rate_details_rate_units | String |  |
| rate_details_units_purchased | String |  |
| status_config_status | String |  |
| status_entity_pause_reason | String |  |
| status_entity_status | String |  |
| status_seller_pause_reason | String |  |
| status_seller_status | String |  |
| time_range_end_time | String |  |
| time_range_start_time | String |  |
| update_time | String |  |

### line_item_viewability_vendor_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| placement_id | String |  |
| vendor | String |  |

### line_item_brand_lift_vendor_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| placement_id | String |  |
| vendor | String |  |

### ad_group_ad

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_group_id | String | FK |
| advertiser_id | String | FK |
| display_video_source_ad_creative_id | String | FK |
| audio_ad_display_url | String |  |
| audio_ad_final_url | String |  |
| audio_ad_tracking_url | String |  |
| audio_ad_video_id | String |  |
| audio_ad_video_unavailable_reason | String |  |
| bumper_ad_common_in_stream_attribute_action_button_label | String |  |
| bumper_ad_common_in_stream_attribute_action_headline | String |  |
| bumper_ad_common_in_stream_attribute_companion_banner_file_size | String |  |
| bumper_ad_common_in_stream_attribute_companion_banner_full_size_height_pixels | Int |  |
| bumper_ad_common_in_stream_attribute_companion_banner_full_size_width_pixels | Int |  |
| bumper_ad_common_in_stream_attribute_companion_banner_mime_type | String |  |
| bumper_ad_common_in_stream_attribute_display_url | String |  |
| bumper_ad_common_in_stream_attribute_final_url | String |  |
| bumper_ad_common_in_stream_attribute_tracking_url | String |  |
| bumper_ad_common_in_stream_attribute_video_id | String |  |
| bumper_ad_common_in_stream_attribute_video_unavailable_reason | String |  |
| display_name | String |  |
| entity_status | String |  |
| in_stream_ad_common_in_stream_attribute_action_button_label | String |  |
| in_stream_ad_common_in_stream_attribute_action_headline | String |  |
| in_stream_ad_common_in_stream_attribute_companion_banner_file_size | String |  |
| in_stream_ad_common_in_stream_attribute_companion_banner_full_size_height_pixels | Int |  |
| in_stream_ad_common_in_stream_attribute_companion_banner_full_size_width_pixels | Int |  |
| in_stream_ad_common_in_stream_attribute_companion_banner_mime_type | String |  |
| in_stream_ad_common_in_stream_attribute_display_url | String |  |
| in_stream_ad_common_in_stream_attribute_final_url | String |  |
| in_stream_ad_common_in_stream_attribute_tracking_url | String |  |
| in_stream_ad_common_in_stream_attribute_video_id | String |  |
| in_stream_ad_common_in_stream_attribute_video_unavailable_reason | String |  |
| masthead_ad_autoplay_video_duration | String |  |
| masthead_ad_autoplay_video_start_millisecond | String |  |
| masthead_ad_call_to_action_button_label | String |  |
| masthead_ad_call_to_action_final_url | String |  |
| masthead_ad_call_to_action_tracking_url | String |  |
| masthead_ad_description | String |  |
| masthead_ad_headline | String |  |
| masthead_ad_show_channel_art | Boolean |  |
| masthead_ad_video_aspect_ratio | String |  |
| masthead_ad_video_id | String |  |
| masthead_ad_video_unavailable_reason | String |  |
| name | String |  |
| non_skippable_ad_common_in_stream_attribute_action_button_label | String |  |
| non_skippable_ad_common_in_stream_attribute_action_headline | String |  |
| non_skippable_ad_common_in_stream_attribute_companion_banner_file_size | String |  |
| non_skippable_ad_common_in_stream_attribute_companion_banner_full_size_height_pixels | Int |  |
| non_skippable_ad_common_in_stream_attribute_companion_banner_full_size_width_pixels | Int |  |
| non_skippable_ad_common_in_stream_attribute_companion_banner_mime_type | String |  |
| non_skippable_ad_common_in_stream_attribute_display_url | String |  |
| non_skippable_ad_common_in_stream_attribute_final_url | String |  |
| non_skippable_ad_common_in_stream_attribute_tracking_url | String |  |
| non_skippable_ad_common_in_stream_attribute_video_id | String |  |
| non_skippable_ad_common_in_stream_attribute_video_unavailable_reason | String |  |
| video_discover_ad_description_1 | String |  |
| video_discover_ad_description_2 | String |  |
| video_discover_ad_headline | String |  |
| video_discover_ad_thumbnail | String |  |
| video_discover_ad_video_id | String |  |
| video_discover_ad_video_unavailable_reason | String |  |
| video_performance_ad_display_url_breadcrumb_1 | String |  |
| video_performance_ad_display_url_breadcrumb_2 | String |  |
| video_performance_ad_domain | String |  |
| video_performance_ad_final_url | String |  |
| video_performance_ad_tracking_url | String |  |

### inventory_source_accessors_advertiser

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| inventory_source_id | String | PK, FK |
| advertiser_id | String | FK |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advertiser_id | String | FK |
| campaign_flight_planned_dates_end_date | LocalDate |  |
| campaign_flight_planned_dates_start_date | LocalDate |  |
| campaign_flight_planned_spend_amount_micros | String |  |
| campaign_goal_performance_goal_amount_micros | String |  |
| campaign_goal_performance_goal_percentage_micros | String |  |
| campaign_goal_performance_goal_string | String |  |
| campaign_goal_performance_goal_type | String |  |
| campaign_goal_type | String |  |
| display_name | String |  |
| entity_status | String |  |
| frequency_cap_max_impressions | Int |  |
| frequency_cap_max_views | Int |  |
| frequency_cap_time_unit | String |  |
| frequency_cap_time_unit_count | Int |  |
| frequency_cap_unlimited | Boolean |  |
| name | String |  |
| update_time | String |  |

### inventory_source_read_advertiser

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| inventory_source_id | String | PK, FK |
| advertiser_id | String | FK |

### line_item_related_video

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| related_video_id | String |  |

### first_party_and_partner_audience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| active_display_audience_size | String |  |
| app_id | String |  |
| audience_source | String |  |
| audience_type | String |  |
| contact_info_list_consent_ad_personalization | String |  |
| contact_info_list_consent_ad_user_data | String |  |
| description | String |  |
| display_audience_size | String |  |
| display_desktop_audience_size | String |  |
| display_mobile_app_audience_size | String |  |
| display_mobile_web_audience_size | String |  |
| display_name | String |  |
| first_party_and_patner_audience_type | String |  |
| gmail_audience_size | String |  |
| membership_duration_days | String |  |
| mobile_device_id_list_consent_ad_personalization | String |  |
| mobile_device_id_list_consent_ad_user_data | String |  |
| name | String |  |
| youtube_audience_size | String |  |

### inventory_source_read_partner

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| inventory_source_id | String | PK, FK |
| partner_id | String | FK |

### line_item_assigned_first_party_and_partner_audience

| Column | Type | Keys |
| --- | --- | --- |
| recency | String | PK |
| first_party_and_partner_audience_id | String | PK, FK |
| line_item_assigned_targeting_option_id | String | PK, FK |
| line_item_id | String | PK, FK |
| is_included | Boolean |  |

### combined_audience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| display_name | String |  |
| name | String |  |

### line_item_assigned_targeting_option

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| line_item_id | String | PK, FK |
| channel_details_channel_id | String | FK |
| inventory_source_group_details_inventory_source_group_id | String | FK |
| age_range_details_age_range | String |  |
| app_category_details_display_name | String |  |
| app_category_details_negative | Boolean |  |
| app_category_details_targeting_option_id | String |  |
| app_details_app_id | String |  |
| app_details_app_platform | String |  |
| app_details_display_name | String |  |
| app_details_negative | Boolean |  |
| assigned_targeting_option_id_alias | String |  |
| audio_content_type_details_audio_content_type | String |  |
| authorized_seller_status_details_authorized_seller_status | String |  |
| authorized_seller_status_details_targeting_option_id | String |  |
| browser_details_display_name | String |  |
| browser_details_negative | Boolean |  |
| browser_details_targeting_option_id | String |  |
| business_chain_details_display_name | String |  |
| business_chain_details_proximity_radius_amount | Double |  |
| business_chain_details_proximity_radius_unit | String |  |
| business_chain_details_targeting_option_id | String |  |
| carrier_and_isp_details_display_name | String |  |
| carrier_and_isp_details_negative | Boolean |  |
| carrier_and_isp_details_targeting_option_id | String |  |
| category_details_display_name | String |  |
| category_details_negative | Boolean |  |
| category_details_targeting_option_id | String |  |
| channel_details_negative | Boolean |  |
| content_duration_details_content_duration | String |  |
| content_duration_details_targeting_option_id | String |  |
| content_genre_details_display_name | String |  |
| content_genre_details_negative | Boolean |  |
| content_genre_details_targeting_option_id | String |  |
| content_instream_position_details_ad_type | String |  |
| content_instream_position_details_content_instream_position | String |  |
| content_outstream_position_details_ad_type | String |  |
| content_outstream_position_details_content_outstream_position | String |  |
| content_stream_type_details_content_stream_type | String |  |
| content_stream_type_details_targeting_option_id | String |  |
| content_theme_exclusion_details_content_theme | String |  |
| content_theme_exclusion_details_excluded_content_theme | String |  |
| content_theme_exclusion_details_excluded_targeting_option_id | String |  |
| day_and_time_details_day_of_week | String |  |
| day_and_time_details_end_hour | Int |  |
| day_and_time_details_start_hour | Int |  |
| day_and_time_details_time_zone_resolution | String |  |
| device_make_model_details_display_name | String |  |
| device_make_model_details_negative | Boolean |  |
| device_make_model_details_targeting_option_id | String |  |
| device_type_details_device_type | String |  |
| device_type_details_youtube_and_partners_bid_multiplier | Double |  |
| digital_content_label_exclusion_details_excluded_content_rating_tier | String |  |
| environment_details_environment | String |  |
| exchange_details_exchange | String |  |
| gender_details_gender | String |  |
| geo_region_details_display_name | String |  |
| geo_region_details_geo_region_type | String |  |
| geo_region_details_negative | Boolean |  |
| geo_region_details_targeting_option_id | String |  |
| household_income_details_household_income | String |  |
| inheritance | String |  |
| inventory_source_details_inventory_source_id | String |  |
| keyword_details_keyword | String |  |
| keyword_details_negative | Boolean |  |
| language_details_display_name | String |  |
| language_details_negative | Boolean |  |
| language_details_targeting_option_id | String |  |
| name | String |  |
| native_content_position_details_content_position | String |  |
| negative_keyword_list_details_negative_keyword_list_id | String |  |
| omid_details_omid | String |  |
| on_screen_position_details_ad_type | String |  |
| on_screen_position_details_on_screen_position | String |  |
| on_screen_position_details_targeting_option_id | String |  |
| operating_system_details_display_name | String |  |
| operating_system_details_negative | Boolean |  |
| operating_system_details_targeting_option_id | String |  |
| parental_status_details_parental_status | String |  |
| poi_details_display_name | String |  |
| poi_details_latitude | Double |  |
| poi_details_longitude | Double |  |
| poi_details_proximity_radius_amount | Double |  |
| poi_details_proximity_radius_unit | String |  |
| poi_details_targeting_option_id | String |  |
| proximity_location_list_details_proximity_location_list_id | String |  |
| proximity_location_list_details_proximity_radius | Double |  |
| proximity_location_list_details_proximity_radius_unit | String |  |
| regional_location_list_details_negative | Boolean |  |
| regional_location_list_details_regional_location_list_id | String |  |
| sensitive_category_exclusion_details_excluded_sensitive_category | String |  |
| session_position_details_session_position | String |  |
| sub_exchange_details_targeting_option_id | String |  |
| targeting_type | String |  |
| third_party_verifier_details_adloox_adult_explicit_sexual_content | String |  |
| third_party_verifier_details_adloox_arms_ammunition_content | String |  |
| third_party_verifier_details_adloox_crime_harmful_acts_individuals_society_human_rights_violations_content | String |  |
| third_party_verifier_details_adloox_death_injury_military_conflict_content | String |  |
| third_party_verifier_details_adloox_debated_sensitive_social_issue_content | String |  |
| third_party_verifier_details_adloox_display_iab_viewability | String |  |
| third_party_verifier_details_adloox_hate_speech_acts_aggression_content | String |  |
| third_party_verifier_details_adloox_illegal_drugs_tobacco_ecigarettes_vaping_alcohol_content | String |  |
| third_party_verifier_details_adloox_misinformation_content | String |  |
| third_party_verifier_details_adloox_obscenity_profanity_content | String |  |
| third_party_verifier_details_adloox_online_piracy_content | String |  |
| third_party_verifier_details_adloox_spam_harmful_content | String |  |
| third_party_verifier_details_adloox_terrorism_content | String |  |
| third_party_verifier_details_adloox_video_iab_viewability | String |  |
| third_party_verifier_details_double_verify_app_star_rating_avoid_insufficient_star_rating | Boolean |  |
| third_party_verifier_details_double_verify_app_star_rating_avoided_star_rating | String |  |
| third_party_verifier_details_double_verify_brand_safety_categories_avoid_unknown_brand_safety_category | Boolean |  |
| third_party_verifier_details_double_verify_custom_segment_id | String |  |
| third_party_verifier_details_double_verify_display_viewability_iab | String |  |
| third_party_verifier_details_double_verify_display_viewability_viewable_during | String |  |
| third_party_verifier_details_double_verify_fraud_invalid_traffic_avoid_insufficient_option | Boolean |  |
| third_party_verifier_details_double_verify_fraud_invalid_traffic_avoided_fraud_option | String |  |
| third_party_verifier_details_double_verify_video_viewability_player_impression_rate | String |  |
| third_party_verifier_details_double_verify_video_viewability_video_iab | String |  |
| third_party_verifier_details_double_verify_video_viewability_video_viewable_rate | String |  |
| third_party_verifier_details_integral_ad_science_display_viewability | String |  |
| third_party_verifier_details_integral_ad_science_exclude_unrateable | Boolean |  |
| third_party_verifier_details_integral_ad_science_excluded_ad_fraud_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_adult_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_alcohol_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_drugs_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_gambling_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_hate_speech_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_illegal_downloads_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_offensive_language_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_violence_risk | String |  |
| third_party_verifier_details_integral_ad_science_traq_score_option | String |  |
| third_party_verifier_details_integral_ad_science_video_viewability | String |  |
| url_details_negative | Boolean |  |
| url_details_url | String |  |
| user_rewarded_content_details_targeting_option_id | String |  |
| user_rewarded_content_details_user_rewarded_content | String |  |
| video_player_size_details_video_player_size | String |  |
| viewability_details_viewability | String |  |
| youtube_channel_details_channel_id | String |  |
| youtube_channel_details_negative | Boolean |  |
| youtube_video_details_negative | Boolean |  |
| youtube_video_details_video_id | String |  |

### zip_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| contact_info_index | Int | PK, FK |
| first_party_and_partner_audience_id | String | PK, FK |
| zip_code | String |  |

### line_item_floodlight_activity_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| floodlight_activity_id | String |  |
| post_click_lookback_window_days | Int |  |
| post_view_lookback_window_days | Int |  |

### advertiser

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| partner_id | String | FK |
| ad_server_config_cm_hybrid_config_cm_account_id | String |  |
| ad_server_config_cm_hybrid_config_cm_floodlight_config_id | String |  |
| ad_server_config_cm_hybrid_config_cm_floodlight_linking_authorized | Boolean |  |
| ad_server_config_cm_hybrid_config_dv_360_to_cm_cost_reporting_enabled | Boolean |  |
| ad_server_config_cm_hybrid_config_dv_360_to_cm_data_sharing_enabled | Boolean |  |
| ad_server_config_third_party_only_config_pixel_order_id_reporting_enabled | Boolean |  |
| billing_profile_id | String |  |
| creative_config_dynamic_creative_enabled | Boolean |  |
| creative_config_ias_client_id | String |  |
| creative_config_oba_compliance_disabled | Boolean |  |
| creative_config_video_creative_data_sharing_authorized | Boolean |  |
| data_access_config_override_partner_sdf_config | Boolean |  |
| data_access_config_sdf_config_admin_email | String |  |
| data_access_config_sdf_config_version | String |  |
| display_name | String |  |
| entity_status | String |  |
| general_config_currency_code | String |  |
| general_config_domain_url | String |  |
| general_config_time_zone | String |  |
| integration_details | String |  |
| integration_details_code | String |  |
| name | String |  |
| prisma_enabled | Boolean |  |
| serving_config_exempt_tv_from_viewability_targeting | Boolean |  |
| update_time | String |  |

### line_item_creative

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| creative_id | String | FK |

### inventory_source_creative_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| inventory_source_id | String | PK, FK |
| creative_type | String |  |
| display_creative_config_creative_size_height_pixels | Int |  |
| display_creative_config_creative_size_width_pixels | Int |  |
| video_creative_config_duration | String |  |

### line_item_warning_message

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| warning_message | String |  |

### line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advertiser_id | String | FK |
| campaign_id | String | FK |
| insertion_order_id | String | FK |
| bid_strategy_fixed_bid_bid_amount_micros | String |  |
| bid_strategy_maximize_spend_auto_bid_custom_bidding_algorithm_id | String |  |
| bid_strategy_maximize_spend_auto_bid_max_average_cpm_bid_amount_micros | String |  |
| bid_strategy_maximize_spend_auto_bid_performance_goal_type | String |  |
| bid_strategy_maximize_spend_auto_bid_raise_bid_for_deals | Boolean |  |
| bid_strategy_performance_goal_auto_bid_custom_bidding_algorithm_id | String |  |
| bid_strategy_performance_goal_auto_bid_max_average_cpm_bid_amount_micros | String |  |
| bid_strategy_performance_goal_auto_bid_performance_goal_amount_micros | String |  |
| bid_strategy_performance_goal_auto_bid_performance_goal_type | String |  |
| bid_strategy_youtube_and_partners_bid_ad_group_effective_target_cpa_source | String |  |
| bid_strategy_youtube_and_partners_bid_ad_group_effective_target_cpa_value | String |  |
| bid_strategy_youtube_and_partners_bid_type | String |  |
| bid_strategy_youtube_and_partners_bid_value | String |  |
| budget_allocation_type | String |  |
| budget_max_amount | String |  |
| budget_unit | String |  |
| contains_eu_political_ads | String |  |
| conversion_counting_post_view_count_percentage_millis | String |  |
| display_name | String |  |
| entity_status | String |  |
| exclude_new_exchanges | Boolean |  |
| flight_date_range_end_date | LocalDate |  |
| flight_date_range_start_date | LocalDate |  |
| flight_date_type | String |  |
| frequency_cap_max_impressions | Int |  |
| frequency_cap_max_views | Int |  |
| frequency_cap_time_unit | String |  |
| frequency_cap_time_unit_count | Int |  |
| frequency_cap_unlimited | Boolean |  |
| integration_details_details | String |  |
| integration_details_integration_code | String |  |
| line_item_type | String |  |
| mobile_app_app_id | String |  |
| mobile_app_display_name | String |  |
| mobile_app_platform | String |  |
| mobile_app_publisher | String |  |
| name | String |  |
| pacing_daily_max_impressions | String |  |
| pacing_daily_max_micros | String |  |
| pacing_period | String |  |
| pacing_type | String |  |
| partner_revenue_model_revenue_amount | String |  |
| partner_revenue_model_type | String |  |
| reservation_type | String |  |
| targeting_expansion_audience_expansion_level | String |  |
| targeting_expansion_audience_expansion_seed_list_excluded | Boolean |  |
| targeting_expansion_enable_optimized_targeting | Boolean |  |
| update_time | String |  |
| youtube_and_partners_settings_content_category | String |  |
| youtube_and_partners_settings_effective_content_category | String |  |
| youtube_and_partners_settings_inventory_source_settings_include_google_tv | Boolean |  |
| youtube_and_partners_settings_inventory_source_settings_include_youtube | Boolean |  |
| youtube_and_partners_settings_inventory_source_settings_include_youtube_video_partners | Boolean |  |
| youtube_and_partners_settings_lead_form_id | String |  |
| youtube_and_partners_settings_linked_merchant_id | String |  |
| youtube_and_partners_settings_target_frequency_target_count | String |  |
| youtube_and_partners_settings_target_frequency_time_unit | String |  |
| youtube_and_partners_settings_target_frequency_time_unit_count | Int |  |
| youtube_and_partners_settings_video_ad_inventory_control_allow_in_feed | Boolean |  |
| youtube_and_partners_settings_video_ad_inventory_control_allow_in_stream | Boolean |  |
| youtube_and_partners_settings_video_ad_inventory_control_allow_shorts | Boolean |  |
| youtube_and_partners_settings_video_ad_sequence_settings_minimum_duration | String |  |
| youtube_and_partners_settings_view_frequency_cap_max_impressions | Int |  |
| youtube_and_partners_settings_view_frequency_cap_max_views | Int |  |
| youtube_and_partners_settings_view_frequency_cap_time_unit | String |  |
| youtube_and_partners_settings_view_frequency_cap_time_unit_count | Int |  |
| youtube_and_partners_settings_view_frequency_cap_unlimited | Boolean |  |

### line_item_assigned_custom_list

| Column | Type | Keys |
| --- | --- | --- |
| custom_list_id | String | PK, FK |
| line_item_assigned_targeting_option_id | String | PK, FK |
| line_item_id | String | PK, FK |
| is_included | Boolean |  |

### line_item_brand_safety_vendor_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| placement_id | String |  |
| vendor | String |  |

### assigned_first_party_and_partner_audience

| Column | Type | Keys |
| --- | --- | --- |
| recency | String | PK |
| ad_group_assigned_targeting_option_id | String | PK, FK |
| ad_group_id | String | PK, FK |
| first_party_and_partner_audience_id | String | PK, FK |
| is_included | Boolean |  |

### line_item_partner_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| cost_type | String |  |
| fee_amount | String |  |
| fee_percentage_millis | String |  |
| fee_type | String |  |
| invoice_type | String |  |

### line_item_reach_vendor_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| placement_id | String |  |
| vendor | String |  |

### line_item_video_ad_sequence_step

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | String | PK, FK |
| ad_group_id | String | FK |
| interaction_type | String |  |
| previous_step_id | String |  |
| step_id | String |  |

### partner

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_server_config_measurement_config_dv_360_to_cm_cost_reporting_enabled | Boolean |  |
| ad_server_config_measurement_config_dv_360_to_cm_data_sharing_enabled | Boolean |  |
| billing_profile_id | String |  |
| data_access_config_sdf_config_admin_email | String |  |
| data_access_config_sdf_config_version | String |  |
| display_name | String |  |
| entity_status | String |  |
| general_config_currency_code | String |  |
| general_config_time_zone | String |  |
| name | String |  |
| update_time | String |  |

### insertion_order_partner_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| insertion_order_id | String | PK, FK |
| cost_type | String |  |
| fee_amount | String |  |
| fee_percentage_millis | String |  |
| fee_type | String |  |
| invoice_type | String |  |

### hashed_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| contact_info_index | Int | PK, FK |
| first_party_and_partner_audience_id | String | PK, FK |
| hashed_phone_number | String |  |

### inventory_source_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| display_name | String |  |
| name | String |  |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advertiser_id | String | FK |
| partner_id | String | FK |
| display_name | String |  |
| name | String |  |

### google_audience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| display_name | String |  |
| google_audience_type | String |  |
| name | String |  |

### line_item_assigned_combined_audience

| Column | Type | Keys |
| --- | --- | --- |
| combined_audience_id | String | PK, FK |
| line_item_assigned_targeting_option_id | String | PK, FK |
| line_item_id | String | PK, FK |
| is_included | Boolean |  |

### ad_group_assigned_targeting_option

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_group_id | String | PK, FK |
| inventory_source_group_details_inventory_source_group_id | String | FK |
| age_range_details_age_range | String |  |
| app_category_details_display_name | String |  |
| app_category_details_negative | Boolean |  |
| app_category_details_targeting_option_id | String |  |
| app_details_app_id | String |  |
| app_details_app_platform | String |  |
| app_details_display_name | String |  |
| app_details_negative | Boolean |  |
| assigned_targeting_option_id_alias | String |  |
| audio_content_type_details_audio_content_type | String |  |
| authorized_seller_status_details_authorized_seller_status | String |  |
| authorized_seller_status_details_targeting_option_id | String |  |
| browser_details_display_name | String |  |
| browser_details_negative | Boolean |  |
| browser_details_targeting_option_id | String |  |
| business_chain_details_display_name | String |  |
| business_chain_details_proximity_radius_amount | Double |  |
| business_chain_details_proximity_radius_unit | String |  |
| business_chain_details_targeting_option_id | String |  |
| carrier_and_isp_details_display_name | String |  |
| carrier_and_isp_details_negative | Boolean |  |
| carrier_and_isp_details_targeting_option_id | String |  |
| category_details_display_name | String |  |
| category_details_negative | Boolean |  |
| category_details_targeting_option_id | String |  |
| channel_details_channel_id | String |  |
| channel_details_negative | Boolean |  |
| content_duration_details_content_duration | String |  |
| content_duration_details_targeting_option_id | String |  |
| content_genre_details_display_name | String |  |
| content_genre_details_negative | Boolean |  |
| content_genre_details_targeting_option_id | String |  |
| content_instream_position_details_ad_type | String |  |
| content_instream_position_details_content_instream_position | String |  |
| content_outstream_position_details_ad_type | String |  |
| content_outstream_position_details_content_outstream_position | String |  |
| content_stream_type_details_content_stream_type | String |  |
| content_stream_type_details_targeting_option_id | String |  |
| content_theme_exclusion_details_content_theme | String |  |
| content_theme_exclusion_details_excluded_content_theme | String |  |
| content_theme_exclusion_details_excluded_targeting_option_id | String |  |
| day_and_time_details_day_of_week | String |  |
| day_and_time_details_end_hour | Int |  |
| day_and_time_details_start_hour | Int |  |
| day_and_time_details_time_zone_resolution | String |  |
| device_make_model_details_display_name | String |  |
| device_make_model_details_negative | Boolean |  |
| device_make_model_details_targeting_option_id | String |  |
| device_type_details_device_type | String |  |
| device_type_details_youtube_and_partners_bid_multiplier | Double |  |
| digital_content_label_exclusion_details_excluded_content_rating_tier | String |  |
| environment_details_environment | String |  |
| exchange_details_exchange | String |  |
| gender_details_gender | String |  |
| geo_region_details_display_name | String |  |
| geo_region_details_geo_region_type | String |  |
| geo_region_details_negative | Boolean |  |
| geo_region_details_targeting_option_id | String |  |
| household_income_details_household_income | String |  |
| inheritance | String |  |
| inventory_source_details_inventory_source_id | String |  |
| keyword_details_keyword | String |  |
| keyword_details_negative | Boolean |  |
| language_details_display_name | String |  |
| language_details_negative | Boolean |  |
| language_details_targeting_option_id | String |  |
| name | String |  |
| native_content_position_details_content_position | String |  |
| negative_keyword_list_details_negative_keyword_list_id | String |  |
| omid_details_omid | String |  |
| on_screen_position_details_ad_type | String |  |
| on_screen_position_details_on_screen_position | String |  |
| on_screen_position_details_targeting_option_id | String |  |
| operating_system_details_display_name | String |  |
| operating_system_details_negative | Boolean |  |
| operating_system_details_targeting_option_id | String |  |
| parental_status_details_parental_status | String |  |
| poi_details_display_name | String |  |
| poi_details_latitude | Double |  |
| poi_details_longitude | Double |  |
| poi_details_proximity_radius_amount | Double |  |
| poi_details_proximity_radius_unit | String |  |
| poi_details_targeting_option_id | String |  |
| proximity_location_list_details_proximity_location_list_id | String |  |
| proximity_location_list_details_proximity_radius | Double |  |
| proximity_location_list_details_proximity_radius_unit | String |  |
| regional_location_list_details_negative | Boolean |  |
| regional_location_list_details_regional_location_list_id | String |  |
| sensitive_category_exclusion_details_excluded_sensitive_category | String |  |
| session_position_details_session_position | String |  |
| sub_exchange_details_targeting_option_id | String |  |
| targeting_type | String |  |
| third_party_verifier_details_adloox_adult_explicit_sexual_content | String |  |
| third_party_verifier_details_adloox_arms_ammunition_content | String |  |
| third_party_verifier_details_adloox_crime_harmful_acts_individuals_society_human_rights_violations_content | String |  |
| third_party_verifier_details_adloox_death_injury_military_conflict_content | String |  |
| third_party_verifier_details_adloox_debated_sensitive_social_issue_content | String |  |
| third_party_verifier_details_adloox_display_iab_viewability | String |  |
| third_party_verifier_details_adloox_hate_speech_acts_aggression_content | String |  |
| third_party_verifier_details_adloox_illegal_drugs_tobacco_ecigarettes_vaping_alcohol_content | String |  |
| third_party_verifier_details_adloox_misinformation_content | String |  |
| third_party_verifier_details_adloox_obscenity_profanity_content | String |  |
| third_party_verifier_details_adloox_online_piracy_content | String |  |
| third_party_verifier_details_adloox_spam_harmful_content | String |  |
| third_party_verifier_details_adloox_terrorism_content | String |  |
| third_party_verifier_details_adloox_video_iab_viewability | String |  |
| third_party_verifier_details_double_verify_app_star_rating_avoid_insufficient_star_rating | Boolean |  |
| third_party_verifier_details_double_verify_app_star_rating_avoided_star_rating | String |  |
| third_party_verifier_details_double_verify_brand_safety_categories_avoid_unknown_brand_safety_category | Boolean |  |
| third_party_verifier_details_double_verify_custom_segment_id | String |  |
| third_party_verifier_details_double_verify_display_viewability_iab | String |  |
| third_party_verifier_details_double_verify_display_viewability_viewable_during | String |  |
| third_party_verifier_details_double_verify_fraud_invalid_traffic_avoid_insufficient_option | Boolean |  |
| third_party_verifier_details_double_verify_fraud_invalid_traffic_avoided_fraud_option | String |  |
| third_party_verifier_details_double_verify_video_viewability_player_impression_rate | String |  |
| third_party_verifier_details_double_verify_video_viewability_video_iab | String |  |
| third_party_verifier_details_double_verify_video_viewability_video_viewable_rate | String |  |
| third_party_verifier_details_integral_ad_science_display_viewability | String |  |
| third_party_verifier_details_integral_ad_science_exclude_unrateable | Boolean |  |
| third_party_verifier_details_integral_ad_science_excluded_ad_fraud_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_adult_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_alcohol_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_drugs_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_gambling_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_hate_speech_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_illegal_downloads_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_offensive_language_risk | String |  |
| third_party_verifier_details_integral_ad_science_excluded_violence_risk | String |  |
| third_party_verifier_details_integral_ad_science_traq_score_option | String |  |
| third_party_verifier_details_integral_ad_science_video_viewability | String |  |
| url_details_negative | Boolean |  |
| url_details_url | String |  |
| user_rewarded_content_details_targeting_option_id | String |  |
| user_rewarded_content_details_user_rewarded_content | String |  |
| video_player_size_details_video_player_size | String |  |
| viewability_details_viewability | String |  |
| youtube_channel_details_channel_id | String |  |
| youtube_channel_details_negative | Boolean |  |
| youtube_video_details_negative | Boolean |  |
| youtube_video_details_video_id | String |  |

## Relationships

- contact_info(first_party_and_partner_audience_id) → first_party_and_partner_audience(id)
- insertion_order(advertiser_id) → advertiser(id)
- insertion_order(campaign_id) → campaign(id)
- hashed_email(first_party_and_partner_audience_id) → contact_info(first_party_and_partner_audience_id)
- hashed_email(contact_info_index) → contact_info(index)
- campaign_budget(campaign_id) → campaign(id)
- ad_url(ad_group_ad_id) → ad_group_ad(id)
- creative(advertiser_id) → advertiser(id)
- insertion_order_budget_segment(insertion_order_id) → insertion_order(id)
- insertion_order_budget_segment(campaign_budget_id) → campaign_budget(id)
- line_item_assigned_google_audience(line_item_assigned_targeting_option_id) → line_item_assigned_targeting_option(id)
- line_item_assigned_google_audience(line_item_id) → line_item(id)
- line_item_assigned_google_audience(google_audience_id) → google_audience(id)
- ad_group(advertiser_id) → advertiser(id)
- ad_group(line_item_id) → line_item(id)
- inventory_source(read_write_accessors_partner_id) → partner(id)
- line_item_viewability_vendor_config(line_item_id) → line_item(id)
- line_item_brand_lift_vendor_config(line_item_id) → line_item(id)
- ad_group_ad(advertiser_id) → advertiser(id)
- ad_group_ad(ad_group_id) → ad_group(id)
- ad_group_ad(display_video_source_ad_creative_id) → creative(id)
- inventory_source_accessors_advertiser(inventory_source_id) → inventory_source(id)
- inventory_source_accessors_advertiser(advertiser_id) → advertiser(id)
- campaign(advertiser_id) → advertiser(id)
- inventory_source_read_advertiser(inventory_source_id) → inventory_source(id)
- inventory_source_read_advertiser(advertiser_id) → advertiser(id)
- line_item_related_video(line_item_id) → line_item(id)
- first_party_and_partner_audience(id) → first_party_and_partner_audience(id)
- inventory_source_read_partner(inventory_source_id) → inventory_source(id)
- inventory_source_read_partner(partner_id) → partner(id)
- line_item_assigned_first_party_and_partner_audience(line_item_assigned_targeting_option_id) → line_item_assigned_targeting_option(id)
- line_item_assigned_first_party_and_partner_audience(line_item_id) → line_item(id)
- line_item_assigned_first_party_and_partner_audience(first_party_and_partner_audience_id) → first_party_and_partner_audience(id)
- line_item_assigned_targeting_option(line_item_id) → line_item(id)
- line_item_assigned_targeting_option(channel_details_channel_id) → channel(id)
- line_item_assigned_targeting_option(inventory_source_group_details_inventory_source_group_id) → inventory_source_group(id)
- zip_code(first_party_and_partner_audience_id) → contact_info(first_party_and_partner_audience_id)
- zip_code(contact_info_index) → contact_info(index)
- line_item_floodlight_activity_config(line_item_id) → line_item(id)
- advertiser(partner_id) → partner(id)
- line_item_creative(creative_id) → creative(id)
- line_item_creative(line_item_id) → line_item(id)
- inventory_source_creative_config(inventory_source_id) → inventory_source(id)
- line_item_warning_message(line_item_id) → line_item(id)
- line_item(advertiser_id) → advertiser(id)
- line_item(campaign_id) → campaign(id)
- line_item(insertion_order_id) → insertion_order(id)
- line_item_assigned_custom_list(line_item_assigned_targeting_option_id) → line_item_assigned_targeting_option(id)
- line_item_assigned_custom_list(line_item_id) → line_item(id)
- line_item_assigned_custom_list(custom_list_id) → custom_list(id)
- line_item_brand_safety_vendor_config(line_item_id) → line_item(id)
- assigned_first_party_and_partner_audience(ad_group_assigned_targeting_option_id) → ad_group_assigned_targeting_option(id)
- assigned_first_party_and_partner_audience(ad_group_id) → ad_group_assigned_targeting_option(ad_group_id)
- assigned_first_party_and_partner_audience(first_party_and_partner_audience_id) → first_party_and_partner_audience(id)
- line_item_partner_cost(line_item_id) → line_item(id)
- line_item_reach_vendor_config(line_item_id) → line_item(id)
- line_item_video_ad_sequence_step(ad_group_id) → ad_group(id)
- line_item_video_ad_sequence_step(line_item_id) → line_item(id)
- insertion_order_partner_cost(insertion_order_id) → insertion_order(id)
- hashed_phone_number(first_party_and_partner_audience_id) → contact_info(first_party_and_partner_audience_id)
- hashed_phone_number(contact_info_index) → contact_info(index)
- channel(partner_id) → partner(id)
- channel(advertiser_id) → advertiser(id)
- line_item_assigned_combined_audience(line_item_assigned_targeting_option_id) → line_item_assigned_targeting_option(id)
- line_item_assigned_combined_audience(line_item_id) → line_item(id)
- line_item_assigned_combined_audience(combined_audience_id) → combined_audience(id)
- ad_group_assigned_targeting_option(ad_group_id) → ad_group(id)
- ad_group_assigned_targeting_option(inventory_source_group_details_inventory_source_group_id) → inventory_source_group(id)