Twitter Ads: Account Report

Description

• Each record in this table represents the daily performance of ads at the account level, within a placement in Twitter.

Supported Data Sources

• Twitter Ads

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.
DATETIME	date_day	The date of the performance.
STRING	placement	Where on Twitter the ad is being displayed. Possible values include 'ALL_ON_TWITTER', 'PUBLISHER_NETWORK', 'TWITTER_PROFILE', 'TWITTER_SEARCH', 'TWITTER_TIMELINE', and 'TAP_*', which are more granular options for PUBLISHER_NETWORK.
STRING	account_id	The ID of the account.
STRING	account_name	Name of the account.
BOOLEAN	is_deleted	Whether the record has been deleted or not.
STRING	timezone	The timezone the account is set to.
INTEGER	industry_type	The industry of the accounts.
STRING	approval_status	The approval status of the account.
INTEGER	business_name	The name of the related business.
INTEGER	business_id	The ID of the related business.
STRING	created_timestamp	The timestamp the account was created.
STRING	updated_timestamp	The timestamp the account was last updated.
STRING	timezone_switched_timestamp	The timestamp the account's timezone was last changed.
INTEGER	clicks	The clicks for th account on that day. Includes clicks on the URL (shortened or regular links), profile pic, screen name, username, detail, hashtags, and likes.
INTEGER	impressions	The impressions for the account on that day. This is the number of users who see a Promoted Ad either in their home timeline or search results.
INTEGER	spend	The spend for the account on that day.
INTEGER	spend_micro	The spend (in micros) for the account on that day.
INTEGER	url_clicks	The url clicks for the account on that day.