Facebook Page data reference
Lucen syncs your Facebook Page data (Social) to your warehouse and models it into the tables below. You connect Facebook Page with one OAuth sign-in. By default your data refreshes every day at 07:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.
Meta does not guarantee that older days exist for a Page, and days it does not return stay empty. Your plan sets how much history the first sync loads, see pricing.
Send Facebook Page data to
Tables
gold_facebook_page_day
- Grain
- account_id / date
- Use for
- Daily views, organic views, reach, Page views, post engagements, and the follower stock
gold_facebook_page_post
- Grain
- account_id / post_id
- Use for
- Current posts plus lifetime counters as of the latest snapshot
gold_facebook_page_reel
- Grain
- account_id / video_id
- Use for
- Current reels plus lifetime plays, likes, comments and shares
Columns
Column names match your warehouse exactly. Descriptions come from dbt.
gold_facebook_page_day columns
gold_facebook_page_post columns
27
gold_facebook_page_reel columns
19
Typical questions
How many Page views and engagements did we get last week?
gold_facebook_page_daysum views and post_engagements; do not sum reach or followers
How many followers does the Page have?
gold_facebook_page_daylatest followers, not a sum
What did we publish, and how many lifetime views does each post have?
gold_facebook_page_postlatest snapshot; NULL counters mean no insights row
How many plays did our reels get?
gold_facebook_page_reelcumulative_play_count, not a post view
Starter queries
SELECT date, account_id, views, organic_views, reach
FROM `your-project.your_org_gold.gold_facebook_page_day`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;SELECT published_date, account_id, post_id, content_type, text
FROM `your-project.your_org_gold.gold_facebook_page_post`
WHERE published_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY published_date DESC
LIMIT 100;SELECT published_date, account_id, video_id, content_type, text
FROM `your-project.your_org_gold.gold_facebook_page_reel`
WHERE published_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY published_date DESC
LIMIT 100;