Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
updated_time 🔑
advertiser_id ➤ ADVERTISER_HISTORY
verification_status
name
click_window_days
conversion_type
code_snippet
view_window_days
created_time
engagement_window_days
CONVERSION_TAG_HISTORY ⇱
id 🔑
updated_time 🔑
is_one_tap
country
test_account
name
currency
owner_user_id
created_time
ADVERTISER_HISTORY ⇱
_fivetran_id 🔑
advertiser_id ➤ ADVERTISER_HISTORY
id
status
name
num_removed_user_records
num_matched_user_records
num_uploaded_user_records
num_batches
list_type
...custom fields
CUSTOMER_LIST_HISTORY ⇱
_fivetran_id 🔑
advertiser_id ➤ ADVERTISER_HISTORY
id
verification_status
name
code_snippet
TAG_HISTORY ⇱
_fivetran_id 🔑
advertiser_id ➤ ADVERTISER_HISTORY
id
status
name
description
rule
audience_type
size
AUDIENCE_HISTORY ⇱
_fivetran_id 🔑
advertiser_id ➤ ADVERTISER_HISTORY
view_window_days
engagement_window_days
click_window_days
APP_EVENT_TRACKING_CONFIG_HISTORY ⇱
id 🔑
updated_time 🔑
advertiser_id ➤ ADVERTISER_HISTORY
status
name
order_line_id
lifetime_spend_cap
created_time
objective_type
billing_group
daily_spend_cap
product_filter
measurement_partner_campaign_id
placement_exclusion
CAMPAIGN_HISTORY ⇱
id 🔑
updated_time 🔑
campaign_id ➤ CAMPAIGN_HISTORY
status
lifetime_frequency_cap
billable_event
name
bid_in_micro_currency
start_time
budget_in_micro_currency
end_time
upgrade_status
created_time
budget_type
auto_targeting_enabled
...custom fields
AD_GROUP_HISTORY ⇱
id 🔑
updated_time 🔑
ad_group_id ➤ AD_GROUP_HISTORY
pin_id ➤ PIN_HISTORY
android_deep_link
click_tracking_url
created_time
destination_url
ios_deep_link
is_pin_deleted
is_removable
name
review_status
status
creative_type
view_tracking_url
...custom fields
PIN_PROMOTION_HISTORY ⇱
_fivetran_id 🔑
ad_group_id ➤ AD_GROUP_HISTORY
parent_id ➤ PRODUCT_GROUP_HISTORY
active
bid_in_micro_currency
definition
id
included
valid
PRODUCT_GROUP_HISTORY ⇱
pin_promotion_id 🔑 ➤ PIN_PROMOTION_HISTORY
updated_time 🔑 ➤ PIN_PROMOTION_HISTORY
index 🔑
reason
REJECTED_REASON_HISTORY
_fivetran_id 🔑
board_id ➤ BOARD_HISTORY
id
domain
tracking_params
image_medium_url
price_currency
title
is_promotable
comment_count
cacheable_id
image_large_url
description
price_value
is_playable
link
ad_creative_type
is_repin
not_promotable_reason
is_uploaded
image_square_url
repin_count
tracked_link
is_video
is_downstream_promotion
attribution
promoter
created_at
image_square_size_pixels_width
image_square_size_pixels_height
image_medium_size_points_width
image_medium_size_points_height
image_large_size_points_width
image_large_size_points_height
image_square_size_points_width
image_square_size_points_height
image_large_size_pixels_width
image_large_size_pixels_height
image_medium_size_pixels_width
image_medium_size_pixels_height
...custom fields
PIN_HISTORY ⇱
_fivetran_id 🔑
id
category
is_collaborative
layout
name
url
collaborated_by_me
followed_by_me
image_thumbnail_url
created_at
board_order_modified_at
BOARD_HISTORY ⇱
advertiser_id 🔑 ➤ ADVERTISER_HISTORY
date 🔑
...metrics
ADVERTISER_REPORT ⇱
advertiser_id 🔑 ➤ ADVERTISER_HISTORY
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
date 🔑
...metrics
CAMPAIGN_REPORT ⇱
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
advertiser_id 🔑 ➤ ADVERTISER_HISTORY
date 🔑
...metrics
AD_GROUP_REPORT ⇱
advertiser_id 🔑 ➤ ADVERTISER_HISTORY
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
pin_promotion_id 🔑 ➤ PIN_PROMOTION_HISTORY
date 🔑
...metrics
PIN_PROMOTION_REPORT ⇱
_fivetran_id 🔑
advertiser_id ➤ ADVERTISER_HISTORY
campaign_id ➤ CAMPAIGN_HISTORY
ad_group_id ➤ AD_GROUP_HISTORY
id
archived
bid
deleted
exclude
match_type
new_match_type
parent_type
value
product_group_id 🔑➤ PRODUCT_GROUP_HISTORY
advertiser_id 🔑 ➤ ADVERTISER_HISTORY
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
date 🔑
...metrics
PRODUCT_GROUP_REPORT ⇱
item_id 🔑
product_group_id 🔑➤ PRODUCT_GROUP_HISTORY
advertiser_id 🔑 ➤ ADVERTISER_HISTORY
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
date 🔑
...metrics
ITEM_REPORT ⇱
advertiser_id 🔑 ➤ ADVERTISER_HISTORY
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
pin_promotion_id 🔑 ➤ PIN_PROMOTION_HISTORY
date 🔑
targetine_type
targeting_value
...metrics
PIN_PROMOTION_TARGETING_REPORT ⇱
id 🔑
name
TARGETING_AGE_BUCKET ⇱
id 🔑
name
TARGETING_APP_TYPE ⇱
id 🔑
name
TARGETING_GENDER ⇱
id 🔑
name
TARGETING_LOCALE ⇱
id 🔑
name
TARGETING_LOCATION ⇱
id 🔑
level
name
parent_id
TARGETING_INTEREST ⇱
country_id 🔑
country_name
TARGETING_GEO ⇱
metro_id 🔑
country_id 🔑 ➤ TARGETING_GEO
metro_name
TARGETING_GEO_METRO ⇱
region_id 🔑
country_id 🔑 ➤ TARGETING_GEO
region_ name
TARGETING_GEO_REGION ⇱
advertiser_id 🔑 ➤ ADVERTISER_HISTORY
product_group_id 🔑 ➤ PRODUCT_GROUP_HISTORY
date 🔑
targetine_type
targeting_value
...metrics
PRODUCT_GROUP_TARGETING_REPORT ⇱