1 of 1

Legend

πŸ”‘ = primary key

➀ = foreign key relation

⇱ = external link

id πŸ”‘

last_updatedπŸ”‘

ad_group_id ➀ AD_GROUP_HISTORY

ad_name

assets

call_to_action_text

content_url

created_date

description

display_url

display_url_path1

display_url_path2

editorial_status

final_url

flash_sale_config

image_url

image_url_hq

image_url_thumbnail

impression_tracking_urls

landing_url

mail_asset_url

mobile_final_url

sponsored_by

status

title

title2

tracking_url

video_auto_loop

video_caption_url

video_preview_start_time

video_primary_url

custom_*

AD_HISTORY ⇱

id πŸ”‘

last_updated πŸ”‘

advertiser_name

created_date

currency

timezone

tracking_url

custom_*

ADVERTISER_HISTORY ⇱

ad_group_id πŸ”‘ ➀ AD_GROUP_HISTORY

channel πŸ”‘

price_type πŸ”‘

value πŸ”‘

AD_GROUP_BIDSET ⇱

id πŸ”‘

last_updatedπŸ”‘

advertiser_id ➀ ADVERTISER_HISTORY

advanced_geo_neg

advanced_geo_pos

app_locale

bidding_strategy

budget

budget_type

campaign_name

channel

conversion_rule_config

conversion_rule_ids

created_date

default_landing_url

display_url_path1

display_url_path2

effective_status

final_url

is_deep_link

is_partner_network

language

mobile_final_url

objective

optimization_rule_ids

status

sub_channel

sub_channel_modifier

tracking_partner

tracking_url

custom_*

CAMPAIGN_HISTORY ⇱

id πŸ”‘

last_updated πŸ”‘

campaign_id ➀ CAMPAIGN_HISTORY

ad_group_name

advanced_geo_neg

advanced_geo_pos

bidding_strategy

created_date

display_url_path1

display_url_path2

ecpa_goal

end_date

final_url

mobile_final_url

product_set_id

status

start_date

tracking_url

custom_*

AD_GROUP_HISTORY ⇱

id πŸ”‘

last_updatedπŸ”‘

campaign_id ➀ CAMPAIGN_HISTORY

ad_group_id ➀ AD_GROUP_HISTORY

created_date

is_call_only

parent_type

phone_country

phone_number

status

type

custom_*

AD_EXTENSION_HISTORY ⇱

id πŸ”‘

last_updatedπŸ”‘

campaign_id ➀ CAMPAIGN_HISTORY

ad_group_id ➀ AD_GROUP_HISTORY

bid_modifier

created_date

exclude

parent_type

status

type

value

TARGETING_ATTRIBUTE_HISTORY ⇱

keyword_id πŸ”‘ ➀ KEYWORD_HISTORY

channel πŸ”‘

price_type πŸ”‘

value πŸ”‘

KEYWORD_BIDSET ⇱

id πŸ”‘

last_updated πŸ”‘

advertiser_id ➀ ADVERTISER_HISTORY

created_date

final_url

mobile_final_url

status

editorial_status

title

tracking_url

landing_url

description

SHARED_SITELINK_HISTORY ⇱

id πŸ”‘

campaign_id ➀ CAMPAIGN_HISTORY

ad_group_id ➀ AD_GROUP_HISTORY

shared_sitelink_id ➀ SHARED_SITELINK_HISTORY

parent_type

status

position

SHARED_SITELINK_SETTING ⇱

id πŸ”‘

last_updatedπŸ”‘

campaign_id ➀ CAMPAIGN_HISTORY

ad_group_id ➀ AD_GROUP_HISTORY

add_param_values

created_date

editorial_status

exclude

final_url

landing_url

match_type

mobile_final_url

parent_id

parent_type

status

tracking_url

value

custom_*

KEYWORD_HISTORY ⇱

ad_id πŸ”‘ ➀ AD_HISTORY

last_updated πŸ”‘ ➀ AD_HISTORY

key πŸ”‘

value πŸ”‘

AD_URL_TAG_HISTORY

Reporting tables

Link to Documentation

CALL_EXTENSION_STATS_REPORT ⇱

AD_EXTENSION_DETAIL_REPORT ⇱

PRODUCT_ADS_REPORT ⇱

KEYWORD_STATS_REPORT ⇱

PRODUCT_AD_PERFORMANCE_DAILY_REPORT ⇱

PERFORMANCE_STATS_DAILY_REPORT ⇱

PERFORMANCE_STATS_HOURLY_REPORT ⇱

USER_STATS_REPORT ⇱

ADJUSTMENT_STATS_REPORT ⇱

CONVERSION_RULES_STATS_REPORT ⇱

SITE_PERFORMANCE_STATS_REPORT ⇱

SEARCH_STATS_REPORT ⇱

CAMPAIGN_BID_PERFORMANCE_STATS_REPORT ⇱

SLOT_PERFORMANCE_HOURLY_REPORT ⇱

SLOT_PERFORMANCE_DAILY_REPORT ⇱