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 in Twitter's documentation .
Features Setup guide Follow our step-by-step Twitter Ads setup guide to connect Twitter Ads with your destination using Fivetran connectors.
Sync overview To capture updates and deletes, we re-import the TWEETS table and its child tables during each sync.
Sync notes 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 your reports stores the date, as well as the midnight timestamp in your account's time zone in UTC format. Unless your account's time zone is UTC, you must add or subtract hours to align the date column values with your Twitter dashboard.
EXAMPLE: Your account's time zone is Pacific Standard Time (UTC-8). You are syncing report data from 2022-06-05 onwards. 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 is saved in destination. To match this value to your Twitter dashboard, you would subtract 08:00.
Schema information This schema applies to all Twitter Ads connectors.
To zoom, open the ERD in a new window. 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 Tables ACCOUNT_REPORT 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_REPORT 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_REPORT 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_REPORT 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*
COLUMN REFERENCE date 🔑 account_id 🔑 ACCOUNT_HISTORY segment_type 🔑 segment_value 🔑 segment_name 🔑 web_conversions metrics*
ACCOUNT_DEVICES_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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*
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*
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_REPORT 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_REPORT 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 Tables CAMPAIGN_REPORT 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_REPORT 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_REPORT 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_REPORT 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*
COLUMN REFERENCE date 🔑 account_id 🔑 ACCOUNT_HISTORY campaign_id 🔑 CAMPAIGN_HISTORY segment_type 🔑 segment_value 🔑 segment_name 🔑 web_conversions metrics*
CAMPAIGN_DEVICES_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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*
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*
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_REPORT 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_REPORT 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_REPORT COLUMN REFERENCE campaign_id 🔑 CAMPAIGN_HISTORY date/month 🔑 total_audience_reach average_frequency
FUNDING INSTRUMENT Tables FUNDING_INSTRUMENT_REPORT 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_REPORT 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_REPORT 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_REPORT 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*
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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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*
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*
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_REPORT 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_REPORT 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_REPORT COLUMN REFERENCE funding_instrument_id 🔑 FUNDING_INSTRUMENT_HISTORY date/month 🔑 total_audience_reach average_frequency
LINE ITEM Tables LINE_ITEM_REPORT 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_REPORT 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_REPORT 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_REPORT 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*
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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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_REPORT 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*
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*
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_REPORT 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_REPORT 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*
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*
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*
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*
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*
COLUMN REFERENCE date 🔑 account_id 🔑 ACCOUNT_HISTORY promoted_tweet_id 🔑 PROMOTED_TWEET_HISTORY segment_type 🔑 segment_value 🔑 segment_name 🔑 web_conversions metrics*
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*
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*
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*
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*
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*
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*
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*
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*
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*
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*
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*
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*
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*
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*
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*
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*
COLUMN REFERENCE date 🔑 account_id 🔑 ACCOUNT_HISTORY promoted_account_id 🔑 PROMOTED_ACCOUNT_HISTORY segment_type 🔑 segment_value 🔑 segment_name 🔑 web_conversions metrics*
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*
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*
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*
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*
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*
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*
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*
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*
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*
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_REPORT 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*
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*
NOTE: The media_creative entity does not support segmentation and has only one report table.
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*
UTC conversion We don't convert source timestamps to Universal Time Coordinated (UTC) but use the Twitter Ads account's time zone to store the data in your destination.
