Microsoft Ads schema and ERD

28 tables

Loading diagram…

ad_group

campaign

account

string

account_financial_status

string

account_life_cycle_status

string

account_mode

string

auto_tag_type

string

back_up_payment_instrument_id

string

billing_threshold_amount

string

bill_to_customer_id

string

business_address_id

string

account_impression_performance_daily_report

account_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

clicks

int

ctr

double

account_impression_performance_hourly_report

account_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

clicks

int

ctr

double

account_performance_daily_report

account_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

device_os

string

top_vs_other

string

account_performance_hourly_report

account_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

device_os

string

top_vs_other

string

account_id

string

ad_group

string

app_id

string

app_platform

string

campaign

string

custom_parameter

string

device_preference

string

editorial_appeal_status

string

editorial_location

string

ad_label

string

account_id

string

parent_id

string

modified_time

date

status

string

_weld_synced

date

ad_group

string

account_id

string

ad_group

string

ad_group_type

string

ad_rotation

string

ad_schedule_use_searcher_time_zone

boolean

bid_adjustment

int

bid_boost_value

int

bid_option

string

bid_strategy_type

string

ad_group_label

string

account_id

string

parent_id

string

ad_group

string

campaign

string

modified_time

date

status

string

_weld_synced

date

ad_group_impression_performance_daily_report

account_id

string

campaign_id

string

ad_group_id

string

date

currency_code

string

ad_distribution

string

device_type

string

language

string

network

string

delivered_match_type

string

clicks

int

ad_group_impression_performance_hourly_report

account_id

string

campaign_id

string

ad_group_id

string

date

currency_code

string

ad_distribution

string

device_type

string

language

string

network

string

delivered_match_type

string

clicks

int

ad_group_performance_daily_report

account_id

string

campaign_id

string

ad_group_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

device_os

string

top_vs_other

string

ad_group_performance_hourly_report

account_id

string

campaign_id

string

ad_group_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

device_os

string

top_vs_other

string

ad_performance_daily_report

account_id

string

campaign_id

string

ad_group_id

string

ad_id

string

date

currency_code

string

ad_distribution

string

device_type

string

language

string

network

string

device_os

string

top_vs_other

string

ad_performance_hourly_report

account_id

string

campaign_id

string

ad_group_id

string

ad_id

string

date

currency_code

string

ad_distribution

string

device_type

string

language

string

network

string

device_os

string

top_vs_other

string

budget

string

account_id

string

parent_id

string

budget

float

budget_name

string

budget_type

string

modified_time

date

status

string

_weld_synced

date

campaign

string

account_id

string

budget_id

string

parent_id

string

ad_schedule_use_searcher_time_zone

boolean

bid_adjustment

int

bid_strategy_max_cpc

float

bid_strategy_name

string

bid_strategy_target_ad_position

string

bid_strategy_target_cpa

float

bid_strategy_target_impression_share

float

campaign_label

string

account_id

string

parent_id

string

campaign

string

modified_time

date

status

string

_weld_synced

date

campaign_impression_performance_daily_report

account_id

string

campaign_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

campaign_status

string

clicks

int

campaign_impression_performance_hourly_report

account_id

string

campaign_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

campaign_status

string

clicks

int

campaign_performance_daily_report

account_id

string

campaign_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

device_os

string

top_vs_other

string

campaign_performance_hourly_report

account_id

string

campaign_id

string

date

currency_code

string

ad_distribution

string

device_type

string

network

string

delivered_match_type

string

device_os

string

top_vs_other

string

keyword

string

account_id

string

ad_group

string

bid

double

bid_strategy_type

string

campaign

string

custom_parameter

string

destination_url

string

editorial_appeal_status

string

editorial_location

string

keyword_performance_daily_report

account_id

string

campaign_id

string

ad_group_id

string

keyword_id

string

ad_id

string

date

currency_code

string

delivered_match_type

string

ad_distribution

string

device_type

string

language

string

network

string

device_os

string

keyword_performance_hourly_report

account_id

string

campaign_id

string

ad_group_id

string

keyword_id

string

ad_id

string

date

currency_code

string

delivered_match_type

string

ad_distribution

string

device_type

string

language

string

network

string

device_os

string

label

string

account_id

string

color

string

label

string

description

string

modified_time

date

status

string

_weld_synced

date

search_query_performance_daily_report

account_id

string

campaign_id

string

ad_group_id

string

ad_id

string

keyword_id

string

date

campaign_type

string

ad_type

string

keyword

string

keyword_status

string

search_query

string

bid_match_type

string

delivered_match_type

string

user_location_performance_report

account_id

string

ad_group_id

string

campaign_id

string

date

ad_distribution

string

assists

int

bid_match_type

string

clicks

int

cost_per_assist

double

cost_per_conversion

double

ctr

double