Twitter | Upload | Twitter Organic Tweets Dataset
Brendon Reimer
With the emergence of Twitter's increased API access fees, ChannelMix has created this dataset in order to provide an alternative to an API connection. The Twitter user interface allows for two different types of files to be exported for tweet information, one aggregated daily and another aggregated per tweet per day. This dataset is designed to handle either file, but not both, dynamically. Including both types of files in the same dataset would result in duplicated data. Twitter also allows for a "video activity metrics" file to be exported. See Twitter | Upload | Twitter Media Dataset for how to upload this data. The OneViews and Dashboards are configured to allow this dataset to exist alongside v_twitter_tweet (the dataset pulling data from the API) without duplicating data.
This dataset is mirrored after the fields used in the ChannelMix OneViews and Dashboards, so it will not include every field from the files downloaded from Twitter, but rather those that are necessary to the functionality of the OneViews and Dashboards. Further customization may be needed to align the dataset to your reporting needs. Any dimensions that are not pulled will display "Not Available" as their values. Please submit a ticket to the Platform Support team for customization.
This dataset cannot be activated automatically. Please submit a ticket to the Platform Support team to activate this dataset.
| Field Name | Is Standard Field | Type | Description |
|---|---|---|---|
| Report Date | True | Datetime | Twitter Field Name: Either "Date" or "time" depending on the file provided. Description: The timestamp for the activity. |
| Account | False | Dimension | Description: The account for the activity. Twitter does not provide an account field, but ChannelMix inserts the channelmix_profile as the default value. |
| Post Type | False | Dimension | Description: The type of post. |
| Content | True | Dimension | Twitter Field Name: "Tweet text" Description: The text of the tweet. |
| ID | True | Dimension | Twitter Field Name: "Tweet id" Description: The ID of the tweet. |
| URL | True | Dimension | Twitter Field Name: "Tweet permalink" Description: The URL of the tweet. Sometimes referred to as the "expanded URL" by Twitter. |
| Impressions | True | Decimal | Twitter Field Name: "impressions" Description: Number of times this Tweet has been viewed. |
| Engagements | True | Decimal | Twitter Field Name: "engagements" Description: User actions associated to the tweet. Sum of: retweets + replies + likes + user profile clicks + url clicks + hashtag clicks + detail expands + permalink clicks + app opens + app installs + follows + email tweet + dial phone + media engagements |
| Likes | True | Decimal | Twitter Field Name: "likes" Description: Number of Likes of this Tweet. |
| Comments | True | Decimal | Twitter Field Name: "replies" Description: Number of Replies of this Tweet. |
| Shares | True | Decimal | Twitter Field Name: "retweets" Description: Number of times this Tweet has been Retweeted. |
| Video Views | True | Decimal |
Twitter Field Name: "media views" or "video views" (see notes) NOTE 1: The "media views" field included in the tweet activity files includes videos and photos, while the "video views" field available in the video activity file only includes videos. NOTE 2: If the v_upload_twitter_media dataset is activated, the organic_video_views field will override media_views as the value for Video Views in the associated OneViews and dashboards, but not in the source level dataset. |
| Video Completions | False | Decimal |
Twitter Field Name: "playback completes" IF v_upload_twitter_media IS ACTIVATED (see notes) NOTE: If the v_upload_twitter_media dataset is activated, the organic_playback_completes field will override media_views as the value for Video Completions in the associated OneViews and dashboards, but not in the source level dataset. |
| Report Filename | True | Dimension | Description: The name of the file that was uploaded. |
| Insert Date | True | Dimension | ChannelMix field - the timestamp when the row was inserted |
| ChannelMix Profile | True | Dimension | ChannelMix field - the descriptive name associated to this segment of data |