Twitter | Tweet Standard Dataset
Below are the measures and dimensions ChannelMix considers standard for the Twitter Tweets dataset. Due to API restrictions on the amount of tweets that can be pulled each day, we will only be pulling data for the previous day daily. This API restriction is also the reason that backfills can only be ran for the current day in the ChannelMix Control Center.
NOTE: As of June 1, 2023, Twitter Organic datasets are not activatable in ChannelMix due to policies enforced by Twitter related to the number of tweets that can be pulled and increased API access fees. Alternatively, we can create datasets using file upload processes if a file from the Twitter user interface is provided (See: Twitter | Upload | Twitter Organic Tweets Dataset).
This dataset cannot be activated automatically. Please talk to your Client Success Manager about obtaining access.
| Field Name | Type | Description |
|---|---|---|
| Created At | Datetime | When the tweet was created. |
| Action Type | Dimension | The action measured by the data. This will be "tweet" for tweets and "mention" for mentions. |
| Media Type | Dimension | They type of media used in the tweet, either "video" or "photo". |
| Author ID | Dimension | Unique identifier of this user. |
| Author Name | Dimension | The "pretty name" of the user that authored the tweet. |
| Author Username | Dimension | The Twitter handle of the user that authored the tweet. |
| Tweet ID | Dimension | The ID of the tweet. |
| Tweet Text | Dimension | The text of the tweet. |
| URL | Dimension | The URL of the tweet. |
| Expanded URL | Dimension | The more granular version of the tweet URL. |
| Like Count | Whole Number | Number of likes of this tweet. |
| Retweet Count | Whole Number | Number of times this tweet has been Retweeted. |
| Quote Count | Whole Number | Number of times this tweet has been retweeted with a comment (also known as quote). |
| Reply Count | Whole Number | Number of replies of this tweet. |
| Impression Count | Whole Number | Number of times this tweet has been viewed. |
| URL Link Clicks | Whole Number | The number of times that the link provided in the tweet was clicked. |
| User Profile Clicks | Whole Number | The number of times that the user profile was clicked from the tweet. |
| Video View Count | Whole Number | The number of times that the video was viewed. |
| Video Playback 0 Count | Whole Number | The number of times that video playback was started. |
| Video Playback 25 Count | Whole Number | The number of times that 25% of the video was completed. |
| Video Playback 50 Count | Whole Number | The number of times that 50% of the video was completed. |
| Video Playback 75 Count | Whole Number | The number of times that 75% of the video was completed. |
| Video Playback 100 Count | Whole Number | The number of times that 100% of the video was completed. |
| Insert Date | Dimension | ChannelMix field - the timestamp when the row was inserted |
| ChannelMix Profile | Dimension | ChannelMix field - the descriptive name associated to this segment of data |