Below are the measures and dimensions that ChannelMix considers standard for the Facebook - Video Post dataset. There is a 0 day lag and data is pulled for the last 60 days at 0230 Central Time and then an additional schedule runs at 1300 Central Time that pulls data for the last 3 days in order to provide video insights after the prime social media posting time, which is around 1200. Most post/video engagement happens within the first 48 hours (sometimes even within the first 5 hours), depending on the size of your brand, quality of the content, etc., so this schedule ensures that you have the most up-to-date data without actually being real-time.
This dataset can be automatically activated without a ticket through Dataset Activation.
|Created Time||Datetime||The date the video was created.|
|Video ID||Datetime||The ID of the video.|
|Video Type||Dimension||The type of video used. Possibilities include: Reel, Story, or Video.|
|Title||Dimension||The title of the video. This field does not apply to all video types.|
|Description||Dimension||The description of the video. This field does not apply to all video types.|
|Permalink URL||Dimension||The permalink URL of the video.|
|Link||Dimension||The URL of the post and video.|
|Source||Dimension||The link to just the video used within the post.|
|Metric||Dimension||A selection of the metrics found here that ChannelMix considers to be the most valuable when reviewing post videos.|
|Performance Metric Value||Decimal||The value of any metric that does not consider viewing time.|
|View Time Metric Value in Seconds||Decimal||
The value of any metric that does consider viewing time, provided in seconds.
|Insert Date||Dimension||Internal use: when the row was inserted in the table.|
|ChannelMix Profile||Dimension||When needed, distinguishes between Facebook accounts – Contents defined by Alight.|