Google Campaign Manager 360

Explore the interactive ERD

Table & Field Reference

languages

Column	Type	Keys
`id`	String	PK
`kind`	String
`language_code`	String
`name`	String

audience_segment

Column	Type	Keys
`id`	String	PK
`audience_segment_group_id`	String	FK
`allocation`	Int
`name`	String

placement_assignment

Column	Type	Keys
`ad_id`	String	PKFK
`placement_id`	String	PKFK
`active`	Boolean
`ssl_required`	Boolean

ad_region

Column	Type	Keys
`ad_id`	String	PKFK
`region_id`	String	PKFK

browser

Column	Type	Keys
`browser_version_id`	String	PK
`dart_id`	String
`kind`	String
`major_version`	String
`minor_version`	String
`name`	String

ad_metro

Column	Type	Keys
`ad_id`	String	PKFK
`metro_id`	String	PKFK

creative_field

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`account_id`	String	FK
`advertiser_id`	String	FK
`kind`	String
`name`	String
`subaccount_id`	String

ad_city

Column	Type	Keys
`ad_id`	String	PKFK
`city_id`	String	PKFK

creative_field_assignment

Column	Type	Keys
`creative_field_id`	String	PKFK
`creative_field_value_id`	String	PKFK
`creative_id`	String	PKFK

creative_field_value

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`kind`	String
`value`	String

placement

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`account_id`	String	FK
`advertiser_id`	String	FK
`campaign_id`	String	FK
`site_id`	String	FK
`active_status`	String
`ad_blocking_opt_out`	Boolean
`ad_serving_platform_id`	String
`comment`	String
`compatibility`	String
`content_category_id`	String
`create_info_time`	String
`directory_site_id`	String
`external_id`	String
`id_dimension_value_dimension_name`	String
`id_dimension_value_etag`	String
`id_dimension_value_id`	String
`id_dimension_value_kind`	String
`id_dimension_value_match_type`	String
`id_dimension_value_value`	String
`is_primary`	Boolean
`key_name`	String
`kind`	String
`last_modified_info_time`	String
`lookback_configuration_click_duration`	Int
`lookback_configuration_post_impression_activities_duration`	Int
`name`	String
`partner_wrapping_data_link_status`	String
`partner_wrapping_data_measurement_partner`	String
`partner_wrapping_data_tag_wrapping_mode`	String
`partner_wrapping_data_wrapped_tag`	String
`payment_approved`	Boolean
`payment_source`	String
`placement_group_id`	String
`placement_strategy_id`	String
`pricing_schedule_cap_cost_option`	String
`pricing_schedule_end_date`	String
`pricing_schedule_flighted`	Boolean
`pricing_schedule_floodlight_activity_id`	String
`pricing_schedule_pricing_type`	String
`pricing_schedule_start_date`	String
`pricing_schedule_testing_start_date`	String
`publisher_update_info_time`	String
`site_served`	Boolean
`size_height`	Int
`size_iab`	Boolean
`size_id`	String
`size_kind`	String
`size_width`	Int
`ssl_required`	Boolean
`status`	String
`subaccount_id`	String
`tag_setting_additional_key_values`	String
`tag_setting_include_click_through_urls`	Boolean
`tag_setting_include_click_tracking`	Boolean
`tag_setting_keyword_option`	String
`video_active_view_opt_out`	Boolean
`video_settings_companion_settings_companions_disabled`	Boolean
`video_settings_companion_settings_image_only`	Boolean
`video_settings_companion_settings_kind`	String
`video_settings_duration_seconds`	Int
`video_settings_kind`	String
`video_settings_oba_enabled`	Boolean
`video_settings_oba_settings_icon_click_through_url`	String
`video_settings_oba_settings_icon_click_tracking_url`	String
`video_settings_oba_settings_icon_view_tracking_url`	String
`video_settings_oba_settings_program`	String
`video_settings_oba_settings_resource_url`	String
`video_settings_oba_settings_size_height`	Int
`video_settings_oba_settings_size_iab`	Boolean
`video_settings_oba_settings_size_id`	String
`video_settings_oba_settings_size_kind`	String
`video_settings_oba_settings_size_width`	Int
`video_settings_oba_settings_x_position`	String
`video_settings_oba_settings_y_position`	String
`video_settings_orientation`	String
`video_settings_publisher_specification_id`	String
`video_settings_skippable_settings_kind`	String
`video_settings_skippable_settings_progress_offset_offset_percentage`	Int
`video_settings_skippable_settings_progress_offset_offset_seconds`	Int
`video_settings_skippable_settings_skip_offset_offset_percentage`	Int
`video_settings_skippable_settings_skip_offset_offset_seconds`	Int
`video_settings_skippable_settings_skippable`	Boolean
`video_settings_transcode_settings_enabled_video_formats`	String
`video_settings_transcode_settings_kind`	String
`vpaid_adapter_choice`	String
`wrapping_opt_out`	Boolean

site

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`account_id`	String	FK
`ad_serving_platform_id`	String
`approved`	Boolean
`directory_site_id`	String
`id_dimension_value_dimension_name`	String
`id_dimension_value_etag`	String
`id_dimension_value_id`	String
`id_dimension_value_kind`	String
`id_dimension_value_match_type`	String
`id_dimension_value_value`	String
`key_name`	String
`kind`	String
`name`	String
`site_settings_active_view_opt_out`	Boolean
`site_settings_ad_blocking_opt_out`	Boolean
`site_settings_disable_new_cookie`	Boolean
`site_settings_tag_setting_additional_key_values`	String
`site_settings_tag_setting_include_click_through_urls`	Boolean
`site_settings_tag_setting_include_click_tracking`	Boolean
`site_settings_tag_setting_keyword_option`	String
`site_settings_video_active_view_opt_out_template`	Boolean
`site_settings_vpaid_adapter_choice_template`	String
`subaccount_id`	String

audience_segment_group

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`name`	String

third_party_tracking_url

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	String	FK
`third_party_url_type`	String
`url`	String

pricing_period

Column	Type	Keys
`_fivetran_id`	String	PK
`placement_id`	String	FK
`end_date`	String
`pricing_comment`	String
`rate_or_cost_nanos`	String
`start_date`	String
`units`	String

country

Column	Type	Keys
`dart_id`	String	PK
`country_code`	String
`kind`	String
`name`	String
`ssl_enabled`	Boolean

companion_creative

Column	Type	Keys
`companion_creative_id`	String	PKFK
`creative_id`	String	PKFK

ad_connection_type

Column	Type	Keys
`ad_id`	String	PKFK
`connection_type_id`	String	PKFK

operating_system_version

Column	Type	Keys
`id`	String	PK
`operating_system_dart_id`	String	FK
`kind`	String
`major_version`	String
`minor_version`	String
`name`	String
`operating_system_desktop`	Boolean
`operating_system_kind`	String
`operating_system_mobile`	Boolean
`operating_system_name`	String

ad_language

Column	Type	Keys
`ad_id`	String	PKFK
`language_id`	String	PKFK

operating_system

Column	Type	Keys
`dart_id`	String	PK
`desktop`	Boolean
`kind`	String
`mobile`	Boolean
`name`	String

ad_postal_code

Column	Type	Keys
`ad_id`	String	PKFK
`postal_code_id`	String	PKFK

creative

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`account_id`	String	FK
`advertiser_id`	String	FK
`active`	Boolean
`ad_parameters`	String
`allow_script_access`	Boolean
`archived`	Boolean
`artwork_type`	String
`authoring_source`	String
`authoring_tool`	String
`auto_advance_images`	Boolean
`background_color`	String
`backup_image_click_through_url_computed_click_through_url`	String
`backup_image_click_through_url_custom_click_through_url`	String
`backup_image_click_through_url_landing_page_id`	String
`backup_image_reporting_label`	String
`backup_image_target_window_custom_html`	String
`backup_image_target_window_target_window_option`	String
`commercial_id`	String
`convert_flash_to_html_5`	Boolean
`creative_asset_selection_default_asset_id`	String
`dynamic_asset_selection`	Boolean
`fs_command_left`	Int
`fs_command_position_option`	String
`fs_command_top`	Int
`fs_command_window_height`	Int
`fs_command_window_width`	Int
`html_code`	String
`html_code_locked`	Boolean
`id_dimension_value_dimension_name`	String
`id_dimension_value_etag`	String
`id_dimension_value_id`	String
`id_dimension_value_kind`	String
`id_dimension_value_match_type`	String
`id_dimension_value_value`	String
`kind`	String
`last_modified_info_time`	String
`latest_trafficked_creative_id`	String
`media_description`	String
`media_duration`	Double
`name`	String
`oba_icon_icon_click_through_url`	String
`oba_icon_icon_click_tracking_url`	String
`oba_icon_icon_view_tracking_url`	String
`oba_icon_program`	String
`oba_icon_resource_url`	String
`oba_icon_size_height`	Int
`oba_icon_size_iab`	Boolean
`oba_icon_size_id`	String
`oba_icon_size_kind`	String
`oba_icon_size_width`	Int
`oba_icon_x_position`	String
`oba_icon_y_position`	String
`override_css`	String
`progress_offset_offset_percentage`	Int
`progress_offset_offset_seconds`	Int
`redirect_url`	String
`rendering_id`	String
`required_flash_plugin_version`	String
`required_flash_version`	Int
`size_height`	Int
`size_iab`	Boolean
`size_id`	String
`size_kind`	String
`size_width`	Int
`skip_offset_offset_percentage`	Int
`skip_offset_offset_seconds`	Int
`skippable`	Boolean
`ssl_compliant`	Boolean
`ssl_override`	Boolean
`studio_advertiser_id`	String
`studio_creative_id`	String
`studio_trafficked_creative_id`	String
`subaccount_id`	String
`third_party_backup_image_impressions_url`	String
`third_party_rich_media_impressions_url`	String
`total_file_size`	String
`type`	String
`universal_ad_id_registry`	String
`universal_ad_id_value`	String
`version`	Int

ad_operating_system

Column	Type	Keys
`ad_id`	String	PKFK
`operating_system_id`	String	PKFK

connection_type

Column	Type	Keys
`id`	String	PK
`kind`	String
`name`	String

ad_mobile_carrier

Column	Type	Keys
`ad_id`	String	PKFK
`mobile_carrier_id`	String	PKFK

ad_operating_system_version

Column	Type	Keys
`ad_id`	String	PKFK
`operating_system_version_id`	String	PKFK

region

Column	Type	Keys
`dart_id`	String	PK
`country_dart_id`	String	FK
`country_code`	String
`kind`	String
`name`	String
`region_code`	String

ad_country

Column	Type	Keys
`ad_id`	String	PKFK
`country_id`	String	PKFK

metro

Column	Type	Keys
`dma_id`	String	PK
`country_dart_id`	String	FK
`country_code`	String
`dart_id`	String
`kind`	String
`metro_code`	String
`name`	String

account

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`country_id`	String	FK
`account_profile`	String
`active`	Boolean
`active_ads_limit_tier`	String
`active_view_opt_out`	Boolean
`currency_id`	String
`default_creative_size_id`	String
`description`	String
`kind`	String
`locale`	String
`maximum_image_size`	String
`name`	String
`nielsen_ocr_enabled`	Boolean
`reports_configuration_exposure_to_conversion_enabled`	Boolean
`reports_configuration_lookback_configuration_click_duration`	Int
`reports_configuration_lookback_configuration_post_impression_activities_duration`	Int
`reports_configuration_report_generation_time_zone_id`	String
`share_reports_with_twitter`	Boolean
`teaser_size_limit`	String

creative_assignment

Column	Type	Keys
`ad_id`	String	PKFK
`creative_id`	String	PKFK
`active`	Boolean
`apply_event_tags`	Boolean
`click_through_url_computed_click_through_url`	String
`click_through_url_custom_click_through_url`	String
`click_through_url_default_landing_page`	Boolean
`click_through_url_landing_page_id`	String
`end_time`	String
`sequence`	Int
`ssl_compliant`	Boolean
`start_time`	String
`weight`	Int

campaign

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`account_id`	String	FK
`advertiser_id`	String	FK
`ad_blocking_configuration_enabled`	Boolean
`advertiser_group_id`	String
`archived`	Boolean
`billing_invoice_code`	String
`click_through_url_suffix_properties_click_through_url_suffix`	String
`click_through_url_suffix_properties_override_inherited_suffix`	Boolean
`comment`	String
`create_info_time`	String
`default_click_through_event_tag_properties_default_click_through_event_tag_id`	String
`default_click_through_event_tag_properties_override_inherited_event_tag`	Boolean
`default_landing_page_id`	String
`end_date`	String
`external_id`	String
`id_dimension_value_dimension_name`	String
`id_dimension_value_etag`	String
`id_dimension_value_id`	String
`id_dimension_value_kind`	String
`id_dimension_value_match_type`	String
`id_dimension_value_value`	String
`kind`	String
`last_modified_info_time`	String
`measurement_partner_link_link_status`	String
`measurement_partner_link_measurement_partner`	String
`measurement_partner_link_partner_campaign_id`	String
`name`	String
`start_date`	String
`subaccount_id`	String

ad_browser

Column	Type	Keys
`ad_id`	String	PKFK
`browser_id`	String	PKFK

creative_asset

Column	Type	Keys
`id`	String	PK
`creative_id`	String	FK
`action_script_3`	Boolean
`active`	Boolean
`alignment`	String
`artwork_type`	String
`asset_identifier_name`	String
`asset_identifier_type`	String
`audio_bit_rate`	Int
`audio_sample_rate`	Int
`backup_image_exit_advertiser_custom_event_id`	String
`backup_image_exit_advertiser_custom_event_name`	String
`backup_image_exit_advertiser_custom_event_type`	String
`backup_image_exit_artwork_label`	String
`backup_image_exit_artwork_type`	String
`backup_image_exit_exit_click_through_url_computed_click_through_url`	String
`backup_image_exit_exit_click_through_url_custom_click_through_url`	String
`backup_image_exit_exit_click_through_url_landing_page_id`	String
`backup_image_exit_id`	String
`backup_image_exit_popup_window_properties_dimension_height`	Int
`backup_image_exit_popup_window_properties_dimension_iab`	Boolean
`backup_image_exit_popup_window_properties_dimension_id`	String
`backup_image_exit_popup_window_properties_dimension_kind`	String
`backup_image_exit_popup_window_properties_dimension_width`	Int
`backup_image_exit_popup_window_properties_offset_left`	Int
`backup_image_exit_popup_window_properties_offset_top`	Int
`backup_image_exit_popup_window_properties_position_type`	String
`backup_image_exit_popup_window_properties_show_address_bar`	Boolean
`backup_image_exit_popup_window_properties_show_menu_bar`	Boolean
`backup_image_exit_popup_window_properties_show_scroll_bar`	Boolean
`backup_image_exit_popup_window_properties_show_status_bar`	Boolean
`backup_image_exit_popup_window_properties_show_tool_bar`	Boolean
`backup_image_exit_popup_window_properties_title`	String
`backup_image_exit_target_type`	String
`backup_image_exit_video_reporting_id`	String
`bit_rate`	Int
`child_asset_type`	String
`collapsed_size_height`	Int
`collapsed_size_iab`	Boolean
`collapsed_size_id`	String
`collapsed_size_kind`	String
`collapsed_size_width`	Int
`custom_start_time_value`	Int
`display_type`	String
`duration`	Int
`duration_type`	String
`expanded_dimension_height`	Int
`expanded_dimension_iab`	Boolean
`expanded_dimension_id`	String
`expanded_dimension_kind`	String
`expanded_dimension_width`	Int
`file_size`	String
`flash_version`	Int
`frame_rate`	Double
`hide_flash_objects`	Boolean
`hide_selection_boxes`	Boolean
`horizontally_locked`	Boolean
`id_dimension_value_dimension_name`	String
`id_dimension_value_etag`	String
`id_dimension_value_id`	String
`id_dimension_value_kind`	String
`id_dimension_value_match_type`	String
`id_dimension_value_value`	String
`media_duration`	Double
`mime_type`	String
`offset_left`	Int
`offset_top`	Int
`orientation`	String
`original_backup`	Boolean
`polite_load`	Boolean
`position_left`	Int
`position_left_unit`	String
`position_top`	Int
`position_top_unit`	String
`progressive_serving_url`	String
`pushdown`	Boolean
`pushdown_duration`	Double
`role`	String
`size_height`	Int
`size_iab`	Boolean
`size_id`	String
`size_kind`	String
`size_width`	Int
`ssl_compliant`	Boolean
`start_time_type`	String
`streaming_serving_url`	String
`transparency`	Boolean
`vertically_locked`	Boolean
`window_mode`	String
`z_index`	Int
`zip_filename`	String
`zip_filesize`	String

city

Column	Type	Keys
`dart_id`	String	PK
`country_dart_id`	String	FK
`metro_dma_id`	String	FK
`region_dart_id`	String	FK
`country_code`	String
`kind`	String
`metro_code`	String
`name`	String
`region_code`	String

ad_platform_type

Column	Type	Keys
`ad_id`	String	PKFK
`platform_type_id`	String	PKFK

postal_code

Column	Type	Keys
`id`	String	PK
`country_dart_id`	String	FK
`code`	String
`country_code`	String
`kind`	String

mobile_carrier

Column	Type	Keys
`id`	String	PK
`country_dart_id`	String	FK
`country_code`	String
`kind`	String
`name`	String

platform_type

Column	Type	Keys
`id`	String	PK
`kind`	String
`name`	String

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`account_id`	String	FK
`advertiser_id`	String	FK
`audience_segment_id`	String	FK
`campaign_id`	String	FK
`active`	Boolean
`archived`	Boolean
`click_through_url_computed_click_through_url`	String
`click_through_url_custom_click_through_url`	String
`click_through_url_default_landing_page`	Boolean
`click_through_url_landing_page_id`	String
`click_through_url_suffix_properties_click_through_url_suffix`	String
`click_through_url_suffix_properties_override_inherited_suffix`	Boolean
`comments`	String
`compatibility`	String
`create_info_time`	String
`creative_rotation_creative_optimization_configuration_id`	String
`creative_rotation_type`	String
`creative_rotation_weight_calculation_strategy`	String
`delivery_schedule_frequency_cap_duration`	String
`delivery_schedule_frequency_cap_impressions`	String
`delivery_schedule_hard_cutoff`	Boolean
`delivery_schedule_impression_ratio`	String
`delivery_schedule_priority`	String
`dynamic_click_tracker`	Boolean
`end_time`	String
`geo_targeting_exclude_countries`	Boolean
`id_dimension_value_dimension_name`	String
`id_dimension_value_etag`	String
`id_dimension_value_id`	String
`id_dimension_value_kind`	String
`id_dimension_value_match_type`	String
`id_dimension_value_value`	String
`key_value_targeting_expression_expression`	String
`kind`	String
`last_modified_info_time`	String
`name`	String
`remarketing_list_expression_expression`	String
`size_height`	Int
`size_iab`	Boolean
`size_id`	String
`size_kind`	String
`size_width`	Int
`ssl_compliant`	Boolean
`ssl_required`	Boolean
`start_time`	String
`subaccount_id`	String
`targeting_template_id`	String
`type`	String

advertiser

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PK
`account_id`	String	FK
`advertiser_group_id`	String
`click_through_url_suffix`	String
`default_click_through_event_tag_id`	String
`default_email`	String
`floodlight_configuration_id`	String
`id_dimension_value_dimension_name`	String
`id_dimension_value_etag`	String
`id_dimension_value_id`	String
`id_dimension_value_kind`	String
`id_dimension_value_match_type`	String
`id_dimension_value_value`	String
`kind`	String
`measurement_partner_link_link_status`	String
`measurement_partner_link_measurement_partner`	String
`measurement_partner_link_partner_advertiser_id`	String
`name`	String
`original_floodlight_configuration_id`	String
`status`	String
`subaccount_id`	String
`suspended`	Boolean