Twitter Ads: Url Report

Description

• Each record in this table represents the daily performance of ads at the account, campaign, line item (ad group), promoted tweet, and url 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	tweet_full_text	The full text of the tweet that the URL appeared in.
STRING	base_url	The base URL of the ad, extracted from the expanded_url.
STRING	url_host	The URL host of the ad, extracted from the expanded_url.
STRING	url_path	The URL path of the ad, extracted from the expanded_url.
STRING	utm_source	The utm_source parameter of the ad, extracted from the expanded_url.
STRING	utm_medium	The utm_medium parameter of the ad, extracted from the expanded_url.
STRING	utm_campaign	The utm_campaign parameter of the ad, extracted from the expanded_url.
STRING	utm_content	The utm_content parameter of the ad, extracted from the expanded_url.
STRING	utm_term	The utm_term parameter of the ad, extracted from the expanded_url.
STRING	expanded_url	The fully expanded URL.
STRING	display_url	The URL as it will be displayed.
STRING	currency	The currency all metrics for the account are set to.
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.