Google Display & Video 360

Explore the interactive ERD

Table & Field Reference

contact_info

Column	Type	Keys
`index`	Int	PK
`first_party_and_partner_audience_id`	String	PKFK
`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	PKFK
`first_party_and_partner_audience_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`line_item_assigned_targeting_option_id`	String	PKFK
`line_item_id`	String	PKFK
`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	PKFK
`placement_id`	String
`vendor`	String

line_item_brand_lift_vendor_config

Column	Type	Keys
`index`	Int	PK
`line_item_id`	String	PKFK
`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	PKFK
`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	PKFK
`advertiser_id`	String	FK

line_item_related_video

Column	Type	Keys
`index`	Int	PK
`line_item_id`	String	PKFK
`related_video_id`	String

first_party_and_partner_audience

Column	Type	Keys
`id`	String	PKFK
`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	PKFK
`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	PKFK
`line_item_assigned_targeting_option_id`	String	PKFK
`line_item_id`	String	PKFK
`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	PKFK
`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	PKFK
`first_party_and_partner_audience_id`	String	PKFK
`zip_code`	String

line_item_floodlight_activity_config

Column	Type	Keys
`index`	Int	PK
`line_item_id`	String	PKFK
`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	PKFK
`creative_id`	String	FK

inventory_source_creative_config

Column	Type	Keys
`index`	Int	PK
`inventory_source_id`	String	PKFK
`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	PKFK
`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	PKFK
`line_item_assigned_targeting_option_id`	String	PKFK
`line_item_id`	String	PKFK
`is_included`	Boolean

line_item_brand_safety_vendor_config

Column	Type	Keys
`index`	Int	PK
`line_item_id`	String	PKFK
`placement_id`	String
`vendor`	String

assigned_first_party_and_partner_audience

Column	Type	Keys
`recency`	String	PK
`ad_group_assigned_targeting_option_id`	String	PKFK
`ad_group_id`	String	PKFK
`first_party_and_partner_audience_id`	String	PKFK
`is_included`	Boolean

line_item_partner_cost

Column	Type	Keys
`index`	Int	PK
`line_item_id`	String	PKFK
`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	PKFK
`placement_id`	String
`vendor`	String

line_item_video_ad_sequence_step

Column	Type	Keys
`index`	Int	PK
`line_item_id`	String	PKFK
`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	PKFK
`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	PKFK
`first_party_and_partner_audience_id`	String	PKFK
`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	PKFK
`line_item_assigned_targeting_option_id`	String	PKFK
`line_item_id`	String	PKFK
`is_included`	Boolean

ad_group_assigned_targeting_option

Column	Type	Keys
`id`	String	PK
`ad_group_id`	String	PKFK
`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