Microsoft Ads: Url Report

Description

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

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.
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.
STRING	currency_code	The currency code associated with spend and, if applicable, other metrics associated with currency.
STRING	base_url	The base URL of the ad, extracted from the final_url.
STRING	url_host	The URL host of the ad, extracted from the final_url.
STRING	url_path	The URL path of the ad, extracted from the final_url.
STRING	utm_source	The site that sent traffic to your page. Microsoft Advertising sets this to Bing; extracted from the final_url.
STRING	utm_medium	Which channel was used. Microsoft Advertising sets this to cp; extracted from the final_url.
STRING	utm_campaign	Which campaign the keyword came from; extracted from the final_url.
STRING	utm_content	Which ad group the keyword came from; extracted from the final_url.
STRING	utm_term	Which keyword brought people to your website; extracted from the final_url.
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.