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 |
| Post Clicks (duplicate) | NUMERIC | The number of times people clicked on anywhere in your posts without generating a story. |
| Date | DATE | The dimension that determines how date-based data in a chart is handled (the time dimension). |
| Is Eligible For Promotion | BOOLEAN | Whether the post is eligible for promotion. |
| Is Expired | BOOLEAN | Whether the post has expiration time that has passed. |
| Is Inline Created | BOOLEAN | Returns True if the post was created inline when creating ads. |
| Is Popular | BOOLEAN | Whether the post is currently popular. Based on whether the total actions as a percentage of reach exceeds a certain threshold. |
| 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) |
| Media Type | TEXT | [deprecated] A string indicating the object type of this post. |
| 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. |
| 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. |
| 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. |
| 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. |
| Page Call Phone Clicks Logged In Unique | OBJECT | Number of people who logged in to Facebook and clicked the Call Now button. |
| 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. |
| 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 (default attribution window). |
| Page CTA Clicks By Age Gender Logged In Unique (number of comments). | OBJECT | Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by age and gender group (number of comments). |
| Page CTA Clicks By Age Gender Logged In Unique (number of likes). | OBJECT | Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by age and gender group (number of likes). |
| Page CTA Clicks By Age Gender Logged In Unique (times stories have been shared). | OBJECT | Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by age and gender group (times stories have been shared). |
| 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. |
| 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. |
| 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). |
| 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 |
| 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 | TEXT | 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) |
| 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) |
| 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) |
| 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. |
| 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. |
| 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. |
| 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). |
| Page Places Checkin Mobile | NUMERIC | The number of times people checked into a place using mobile phones. |
| 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. |
| Page Places Checkin By Age Gender | NUMERIC | gender and age of people who checked in at your Place. |
| Page Places Checkins By Country | NUMERIC | top countries of people who checked into your Place. |
| Page Places Checkin By Locale | NUMERIC | top locales of people who checked into your Place. |
| Page Positive Feedback By Type | OBJECT | The number of times people took a positive action broken down by type. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| Permalink Url | TEXT | The permanent static URL to the post on www.facebook.com. Example https://www.facebook.com/FacebookforDevelopers/posts/10153449196353553 |
| Post Activity | NUMERIC | The number of action types at post level (likes, comments, shares) (default attribution window). |
| Post Activity (number of comments). | NUMERIC | The number of action types at post level (likes, comments, shares) (number of comments). |
| Post Activity (number of likes). | NUMERIC | The number of action types at post level (likes, comments, shares) (number of likes). |
| Post Activity (times stories have been shared). | NUMERIC | The number of action types at post level (likes, comments, 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 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. |
| Post Reactions By Like Total | NUMERIC | Total post reactions by type. |
| Post Reactions Haha Total | NUMERIC | Total "haha" reactions of a post. |
| Post Reactions Like Total | NUMERIC | Total "like" reactions of a post. |
| Post Reactions Love Total | NUMERIC | Total "love" reactions of a post. |
| Post Reactions Sorry Total | NUMERIC | Total "sad" reactions of a post. |
| Post Reactions Wow Total | NUMERIC | Total "wow" reactions of a post. |
| Post title | TEXT | The title of the post. |
| Post Video Avg Time watched | NUMERIC | Average time (in milliseconds) people spent watching your videos. The metric is only available for videos created after August 25, 2016. Returns 0 for video shares. |
| 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. |
| 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. |
| 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. |
| Type | TEXT | A string indicating the object type of this post. |
| URL | TEXT | URL of the attachment. |
| Today | DATE | Today's date |
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.