# Google Campaign Manager 360 schema ERD

Table and field reference for the Fivetran Google Campaign Manager 360 connector.

## 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 | PK, FK |
| placement_id | String | PK, FK |
| active | Boolean |  |
| ssl_required | Boolean |  |

### ad_region

| Column | Type | Keys |
| --- | --- | --- |
| ad_id | String | PK, FK |
| region_id | String | PK, FK |

### 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 | PK, FK |
| metro_id | String | PK, FK |

### 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 | PK, FK |
| city_id | String | PK, FK |

### creative_field_assignment

| Column | Type | Keys |
| --- | --- | --- |
| creative_field_id | String | PK, FK |
| creative_field_value_id | String | PK, FK |
| creative_id | String | PK, FK |

### 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 | PK, FK |
| creative_id | String | PK, FK |

### ad_connection_type

| Column | Type | Keys |
| --- | --- | --- |
| ad_id | String | PK, FK |
| connection_type_id | String | PK, FK |

### 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 | PK, FK |
| language_id | String | PK, FK |

### 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 | PK, FK |
| postal_code_id | String | PK, FK |

### 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 | PK, FK |
| operating_system_id | String | PK, FK |

### connection_type

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

### ad_mobile_carrier

| Column | Type | Keys |
| --- | --- | --- |
| ad_id | String | PK, FK |
| mobile_carrier_id | String | PK, FK |

### ad_operating_system_version

| Column | Type | Keys |
| --- | --- | --- |
| ad_id | String | PK, FK |
| operating_system_version_id | String | PK, FK |

### 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 | PK, FK |
| country_id | String | PK, FK |

### 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 | PK, FK |
| creative_id | String | PK, FK |
| 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 | PK, FK |
| browser_id | String | PK, FK |

### 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 | PK, FK |
| platform_type_id | String | PK, FK |

### 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 |  |

### ad

| 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 |  |

## Relationships

- audience_segment(audience_segment_group_id) → audience_segment_group(id)
- placement_assignment(ad_id) → ad(id)
- placement_assignment(placement_id) → placement(id)
- ad_region(ad_id) → ad(id)
- ad_region(region_id) → region(dart_id)
- ad_metro(ad_id) → ad(id)
- ad_metro(metro_id) → metro(dma_id)
- creative_field(account_id) → account(id)
- creative_field(advertiser_id) → advertiser(id)
- ad_city(ad_id) → ad(id)
- ad_city(city_id) → city(dart_id)
- creative_field_assignment(creative_id) → creative(id)
- creative_field_assignment(creative_field_id) → creative_field(id)
- creative_field_assignment(creative_field_value_id) → creative_field_value(id)
- placement(account_id) → account(id)
- placement(advertiser_id) → advertiser(id)
- placement(campaign_id) → campaign(id)
- placement(site_id) → site(id)
- site(account_id) → account(id)
- audience_segment_group(campaign_id) → campaign(id)
- third_party_tracking_url(creative_id) → creative(id)
- pricing_period(placement_id) → placement(id)
- companion_creative(creative_id) → creative(id)
- companion_creative(companion_creative_id) → creative_asset(id)
- ad_connection_type(ad_id) → ad(id)
- ad_connection_type(connection_type_id) → connection_type(id)
- operating_system_version(operating_system_dart_id) → operating_system(dart_id)
- ad_language(ad_id) → ad(id)
- ad_language(language_id) → languages(id)
- ad_postal_code(ad_id) → ad(id)
- ad_postal_code(postal_code_id) → postal_code(id)
- creative(advertiser_id) → advertiser(id)
- creative(account_id) → account(id)
- ad_operating_system(ad_id) → ad(id)
- ad_operating_system(operating_system_id) → operating_system(dart_id)
- ad_mobile_carrier(ad_id) → ad(id)
- ad_mobile_carrier(mobile_carrier_id) → mobile_carrier(id)
- ad_operating_system_version(ad_id) → ad(id)
- ad_operating_system_version(operating_system_version_id) → operating_system_version(id)
- region(country_dart_id) → country(dart_id)
- ad_country(ad_id) → ad(id)
- ad_country(country_id) → country(dart_id)
- metro(country_dart_id) → country(dart_id)
- account(country_id) → country(dart_id)
- creative_assignment(creative_id) → creative(id)
- creative_assignment(ad_id) → ad(id)
- campaign(account_id) → account(id)
- campaign(advertiser_id) → advertiser(id)
- ad_browser(ad_id) → ad(id)
- ad_browser(browser_id) → browser(browser_version_id)
- creative_asset(creative_id) → creative(id)
- city(country_dart_id) → country(dart_id)
- city(region_dart_id) → region(dart_id)
- city(metro_dma_id) → metro(dma_id)
- ad_platform_type(ad_id) → ad(id)
- ad_platform_type(platform_type_id) → platform_type(id)
- postal_code(country_dart_id) → country(dart_id)
- mobile_carrier(country_dart_id) → country(dart_id)
- ad(campaign_id) → campaign(id)
- ad(advertiser_id) → advertiser(id)
- ad(account_id) → account(id)
- ad(audience_segment_id) → audience_segment(id)
- advertiser(account_id) → account(id)