X Ads (Twitter) data warehouse table groups

  • Updated on May 7, 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
account_ui_id
Display name Account UI ID
Description Converted account ID to base-10 to match the UI value
Field type dimension
Data type int.number.value
ad_group_ui_id
Display name Ad group UI ID
Description Converted ad group ID to base-10 to match the UI value
Field type dimension
Data type int.number.value
ad_name
Display name Ad name
Description Ad name as displayed in X user interface. Derived from promoted tweet name, or card name if tweet name is not set
Field type dimension
Data type string.text.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_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
campaign_ui_id
Display name Campaign UI ID
Description Converted campaign ID to base-10 to match the UI value
Field type dimension
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
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
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_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_placements
Display name Line item placements
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
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
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

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
account_ui_id
Display name Account UI ID
Description Converted account ID to base-10 to match the UI value
Field type dimension
Data type int.number.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_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
campaign_ui_id
Display name Campaign UI ID
Description Converted campaign ID to base-10 to match the UI value
Field type dimension
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

© Supermetrics 2025