Lucen

Facebook Page data reference

Social
3 tables
59 columns

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

IDNameTypeDescription
client_idClient idSTRINGOrg slug the row belongs to.
account_idAccount idSTRINGFacebook Page id. Filter a brand to the Page ids on its connections.
dateDateDATECalendar date of the activity.
connection_aliasConnection aliasSTRINGPortal connection alias that loaded the row.
viewsViewsFLOAT64Page content views that day. Additive across days. NULL means unknown, not zero.
organic_viewsOrganic viewsFLOAT64Organic Page content views that day. Additive across days. NULL means unknown. Do not estimate organic as total views minus paid.
reachReachFLOAT64Unique viewers that day. A chart value: do not sum reach across days.
page_viewsPage viewsFLOAT64Page profile views that day. Additive across days. NULL means unknown, not zero.
post_engagementsPost engagementsFLOAT64Post engagements that day. Additive across days. NULL means unknown, not zero. This is not the sum of lifetime post counters.
followersFollowersFLOAT64Last non-null Page follow stock on or before this date. A stock: do not sum followers across days. Take the latest value in a period.
followers_as_of_dateFollowers as of dateDATEDate of the Page insights row the followers value was taken from. Earlier than date when that day had no page_follows.
data_updated_atData updated atTIMESTAMPFetch time of the day's insights row.
paid_viewsPaid viewsFLOAT64Native page_media_view breakdown is_from_ads=1. Independent of total views; NULL means unavailable.

gold_facebook_page_post columns

27

gold_facebook_page_reel columns

19

Typical questions

Prompt to try
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

Prompt to try
How many followers does the Page have?

gold_facebook_page_daylatest followers, not a sum

Prompt to try
What did we publish, and how many lifetime views does each post have?

gold_facebook_page_postlatest snapshot; NULL counters mean no insights row

Prompt to try
How many plays did our reels get?

gold_facebook_page_reelcumulative_play_count, not a post view

Starter queries

sql
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;
sql
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;
sql
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;

Integration page