Edit on GitHubMicrosoft Advertising link Updated November 17, 2023
Microsoft Advertising (formerly known as Bing Ads) is a service that provides pay-per-click advertising for both the Bing and Yahoo search engines. To get an overview of Microsoft Advertising, see its entity hierarchy and limits documentation .
Our Microsoft Advertising connector queries for metadata and performance reports for all your accounts and syncs the data into your destination.
Setup guidelink Follow our step-by-step Microsoft Advertising setup guide to connect Microsoft Advertising with your destination using Fivetran connectors.
Sync overviewlink Rollback synclink A rollback sync is a sync that automatically starts once a day. Rollback syncs capture the changes that happen outside of the incremental sync time frame. You can configure this parameter in the setup form.
NOTE: Fivetran does not automatically capture the conversion window size.
IMPORTANT: Since we only run the rollback once a day, we recommend that you set a greater rollback window size for your Microsoft Advertising connector than your conversion window value set in Microsoft Advertising to capture all conversion data. For example, our default rollback window size of 35 days corresponds to the default Microsoft conversion window value of 30 days .
Multithreadinglink The Microsoft Advertising connector supports multithreading. Fivetran uses multiple parallel API requests to sync Ads data from your Microsoft Advertising account to your destination. The connector’s sync speed depends on your Microsoft Advertising account metadata.
Schema informationlink This schema applies to all Microsoft Advertising connectors.
Microsoft Advertising Schemalink To zoom, open the ERD in a new window. Schema noteslink In the ACCOUNT_HISTORY
table, we add last_modified_time
as EPOCH for the accounts
which do not have a last_modified_time
.
The Microsoft Advertising Bulk API doesn't return deleted entities (for example, campaigns
, ad groups
, ads
, and keywords
). Deleted entities are therefore not included in metadata
tables, but you can still find them in different report
tables.
Report Tableslink These are the report tables synced by our Microsoft Advertising connector.
COLUMN REFERENCE account_id 🔑 account_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 device_os 🔑 top_vs_other 🔑 bid_match_type 🔑 phone_impressions phone_calls clicks ctr spend impressions cost_per_conversion ptr assists return_on_ad_spend cost_per_assist all_conversions_qualified view_through_conversions_qualified average metrics* conversion metrics* low_quality metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 clicks ctr spend cost_per_conversion phone_impressions phone_calls ptr assists cost_per_assist all_conversions_qualified view_through_conversions_qualified exact_match_impression_share_percent absolute_top_impression_share_percent click_share_percent average metrics* conversion metrics* low_quality metrics* revenue metrics* impression metrics*
COLUMN REFERENCE account_id 🔑 account_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 clicks ctr spend cost_per_conversion phone_impressions phone_calls ptr assists cost_per_assist exact_match_impression_share_percent impressions average metrics* conversion metrics* low_quality metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 device_os 🔑 top_vs_other 🔑 bid_match_type 🔑 language 🔑 impressions clicks ctr spend cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience phone_impressions phone_calls ptr assists cost_per_assist custom_parameters final_url_suffix view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* average metrics* conversion metrics* historical metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 device_os 🔑 top_vs_other 🔑 bid_match_type 🔑 language 🔑 impressions clicks ctr spend cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience phone_impressions phone_calls ptr assists cost_per_assist final_url_suffix custom_parameters view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* average metrics* conversion metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 language 🔑 network 🔑 delivered_match_type 🔑 clicks ctr spend cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience phone_impressions phone_calls ptr assists return_on_ad_spend cost_per_assist final_url_suffix custom_parameters exact_match_impression_share_percent absolute_top_impression_share_percent click_share_percent view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* top_impression metrics* absolute_top_impression metrics* average metrics* conversion metrics* historical metrics* revenue metrics* impression metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 language 🔑 network 🔑 delivered_match_type 🔑 clicks ctr spend cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience phone_impressions phone_calls ptr assists return_on_ad_spend cost_per_assist final_url_suffix custom_parameters exact_match_impression_share_percent impressions view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* top_impression metrics* absolute_top_impression metrics* average metrics* conversion metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 device_os 🔑 top_vs_other 🔑 bid_match_type 🔑 campaign_status impressions clicks ctr spend cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience phone_impressions phone_calls ptr assists return_on_ad_spend cost_per_assist custom_parameters view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* average metrics* conversion metrics* low_quality metrics* historical metrics* revenue metrics* budget metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 device_os 🔑 top_vs_other 🔑 bid_match_type 🔑 campaign_status impressions clicks ctr spend cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience phone_impressions phone_calls ptr assists return_on_ad_spend cost_per_assist custom_parameters view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* average metrics* conversion metrics* low_quality metrics* revenue metrics* budget metrics*
COLUMN REFERENCE date 🔑 account_id 🔑 account_history campaign_id 🔑 campaign_history currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 campaign_status clicks ctr spend cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience phone_impressions phone_calls ptr assists return_on_ad_spend cost_per_assist custom_parameters exact_match_impression_share_percent absolute_top_impression_share_percent click_share_percent view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* top_impression metrics* absolute_top_impression metrics* impression metrics* average metrics* conversion metrics* low_quality metrics* historical metrics* revenue metrics*
COLUMN REFERENCE date 🔑 account_id 🔑 account_history campaign_id 🔑 campaign_history currency_code 🔑 ad_distribution 🔑 device_type 🔑 network 🔑 delivered_match_type 🔑 campaign_status clicks ctr spend cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience phone_impressions phone_calls ptr assists return_on_ad_spend cost_per_assist custom_parameters exact_match_impression_share_percent impressions view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* top_impression metrics* absolute_top_impression metrics* average metrics* conversion metrics* low_quality metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history ad_id 🔑 ad_history date 🔑 network 🔑 currency_code 🔑 device_type 🔑 language 🔑 merchant_product_id 🔑 condition 🔑 price 🔑 top_vs_other 🔑 ad_distribution 🔑 click_type_id 🔑 bid_strategy_type 🔑 store_id 🔑 brand local_store_code click_type title impressions clicks ctr average_cpc spend seller_name offer_language country_of_sale return_on_ad_spend total_clicks_on_ad_elements assisted_impressions assisted_clicks all_conversions_qualified view_through_conversions_qualified conversion metrics* custom_label metrics* product_category metrics* product_type metrics* revenue metrics*
COLUMN REFERENCE date 🔑 account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history currency_code 🔑 device_type 🔑 merchant_product_id 🔑 condition 🔑 price 🔑 bid_strategy_type 🔑 store_id 🔑 brand title impressions clicks ctr average_cpc spend seller_name offer_language country_of_sale total_clicks_on_ad_elements return_on_ad_spend absolute_top_impression_share_percent click_share_percent assisted_impressions assisted_clicks all_conversions_qualified view_through_conversions_qualified custom_label metrics* product_type metrics* product_category metrics* impression metrics* benchmark metrics* conversion metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history ad_id 🔑 ad_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 language 🔑 network 🔑 device_os 🔑 top_vs_other 🔑 bid_match_type 🔑 delivered_match_type 🔑 impressions clicks ctr average_cpc spend average_position conversions conversions_qualified conversion_rate cost_per_conversion destination_url assists return_on_ad_spend cost_per_assist custom_parameters final_app_url ad_description ad_description_2 view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* revenue metrics*
AD_EXTENSION_DETAIL_DAILY_REPORT & AD_EXTENSION_DETAIL_HOURLY_REPORTlink COLUMN REFERENCE _fivetran_id 🔑 account_id account_history campaign_id campaign_history ad_group_id ad_group_history ad_id ad_history date ad_extension_type_id device_type network device_os top_vs_other bid_match_type delivered_match_type account_name campaign_name ad_group_name ad_title ad_extension_type ad_extension_id ad_extension_version ad_extension_property_value impressions clicks ctr conversions conversions_qualified cost_per_conversion conversion_rate spend average_cpc assists revenue return_on_ad_spend cost_per_assist revenue_per_conversion revenue_per_assist account_status campaign_status ad_group_status ad_status all_conversions all_conversions_qualified all_revenue all_conversion_rate all_cost_per_conversion all_return_on_ad_spend all_revenue_per_conversion goal goal_type
GOALS_AND_FUNNELS_DAILY_REPORT & GOALS_AND_FUNNELS_HOURLY_REPORTlink COLUMN REFERENCE _fivetran_id 🔑 account_id account_history campaign_id campaign_history ad_group_id ad_group_history keyword_id keyword_history date goal all_conversions all_conversions_qualified assists all_revenue goal_id device_type device_os goal_type view_through_conversions view_through_conversions_qualified
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history keyword_id 🔑 keyword_history ad_id 🔑 ad_history date 🔑 currency_code 🔑 delivered_match_type 🔑 ad_distribution 🔑 device_type 🔑 language 🔑 network 🔑 device_os 🔑 top_vs_other 🔑 bid_match_type 🔑 keyword_status impressions clicks ctr current_max_cpc average_cpc spend average_position conversions conversions_qualified conversion_rate cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience quality_impact assists return_on_ad_spend cost_per_assist custom_parameters final_app_url mainline_1_bid mainline_bid first_page_bid final_url_suffix view_through_conversions view_through_conversions_qualified all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* historical metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history keyword_id 🔑 keyword_history ad_id 🔑 ad_history date 🔑 currency_code 🔑 delivered_match_type 🔑 ad_distribution 🔑 device_type 🔑 language 🔑 network 🔑 device_os 🔑 top_vs_other 🔑 bid_match_type 🔑 keyword_status impressions clicks ctr current_max_cpc average_cpc spend average_position conversions conversion_rate cost_per_conversion quality_score expected_ctr ad_relevance landing_page_experience quality_impact assists return_on_ad_spend cost_per_assist custom_parameters final_app_url final_url_suffix mainline_1_bid mainline_bid first_page_bid view_through_conversions all_cost_per_conversion all_return_on_ad_spend all_conversion metrics* all_revenue metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history date 🔑 currency_code 🔑 ad_distribution 🔑 device_type 🔑 device_os 🔑 bid_match_type 🔑 delivered_match_type 🔑 network 🔑 language 🔑 location_id 🔑 query_intent_location_id 🔑 top_vs_other 🔑 account_name country state metro_area impressions clicks ctr average_cpc spend average_position proximity_target_location radius city assists return_on_ad_spend cost_per_conversion cost_per_assist county postal_code all_conversions_qualified view_through_conversions_qualified query metrics* conversion metrics* revenue metrics*
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history ad_id 🔑 ad_history keyword_id 🔑 keyword_history date 🔑 device_type 🔑 device_os 🔑 bid_match_type 🔑 delivered_match_type 🔑 network 🔑 language 🔑 top_vs_other 🔑 search_query 🔑 customer_id 🔑 destination_url impressions clicks ctr average_cpc spend average_position ad_group_criterion_id assists return_on_ad_spend cost_per_assist conversion metrics* revenue metrics*
SHARE_OF_VOICE_DAILY_REPORTlink COLUMN REFERENCE _fivetran_id 🔑 account_id account_history campaign_id campaign_history ad_group_id ad_group_history keyword_id keyword_history date device_type bid_match_type delivered_match_type network language account_name campaign_name ad_group_name keyword account_number impressions clicks ctr average_cpc spend average_position impression_share_percent impression_lost_to_budget_percent impression_lost_to_rank_agg_percent current_max_cpc quality_score expected_ctr ad_relevance landing_page_experience conversions conversions_qualified conversion_rate cost_per_conversion ad_distribution click_share_percent account_status campaign_status ad_group_status keyword_status bid_strategy_type keyword_labels exact_match_impression_share_percent top_impression_share_lost_to_rank_percent top_impression_share_lost_to_budget_percent absolute_top_impression_share_lost_to_rank_percent absolute_top_impression_share_lost_to_budget_percent absolute_top_impression_share_percent top_impression_share_percent absolute_top_impression_rate_percent top_impression_rate_percent base_campaign_id all_conversions all_conversions_qualified all_conversion_rate all_cost_per_conversion view_through_conversions view_through_conversions_qualified goal goal_type
COLUMN REFERENCE account_id 🔑 account_history campaign_id 🔑 campaign_history ad_group_id 🔑 ad_group_history ad_id 🔑 ad_history merchant_product_id 🔑 date 🔑 device_type 🔑 device_os 🔑 click_type_id 🔑 network 🔑 language 🔑 search_query 🔑 title 🔑 product_group 🔑 partition_type 🔑 customer_id 🔑 click_type account_name campaign_name destination_url total_clicks_on_ad_elements ad_group_criterion_id impressions clicks ctr average_cpc spend assists cost_per_assist customer_name assisted_impressions assisted_clicks conversion metrics* revenue metrics*
NOTE: The *
suffix in the column name means the name indicates several metrics of the same type. For example, under all_revenue metrics*
we mean the following metric columns: all_revenue
and all_revenue_per_conversion
.
NOTE: Each report table in the destination always contains all primary key columns. Non-primary key columns are included in the relevant table in the destination only if the source table has at least one record with a non-null value in a given non-primary key column.
Table re-synclink When the connector requests data from Microsoft Advertising, the data is retrieved in bulk. This means that a single response contains entities related to different tables, and all these tables share a common cursor. As a result, a re-sync of just a single entity table is not supported. When a re-sync of an entity table is triggered, the cursor for all entity tables is reset, and all entity tables are re-synced as well.
The following tables are entity tables:
ad_attribute_history
ad_custom_parameter_history
ad_group_custom_parameter_history
ad_group_history
, ad_group_label_history
ad_history
ad_label_history
ad_publisher_country
budget_history
campaign_custom_parameter_history
campaign_history
campaign_label_history
keyword_custom_parameter_history
keyword_history
keyword_label_history
keyword_publisher_country
label_history