Facebook Pages

Explore the interactive ERD

Table & Field Reference

page_metrics_by_monetization_tool

Column	Type	Keys
`date`	Instant	PK
`monetization_tool`	String	PK
`page_id`	String	PKFK
`monetization_approximate_earnings`	Double

reel_metrics_total

Column	Type	Keys
`date`	Instant	PK
`reel_id`	String	PKFK
`blue_reels_play_count`	Double
`post_video_avg_time_watched`	Double
`post_video_followers`	Double
`post_video_view_time`	Double

post_metrics_by_video_interval

Column	Type	Keys
`date`	Instant	PK
`video_interval`	Int	PK
`post_id`	String	PKFK
`post_video_retention_graph`	Double
`post_video_retention_graph_autoplayed`	Double
`post_video_retention_graph_clicked_to_play`	Double

post_monetization_metrics

Column	Type	Keys
`date`	Instant	PK
`post_id`	String	PKFK
`content_monetization_earnings_currency`	String
`content_monetization_earnings_micro_amount`	Long
`monetization_approximate_earnings`	Double

page_metrics_by_country

Column	Type	Keys
`country`	String	PK
`date`	Instant	PK
`page_id`	String	PKFK
`page_follows_country`	Double

post_video_property_history

Column	Type	Keys
`index`	Int	PK
`post_id`	String	PKFK
`updated_time`	Instant	PKFK
`href`	String
`name`	String
`text`	String

post_metrics_by_followers

Column	Type	Keys
`date`	Instant	PK
`is_from_followers`	Boolean	PK
`post_id`	String	PKFK
`post_media_view`	Long

page_metrics_by_crosspost_status

Column	Type	Keys
`crosspost_status`	String	PK
`date`	Instant	PK
`page_id`	String	PKFK
`page_daily_video_ad_break_ad_impressions_by_crosspost_status`	Double
`page_daily_video_ad_break_cpm_by_crosspost_status`	Double
`page_daily_video_ad_break_earnings_by_crosspost_status`	Double

page_metrics_by_earning_source

Column	Type	Keys
`date`	Instant	PK
`earning_source`	String	PK
`page_id`	String	PKFK
`content_monetization_earnings`	Double

page_metrics_by_paid_organic

Column	Type	Keys
`date`	Instant	PK
`is_from_ads`	Boolean	PK
`page_id`	String	PKFK
`page_media_view`	Long

post_attachment_history

Column	Type	Keys
`index`	Int	PK
`post_id`	String	PKFK
`updated_time`	Instant	PKFK
`media_image_height`	Int
`media_image_src`	String
`media_image_width`	Int
`media_source`	String
`media_type`	String
`target_id`	String
`target_url`	String
`type`	String
`unshimmed_url`	String
`url`	String

post_metrics_by_paid_organic

Column	Type	Keys
`date`	Instant	PK
`is_from_ads`	Boolean	PK
`post_id`	String	PKFK
`post_media_view`	Long

post_metrics_by_action_type

Column	Type	Keys
`action_type`	String	PK
`date`	Instant	PK
`post_id`	String	PKFK
`post_activity_by_action_type`	Double
`post_activity_by_action_type_unique`	Double

page_metrics_by_city

Column	Type	Keys
`city`	String	PK
`date`	Instant	PK
`page_id`	String	PKFK
`page_follows_city`	Double

page_metrics_total

Column	Type	Keys
`date`	Instant	PK
`page_id`	String	PKFK
`page_actions_post_reactions_anger_total`	Double
`page_actions_post_reactions_haha_total`	Double
`page_actions_post_reactions_like_total`	Double
`page_actions_post_reactions_love_total`	Double
`page_actions_post_reactions_sorry_total`	Double
`page_actions_post_reactions_wow_total`	Double
`page_daily_follows`	Double
`page_daily_follows_unique`	Double
`page_daily_unfollows_unique`	Double
`page_follows`	Double
`page_media_view`	Double
`page_post_engagements`	Double
`page_total_actions`	Double
`page_video_complete_views_30_s`	Double
`page_video_complete_views_30_s_autoplayed`	Double
`page_video_complete_views_30_s_click_to_play`	Double
`page_video_complete_views_30_s_organic`	Double
`page_video_complete_views_30_s_paid`	Double
`page_video_complete_views_30_s_repeat_views`	Double
`page_video_complete_views_30_s_unique`	Double
`page_video_repeat_views`	Double
`page_video_view_time`	Double
`page_video_views`	Double
`page_video_views_autoplayed`	Double
`page_video_views_click_to_play`	Double
`page_video_views_organic`	Double
`page_video_views_paid`	Double
`page_video_views_unique`	Double
`page_views_total`	Double

post_metrics_by_locale

Column	Type	Keys
`date`	Instant	PK
`locale`	String	PK
`post_id`	String	PKFK
`post_video_view_time_by_region_id`	Double

page

Column	Type	Keys
`id`	String	PK
`app_id`	String
`birthday`	String
`can_checkin`	Boolean
`can_post`	Boolean
`category`	String
`category_list`	Json
`checkins`	Long
`description`	String
`display_subtext`	String
`emails`	Json
`fan_count`	Long
`followers_count`	Long
`global_brand_page_name`	String
`has_transitioned_to_new_page_experience`	Boolean
`hometown`	String
`is_always_open`	Boolean
`is_community_page`	Boolean
`is_eligible_for_branded_content`	Boolean
`is_messenger_bot_get_started_enabled`	Boolean
`is_messenger_platform_bot`	Boolean
`is_owned`	Boolean
`is_permanently_closed`	Boolean
`is_published`	Boolean
`is_unclaimed`	Boolean
`name`	String
`phone`	String
`place_type`	String
`price_range`	String
`promotion_eligible`	Boolean
`promotion_ineligible_reason`	String
`single_line_address`	String
`talking_about_count`	Long
`username`	String
`website`	String
`were_here_count`	Long

page_video_history

Column	Type	Keys
`id`	String	PK
`updated_time`	Instant	PK
`page_id`	String	FK
`ad_breaks`	Json
`backdated_time`	Instant
`backdated_time_granularity`	String
`content_category`	String
`content_tags`	Json
`created_time`	Instant
`custom_labels`	Json
`description`	String
`embed_html`	String
`embeddable`	Boolean
`event`	Json
`format`	Json
`from_object`	Json
`icon`	String
`is_crosspost_video`	Boolean
`is_crossposting_eligible`	Boolean
`is_episode`	Boolean
`is_instagram_eligible`	Boolean
`length`	Float
`live_status`	String
`permalink_url`	String
`picture`	Json
`place`	Json
`post_views`	Long
`premiere_living_room_status`	String
`privacy`	Json
`published`	Boolean
`scheduled_publish_time`	Instant
`source`	String
`title`	String
`universal_video_id`	String
`views`	Long

post_metrics_by_country

Column	Type	Keys
`country`	String	PK
`date`	Instant	PK
`post_id`	String	PKFK
`post_video_view_time_by_country_id`	Double

reel_metrics_by_type

Column	Type	Keys
`date`	Instant	PK
`type`	String	PK
`reel_id`	String	PKFK
`post_video_likes_by_reaction_type`	Double
`post_video_social_actions`	Double

page_metrics_by_paid_non_paid

Column	Type	Keys
`date`	Instant	PK
`paid_non_paid`	String	PK
`page_id`	String	PKFK
`page_fan_adds_by_paid_non_paid_unique`	Double
`page_video_views_by_paid_non_paid`	Double

reel_history

Column	Type	Keys
`id`	String	PK
`updated_time`	Instant	PK
`page_id`	String	FK
`ad_breaks`	Json
`backdated_time`	Instant
`backdated_time_granularity`	String
`content_category`	String
`content_tags`	Json
`created_time`	Instant
`custom_labels`	Json
`description`	String
`embed_html`	String
`embeddable`	Boolean
`event`	Json
`from_object`	Json
`icon`	String
`is_crosspost_video`	Boolean
`is_episode`	Boolean
`is_instagram_eligible`	Boolean
`length`	Float
`live_status`	String
`permalink_url`	String
`place`	Json
`premiere_living_room_status`	String
`published`	Boolean
`scheduled_publish_time`	Instant
`source`	String
`status_processing_progress`	Int
`status_value`	String
`title`	String
`universal_video_id`	String
`views`	Long

post_history

Column	Type	Keys
`id`	String	PK
`updated_time`	Instant	PK
`page_id`	String	FK
`created_time`	Instant
`full_picture`	String
`is_eligible_for_promotion`	Boolean
`is_expired`	Boolean
`is_hidden`	Boolean
`is_instagram_eligible`	Boolean
`is_published`	Boolean
`message`	String
`parent_id`	String
`promotable_id`	String
`share_count`	Long
`status_type`	String
`privacy_`

post_tagged_profile_history

Column	Type	Keys
`index`	Int	PK
`post_id`	String	PKFK
`updated_time`	Instant	PKFK
`id`	String
`length`	Int
`name`	String
`offset`	Int
`type`	String

page_video_thumbnail

Column	Type	Keys
`id`	String	PK
`video_id`	String	FK
`height`	Long
`is_preferred`	Boolean
`name`	String
`scale`	Float
`uri`	String
`width`	Long

page_monetization_metrics

Column	Type	Keys
`date`	Instant	PK
`page_id`	String	PKFK
`content_monetization_earnings_currency`	String
`content_monetization_earnings_micro_amount`	Long
`monetization_approximate_earnings`	Double

post_metrics_by_type

Column	Type	Keys
`date`	Instant	PK
`type`	String	PK
`post_id`	String	PKFK
`post_clicks_by_type`	Double
`post_reactions_by_type_total`	Double

post_metrics_by_monetization_tool

Column	Type	Keys
`date`	Instant	PK
`monetization_tool`	String	PK
`post_id`	String	PKFK
`monetization_approximate_earnings`	Double

post_metrics_total

Column	Type	Keys
`date`	Instant	PK
`post_id`	String	PKFK
`post_clicks`	Double
`post_media_view`	Double
`post_reactions_anger_total`	Double
`post_reactions_haha_total`	Double
`post_reactions_like_total`	Double
`post_reactions_love_total`	Double
`post_reactions_sorry_total`	Double
`post_reactions_wow_total`	Double
`post_video_ad_break_ad_cpm`	Double
`post_video_ad_break_ad_impressions`	Double
`post_video_ad_break_earnings`	Double
`post_video_avg_time_watched`	Double
`post_video_complete_views_30_s_autoplayed`	Double
`post_video_complete_views_30_s_clicked_to_play`	Double
`post_video_complete_views_30_s_organic`	Double
`post_video_complete_views_30_s_paid`	Double
`post_video_complete_views_30_s_unique`	Double
`post_video_complete_views_organic`	Double
`post_video_complete_views_organic_unique`	Double
`post_video_complete_views_paid`	Double
`post_video_complete_views_paid_unique`	Double
`post_video_length`	Double
`post_video_view_time`	Double
`post_video_view_time_organic`	Double
`post_video_views`	Double
`post_video_views_15_s`	Double
`post_video_views_60_s_excludes_shorter`	Double
`post_video_views_autoplayed`	Double
`post_video_views_clicked_to_play`	Double
`post_video_views_organic`	Double
`post_video_views_organic_unique`	Double
`post_video_views_paid`	Double
`post_video_views_paid_unique`	Double
`post_video_views_sound_on`	Double
`post_video_views_unique`	Double

post_metrics_by_age_gender

Column	Type	Keys
`age_gender`	String	PK
`date`	Instant	PK
`post_id`	String	PKFK
`post_video_view_time_by_age_bucket_and_gender`	Double

post_comment_history

Column	Type	Keys
`_fivetran_id`	String	PK
`post_id`	String	FK
`can_comment`	Boolean
`can_hide`	Boolean
`can_like`	Boolean
`can_remove`	Boolean
`can_reply_privately`	Boolean
`comment_count`	Long
`created_time`	Instant
`from_object`	Json
`id`	String
`like_count`	Long
`message`	String
`message_tags`	Json
`object`	Json
`parent_id`	String
`user_likes`	Boolean
`attachment_`