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 |
Column level. Table-level data blocking for reporting tables only |
Column hashing |
check |
|
Re-sync |
check |
Connector level |
History |
check |
Tables with the _HISTORY suffix |
API configurable |
check |
|
Priority-first sync |
check |
Reporting tables |
Fivetran data models |
check |
Get the models: source / transform; Get the ad reporting model |
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. The rollback sync time frame for our Microsoft Advertising connector is 29 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_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 π |
|
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 |
|
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 π |
|
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 |
|
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 |
|
final_url_suffix |
|
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 |
|
final_url_suffix |
|
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 π |
|
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 |
|
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 π |
|
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 |
|
custom_label metrics* |
|
product_type metrics* |
|
product_category metrics* |
|
impression metrics* |
|
benchmark metrics* |
|
conversion metrics* |
|
revenue 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 π |
|
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_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 |
|
all_conversions_qualified |
|
assists |
|
all_revenue |
|
goal_id |
|
device_type |
|
device_os |
|
goal_type |
|
view_through_conversions |
|
view_through_conversions_qualified |
|
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 π |
|
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_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 π |
|
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_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: 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.