Facebook Insights data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: POST

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
page_impressions
Display name Total impressions
Description The total number of impressions seen of any content associated with your Page
Field type metric
Data type int.number.value
page_impressions_unique
Display name Total reach
Description The number of people who have seen any content associated with your Page
Field type metric
Data type int.number.value
page_video_views
Display name Total video views
Description Total number of times page's videos have been viewed for more than 3 seconds
Field type metric
Data type int.number.value
post_caption
Display name Post caption
Field type dimension
Data type string.text.value
post_comments_on_post
Display name Comments on posts
Field type metric
Data type int.number.value
post_created_time_of_day
Display name Post creation time of day
Field type dimension
Data type string.time.hms
post_full_picture
Display name Post image URL
Field type dimension
Data type string.text.url
post_ID
Display name Post ID
Field type dimension
Data type string.text.value
post_likes_on_post
Display name Likes on posts
Field type metric
Data type int.number.value
post_link_clicks
Display name Post link clicks
Field type metric
Data type int.number.value
post_linkto
Display name Link to post
Field type dimension
Data type string.text.url
post_message
Display name Post message
Field type dimension
Data type string.text.value
post_name
Display name Post name
Field type dimension
Data type string.text.value
post_other_clicks
Display name Post other clicks
Field type metric
Data type int.number.value
post_photo_views
Display name Post photo views
Field type metric
Data type int.number.value
post_picture
Display name Post thumbnail URL
Field type dimension
Data type string.text.url
post_privacy
Display name Post privacy
Field type dimension
Data type string.text.value
post_reactions_anger
Display name Post reactions: angry
Description Total "anger" reactions of a post
Field type metric
Data type int.number.value
post_reactions_haha
Display name Post reactions: haha
Description Total "haha" reactions of a post
Field type metric
Data type int.number.value
post_reactions_like
Display name Post reactions: like
Description Total "like" reactions of a post
Field type metric
Data type int.number.value
post_reactions_love
Display name Post reactions: love
Description Total "love" reactions of a post
Field type metric
Data type int.number.value
post_reactions_pride
Display name Post reactions: pride
Field type metric
Data type int.number.value
post_reactions_sorry
Display name Post reactions: sad
Description Total "sorry" reactions of a post
Field type metric
Data type int.number.value
post_reactions_thankful
Display name Post reactions: thankful
Field type metric
Data type int.number.value
post_reactions_wow
Display name Post reactions: wow
Description Total "wow" reactions of a post
Field type metric
Data type int.number.value
post_shares_on_post
Display name Shares on posts
Field type metric
Data type int.number.value
post_type
Display name Post type
Field type dimension
Data type string.text.value
post_video_length
Display name Video length
Field type dimension
Data type float.number.value
post_video_view_time
Display name Total video view time (s)
Description The total number of seconds your video was watched, including replays and views less than 3 seconds. Returns 0 for reshared videos
Field type metric
Data type float.number.value
post_video_views_60s_excludes_shorter
Display name Total 60s video views
Description The number of times your videos played for at least 60 seconds. This metric is counted only for videos that are 60 seconds or longer
Field type metric
Data type int.number.value
profile
Display name Page name
Field type dimension
Data type string.text.value
profileid
Display name Page/app ID
Field type dimension
Data type string.text.value

Table: PAGE

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
page_fans
Display name Total likes
Description The total number of people who have liked your Page
Field type metric
Data type int.number.value
page_followers
Display name Page followers
Description Number of page followers
Field type metric
Data type int.number.value
page_impressions
Display name Total impressions
Description The total number of impressions seen of any content associated with your Page
Field type metric
Data type int.number.value
page_impressions_paid
Display name Paid impressions
Description The number of impressions of a Sponsored Story or Ad pointing to your Page
Field type metric
Data type int.number.value
page_impressions_paid_unique
Display name Paid reach
Description Number of people who saw a sponsored story or Ad about your Page
Field type metric
Data type int.number.value
page_impressions_unique
Display name Total reach
Description The number of people who have seen any content associated with your Page
Field type metric
Data type int.number.value
page_post_engagements
Display name Page post engagements
Description The number of times people have engaged with your posts through likes, comments and shares and more
Field type metric
Data type int.number.value
page_video_views
Display name Total video views
Description Total number of times page's videos have been viewed for more than 3 seconds
Field type metric
Data type int.number.value
page_video_views_autoplayed
Display name Auto-played video views
Description The number of times your videos automatically played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds
Field type metric
Data type int.number.value
page_video_views_click_to_play
Display name Clicked to play video views
Description The number of times your videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, after people clicked play
Field type metric
Data type int.number.value
page_video_views_organic
Display name Organic video views
Description Total number of times page's videos have been viewed for more than 3 seconds by organic reach
Field type metric
Data type int.number.value
page_video_views_paid
Display name Paid video views
Description Total number of times page's promoted videos have been viewed for more than 3 seconds
Field type metric
Data type int.number.value
page_video_views_unique
Display name Unique video views
Description Total number of times page's videos have been played for unique people for more than 3 seconds
Field type metric
Data type int.number.value
profile
Display name Page name
Field type dimension
Data type string.text.value
profileid
Display name Page/app ID
Field type dimension
Data type string.text.value

Table: GEO

country
Display name Country
Field type dimension
Data type string.geo.country.twolettercode
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
page_fans
Display name Total likes
Description The total number of people who have liked your Page
Field type metric
Data type int.number.value
profile
Display name Page name
Field type dimension
Data type string.text.value
profileid
Display name Page/app ID
Field type dimension
Data type string.text.value

Table: CITY

city
Display name City
Field type dimension
Data type string.geo.city
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
page_fans
Display name Total likes
Description The total number of people who have liked your Page
Field type metric
Data type int.number.value
profile
Display name Page name
Field type dimension
Data type string.text.value
profileid
Display name Page/app ID
Field type dimension
Data type string.text.value

Table: VIDEO_REELS

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
page_video_views
Display name Total video views
Description Total number of times page's videos have been viewed for more than 3 seconds
Field type metric
Data type int.number.value
profile
Display name Page name
Field type dimension
Data type string.text.value
profileid
Display name Page/app ID
Field type dimension
Data type string.text.value
reel_video_avg_time_watched
Display name Reels avg. time watched
Description The average number of milliseconds your reel was played during a single instance of playing it, including time spent replaying your reel. Because this metric includes replays, the value can be greater than the total length of the reel
Field type metric
Data type float.number.value
reel_video_likes_by_reaction_type_angry
Display name Reels reactions: angry
Description The number of reactions (angry) on your reel
Field type metric
Data type int.number.value
reel_video_likes_by_reaction_type_care
Display name Reels reactions: care
Description The number of reactions (care) on your reel
Field type metric
Data type int.number.value
reel_video_likes_by_reaction_type_haha
Display name Reels reactions: haha
Description The number of reactions (haha) on your reel
Field type metric
Data type int.number.value
reel_video_likes_by_reaction_type_like
Display name Reels reactions: like
Description The number of reactions (likes) on your reel
Field type metric
Data type int.number.value
reel_video_likes_by_reaction_type_love
Display name Reels reactions: love
Description The number of reactions (love) on your reel
Field type metric
Data type int.number.value
reel_video_likes_by_reaction_type_sad
Display name Reels reactions: sad
Description The number of reactions (sad) on your reel
Field type metric
Data type int.number.value
reel_video_likes_by_reaction_type_wow
Display name Reels reactions: wow
Description The number of reactions (wow) on your reel
Field type metric
Data type int.number.value
reel_video_social_actions_comment
Display name Reels comments
Description The number of comments on your reel
Field type metric
Data type int.number.value
reel_video_social_actions_share
Display name Reels shares
Description The number of times your reel was shared
Field type metric
Data type int.number.value
reel_video_view_time
Display name Reels total view time
Description The total number of milliseconds your reel played, including time spent replaying your reel
Field type metric
Data type float.number.value
reels_blue_reels_play_count
Display name Reels plays
Description The number of times your reel starts to play after an impression is already counted. This metric counts reels sessions with 1 millisecond or more of playback. This metric excludes replays
Field type metric
Data type int.number.value
reels_impressions_unique
Display name Reels reach
Description 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
Field type metric
Data type int.number.value
video_content_category
Display name Video content category
Field type dimension
Data type string.text.value
video_created_time_of_day
Display name Video creation time of day
Field type dimension
Data type string.time.hms
video_description
Display name Video description
Field type dimension
Data type string.text.value
video_id
Display name Video ID
Field type dimension
Data type string.text.value
video_permalink_url
Display name Video permalink URL
Field type dimension
Data type string.text.url
video_picture
Display name Video image URL
Field type dimension
Data type string.text.url
video_title
Display name Video title
Field type dimension
Data type string.text.value