X Ads (Twitter) data warehouse table groups

  • Updated on Apr 29, 2026
  • Published on Aug 5, 2025
Prev Next

Table: AD

account
Display name Account
Description The ad account name
Field type dimension
Data type string.text.value
account_id
Display name Account ID
Description The unique ID for the ad account
Field type dimension
Data type string.text.value
app_clicks
Display name App clicks
Description Total number of clicks to install or open your app. This includes earned clicks that you're not billed for. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
billed_engagements
Display name Engagements (billed)
Description Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
campaign_created_at
Display name Campaign created
Field type dimension
Data type string.time.date
campaign_currency
Display name Campaign currency
Description The currency used for all spend-related metrics and billing
Field type dimension
Data type string.currency.code
campaign_deleted
Display name Campaign deleted
Field type dimension
Data type bool
campaign_id
Display name Campaign ID
Description The unique ID for each campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign
Field type dimension
Data type string.text.value
campaign_paused
Display name Campaign paused
Description Please note that this field will be removed on 2022-11-30
Field type dimension
Data type bool
campaign_servable
Display name Campaign servable
Field type dimension
Data type bool
campaign_standard_delivery
Display name Campaign standard delivery
Field type dimension
Data type bool
card_engagements
Display name Card engagements
Description Total number of card engagements. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
clicks
Display name Clicks
Description Total clicks on links, hashtags, a Website Card, and other Tweet details in your ad, combined with likes and profile clicks
Field type metric
Data type int.number.value
conversion_custom
Display name Custom conversions
Field type metric
Data type int.number.value
conversion_downloads
Display name Downloads
Field type metric
Data type int.number.value
conversion_order_quantity
Display name Order quantity
Description The order quantity of the purchase, e.g. 1 unit
Field type metric
Data type int.number.value
conversion_purchases
Display name Purchases
Description Total number of purchases. The sum of post view, post engagement, and assisted purchases for both your website and mobile app
Field type metric
Data type int.number.value
conversion_sale_amount
Display name Sale amount
Description The total sale amount of the purchase
Field type metric
Data type float.currency.value
conversion_sign_ups
Display name Sign-ups
Description Total number of sign ups. This is the same as the sum of post views, post engagements and assisted sign ups. This is also the sum of website and mobile app sign ups
Field type metric
Data type int.number.value
conversion_site_visits
Display name Site visits
Field type metric
Data type int.number.value
conversions
Display name Conversions
Field type metric
Data type int.number.value
cost
Display name Cost
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
engagements
Display name Engagements
Description All clicks on your Tweet, including Retweets, replies, likes, poll votes, and hashtag clicks. This includes earned clicks that you're not billed for. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
followers
Display name Followers
Description Total number of followers generated from your Tweet, including earned. If you're running a followers campaign, this number also reflects follows from other locations, including Who to follow. You only pay the first time someone follows you. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
follows
Display name Follows
Description Total number of followers generated from your Tweet, including earned. If you're running a followers campaign, this number also reflects follows from other locations, including Who to follow. You only pay the first time someone follows you. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
impressions
Display name Impressions
Description The number of times your ad is shown to users, including earned
Field type metric
Data type int.number.value
leads
Display name Leads
Description The number of leads you acquired as a result of a user submitting their contact information on Twitter through the Lead Generation Card. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
likes
Display name Paid likes
Description The number of people who liked your ad by clicking the heart button. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
line_item_advertiser_domain
Display name Advertiser domain
Field type dimension
Data type string.text.value
line_item_automatically_select_bid
Display name Line item automatically select bid
Description Please note that this field will be removed on 2022-02-15
Field type dimension
Data type bool
line_item_bid_amount
Display name Line item bid amount
Field type dimension
Data type float.currency.value
line_item_bid_type
Display name Line item bid type
Field type dimension
Data type string.text.value
line_item_categories
Display name Line item categories
Field type dimension
Data type string.text.value
line_item_charge_by
Display name Charge by
Field type dimension
Data type string.text.value
line_item_created_at
Display name Ad group creation date
Description Formerly called line item creation date
Field type dimension
Data type string.time.date
line_item_deleted
Display name Ad group deleted
Description Formerly called line item deleted
Field type dimension
Data type bool
line_item_id
Display name Ad group ID
Description Formerly called line item id
Field type dimension
Data type string.text.value
line_item_include_sentiment
Display name Include sentiment
Field type dimension
Data type string.text.value
line_item_name
Display name Ad group
Description Formerly called line item
Field type dimension
Data type string.text.value
line_item_objective
Display name Campaign objective
Field type dimension
Data type string.text.value
line_item_paused
Display name Ad group paused
Description Formerly called line item paused. Please note that this field will be removed on 2022-11-30
Field type dimension
Data type bool
line_item_placements
Display name Line item placements
Field type dimension
Data type string.text.value
line_item_primary_web_event_tag
Display name Primary web event tag
Field type dimension
Data type string.text.value
line_item_product_type
Display name Line item product type
Field type dimension
Data type string.text.value
line_item_total_budget_amount
Display name Ad group total budget
Description The maximum amount you are willing to spend on the ad group, for the duration of the ad group flight length. Formerly called line item total budget
Field type dimension
Data type float.currency.value
line_item_tracking_tags
Display name Tracking tags
Description Please note that this field will be removed on 2022-02-15
Field type dimension
Data type string.text.value
mediaViews
Display name Media views
Description Total views (autoplay and click) of your media across videos, Vines, GIFs, and images. This includes views you are not billed for. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
promoted_tweet_card_destination_url
Display name Promoted tweet card destination URL
Field type dimension
Data type string.text.url
promoted_tweet_card_image_url
Display name Promoted tweet card image URL
Field type dimension
Data type string.text.url
promoted_tweet_card_title
Display name Promoted tweet card title
Field type dimension
Data type string.text.value
promoted_tweet_created_at
Display name Promoted tweet creation date
Field type dimension
Data type string.time.date
promoted_tweet_first_url
Display name Promoted tweet first URL
Field type dimension
Data type string.text.url
promoted_tweet_id
Display name Promoted tweet ID
Description Unique numeric ID of the original tweet being used in the promoted tweet ad
Field type dimension
Data type string.text.value
promoted_tweet_text
Display name Promoted tweet text
Field type dimension
Data type string.text.value
promoted_video_views_100
Display name Views (completed)
Description The number of people who watched 100% of the video, regardless of how much of the video player is in view. You're not billed for these
Field type metric
Data type int.number.value
promoted_video_views_25
Display name Views (75% complete)
Description The number of people who watched 25% of the video, regardless of how much of the video player is in view. You're not billed for these
Field type metric
Data type int.number.value
promoted_video_views_50
Display name Views (50% complete)
Description The number of people who watched 50% of the video, regardless of how much of the video player is in view. You're not billed for these
Field type metric
Data type int.number.value
promoted_video_views_75
Display name Views (25% complete)
Description The number of people who watched 75% of the video, regardless of how much of the video player is in view. You're not billed for these
Field type metric
Data type int.number.value
replies
Display name Replies
Description The number of people that responded to your Tweet by clicking the reply button. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
retweets
Display name Retweets
Description The number of people that Retweeted your ad by clicking the Retweet button. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
url_clicks
Display name URL clicks
Description Total clicks on the link or Website Card in your ad, including earned. This includes clicks you're not billed for. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value
utm_campaign
Display name Campaign (utm)
Description Value of the utm_campaign parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_content
Display name Content (utm)
Description Value of the utm_content parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_medium
Display name Medium (utm)
Description Value of the utm_medium parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_source
Display name Source (utm)
Description Value of the utm_source parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_term
Display name Term (utm)
Description Value of the utm_term parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
V1_promoted_tweet_likes
Display name Total likes
Description The number of people who liked your ad by clicking the heart button. Please note that this field will be removed on 2026-04-29
Field type metric
Data type int.number.value

Table: CAMPAIGN

account
Display name Account
Description The ad account name
Field type dimension
Data type string.text.value
account_id
Display name Account ID
Description The unique ID for the ad account
Field type dimension
Data type string.text.value
campaign_currency
Display name Campaign currency
Description The currency used for all spend-related metrics and billing
Field type dimension
Data type string.currency.code
campaign_daily_budget_amount
Display name Campaign daily budget
Description The maximum amount you're willing to spend on each campaign on average per day
Field type dimension
Data type float.currency.value
campaign_deleted
Display name Campaign deleted
Field type dimension
Data type bool
campaign_id
Display name Campaign ID
Description The unique ID for each campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign
Field type dimension
Data type string.text.value
campaign_paused
Display name Campaign paused
Description Please note that this field will be removed on 2022-11-30
Field type dimension
Data type bool
campaign_servable
Display name Campaign servable
Field type dimension
Data type bool
campaign_total_budget_amount
Display name Campaign total budget
Description The maximum amount you're willing to spend on each campaign for the duration of the campaign
Field type dimension
Data type float.currency.value
cost
Display name Cost
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

© Supermetrics 2025