Social
Meta Page Insights schema
SightShark syncs Meta Page Insights into a data warehouse you own. It creates 26 tables holding 320 fields, refreshed daily. Facebook Page organic data: the page, its posts, videos and reels, comments and attachments, plus page and post metrics including the full video retention curve.
26 tables / 320 fields / Tables from the production sync
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
reports_page_metrics_total
31 fields
- page_id
- date
- page_daily_follows
- page_daily_follows_unique
- page_daily_unfollows_unique
- page_follows
- page_media_view
- page_post_engagements
- page_total_actions
- page_views_total
- page_actions_post_reactions_anger_total
- page_actions_post_reactions_haha_total
- page_actions_post_reactions_like_total
- page_actions_post_reactions_love_total
- page_actions_post_reactions_sorry_total
- page_actions_post_reactions_wow_total
- page_video_views
- page_video_views_paid
- page_video_views_organic
- page_video_views_autoplayed
- page_video_views_click_to_play
- page_video_views_unique
- page_video_repeat_views
- page_video_complete_views_30_s
- page_video_complete_views_30_s_autoplayed
- page_video_complete_views_30_s_click_to_play
- page_video_complete_views_30_s_organic
- page_video_complete_views_30_s_paid
- page_video_complete_views_30_s_repeat_views
- page_video_complete_views_30_s_unique
- page_video_view_time
snapshots_post_history
19 fields
- id
- updated_time
- page_id
- message
- created_time
- status_type
- story
- full_picture
- parent_id
- promotable_id
- is_published
- is_hidden
- is_expired
- is_instagram_eligible
- is_eligible_for_promotion
- comment_count
- share_count
- privacy
- snapshot_time
reports_post_metrics_by_video_interval
6 fields
- post_id
- date
- video_interval
- post_video_retention_graph
- post_video_retention_graph_autoplayed
- post_video_retention_graph_clicked_to_play
snapshots_page
37 fields
- id
- name
- username
- fan_count
- followers_count
- talking_about_count
- were_here_count
- checkins
- category
- category_list
- description
- emails
- phone
- website
- single_line_address
- hometown
- place_type
- price_range
- is_published
- is_owned
- is_community_page
- is_always_open
- is_permanently_closed
- is_unclaimed
- is_eligible_for_branded_content
- is_messenger_bot_get_started_enabled
- is_messenger_platform_bot
- has_transitioned_to_new_page_experience
- promotion_eligible
- promotion_ineligible_reason
- can_post
- can_checkin
- app_id
- birthday
- display_subtext
- global_brand_page_name
- snapshot_time
snapshots_page_video_history
36 fields
- id
- updated_time
- page_id
- title
- description
- created_time
- published
- length
- views
- permalink_url
- is_crosspost_video
- is_crossposting_eligible
- is_instagram_eligible
- is_episode
- live_status
- source
- format
- picture
- place
- privacy
- embeddable
- embed_html
- from_object
- icon
- event
- content_category
- content_tags
- custom_labels
- ad_breaks
- backdated_time
- backdated_time_granularity
- premiere_living_room_status
- scheduled_publish_time
- universal_video_id
- post_views
- snapshot_time
snapshots_post_attachment_history
14 fields
- index
- post_id
- updated_time
- media_image_height
- media_image_src
- media_image_width
- media_source
- media_type
- target_id
- target_url
- type
- unshimmed_url
- url
- snapshot_time
snapshots_post_tagged_profile_history
9 fields
- index
- post_id
- updated_time
- id
- name
- length
- offset
- type
- snapshot_time
snapshots_post_video_property_history
7 fields
- index
- post_id
- updated_time
- href
- name
- text
- snapshot_time
snapshots_post_comment_history
18 fields
- _fivetran_id
- post_id
- id
- created_time
- message
- like_count
- comment_count
- can_comment
- can_hide
- can_like
- can_remove
- can_reply_privately
- from_object
- message_tags
- object
- parent_id
- user_likes
- snapshot_time
snapshots_reel_history
33 fields
- id
- updated_time
- page_id
- title
- description
- created_time
- published
- length
- views
- permalink_url
- is_crosspost_video
- is_instagram_eligible
- is_episode
- live_status
- source
- place
- embeddable
- embed_html
- from_object
- icon
- event
- content_category
- content_tags
- custom_labels
- ad_breaks
- backdated_time
- backdated_time_granularity
- premiere_living_room_status
- scheduled_publish_time
- universal_video_id
- status_value
- status_processing_progress
- snapshot_time
snapshots_page_video_thumbnail
9 fields
- id
- video_id
- height
- width
- uri
- name
- scale
- is_preferred
- snapshot_time
reports_page_metrics_by_city
4 fields
- page_id
- date
- city
- page_follows_city
reports_page_metrics_by_country
4 fields
- page_id
- date
- country
- page_follows_country
reports_page_metrics_by_crosspost_status
6 fields
- page_id
- date
- crosspost_status
- page_daily_video_ad_break_ad_impressions_by_crosspost_status
- page_daily_video_ad_break_cpm_by_crosspost_status
- page_daily_video_ad_break_earnings_by_crosspost_status
reports_page_metrics_by_paid_non_paid
5 fields
- page_id
- date
- paid_non_paid
- page_fan_adds_by_paid_non_paid_unique
- page_video_views_by_paid_non_paid
reports_page_metrics_by_paid_organic
4 fields
- page_id
- date
- is_from_ads
- page_media_view
reports_post_metrics_total
37 fields
- post_id
- date
- post_clicks
- post_media_view
- post_reactions_anger_total
- post_reactions_haha_total
- post_reactions_like_total
- post_reactions_love_total
- post_reactions_sorry_total
- post_reactions_wow_total
- post_video_ad_break_ad_cpm
- post_video_ad_break_ad_impressions
- post_video_ad_break_earnings
- post_video_avg_time_watched
- post_video_complete_views_30_s_autoplayed
- post_video_complete_views_30_s_clicked_to_play
- post_video_complete_views_30_s_organic
- post_video_complete_views_30_s_paid
- post_video_complete_views_30_s_unique
- post_video_complete_views_organic
- post_video_complete_views_organic_unique
- post_video_complete_views_paid
- post_video_complete_views_paid_unique
- post_video_length
- post_video_view_time
- post_video_view_time_organic
- post_video_views
- post_video_views_15_s
- post_video_views_60_s_excludes_shorter
- post_video_views_autoplayed
- post_video_views_clicked_to_play
- post_video_views_organic
- post_video_views_organic_unique
- post_video_views_paid
- post_video_views_paid_unique
- post_video_views_sound_on
- post_video_views_unique
reports_post_metrics_by_action_type
5 fields
- post_id
- date
- action_type
- post_activity_by_action_type
- post_activity_by_action_type_unique
reports_post_metrics_by_age_gender
4 fields
- post_id
- date
- age_gender
- post_video_view_time_by_age_bucket_and_gender
reports_post_metrics_by_country
4 fields
- post_id
- date
- country
- post_video_view_time_by_country_id
reports_post_metrics_by_followers
4 fields
- post_id
- date
- is_from_followers
- post_media_view
reports_post_metrics_by_locale
4 fields
- post_id
- date
- locale
- post_video_view_time_by_region_id
reports_post_metrics_by_paid_organic
4 fields
- post_id
- date
- is_from_ads
- post_media_view
reports_post_metrics_by_type
5 fields
- post_id
- date
- type
- post_clicks_by_type
- post_reactions_by_type_total
reports_reel_metrics_total
6 fields
- reel_id
- date
- blue_reels_play_count
- post_video_avg_time_watched
- post_video_followers
- post_video_view_time
reports_reel_metrics_by_type
5 fields
- reel_id
- date
- type
- post_video_likes_by_reaction_type
- post_video_social_actions
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Organic numbers live behind a different login from paid, so the two halves of the same channel are usually reported separately and never add up.
Questions people ask
What tables does SightShark create from Meta Page Insights?
26 tables, including reports_page_metrics_total, snapshots_post_history, reports_post_metrics_by_video_interval. reports_page_metrics_total is one row per page, per day. Every one is listed on this page, with its fields.
Which Meta Page Insights fields can I get?
All 320 listed fields are on this page, table by table, named as they appear in your warehouse.
How often does Meta Page Insights data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Meta Page Insights data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Meta Page Insights and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 7 min read
What happens when a platform changes its API.
A pipeline that stops gets fixed today. A pipeline that keeps returning rows can be wrong for a month.
Read it - 6 min read
How to write metric definitions that hold across clients.
Most arguments about a number are arguments about what the number means. Write it down once.
Read it - 7 min read
How far back a new client's marketing data goes.
Further than you expect in places, and gone for good in others. Worth knowing before the day you need it.
Read it
Get started
Want Meta Page Insights in your own warehouse?
A call with someone who can answer the schema questions.