X Organic (Twitter) fields

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

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

34 metrics48 dimensions

ACCOUNT

profile_info__account_name
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
profile_info__account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
tweet_engagements__account_name
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
tweet_engagements__account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
tweet_engagements__account_handle
Field label Account handle
Description The handle of the X account
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

PROFILE

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

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
profile_info__date
Field label Date
Description A date field for today
Field type dimension
Data type string.time.date
Destinations Google Sheets, Looker Studio

TWEET

tweet_engagements__tweet_id
Field label Tweet ID
Description ID of the tweet
Field type dimension
Data type string.text.value
tweet_engagements__tweet_text
Field label Tweet text
Description The full text of the tweet
Field type dimension
Data type string.text.value
tweet_engagements__tweet_url
Field label Tweet URL
Description A link to the tweet
Field type dimension
Data type string.text.url
tweet_engagements__parent_tweet_id
Field label Parent tweet ID
Description ID of the parent tweet
Field type dimension
Data type string.text.value
tweet_engagements__tweet_language
Field label Tweet language
Description Language of the tweet
Field type dimension
Data type string.language.twolettercode
tweet_engagements__source
Field label Source
Description The source of the tweet
Field type dimension
Data type string.text.value
tweet_engagements__card_uri
Field label Card URI
Description Card URI
Field type dimension
Data type string.text.url
tweet_engagements__retweeted
Field label Retweeted
Description Whether or not the tweet has been retweeted by the Twitter account
Field type dimension
Data type bool
tweet_engagements__truncated
Field label Truncated
Description Whether or not the tweets is truncated
Field type dimension
Data type bool
tweet_engagements__favorited
Field label Favorited
Description Whether or not the tweet is favorited
Field type dimension
Data type bool
tweet_engagements__timeline_type
Field label Timeline type
Description The timeline type of the tweet
Field type dimension
Data type string.text.value
tweet_engagements__tweet_type
Field label Tweet type
Description The type of the tweet
Field type dimension
Data type string.text.value
tweet_engagements__created_datetime
Field label Created date & time
Description Date & time the tweet was created
Field type dimension
Data type string.time.datetime
tweet_engagements__created_date
Field label Created date
Description Date the tweet was created
Field type dimension
Data type string.time.date

TWEETS

tweet_engagements__details__impressions
Field label Impressions
Description Total number of impressions
Field type metric
Data type int.number.value
tweet_engagements__details__clicks
Field label Clicks
Description Total number of clicks, including favorites and other engagements
Field type metric
Data type int.number.value
tweet_engagements__details__engagements
Field label Engagements
Description Total number of engagements
Field type metric
Data type int.number.value
tweet_engagements__details__retweets
Field label Retweets
Description Total number of retweets
Field type metric
Data type int.number.value
tweet_engagements__details__replies
Field label Replies
Description Total number of replies
Field type metric
Data type int.number.value
tweet_engagements__details__likes
Field label Likes
Description Total number of likes
Field type metric
Data type int.number.value
tweet_engagements__details__engagement_rate
Field label Engagement rate
Description The rate at which the users engaged with the tweet (Engagements / Impressions)
Field type metric
Data type float.number.ratio
tweet_engagements__details__retweet_rate
Field label Retweet rate
Description The rate at which the users retweeted the tweet (Retweets / Impressions)
Field type metric
Data type float.number.ratio
tweet_engagements__details__reply_rate
Field label Reply rate
Description The rate at which the users replied to the tweet (Replies / Impressions)
Field type metric
Data type float.number.ratio
tweet_engagements__details__like_rate
Field label Like rate
Description The rate at which the users liked the tweet (Likes / Impressions)
Field type metric
Data type float.number.ratio
tweet_engagements__details__follows
Field label Follows
Description Total number of follows
Field type metric
Data type int.number.value
tweet_engagements__details__unfollows
Field label Unfollows
Description Total number of unfollows
Field type metric
Data type int.number.value
tweet_engagements__details__tweets_send
Field label Tweets send
Description Total number of tweets send
Field type metric
Data type int.number.value
tweet_engagements__details__link_clicks
Field label 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__app_clicks
Field label App clicks
Description Number of app install or app open attempts
Field type metric
Data type int.number.value
tweet_engagements__details__card_engagements
Field label Card engagements
Description Total number of card engagements
Field type metric
Data type int.number.value
tweet_engagements__details__poll_card_votes
Field label Poll card votes
Description Total number of poll card votes
Field type metric
Data type int.number.value

VIDEO

tweet_engagements__details__video_content_starts
Field label Video content starts
Description Total number of video playback starts
Field type metric
Data type int.number.value
tweet_engagements__details__total_video_views
Field label 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__video_views_25
Field label 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
Field label 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
Field label 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__details__video_completes
Field label 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_view_rate
Field label Video view rate
Description The rate at which the users viewed the video on the tweet (Total video views / Impressions)
Field type metric
Data type float.number.ratio
tweet_engagements__details__video_view_25_rate
Field label Video view 25% rate
Description The percentage of 25% video views. (Video views 25% / Video content starts)
Field type metric
Data type float.number.ratio
tweet_engagements__details__video_view_50_rate
Field label Video view 50% rate
Description The percentage of 50% video views. (Video views 50% / Video content starts)
Field type metric
Data type float.number.ratio
tweet_engagements__details__video_view_75_rate
Field label Video view 75% rate
Description The percentage of 75% video views. (Video views 75% / Video content starts)
Field type metric
Data type float.number.ratio
tweet_engagements__details__video_completion_rate
Field label Video completion rate
Description The percentage of video completes. (Video completes / Video content starts)
Field type metric
Data type float.number.ratio
tweet_engagements__details__video_views_3s100pct
Field label Video views 3s (100% in view)
Description Total number of views where at least 3 seconds were played while 100% in view
Field type metric
Data type int.number.value