Twitter | Upload | Twitter Media 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 a "video activity metrics" file to be exported and this dataset is intended to capture that data.
This dataset provides some data to the ChannelMix OneViews and dashboards. If this dataset is activated, the organic_video_views field will override media_views as the value for Video Views and the organic_playback_completes field will override media_views as the value for Video Completions in the associated OneViews and dashboards. 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. See Twitter | Upload | Twitter Organic Tweets Dataset for how to upload data for the rest of the fields used in the OneViews and dashboards.
This dataset cannot be activated automatically. Please submit a ticket to the Platform Support team to activate this dataset.
| Field Name | Type | Description |
|---|---|---|
| Report Date | Date | The date of the activity. |
| Video ID | Dimension | The ID of the video, not specific to a tweet. A video can be referenced in more than one tweet. |
| Title | Dimension | The title of the video. |
| Duration | Dimension | The length of the video in minutes and seconds (i.e. 1:30). |
| Poster Image URL | Dimension | Video thumbnail image. |
| Organic Playback Starts | Whole Number | The number of times the video was started as a result of the user finding it organically. |
| Organic Playback 25% | Whole Number | The number of times that 25% of the video was completed as a result of the user finding it organically. |
| Organic Playback 50% | Whole Number | The number of times that 50% of the video was completed as a result of the user finding it organically. |
| Organic Playback 75% | Whole Number | The number of times that 75% of the video was completed as a result of the user finding it organically. |
| Organic Playback Completes | Whole Number | The number of times that 100% of the video was completed as a result of the user finding it organically. |
| Organic Video Views | Whole Number | The number of times that the video was viewed as a result of the user finding it organically. |
| Organic Completion Rate Percentage | Decimal | The completion rate of the video as a result of the user finding it organically. Provided as a percentage (i.e. 5.3 = 5.3%). |
| Organic CTA Clicks | Whole Number | The number of call to action clicks as a result of the user finding the video organically. |
| Organic Minutes Viewed | Whole Number | The number of minutes that the video was viewed as a result of the user finding it organically. Provided as a whole number (i.e. 4 = 4 minutes). |
| Promoted Playback Starts | Whole Number | The number of times the video was started as a result of the user finding it via promoted tweet. |
| Promoted Playback 25% | Whole Number | The number of times that 25% of the video was completed as a result of the user finding it via promoted tweet. |
| Promoted Playback 50% | Whole Number | The number of times that 50% of the video was completed as a result of the user finding it via promoted tweet. |
| Promoted Playback 75% | Whole Number | The number of times that 75% of the video was completed as a result of the user finding it via promoted tweet. |
| Promoted Playback Completes | Whole Number | The number of times that 100% of the video was completed as a result of the user finding it via promoted tweet. |
| Promoted Video Views | Whole Number | The number of times that the video was viewed as a result of the user finding it via promoted tweet. |
| Promoted Completion Rate Percentage | Decimal | The completion rate of the video as a result of the user finding it via promoted tweet. Provided as a percentage (i.e. 5.3 = 5.3%). |
| Promoted CTA Clicks | Whole Number | The number of call to action clicks as a result of the user finding the video via promoted tweet. |
| Promoted Minutes Viewed | Whole Number | The number of minutes that the video was viewed as a result of the user finding it via promoted tweet. Provided as a whole number (i.e. 4 = 4 minutes). |
| Toptweet n ID | Dimension | Where n represents a number from 1-10, the ID of the tweet with the most (n = 1) to least (n = 10) views. |
| Toptweet n Time | Datetime | Where n represents a number from 1-10, the timestamp of the tweet with the most (n = 1) to least (n = 10) views. |
| Toptweet n Permalink | Dimension | Where n represents a number from 1-10, the URL of the tweet with the most (n = 1) to least (n = 10) views. |
| Toptweet n Text | Dimension | Where n represents a number from 1-10, the text of the tweet with the most (n = 1) to least (n = 10) views. |
| Toptweet n Organic Views | Decimal | Where n represents a number from 1-10, the number of organic views of the tweet with the most (n = 1) to least (n = 10) views. |
| Toptweet n Promoted Views | Decimal | Where n represents a number from 1-10, the number of promoted views of the tweet with the most (n = 1) to least (n = 10) views. |
| Report Filename | Dimension | The name of the file that was uploaded. |
| 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 |