Microsoft Ads: Search Report

Description

• Each record in this table represents the daily clicks, impressions, spend (and if applicable other passthrough metrics) of ads by search query, keyword, ad, ad group, campaign, account, device os, device type and network.

Supported Data Sources

• Microsoft Advertising

Columns

Type	Name	Description
STRING	source_relation	The source of the record if the unioning functionality is being used. If not this field will be empty.
DATE	date_day	The date of the performance report.
STRING	account_name	The name of the account.
INTEGER	account_id	The ID of the account.
STRING	campaign_name	The name of the campaign.
INTEGER	campaign_id	The ID of the campaign.
STRING	ad_group_name	The name of the corresponding ad group.
INTEGER	ad_group_id	The ID of the corresponding ad group.
STRING	ad_name	The name of the corresponding ad; title_part_1 is used as the ad name as a proxy as one is not provided by the data source.
INTEGER	ad_id	The ID of the corresponding ad.
INTEGER	keyword_id	The ID of the keyword.
STRING	keyword_name	The keyword(s) associated with this record.
STRING	match_type	The match type associated with this record; values contain but may not be limited to 'Broad', 'Exact', 'Phrase'. Please refer to Microsoft Ad's documentation.
STRING	search_query	The search query string associated with this record.
STRING	device_os	The device operating system associated with this record; values include but may not be limited to 'Windows', 'iOS', 'Android', 'Other', 'BlackBerry' and 'Unknown'.
STRING	device_type	The device type associated with this record; values include but may not be limited to 'Computer', 'Smartphone', 'Tablet' and 'Unknown'.
STRING	network	The network associated with this record.
INTEGER	clicks	The number of clicks that occurred by the grain of the report.
INTEGER	impressions	The number of impressions that occurred by the grain of the report.
DECIMAL	spend	The amount of spend that occurred by the grain of the report.