Twitter Ads: Keyword Report

Description

• Each record in this table represents the daily performance of ads at the account, campaign, line item (ad group), and keyword 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	Name of the associated 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	keyword_id	Unique key of the table built from the combination of 'account_id', 'line_item_id', 'segment', and 'placement' fields.
STRING	keyword	The keyword whose performance is being tracked.
STRING	currency	The currency all metrics for the account are set to.
INTEGER	clicks	The clicks for the line item + keyword 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 line item + keyword 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 line item + keyword on that day in whichever currency was selected during account creation.
INTEGER	spend_micro	The spend for the line item + keyword on that day, in micros and in whichever currency was selected during account creation.
INTEGER	url_clicks	The url clicks for the line item + keyword on that day.