X Organic (Twitter) data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: PROFILE

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
profile_info__account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
profile_info__account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
profile_info__created_at_date
Display name Created at date
Description Date the user was created
Field type dimension
Data type string.time.date
profile_info__created_at_datetime
Display name Created at datetime
Description Date & time the user was created
Field type dimension
Data type string.time.datetime
profile_info__description
Display name Description
Description Description of the Twitter user, also known as profile bio
Field type dimension
Data type string.text.value
profile_info__favourites
Display name Favourites
Description Total lifetime number of favourites the Twitter user has
Field type metric
Data type int.number.value
profile_info__followers
Display name Followers
Description Total number of followers the Twitter user has
Field type metric
Data type int.number.value
profile_info__following
Display name Following
Description Total number of friends Twitter user has
Field type metric
Data type int.number.value
profile_info__lists
Display name Lists
Description The number of public lists that this user is a member of
Field type metric
Data type int.number.value
profile_info__location
Display name Location
Description Location of the Twitter user
Field type dimension
Data type string.text.value
profile_info__profile_background_image_url
Display name Profile background image URL
Description A link to the user's profile background image
Field type dimension
Data type string.text.url
profile_info__profile_background_image_url_https
Display name Profile background image URL HTTPS
Description A HTTPS link to the user's profile background image
Field type dimension
Data type string.text.url
profile_info__profile_banner_url
Display name Profile banner URL
Description A link to the user's profile banner
Field type dimension
Data type string.text.url
profile_info__profile_image_url
Display name Profile image URL
Description A link to the user's profile image
Field type dimension
Data type string.text.url
profile_info__profile_image_url_https
Display name Profile image URL HTTPS
Description A HTTPS link to the user's profile image
Field type dimension
Data type string.text.url
profile_info__protected
Display name Protected
Description Whether or not the Twitter user is protected
Field type dimension
Data type bool
profile_info__tweets
Display name Tweets
Description Total lifetime number of tweets the Twitter user has published
Field type metric
Data type int.number.value
profile_info__user_id
Display name User ID
Description ID of the user
Field type dimension
Data type string.text.value
profile_info__user_language
Display name User language
Description Language of the Twitter user
Field type dimension
Data type string.language.twolettercode
profile_info__user_name
Display name User name
Description Name of the user
Field type dimension
Data type string.text.value
profile_info__user_screen_name
Display name User screen name
Description Screen name of the user
Field type dimension
Data type string.text.value
profile_info__user_url
Display name User URL
Description A link to the user's website
Field type dimension
Data type string.text.url
profile_info__verified
Display name Verified
Description Whether or not the Twitter user is verified
Field type dimension
Data type bool
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: TWEET

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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
tweet_engagements__account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
tweet_engagements__account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
tweet_engagements__card_uri
Display name Card URI
Description Card URI
Field type dimension
Data type string.text.url
tweet_engagements__created_date
Display name Created date
Description Date the tweet was created
Field type dimension
Data type string.time.date
tweet_engagements__created_datetime
Display name Created date & time
Description Date & time the tweet was created
Field type dimension
Data type string.time.datetime
tweet_engagements__details__app_clicks
Display name App clicks
Description Number of app install or app open attempts
Field type metric
Data type int.number.value
tweet_engagements__details__card_engagements
Display name Card engagements
Description Total number of card engagements
Field type metric
Data type int.number.value
tweet_engagements__details__clicks
Display name Clicks
Description Total number of clicks, including favorites and other engagements
Field type metric
Data type int.number.value
tweet_engagements__details__engagements
Display name Engagements
Description Total number of engagements
Field type metric
Data type int.number.value
tweet_engagements__details__follows
Display name Follows
Description Total number of follows
Field type metric
Data type int.number.value
tweet_engagements__details__impressions
Display name Impressions
Description Total number of impressions
Field type metric
Data type int.number.value
tweet_engagements__details__likes
Display name Likes
Description Total number of likes
Field type metric
Data type int.number.value
tweet_engagements__details__link_clicks
Display name Link clicks
Description Total number of clicks on the link or Website Card in an ad, including earned
Field type metric
Data type int.number.value
tweet_engagements__details__poll_card_votes
Display name Poll card votes
Description Total number of poll card votes
Field type metric
Data type int.number.value
tweet_engagements__details__replies
Display name Replies
Description Total number of replies
Field type metric
Data type int.number.value
tweet_engagements__details__retweets
Display name Retweets
Description Total number of retweets
Field type metric
Data type int.number.value
tweet_engagements__details__total_video_views
Display name Total video views
Description Total number of video views which have been at least 50% in-view for 2 seconds
Field type metric
Data type int.number.value
tweet_engagements__details__tweets_send
Display name Tweets send
Description Total number of tweets send
Field type metric
Data type int.number.value
tweet_engagements__details__unfollows
Display name Unfollows
Description Total number of unfollows
Field type metric
Data type int.number.value
tweet_engagements__details__video_completes
Display name Video completes
Description Total number of video completes, i.e. views where at least 100% of the video was viewed
Field type metric
Data type int.number.value
tweet_engagements__details__video_views_25
Display name Video views 25%
Description Total number of views where at least 25% of the video was viewed
Field type metric
Data type int.number.value
tweet_engagements__details__video_views_50
Display name Video views 50%
Description Total number of views where at least 50% of the video was viewed
Field type metric
Data type int.number.value
tweet_engagements__details__video_views_75
Display name Video views 75%
Description Total number of views where at least 75% of the video was viewed
Field type metric
Data type int.number.value
tweet_engagements__favorited
Display name Favorited
Description Whether or not the tweet is favorited
Field type dimension
Data type bool
tweet_engagements__retweeted
Display name Retweeted
Description Whether or not the tweet has been retweeted by the Twitter account
Field type dimension
Data type bool
tweet_engagements__source
Display name Source
Description The source of the tweet
Field type dimension
Data type string.text.value
tweet_engagements__truncated
Display name Truncated
Description Whether or not the tweets is truncated
Field type dimension
Data type bool
tweet_engagements__tweet_id
Display name Tweet ID
Description ID of the tweet
Field type dimension
Data type string.text.value
tweet_engagements__tweet_language
Display name Tweet language
Description Language of the tweet
Field type dimension
Data type string.language.twolettercode
tweet_engagements__tweet_text
Display name Tweet text
Description The full text of the tweet
Field type dimension
Data type string.text.value