Yahoo DSP

Explore the interactive ERD

Table & Field Reference

beacon_condition

Column	Type	Keys
`index`	Int	PK
`beacon_id`	Int	PKFK
`beacon_updated_at`	String	PKFK
`key`	String
`operator`	String
`value`	String

beacon_history

Column	Type	Keys
`id`	Int	PK
`updated_at`	String	PK
`account_id`	Int	FK
`pixel_id`	Int	FK
`seat_id`	Int	FK
`app_id`	String
`app_locale`	String
`app_url`	String
`conversion_category`	String
`conversion_default_value`	Double
`created_at`	String
`destination_url`	String
`destination_url_operator`	String
`mobile_measurement_partner`	String
`name`	String
`rule_type`	String

campaign_history

Column	Type	Keys
`id`	Int	PK
`updated_at`	Instant	PK
`account_id`	Int	FK
`budget_type`	String
`created_at`	Instant
`currency`	String
`demo_vendor`	String
`frequency_cap_period_type`	String
`frequency_cap_value`	Long
`goal_type`	String
`goal_value`	Long
`name`	String
`package_enabled`	Boolean
`status`	String
`time_zone`	String

package_schedule

Column	Type	Keys
`id`	Int	PK
`package_id`	Int	PKFK
`budget`	Double
`daily_budget`	Double
`daily_budget_type`	String
`end_date`	Instant
`imp_budget`	Long
`imp_daily_budget`	Double
`name`	String
`package_language`	String
`start_date`	Instant

ad_countdown_history

Column	Type	Keys
`id`	Int	PK
`ad_id`	Int	PKFK
`ad_updated_at`	Instant	PKFK
`countdown_prefix_id`	Int
`end_date`	Instant
`time_zone`	String

advertiser_contact

Column	Type	Keys
`account_id`	Int	PKFK
`address_line_1`	String
`address_line_2`	String
`city`	String
`country`	String
`email`	String
`first_name`	String
`last_name`	String
`postal_code`	String
`region`	String
`telephone`	String

creative_details_media

Column	Type	Keys
`id`	Int	PK
`creative_id`	Int	PKFK
`bit_rate`	Int
`frame_rate`	Int
`height`	Int
`media_mime_type`	String
`media_url`	String
`width`	Int

audience_poi_targeting_rule_chain

Column	Type	Keys
`location_id`	Int	PK
`audience_poi_id`	Int	PKFK
`is_excluded`	Boolean

deal_account

Column	Type	Keys
`account_id`	Int	PKFK
`deal_id`	Int	PKFK

audience_poi

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`seat_id`	Int	FK
`name`	String
`number_of_visits`	Int
`retention_days`	String
`status`	String

contextual_category_by_taxonomy_type

Column	Type	Keys
`id`	Int	PK
`taxonomy_type`	String	PK
`parent_category_id`	Int	FK
`description`	String
`level`	Int

audience_ip_address_history

Column	Type	Keys
`id`	String	PK
`audience_ip_address_id`	Int	PKFK
`created_date`	Instant
`fail_percentage`	Double
`status`	String
`type`	String

audience_srt_included_keyword

Column	Type	Keys
`value`	String	PK
`audience_srt_id`	Int	PKFK

deal

Column	Type	Keys
`id`	Int	PK
`account_group_id`	Int	FK
`exchange_id`	Int	FK
`account_is_excluded`	Boolean
`description`	String
`exchange_deal_id`	String
`name`	String
`reserve_price`	Double
`status`	String

creative_impression_tracking

Column	Type	Keys
`tracking_event_type`	String	PK
`creative_id`	Int	PKFK
`imp_tracker_url`	String

audience_poi_targeting_rule_gid

Column	Type	Keys
`gid_id`	Int	PK
`audience_poi_id`	Int	PKFK
`is_excluded`	Boolean

targeting_ab_testing

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`user_group_id`	Int	FK
`lower_bound`	Int
`name`	String
`traffic_percent`	Int
`upper_bound`	Int

creative_details

Column	Type	Keys
`creative_id`	Int	PKFK
`call_to_action`	String
`company_name`	String
`description`	String
`duration`	Int
`title`	String

line_fee_list

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`fee`	Double
`name`	String
`type_name`	String

creative_expand_direction

Column	Type	Keys
`direction`	String	PK
`creative_id`	Int	PKFK

ad_schedule_history

Column	Type	Keys
`id`	Int	PK
`ad_id`	Int	PKFK
`ad_updated_at`	Instant	PKFK
`end_date`	Instant
`start_date`	Instant

audience_mail_event

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`seat_id`	Int	FK
`created_at`	LocalDate
`even_type`	String
`frequency`	Int
`name`	String
`status`	String

audience_mail_event_time_attribute

Column	Type	Keys
`index`	Int	PK
`audience_mail_event_id`	Int	PKFK
`from_date`	LocalDate
`key`	String
`name`	String
`num_days`	String
`range_type`	String
`to_date`	LocalDate

targeting_frequency_capping

Column	Type	Keys
`line_id`	Int	PKFK
`cap_period`	String
`cap_value`	String
`enable_viewability_freq_cap`	Boolean
`serve_unknown_user`	Boolean

creative_companion_banner

Column	Type	Keys
`id`	Int	PK
`creative_id`	Int	PKFK
`mime_type`	String
`name`	String

targeting_demographic

Column	Type	Keys
`line_id`	Int	PKFK
`threshold`	Double

targeting_segment

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`audience_type`	String
`created_at`	LocalDate
`is_excluded`	Boolean
`name`	String
`reach_count`	Long
`recency`	Int
`segment_type`	String

audience_mail_domain

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`seat_id`	Int	FK
`created_at`	LocalDate
`name`	String
`retention_days`	Int
`status`	String

audience_email_address

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`created_at`	LocalDate
`name`	String
`status`	String

targeting_deal

Column	Type	Keys
`id`	String	PK
`line_id`	Int	PKFK
`exchange_deal_id`	String	FK
`exchange_id`	Int	FK
`account_is_excluded`	Boolean
`description`	String
`is_excluded`	Boolean
`name`	String
`reserve_price`	Double
`status`	String

beacon_instrumentation_code

Column	Type	Keys
`beacon_id`	Int	PKFK
`pixel_id`	Int	FK
`custom_event_script`	String
`url_secure_multiple`	String
`url_secure_single`	String

contextual_history

Column	Type	Keys
`id`	Int	PK
`updated_at`	Instant	PK
`account_id`	Int	FK
`seat_id`	Int	FK
`name`	String
`owner_type`	String
`taxonomy_type`	String

audience_email_address_history

Column	Type	Keys
`id`	String	PK
`audience_email_address_id`	Int	PKFK
`created_date`	Instant
`duplicated`	Int
`error_message`	String
`fail_percentage`	Double
`status`	String
`total_failed`	Int
`total_ids`	Int
`type`	String

targeting_weather_temperature

Column	Type	Keys
`line_id`	Int	PKFK
`all_temperatures`	Boolean
`is_fahrenheit`	Boolean
`max_temp`	Int
`min_temp`	Int

audience_profile_size

Column	Type	Keys
`id`	Int	PK
`profile_timestamp`	Instant	PK
`count`	Long

audience_profile_gender

Column	Type	Keys
`id`	Int	PK
`name`	String	PK
`count`	Long
`unique_count`	Long

pixel

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	PKFK
`name`	String

targeting_dooh_screen_owner

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`name`	String

audience_mail_domain_excluded_domains

Column	Type	Keys
`domain`	String	PK
`audience_mail_domain`	Int	PKFK

audience_srt

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`seat_id`	Int	FK
`broad_optimization_type`	String
`created_at`	LocalDate
`match_type`	String
`name`	String
`retention_days`	Int
`status`	String

audience_poi_targeting_rule_woeid

Column	Type	Keys
`woe_id`	Int	PK
`audience_poi_id`	Int	PKFK
`is_excluded`	Boolean

targeting_weather_humidity

Column	Type	Keys
`line_id`	Int	PKFK
`all_humidities`	Boolean
`max_humidity`	Int
`min_humidity`	Int

targeting_type

Column	Type	Keys
`name`	String	PK
`line_id`	Int	PKFK
`id`	Int
`is_targeted`	Boolean

ad_history

Column	Type	Keys
`id`	Int	PK
`updated_at`	Instant	PK
`line_id`	Int	PKFK
`creative_id`	Int	FK
`media_type`	String
`name`	String
`status`	String

creative_history

Column	Type	Keys
`id`	Int	PK
`updated_at`	Instant	PK
`account_id`	Int	FK
`ad_choice_icon_location`	String
`ad_choices_enabled`	Boolean
`ad_type`	String
`creative_language`	String
`creative_tag_url`	String
`creative_type`	String
`is_third_party_code_secure`	Boolean
`landing_page_domain`	String
`landing_page_url`	String
`layout`	String
`mime_type`	String
`name`	String
`status`	String
`third_party_code`	String

line_conversion_list

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`accept_view_through`	Boolean
`beacon_id`	Int
`beacon_value_pc`	Double
`click_window`	Int
`click_window_unit_type`	String
`name`	String
`view_beacon_value_discount`	Double
`view_window`	Int
`view_window_unit_type`	String

creative_adx_categories

Column	Type	Keys
`category`	String	PK
`creative_id`	Int	PKFK

audience_mail_event_text_attribute

Column	Type	Keys
`index`	Int	PK
`audience_mail_event_id`	Int	PKFK
`group_type`	String
`key`	String
`match_type`	String
`name`	String
`operator_type`	String
`value`	String

targeting_geo

Column	Type	Keys
`id`	String	PK
`line_id`	Int	PKFK
`code`	String
`description`	String
`excluded`	Boolean
`key`	String
`level`	String
`name`	String
`woeid`	String

targeting_publisher

Column	Type	Keys
`id`	String	PK
`line_id`	Int	PKFK
`is_excluded`	Boolean
`name`	String

audience_conversion_rule

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`name`	String
`pixel_rule_id`	Int
`pixel_rule_name`	String
`pixel_rule_size`	Long
`status`	String

audience_poi_custom_date_range

Column	Type	Keys
`index`	Int	PK
`audience_poi_id`	Int	PKFK
`end_date`	LocalDate
`start_date`	LocalDate

audience_composite_exclude_segment

Column	Type	Keys
`id`	Int	PK
`composite_audience_id`	Int	PKFK
`name`	String
`reach_count`	Long
`segment_type`	String
`status`	String

audience_mail_domain_categories

Column	Type	Keys
`audience_mail_domain_id`	Int	PKFK
`id`	Int	PKFK

audience_lookalike_country

Column	Type	Keys
`country`	String	PK
`audience_lookalike_id`	Int	PKFK

audience_composite_include_segment

Column	Type	Keys
`id`	Int	PK
`composite_audience_id`	Int	PKFK
`name`	String
`reach_count`	Long
`segment_type`	String
`status`	String

line

Column	Type	Keys
`id`	Int	PK
`order_id`	Int	FK
`package_id`	Int	FK
`app_id`	String
`app_locale`	String
`app_marketing_objective`	String
`app_url`	String
`bid_price`	Double
`billing_method_type`	String
`billing_price`	Double
`budget_type`	String
`completion_threshold`	Int
`goal_amount`	Double
`goal_mode_type`	String
`goal_type`	String
`is_native_enabled`	Boolean
`margin_goal`	Double
`margin_type`	String
`max_goal`	Double
`media_type`	String
`name`	String
`pacing_acceleration`	Int
`pacing_mode_type`	String
`status`	String

order_frequency_cap

Column	Type	Keys
`campaign_updated_at`	Instant	PKFK
`order_id`	Int	PKFK
`pacing_type`	String
`period_multi_hour`	Int
`value_day`	Int
`value_hour`	Int
`value_minute`	Int
`value_month`	Int
`value_multi_hour`	Int
`value_week`	Int

advertiser_history

Column	Type	Keys
`id`	Int	PK
`updated_at`	Instant	PK
`seat_id`	Int	FK
`billing_price`	Short
`currency`	String
`iab_category_id`	Int
`iab_secondary_category_id`	Int
`is_crossdevice_off`	Boolean
`landing_page_url`	String
`name`	String
`status`	String
`time_zone`	String

audience_lookalike

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`created_at`	String
`device_type`	String
`expected_size`	Long
`name`	String
`seed_audience_id`	Int
`seed_audience_name`	String
`seed_audience_type`	String
`status`	String

seat

Column	Type	Keys
`id`	Int	PK
`currency`	String
`name`	String
`time_zone`	String

audience_srt_excluded_keyword

Column	Type	Keys
`value`	String	PK
`audience_srt_id`	Int	PKFK

targeting_day_parting

Column	Type	Keys
`day`	String	PK
`line_id`	Int	PKFK
`hours`	String
`is_whole_day`	Boolean

pixel_codes

Column	Type	Keys
`index`	Int	PK
`pixel_id`	Int	PKFK
`instrumentation_code`	String
`protocol`	String
`type`	String

deal_account_group

Column	Type	Keys
`account_group_id`	Int	PKFK
`deal_id`	Int	PKFK

audience_device_id_history

Column	Type	Keys
`id`	String	PK
`audience_device_id`	Int	PKFK
`created_date`	Instant
`duplicated`	Int
`error_message`	String
`fail_percentage`	Double
`status`	String
`total_failed`	Int
`total_ids`	Int
`type`	String

targeting_contextuals_history

Column	Type	Keys
`id`	Int	PK
`updated_at`	Instant	PK
`account_id`	Int	PKFK
`line_id`	Int	PKFK
`is_excluded`	Boolean
`name`	String
`taxonomy_type`	String

audience_profile_location

Column	Type	Keys
`continent`	String	PK
`country_name`	String	PK
`id`	Int	PK
`count`	Long
`unique_count`	Long

audience_composite_list

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`seat_id`	Int	FK
`clear_all_exclude`	Boolean
`name`	String
`people_count`	Long
`status`	String
`total_count`	Long

audience_ip_address

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`created_at`	LocalDate
`name`	String
`retention_days`	Int
`status`	String

audience_device_id

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	FK
`created_at`	LocalDate
`is_device_only`	Boolean
`name`	String
`status`	String

targeting_native_lists

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`created_at`	Instant
`is_excluded`	Boolean
`name`	String
`updated_at`	Instant

audience_profile_age

Column	Type	Keys
`id`	Int	PK
`name`	String	PK
`count`	Long
`unique_count`	Long

bid_multiplier_cap

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`bm_ad_learn_override`	Boolean
`multiplier_cap`	Double

line_schedule

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`budget`	Double
`daily_budget`	Double
`daily_budget_type`	String
`end_date_str`	Instant
`imp_budget`	Int
`imp_daily_budget`	Double
`name`	String
`start_date_str`	Instant

audience_poi_location_breadcrumb

Column	Type	Keys
`id`	Int	PK
`audience_poi_location_id`	Int	PKFK
`name`	String

creative_user_interaction

Column	Type	Keys
`action`	String	PK
`creative_id`	Int	PKFK

user_group

Column	Type	Keys
`id`	Int	PK
`account_id`	Int	PKFK
`name`	String

audience_poi_location

Column	Type	Keys
`id`	Int	PK
`has_children`	Boolean
`name`	String
`type`	String

account_group

Column	Type	Keys
`id`	Int	PK
`seat_id`	Int	FK
`code`	String
`name`	String

audience_poi_targeting_rule_category

Column	Type	Keys
`category_id`	Int	PK
`audience_poi_id`	Int	PKFK
`is_excluded`	Boolean

site_list_item

Column	Type	Keys
`id`	Int	PK
`site_list_id`	Int	PKFK
`site_list_updated_at`	Instant	PKFK
`item_name`	String

audience_mail_domain_domains

Column	Type	Keys
`domain`	String	PK
`audience_mail_domain_id`	Int	PKFK

targeting_site_list

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`created_at`	Instant
`is_excluded`	Boolean
`name`	String
`total_sites`	Int
`type`	String
`updated_at`	Instant

targeting_dooh_venue_type

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`label`	String

budget_schedule_history

Column	Type	Keys
`id`	Int	PK
`campaign_id`	Int	PKFK
`campaign_updated_at`	Instant	PKFK
`budget_type`	String
`daily_budget`	String
`end_date`	Instant
`imp_budget`	Int
`imp_daily_budget`	Int
`schedule_budget`	String
`schedule_name`	String
`start_date`	Instant

exchange

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

creative_custom_identifier

Column	Type	Keys
`id`	Int	PK
`creative_id`	Int	PKFK
`identifier_value`	String

package

Column	Type	Keys
`id`	Int	PK
`order_id`	Int	FK
`billing_method_type`	String
`budget_distributor_enabled`	Boolean
`budget_type`	String
`channel_type`	String
`completion_threshold`	Long
`flighting_enabled`	Boolean
`goal_mode_type`	String
`goal_type`	String
`margin_type`	String
`media_type`	String
`name`	String
`objective`	String
`pacing_mode_type`	String
`package_language`	String
`status`	String
`supply_type`	String

site_list_history

Column	Type	Keys
`id`	Int	PK
`updated_at`	Instant	PK
`account_id`	Int	FK
`seat_id`	Int	FK
`is_shared`	Boolean
`name`	String
`status`	String
`type`	String

user_group_entity

Column	Type	Keys
`id`	Int	PK
`user_group_id`	Int	PKFK
`lower_bound`	Int
`name`	String
`traffic_percent`	Int
`upper_bound`	Int

audience_mail_domain_all_categories

Column	Type	Keys
`id`	Int	PK
`category`	String

audience_profile_device

Column	Type	Keys
`id`	Int	PK
`name`	String	PK
`count`	Long
`unique_count`	Long

contextual_category

Column	Type	Keys
`category_id`	Int	PK
`id`	Int	PK
`contextual_id`	Int	PKFK
`contextual_updated_at`	Instant	PKFK

audience_composite_fees

Column	Type	Keys
`currency`	String	PK
`fee_media_type`	String	PK
`composite_audience_id`	Int	PKFK
`fee`	Double

bid_multiplier

Column	Type	Keys
`id`	Int	PK
`line_id`	Int	PKFK
`is_app_name`	Boolean
`multiplier`	Double
`target_domain`	String
`target_type`	String
`target_value_city`	String
`target_value_country`	String
`target_value_day`	String
`target_value_dma_code`	String
`target_value_hour`	Int
`target_value_id`	Int
`target_value_locality`	String
`target_value_major_metro_area`	String
`target_value_postal_code`	String
`target_value_postal_code_prefix`	String
`target_value_region`	String
`target_value_sub_locality`	String
`target_value_text`	String

package_user_frequency_cap

Column	Type	Keys
`package_id`	Int	PKFK
`period_multi_hour`	Long
`value_day`	Long
`value_hour`	Long
`value_minute`	Long
`value_month`	Long
`value_multi_hour`	Long
`value_week`	Long

advertiser_billing_contact

Column	Type	Keys
`account_id`	Int	PKFK
`address_line_1`	String
`address_line_2`	String
`address_line_3`	String
`city`	String
`country`	String
`email`	String
`first_name`	String
`last_name`	String
`legal_mandate_confirmation`	String
`postal_code`	String
`region`	String
`telephone`	String
`vat_number`	String

package_household_frequency_cap

Column	Type	Keys
`package_id`	Int	PKFK
`enabled`	Boolean
`period_multi_hour`	Long
`value_day`	Long
`value_hour`	Long
`value_minute`	Long
`value_month`	Long
`value_multi_hour`	Long
`value_week`	Long