Stream all data from Facebook Page Insights to Snowflake
About Facebook Page Insights
About SnowFlake
Connect Facebook Page Insights to Snowflake
It is very simple to connect Facebook Page Insights to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1.You need to select Facebook Page Insights as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3. Enter all the credentials required and click Save
4. Your data will now be streamed from Facebook Page Insights to Snowflake. In case there is an error you will be notified.
Facebook Page Insights metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Account ID | TEXT | The Page ID of the Facebook Page |
| Account Name | TEXT | The Page Name of the Facebook Page |
| Video Backdated Time | TIMESTAMP | A user-specified time for when this object was created. |
| Video Backdated Time Granularity | TEXT | The granularity of the backdated time. How accurate the backdated time is. |
| Reels Lifetime Play Count | NUMERIC | Lifetime: The number of times your reel starts to play after an impression is already counted. This is defined as reels sessions with 1ms or more of playback and excludes replays. |
| Video Captions | TEXT | Captions for the video. |
| Post Clicks (duplicate) | NUMERIC | The number of times people clicked on anywhere in your posts without generating a story. |
| Video Content Category | TEXT | The content category of the video. |
| Created Time | TIMESTAMP | The time the video was initially published. |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | The dimension that determines how date-based data in a chart is handled (the time dimension). |
| Day of month | TEXT | Day of the month |
| Video Description | TEXT | The description of the video. |
| Video Embed HTML | TEXT | The embed HTML of the video. |
| Video Embeddable | BOOLEAN | Whether the video is embeddable. |
| Video Event | TEXT | Event info. |
| Reels Replay Count | NUMERIC | The number of times your reel starts to play again after an initial play of your reel by the same account for at least 1ms in the same session. |
| Reels Total Plays | NUMERIC | The number of times your reel starts to play after an impression is already counted. This is defined as reel sessions with 1ms or more and includes replays. Replays are counted after the initial play of the reel in the same session. |
| Post full picture | TEXT | If the photo's largest dimension exceeds 720 pixels, it is resized, with the largest dimension set to 720. |
| Video Icon | TEXT | The icon that Facebook displays when videos are published to the Feed. |
| Video ID | TEXT | The ID of the video. |
| Video Is Crosspost Video | BOOLEAN | Whether the video is a crosspost from other page. |
| Video Is Crossposting Eligible | BOOLEAN | Whether the video is eligible for crossposting. |
| Post is Eligible For Promotion | BOOLEAN | Whether the post is eligible for promotion. |
| Video Is Episode | BOOLEAN | Whether the video is an episode in a series. |
| Post is Expired | BOOLEAN | Whether the post has expiration time that has passed. |
| Post is Inline Created | BOOLEAN | Returns True if the post was created inline when creating ads. |
| Video Is Instagram Eligible | BOOLEAN | Whether the video is eligible for Instagram promotion. |
| Post is Popular | BOOLEAN | Whether the post is currently popular. Based on whether the total actions as a percentage of reach exceeds a certain threshold. |
| Post is Published | BOOLEAN | Indicates whether a scheduled post was published (applies to scheduled Page Post only, for users post and instanlty published posts this value is always true) |
| Video Length | TEXT | Duration of this video in seconds. |
| Video Live Status | TEXT | Status of the video. |
| Post media Type | TEXT | [deprecated] A string indicating the object type of this post. |
| Month | TEXT | Number of the month |
| (Deprecated) Page Call Phone Clicks By Age Gender Logged In Unique | OBJECT | Number of people who logged in to Facebook and clicked the Call Now button, broken down by age and gender group. |
| (Deprecated) Page Call Phone Clicks By Site Logged In Unique | OBJECT | The number of people who clicked your Page's phone number or Call Now button while they were logged into Facebook, broken down by the type of device they used. |
| (Deprecated) Page Call Phone Clicks Logged In By City Unique | OBJECT | Number of people who logged in to Facebook and clicked the Call Now button, broken down by city. |
| (Deprecated) Page Call Phone Clicks Logged In By Country Unique | OBJECT | Number of people who logged in to Facebook and clicked the Call Now button, broken down by countries. |
| (Deprecated) Page Call Phone Clicks Logged In Unique | OBJECT | Number of people who logged in to Facebook and clicked the Call Now button. |
| (Deprecated) Page Consumptions | NUMERIC | The number of times people clicked on any of your content. |
| Page Consumptions By Consumption Type | OBJECT | The number of people who clicked on any of your content. |
| Page Consumptions By Consumtion Type Unique | OBJECT | The number of people who clicked on any of your content, by type. |
| Page Consumptions Unique | NUMERIC | The number of people who clicked on any of your content. |
| (Deprecated) Page CTA Clicks By Age Gender Logged In Unique | OBJECT | Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by age and gender group. |
| Page CTA Clicks By Site Logged In Unique | OBJECT | Number of people who are logged in to Facebook and clicked on the CTA button, broken down by www, mobile, api or other. |
| (Deprecated) Page CTA Clicks Logged In By City Unique | OBJECT | Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by city. |
| (Deprecated) Page CTA Clicks Logged In By Country Unique | OBJECT | Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by country. |
| Page CTA Clicks Logged In Total | NUMERIC | Total number of clicks on the Page CTA button by people who are logged in to Facebook (default attribution window). |
| Page CTA Clicks Logged In Total (number of comments). | NUMERIC | Total number of clicks on the Page CTA button by people who are logged in to Facebook (number of comments). |
| Page CTA Clicks Logged In Total (number of likes). | NUMERIC | Total number of clicks on the Page CTA button by people who are logged in to Facebook (number of likes). |
| Page CTA Clicks Logged In Total (times stories have been shared). | NUMERIC | Total number of clicks on the Page CTA button by people who are logged in to Facebook (times stories have been shared). |
| Page CTA Clicks Logged In Unique | NUMERIC | Unique number of clicks on the Page CTA button by people who are logged in to Facebook (default attribution window). |
| Page CTA Clicks Logged In Unique (number of comments). | NUMERIC | Unique number of clicks on the Page CTA button by people who are logged in to Facebook (number of comments). |
| Page CTA Clicks Logged In Unique (number of likes). | NUMERIC | Unique number of clicks on the Page CTA button by people who are logged in to Facebook (number of likes). |
| Page CTA Clicks Logged In Unique (times stories have been shared). | NUMERIC | Unique number of clicks on the Page CTA button by people who are logged in to Facebook (times stories have been shared). |
| Daily Follows | NUMERIC | The number of people who have followed your Page daily. |
| Daily Follows Unique | NUMERIC | The number of people who have followed your Page daily. (Unique Users) |
| Daily Unfollows | NUMERIC | The number of people who have unfollowed your Page daily. |
| Daily Unfollows Unique | NUMERIC | The number of people who have unfollowed your Page daily. (Unique Users) |
| (Deprecated) Page Engaged Users | NUMERIC | The number of people who engaged with your Page. Engagement includes any click. |
| New likes | NUMERIC | The number of new people who have liked your Page |
| Page Fans Adds By Paid Non Paid Unique | OBJECT | The number of new people who have liked your Page broken down by paid and non-paid. |
| New likes (unique users) | NUMERIC | The number of new people who have liked your Page (Unique users) |
| New unlikes | NUMERIC | The number of new people who have unliked your Page |
| Unlikes (unique users) | NUMERIC | The number of Unlikes of your Page (Unique users) |
| Page Fans total page likes | NUMERIC | The total number of people who have liked your Page |
| (Deprecated) Page Fans Age | TEXT | The number of people who have liked your Page, broken down by age (should be used with 'page_fans_likes' and 'date' fields together) |
| Page Fans City | CITY | The number of people who have liked your Page, broken down by city (should be used with 'page_fans_likes' and 'date' fields together) |
| Page Fans Country | COUNTRY | The number of people who have liked your Page, broken down by country (should be used with 'page_fans_likes' and 'date' fields together) |
| Page Fans total page likes (daily) | NUMERIC | The total number of people who have liked your Page (daily) |
| (Deprecated) Page Fans Gender | TEXT | The number of people who have liked your Page, broken down by gender (should be used with 'page_fans_likes' and 'date' fields together) |
| (Deprecated) Page Fans Gender and Age | TEXT | The number of people who have liked your Page, broken down by gender and age (should be used with 'page_fans_likes' and 'date' fields together) |
| Page Fans Likes (for dimensions) | NUMERIC | The number of people who have liked your Page broken down by dimensions (page_fans_gender_age, page_fans_locale, page_fans_city, page_fans_country, page_fans_gender, page_fans_age fields) |
| Page Fans Locale | TEXT | The number of people who have liked your Page, broken down by locale (should be used with page_fans_likes and date fields together). |
| Page Fans Online | OBJECT | The number of your fans who saw any posts on Facebook on a given day, broken down by hour of day in PST/PDT. |
| Page Fans Online Per Day | NUMERIC | The number of your fans who saw any posts on Facebook on a given day. |
| Lifetime Total Follows | NUMERIC | Lifetime - The total number of people who have followed your Page. (Unique Users) |
| Lifetime Total Follows daily | NUMERIC | Lifetime - The total number of people who have followed your Page daily. (Unique Users) |
| (Deprecated) Page Get Directions Clicks By Age Gender Logged In Unique | OBJECT | Number of people who logged in to Facebook and clicked the Get Directions button, broken down by age and gender group. |
| (Deprecated) Page Get Directions Clicks By Site Logged In Unique | OBJECT | Number of people who logged in to Facebook and clicked the Get Directions button, broken down by www, mobile, api or other. |
| (Deprecated) Page Get Directions Clicks Logged In By City Unique | OBJECT | Number of people who logged in to Facebook and clicked the Get Directions button, broken down by city. |
| (Deprecated) Page Get Directions Clicks Logged In By Country Unique | OBJECT | Number of people who logged in to Facebook and clicked the Get Directions button, broken down by country. |
| Page Get Directions Clicks Logged In Unique | NUMERIC | Number of people who logged in to Facebook and clicked the Get Directions button. |
| Page Id | TEXT | Page id |
| Page Impressions | NUMERIC | The number of times any content from your Page or about your Page entered a person's screen. This includes posts, stories, ads, as well other content or information on your Page. |
| Page Impressions Organic | NUMERIC | The number of times any post or story content from your Page or about your Page entered a person's screen through unpaid distribution. |
| Page Impressions Paid | NUMERIC | The number of times any post or story content from your Page or about your Page entered a person's screen through paid distribution such as an ad. |
| Page Impressions Unique | NUMERIC | The number of people who had any content from your Page or about your Page enter their screen. This includes posts, stories, check-ins, ads, social information from people who interact with your Page and more. |
| Page Name | TEXT | The name of the Page |
| Page Negative Feedback | NUMERIC | The number of times people took a negative action (e.g., un-liked or hid a post). |
| Page Negative Fedback By Type | OBJECT | The number of times people took a negative action broken down by type (default attribution window). |
| Page Negative Fedback By Type (number of comments). | OBJECT | The number of times people took a negative action broken down by type (number of comments). |
| Page Negative Feedback By Type Hide Clicks | NUMERIC | Number of negative actions, disaggregated by type (hide_clicks) (default attribution window). |
| Page Negative Feedback By Type Hide Clicks (number of comments). | NUMERIC | Number of negative actions, disaggregated by type (hide_clicks) (number of comments). |
| Page Negative Feedback By Type Hide Clicks (number of likes). | NUMERIC | Number of negative actions, disaggregated by type (hide_clicks) (number of likes). |
| Page Negative Feedback By Type Hide Clicks (times stories have been shared). | NUMERIC | Number of negative actions, disaggregated by type (hide_clicks) (times stories have been shared). |
| Page Negative Fedback By Type (number of likes). | OBJECT | The number of times people took a negative action broken down by type (number of likes). |
| Page Negative Fedback By Type (times stories have been shared). | OBJECT | The number of times people took a negative action broken down by type (times stories have been shared). |
| Page Negative Fedback By Type Unique | OBJECT | The number of people who took a negative action broken down by type (default attribution window). |
| Page Negative Fedback By Type Unique (number of comments). | OBJECT | The number of people who took a negative action broken down by type (number of comments). |
| Page Negative Fedback By Type Unique (number of likes). | OBJECT | The number of people who took a negative action broken down by type (number of likes). |
| Page Negative Fedback By Type Unique (times stories have been shared). | OBJECT | The number of people who took a negative action broken down by type (times stories have been shared). |
| Page Negative Feedback Unique | NUMERIC | The number of people who took a negative action (e.g., un-liked or hid a post). |
| (Deprecated) Page Places Checkin Mobile | NUMERIC | The number of times people checked into a place using mobile phones. |
| (Deprecated) Page Places Checkin Mobile Unique | NUMERIC | The number of people who checked into a place using mobile phones. |
| Page Places Checkin Total | NUMERIC | The number of times people checked into a place. |
| Page Places Checkin Total Unique | NUMERIC | The number of people who checked into a place. |
| (Deprecated) Page Places Checkin By Age Gender | NUMERIC | gender and age of people who checked in at your Place. |
| (Deprecated) Page Places Checkins By Country | NUMERIC | top countries of people who checked into your Place. |
| (Deprecated) Page Places Checkin By Locale | NUMERIC | top locales of people who checked into your Place. |
| (Deprecated) Page Positive Feedback By Type | OBJECT | The number of times people took a positive action broken down by type. |
| (Deprecated) Page Positive Feedback By Type Unique | OBJECT | The number of people who took a positive action broken down by type. |
| Page Post Engagements | NUMERIC | The number of times people have engaged with your posts through reactions, comments, shares and more. |
| Page Total Actions | NUMERIC | The number of clicks on your Page's contact info and call-to-action button. |
| Page Video View Time | NUMERIC | The total time (in milliseconds) spent by users watching videos on your Page. |
| Page Video Views | NUMERIC | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds. During separate playback, videos are treated separately, replay time is excluded. |
| Page Video Views Autoplayed | NUMERIC | The number of times your autoplay videos have been viewed for at least 3 seconds, or almost completely if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account. |
| Paid Page Video Views By Paid Non Paid | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by paid views. During a separate playback event, video views are counted separately, repeat times are excluded (default attribution window). |
| Paid Page Video Views By Paid Non Paid (number of comments). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by paid views. During a separate playback event, video views are counted separately, repeat times are excluded (number of comments). |
| Paid Page Video Views By Paid Non Paid (number of likes). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by paid views. During a separate playback event, video views are counted separately, repeat times are excluded (number of likes). |
| Paid Page Video Views By Paid Non Paid (times stories have been shared). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by paid views. During a separate playback event, video views are counted separately, repeat times are excluded (times stories have been shared). |
| Total Page Video Views By Paid Non Paid | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by total views. During a separate playback event, video views are counted separately, repeat times are excluded (default attribution window). |
| Total Page Video Views By Paid Non Paid (number of comments). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by total views. During a separate playback event, video views are counted separately, repeat times are excluded (number of comments). |
| Total Page Video Views By Paid Non Paid (number of likes). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by total views. During a separate playback event, video views are counted separately, repeat times are excluded (number of likes). |
| Total Page Video Views By Paid Non Paid (times stories have been shared). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by total views. During a separate playback event, video views are counted separately, repeat times are excluded (times stories have been shared). |
| Unpaid Page Video Views By Paid Non Paid | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by unpaid views. During a separate playback event, video views are counted separately, repeat times are excluded (default attribution window). |
| Unpaid Page Video Views By Paid Non Paid (number of comments). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by unpaid views. During a separate playback event, video views are counted separately, repeat times are excluded (number of comments). |
| Unpaid Page Video Views By Paid Non Paid (number of likes). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by unpaid views. During a separate playback event, video views are counted separately, repeat times are excluded (number of likes). |
| Unpaid Page Video Views By Paid Non Paid (times stories have been shared). | OBJECT | The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by unpaid views. During a separate playback event, video views are counted separately, repeat times are excluded (times stories have been shared). |
| Page Video Views Click To Play | NUMERIC | The number of views of your Page video, initiated by pressing the "Play" button, for at least 3 seconds, or almost completely if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account. |
| Page Video Views Organic | NUMERIC | Your Page's video has been viewed for at least 3 seconds, or nearly all if shorter than 3 seconds, within organic reach. When analyzing a single case of video playback, the time spent on repetitions is not taken into account. |
| Page Video Views Paid | NUMERIC | The number of views of your Page's promoted videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds. For each video impression, views are counted separately, the time spent on replays is not counted. |
| Page Video Views Unique | NUMERIC | The number of people who viewed your Page's video for at least 3 seconds, or almost all of them if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account. |
| (Deprecated) Page Website Clicks By Age Gender Logged In Unique | OBJECT | Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by age and gender group. |
| (Deprecated) Page Website Clicks By Site Logged In Unique | OBJECT | Number of people who logged in to Facebook and clicked the Page CTA button, broken down by www, mobile, api and other. |
| (Deprecated) Page Website Clicks Logged In By City Unique | OBJECT | Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by city. |
| (Deprecated) Page Website Clicks Logged In By Country Unique | OBJECT | Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by country. |
| Page Website Clicks Logged In Unique | NUMERIC | Number of people who logged in to Facebook and clicked the goto website CTA button. |
| Post permalink URL | TEXT | The permanent static URL to the post/video on www.facebook.com. Example https://www.facebook.com/FacebookforDevelopers/posts/10153449196353553 |
| Video Thumbnail Picture | TEXT | The URL for the thumbnail picture of the video. |
| Video Place | TEXT | Place info. |
| Video Poll Settings | OBJECT | Settings for polls on the video. |
| Video Polls | OBJECT | Video polls attached to this video. |
| Post Activity | NUMERIC | The number of action types at post level (likes, comments, shares). Includes actions in the original post and its shares (default attribution window). |
| Post Activity (number of comments). | NUMERIC | The number of action types at post level (likes, comments, shares). Includes actions in the original post and its shares (number of comments). |
| Post Activity (number of likes). | NUMERIC | The number of action types at post level (likes, comments, shares). Includes actions in the original post and its shares (number of likes). |
| Post Activity (times stories have been shared). | NUMERIC | The number of action types at post level (likes, comments, shares). Includes actions in the original post and its shares (times stories have been shared). |
| Post Clicks | NUMERIC | The number of times people clicked on anywhere in your posts without generating a story. |
| Post Clicks By Type Link Clicks | NUMERIC | The number of clicks on any places in your publications without creating news (link clicks) (default attribution window). |
| Post Clicks By Type Link Clicks (number of comments). | NUMERIC | The number of clicks on any places in your publications without creating news (link clicks) (number of comments). |
| Post Clicks By Type Link Clicks (number of likes). | NUMERIC | The number of clicks on any places in your publications without creating news (link clicks) (number of likes). |
| Post Clicks By Type Link Clicks (times stories have been shared). | NUMERIC | The number of clicks on any places in your publications without creating news (link clicks) (times stories have been shared). |
| Post Clicks By Type Other clicks | NUMERIC | The number of clicks on any places in your publications without creating news (other clicks) (default attribution window). |
| Post Clicks By Type Other clicks (number of comments). | NUMERIC | The number of clicks on any places in your publications without creating news (other clicks) (number of comments). |
| Post Clicks By Type Other clicks (number of likes). | NUMERIC | The number of clicks on any places in your publications without creating news (other clicks) (number of likes). |
| Post Clicks By Type Other clicks (times stories have been shared). | NUMERIC | The number of clicks on any places in your publications without creating news (other clicks) (times stories have been shared). |
| Post Clicks By Type Photo View | NUMERIC | The number of clicks on any places in your publications without creating news (photo clicks) (default attribution window). |
| Post Clicks By Type Photo View (number of comments). | NUMERIC | The number of clicks on any places in your publications without creating news (photo clicks) (number of comments). |
| Post Clicks By Type Photo View (number of likes). | NUMERIC | The number of clicks on any places in your publications without creating news (photo clicks) (number of likes). |
| Post Clicks By Type Photo View (times stories have been shared). | NUMERIC | The number of clicks on any places in your publications without creating news (photo clicks) (times stories have been shared). |
| Post Clicks By Type Video Play | NUMERIC | The number of clicks on any places in your publications without creating news (video plays) (default attribution window). |
| Post Clicks By Type Video Play (number of comments). | NUMERIC | The number of clicks on any places in your publications without creating news (video plays) (number of comments). |
| Post Clicks By Type Video Play (number of likes). | NUMERIC | The number of clicks on any places in your publications without creating news (video plays) (number of likes). |
| Post Clicks By Type Video Play (times stories have been shared). | NUMERIC | The number of clicks on any places in your publications without creating news (video plays) (times stories have been shared). |
| Post Clicks Unique | NUMERIC | The number of people who clicked anywhere in your post without generating a story. |
| Post Created Time | TIMESTAMP | Post created time |
| Post Description | TEXT | The description of the link (appears beneath the link caption). If not specified, this field is automatically populated by information scraped from the link, typically the title of the page. |
| Post Id | TEXT | Post id |
| Post Impressions | NUMERIC | The number of times your Page's post entered a person's screen. Posts include statuses, photos, links, videos and more. |
| Post impressions Organic | NUMERIC | The number of times your Page posts are displayed on the user's screen as a result of unpaid distribution. |
| Post impressions Organic Unique | NUMERIC | The number of people who displayed your Page post as a result of an unpaid distribution (Post Reach - Organic). |
| Post Impressions Paid | NUMERIC | The number of times your Page post appears on the screen of any user as a result of paid distribution - for example, advertising. |
| Post Impressions Paid Unique | NUMERIC | The number of people on whose screen the publication of your Page was displayed as a result of paid distribution - for example, advertising. |
| Post Impressions Unique | NUMERIC | The number of people on the page displayed the publication of your information. Publications are considered statuses, photos, links, videos, etc. |
| Post Message | TEXT | Post message |
| Post Message Oneline | TEXT | Post message in one line |
| Post Negative Feedback By Type Hide All Clicks | NUMERIC | Number of negative actions taken on your post (hide all clicks) (default attribution window). |
| Post Negative Feedback By Type Hide All Clicks (number of comments). | NUMERIC | Number of negative actions taken on your post (hide all clicks) (number of comments). |
| Post Negative Feedback By Type Hide All Clicks (number of likes). | NUMERIC | Number of negative actions taken on your post (hide all clicks) (number of likes). |
| Post Negative Feedback By Type Hide All Clicks (times stories have been shared). | NUMERIC | Number of negative actions taken on your post (hide all clicks) (times stories have been shared). |
| Post Negative Feedback By Type Hide Clicks | NUMERIC | Number of negative actions taken on your post (hide all clicks) (default attribution window). |
| Post Negative Feedback By Type Hide Clicks (number of comments). | NUMERIC | Number of negative actions taken on your post (hide all clicks) (number of comments). |
| Post Negative Feedback By Type Hide Clicks (number of likes). | NUMERIC | Number of negative actions taken on your post (hide all clicks) (number of likes). |
| Post Negative Feedback By Type Hide Clicks (times stories have been shared). | NUMERIC | Number of negative actions taken on your post (hide all clicks) (times stories have been shared). |
| Post Negative Feedback By Type Unique Hide All Clicks | NUMERIC | The number of people who performed a negative action in your post (hide all clicks) (default attribution window). |
| Post Negative Feedback By Type Unique Hide All Clicks (number of comments). | NUMERIC | The number of people who performed a negative action in your post (hide all clicks) (number of comments). |
| Post Negative Feedback By Type Unique Hide All Clicks (number of likes). | NUMERIC | The number of people who performed a negative action in your post (hide all clicks) (number of likes). |
| Post Negative Feedback By Type Unique Hide All Clicks (times stories have been shared). | NUMERIC | The number of people who performed a negative action in your post (hide all clicks) (times stories have been shared). |
| Post Picture | IMAGE_URL | The picture scraped from any link included with the post. |
| Post Reactions Anger Total | NUMERIC | Total "anger" reactions of a post. Includes "anger" in the original post and its shares. |
| Post Reactions By Like Total | NUMERIC | Total post reactions by type. Includes reactions in the original post and its shares. |
| Post Reactions Haha Total | NUMERIC | Total "haha" reactions of a post. Includes "haha" in the original post and its shares. |
| Post Reactions Like Total | NUMERIC | Total "like" reactions of a post. Includes "like" in the original post and its shares. |
| Post Reactions Love Total | NUMERIC | Total "love" reactions of a post. Includes "love" in the original post and its shares. |
| Post Reactions Sorry Total | NUMERIC | Total "sad" reactions of a post. Includes "sad" in the original post and its shares. |
| Post Reactions Wow Total | NUMERIC | Total "wow" reactions of a post. Includes "wow" in the original post and its shares. |
| Post title | TEXT | The title of the post. |
| Reels Avg Time watched | NUMERIC | Lifetime: the average time (in ms) your reel was played, including any time spent replaying the reel during a single instance of it playing. Because this metric includes replays, this number could be greater than the total length of the reel |
| Post Video Complete Views Organic | NUMERIC | Your videos have been viewed up to 95% or more of their organic reach. During a separate playback case, video views are counted separately, video replay time is excluded. Returns 0 for video reposts. |
| Post Video Complete Views Organic Unique | NUMERIC | The number of people who viewed your videos up to 95% or more of their organic reach. During a single playback event, views are counted separately, repeat times are excluded. Returns 0 for video reposts. |
| Reels Followers | NUMERIC | Lifetime: The number of people who followed your Page or profile within 24 hours of watching this reel. This metric is estimated. |
| Reels Likes By Reaction Type Angry | NUMERIC | Lifetime loves of a video broken down by reaction type. |
| Reels Likes By Reaction Type Care | NUMERIC | Lifetime loves of a video broken down by reaction type. |
| Reels Likes By Reaction Type Haha | NUMERIC | Lifetime loves of a video broken down by reaction type. |
| Reels Likes By Reaction Type Like | NUMERIC | Lifetime likes of a video broken down by reaction type. |
| Reels Likes By Reaction Type Love | NUMERIC | Lifetime loves of a video broken down by reaction type. |
| Reels Likes By Reaction Type Sad | NUMERIC | Lifetime loves of a video broken down by reaction type. |
| Reels Likes By Reaction Type WOW | NUMERIC | Lifetime loves of a video broken down by reaction type. |
| Reels Social Actions Comment | NUMERIC | Lifetime comments of a video. |
| Reels Social Actions Share | NUMERIC | Lifetime shares of a video. |
| Reels Total Reactions | NUMERIC | Total reels reactions. |
| Reels View Time | NUMERIC | The total number of milliseconds your reel played, including time spent replaying your reel. |
| Post Video Views | NUMERIC | The number of times your videos have been viewed for at least 3 seconds, or nearly all if they are shorter than 3 seconds. During a separate case of playback, video views are counted separately, video replay time is excluded. |
| Post Video Views Autoplayed | NUMERIC | The number of times your autoplay videos have been viewed for at least 3 seconds, or almost completely if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account. |
| Post Video Views Clicked To Play | NUMERIC | The number of views of your videos initiated by pressing the Play button for at least 3 seconds, or almost completely if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account. |
| Post Vide Views Organic | NUMERIC | The number of views of your videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds, within organic reach. During a separate playback case, video views are counted separately, video replay time is excluded. |
| Post Video Views Organic Unique | NUMERIC | The number of people who watched your videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds, within organic reach. During a single playback event, views are counted separately, repeat times are excluded. |
| Post Video Views Paid | NUMERIC | The number of views of your promoted videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds. For each video display, video views are counted separately, video repeat times are excluded. |
| Post Video Views Paid Unique | NUMERIC | The number of people who watched your promoted videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds. For each video show, views are counted separately, repeat times are excluded. |
| Post Video Views Unique | NUMERIC | The number of people who watched your videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds. During a separate playback event, video views are counted separately, repeat times are excluded. |
| Video Post Views | NUMERIC | The number of times the video has been viewed. |
| Video Premiere Living Room Status | TEXT | The status of the Premiere Watch Party, if any. |
| Video Privacy | TEXT | The privacy setting for the video. |
| Video Published | BOOLEAN | Whether the video is published. |
| Reel Description | TEXT | The description of the reel. |
| Reels Post Impressions Unique | NUMERIC | The number of people who saw your reel at least once, whether or not the person played your reel. This metric is different from impressions, which includes multiple views of your reel by the same person. This metric is estimated. |
| Video Scheduled Publish Time | TIMESTAMP | The time that the video is scheduled to publish. |
| Video Source | TEXT | A URL to the raw, playable video file. |
| Video Sponsor Tags | TEXT | Sponsor pages tagged in the video. |
| Video Status | TEXT | Status of the video. |
| Video Tags | OBJECT | Users tagged in the video. |
| Post targeting | TEXT | Object that limited the audience for this content. Anyone not in these demographics will not be able to view this content. This will not override any Page-level demographic restrictions that may be in place. |
| Video Thumbnails | TEXT | Thumbnails for the video. |
| Video Title | TEXT | The title of the video. |
| Today | DATE | Today's date |
| Lifetime Total 10-Second Views | NUMERIC | Lifetime: Total number of times your video was viewed for 10 seconds or viewed to the end, whichever came first. (Total Count) |
| Lifetime Auto-Played 10-Second Views | NUMERIC | Lifetime: Number of times your video started automatically playing and people viewed it for 10 seconds, or viewed it to the end, whichever came first. (Total Count) |
| Lifetime Clicked-to-Play 10-Second Views | NUMERIC | Lifetime: Number of times people clicked to play your video and viewed it for 10 seconds or viewed it to the end, whichever came first. (Total Count) |
| Lifetime Organic 10-Second Views | NUMERIC | Lifetime: Number of times your video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. (Total Count) |
| Lifetime Paid 10-Second Views | NUMERIC | Lifetime: Number of times your video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. (Total Count) |
| Lifetime 10-Second Views with sound on | NUMERIC | Lifetime: Number of times your video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. (Total Count) |
| Lifetime Unique 10-Second Views | NUMERIC | Lifetime: Number of unique people who viewed your video for 10 seconds or viewed to the end, whichever came first. (Unique Users) |
| Lifetime Total 15-Second Views | NUMERIC | Lifetime: Total number of times your video was viewed for at least 15 seconds. |
| Lifetime Total 30-Second Views | NUMERIC | Lifetime: Total number of times your video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds. (Total Count) |
| Lifetime Auto-Played 30-Second Views | NUMERIC | Lifetime: Number of times your video started automatically playing and people viewed it for 30 seconds or 97% of the video if video is less than 30 seconds. (Total Count) |
| Lifetime Clicked-to-Play 30-Second Views | NUMERIC | Lifetime: Number of times people clicked to play your video and viewed it for 30 seconds or 97% of the video if video is less than 30 seconds. (Total Count) |
| Lifetime Organic 30-Second Views | NUMERIC | Lifetime: Number of times your video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds without a paid promotion. (Total Count) |
| Lifetime Paid 30-Second Views | NUMERIC | Lifetime: Number of times your video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds after a paid promotion. (Total Count) |
| Lifetime Unique 30-Second Views | NUMERIC | Lifetime: Number of unique people who viewed your video for 30 seconds or 97% of the video if video is less than 30 seconds. (Unique Users) |
| Lifetime Total 60-Second Views for videos 60 seconds or longer | NUMERIC | Lifetime: Total number of times your video was viewed for 60 seconds only if the video is 60 seconds or longer. |
| Lifetime Average time video viewed | NUMERIC | Lifetime: Average time video viewed (Total Count) |
| Lifetime Total Video Watches at 95% | NUMERIC | Lifetime: Total number of times your video was watched at 95% of its length, including watches that skipped to this point. (Total Count) |
| Lifetime Auto-Played Video Watches at 95% | NUMERIC | Lifetime: Number of times your video started automatically playing and people watched it at 95% of its length, including watches that skipped to this point. (Total Count) |
| Lifetime Clicked-to-Play Video Watches at 95% | NUMERIC | Lifetime: Number of times people clicked to play your video and watched it at 95% of its length, including watches that skipped to this point. (Total Count) |
| Lifetime Organic Watches at 95% | NUMERIC | Lifetime: Number of times your video was watches at 95% of its length without any paid promotion, including watches that skipped to this point. (Total Count) |
| Lifetime Organic Unique Watches at 95% | NUMERIC | Lifetime: The number of unique people who watched your video at 95% of its length without any paid promotion, including people that skipped to this point. (Unique Users) |
| Lifetime Paid Watches at 95% | NUMERIC | Lifetime: Number of times your video was watched at 95% of its length after paid promotion, including watches that skipped to this point. (Total Count) |
| Lifetime Paid Unique Watches at 95% | NUMERIC | Lifetime: The number of unique people who watched your video at 95% of its length after paid promotion, including people that skipped to this point. (Unique Users) |
| Lifetime Unique Video Watches at 95% | NUMERIC | Lifetime: Total number of unique people who watched your video at 95% of its length or more, including people that skipped to this point. (Unique Users) |
| Lifetime Video Consumption Rate | NUMERIC | The ratio of unique video views to total unique impressions. |
| Lifetime Video Total Impressions | NUMERIC | Lifetime: The number of impressions of the video. (Total Count) |
| Lifetime Video Impressions by people who have liked your Page | NUMERIC | Lifetime: Number of impressions of your Page Video to people who have liked your Page. (Total Count) |
| Lifetime Video Paid Impressions by people who have liked your Page | NUMERIC | Lifetime: Number of paid impressions of your Page Video Asset to people who have liked your Page. (Total Count) |
| Lifetime Paid reach of a Video by people who like your Page | NUMERIC | Lifetime: Number of people who like your Page and who saw your Page Video in an ad or sponsored story. (Unique Users) |
| Lifetime Video reach by people who like your Page | NUMERIC | Lifetime: Number of people who saw your Page video because they've liked your Page (Unique Users) |
| Lifetime Video Organic Impressions | NUMERIC | Lifetime: The number of impressions of your Video in Feed or ticker or on your Page's Timeline. (Total Count) |
| Lifetime Video organic reach | NUMERIC | Lifetime: Number of people who saw your Page Video in Feed or ticker, or on your Page's timeline. (Unique Users) |
| Lifetime Video Paid Impressions | NUMERIC | Lifetime: Number of impressions of your Page Video in an Ad or Sponsored Story. (Total Count) |
| Lifetime Video Paid Reach | NUMERIC | Lifetime: Number of people your advertised Page Video was served to. (Unique Users) |
| Lifetime Video Total Reach | NUMERIC | Lifetime: The total number of people your video was served to. (Unique Users) |
| Lifetime Video Viral Impressions | NUMERIC | Lifetime: The number of impressions of your Page Video in a story generated by a friend. (Total Count) |
| Lifetime Video viral reach | NUMERIC | Lifetime: Number of people who saw your Page Video in a story from a friend. (Unique Users) |
| Lifetime Video Play Count | NUMERIC | Lifetime Video Play Count. |
| Lifetime Total Video View Time (in ms) | NUMERIC | Lifetime: Total time (in ms) video has been viewed. (Total Count) |
| Lifetime Total Organic Video View Time (in ms) | NUMERIC | Lifetime: Total time (in ms) video has been viewed in Feed or ticker or on your Page's Timeline. (Total Count) |
| Lifetime Total Paid Video View Time (in ms) | NUMERIC | Lifetime: Total time (in ms) video has been viewed after paid promotion. (Total Count) |
| Total Video Views | NUMERIC | Lifetime: Total number of times your video was viewed for 3 seconds or viewed to the end, whichever came first. (Total Count) |
| Lifetime Auto-Played Video Views | NUMERIC | Lifetime: Number of times your video started automatically playing and people viewed it for 3 seconds or viewed it to the end, whichever came first. (Total Count) |
| Lifetime Clicked-to-Play Video Views | NUMERIC | Lifetime: Number of times people clicked to play your video and viewed it for 3 seconds or viewed it to the end, whichever came first. (Total Count) |
| Lifetime Organic Video Views | NUMERIC | Lifetime: Number of times your video was viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. (Total Count) |
| Lifetime Unique Organic Video Views | NUMERIC | Lifetime: Number unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. (Unique Users) |
| Lifetime Paid Video Views | NUMERIC | Lifetime: Number of times your video was viewed for 3 seconds or viewed to the end, whichever came first, after paid promotion. (Total Count) |
| Lifetime Unique Paid Video Views | NUMERIC | Lifetime: Number of unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, after paid promotion. (Unique Users) |
| Lifetime Video Views with sound on | NUMERIC | Lifetime: Number of times your video sound was turned on and was viewed for 3 seconds or viewed to the end, whichever came first. (Total Count) |
| Lifetime Unique Video Views | NUMERIC | Lifetime: Number of unique people who viewed your video for 3 seconds or viewed to the end, whichever came first. (Unique Users) |
| Post type | TEXT | A string indicating the object type of this post. |
| Video Universal Video ID | TEXT | The publishers asset management code for this video. |
| Video Updated Time | TIMESTAMP | The last time the video or its caption was updated. |
| Post URL | TEXT | URL of the attachment. |
| Video Permalink URL | TEXT | The permanent static URL to the video on www.facebook.com. Example https://www.facebook.com/FacebookforDevelopers/posts/10153449196353553 |
| Video Post Id | TEXT | Video Post id |
| (Deprecated) Video Post Impressions Unique | NUMERIC | The number of people who saw your reel at least once, whether or not the person played your reel. This metric is different from impressions, which includes multiple views of your reel by the same person. This metric is estimated. |
| Video Views | NUMERIC | The number of times the video has been viewed. |
| Week | TEXT | Week (Sun-Sat). |
| Day of week and day number | TEXT | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| Day of week and day number, ISO | TEXT | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| Week ISO | TEXT | Week, ISO format (Mon-Sun). |
| Year | TEXT | Year |
| Yearmonth | TEXT | Year and month, e.g. 2024|3 |
| Year of week | TEXT | The year that contains first day of the week (Sun-Sat). |
| Year of week, ISO | TEXT | The year that contains first day of the ISO week (Mon-Sun). |
| Year week | TEXT | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| Year week ISO | TEXT | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
Easily connect Facebook Page Insights to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.