Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
= deprecated endpoints
id 🔑
last_updated_date 🔑
portfolio_id ➤ PORTFOLIO_HISTORY.id
bidding_strategy
budget
effective_budget
budget_type
creation_date
end_date
name
profile_id
serving_status
start_date
state
targeting_type
CAMPAIGN_HISTORY ⇱
id 🔑
last_update_date 🔑
campaign_id ➤ CAMPAIGN_HISTORY.id
creation_date
default_bid
name
serving_status
state
AD_GROUP_HISTORY ⇱
id 🔑
last_updated_date 🔑
ad_group_id ➤ AD_GROUP_HISTORY
campaign_id ➤ CAMPAIGN_HISTORY
bid
creation_date
keyword_text
match_type
native_language_keyword
native_language_locale
serving_status
state
KEYWORD_HISTORY ⇱
id 🔑
last_updated_date 🔑
campaign_id ➤ CAMPAIGN_HISTORY
ad_group_id ➤ AD_GROUP_HISTORY
creation_date
keyword_text
match_type
native_language_keyword
native_language_locale
serving_status
state
NEGATIVE_KEYWORD_HISTORY ⇱
name 🔑
keyword_id 🔑 ➤ KEYWORD_HISTORY
help_url
message
CAMPAIGN_NEGATIVE_KEYWORD_SERVING_STATUS_DETAIL ⇱
_fivetran_id 🔑
campaign_id ➤ CAMPAIGN_HISTORY.id
ad_group_id ➤ AD_GROUP_HISTORY.id
keyword_text
match_type
state
AD_GROUP_SUGGESTED_KEYWORD ⇱
_fivetran_id 🔑
asin
keyword_text
match_type
ASIN_SUGGESTED_KEYWORD ⇱
ad_id 🔑
last_updated_date 🔑
ad_group_id ➤ AD_GROUP_HISTORY.id
campaign_id ➤ CAMPAIGN_HISTORY.id
asin
creation_date
custom_text
sku
serving_status
state
PRODUCT_AD_HISTORY ⇱
name 🔑
product_ad_id 🔑 ➤ PRODUCT_AD_HISTORY
help_url
message
PRODUCT_AD_SERVING_STATUS_DETAIL ⇱
target_id 🔑
last_updated_date 🔑
ad_group_id ➤ AD_GROUP_HISTORY
campaign_id ➤ CAMPAIGN_HISTORY
bid
creation_date
expression_type
serving_status
state
TARGETING_CLAUSE_HISTORY ⇱
_fivetran_id 🔑
target_id ➤ TARGETING_CLAUSE_HISTORY
type
value
TARGETING_EXPRESSION ⇱
_fivetran_id 🔑
target_id ➤ TARGETING_CLAUSE_HISTORY
type
value
TARGETING_RESOLVED_EXPRESSION ⇱
target_id 🔑
last_updated_date 🔑
ad_group_id ➤ AD_GROUP_HISTORY
campaign_id ➤ CAMPAIGN_HISTORY
creation_date
expression_type
serving_status
state
NEGATIVE_TARGETING_CLAUSE_HISTORY ⇱
id 🔑
budget_increase_by_type
budget_increase_by_value
created_date
date_range_type_duration_end_date
date_range_type_duration_start_date
event_type_rule_duration_end_date
event_type_rule_duration_event_id
event_type_rule_duration_event_name
event_type_rule_duration_start_date
last_updated_date
name
preformance_measure_comparison_operator
preformance_measure_metric_name
preformance_measure_treshold
recurrence_type
state
status
type
BUDGET_RULE ⇱
campaign_id 🔑➤ CAMPAIGN_HISTORY.id
rule_id 🔑 ➤ BUDGET_RULE.rule_id
BUDGET_RULE_CAMPAIGN ⇱
day_of_week 🔑
rule_id 🔑 ➤ BUDGET_RULE.rule_id
BUDGET_RULE_RECURRENCE_DAY ⇱
_fivetran_id 🔑
target_id ➤ NEGATIVE_TARGETING_CLAUSE_HISTORY
type
value
NEGATIVE_TARGETING_EXPRESSION ⇱
_fivetran_id 🔑
target_id ➤ NEGATIVE_TARGETING_CLAUSE_HISTORY
type
value
NEGATIVE_TARGETING_RESOLVED_EXPRESSION ⇱
id 🔑
last_update_date 🔑
profile_id ➤ PROFILE
budget_amount
budget_currency_code
budget_end_date
budget_policy
budget_start_date
creation_date
in_budget
name
serving_status
state
PORTFOLIO_HISTORY ⇱
date 🔑
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id
_metrics
CAMPAIGN_LEVEL_REPORT ⇱
date 🔑
placement 🔑
_metrics
CAMPAIGN_PLACEMENT_REPORT ⇱
date 🔑
ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id
keyword_id 🔑 ➤ KEYWORD_HISTORY.id
_metrics
TARGETING_KEYWORD_REPORT ⇱
date 🔑�search_term
ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id
keyword_id 🔑 ➤ KEYWORD_HISTORY.id
_metrics
SEARCH_TERM_AD_KEYWORD_REPORT ⇱
date 🔑
ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id
_metrics
AD_GROUP_LEVEL_REPORT ⇱
date 🔑
ad_id 🔑 ➤ PRODUCT_AD_HISTORY
ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id
_metrics
ADVERTISED_PRODUCT_REPORT ⇱
date 🔑
purchased_asin 🔑
ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id
keyword_id 🔑 ➤ KEYWORD_HISTORY.id
_metrics
PURCHASED_PRODUCT_KEYWORD_REPORT ⇱
date 🔑�search_term
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
_metrics
SEARCH_TERM_TARGETING_REPORT ⇱
date 🔑
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
campaign_id 🔑 ➤ CAMPAIGN_HISTORY�keyword_id 🔑 ➤ TARGETING_EXPRESSION.target_id
_metrics
TARGETING_REPORT ⇱
date 🔑
purchased_asin 🔑
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
keyword_id 🔑 ➤ KEYWORD_HISTORY.id
_metrics
PURCHASED_PRODUCT_TARGETING_REPORT ⇱
name 🔑
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
help_url
message
CAMPAIGN_SERVING_STATUS_DETAIL ⇱
placement 🔑
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
percentage
CAMPAIGN_PLACEMENT_BIDDING ⇱
name 🔑
campaign_id 🔑 ➤ CAMPAIGN_HISTORY
value
CAMPAIGN_TAG ⇱
name 🔑
ad_group_id 🔑 ➤ AD_GROUP_HISTORY
help_url
message
AD_GROUP_SERVING_STATUS_DETAIL ⇱
name 🔑
keyword_id 🔑 ➤ KEYWORD_HISTORY
help_url
message
KEYWORD_SERVING_STATUS_DETAIL ⇱
name 🔑
keyword_id 🔑 ➤ KEYWORD_HISTORY
help_url
message
NEGATIVE_KEYWORD_SERVING_STATUS_DETAIL ⇱
id 🔑
last_updated_date 🔑
campaign_id ➤ CAMPAIGN_HISTORY
creation_date
keyword_text
match_type
serving_status
state
CAMPAIGN_NEGATIVE_KEYWORD_HISTORY ⇱
name 🔑
target_id 🔑 ➤ TARGETING_CLAUSE_HISTORY
help_url
level
TARGETING_SERVING_STATUS_DETAIL ⇱
name 🔑
target_id 🔑 ➤ TARGETING_CLAUSE_HISTORY
help_url
level
NEGATIVE_TARGETING_SERVING_STATUS_DETAIL ⇱
Sponsored Products
id 🔑
account_id
account_marketplace_string_id
account_name
account_sub_type
account_type
account_valid_payment_method
currency_code
country_code
daily_budget
timezone
PROFILE ⇱
_fivetran_id 🔑
profile_id ➤ PROFILE
asin
estimated_impression_lower
estimated_impression_upper
strategy
targeting_type
theme
ASIN_THEME_BASED_BID_RECOMMENDATION ⇱
parent_id 🔑➤ ASIN_THEME_BASED_BID_RECOMMENDATION
index 🔑
suggested_bid
ASIN_BID_RECOMMENDATION_VALUE ⇱
_fivetran_id 🔑
profile_id ➤ PROFILE
asin ➤ AD_GROUP_HISTORY
bid
estimated_impression_avg
estimated_impression_lower
estimated_impression_upper
placement
strategy
targeting_type
theme
type_of_bid
ASIN_BID_ANALYSIS ⇱
_fivetran_id 🔑
ad_group_id ➤ AD_GROUP_HISTORY
campaign_id ➤ CAMPAIGN_HISTORY
profile_id ➤ PROFILE
estimated_impression_lower
estimated_impression_upper
targeting_type
theme
AD_GROUP_THEME_BASED_BID_RECOMMENDATION ⇱
parent_id 🔑 ➤ AD_GROUP_THEME_BASED_BID_RECOMMENDATION
index 🔑
suggested_bid
AD_GROUP_BID_RECOMMENDATION_VALUE ⇱
_fivetran_id 🔑
ad_group_id ➤ AD_GROUP_HISTORY
campaign_id ➤ CAMPAIGN_HISTORY
profile_id ➤ PROFILE
bid
estimated_impression_avg
estimated_impression_lower
estimated_impression_upper
placement
targeting_type
theme
type_of_bid
AD_GROUP_BID_ANALYSIS ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
last_updated_date 🔑
portfolio_id ➤ PORTFOLIO_HISTORY
profile_id ➤ PROFILE
budget
budget_type
cost_type
creation_date
delivery_profile
end_date
name
serving_status
start_date
state
tactic
SD_CAMPAIGN_HISTORY ⇱
id 🔑
last_updated_date 🔑
campaign_id ➤ SD_CAMPAIGN_HISTORY.id
bid_optimization
creation_date
creative_type
default_bid
name
serving_status
state
tactic
SD_AD_GROUP_HISTORY ⇱
id 🔑
last_updated_date 🔑
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
campaign_id ➤ SD_CAMPAIGN_HISTORY.id
ad_name
asin
creation_date
landing_page_type
landing_page_url
serving_status
sku
state
SD_PRODUCT_AD_HISTORY ⇱
id 🔑
last_updated_date 🔑
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
bid
creation_date
expression_type
serving_status
state
SD_TARGETING_HISTORY ⇱
id 🔑
last_updated_date 🔑
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
creation_date
expression_type
serving_status
state
SD_NEGATIVE_TARGETING_HISTORY ⇱
_fivetran_id 🔑
target_id ➤ SD_NEGATIVE_TARGETING_HISTORY.id
value
type
SD_NEGATIVE_TARGETING_RESOLVED_EXPRESSION ⇱
domain_id 🔑
last_modified 🔑
created_at
name
state
type
SD_BRAND_SAFETY_HISTORY ⇱
request_id 🔑
domain_id ➤ SD_BRAND_SAFETY_HISTORY
details
status
SD_BRAND_SAFETY_STATUS_HISTORY ⇱
id 🔑
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
creative_type
properties_*
SD_CREATIVE ⇱
moderation_status 🔑
creative_id 🔑 ➤ SD_CREATIVE.id
eta_for_moderation
SD_CREATIVE_MODERATION ⇱
report_date 🔑
tactic 🔑
campaign_id 🔑➤ SD_CAMPAIGN_HISTORY.id
_metrics
SD_CAMPAIGN_REPORT_V_2 ⇱
report_date 🔑
tactic 🔑
ad_group_id 🔑 ➤ SD_AD_GROUP_HISTORY.id
campaign_id ➤ SD_CAMPAIGN_HISTORY.id
_metrics
SD_AD_GROUP_REPORT_V_2 ⇱
report_date 🔑
tactic 🔑
ad_id 🔑 ➤ SD_PRODUCT_AD_HISTORY.id
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
campaign_id ➤ SD_CAMPAIGN_HISTORY.id
_metrics
SD_PRODUCT_AD_REPORT_V_2 ⇱
report_date 🔑
tactic 🔑
target_id 🔑 ➤ SD_TARGETING_HISTORY.id
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
campaign_id ➤ SD_CAMPAIGN_HISTORY.id
_metrics
SD_TARGET_REPORT_V_2 ⇱
_fivetran_id 🔑
report_date 🔑
tactic 🔑
asin
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
campaign_id ➤ SD_CAMPAIGN_HISTORY.id
_metrics
SD_ASIN_REPORT_V_2 ⇱
report_date 🔑
tactic 🔑
target_id 🔑 ➤ SD_TARGETING_HISTORY.id
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
campaign_id ➤ SD_CAMPAIGN_HISTORY.id
_metrics
SD_MATCHED_TARGET_REPORT_V_2 ⇱
asin 🔑
target_asin 🔑
rank
SD_TARGETING_RECOMMENDATION_PRODUCT ⇱
category 🔑
target_asin 🔑
tactic 🔑
name
rank
targetable_asin_count_range_lower
targetable_asin_count_range_upper
translated_name
SD_TARGETING_RECOMMENDATION_CATEGORY ⇱
audience 🔑
target_asin 🔑
category
name
rank
SD_TARGETING_RECOMMENDATION_AUDIENCE ⇱
Sponsored Display
Reports V2 (Deprecated)
asin 🔑
target_id 🔑 ➤ SD_TARGETING_HISTORY.id
bid_optimization
cost_type
range_lower
range_upper
recommended
SD_BID_RECOMMENDATION ⇱
_fivetran_id 🔑
target_id ➤ SD_NEGATIVE_TARGETING_HISTORY.id
value
type
SD_NEGATIVE_TARGETING_EXPRESSION ⇱
id 🔑
last_updated_date 🔑
campaign_id 🔑 ➤ SD_CAMPAIGN_HISTORY.id
created_date
rule_state
rule_status
rule_detail_*
SD_BUDGET_RULE_HISTORY ⇱
usage_updated_timestamp 🔑
campaign_id 🔑 ➤ SD_CAMPAIGN_HISTORY.id
budget
budget_usage_percent
SD_BUDGET_USAGE_HISTORY ⇱
_fivetran_id 🔑
target_id ➤ SD_TARGETING_HISTORY.id
value
type
SD_TARGETING_EXPRESSION ⇱
_fivetran_id 🔑
target_id ➤ SD_TARGETING_HISTORY.id
value
type
SD_TARGETING_RESOLVED_EXPRESSION ⇱
date 🔑
campaign_id 🔑 ➤ SD_CAMPAIGN_HISTORY.id
_metrics
SD_CAMPAIGN_REPORT ⇱
date 🔑
ad_group_id 🔑 ➤ SD_AD_GROUP_HISTORY.id
campaign_id ➤SD_CAMPAIGN_HISTORY.id
_metrics
SD_AD_GROUP_REPORT ⇱
date 🔑
ad_id 🔑 ➤ SD_AD_GROUP_HISTORY.id
ad_group_id ➤ SD_AD_GROUP_HISTORY.id
campaign_id ➤SD_CAMPAIGN_HISTORY.id
_metrics
SD_PRODUCT_AD_REPORT ⇱
date 🔑
ad_group_id 🔑
asin_brand_halo 🔑
campaign_id 🔑 ➤ SD_CAMPAIGN_HISTORY.id
promoted_asin 🔑
promoted_sku 🔑
_metrics
SD_PURCHASED_PRODUCTS_REPORTS ⇱
date 🔑
ad_group_id 🔑 ➤ SD_AD_GROUP_HISTORY.id
campaign_id 🔑 ➤SD_CAMPAIGN_HISTORY.id
targeting_id 🔑 ➤SD_TARGETING_HISTORY.id
_metrics
SD_TARGET_REPORT ⇱
date 🔑
ad_group_id 🔑 ➤ SD_AD_GROUP_HISTORY.id
campaign_id 🔑 ➤SD_CAMPAIGN_HISTORY.id
matched_target_asin
targeting_id 🔑 ➤SD_TARGETING_HISTORY.id
_metrics
SD_MATCHED_TARGET_REPORT ⇱
Reports V3
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
= deprecated endpoints
id 🔑
last_updated_date 🔑
brand_entity_id ➤ SB_BRAND
portfolio_id ➤ PORTFOLIO_HISTORY
profile_id ➤ PROFILE
bid_optimization
bid_optimization_strategy
budget
budget_type
creation_date
end_date
goal
is_multi_ad_groups_enabled
name
product_location
rule_based_budget_applicable_rule_id
rule_based_budget_applicable_rule_name
rule_based_budget_is_processing
rule_based_budget_value
start_date
state
SB_CAMPAIGN_HISTORY ⇱
shopper_segment 🔑
campaign_id 🔑➤ SB_CAMPAIGN_HISTORY
percentage
SB_CAMPAIGN_BID_ADJUSTMENTS_BY_SHOPPER_SEGMENT ⇱
placement 🔑
campaign_id 🔑➤ SB_CAMPAIGN_HISTORY
percentage
SB_CAMPAIGN_BID_ADJUSTMENTS_BY_PLACEMENT ⇱
tag_name 🔑
campaign_id 🔑➤ SB_CAMPAIGN_HISTORY
value
SB_CAMPAIGN_TAG ⇱
id 🔑
last_update_date 🔑
campaign_id ➤ SB_CAMPAIGN_HISTORY
creation_date
name
serving_status
state
SB_AD_GROUP_HISTORY ⇱
seven_days_start_date 🔑
seven_days_end_date 🔑
campaign_id 🔑➤ SB_CAMPAIGN_HISTORY.id
seven_days_estimated_clicks_lower
seven_days_estimated_clicks_upper
seven_days_estimated_impressions_lower
seven_days_estimated_impressions_upper
seven_days_estimated_missed_sales_lower
seven_days_estimated_missed_sales_upper
seven_days_percent_time_in_budget
suggested_budget
SB_BUDGET_RECOMMENDATION_HISTORY ⇱
_fivetran_id 🔑
last_update_date 🔑
campaign_id ➤ SB_CAMPAIGN_HISTORY
ad_group_id
creation_date
id
landing_page_page_type
landing_page_url
name
serving_status
state
SB_AD_HISTORY ⇱
asin 🔑
ad_id 🔑➤ SB_AD_HISTORY
SB_AD_LANDING_PAGE_ASIN ⇱
_fivetran_id 🔑
ad_id ➤ SB_AD_HISTORY
brand_logo_asset_id
brand_logo_crop_height
brand_logo_crop_left
brand_logo_crop_top
brand_logo_crop_width
brand_logo_url
brand_name
creation_time
creative_type
creative_version
creative_status
custom_image_asset_id
custom_image_crop_height
custom_image_crop_left
custom_image_crop_top
custom_image_crop_width
custom_image_url
headline
last_update_time
landing_page_type
landing_page_value
SB_CREATIVE_HISTORY ⇱
asset_id 🔑
_fivetran_id 🔑➤ SB_CREATIVE_HISTORY
crop_height
crop_left
crop_top
crop_width
url
SB_CREATIVE_CUSTOM_IMAGE ⇱
asin 🔑
_fivetran_id 🔑➤ SB_CREATIVE_HISTORY
SB_CREATIVE_ASIN ⇱
asin 🔑
url 🔑
_fivetran_id 🔑➤ SB_CREATIVE_HISTORY
page_title
SB_CREATIVE_SUB_PAGE ⇱
id 🔑
_fivetran_id 🔑➤ SB_CREATIVE_HISTORY
SB_CREATIVE_ORIGINAL_VIDEO_ASSET ⇱
id 🔑
last_updated_date 🔑
budget_increase_by_type
budget_increase_by_value
created_date
date_range_type_duration_end_date
date_range_type_duration_start_date
event_type_rule_duration_end_date
event_type_rule_duration_event_id
event_type_rule_duration_event_name
event_type_rule_duration_start_date
name
preformance_measure_comparison_operator
preformance_measure_metric_name
preformance_measure_treshold
recurrence_type
status
type
SB_BUDGET_RULE_HISTORY ⇱
day_of_week 🔑
rule_id 🔑 ➤ SB_BUDGET_RULE_HISTORY
SB_BUDGET_RULE_RECURRENCE_DAY ⇱
campaign_id 🔑➤ SB_CAMPAIGN_HISTORY
rule_id 🔑 ➤ SB_BUDGET_RULE_HISTORY
SB_BUDGET_RULE_CAMPAIGN ⇱
usage_updated_timestamp 🔑
campaign_id 🔑➤ SB_CAMPAIGN_HISTORY
budget
budget_usage_percent
SB_BUDGET_USAGE_HISTORY ⇱
id 🔑
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
keyword_text
match_type
native_language_keyword
state
SB_KEYWORD ⇱
id 🔑
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
keyword_text
match_type
state
SB_NEGATIVE_KEYWORD ⇱
entity_id 🔑
brand_entity_id
store_name
SB_STORE ⇱
id 🔑
entity_id 🔑➤ SB_STORE.entity_id
name
url
SB_STORE_PAGE_INFO ⇱
_fivetran_id 🔑
id
entity_id
registry_name
SB_BRAND ⇱
_fivetran_id 🔑
date 🔑
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
attribution_type
campaign_budget_currency_code
product_category
product_name
purchased_asin
_metrics
REPORTS
id 🔑
_fivetran_id 🔑➤ SB_CREATIVE_HISTORY
SB_CREATIVE_VIDEO_ASSET ⇱
event_id 🔑
campaign_id 🔑➤ SB_CAMPAIGN_HISTORY
end_date
event_name
start_date
suggested_budget_increase_percent
SB_BUDGET_RULE_RECOMMENDATION ⇱
id 🔑
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
bid
state
SB_PRODUCT_TARGET ⇱
id 🔑
asin_count_range_max
asin_count_range_min
estimated_reach_max
estimated_reach_min
is_targetable
name
parent_category_refinement_id
supply_source
translated_name
SB_PRODUCT_TARGETING_CATEGORY ⇱
id 🔑
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
bid
state
SB_NEGATIVE_PRODUCT_TARGET ⇱
asin 🔑
recommended_target_asin
SB_TARGETING_RECOMMENDATION_PRODUCT ⇱
asin 🔑
id 🔑➤ SB_PRODUCT_TARGETING_CATEGORY�estimated_reach
is_targetable
name
path
supply_source
translated_name
translated_path
SB_TARGETING_RECOMMENDATION_CATEGORY ⇱
brand_id 🔑➤ SB_BRAND
category_id 🔑➤ SB_PRODUCT_TARGETING_CATEGORY�brand_name
SB_TARGETING_RECOMMENDATION_BRAND_CATEGORY ⇱
asin 🔑
id 🔑
match_type
search_term_impression_rank
search_term_impression_share
translation
type
value
SB_KEYWORD_RECOMMENDATION_ASIN ⇱
id 🔑
url 🔑
match_type
search_term_impression_rank
search_term_impression_share
translation
type
url_type
value
SB_KEYWORD_RECOMMENDATION_URL ⇱
_fivetran_id 🔑
_fivetran_violation_policy_id 🔑➤ SB_CAMPAIGN_VIOLATION_POLICY
moderated_component
reviewed_text
SB_CAMPAIGN_VIOLATION_TEXT_CONTENT ⇱
campaign_id 🔑➤ SB_CAMPAIGN_HISTORY
eta_for_moderation
moderation_status
SB_CAMPAIGN_MODERATION ⇱
_fivetran_id 🔑
campaign_id ➤ SB_CAMPAIGN_HISTORY
policy_description
policy_link_url
SB_CAMPAIGN_VIOLATION_POLICY ⇱
violating_text 🔑
_fivetran_violation_text_content_id 🔑 ➤ SB_CAMPAIGN_VIOLATION_TEXT_CONTENT
text_position_start
text_position_end
SB_CAMPAIGN_VIOLATION_TEXT_EVIDENCE ⇱
_fivetran_id 🔑
_fivetran_violation_policy_id 🔑➤ SB_CAMPAIGN_VIOLATION_POLICY
moderated_component
reviewed_image_url
SB_CAMPAIGN_VIOLATION_IMAGE_CONTENT ⇱
_fivetran_id 🔑
_fivetran_violation_image_content_id 🔑 ➤ SB_CAMPAIGN_VIOLATION_IMAGE_CONTENT
image_crop_top_left_x
image_crop_top_left_y
image_crop_height
image_crop_width
SB_CAMPAIGN_VIOLATION_IMAGE_EVIDENCE ⇱
_fivetran_id 🔑
_fivetran_violation_policy_id 🔑➤ SB_CAMPAIGN_VIOLATION_POLICY
moderated_component
SB_CAMPAIGN_VIOLATION_ASIN_CONTENT ⇱
asin 🔑
_fivetran_violation_asin_content_id 🔑 ➤ SB_CAMPAIGN_VIOLATION_ASIN_CONTENT
SB_CAMPAIGN_VIOLATION_ASIN_EVIDENCE ⇱
brand_name 🔑 ➤ SB_BRAND
category_id 🔑 ➤ SB_PRODUCT_TARGETING_CATEGORY
start_date 🔑
end_date 🔑
acos_median
acos_top_25_pct
acos_value
acos_bottom_25_pct
ctr_median
ctr_top_25_pct
ctr_value
ctr_bottom_25_pct
impressions_median
impressions_top_25_pct
impressions_value
impressions_bottom_25_pct
roas_median
roas_top_25_pct
roas_value
roas_bottom_25_pct
SB_BENCHMARK_BRAND_AND_CATEGORY_REPORT ⇱
id 🔑
brand_entity_id 🔑➤ SB_BRAND.entity_id
height
media_type
name
url
width
SB_STORE_ASSET ⇱
type 🔑
target_id 🔑 ➤ SB_PRODUCT_TARGET
value
SB_PRODUCT_TARGET_EXPRESSION ⇱
target_id 🔑 ➤ SB_PRODUCT_TARGET
type 🔑
value
SB_PRODUCT_TARGET_RESOLVED_EXPRESSION ⇱
report_date 🔑
ad_group_id 🔑 ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
_metrics
report_date 🔑
target_id 🔑 ➤ SB_PRODUCT_TARGET
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
_metrics
report_date 🔑
keyword_id 🔑 ➤ SB_KEYWORD
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
_metrics
report_date 🔑
query_term 🔑
keyword_id 🔑➤ SB_KEYWORD
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
_metrics
report_date 🔑
_fivetran_id 🔑➤ SB_AD_HISTORY
ad_id ➤ SB_AD_HISTORY
ad_group_id ➤ SB_AD_GROUP_HISTORY
campaign_id ➤ SB_CAMPAIGN_HISTORY
_metrics
Version 2 ⇱
Version 3 ⇱
Others
type 🔑
target_id 🔑 ➤ SB_PRODUCT_TARGET
value
SB_NEGATIVE_PRODUCT_TARGET_EXPRESSION ⇱
target_id 🔑 ➤ SB_PRODUCT_TARGET
type 🔑
value
SB_NEGATIVE_PRODUCT_TARGET_RESOLVED_EXPRESSION ⇱
Sponsored Brands