Twitter Ads link

Updated November 16, 2023

Twitter Ads provides a history of the settings and detailed reports of your Twitter Ad Accounts, Campaigns, Line Items, Tweets, and Media Creatives. You can find more information on Twitter documentation.

Featureslink

Feature Name	Supported	Notes
Capture deletes
Custom data
Data blocking		Column level and table level
Column hashing
Re-sync		Connector level
History
API configurable		API configuration
Priority-first sync
Fivetran data models		Get the models: source / transform; Get the ad reporting model
Private networking

Setup guidelink

Follow our step-by-step Twitter Ads setup guide to connect Twitter Ads with your destination using Fivetran connectors.

Schema informationlink

This schema applies to all Twitter Ads connectors

To zoom, open the ERD in a new window.

Sync noteslink

Twitter takes a long time to process a request for a report. So, we sync all the historical reports until the creation date of a particular entity gradually as the connector runs. Initially, you will have the latest reports until the previous day from the day you created the connector, and the complete historical reports will become available over time.
We use request-specific data sync time frame for each request type. If there is no data present for a particular date range, then we skip that date range. As a result, a few dates may be missing.
The LIFE_TIME_VALUE_MOBILE_CONVERSION metric is valid only after 2015-07-14T00:00:00Z. Before this date, this metric will have null values.
The date field in reports stores the date along with the midnight timestamp in the account's timezone in UTC format.
EXAMPLE: An account's time zone is UTC-8. The report data are being fetched since 2022-06-05. In this case, we calculate the start date as follows: 2022-06-05T00:00:00-08:00 = 2022-06-05T08:00:00Z. The 2022-06-05T08:00:00Z value will be saved in destination.

Twitter Ads Report Tableslink

The following are the reporting tables created per segment along with the tables' metrics.

NOTE: All the columns in the reports, except the metrics, are primary keys by default.

ACCOUNT Tableslink

ACCOUNT_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_AGE_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_APP_STORE_CATEGORY_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_CITIES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_value 🔑
segment_name
country_target_value 🔑
country_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_CONVERSION_TAGS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
web_conversions metrics*

ACCOUNT_DEVICES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_EVENTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_GENDER_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_INTERESTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_LOCATIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_value 🔑
segment_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_METROS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_value 🔑
segment_name
country_target_value 🔑
country_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_PLATFORMS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_PLATFORM_VERSIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_POSTAL_CODES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

ACCOUNT_REGIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN Tableslink

CAMPAIGN_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_AGE_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_APP_STORE_CATEGORY_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_CITIES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_CONVERSION_TAGS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
web_conversions metrics*

CAMPAIGN_DEVICES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_EVENTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_GENDER_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_INTERESTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_KEYWORDS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_LANGUAGES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_LOCATIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_value 🔑
segment_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_METROS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_value 🔑
segment_name
country_target_value 🔑
country_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_PLATFORMS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_PLATFORM_VERSIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_POSTAL_CODES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_REGIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

CAMPAIGN_REACH_DAILY_REPORT & CAMPAIGN_REACH_MONTHLY_REPORTlink

COLUMN	REFERENCE
campaign_id 🔑	CAMPAIGN_HISTORY
date/month 🔑
total_audience_reach
average_frequency

FUNDING INSTRUMENT Tableslink

FUNDING_INSTRUMENT_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_AGE_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_APP_STORE_CATEGORY_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_CITIES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_value 🔑
segment_name
country_target_value 🔑
country_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_CONVERSION_TAGS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
web_conversions metrics*

FUNDING_INSTRUMENT_DEVICES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_EVENTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_GENDER_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_INTERESTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_LOCATIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_value 🔑
segment_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_METROS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_value 🔑
segment_name
country_target_value 🔑
country_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_PLATFORMS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_PLATFORM_VERSIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_POSTAL_CODES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_REGIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

FUNDING_INSTRUMENT_REACH_DAILY_REPORT & FUNDING_INSTRUMENT_REACH_MONTHLY_REPORTlink

COLUMN	REFERENCE
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
date/month 🔑
total_audience_reach
average_frequency

LINE ITEM Tableslink

LINE_ITEM_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_AGE_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_APP_STORE_CATEGORY_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_CITIES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_CONVERSION_TAGS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
web_conversions metrics*

LINE_ITEM_DEVICES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_EVENTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_GENDER_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_INTERESTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_KEYWORDS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_LANGUAGES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_LOCATIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_value 🔑
segment_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_METROS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_value 🔑
segment_name
country_target_value 🔑
country_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_PLATFORMS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_PLATFORM_VERSIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_POSTAL_CODES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

LINE_ITEM_REGIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED TWEET Tableslink

PROMOTED_TWEET_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_AGE_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_APP_STORE_CATEGORY_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_CITIES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_CONVERSION_TAGS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
web_conversions metrics*

PROMOTED_TWEET_DEVICES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_EVENTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_GENDER_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_INTERESTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_KEYWORDS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_LANGUAGES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_LOCATIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_value 🔑
segment_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_METROS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_value 🔑
segment_name
country_target_value 🔑
country_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_PLATFORMS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_PLATFORM_VERSIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_POSTAL_CODES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_TWEET_REGIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED ACCOUNT Tableslink

PROMOTED_ACCOUNT_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_AGE_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_APP_STORE_CATEGORY_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_CITIES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_CONVERSION_TAGS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
web_conversions metrics*

PROMOTED_ACCOUNT_DEVICES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_EVENTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_GENDER_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_INTERESTS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_KEYWORDS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_LANGUAGES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_LOCATIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_value 🔑
segment_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_METROS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_value 🔑
segment_name
country_target_value 🔑
country_name
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_PLATFORMS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_PLATFORM_VERSIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
segment_value 🔑
segment_name 🔑
platform_target_value 🔑
platform_name 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_POSTAL_CODES_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

PROMOTED_ACCOUNT_REGIONS_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_value 🔑
segment_name
country_name
country_target_value 🔑
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

MEDIA CREATIVE Tablelink

NOTE: The media_creative entity does not support segmentation and has only one report table.

MEDIA_CREATIVE_REPORTlink

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
media_creative_id 🔑	MEDIA_CREATIVE_HISTORY
engagements metrics*
billing metrics*
video metrics*
media metrics*
web_conversions metrics*
mobile_conversions metrics*
life_time_value_mobile_conversion metrics*

Documentation