X Ads (Twitter) fields

Prev Next

Supermetrics brings all your X Ads (Twitter) data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

158 metrics138 dimensions

ACCOUNT

account
account_id
account_ui_id

AD GROUP

line_item_name
line_item_id
ad_group_ui_id
line_item_objective
line_item_goal
line_item_product_type
line_item_placements
line_item_charge_by
line_item_bid_type
line_item_bid_amount
line_item_total_budget_amount
line_item_advertiser_domain
line_item_primary_web_event_tag
line_item_created_at
line_item_start_date
line_item_end_date
line_item_status
line_item_deleted
line_item_categories
line_item_include_sentiment

CAMPAIGN

campaign_name
campaign_id
campaign_ui_id
campaign_created_at
campaign_start_time
campaign_end_time
campaign_servable
campaign_status
campaign_deleted
campaign_currency
campaign_standard_delivery
campaign_total_budget_amount
campaign_daily_budget_amount
campaign_budget_optimization

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

DEPRECATED

promoted_tweet_card_display_url
audienceCategory
line_item_optimization
audienceName
audienceSource
audienceType
interactionType
line_item_tracking_tags
line_item_paused
line_item_automatically_select_bid
campaign_paused
promoted_tweet_card_id
matchRate
percentage

FUNDING INSTRUMENTS

funding_instrument_id
funding_instrument_ui_id
funding_instrument_description
funding_instrument_type
funding_instrument_status
funding_instrument_currency
funding_instrument_start_date
funding_instrument_end_date
funding_instrument_credit_limit
funding_instrument_funded_amount
funding_instrument_credit_remaining
funding_instrument_reasons_not_able_to_fund
funding_instrument_io_header

GENERAL METRICS

impressions
cost
cost_eur
cost_usd
cost_gbp
CPM
mediaViews
mediaViewRate
media_engagements
conversions
V1_conversionRate

MEDIA CREATIVE

media_creative_id
media_creative_created_at
media_creative_type
media_name
media_url

MOBILE CONVERSION METRICS

mobile_conversion_achievement_unlocked
mobile_conversion_add_to_cart
mobile_conversion_added_payment_infos
mobile_conversion_add_to_wishlist
mobile_conversion_checkout_initiated
mobile_conversion_content_views
mobile_conversion_installs
V1_mobile_conversion_installs_post_view
V1_mobile_conversion_installs_post_engagement
mobile_conversion_invites
mobile_conversion_level_achieved
mobile_conversion_logins
mobile_conversion_purchases
mobile_conversion_re_engages
mobile_conversion_sign_ups
mobile_conversion_rated
mobile_conversion_reservations
mobile_conversion_searches
mobile_conversion_shares
mobile_conversion_spent_credits
mobile_conversion_tutorial_completes
mobile_conversion_updates
mobile_conversion_achievement_unlocked_breakdown
mobile_conversion_add_to_cart_breakdown
mobile_conversion_add_to_wishlist_breakdown
mobile_conversion_added_payment_infos_breakdown
mobile_conversion_checkout_initiated_breakdown
mobile_conversion_content_views_breakdown
mobile_conversion_installs_breakdown
mobile_conversion_invites_breakdown
mobile_conversion_level_achieved_breakdown
mobile_conversion_logins_breakdown
mobile_conversion_order_quantity
mobile_conversion_purchases_breakdown
mobile_conversion_rated_breakdown
mobile_conversion_re_engages_breakdown
mobile_conversion_reservations_breakdown
mobile_conversion_sale_amount_local_micro
mobile_conversion_searches_breakdown
mobile_conversion_shares_breakdown
mobile_conversion_sign_ups_breakdown
mobile_conversion_spent_credits_breakdown
mobile_conversion_tutorial_completes_breakdown
mobile_conversion_updates_breakdown

OBJECTIVE APP INSTALLS

V1_app_installs
app_clicks
app_click_rate
app_install_rate
CPAC
CPI

OBJECTIVE FOLLOWERS

followers
followersRate
CPF

OBJECTIVE LEAD GENERATION

leads
lead_rate
CPL

OBJECTIVE TWEET ENGAGEMENTS

engagements
billed_engagements
CPE
engagementsRate
likes
retweets
replies
follows
card_engagements
qualified_impressions

OBJECTIVE VIDEO VIEWS

promoted_video_total_views
video_view_rate
CPV
promoted_video_cta_clicks
video_3s100pct_views
video_6s_views
video_15s_views
promoted_video_starts
promoted_video_views_25
promoted_video_views_50
promoted_video_views_75
promoted_video_views_100

OBJECTIVE WEBSITE CLICKS OR CONVERSIONS

clicks
url_clicks
CTR
CPC
CPA
conversion_site_visits
conversion_sign_ups
conversion_downloads
conversion_purchases
conversion_order_quantity
conversion_sale_amount
conversion_custom

PROMOTED TWEET

promoted_tweet_id
promoted_tweet_ad_id
promoted_tweet_created_at
ad_name
promoted_tweet_name
promoted_tweet_text
promoted_tweet_source
promoted_tweet_scheduled_status
promoted_tweet_scheduled_at
promoted_tweet_type
promoted_tweet_language
promoted_tweet_hashtags
promoted_tweet_symbols
promoted_tweet_user_mentions
tweet_url
promoted_tweet_first_url
promoted_tweet_card_title
promoted_tweet_card_name
promoted_tweet_card_type
promoted_tweet_card_destination_url
promoted_tweet_card_image_url
promoted_tweet_card_image
promoted_tweet_card_uri
promoted_tweet_destination_url
promoted_tweet_media_type
utm_source
utm_medium
utm_content
utm_term
utm_campaign

PROMOTED TWEETS

V1_promoted_tweet_retweets
V1_promoted_tweet_likes

PROMOTED TWEETS (PROFILE)

promoted_tweet_profile_impressions
promoted_tweet_profile_qualified_impressions
promoted_tweet_profile_clicks
promoted_tweet_profile_engagements
promoted_tweet_profile_favorites
promoted_tweet_profile_follows
promoted_tweet_profile_replies
promoted_tweet_profile_retweets
promoted_tweet_profile_url_clicks
promoted_tweet_profile_card_engagements
promoted_tweet_profile_media_views

PROMOTED TWEETS (SEARCH)

promoted_tweet_search_impressions
promoted_tweet_search_qualified_impressions
promoted_tweet_search_clicks
promoted_tweet_search_engagements
promoted_tweet_search_engagement_rate
promoted_tweet_search_favorites
promoted_tweet_search_follows
promoted_tweet_search_replies
promoted_tweet_search_retweets
promoted_tweet_search_url_clicks
promoted_tweet_search_card_engagements
promoted_tweet_search_media_views

PROMOTED TWEETS (TIMELINE)

promoted_tweet_timeline_impressions
promoted_tweet_timeline_qualified_impressions
promoted_tweet_timeline_clicks
promoted_tweet_timeline_engagements
promoted_tweet_timeline_engagement_rate
promoted_tweet_timeline_favorites
promoted_tweet_timeline_follows
promoted_tweet_timeline_replies
promoted_tweet_timeline_retweets
promoted_tweet_timeline_url_clicks
promoted_tweet_timeline_media_views
promoted_tweet_timeline_card_engagements

PROMOTED TWEETS (TWITTER PUBLISHER NETWORK)

promoted_tweet_tpn_media_views
promoted_tweet_tpn_qualified_impressions
promoted_tweet_tpn_card_engagements
promoted_tweet_tpn_engagement_rate
promoted_tweet_tpn_engagements
promoted_tweet_tpn_clicks
promoted_tweet_tpn_favorites
promoted_tweet_tpn_follows
promoted_tweet_tpn_impressions
promoted_tweet_tpn_replies
promoted_tweet_tpn_retweets
promoted_tweet_tpn_url_clicks

PROMOTEDACCOUNT METRICS

promoted_account_follows
promoted_account_follow_rate
promoted_account_impressions
promoted_account_profile_visits

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts

REACH

total_audience_reach
average_frequency

SEGMENTATION

AGE
APP_STORE_CATEGORY
CONVERSION_TAGS
EVENTS
GENDER
INTERESTS
KEYWORDS
LANGUAGES
LOCATIONS
countryCode
REGIONS
CITIES
PLATFORMS
SIMILAR_TO_FOLLOWERS_OF_USER
TV_SHOWS

TIME

today
year
yearofweek
yearofweekiso
yearmonth
quarter
month
yearweek
yearweekiso
week
weekiso
dayOfWeekName
dayOfWeekNameIso
dayOfMonth
date