Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Date & time | time | dim | |
| ACCOUNT | Name | username | dim | |
| ID | id | dim | ||
| Location | user_location | dim | ||
| Twitter name | twitter_name | dim | ||
| User description | user_description | dim | ||
| User description (translated) | user_description_translated | dim | ||
| Reply to name | in_reply_to_screen_name | dim | ||
| MISCELLANEOUS | Tweet location name | place_name | dim | |
| Tweet location full name | place_full_name | dim | ||
| Tweet country code | place_country_code | dim | ||
| Country | place_country | dim | ||
| Is favorited | favorited | dim | ||
| Is retweeted | retweeted | dim | ||
| Is possibly sensitive | possibly_sensitive | dim | ||
| Is quote status | is_quote_status | dim | ||
| TWEETS | Tweet | text | dim | |
| Tweet (translated) | text_translated | dim | ||
| Link to tweet | link | dim | ||
| Tweet language | language | dim | ||
| DEPRECATED | Is truncated | truncated | dim | Please note that this field will be removed on 2023-05-31 |
| Tweet source | source | dim | Please note that this field will be removed on 2023-05-31 | |
| ACCOUNT METRICS | User followers | followers | met | |
| TWEETS METRICS | Retweets | retweets | met | |
| Likes | likes | met | ||
| TIME | Created at | created_at | dim | |
| Status created at | status_created_at | dim | ||
| ACCOUNT | Username | screen_name | dim | |
| Link to profile | link_to_profile | dim | ||
| Name | name | dim | ||
| Description | description | dim | ||
| Description (translated) | description_translated | dim | ||
| Location | location | dim | ||
| ID | id | dim | ||
| Link to website | url | dim | ||
| Verified | verified | dim | ||
| MISCELLANEOUS | Is protected | protected | dim | |
| Profile image URL | profile_image_url | dim | ||
| Status text | status_text | dim | ||
| DEPRECATED | Language | lang | dim | Please note that this field will be removed on 2019-05-20 |
| Timezone | time_zone | dim | Please note that this field will be removed on 2019-05-20 | |
| Is geo enabled | geo_enabled | dim | Please note that this field will be removed on 2019-05-20 | |
| Status place | status_place | dim | Please note that this field will be removed on 2023-05-31 | |
| Status source | status_source | dim | Please note that this field will be removed on 2023-05-31 | |
| ACCOUNT METRICS | Listed count | listed_count | met | |
| Followers count | followers_count | met | ||
| Tweets count | statuses_count | met | Number of Tweets (including Retweets) posted by the user | |
| Following count | friends_count | met | ||
| DEPRECATED | Status retweet count | status_retweet_count | met | Please note that this field will be removed on 2023-05-31 |
| Favourites count | favourites_count | met | Please note that this field will be removed on 2023-05-31 | |
| TIME | Date | date | dim | |
| Date & time | time | dim | ||
| ACCOUNT | Name | username | dim | |
| ID | id | dim | ||
| Location | user_location | dim | ||
| Twitter name | twitter_name | dim | ||
| User description | user_description | dim | ||
| User description (translated) | user_description_translated | dim | ||
| MISCELLANEOUS | Tweet location name | place_name | dim | |
| Tweet location full name | place_full_name | dim | ||
| Tweet country code | place_country_code | dim | ||
| Country | place_country | dim | ||
| Is favorited | favorited | dim | ||
| Is retweeted | retweeted | dim | ||
| Is possibly sensitive | possibly_sensitive | dim | ||
| TWEETS | Tweet | text | dim | |
| Tweet (translated) | text_translated | dim | ||
| Link to tweet | link | dim | ||
| Tweet language | language | dim | ||
| DEPRECATED | Is truncated | truncated | dim | Please note that this field will be removed on 2023-05-31 |
| Tweet source | source | dim | Please note that this field will be removed on 2023-05-31 | |
| ACCOUNT METRICS | User followers | followers | met | |
| TWEETS METRICS | Retweets | retweets | met | |
| Likes | likes | met |