Google Ad Manager

Explore the interactive ERD

Table & Field Reference

order_applied_label

Column	Type	Keys
`label_id`	Long	PK
`order_id`	Long	PKFK
`is_negated`	Boolean

creative_tracking_url

Column	Type	Keys
`index`	Int	PK
`key`	String	PK
`creative_id`	Long	PKFK
`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	PKFK
`max_impressions`	Int
`num_time_units`	Int
`time_unit`	String

order_applied_team

Column	Type	Keys
`team_id`	Long	PK
`order_id`	Long	PKFK

creative_applied_label

Column	Type	Keys
`label_id`	Long	PK
`creative_id`	Long	PKFK
`is_negated`	Boolean

creative_third_party_company

Column	Type	Keys
`third_party_company_id`	Long	PK
`creative_id`	Long	PKFK

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	PKFK
`canonical_parent_id`	Int
`display_name`	String
`type`	String

order_secondary_trafficker

Column	Type	Keys
`order_id`	Long	PKFK
`user_id`	Long	PKFK

order_custom_field_value

Column	Type	Keys
`custom_field_id`	Long	PK
`order_id`	Long	PKFK

line_item_applied_label

Column	Type	Keys
`label_id`	Long	PK
`line_item_id`	Long	PKFK
`is_negated`	Boolean

ad_unit_size

Column	Type	Keys
`environment_type`	String	PK
`index`	Int	PK
`ad_unit_id`	String	PKFK
`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	PKFK
`goal_type`	String
`unit_type`	String
`units`	Long

line_item_creative_association_size

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`line_item_id`	Long	PKFK
`height`	Int
`is_aspect_ratio`	Boolean
`width`	Int

order_agency_contact

Column	Type	Keys
`agency_contact_id`	Long	PK
`order_id`	Long	PKFK

line_item_custom_field_value

Column	Type	Keys
`custom_field_id`	Long	PK
`line_item_id`	Long	PKFK
`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	PKFK

ad_unit_applied_team

Column	Type	Keys
`team_id`	Long	PK
`ad_unit_id`	String	PKFK

placement_targeted_ad_unit

Column	Type	Keys
`ad_unit_id`	String	PKFK
`placement_id`	Long	PKFK

creative_audio_asset

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`redirect_url`	String
`metadata_`

creative_video_asset

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`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	PKFK
`canonical_parent_id`	Int
`display_name`	String
`type`	String

order_advertiser_contact

Column	Type	Keys
`advertiser_contact_id`	Long	PK
`order_id`	Long	PKFK

line_item_effective_applied_label

Column	Type	Keys
`label_id`	Long	PK
`line_item_id`	Long	PKFK
`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	PKFK
`is_negated`	Boolean

ad_unit_effective_applied_label

Column	Type	Keys
`label_id`	Long	PK
`ad_unit_id`	String	PKFK
`is_negated`	Boolean

targeting_preset_inventory_targeted_ad_unit

Column	Type	Keys
`ad_unit_id`	String	PK
`targeting_preset_id`	Long	PKFK
`include_descendants`	Boolean

ad_unit_parent_path

Column	Type	Keys
`parent_ad_unit_id`	String	PK
`ad_unit_id`	String	PKFK
`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	PKFK
`include_descendants`	Boolean

targeting_preset_inventory_targeted_placement_id

Column	Type	Keys
`placement_id`	Long	PKFK
`targeting_preset_id`	Long	PKFK

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	PKFK
`value`	String

line_item_creative_association

Column	Type	Keys
`creative_id`	Long	PKFK
`line_item_id`	Long	PKFK
`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	PKFK
`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	PKFK
`is_negated`	Boolean

creative_ad_tag_key

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`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	PKFK
`units`	Long

line_item_creative_targeting

Column	Type	Keys
`index`	Int	PK
`line_item_id`	Long	PKFK
`name`	String
`targeting_`

order_secondary_salesperson

Column	Type	Keys
`order_id`	Long	PKFK
`user_id`	Long	PKFK

creative_asset

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

creative_companion

Column	Type	Keys
`companion_creative_id`	Long	PK
`creative_id`	Long	PKFK

line_item_activity_association

Column	Type	Keys
`activity_id`	Int	PK
`line_item_id`	Long	PKFK
`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	PKFK
`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	PKFK
`max_impressions`	Int
`num_time_units`	Int
`time_unit`	String

line_item_viewability_provider_company

Column	Type	Keys
`company_id`	Long	PKFK
`line_item_id`	Long	PKFK

creative_custom_key_value

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`value`	String

creative_placeholder

Column	Type	Keys
`index`	Int	PK
`line_item_id`	Long	PKFK
`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	PKFK
`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	PKFK
`max_impressions`	Int
`num_time_units`	Int
`time_unit`	String