Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Date | profile_info_date | dim | A date field for today. |
| Account | Account name | profile_info_account_name | dim | The name of the account. |
| Account ID | profile_info_account_id | dim | The ID of the account. | |
| Profile | User name | profile_info_user_name | dim | Name of the user. |
| User screen name | profile_info_user_screen_name | dim | Screen name of the user. | |
| User ID | profile_info_user_id | dim | ID of the user. | |
| Description | profile_info_description | dim | Description of the Twitter user, also known as profile bio. | |
| User language | profile_info_user_language | dim | Language of the Twitter user. | |
| Location | profile_info_location | dim | Location of the Twitter user. | |
| Protected | profile_info_protected | dim | Whether or not the Twitter user is protected. | |
| Verified | profile_info_verified | dim | Whether or not the Twitter user is verified. | |
| User URL | profile_info_user_url | dim | A link to the user's website. | |
| Profile image URL | profile_info_profile_image_url | dim | A link to the user's profile image. | |
| Profile image URL HTTPS | profile_info_profile_image_url_https | dim | A HTTPS link to the user's profile image. | |
| Profile background image URL | profile_info_profile_background_image_url | dim | A link to the user's profile background image. | |
| Profile background image URL HTTPS | profile_info_profile_background_image_url_https | dim | A HTTPS link to the user's profile background image. | |
| Profile banner URL | profile_info_profile_banner_url | dim | A link to the user's profile banner. | |
| Created at datetime | profile_info_created_at_datetime | dim | Date & time the user was created. | |
| Created at date | profile_info_created_at_date | dim | Date the user was created. | |
| Followers | profile_info_followers | met | Total number of followers the Twitter user has. | |
| Following | profile_info_following | met | Total number of friends Twitter user has. | |
| Lists | profile_info_lists | met | The number of public lists that this user is a member of. | |
| Tweets | profile_info_tweets | met | Total lifetime number of tweets the Twitter user has published. | |
| Favourites | profile_info_favourites | met | Total lifetime number of favourites the Twitter user has. | |
| Account | Account name | tweet_engagements_account_name | dim | The name of the account. |
| Account ID | tweet_engagements_account_id | dim | The ID of the account. | |
| Account handle | tweet_engagements_account_handle | dim | The handle of the X account. | |
| Tweet | Tweet ID | tweet_engagements_tweet_id | dim | ID of the tweet. |
| Tweet text | tweet_engagements_tweet_text | dim | The full text of the tweet. | |
| Tweet URL | tweet_engagements_tweet_url | dim | A link to the tweet. | |
| Tweet language | tweet_engagements_tweet_language | dim | Language of the tweet. | |
| Source | tweet_engagements_source | dim | The source of the tweet. | |
| Card URI | tweet_engagements_card_uri | dim | Card URI. | |
| Retweeted | tweet_engagements_retweeted | dim | Whether or not the tweet has been retweeted by the Twitter account. | |
| Truncated | tweet_engagements_truncated | dim | Whether or not the tweets is truncated. | |
| Favorited | tweet_engagements_favorited | dim | Whether or not the tweet is favorited. | |
| Timeline type | tweet_engagements_timeline_type | dim | The timeline type of the tweet. | |
| Tweet type | tweet_engagements_tweet_type | dim | The type of the tweet. | |
| Created date & time | tweet_engagements_created_datetime | dim | Date & time the tweet was created. | |
| Created date | tweet_engagements_created_date | dim | Date the tweet was created. | |
| Time | Impressions | tweet_engagements_details__impressions | met | Total number of impressions. |
| Clicks | tweet_engagements_details__clicks | met | Total number of clicks, including favorites and other engagements. | |
| Engagements | tweet_engagements_details__engagements | met | Total number of engagements. | |
| Retweets | tweet_engagements_details__retweets | met | Total number of retweets. | |
| Replies | tweet_engagements_details__replies | met | Total number of replies. | |
| Likes | tweet_engagements_details__likes | met | Total number of likes. | |
| Engagement rate | tweet_engagements_details__engagement_rate | met | The rate at which the users engaged with the tweet (Engagements / Impressions). | |
| Retweet rate | tweet_engagements_details__retweet_rate | met | The rate at which the users retweeted the tweet (Retweets / Impressions). | |
| Reply rate | tweet_engagements_details__reply_rate | met | The rate at which the users replied to the tweet (Replies / Impressions). | |
| Like rate | tweet_engagements_details__like_rate | met | The rate at which the users liked the tweet (Likes / Impressions). | |
| Follows | tweet_engagements_details__follows | met | Total number of follows. | |
| Unfollows | tweet_engagements_details__unfollows | met | Total number of unfollows. | |
| Tweets send | tweet_engagements_details__tweets_send | met | Total number of tweets send. | |
| Link clicks | tweet_engagements_details__link_clicks | met | Total number of clicks on the link or Website Card in an ad, including earned. | |
| App clicks | tweet_engagements_details__app_clicks | met | Number of app install or app open attempts. | |
| Card engagements | tweet_engagements_details__card_engagements | met | Total number of card engagements. | |
| Poll card votes | tweet_engagements_details__poll_card_votes | met | Total number of poll card votes. | |
| Video content starts | tweet_engagements_details__video_content_starts | met | Total number of video playback starts. | |
| Total video views | tweet_engagements_details__total_video_views | met | Total number of video views which have been at least 50% in-view for 2 seconds. | |
| Video views 25% | tweet_engagements_details__video_views_25 | met | Total number of views where at least 25% of the video was viewed. | |
| Video views 50% | tweet_engagements_details__video_views_50 | met | Total number of views where at least 50% of the video was viewed. | |
| Video views 75% | tweet_engagements_details__video_views_75 | met | Total number of views where at least 75% of the video was viewed. | |
| Video completes | tweet_engagements_details__video_completes | met | Total number of video completes, i.e. views where at least 100% of the video was viewed. | |
| Video view rate | tweet_engagements_details__video_view_rate | met | The rate at which the users viewed the video on the tweet (Total video views / Impressions). | |
| Video view 25% rate | tweet_engagements_details__video_view_25_rate | met | The percentage of 25% video views. (Video views 25% / Video content starts). | |
| Video view 50% rate | tweet_engagements_details__video_view_50_rate | met | The percentage of 50% video views. (Video views 50% / Video content starts). | |
| Video view 75% rate | tweet_engagements_details__video_view_75_rate | met | The percentage of 75% video views. (Video views 75% / Video content starts). | |
| Video completion rate | tweet_engagements_details__video_completion_rate | met | The percentage of video completes. (Video completes / Video content starts). | |
| Video views 3s (100% in view) | tweet_engagements_details__video_views_3s100pct | met | Total number of views where at least 3 seconds were played while 100% in view. |