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.
| Feature Name |
Supported |
Notes |
| Capture Deletes |
check |
CAMPAIGN_HISTORY, AD_GROUP_HISTORY, KEYWORD_HISTORY, AD_HISTORY, BUDGET_HISTORY, LABEL_HISTORY, CAMPAIGN_LABEL_HISTORY, AD_GROUP_LABEL_HISTORY, KEYWORD_LABEL_HISTORY and AD_LABEL_HISTORY tables. |
| 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 |
Table-level data blocking for reporting tables only |
| Column Hashing |
|
|
| Re-sync |
check |
Connector level |
| History |
check |
Tables with the _HISTORY suffix |
| API Configurable |
check |
|
| Priority-first sync |
check |
Reporting tables |
| dbt Package |
check |
Get the package: source / transform; Get the ad reporting package |
Setup guidelink
Follow our step-by-step Microsoft Advertising setup guide to connect Microsoft Advertising with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Microsoft Advertising connectors.
Microsoft Advertising Schemalink
To zoom, open ERD in 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.
Report Tableslink
These are the report tables synced by our Microsoft Advertising connector.
ACCOUNT_PERFORMANCE_DAILY_REPORT & ACCOUNT_PERFORMANCE_HOURLY_REPORT
| 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 |
|
| average metrics* |
|
| conversion metrics* |
|
| low_quality metrics* |
|
| revenue metrics* |
|
|
|
ACCOUNT_IMPRESSION_PERFORMANCE_DAILY_REPORT
| 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 |
|
| absolute_top_impression_share_percent |
|
| click_share_percent |
|
| average metrics* |
|
| conversion metrics* |
|
| low_quality metrics* |
|
| revenue metrics* |
|
| impression metrics* |
|
ACCOUNT_IMPRESSION_PERFORMANCE_HOURLY_REPORT
| 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_REPORT
| 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 🔑 |
|
| impressions |
|
| clicks |
|
| ctr |
|
| spend |
|
| cost_per_conversion |
|
| language |
|
| quality_score |
|
| expected_ctr |
|
| ad_relevance |
|
| landing_page_experience |
|
| phone_impressions |
|
| phone_calls |
|
| ptr |
|
| assists |
|
| cost_per_assist |
|
| custom_parameters |
|
| view_through_conversions |
|
| 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_REPORT
| 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 🔑 |
|
| impressions |
|
| clicks |
|
| ctr |
|
| spend |
|
| cost_per_conversion |
|
| language |
|
| quality_score |
|
| expected_ctr |
|
| ad_relevance |
|
| landing_page_experience |
|
| phone_impressions |
|
| phone_calls |
|
| ptr |
|
| assists |
|
| cost_per_assist |
|
| custom_parameters |
|
| view_through_conversions |
|
| 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_REPORT
| 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 |
|
| custom_parameters |
|
| exact_match_impression_share_percent |
|
| absolute_top_impression_share_percent |
|
| click_share_percent |
|
| view_through_conversions |
|
| 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_REPORT
| 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 |
|
| custom_parameters |
|
| exact_match_impression_share_percent |
|
| impressions |
|
| view_through_conversions |
|
| 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_REPORT
| 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 |
|
| 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_REPORT
| 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 |
|
| 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_REPORT
| 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 |
|
| 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_REPORT
| 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 |
|
| 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_REPORT
| 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 🔑 |
|
| brand 🔑 |
|
| price 🔑 |
|
| top_vs_other 🔑 |
|
| ad_distribution 🔑 |
|
| click_type_id 🔑 |
|
| bid_strategy_type 🔑 |
|
| local_store_code |
|
| store_id 🔑 |
|
| 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 |
|
| conversion metrics* |
|
| custom_label metrics* |
|
| product_category metrics* |
|
| product_type metrics* |
|
| revenue metrics* |
|
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_DAILY_REPORT & PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_HOURLY_REPORT
| 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 🔑 |
|
| brand 🔑 |
|
| price 🔑 |
|
| bid_strategy_type 🔑 |
|
| store_id 🔑 |
|
| revenue metrics* |
|
| 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 |
|
| custom_label metrics* |
|
| product_type metrics* |
|
| product_category metrics* |
|
| impression metrics* |
|
| benchmark metrics* |
|
| conversion metrics* |
|
AD_PERFORMANCE_DAILY_REPORT & AD_PERFORMANCE_HOURLY_REPORT
| 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 🔑 |
|
| impressions |
|
| clicks |
|
| ctr |
|
| average_cpc |
|
| spend |
|
| average_position |
|
| conversions |
|
| conversion_rate |
|
| cost_per_conversion |
|
| destination_url |
|
| delivered_match_type |
|
| assists |
|
| return_on_ad_spend |
|
| cost_per_assist |
|
| custom_parameters |
|
| final_app_url |
|
| ad_description |
|
| ad_description_2 |
|
| view_through_conversions |
|
| 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_REPORT
| 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 |
|
| 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_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_REPORT
| 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 |
|
| assists |
|
| all_revenue |
|
| goal_id |
|
| device_type |
|
| device_os |
|
| goal_type |
|
| view_through_conversions |
|
KEYWORD_PERFORMANCE_DAILY_REPORT
| 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 🔑 |
|
| current_max_cpc |
|
| device_type 🔑 |
|
| language 🔑 |
|
| network 🔑 |
|
| device_os 🔑 |
|
| top_vs_other 🔑 |
|
| bid_match_type 🔑 |
|
| keyword_status |
|
| impressions |
|
| clicks |
|
| ctr |
|
| 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 |
|
| mainline_1_bid |
|
| mainline_bid |
|
| first_page_bid |
|
| final_url_suffix |
|
| view_through_conversions |
|
| all_cost_per_conversion |
|
| all_return_on_ad_spend |
|
| all_conversion metrics* |
|
| all_revenue metrics* |
|
| historical metrics* |
|
| revenue metrics* |
|
KEYWORD_PERFORMANCE_HOURLY_REPORT
| 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 🔑 |
|
| current_max_cpc |
|
| device_type 🔑 |
|
| language 🔑 |
|
| network 🔑 |
|
| device_os 🔑 |
|
| top_vs_other 🔑 |
|
| bid_match_type 🔑 |
|
| keyword_status |
|
| impressions |
|
| clicks |
|
| ctr |
|
| 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_REPORT
| 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 |
|
| query metrics* |
|
| conversion metrics* |
|
| revenue metrics* |
|
|
|
SEARCH_QUERY_PERFORMANCE_DAILY_REPORT & SEARCH_QUERY_PERFORMANCE_HOURLY_REPORT
| 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_REPORT
| 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 |
|
| 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_conversion_rate |
|
| all_cost_per_conversion |
|
| view_through_conversions |
|
| goal |
|
| goal_type |
|
PRODUCT_SEARCH_QUERY_PERFORMANCE_DAILY_REPORT & PRODUCT_SEARCH_QUERY_PERFORMANCE_HOURLY_REPORT
| 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: A * suffix in the column name indicates multiple metrices of the same type. For example, all_revenue metrics* includes the following columns:
- all_revenue
- all_revenue_per_conversion
