Microsoft Ads: Campaign Report

Description

• Each record in this table represents the daily clicks, impressions, spend (and if applicable other passthrough metrics) of ads by campaign, account, campaign type, campaign timezone, campaign status, 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	campaign_type	The campaign type associated with this record; see the following documentation for more information on values and definitions.
STRING	campaign_timezone	The time zone associated with this campaign.
STRING	campaign_status	The status of this campaign; 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.