Microsoft Ads: Ad 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 and currency code.

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	ad_type	The ad type associated with this record; see the following documentation for more information on values and definitions.
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.
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.