Xandr
Explore the interactive ERD
Table & Field Reference
yield_management_profile_modifier_technical_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
yield_management_profile_id | Unknown | PKFK |
amount_cpm | Unknown | |
amount_pct | Unknown | |
name | Unknown | |
type | Unknown |
yield_management_profile_bias
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
yield_management_profile_id | Unknown | PKFK |
code | Unknown | |
description | Unknown | |
name | Unknown | |
priority | Unknown | |
profile_id | Unknown |
yield_management_profile_floor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
yield_management_profile_id | Unknown | PKFK |
apply_floor_to_direct | Unknown |
yield_management_profile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
publisher_id | Unknown | FK |
active | Unknown | |
base_ym_bias_id | Unknown | |
base_ym_floor_id | Unknown | |
code | Unknown | |
description | Unknown | |
last_modified | Unknown | |
name | Unknown |
demand_partner_schema_required
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
demand_partner_schema_id | Unknown | PKFK |
required | Unknown |
demand_partner_schema_property
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
demand_partner_schema_id | Unknown | PKFK |
description | Unknown | |
enum | Json | |
pattern | Unknown | |
type | Json |
demand_partner_schema
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
schema | Unknown | |
title | Unknown | |
type | Unknown |
yield_management_group_buyer_member
| Column | Type | Keys |
|---|---|---|
member_id | Unknown | PKFK |
yield_management_buyer_group_id | Unknown | PKFK |
yield_management_buyer_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
code | Unknown | |
description | Unknown | |
last_modified | Unknown | |
name | Unknown |
ad_profile_brand
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | PKFK |
parent_brand_id | Unknown | |
status | Unknown |
ad_profile_creative
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | PKFK |
approved | Unknown |
ad_profile_excluded_landing_page_url
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
ad_profile_id | Unknown | PKFK |
excluded_landing_page_url | Unknown |
ad_profile_language
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | PKFK |
status | Unknown |
ad_profile_ad_server
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | PKFK |
status | Unknown |
ad_profile_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | PKFK |
status | Unknown |
ad_profile_member
| Column | Type | Keys |
|---|---|---|
ad_profile_id | Unknown | PKFK |
member_id | Unknown | PKFK |
audit_type | Unknown | |
exclude_unaudited | Unknown | |
require_seller_audit_status | Unknown | |
status | Unknown |
ad_profile_technical_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | PKFK |
status | Unknown |
frequency_caps_technical_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_frequency_caps_id | Unknown | PKFK |
ad_profile_id | Unknown | PKFK |
last_activity | Unknown | |
name | Unknown |
frequency_caps_category_country_brand
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_frequency_caps_id | Unknown | PKFK |
ad_profile_id | Unknown | PKFK |
frequency_caps_category_id | Unknown | PKFK |
brand | Json | |
brand_name | Unknown | |
country | Unknown |
frequency_caps_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_frequency_caps_id | Unknown | PKFK |
ad_profile_id | Unknown | PKFK |
is_brand_eligible | Unknown | |
is_sensitive | Unknown | |
last_modified | Unknown | |
name | Unknown | |
requires_whitelist | Unknown | |
requires_whitelist_on_external | Unknown | |
requires_whitelist_on_managed | Unknown |
ad_profile_frequency_caps
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | PKFK |
cap_users_without_cookie | Unknown | |
max_day_imps | Unknown | |
max_session_imps | Unknown | |
member_id | Unknown | |
min_minutes_per_imp | Unknown |
ad_profile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
publisher_id | Unknown | FK |
approved_creative_count | Unknown | |
audit_type_direct | Unknown | |
banned_creative_count | Unknown | |
brands_unreviewed | Unknown | |
check_attributes_direct | Unknown | |
creatives_approved_percent | Unknown | |
creatives_unreviewed | Unknown | |
default_ad_server_status | Unknown | |
default_audit_type | Unknown | |
default_brand_status | Unknown | |
default_category_status | Unknown | |
default_language_status | Unknown | |
default_member_status | Unknown | |
default_technical_attribute_status | Unknown | |
description | Unknown | |
exclude_unaudited | Unknown | |
exclude_unaudited_direct | Unknown | |
languages | Unknown | |
last_modified | Unknown | |
notes | Unknown | |
require_seller_audit_default | Unknown | |
state | Unknown | |
total_creative_count | Unknown |
operating_system_family
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
placement_ad_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
placement_id | Unknown | PKFK |
display_name | Unknown | |
name | Unknown | |
renderer | Json | |
renderer_id | Unknown |
placement_supported_media_subtype
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
placement_id | Unknown | PKFK |
is_private | Unknown | |
media_type_group_id | Unknown | |
name | Unknown |
placement_content_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
placement_id | Unknown | PKFK |
is_system | Unknown | |
name | Unknown |
placement_default_creative
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
placement_id | Unknown | PKFK |
height | Unknown | |
name | Unknown | |
price | Unknown | |
width | Unknown |
placement_estimated_clear_price
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
placement_id | Unknown | PKFK |
average_price | Unknown | |
clear_price | Unknown | |
geo_country | Unknown | |
height | Unknown | |
verified | Unknown | |
width | Unknown |
placement_inventory_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
placement_id | Unknown | PKFK |
name | Unknown |
placement_supported_media_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
placement_id | Unknown | PKFK |
last_modified | Unknown | |
media_type_group_id | Unknown | |
name | Unknown | |
uses_sizes | Unknown |
placement_mime_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
placement_id | Unknown | PKFK |
mime_type | Unknown |
placement_private_size
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
placement_id | Unknown | PKFK |
height | Unknown | |
width | Unknown |
placement_filtered_advertiser
| Column | Type | Keys |
|---|---|---|
advertiser_id | Unknown | PKFK |
placement_id | Unknown | PKFK |
placement_video_aspect_ratio
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
placement_id | Unknown | PKFK |
ratio_height | Unknown | |
ratio_width | Unknown |
placement_video_framework
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
placement_id | Unknown | PKFK |
framework | Unknown |
placement_video_bumper
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
placement_id | Unknown | PKFK |
max_duration_secs | Unknown | |
video_bumper_type | Unknown |
placement
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | FK |
publisher_id | Unknown | FK |
site_id | Unknown | FK |
audit_level | Unknown | |
audited | Unknown | |
code | Unknown | |
code_2 | Unknown | |
code_3 | Unknown | |
content_retrieval_timeout_ms | Unknown | |
cost_cpm | Unknown | |
default_calculation_type | Unknown | |
default_creative_id | Unknown | |
default_position | Unknown | |
default_referrer_url | Unknown | |
demand_filter_action | Unknown | |
enable_for_mediation | Unknown | |
exclusive | Unknown | |
filtered_campaigns | Unknown | |
filtered_line_items | Unknown | |
floor_application_target | Unknown | |
handles_mixed_media | Unknown | |
height | Unknown | |
hide_referer | Unknown | |
intended_audience | Unknown | |
is_prohibited | Unknown | |
is_resizable | Unknown | |
is_ss_native_assembly_enabled | Unknown | |
last_modified | Unknown | |
name | Unknown | |
pixel_type | Unknown | |
pixel_url | Unknown | |
pixel_url_secure | Unknown | |
reserve_price | Unknown | |
segments | Unknown | |
site_audit_status | Unknown | |
state | Unknown | |
supported_mime_types_action_include | Unknown | |
tinytag_renderer_asset_floor_prices | Json | |
use_detected_domain | Unknown | |
video_context | Unknown | |
video_id | Unknown | |
video_layback_method | Unknown | |
video_max_duration_secs | Unknown | |
video_maximum_ad_duration_secs | Unknown | |
video_maximum_number_ads | Unknown | |
video_mf_min_height | Unknown | |
video_mf_min_width | Unknown | |
video_min_bitrate | Unknown | |
video_player_vast_version | Unknown | |
video_skip_offset_seconds | Unknown | |
video_start_delay_secs | Unknown | |
video_supports_skippable | Unknown | |
video_vmin_ad_duration | Unknown | |
video_width | Unknown | |
visibility_profile_id | Unknown | |
width | Unknown | |
custom_toolbar_** |
bidder_info_app_media_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
maintainer_email | Unknown | PKFK |
media_type | Unknown |
bidder_info_site_media_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
maintainer_email | Unknown | PKFK |
media_type | Unknown |
bidder_info
| Column | Type | Keys |
|---|---|---|
maintainer_email | Unknown | PK |
status | Unknown |
seller_creative_review_deal_audit_status
| Column | Type | Keys |
|---|---|---|
deal_id | Unknown | PKFK |
seller_creative_review_id | Unknown | PKFK |
audit_feedback | Unknown | |
audit_status | Unknown |
seller_creative_review
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
audit_feedback | Unknown | |
audit_status | Unknown | |
brand_id | Unknown | |
created_on | Unknown | |
creative_id | Unknown | |
deleted | Unknown | |
language_id | Unknown | |
last_modified | Unknown |
deal_creative
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | PKFK |
status | Unknown |
deal_brand
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | PKFK |
name | Unknown | |
override | Unknown |
deal_ad_server_list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | PKFK |
name | Unknown | |
override | Unknown |
deal_allowed_media_subtype_native_asset
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
deal_allowed_media_subtype_id | Unknown | PKFK |
deal_id | Unknown | PKFK |
max_text_length | Unknown | |
min_text_length | Unknown | |
native_asset_name | Unknown | |
requirement | Unknown |
deal_allowed_media_subtype_permitted_size
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
deal_allowed_media_subtype_id | Unknown | PKFK |
deal_id | Unknown | PKFK |
aspect_ratio_tolerance | Unknown | |
max_image_height | Unknown | |
max_image_width | Unknown | |
min_image_height | Unknown | |
min_image_width | Unknown | |
platform_height | Unknown | |
platform_width | Unknown | |
scaling_permitted | Unknown | |
validate_image_size | Unknown |
deal_allowed_media_subtype
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | PKFK |
last_modified | Unknown | |
media_type_group_id | Unknown | |
media_type_id | Unknown | |
media_type_name | Unknown | |
name | Unknown |
deal_allowed_media_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | PKFK |
last_modified | Unknown | |
media_type_group_id | Unknown | |
name | Unknown | |
uses_sizes | Unknown |
deal_buyer_seat
| Column | Type | Keys |
|---|---|---|
bidder_id | Unknown | PK |
deal_id | Unknown | PKFK |
bidder_name | Unknown | |
code | Unknown | |
name | Unknown |
deal_buyer_bidder
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
deal_id | Unknown | PKFK |
bidder_id | Unknown | |
bidder_name | Unknown |
deal_buyer_member
| Column | Type | Keys |
|---|---|---|
bidder_id | Unknown | PK |
id | Unknown | PK |
deal_id | Unknown | PKFK |
bidder_name | Unknown | |
name | Unknown |
deal_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | PKFK |
name | Unknown | |
override | Unknown |
deal_language
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | PKFK |
name | Unknown | |
override | Unknown |
deal_technical_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | PKFK |
name | Unknown | |
override | Unknown |
deal_line_item_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
deal_id | Unknown | PKFK |
line_item_id | Unknown |
deal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
seller_member_id | Unknown | FK |
active | Unknown | |
allow_creative_add_on_click | Unknown | |
allow_creative_add_on_view | Unknown | |
ask_price | Unknown | |
auction_type_id | Unknown | |
auction_type_name | Unknown | |
audit_status_option | Unknown | |
brand_restrict | Unknown | |
buyer_bidder_id | Unknown | |
buyer_id | Unknown | |
buyer_name | Unknown | |
code | Unknown | |
currency | Unknown | |
description | Unknown | |
end_date | Unknown | |
floor_price | Unknown | |
language_restrict | Unknown | |
last_modified | Unknown | |
media_preference | Unknown | |
name | Unknown | |
package_id | Unknown | |
payment_type | Unknown | |
priority | Unknown | |
profile_id | Unknown | |
seller_id | Unknown | |
seller_name | Unknown | |
seller_targeting_restriction_id | Unknown | |
seller_targeting_restriction_name | Unknown | |
size_preference | Unknown | |
start_date | Unknown | |
technical_attribute_restrict | Unknown | |
type_id | Unknown | |
type_name | Unknown | |
use_deal_floor | Unknown | |
version | Unknown | |
visibility_profile_id | Unknown |
placement_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
placement_set_id | Unknown | PKFK |
placement_id | Unknown | FK |
placement_set
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
publisher_id | Unknown | FK |
code | Unknown | |
last_activity | Unknown | |
name | Unknown |
content_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
code | Unknown | |
description | Unknown | |
is_system | Unknown | |
last_modified | Unknown | |
name | Unknown | |
parent_category_id | Unknown | |
parent_category_name | Unknown | |
type | Unknown |
cross_partner_setting_price_granularity_range
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
cross_partner_setting_id | Unknown | PKFK |
increment | Unknown | |
max | Unknown |
cross_partner_setting_group_role
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
cross_partner_setting_id | Unknown | PKFK |
role_id | Unknown |
cross_partner_setting_group_team
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
cross_partner_setting_id | Unknown | PKFK |
team_id | Unknown |
cross_partner_setting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
bidder_timeout_ms | Unknown | |
deleted | Unknown | |
last_modified | Unknown | |
price_granularity_currency_code | Unknown | |
price_granularity_label | Unknown | |
price_granularity_precision | Unknown |
yield_management_auction_tier_buyer_member
| Column | Type | Keys |
|---|---|---|
member_id | Unknown | PKFK |
yield_management_auction_tier_id | Unknown | PKFK |
yield_management_auction_tier
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
code | Unknown | |
description | Unknown | |
member_action | Unknown | |
min_price | Unknown | |
name | Unknown | |
priority | Unknown | |
profile_id | Unknown | |
ym_profile_id | Unknown |
member_content_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
name | Unknown |
member_plugin
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
status | Unknown |
member_floor_optimization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
active | Unknown |
member_default_country
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
country_code | Unknown | |
country_name | Unknown |
inventory_trust_member
| Column | Type | Keys |
|---|---|---|
member_id | Unknown | PKFK |
seller_member_id | Unknown | PKFK |
allow_unaudited | Unknown | |
is_banned | Unknown | |
trust | Unknown |
member_third_party_pixel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
active | Unknown | |
audit_status | Unknown | |
name | Unknown |
member_standard_size
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
height | Unknown | |
is_standard | Unknown | |
width | Unknown |
seller_member_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
created_on | Unknown | |
description | Unknown | |
display_order | Unknown | |
last_modified | Unknown | |
name | Unknown |
member_mediation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
auto_bid_adjustment_enabled | Unknown | |
reporting_sync_enabled | Unknown |
member_native_custom_key
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
native_custom_key | Unknown |
member_brand_exception
| Column | Type | Keys |
|---|---|---|
brand_id | Unknown | PK |
member_id | Unknown | PKFK |
member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_ad_profile_id | Unknown | FK |
default_placement_id | Unknown | FK |
account_owner_user_first_name | Unknown | |
account_owner_user_id | Unknown | |
account_owner_user_last_name | Unknown | |
active_contract_auditing_fee_per_creative | Unknown | |
active_contract_creative_priority_fee_1 | Unknown | |
active_contract_creative_priority_fee_2 | Unknown | |
age_segment_id | Unknown | |
agent_id | Unknown | |
allow_ad_profile_override | Unknown | |
allow_non_cpm_payment | Unknown | |
allow_priority_audit | Unknown | |
audit_notify_email | Unknown | |
bidder_id | Unknown | |
billing_address_1 | Unknown | |
billing_address_2 | Unknown | |
billing_city | Unknown | |
billing_country | Unknown | |
billing_postal_code | Unknown | |
billing_region | Unknown | |
buyer_clearing_fee_pct | Unknown | |
buyer_credit_limit | Unknown | |
code | Unknown | |
contact_email | Unknown | |
contact_info | Unknown | |
content_categories | Unknown | |
contract_allows_unaudited | Unknown | |
contracts | Json | |
creative_size_fee_per_gb | Unknown | |
creative_size_minimum_bytes | Unknown | |
curation_deductions_allowed | Unknown | |
daily_budget | Unknown | |
daily_budget_imps | Unknown | |
daily_imps_self_audited | Unknown | |
daily_imps_unaudited | Unknown | |
daily_imps_verified | Unknown | |
deal_types | Json | |
deal_visibility_profile_id | Unknown | |
default_accept_data_provider_user_sync | Unknown | |
default_accept_deals | Unknown | |
default_accept_demand_partner_user_sync | Unknown | |
default_accept_supply_partner_user_sync | Unknown | |
default_allow_cpa | Unknown | |
default_allow_cpc | Unknown | |
default_buyer_group_id | Unknown | |
default_campaign_allow_unaudited | Unknown | |
default_campaign_trust | Unknown | |
default_content_retrieval_timeout_ms | Unknown | |
default_creatives | Unknown | |
default_currency | Unknown | |
default_discrepancy_pct | Unknown | |
default_enable_for_mediation | Unknown | |
default_external_audit | Unknown | |
default_optimization_version | Unknown | |
description | Unknown | |
developer_id | Unknown | |
domain_blacklist_email | Unknown | |
dongle | Unknown | |
email_code | Unknown | |
enable_click_and_imp_trackers | Unknown | |
enable_facebook | Unknown | |
enable_mobile_ui | Unknown | |
enforce_cmp_validation | Unknown | |
entity_type | Unknown | |
expose_eap_ecp_placement_settings | Unknown | |
expose_optimization_levers | Unknown | |
gender_segment_id | Unknown | |
interface_domain | Unknown | |
interface_domain_beta | Unknown | |
inventory_trust | Unknown | |
inventory_trust_default_allow_unaudited | Unknown | |
inventory_trust_default_is_banned | Unknown | |
inventory_trust_default_trust | Unknown | |
is_iash_compliant | Unknown | |
last_modified | Unknown | |
macros | Unknown | |
max_hosted_video_size | Unknown | |
mediation | Unknown | |
name | Unknown | |
no_reselling_priority | Unknown | |
platform_exposure | Unknown | |
plugins_enabled | Unknown | |
pops_enabled_ui | Unknown | |
price_buckets | Unknown | |
prioritize_margin | Unknown | |
reporting_decimal_type | Unknown | |
requires_publisher_audit | Unknown | |
reselling_description | Unknown | |
reselling_exposed_on | Unknown | |
reselling_exposure | Unknown | |
seller_revshare_pct | Unknown | |
server_of_record_enforce_true_priority_tiers | Unknown | |
server_of_record_guaranteed_delivery_enabled | Unknown | |
server_of_record_guaranteed_delivery_version | Unknown | |
serving_domain_cname | Unknown | |
serving_domain_type | Unknown | |
sherlock_notify_email | Unknown | |
short_name | Unknown | |
state | Unknown | |
tax_region_id | Unknown | |
timezone | Unknown | |
use_insertion_orders | Unknown | |
vendor_id | Unknown | |
visibility_profile_id | Unknown | |
website_url | Unknown | |
white_label_support_email | Unknown | |
xd_coop | Unknown | |
xvm_status | Unknown | |
ym_profile_id | Unknown |
yield_management_floor_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
yield_management_floor_id | Unknown | PKFK |
name | Unknown |
yield_management_floor_brand
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
yield_management_floor_id | Unknown | PKFK |
name | Unknown |
yield_management_floor_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
yield_management_floor_id | Unknown | PKFK |
name | Unknown |
yield_management_floor_allowed_media_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
yield_management_floor_id | Unknown | PKFK |
name | Unknown |
yield_management_floor_allowed_media_subtype
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
yield_management_floor_id | Unknown | PKFK |
name | Unknown |
yield_management_floor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
allow_tag_reserve_override | Unknown | |
brands | Unknown | |
code | Unknown | |
default_calculation_type | Unknown | |
description | Unknown | |
floor_application_target | Unknown | |
floor_optimization_enabled | Unknown | |
hard_floor | Unknown | |
last_modified | Unknown | |
members | Unknown | |
name | Unknown | |
priority | Unknown | |
profile_id | Unknown | |
soft_floor | Unknown | |
ym_profile_id | Unknown |
advertiser_label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
advertiser_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
advertiser_third_party_pixel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
advertiser_id | Unknown | PKFK |
active | Unknown | |
audit_status | Unknown | |
name | Unknown |
advertiser
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
allow_safety_pacing | Unknown | |
audience_size_check_last_run | Unknown | |
audience_size_check_state | Unknown | |
billing_address_1 | Unknown | |
billing_address_2 | Unknown | |
billing_city | Unknown | |
billing_country | Unknown | |
billing_internal_user | Unknown | |
billing_name | Unknown | |
billing_phone | Unknown | |
billing_state | Unknown | |
billing_zip | Unknown | |
code | Unknown | |
competitive_brands | Json | |
competitive_categories | Json | |
control_pct | Unknown | |
daily_budget | Unknown | |
daily_budget_imps | Unknown | |
default_brand | Unknown | |
default_brand_category_id | Unknown | |
default_brand_id | Unknown | |
default_brand_name | Unknown | |
default_category | Unknown | |
default_currency | Unknown | |
enable_pacing | Unknown | |
enable_political_io_by_default | Unknown | |
is_malicious | Unknown | |
is_mediated | Unknown | |
is_running_political_ads | Unknown | |
labels | Unknown | |
last_modified | Unknown | |
legal_entity_name | Unknown | |
lifetime_budget | Unknown | |
lifetime_budget_imps | Unknown | |
name | Unknown | |
object_stats | Unknown | |
partner_fees | Unknown | |
profile_id | Unknown | |
re_marketing_segment_id | Unknown | |
state | Unknown | |
stats | Json | |
time_format | Unknown | |
timezone | Unknown | |
use_insertion_orders | Unknown |
targeting_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
targeting_key_id | Unknown | PKFK |
created_on | Unknown | |
label | Unknown | |
last_modified | Unknown | |
name | Unknown |
site_inventory_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
site_id | Unknown | PKFK |
name | Unknown |
site_placement
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
site_id | Unknown | PKFK |
code | Unknown |
site_content_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
site_id | Unknown | PKFK |
is_primary | Unknown | |
is_system | Unknown | |
name | Unknown | |
site | Json |
site_creative_format
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
site_id | Unknown | PKFK |
creative_format | Unknown |
site_allowed_click_action
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
site_id | Unknown | PKFK |
allowed_click_action | Unknown |
site
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
publisher_id | Unknown | FK |
code | Unknown | |
created_on | Unknown | |
creative_format_action | Unknown | |
intended_audience | Unknown | |
label | Unknown | |
last_modified | Unknown | |
mobile_app_instance_bundle_id | Unknown | |
mobile_app_instance_id | Unknown | |
mobile_app_instance_os_family_id | Unknown | |
name | Unknown | |
primary_content_category_id | Unknown | |
publisher_join | Json | |
state | Unknown | |
supply_type | Unknown | |
type | Unknown | |
url | Unknown | |
marketplace_map_** |
ad_quality_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_profile_id | Unknown | FK |
publisher_id | Unknown | FK |
active | Unknown | |
code | Unknown | |
description | Unknown | |
name | Unknown | |
priority | Unknown | |
profile_id | Unknown |
config_price_granularity_range
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
config_id | Unknown | PKFK |
increment | Unknown | |
max | Unknown |
config_property_media_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
config_id | Unknown | PKFK |
config_property_id | Unknown | PKFK |
media_type | Unknown |
config_property_media_type_size
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
config_id | Unknown | PKFK |
config_property_id | Unknown | PKFK |
height | Unknown | |
is_standard | Unknown | |
width | Unknown |
config_property_targeting_os_family
| Column | Type | Keys |
|---|---|---|
config_id | Unknown | PKFK |
config_property_id | Unknown | PKFK |
operating_system_family_id | Unknown | PKFK |
demand_partner_config_param
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
config_id | Unknown | PKFK |
config_property_id | Unknown | PKFK |
demand_partner_id | Unknown | FK |
deleted | Unknown | |
enabled | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
name | Unknown | |
prebid_settings_id | Unknown | |
custom_param_** |
config_property
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
config_id | Unknown | PKFK |
member_id | Unknown | FK |
deleted | Unknown | |
enabled | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
name | Unknown | |
targeting_id | Unknown | |
targeting_level_code | Unknown | |
targeting_level_name | Unknown |
config_demand_partner_setting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
config_id | Unknown | PKFK |
bid_cpm_adjustment | Unknown | |
enabled | Unknown | |
name | Unknown |
config
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
bidder_timeout_ms | Unknown | |
deleted | Unknown | |
last_modified | Unknown | |
price_granularity_currency_code | Unknown | |
price_granularity_label | Unknown | |
price_granularity_precision | Unknown | |
price_granularity_range | Json | |
price_granularity_ranges_increment | Unknown | |
price_granularity_ranges_max | Unknown | |
total_configs | Unknown |
ad_server_category_mapping
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
adserver_category_code | Unknown | |
iab_sub_category_code | Unknown |
line_item_imp_tracker_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
line_item_imp_tracker_id | Unknown | PKFK |
name | Unknown |
line_item_imp_tracker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
advertiser_id | Unknown | FK |
member_id | Unknown | FK |
publisher_id | Unknown | FK |
click_tracker | Json | |
code | Unknown | |
last_modified | Unknown | |
name | Unknown | |
payment_rule_id | Unknown | |
payment_rule_name | Unknown | |
state | Unknown |
line_item_click_tracker_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_click_tracker_id | Unknown | PKFK |
line_item_id | Unknown | PKFK |
name | Unknown |
line_item_click_tracker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
advertiser_id | Unknown | FK |
member_id | Unknown | FK |
publisher_id | Unknown | FK |
click_url | Unknown | |
code | Unknown | |
last_modified | Unknown | |
name | Unknown | |
state | Unknown |
line_item_pixel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
name | Unknown | |
post_click_revenue | Unknown | |
post_view_revenue | Unknown | |
state | Unknown | |
trigger_type | Unknown |
line_item_ad_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
line_item_id | Unknown | PKFK |
ad_type | Unknown |
line_item_budget_interval
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
code | Unknown | |
creatives | Unknown | |
daily_budget_imps_opt | Unknown | |
daily_budget_opt | Unknown | |
enable_pacing | Unknown | |
end_date | Unknown | |
lifetime_budget | Unknown | |
lifetime_budget_imps | Unknown | |
lifetime_pacing | Unknown | |
lifetime_pacing_pct | Unknown | |
object_id | Unknown | |
object_type | Unknown | |
parent_interval_id | Unknown | |
start_date | Unknown | |
sub_flight | Unknown | |
timezone | Unknown | |
under_spend_rollover_state | Unknown |
line_item_delivery_goal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
disallow_non_guaranteed | Unknown | |
guaranteed_delivery_version | Unknown | |
percentage | Unknown | |
reserved | Unknown | |
type | Unknown |
line_item_supply_strategy
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
line_item_id | Unknown | FK |
deals | Unknown | |
managed | Unknown | |
prebid_server_profile | Unknown | |
programmatic_guaranteed | Unknown | |
rtb | Unknown |
line_item_insertion_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
advertiser_id | Unknown | FK |
budget_type | Unknown | |
code | Unknown | |
currency | Unknown | |
end_date | Unknown | |
last_modified | Unknown | |
name | Unknown | |
political_content | Unknown | |
start_date | Unknown | |
state | Unknown | |
timezone | Unknown |
budget_interval_creative
| Column | Type | Keys |
|---|---|---|
line_item_creative_id | Unknown | PKFK |
line_item_id | Unknown | PKFK |
line_item_insertion_order_budget_interval_id | Unknown | PKFK |
line_item_insertion_order_budget_interval
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
code | Unknown | |
creatives | Unknown | |
daily_budget | Unknown | |
daily_budget_imps | Unknown | |
enable_pacing | Unknown | |
end_date | Unknown | |
lifetime_budget | Unknown | |
lifetime_budget_imps | Unknown | |
lifetime_pacing | Unknown | |
lifetime_pacing_pct | Unknown | |
object_id | Unknown | |
object_type | Unknown | |
start_date | Unknown | |
subflight | Unknown | |
timezone | Unknown | |
under_spend_rollover_state | Unknown |
line_item_creative
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
all_budget_intervals | Unknown | |
audit_status | Unknown | |
code | Unknown | |
custom_date_ranges | Unknown | |
format | Unknown | |
height | Unknown | |
in_scope | Unknown | |
is_expired | Unknown | |
is_prohibited | Unknown | |
is_self_audited | Unknown | |
name | Unknown | |
pop_window_maximize | Unknown | |
state | Unknown | |
weight | Unknown | |
width | Unknown |
line_item_label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_item_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
advertiser_id | Unknown | FK |
insertion_order_id | Unknown | FK |
member_id | Unknown | FK |
all_stats | Json | |
archived_on | Unknown | |
auction_event_kpi_value | Unknown | |
auction_event_kpi_value_type | Unknown | |
bid_object_type | Unknown | |
budget_scheduling_setting_underspend_catchup_type | Unknown | |
budget_set_per_flight | Unknown | |
campaigns | Unknown | |
click_url | Unknown | |
code | Unknown | |
comments | Unknown | |
created_on | Unknown | |
creative_distribution_type | Unknown | |
ctv_bundle_enabled | Unknown | |
currency | Unknown | |
custom_model | Unknown | |
custom_optimization_note | Unknown | |
daily_budget | Unknown | |
daily_budget_imps | Unknown | |
daily_budget_imps_opt | Unknown | |
daily_budget_opt | Unknown | |
deals | Unknown | |
delivery_model_type | Unknown | |
discrepancy_pct | Unknown | |
enable_pacing | Unknown | |
enable_v_8 | Unknown | |
end_date | Unknown | |
first_run | Unknown | |
flat_fee_adjustment_id | Unknown | |
flat_fee_allocation_date | Unknown | |
flat_fee_status | Unknown | |
flat_fee_type | Unknown | |
goal_pixels | Unknown | |
goal_type | Unknown | |
goal_value | Unknown | |
in_demo_measurement | Unknown | |
incrementality | Unknown | |
inventory_discovery | Unknown | |
inventory_type | Unknown | |
is_archived | Unknown | |
kpi_auction_event_type | Unknown | |
kpi_auction_event_type_code | Unknown | |
kpi_auction_type_id | Unknown | |
last_modified | Unknown | |
last_run | Unknown | |
lifetime_budget | Unknown | |
lifetime_budget_imps | Unknown | |
lifetime_pacing | Unknown | |
lifetime_pacing_pct | Unknown | |
lifetime_pacing_span | Unknown | |
manage_creative | Unknown | |
max_billable_value | Unknown | |
name | Unknown | |
offline_attributions | Unknown | |
payment_auction_event_type | Unknown | |
payment_auction_event_type_code | Unknown | |
payment_auction_type_id | Unknown | |
prefer_delivery_over_performance | Unknown | |
priority | Unknown | |
product | Unknown | |
profile_id | Unknown | |
publishers_allowed | Unknown | |
remaining_days | Unknown | |
require_cookie_for_tracking | Unknown | |
revenue_auction_event_type | Unknown | |
revenue_auction_event_type_code | Unknown | |
revenue_auction_type_id | Unknown | |
revenue_type | Unknown | |
revenue_value | Unknown | |
road_block_adjustment_id | Unknown | |
road_block_master_height | Unknown | |
road_block_master_width | Unknown | |
road_block_slot_type | Unknown | |
road_block_type | Unknown | |
start_date | Unknown | |
state | Unknown | |
subtype | Unknown | |
timezone | Unknown | |
total_days | Unknown | |
type | Unknown | |
underspend_rollover_state | Unknown | |
use_ip_tracking | Unknown | |
user_info_creator_id | Unknown | |
user_info_owner_id | Unknown | |
valuation_bid_price_pacing_enabled | Unknown | |
valuation_bid_price_pacing_lever | Unknown | |
valuation_campaign_group_valuation_strategy | Unknown | |
valuation_goal_confidence_threshold | Unknown | |
valuation_goal_target | Unknown | |
valuation_goal_threshold | Unknown | |
valuation_max_avg_cpm | Unknown | |
valuation_max_revenue_value | Unknown | |
valuation_min_avg_cpm | Unknown | |
valuation_min_margin_cpm | Unknown | |
valuation_min_margin_pct | Unknown | |
valuation_min_revenue_value | Unknown | |
valuation_no_revenue_log | Unknown | |
viewability_vendor | Unknown | |
waive_deductions_when_disallowed | Unknown |
package_member
| Column | Type | Keys |
|---|---|---|
member_id | Unknown | PKFK |
package_id | Unknown | PKFK |
member_ask_price | Unknown | |
member_use_deal_floor | Unknown | |
name | Unknown |
package_technical_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
package_id | Unknown | PKFK |
name | Unknown | |
override | Unknown |
package_size
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
package_id | Unknown | PKFK |
height | Unknown | |
width | Unknown |
package_allowed_media_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
package_id | Unknown | PKFK |
last_modified | Unknown | |
media_type_group_id | Unknown | |
name | Unknown | |
uses_sizes | Unknown |
package_allowed_media_subtype_native_asset
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
package_allowed_media_subtype_id | Unknown | PKFK |
package_id | Unknown | PKFK |
max_text_length | Unknown | |
min_text_length | Unknown | |
native_asset_name | Unknown | |
requirement | Unknown |
package_allowed_media_subtype_permitted_size
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
package_allowed_media_subtype_id | Unknown | PKFK |
package_id | Unknown | PKFK |
aspect_ratio_tolerance | Unknown | |
max_image_height | Unknown | |
max_image_width | Unknown | |
min_image_height | Unknown | |
min_image_width | Unknown | |
platform_height | Unknown | |
platform_width | Unknown | |
scaling_permitted | Unknown | |
validate_image_size | Unknown |
package_allowed_media_subtype
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
package_id | Unknown | PKFK |
last_modified | Unknown | |
media_type_group_id | Unknown | |
media_type_id | Unknown | |
media_type_name | Unknown | |
name | Unknown |
package
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
default_ask_price | Unknown | |
default_currency | Unknown | |
default_deal_priority | Unknown | |
default_deal_type_id | Unknown | |
default_deal_type_name | Unknown | |
default_use_deal_floor | Unknown | |
description | Unknown | |
last_modified | Unknown | |
media_preference | Unknown | |
name | Unknown | |
profile_id | Unknown | |
seller_id | Unknown | |
seller_name | Unknown | |
seller_rank | Unknown | |
setting_has_inventory | Unknown | |
setting_has_segments | Unknown | |
setting_has_sizes | Unknown | |
setting_inventory_description | Unknown | |
setting_segments_description | Unknown | |
size_preference | Unknown | |
technical_attribute_restrict | Unknown | |
visibility_type_id | Unknown | |
visibility_type_name | Unknown |
external_inventory_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
code | Unknown | |
name | Unknown | |
publisher_id | Unknown |
publisher_brand_exception
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
publisher_id | Unknown | PKFK |
brand_id | Unknown |
publisher_contact
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
publisher_id | Unknown | PKFK |
email | Unknown | |
name | Unknown | |
phone | Unknown |
publisher_external_inv_code
| Column | Type | Keys |
|---|---|---|
external_inventory_code_id | Unknown | PKFK |
publisher_id | Unknown | PKFK |
publisher_label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
publisher_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
publisher_placement
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
publisher_id | Unknown | PKFK |
code | Unknown |
publisher
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_ad_profile_id | Unknown | FK |
default_site_id | Unknown | FK |
member_id | Unknown | FK |
accept_data_provider_user_sync | Unknown | |
accept_demand_partner_user_sync | Unknown | |
accept_supply_partner_user_sync | Unknown | |
ad_quality_advanced_mode_enabled | Unknown | |
allow_cpa_external | Unknown | |
allow_cpa_managed | Unknown | |
allow_cpc_external | Unknown | |
allow_cpc_managed | Unknown | |
allow_cpm_external | Unknown | |
allow_cpm_managed | Unknown | |
allow_report_on_default_imps | Unknown | |
base_ad_quality_rule_id | Unknown | |
base_payment_rule_id | Unknown | |
billing_address_1 | Unknown | |
billing_address_2 | Unknown | |
billing_city | Unknown | |
billing_country | Unknown | |
billing_dba | Unknown | |
billing_internal_user | Unknown | |
billing_state | Unknown | |
billing_zip | Unknown | |
code | Unknown | |
cpc_reselling_disabled | Unknown | |
cpm_reselling_disabled | Unknown | |
currency | Unknown | |
description | Unknown | |
enable_cookie_tracking_default | Unknown | |
expose_domains | Unknown | |
external_cpa_bias_pct | Unknown | |
external_cpc_bias_pct | Unknown | |
inventory_relationship | Unknown | |
inventory_source | Unknown | |
inventory_source_name | Unknown | |
is_oo | Unknown | |
is_rtb | Unknown | |
last_modified | Unknown | |
learn_bypass_cpm | Unknown | |
managed_cpa_bias_pct | Unknown | |
managed_cpc_bias_pct | Unknown | |
max_learn_pct | Unknown | |
name | Unknown | |
pitbull_segment_id | Unknown | |
pitbull_segment_value | Unknown | |
platform_ops_notes | Unknown | |
redirect_to_rm | Unknown | |
reselling_exposed_on | Unknown | |
reselling_exposure | Unknown | |
reselling_name | Unknown | |
seller_page_cap_enabled | Unknown | |
state | Unknown | |
timezone | Unknown | |
use_anx_auction_logic | Unknown | |
visibility_profile_id | Unknown | |
ym_profile_id | Unknown |
yield_management_bias_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
yield_management_bias_id | Unknown | PKFK |
bias_cpm | Unknown | |
bias_pct | Unknown | |
name | Unknown | |
type | Unknown |
yield_management_bias_buyer_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
yield_management_bias_id | Unknown | PKFK |
bias_cpm | Unknown | |
bias_pct | Unknown | |
name | Json | |
type | Unknown |
yield_management_bias
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
code | Unknown | |
description | Unknown | |
last_modified | Unknown | |
name | Unknown | |
priority | Unknown | |
profile_id | Unknown | |
ym_profile_id | Unknown |
primary_ad_server
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
targeting_key
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_on | Unknown | |
label | Unknown | |
last_modified | Unknown | |
name | Unknown | |
state | Unknown | |
type | Unknown |
ad_size
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
height | Unknown | |
is_standard | Unknown | |
width | Unknown |
demand_partner_source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
demand_partner_id | Unknown | PKFK |
member_owner_id | Unknown | |
source | Unknown | |
status | Unknown |
demand_partner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
bid_cpm_adjustment | Unknown | |
deleted | Unknown | |
demand_partner_id | Unknown | |
enabled | Unknown | |
last_modified | Unknown | |
name | Unknown |
visibility_profile_buyer_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
visibility_profile_id | Unknown | PKFK |
custom_categories | Json | |
expose_age | Unknown | |
expose_application_id | Unknown | |
expose_city | Unknown | |
expose_custom_categories | Unknown | |
expose_device_id | Unknown | |
expose_dma | Unknown | |
expose_gender | Unknown | |
expose_geo_lat_lon | Unknown | |
expose_ip | Unknown | |
expose_postal_code | Unknown | |
expose_query_string | Unknown | |
expose_reserve_price | Unknown | |
expose_site_id | Unknown | |
expose_state | Unknown | |
expose_user_agent | Unknown | |
expose_user_id | Unknown | |
name | Unknown | |
url_exposure | Unknown |
visibility_profile_bidder_custom_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
visibility_profile_bidder_id | Unknown | PKFK |
visibility_profile_id | Unknown | PKFK |
name | Unknown |
visibility_profile_bidder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
visibility_profile_id | Unknown | PKFK |
expose_age | Unknown | |
expose_application_id | Unknown | |
expose_city | Unknown | |
expose_custom_categories | Json | |
expose_device_id | Unknown | |
expose_dma | Unknown | |
expose_gender | Unknown | |
expose_geo_lat_lon | Unknown | |
expose_ip | Unknown | |
expose_postal_code | Unknown | |
expose_query_string | Unknown | |
expose_reserve_price | Unknown | |
expose_site_id | Unknown | |
expose_state | Unknown | |
expose_user_agent | Unknown | |
expose_user_id | Unknown | |
name | Unknown | |
url_exposure | Unknown |
visibility_profile_custom_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
visibility_profile_id | Unknown | PKFK |
name | Unknown |
visibility_profile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
expose_age_default | Unknown | |
expose_application_id_default | Unknown | |
expose_city_default | Unknown | |
expose_custom_categories_default | Unknown | |
expose_device_id_default | Unknown | |
expose_device_type_target | Unknown | |
expose_dma_default | Unknown | |
expose_gender_default | Unknown | |
expose_geo_lat_lon_default | Unknown | |
expose_ip_default | Unknown | |
expose_postal_code_default | Unknown | |
expose_query_string_default | Unknown | |
expose_reserve_price_default | Unknown | |
expose_segment_groups_default | Unknown | |
expose_site_id_default | Unknown | |
expose_user_agent_default | Unknown | |
expose_user_id_default | Unknown | |
expose_video_content_duration_default | Unknown | |
expose_video_content_genres_default | Unknown | |
expose_video_content_networks_default | Unknown | |
expose_video_content_ratings_default | Unknown | |
expose_video_context_default | Unknown | |
expose_video_delivery_types_default | Unknown | |
expose_video_program_types_default | Unknown | |
last_modified | Unknown | |
name | Unknown | |
notes | Unknown | |
url_exposure_default | Unknown |
payment_rule_filtered_advertiser
| Column | Type | Keys |
|---|---|---|
advertiser_id | Unknown | PKFK |
payment_rule_id | Unknown | PKFK |
payment_rule_filtered_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
payment_rule_id | Unknown | PKFK |
name | Unknown |
payment_rule_filtered_campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
payment_rule_id | Unknown | PKFK |
name | Unknown |
payment_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
publisher_id | Unknown | FK |
apply_cost_on_default | Unknown | |
buyer_type | Unknown | |
code | Unknown | |
cost_cpm | Unknown | |
daily_budget | Unknown | |
daily_budget_imps | Unknown | |
demand_filter_action | Unknown | |
description | Unknown | |
end_date | Unknown | |
last_modified | Unknown | |
lifetime_budget | Unknown | |
lifetime_budget_imps | Unknown | |
max_rev_share | Unknown | |
name | Unknown | |
pricing_type | Unknown | |
priority | Unknown | |
profile_id | Unknown | |
revshare | Unknown | |
start_date | Unknown | |
state | Unknown | |
target_ecpm | Unknown | |
timezone | Unknown |
demand_partner_param
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | FK |
param_placement_id | Unknown | FK |
param_publisher_id | Unknown | FK |
prebid_settings_id | Unknown | FK |
deleted | Unknown | |
enabled | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
name | Unknown | |
param_key_value | Unknown | |
param_placement_key | Unknown | |
param_size | Unknown |
advertiser_analytics_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
advertiser_id | Unknown | FK |
buyer_member_id | Unknown | FK |
deal_id | Unknown | FK |
line_item_id | Unknown | FK |
seller_member_id | Unknown | FK |
adjustment_id | Unknown | |
attributed_pc_revenue | Unknown | |
attributed_pv_revenue | Unknown | |
attributed_revenue | Unknown | |
bid_type | Unknown | |
billing_period_end_date | Unknown | |
billing_period_external_code | Unknown | |
billing_period_start_date | Unknown | |
campaign_code | Unknown | |
campaign_id | Unknown | |
campaign_name | Unknown | |
campaign_priority | Unknown | |
click_conv_rate | Unknown | |
click_convs_rate | Unknown | |
click_thru_pct | Unknown | |
clicks | Unknown | |
conv_rate | Unknown | |
convs_per_mm | Unknown | |
convs_rate | Unknown | |
cost_per_video_complete | Unknown | |
cpa | Unknown | |
cpc | Unknown | |
cpm | Unknown | |
creative_id | Unknown | |
creative_name | Unknown | |
ctr | Unknown | |
day | Unknown | |
ecpa | Unknown | |
ecpa_adv_curr | Unknown | |
ecpc | Unknown | |
ecpc_adv_curr | Unknown | |
ecpm | Unknown | |
ecpm_adv_curr | Unknown | |
gender | Unknown | |
geo_country | Unknown | |
geo_country_name | Unknown | |
hour | Unknown | |
imp_type | Unknown | |
imp_type_id | Unknown | |
imps | Unknown | |
imps_viewed | Unknown | |
insertion_order_code | Unknown | |
insertion_order_id | Unknown | |
insertion_order_name | Unknown | |
media_cost | Unknown | |
media_type | Unknown | |
mediatype_id | Unknown | |
month | Unknown | |
placement_code | Unknown | |
placement_id | Unknown | |
placement_name | Unknown | |
post_click_convs | Unknown | |
post_click_convs_rate | Unknown | |
post_click_revenue | Unknown | |
post_view_convs | Unknown | |
post_view_convs_rate | Unknown | |
post_view_revenue | Unknown | |
publisher_code | Unknown | |
publisher_id | Unknown | |
publisher_name | Unknown | |
revenue_per_video_complete | Unknown | |
rpm | Unknown | |
seller_type | Unknown | |
size | Unknown | |
spend | Unknown | |
spend_adv_curr | Unknown | |
split_id | Unknown | |
split_name | Unknown | |
supply_type | Unknown | |
total_convs | Unknown | |
total_revenue | Unknown | |
user_group_for_campaign | Unknown | |
venue | Unknown | |
video_25_pcts | Unknown | |
video_50_pcts | Unknown | |
video_75_pcts | Unknown | |
video_completion_rate | Unknown | |
video_completions | Unknown | |
video_errors | Unknown | |
video_served | Unknown | |
video_skip_rate | Unknown | |
video_skips | Unknown | |
video_start_rate | Unknown | |
video_starts | Unknown | |
view_measured_imps | Unknown | |
view_measurement_rate | Unknown | |
view_rate | Unknown |