Edit on GitHub
Microsoft 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.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| Custom data | check | KEYWORD_CUSTOM_PARAMETER_HISTORY, AD_CUSTOM_PARAMETER_HISTORY, CAMPAIGN_CUSTOM_PARAMETER_HISTORY and AD_GROUP_CUSTOM_PARAMETER_HISTORY tables. |
| Data blocking | check | Column level and table level |
| Column hashing | check | |
| Re-sync | check | Table level. Metadata tables are being re-synced all together in case of triggering the re-sync for one of them |
| History | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | Reporting tables |
| Fivetran data models | check | Get the models: source / transform; Get the ad reporting model; Supports Quickstart data models |
| Private networking |
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.
ACCOUNT_PERFORMANCE_DAILY_REPORT & ACCOUNT_PERFORMANCE_HOURLY_REPORTlink
| 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* | |
ACCOUNT_IMPRESSION_PERFORMANCE_DAILY_REPORTlink
| 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* |
ACCOUNT_IMPRESSION_PERFORMANCE_HOURLY_REPORTlink
| 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* |
AD_GROUP_PERFORMANCE_DAILY_REPORTlink
| 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* | |
AD_GROUP_PERFORMANCE_HOURLY_REPORTlink
| 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* |
AD_GROUP_IMPRESSION_PERFORMANCE_DAILY_REPORTlink
| 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* | |
AD_GROUP_IMPRESSION_PERFORMANCE_HOURLY_REPORTlink
| 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* |
CAMPAIGN_PERFORMANCE_DAILY_REPORTlink
| 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* |
CAMPAIGN_PERFORMANCE_HOURLY_REPORTlink
| 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* | |
CAMPAIGN_IMPRESSION_PERFORMANCE_DAILY_REPORTlink
| 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* |
CAMPAIGN_IMPRESSION_PERFORMANCE_HOURLY_REPORTlink
| 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* | |
PRODUCT_DIMENSION_PERFORMANCE_DAILY_REPORT & PRODUCT_DIMENSION_PERFORMANCE_HOURLY_REPORTlink
| 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* |
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_DAILY_REPORT & PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_HOURLY_REPORTlink
| 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* |
AD_PERFORMANCE_DAILY_REPORT & AD_PERFORMANCE_HOURLY_REPORTlink
| 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 |
KEYWORD_PERFORMANCE_DAILY_REPORTlink
| 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* |
KEYWORD_PERFORMANCE_HOURLY_REPORTlink
| 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* | |
USER_LOCATION_PERFORMANCE_DAILY_REPORT & USER_LOCATION_PERFORMANCE_HOURLY_REPORTlink
| 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* | |
SEARCH_QUERY_PERFORMANCE_DAILY_REPORT & SEARCH_QUERY_PERFORMANCE_HOURLY_REPORTlink
| 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 |
PRODUCT_SEARCH_QUERY_PERFORMANCE_DAILY_REPORT & PRODUCT_SEARCH_QUERY_PERFORMANCE_HOURLY_REPORTlink
| 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, underall_revenue metrics*we mean the following metric columns:all_revenueandall_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_historyad_custom_parameter_historyad_group_custom_parameter_historyad_group_history,ad_group_label_historyad_historyad_label_historyad_publisher_countrybudget_historycampaign_custom_parameter_historycampaign_historycampaign_label_historykeyword_custom_parameter_historykeyword_historykeyword_label_historykeyword_publisher_countrylabel_history