Twitter Ads: Campaign Report

Description

• Each record in this table represents the daily performance of ads at the account and campaign 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 related account.
STRING	account_name	The name of the related account.
STRING	campaign_id	The ID of the campaign.
STRING	campaign_name	The name of the campaign.
BOOLEAN	is_deleted	Whether the record has been deleted or not.
STRING	campaign_status	The status of the campaign.
STRING	currency	The currency all metrics for the account are set to.
BOOLEAN	is_servable	Whether the campaign is in a state to be actively served to users.
BOOLEAN	is_standard_delivery	Whether standard delivery is enabled (vs accelerated delivery).
INTEGER	frequency_cap	The maximum number of times an ad could be delivered to a user.
STRING	start_timestamp	The time the campaign will start.
STRING	end_timestamp	The time the campaign will end
STRING	created_timestamp	The timestamp the account was created.
STRING	updated_timestamp	The timestamp the account was last updated.
STRING	funding_instrument_id	Reference to the funding instrument.
INTEGER	daily_budget_amount	The daily budget amount to be allocated to the campaign. The currency associated with the specified funding instrument will be used.
INTEGER	total_budget_amount	The total budget amount to be allocated to the campaign.
INTEGER	clicks	The number of clicks on that date. Includes clicks on the URL (shortened or regular links), profile pic, screen name, username, detail, hashtags, and likes.
INTEGER	impressions	The number of impressions on that date. This is the number of users who see a Promoted Ad either in their home timeline or search results.
INTEGER	spend	The amount of spend on that date.
INTEGER	spend_micro	The amount of spend, in micros, on that date.
INTEGER	url_clicks	The number of URL clicks on that date.