Twitter Ads

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.

Features

Feature Name	Supported	Notes
Capture Deletes
Custom Data
Data Blocking
Column Hashing
Re-sync		Connector level
History		All tables
API Configurable
Priority-first sync

Setup guide

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

Schema information

This schema applies to all Twitter Ads connectors

To zoom, open ERD in new window

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.
Since we fetch 45 days of data with each request, if there is no data present for a particular date range of 45 days, 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.

Twitter Ads Report Tables

Following are the reporting tables created per segment with all the metrics

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_type 🔑
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_REPORT

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_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_PLATFORMS_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_PLATFORM_VERSIONS_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_POSTAL_CODES_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
segment_type 🔑
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_type 🔑
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_type 🔑
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_REPORT

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_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_PLATFORMS_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_PLATFORM_VERSIONS_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_POSTAL_CODES_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
segment_type 🔑
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_type 🔑
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 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_type 🔑
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_REPORT

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_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_PLATFORMS_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_PLATFORM_VERSIONS_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_POSTAL_CODES_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
funding_instrument_id 🔑	FUNDING_INSTRUMENT_HISTORY
segment_type 🔑
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_type 🔑
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 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_type 🔑
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_REPORT

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_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_PLATFORMS_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_PLATFORM_VERSIONS_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_POSTAL_CODES_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
line_item_id 🔑	LINE_ITEM_HISTORY
segment_type 🔑
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_type 🔑
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 Tables

PROMOTED_TWEET_REPORT

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_REPORT

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_REPORT

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_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_PLATFORMS_REPORT

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_REPORT

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_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
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_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_tweet_id 🔑	PROMOTED_TWEET_HISTORY
segment_type 🔑
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 Tables

PROMOTED_ACCOUNT_REPORT

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_REPORT

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_REPORT

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_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_REPORT

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_PLATFORMS_REPORT

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_REPORT

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_type 🔑
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_REPORT

COLUMN	REFERENCE
date 🔑
account_id 🔑	ACCOUNT_HISTORY
promoted_account_id 🔑	PROMOTED_ACCOUNT_HISTORY
segment_type 🔑
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*

Pre-built dbt packages

Fivetran integrates with data build tool (dbt) to power complex transformations. Our pre-built Twitter Ads dbt package produces clear, comprehensible tables that power your reports, visualizations, and dashboards. Find the package in Fivetran's dbt hub.

You can use Fivetran-created dbt packages with several destinations. Find a complete list of supported destinations in our dbt documentation.

Documentation