Facebook Pages
Important
For the Post table
- We retrieve the latest 500 posts from a Facebook Page daily, provided they were published within the last 2 years.
For the Video and Reels table
- We retrieve the latest 500 videos from a Facebook Page daily, provided they were published within the last 2 years. Then, we categorize these videos into "Normal Videos" (Video Table) and 'Reels' (Reel Table)
Page Table
Page ID - The unique ID of the Facebook Page.
Page Name - The name of the Facebook Page.
Date - The date for which the metrics are reported.
Followers Count - The total number of followers for the Page.
Page Follows Day - The number of new followers gained on the specified day.
Page Daily Follows Unique Day - The number of unique new followers gained on the specified day.
Page Daily Follows Unique Days 28 - The number of unique new followers gained in the last 28 days.
Page Daily Follows Unique Week - The number of unique new followers gained in the last 7 days.
Page Daily Unfollows Unique Day - The number of unique users who unfollowed the Page on the specified day.
Page Daily Unfollows Unique Days 28 - The number of unique users who unfollowed the Page in the last 28 days.
Page Daily Unfollows Unique Week - The number of unique users who unfollowed the Page in the last 7 days.
Page Impressions Day - The total number of impressions for the Page on the specified day.
Page Impressions Days 28 - The total number of impressions for the Page in the last 28 days.
Page Impressions Nonviral Day - The number of non-viral impressions for the Page on the specified day.
Page Impressions Nonviral Days 28 - The number of non-viral impressions for the Page in the last 28 days.
Page Impressions Nonviral Unique Day - The number of unique non-viral impressions for the Page on the specified day.
Page Impressions Nonviral Unique Days 28 - The number of unique non-viral impressions for the Page in the last 28 days.
Page Impressions Nonviral Unique Week - The number of unique non-viral impressions for the Page in the last 7 days.
Page Impressions Nonviral Week - The number of non-viral impressions for the Page in the last 7 days.
Page Impressions Paid Day - The number of paid impressions for the Page on the specified day.
Page Impressions Paid Days 28 - The number of paid impressions for the Page in the last 28 days.
Page Impressions Paid Unique Day - The number of unique paid impressions for the Page on the specified day.
Page Impressions Paid Unique Days 28 - The number of unique paid impressions for the Page in the last 28 days.
Page Impressions Paid Unique Week - The number of unique paid impressions for the Page in the last 7 days.
Page Impressions Paid Week - The number of paid impressions for the Page in the last 7 days.
Page Impressions Unique Day - The number of unique impressions for the Page on the specified day.
Page Impressions Unique Days 28 - The number of unique impressions for the Page in the last 28 days.
Page Impressions Unique Week - The number of unique impressions for the Page in the last 7 days.
Page Impressions Viral Day - The number of viral impressions for the Page on the specified day.
Page Impressions Viral Days 28 - The number of viral impressions for the Page in the last 28 days.
Page Impressions Viral Unique Day - The number of unique viral impressions for the Page on the specified day.
Page Impressions Viral Unique Days 28 - The number of unique viral impressions for the Page in the last 28 days.
Page Impressions Viral Unique Week - The number of unique viral impressions for the Page in the last 7 days.
Page Impressions Viral Week - The number of viral impressions for the Page in the last 7 days.
Page Impressions Week - The total number of impressions for the Page in the last 7 days.
Page Post Engagements Day - The number of engagements on Page posts on the specified day.
Page Post Engagements Days 28 - The number of engagements on Page posts in the last 28 days.
Page Post Engagements Week - The number of engagements on Page posts in the last 7 days.
Page Posts Impressions Day - The total number of impressions for Page posts on the specified day.
Page Posts Impressions Days 28 - The total number of impressions for Page posts in the last 28 days.
Page Posts Impressions Paid Day - The number of paid impressions for Page posts on the specified day.
Page Posts Impressions Paid Days 28 - The number of paid impressions for Page posts in the last 28 days.
Page Posts Impressions Paid Week - The number of paid impressions for Page posts in the last 7 days.
Page Posts Impressions Unique Day - The number of unique impressions for Page posts on the specified day.
Page Posts Impressions Unique Days 28 - The number of unique impressions for Page posts in the last 28 days.
Page Posts Impressions Unique Week - The number of unique impressions for Page posts in the last 7 days.
Page Posts Impressions Week - The total number of impressions for Page posts in the last 7 days.
Page Actions Post Reactions Anger Total Day - The total number of angry reactions on Page posts on the specified day.
Page Actions Post Reactions Anger Total Days 28 - The total number of angry reactions on Page posts in the last 28 days.
Page Actions Post Reactions Anger Total Week - The total number of angry reactions on Page posts in the last 7 days.
Page Actions Post Reactions Haha Total Day - The total number of haha reactions on Page posts on the specified day.
Page Actions Post Reactions Haha Total Days 28 - The total number of haha reactions on Page posts in the last 28 days.
Page Actions Post Reactions Haha Total Week - The total number of haha reactions on Page posts in the last 7 days.
Page Actions Post Reactions Like Total Day - The total number of like reactions on Page posts on the specified day.
Page Actions Post Reactions Like Total Days 28 - The total number of like reactions on Page posts in the last 28 days.
Page Actions Post Reactions Like Total Week - The total number of like reactions on Page posts in the last 7 days.
Page Actions Post Reactions Love Total Day - The total number of love reactions on Page posts on the specified day.
Page Actions Post Reactions Love Total Days 28 - The total number of love reactions on Page posts in the last 28 days.
Page Actions Post Reactions Love Total Week - The total number of love reactions on Page posts in the last 7 days.
Page Actions Post Reactions Sorry Total Day - The total number of sorry reactions on Page posts on the specified day.
Page Actions Post Reactions Sorry Total Days 28 - The total number of sorry reactions on Page posts in the last 28 days.
Page Actions Post Reactions Sorry Total Week - The total number of sorry reactions on Page posts in the last 7 days.
Page Actions Post Reactions Wow Total Day - The total number of wow reactions on Page posts on the specified day.
Page Actions Post Reactions Wow Total Days 28 - The total number of wow reactions on Page posts in the last 28 days.
Page Actions Post Reactions Wow Total Week - The total number of wow reactions on Page posts in the last 7 days.
Page Posts Impressions Organic Day - The number of organic impressions for Page posts on the specified day.
Page Posts Impressions Organic Days 28 - The number of organic impressions for Page posts in the last 28 days.
Page Posts Impressions Organic Unique Day - The number of unique organic impressions for Page posts on the specified day.
Page Posts Impressions Organic Unique Days 28 - The number of unique organic impressions for Page posts in the last 28 days.
Page Posts Impressions Organic Unique Week - The number of unique organic impressions for Page posts in the last 7 days.
Page Posts Impressions Organic Week - The number of organic impressions for Page posts in the last 7 days.
Page Posts Impressions Paid Unique Day - The number of unique paid impressions for Page posts on the specified day.
Page Posts Impressions Paid Unique Days 28 - The number of unique paid impressions for Page posts in the last 28 days.
Page Posts Impressions Paid Unique Week - The number of unique paid impressions for Page posts in the last 7 days.
Page Video Views Day - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. (on the specified day)
Page Video Views Days 28 - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. (in the last 28 days)
Page Video Views Week - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. (in the last 7 days)
Page Video Views Paid Day - The number of times your Page's promoted videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. (on the specified day)
Page Video Views Paid Days 28 - The number of times your Page's promoted videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. (in the last 28 days)
Page Video Views Paid Week - The number of times your Page's promoted videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. (in the last 7 days)
Page Video Views Organic Day - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. (on the specified day)
Page Video Views Organic Days 28 - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. (in the last 28 days)
Page Video Views Organic Week - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. (in the last 7 days)
Page Video Views Autoplayed Day - The number of times your Page's videos automatically played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. (on the specified day)
Page Video Views Autoplayed Days 28 - The number of times your Page's videos automatically played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. (in the last 28 days)
Page Video Views Autoplayed Week - The number of times your Page's videos automatically played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. (in the last 7 days)
Page Video Views Click to play Day - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, after people clicked play. During a single instance of a video playing, we'll exclude any time spent replaying the video. (on the specified day)
Page Video Views Click to play Days 28 - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, after people clicked play. During a single instance of a video playing, we'll exclude any time spent replaying the video. (in the last 28 days)
Page Video Views Click to play Week - The number of times your Page's videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, after people clicked play. During a single instance of a video playing, we'll exclude any time spent replaying the video. (in the last 7 days)
Page Video Complete Views 30s Autoplayed Day - The number of times videos were viewed to completion (at least 30 seconds) that were autoplayed on the specified day.
Page Video Complete Views 30s Autoplayed Days 28 - The number of times videos were viewed to completion (at least 30 seconds) that were autoplayed in the last 28 days.
Page Video Complete Views 30s Autoplayed Week - The number of times videos were viewed to completion (at least 30 seconds) that were autoplayed in the last 7 days.
Page Video Complete Views 30s Day - The number of times videos were viewed to completion (at least 30 seconds) on the specified day.
Page Video Complete Views 30s Days 28 - The number of times videos were viewed to completion (at least 30 seconds) in the last 28 days.
Page Video Complete Views 30s Organic Day - The number of times videos were viewed to completion (at least 30 seconds) organically on the specified day.
Page Video Complete Views 30s Organic Days 28 - The number of times videos were viewed to completion (at least 30 seconds) organically in the last 28 days.
Page Video Complete Views 30s Organic Week - The number of times videos were viewed to completion (at least 30 seconds) organically in the last 7 days.
Page Video Complete Views 30s Paid Day - The number of times videos were viewed to completion (at least 30 seconds) through paid reach on the specified day.
Page Video Complete Views 30s Paid Days 28 - The number of times videos were viewed to completion (at least 30 seconds) through paid reach in the last 28 days.
Page Video Complete Views 30s Paid Week - The number of times videos were viewed to completion (at least 30 seconds) through paid reach in the last 7 days.
Page Video Complete Views 30s Week - The number of times videos were viewed to completion (at least 30 seconds) in the last 7 days.
Page Video Repeat Views Day - The number of repeat video views on the specified day.
Page Video Repeat Views Days 28 - The number of repeat video views in the last 28 days.
Page Video Repeat Views Week - The number of repeat video views in the last 7 days.
Page Video Views Unique Day - The number of unique video views on the specified day.
Page Video Views Unique Days 28 - The number of unique video views in the last 28 days.
Page Video Views Unique Week - The number of unique video views in the last 7 days.
Page Video Complete Views 30s Click To Play Day - The number of times videos were viewed to completion (at least 30 seconds) that were started by clicking to play on the specified day.
Page Video Complete Views 30s Click To Play Days 28 - The number of times videos were viewed to completion (at least 30 seconds) that were started by clicking to play in the last 28 days.
Page Video Complete Views 30s Click To Play Week - The number of times videos were viewed to completion (at least 30 seconds) that were started by clicking to play in the last 7 days.
Page Video Complete Views 30s Repeat Views Day - The number of repeat views of videos to completion (at least 30 seconds) on the specified day.
Page Video Complete Views 30s Repeat Views Days 28 - The number of repeat views of videos to completion (at least 30 seconds) in the last 28 days.
Page Video Complete Views 30s Repeat Views Week - The number of repeat views of videos to completion (at least 30 seconds) in the last 7 days.
Page Video Complete Views 30s Unique Day - The number of unique video views to completion (at least 30 seconds) on the specified day.
Page Video Complete Views 30s Unique Days 28 - The number of unique video views to completion (at least 30 seconds) in the last 28 days.
Page Video Complete Views 30s Unique Week - The number of unique video views to completion (at least 30 seconds) in the last 7 days.
Page Video View Time Day - Total time spent viewing videos on the specified day.
Page Video View Time Days 28 - Total time spent viewing videos in the last 28 days.
Page Video View Time Week - Total time spent viewing videos in the last 7 days.
Post Table
Page ID - The unique ID of the Facebook Page.
Page Name - The name of the Facebook Page.
Post ID - The unique ID of the post.
Post Type - The type of the post.
Permalink URL - The permanent URL of the post.
Message - The text content of the post.
Created Time - The date and time the post was created.
Updated Time - The date and time the post was last updated.
Full Picture - The URL of the full-sized picture associated with the post.
Post Shares Lifetime - The total number of times the post has been shared.
Post Comments Lifetime - The total number of comments on the post.
Post Clicks Lifetime - The number of times people clicked on anywhere in your posts without generating a story.
Link Clicks Lifetime - The total number of link clicks on the post.
Other Clicks Lifetime - The total number of other clicks on the post.
Post Impressions Fan Lifetime - The total number of impressions on the post from fans.
Post Impressions Fan Unique Lifetime - The number of unique fans who saw the post.
Post Impressions Lifetime - The total number of impressions on the post.
Post Impressions Nonviral Lifetime - The number of non-viral impressions.
Post Impressions Nonviral Unique Lifetime - The number of unique non-viral impressions.
Post Impressions Organic Lifetime - The number of organic impressions.
Post Impressions Organic Unique Lifetime - The number of unique organic impressions.
Post Impressions Paid Lifetime - The number of paid impressions.
Post Impressions Paid Unique Lifetime - The number of unique paid impressions.
Post Impressions Unique Lifetime - The number of unique impressions on the post.
Post Impressions Viral Lifetime - The number of viral impressions.
Post Impressions Viral Unique Lifetime - The number of unique viral impressions.
Post Reactions Like Total Lifetime - The total number of "Like" reactions.
Post Reactions Love Total Lifetime - The total number of "Love" reactions.
Post Reactions Anger Total Lifetime - The total number of "Anger" reactions.
Post Reactions Haha Total Lifetime - The total number of "Haha" reactions.
Post Reactions Sorry Total Lifetime - The total number of "Sorry" reactions.
Post Reactions Wow Total Lifetime - The total number of "Wow" reactions.
Post Video Avg Time Watched Lifetime - The average time spent watching the video.
Post Video Complete Views 30s Autoplayed Lifetime - The number of times the video was autoplayed for at least 30 seconds.
Post Video Complete Views 30s Clicked To Play Lifetime - The number of times the video was clicked to play and watched for at least 30 seconds.
Post Video Complete Views 30s Organic Lifetime - The number of organic video views of at least 30 seconds.
Post Video Complete Views 30s Paid Lifetime - The number of paid video views of at least 30 seconds.
Post Video Complete Views 30s Unique Lifetime - The number of unique video views of at least 30 seconds.
Post Video Complete Views Organic Lifetime - The number of organic video views to completion.
Post Video Complete Views Organic Unique Lifetime - The number of unique organic video views to completion.
Post Video Complete Views Paid Lifetime - The number of paid video views to completion.
Post Video Complete Views Paid Unique Lifetime - The number of unique paid video views to completion.
Post Video Views Organic Lifetime - The number of organic video views.
Post Video Length - The length of the video in seconds.
Post Video Social Actions Count Unique Lifetime - The number of unique users who took a social action on the video (like, comment, share).
Post Video View Time Lifetime - The total time spent viewing the video.
Post Video View Time Organic Lifetime - The total time spent viewing the video organically.
Post Video Views 15s Lifetime - The number of video views for at least 15 seconds.
Post Video Views 60s Excludes Shorter Lifetime - The number of video views for at least 60 seconds (excludes shorter views).
Post Video Views Autoplayed Lifetime - The number of times the video was autoplayed.
Post Video Views Clicked To Play Lifetime - The number of times the video was clicked to play.
Post Video Views Lifetime - The total number of video views.
Post Video Views Live Lifetime - The number of live video views.
Post Video Views Organic Unique Lifetime - The number of unique organic video views.
Post Video Views Paid Lifetime - The number of paid video views.
Post Video Views Paid Unique Lifetime - The number of unique paid video views.
Post Video Views Sound On Lifetime - The number of video views with sound on.
Post Video Views Unique Lifetime - The number of unique video views.
Video Table
Page ID - The unique ID of the Facebook Page.
Page Name - The name of the Facebook Page.
Video ID - The unique ID of the video.
Post ID - The unique ID of the post associated with the video.
Title - The title of the video.
Description - The description of the video.
Created Time - The date and time the video was created.
Updated Time - The date and time the video was last updated.
Permalink URL - The permanent URL of the video.
Source - The source of the video.
Content Category - The category of the video content.
Is Crosspost Video - Indicates whether the video is a crosspost.
Published - Indicates whether the video is published.
Privacy - The privacy setting of the video.
Video Length - The length of the video in seconds.
Total Video Views Lifetime - The total number of video views.
Total Video 10s Views Lifetime - The total number of video views for at least 10 seconds.
Total Video 15s Views Lifetime - The total number of video views for at least 15 seconds.
Total Video 30s Views Lifetime - The total number of video views for at least 30 seconds.
Total Video Complete Views Lifetime - The total number of complete video views.
Total Video Views Organic Lifetime - The total number of organic video views.
Total Video Views Organic Unique Lifetime - The total number of unique organic video views.
Total Video Views Paid Lifetime - The total number of paid video views.
Total Video Views Paid Unique Lifetime - The total number of unique paid video views.
Total Video Complete Views Auto Played Lifetime - The total number of complete video views that were autoplayed.
Total Video Complete Views Clicked To Play Lifetime - The total number of complete video views that were clicked to play.
Total Video Complete Views Unique Lifetime - The total number of unique complete video views.
Total Video Views Autoplayed Lifetime - The total number of video views that were autoplayed.
Total Video Views Clicked To Play Lifetime - The total number of video views that were clicked to play.
Total Video Views Sound On Lifetime - The total number of video views with sound on.
Total Video Views Unique Lifetime - The total number of unique video views.
Total Video 10s Views Auto Played Lifetime - The total number of 10-second video views that were autoplayed.
Total Video 10s Views Clicked To Play Lifetime - The total number of 10-second video views that were clicked to play.
Total Video 10s Views Organic Lifetime - The total number of organic 10-second video views.
Total Video 10s Views Paid Lifetime - The total number of paid 10-second video views.
Total Video 10s Views Sound On Lifetime - The total number of 10-second video views with sound on.
Total Video 10s Views Unique Lifetime - The total number of unique 10-second video views.
Total Video 60s Excludes Shorter Views Lifetime - The total number of video views for at least 60 seconds (excluding shorter views).
Total Video Avg Time Watched Lifetime - The average time watched for the video in seconds.
Total Video Complete Views Organic Lifetime - The total number of organic complete video views.
Total Video Complete Views Organic Unique Lifetime - The total number of unique organic complete video views.
Total Video Complete Views Paid Lifetime - The total number of paid complete video views.
Total Video Complete Views Paid Unique Lifetime - The total number of unique paid complete video views.
Total Video Impressions Lifetime - The total number of video impressions.
Total Video Impressions Paid Unique Lifetime - The total number of unique paid video impressions.
Total Video Impressions Unique Lifetime - The total number of unique video impressions.
Total Video View Total Time Lifetime - The total time spent viewing the video in seconds.
Total Video View Total Time Organic Lifetime - The total organic time spent viewing the video in seconds.
Total Video View Total Time Paid Lifetime - The total paid time spent viewing the video in seconds.
Total Video Impressions Paid Lifetime - The total number of paid video impressions.
Total Video Impressions Organic Unique Lifetime - The total number of unique organic video impressions.
Total Video Impressions Organic Lifetime - The total number of organic video impressions.
Total Video Impressions Viral Unique Lifetime - The total number of unique viral video impressions.
Total Video Impressions Viral Lifetime - The total number of viral video impressions.
Total Video Impressions Fan Unique Lifetime - The total number of unique fan video impressions.
Total Video Impressions Fan Lifetime - The total number of fan video impressions.
Total Video Impressions Fan Paid Unique Lifetime - The total number of unique paid fan video impressions.
Total Video Impressions Fan Paid Lifetime - The total number of paid fan video impressions.
Total Video Stories By Action Type Share Lifetime - The total number of shares of the video story.
Total Video Stories By Action Type Like Lifetime - The total number of likes of the video story.
Total Video Stories By Action Type Comment Lifetime - The total number of comments on the video story.
Total Video Reactions Like Lifetime - The total number of "like" reactions to the video.
Total Video Reactions Love Lifetime - The total number of "love" reactions to the video.
Total Video Reactions Wow Lifetime - The total number of "wow" reactions to the video.
Total Video Reactions Haha Lifetime - The total number of "haha" reactions to the video.
Total Video Reactions Care Lifetime - The total number of "care" reactions to the video.
Total Video Reactions Sad Lifetime - The total number of "sad" reactions to the video.
Total Video Reactions Angry Lifetime - The total number of "angry" reactions to the video.
Reel Table
Page ID - The unique ID of the Facebook Page.
Page Name - The name of the Facebook Page.
Video ID - The unique ID of the video associated with the Reel.
Post ID - The unique ID of the Reel post.
Description - The description text of the Reel.
Created Time - The date and time the Reel was created.
Updated Time - The date and time the Reel was last updated.
Permalink URL - The permanent URL to the Reel.
Source - The source of the Reel (e.g., native upload, crosspost).
Content Category - The category of the Reel's content.
Is Crosspost Video - Indicates whether the Reel is a crossposted video.
Published - Indicates whether the Reel is published.
Privacy - The privacy setting of the Reel (e.g., public, friends).
Video Length - The length of the Reel video in seconds.
Blue Reels Play Count Lifetime - The total number of times the Reel has been played.
Post Impressions Unique Lifetime - The total number of unique users who have seen the Reel.
Post Video Avg Time Watched Lifetime - The average time spent watching the Reel video in seconds.
Post Video Followers Lifetime - The number of followers gained from the Reel.
Reel Video Reaction Like Lifetime - The total number of "Like" reactions on the Reel.
Reel Video Reaction Love Lifetime - The total number of "Love" reactions on the Reel.
Reel Video Reaction Wow Lifetime - The total number of "Wow" reactions on the Reel.
Reel Video Reaction Haha Lifetime - The total number of "Haha" reactions on the Reel.
Reel Video Reaction Care Lifetime - The total number of "Care" reactions on the Reel.
Reel Video Reaction Sad Lifetime - The total number of "Sad" reactions on the Reel.
Reel Video Reaction Angry Lifetime - The total number of "Angry" reactions on the Reel.
Reel Video Social Actions Share Lifetime - The total number of times the Reel has been shared.
Reel Video Social Actions Comment Lifetime - The total number of comments on the Reel.
Post Video View Time Lifetime - The total time spent viewing the Reel video in seconds.