Microsoft Ads: Account Report

Description

• Each record in this table represents the daily clicks, impressions, spend (and if applicable other passthrough metrics) of ads by account, account timezone, 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	account_timezone	The time zone associated with this account.
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.