Twitter Ads: Promoted Tweet Report

Description

• Each record in this table represents the daily performance of ads at the account, campaign, line item (ad group), and promoted tweet 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 related campaign.
STRING	campaign_name	The name of the related campaign.
STRING	line_item_id	The ID of the related line item (ad group).
STRING	line_item_name	The ID of the related line item.
STRING	promoted_tweet_id	The ID of the promoted tweet that the URL appeared in.
INTEGER	tweet_id	The ID of the tweet that the URL appeared in.
INTEGER	tweet_name	The name, if provided, of the tweet that the URL appeared in.
STRING	full_text	The full text of the tweet that the URL appeared in.
BOOLEAN	is_deleted	Whether the record has been deleted or not.
STRING	promoted_tweet_status	The status of the promoted tweet.
STRING	campaign_status	The status of the tweet's campaign.
STRING	line_item_status	The status of the tweet's line item.
STRING	language	Two-letter language code of the tweet.
STRING	currency	The currency all metrics for the account are set to.
STRING	approval_status	The approval status of the promoted tweet.
STRING	created_timestamp	The timestamp the account was created.
STRING	updated_timestamp	The timestamp the account was last updated.
INTEGER	clicks	The clicks for the promoted tweet + URL 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 promoted tweet + URL 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 promoted tweet + URL on that day.
INTEGER	spend_micro	The spend, in micros, for the tweet + URL on that day.
INTEGER	url_clicks	The URL clicks for the promoted tweet + URL on that day.