Twitter Ads: Line Item Report

Description

• Each record in this table represents the daily performance of ads at the account, campaign, and line item (ad group) 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 line item's campaign.
STRING	campaign_name	The name of the line item's campaign.
STRING	line_item_id	The ID of the line item.
STRING	line_item_name	The name of the line item.
BOOLEAN	is_deleted	Whether the record has been deleted or not.
STRING	line_item_status	The status of the line item.
STRING	campaign_status	The status of the line item's related campaign.
STRING	currency	The currency in which metrics will be reported.
STRING	advertiser_domain	The website domain for this advertiser, without the protocol specification.
INTEGER	advertiser_user_id	The Twitter user identifier for the handle promoting the ad.
STRING	bid_type	The bidding mechanism.
STRING	bid_unit	The bid unit for this line item.
STRING	charge_by	The unit to charge this line item by.
STRING	objective	The campaign objective for this line item.
STRING	optimization	The optimization setting to use with this line item.
STRING	product_type	The type of promoted product that this line item will contain.
INTEGER	primary_web_event_tag	The identifier of the primary web event tag. Allows more accurate tracking of engagements for the campaign pertaining to this line item.
STRING	creative_source	The source of the creatives for the line item.
INTEGER	start_timestamp	The timestamp at which the line item will start being served.
INTEGER	end_timestamp	The timestamp at which the line item will stop being served.
STRING	created_timestamp	The timestamp the account was created.
STRING	updated_timestamp	The timestamp the account was last updated.
INTEGER	target_cpa	The target cost per acquisition for the line item.
INTEGER	total_budget_amount	The total budget amount to be allocated to the campaign.
INTEGER	bid_amount	The bid amount to be associated with this line item.
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.