# Google Ad Manager schema ERD

Table and field reference for the Fivetran Google Ad Manager connector.

## Table & Field Reference

### order_applied_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| order_id | Long | PK, FK |
| is_negated | Boolean |  |

### creative_tracking_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| key | String | PK |
| creative_id | Long | PK, FK |
| value | String |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| address | String |  |
| applied_team_ids | Json |  |
| comment | String |  |
| credit_status | String |  |
| email | String |  |
| external_id | String |  |
| fax_phone | String |  |
| last_modified_date_time | Instant |  |
| name | String |  |
| primary_contact_id | Long |  |
| primary_phone | String |  |
| third_party_company_id | Int |  |
| type | String |  |
| child_publisher_** |  |  |
| viewability_provider_** |  |  |

### line_item_frequency_cap

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | Long | PK, FK |
| max_impressions | Int |  |
| num_time_units | Int |  |
| time_unit | String |  |

### order_applied_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Long | PK |
| order_id | Long | PK, FK |

### creative_applied_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| creative_id | Long | PK, FK |
| is_negated | Boolean |  |

### creative_third_party_company

| Column | Type | Keys |
| --- | --- | --- |
| third_party_company_id | Long | PK |
| creative_id | Long | PK, FK |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| advertiser_id | Long | FK |
| agency_id | Long | FK |
| creator_id | Long | FK |
| salesperson_id | Long | FK |
| trafficker_id | Long | FK |
| currency_code | String |  |
| end_date_time | Instant |  |
| external_order_id | Int |  |
| is_archived | Boolean |  |
| is_programmatic | Boolean |  |
| last_modified_by_app | String |  |
| last_modified_date_time | Instant |  |
| name | String |  |
| notes | String |  |
| po_number | String |  |
| start_date_time | Instant |  |
| status | String |  |
| total_budget_currency_code | String |  |
| total_budget_micro_amount | Long |  |
| total_clicks_delivered | Long |  |
| total_impressions_delivered | Long |  |
| total_viewable_impressions_delivered | Long |  |
| unlimited_end_date_time | Boolean |  |

### targeting_preset_geo_excluded_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| targeting_preset_id | Long | PK, FK |
| canonical_parent_id | Int |  |
| display_name | String |  |
| type | String |  |

### order_secondary_trafficker

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Long | PK, FK |
| user_id | Long | PK, FK |

### order_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_id | Long | PK |
| order_id | Long | PK, FK |

### line_item_applied_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| line_item_id | Long | PK, FK |
| is_negated | Boolean |  |

### ad_unit_size

| Column | Type | Keys |
| --- | --- | --- |
| environment_type | String | PK |
| index | Int | PK |
| ad_unit_id | String | PK, FK |
| full_display_string | String |  |
| is_audio | Boolean |  |
| size_height | Int |  |
| size_is_aspect_ratio | Boolean |  |
| size_width | Int |  |

### line_item_secondary_goal

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | Long | PK, FK |
| goal_type | String |  |
| unit_type | String |  |
| units | Long |  |

### line_item_creative_association_size

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| line_item_id | Long | PK, FK |
| height | Int |  |
| is_aspect_ratio | Boolean |  |
| width | Int |  |

### order_agency_contact

| Column | Type | Keys |
| --- | --- | --- |
| agency_contact_id | Long | PK |
| order_id | Long | PK, FK |

### line_item_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_id | Long | PK |
| line_item_id | Long | PK, FK |
| custom_field_option_id | Long |  |
| type | String |  |
| value | String |  |
| value_type | String |  |

### ad_unit_effective_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Long | PK |
| ad_unit_id | String | PK, FK |

### ad_unit_applied_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Long | PK |
| ad_unit_id | String | PK, FK |

### placement_targeted_ad_unit

| Column | Type | Keys |
| --- | --- | --- |
| ad_unit_id | String | PK, FK |
| placement_id | Long | PK, FK |

### creative_audio_asset

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| redirect_url | String |  |
| metadata_** |  |  |

### creative_video_asset

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| redirect_url | String |  |
| metadata_** |  |  |

### line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| allow_overbook | Boolean |  |
| allowed_formats | String |  |
| auto_extension_days | Int |  |
| budget_currency_code | String |  |
| budget_micro_amount | Long |  |
| child_content_eligibility | String |  |
| companion_delivery_option | String |  |
| competitive_constraint_scope | String |  |
| contracted_units_bought | Long |  |
| cost_per_unit_currency_code | String |  |
| cost_per_unit_micro_amount | Long |  |
| cost_type | String |  |
| creation_date_time | Instant |  |
| creative_rotation_type | String |  |
| custom_pacing_curve_custom_pacing_goal_unit | String |  |
| custom_vast_extension | String |  |
| deal_info_external_deal_id | Long |  |
| delivery_forecast_source | String |  |
| delivery_indicator_actual_delivery_percentage | Double |  |
| delivery_indicator_expected_delivery_percentage | Double |  |
| delivery_rate_type | String |  |
| disable_same_advertiser_competitive_exclusion | Boolean |  |
| discount | Double |  |
| discount_type | String |  |
| end_date_time | Instant |  |
| environment_type | String |  |
| external_id | String |  |
| is_archived | Boolean |  |
| is_missing_creatives | Boolean |  |
| last_modified_by_app | String |  |
| last_modified_date_time | Instant |  |
| line_item_type | String |  |
| name | String |  |
| notes | String |  |
| order_id | Long |  |
| order_name | String |  |
| primary_goal_goal_type | String |  |
| primary_goal_unit_type | String |  |
| primary_goal_units | Long |  |
| priority | Int |  |
| programmatic_creative_source | String |  |
| repeated_creative_serving_enabled | Boolean |  |
| reservation_status | String |  |
| reserve_at_creation | Boolean |  |
| roadblocking_type | String |  |
| skip_cross_selling_rule_warning_checks | Boolean |  |
| skip_inventory_check | Boolean |  |
| skippable_ad_type | String |  |
| start_date_time | Instant |  |
| start_date_time_type | String |  |
| status | String |  |
| unlimited_end_date_time | Boolean |  |
| value_cost_per_unit_currency_code | String |  |
| value_cost_per_unit_micro_amount | Long |  |
| video_max_duration | Long |  |
| web_property_code | String |  |
| youtube_kids_restricted | Boolean |  |
| grp_settings_** |  |  |
| stats_** |  |  |
| targeting_** |  |  |
| third_party_ms_** |  |  |

### targeting_preset_geo_targeted_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| targeting_preset_id | Long | PK, FK |
| canonical_parent_id | Int |  |
| display_name | String |  |
| type | String |  |

### order_advertiser_contact

| Column | Type | Keys |
| --- | --- | --- |
| advertiser_contact_id | Long | PK |
| order_id | Long | PK, FK |

### line_item_effective_applied_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| line_item_id | Long | PK, FK |
| is_negated | Boolean |  |

### ad_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| parent_id | String | FK |
| ad_unit_code | String |  |
| application_id | Long |  |
| description | String |  |
| explicitly_targeted | Boolean |  |
| external_set_top_box_channel_id | String |  |
| has_children | Boolean |  |
| is_fluid | Boolean |  |
| is_interstitial | Boolean |  |
| is_native | Boolean |  |
| is_set_top_box_enabled | Boolean |  |
| last_modified_date_time | Instant |  |
| name | String |  |
| refresh_rate | Int |  |
| smart_size_mode | String |  |
| status | String |  |
| target_window | String |  |
| ad_sense_settings_** |  |  |

### ad_unit_applied_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| ad_unit_id | String | PK, FK |
| is_negated | Boolean |  |

### ad_unit_effective_applied_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| ad_unit_id | String | PK, FK |
| is_negated | Boolean |  |

### targeting_preset_inventory_targeted_ad_unit

| Column | Type | Keys |
| --- | --- | --- |
| ad_unit_id | String | PK |
| targeting_preset_id | Long | PK, FK |
| include_descendants | Boolean |  |

### ad_unit_parent_path

| Column | Type | Keys |
| --- | --- | --- |
| parent_ad_unit_id | String | PK |
| ad_unit_id | String | PK, FK |
| parent_ad_unit_code | String |  |
| parent_ad_unit_name | String |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| external_id | String |  |
| is_active | Boolean |  |
| is_service_account | Boolean |  |
| name | String |  |
| orders_ui_local_time_zone_id | String |  |
| role_id | Long |  |
| role_name | String |  |

### targeting_preset_inventory_excluded_ad_unit

| Column | Type | Keys |
| --- | --- | --- |
| ad_unit_id | String | PK |
| targeting_preset_id | Long | PK, FK |
| include_descendants | Boolean |  |

### targeting_preset_inventory_targeted_placement_id

| Column | Type | Keys |
| --- | --- | --- |
| placement_id | Long | PK, FK |
| targeting_preset_id | Long | PK, FK |

### targeting_preset

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |
| targeting_** |  |  |

### creative_third_party_impression_tracking_url

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

### line_item_creative_association

| Column | Type | Keys |
| --- | --- | --- |
| creative_id | Long | PK, FK |
| line_item_id | Long | PK, FK |
| creative_set_id | Long |  |
| destination_url | String |  |
| end_date_time | Instant |  |
| last_modified_date_time | Instant |  |
| manual_creative_rotation_weight | Double |  |
| sequential_creative_rotation_index | Int |  |
| start_date_time | Instant |  |
| start_date_time_type | String |  |
| stats_stats_clicks_delivered | Long |  |
| stats_stats_impressions_delivered | Long |  |
| stats_stats_video_completions_delivered | Long |  |
| stats_stats_video_starts_delivered | Long |  |
| stats_stats_viewable_impressions_delivered | Long |  |
| status | String |  |
| targeting_name | String |  |

### creative_asset_property

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| height | Int |  |
| name | String |  |
| total_file_size | Long |  |
| type | String |  |
| url | String |  |
| width | Int |  |

### order_effective_applied_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| order_id | Long | PK, FK |
| is_negated | Boolean |  |

### creative_ad_tag_key

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

### placement

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| description | String |  |
| last_modified_date_time | Instant |  |
| name | String |  |
| placement_code | String |  |
| status | String |  |

### creative

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| advertiser_id | Long | FK |
| ad_badging_enabled | Boolean |  |
| ad_id | String |  |
| ad_id_type | String |  |
| all_impressions_url | String |  |
| allow_duration_override | Boolean |  |
| alt_text | String |  |
| amp_redirect_url | String |  |
| artwork_type | String |  |
| asset_size_height | Int |  |
| asset_size_is_aspect_ratio | Boolean |  |
| asset_size_width | Int |  |
| audio_source_url | String |  |
| backup_image_impressions_url | String |  |
| billing_attribute | String |  |
| click_tracking_url | String |  |
| code_snippet | String |  |
| creative_format | String |  |
| creative_template_id | Long |  |
| custom_parameters | String |  |
| destination_url | String |  |
| destination_url_type | String |  |
| duration | Int |  |
| expanded_snippet | String |  |
| external_asset_id | String |  |
| html_snippet | String |  |
| image_url | String |  |
| internal_redirect_url | String |  |
| is_allows_all_requested_sizes | Boolean |  |
| is_audio | Boolean |  |
| is_interstitial | Boolean |  |
| is_native_eligible | Boolean |  |
| is_safe_frame_compatible | Boolean |  |
| last_modified_date_time | Instant |  |
| license_window_end_date_time | Instant |  |
| license_window_start_date_time | Instant |  |
| locked_orientation | String |  |
| mezzanine_file_metadata_bit_rate | Int |  |
| mezzanine_file_metadata_delivery_type | String |  |
| mezzanine_file_metadata_duration | Int |  |
| mezzanine_file_metadata_maximum_bit_rate | Int |  |
| mezzanine_file_metadata_mime_type | String |  |
| mezzanine_file_metadata_minimum_bit_rate | Int |  |
| mezzanine_file_metadata_scalable_type | String |  |
| mezzanine_file_metadata_size_height | Int |  |
| mezzanine_file_metadata_size_is_aspect_ratio | Boolean |  |
| mezzanine_file_metadata_size_width | Int |  |
| mezzanine_file_redirect_url | String |  |
| name | String |  |
| override_css | String |  |
| override_size | Boolean |  |
| preview_url | String |  |
| provider_id | String |  |
| required_flash_plugin_version | String |  |
| rich_media_impressions_url | String |  |
| scan_result | String |  |
| size_height | Int |  |
| size_is_aspect_ratio | Boolean |  |
| size_width | Int |  |
| skippable_ad_type | String |  |
| snippet | String |  |
| ssl_manual_override | String |  |
| studio_creative_id | Long |  |
| survey_url | String |  |
| third_party_click_tracking_url | String |  |
| total_file_size | Long |  |
| type | String |  |
| unsupported_creative_type | String |  |
| vast_preview_url | String |  |
| vast_redirect_type | String |  |
| vast_xml_url | String |  |
| video_source_url | String |  |
| html5_asset_** |  |  |
| primary_image_asset_** |  |  |

### line_item_delivery_data_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | Long | PK, FK |
| units | Long |  |

### line_item_creative_targeting

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | Long | PK, FK |
| name | String |  |
| targeting_** |  |  |

### order_secondary_salesperson

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Long | PK, FK |
| user_id | Long | PK, FK |

### creative_asset

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| asset_byte_array | Binary |  |
| asset_url | String |  |
| file_name | String |  |
| file_size | Long |  |
| id | Long |  |
| image_density | String |  |
| size_height | Int |  |
| size_is_aspect_ratio | Boolean |  |
| size_width | Int |  |

### creative_policy_label

| Column | Type | Keys |
| --- | --- | --- |
| label | String | PK |
| creative_id | Long | PK, FK |

### creative_companion

| Column | Type | Keys |
| --- | --- | --- |
| companion_creative_id | Long | PK |
| creative_id | Long | PK, FK |

### line_item_activity_association

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | Int | PK |
| line_item_id | Long | PK, FK |
| click_through_conversion_cost | BigDecimal |  |
| view_through_conversion_cost | BigDecimal |  |

### creative_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_id | Long | PK |
| creative_id | Long | PK, FK |
| custom_field_option_id | Long |  |
| type | String |  |
| value | String |  |
| value_type | String |  |

### ad_unit_applied_label_frequency_cap

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| ad_unit_id | String | PK, FK |
| max_impressions | Int |  |
| num_time_units | Int |  |
| time_unit | String |  |

### line_item_viewability_provider_company

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Long | PK, FK |
| line_item_id | Long | PK, FK |

### creative_custom_key_value

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

### creative_placeholder

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | Long | PK, FK |
| creative_size_type | String |  |
| creative_template_id | Long |  |
| expected_creative_count | Int |  |
| is_amp_only | Boolean |  |
| size_height | Int |  |
| size_is_aspect_ratio | Boolean |  |
| size_width | Int |  |
| targeting_name | String |  |

### line_item_custom_pacing_goal

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_id | Long | PK, FK |
| amount | Long |  |
| start_date_time | Instant |  |
| use_line_item_start_date_time | Boolean |  |

### ad_unit_effective_label_frequency_cap

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Long | PK |
| ad_unit_id | String | PK, FK |
| max_impressions | Int |  |
| num_time_units | Int |  |
| time_unit | String |  |

## Relationships

- order_applied_label(order_id) → orders(id)
- creative_tracking_url(creative_id) → creative(id)
- line_item_frequency_cap(line_item_id) → line_item(id)
- order_applied_team(order_id) → orders(id)
- creative_applied_label(creative_id) → creative(id)
- creative_third_party_company(creative_id) → creative(id)
- orders(advertiser_id) → company(id)
- orders(agency_id) → company(id)
- orders(creator_id) → users(id)
- orders(trafficker_id) → users(id)
- orders(salesperson_id) → users(id)
- targeting_preset_geo_excluded_location(targeting_preset_id) → targeting_preset(id)
- order_secondary_trafficker(order_id) → orders(id)
- order_secondary_trafficker(user_id) → users(id)
- order_custom_field_value(order_id) → orders(id)
- line_item_applied_label(line_item_id) → line_item(id)
- ad_unit_size(ad_unit_id) → ad_unit(id)
- line_item_secondary_goal(line_item_id) → line_item(id)
- line_item_creative_association_size(line_item_id) → line_item_creative_association(line_item_id)
- line_item_creative_association_size(creative_id) → line_item_creative_association(creative_id)
- order_agency_contact(order_id) → orders(id)
- line_item_custom_field_value(line_item_id) → line_item(id)
- ad_unit_effective_team(ad_unit_id) → ad_unit(id)
- ad_unit_applied_team(ad_unit_id) → ad_unit(id)
- placement_targeted_ad_unit(placement_id) → placement(id)
- placement_targeted_ad_unit(ad_unit_id) → ad_unit(id)
- creative_audio_asset(creative_id) → creative(id)
- creative_video_asset(creative_id) → creative(id)
- targeting_preset_geo_targeted_location(targeting_preset_id) → targeting_preset(id)
- order_advertiser_contact(order_id) → orders(id)
- line_item_effective_applied_label(line_item_id) → line_item(id)
- ad_unit(parent_id) → ad_unit(id)
- ad_unit_applied_label(ad_unit_id) → ad_unit(id)
- ad_unit_effective_applied_label(ad_unit_id) → ad_unit(id)
- targeting_preset_inventory_targeted_ad_unit(targeting_preset_id) → targeting_preset(id)
- ad_unit_parent_path(ad_unit_id) → ad_unit(id)
- targeting_preset_inventory_excluded_ad_unit(targeting_preset_id) → targeting_preset(id)
- targeting_preset_inventory_targeted_placement_id(targeting_preset_id) → targeting_preset(id)
- targeting_preset_inventory_targeted_placement_id(placement_id) → placement(id)
- creative_third_party_impression_tracking_url(creative_id) → creative(id)
- line_item_creative_association(line_item_id) → line_item(id)
- line_item_creative_association(creative_id) → creative(id)
- creative_asset_property(creative_id) → creative(id)
- order_effective_applied_label(order_id) → orders(id)
- creative_ad_tag_key(creative_id) → creative(id)
- creative(advertiser_id) → company(id)
- line_item_delivery_data_unit(line_item_id) → line_item(id)
- line_item_creative_targeting(line_item_id) → line_item(id)
- order_secondary_salesperson(order_id) → orders(id)
- order_secondary_salesperson(user_id) → users(id)
- creative_asset(creative_id) → creative(id)
- creative_policy_label(creative_id) → creative(id)
- creative_companion(creative_id) → creative(id)
- line_item_activity_association(line_item_id) → line_item(id)
- creative_custom_field_value(creative_id) → creative(id)
- ad_unit_applied_label_frequency_cap(ad_unit_id) → ad_unit(id)
- line_item_viewability_provider_company(line_item_id) → line_item(id)
- line_item_viewability_provider_company(company_id) → company(id)
- creative_custom_key_value(creative_id) → creative(id)
- creative_placeholder(line_item_id) → line_item(id)
- line_item_custom_pacing_goal(line_item_id) → line_item(id)
- ad_unit_effective_label_frequency_cap(ad_unit_id) → ad_unit(id)