This document covers two distinct but related connectors:
Facebook Pages (page‑level insights)
Facebook Posts (post‑level insights)
Both use the same credential set and run on identical schedules, but write to separate fact tables and expose different dimensions / metrics.
Part 1 – Facebook Pages Connector
🛠 Overview
The Facebook Pages connector ingests daily page‑level insights (fans, follows, reactions, consumptions) for a list of specified Page IDs.
Granularity – one row per page per breakdown per day
Purpose – Trend analysis of audience growth and engagement drivers
Refresh cadence – Append daily (5‑day look‑back)
For more information on the Facebook Organic integration please follow this here
⚙️ Connection Setup (Shared)
Key | Description | Required | Type |
| Comma‑separated list of Page IDs to query | ✅ | Text |
| Long‑lived Facebook access token (hidden) | ✅ | Hidden |
| Label only – not used for auth | ❌ | Text |
🗓️ Job Configuration – Facebook Organic ‑ Pages
Setting | Value |
Feed |
|
Job Label | Facebook Organic ‑ Pages |
Schedule | Daily, 06:00 UTC |
Look‑back | 5 days (rolling) |
Target Table |
|
Update Mode | Append |
Date Column |
|
📚 Table Schema – facebook_data_pages
Field | Description |
| Insight date |
| Page ID |
| Breakdown dimension (e.g., |
| Fans gained on the day |
| Unfollows on the day |
| New follows |
| Likes on page posts that day |
| Page consumptions |
Additional columns returned by Facebook (e.g., reach, views) are stored when present.
🏷️ Dimensions
Dimension Name | Mapping |
Page ID [FB Org] |
|
Breakdown [FB Org] |
|
📊 Base Metrics
Metric Name | Formula | Round |
Page Fan Adds [FB Org] |
| 0 |
Page Unfollows [FB Org] |
| 0 |
Page Follows [FB Org] |
| 0 |
Page Post Likes [FB Org] |
| 0 |
Page Consumptions [FB Org] |
| 0 |
🧮 Composite Metric
Name | Formula | Round | Suffix |
Page Engagement % [FB Org] |
| 2 | % |
Part 2 – Facebook Posts Connector
🛠 Overview
The Facebook Posts connector imports daily post‑level metrics (impressions, clicks, reactions) for each post published by the specified Pages.
Granularity – one row per post per day
Purpose – Evaluate organic post reach, engagement, and reaction mix
Refresh cadence – Append daily (5‑day look‑back)
🗓️ Job Configuration – Facebook Organic ‑ Posts
Setting | Value |
Feed |
|
Job Label | Facebook Organic ‑ Posts |
Schedule | Daily, 06:00 UTC |
Look‑back | 5 days (rolling) |
Target Table |
|
Update Mode | Append |
Date Column |
|
📚 Table Schema – facebook_data_posts
Field | Description |
| Insight date |
| Unique post ID (FB permalink ID) |
| Message text |
| Story / headline |
| Total impressions |
| Unique impressions |
| Non‑viral impressions |
| Non‑viral unique impressions |
| Total post clicks |
| Unique post clicks |
| Users who engaged |
| Engaged users who are page fans |
| “Wow” reactions |
| “Haha” reactions |
| “Sad” reactions |
| “Angry” reactions |
| “Love” reactions |
| “Like” reactions |
Facebook may return additional reaction types or video‑specific metrics; the connector stores them if present.
🏷️ Dimensions
Dimension Name | Mapping |
Post Message [FB Org] |
|
Post Story [FB Org] |
|
📊 Base Metrics
Metric Name | Formula | Round |
Post Impressions [FB Org] |
| 0 |
Post Impressions Unique [FB Org] |
| 0 |
Post Impressions Non‑Viral [FB Org] |
| 0 |
Post Impressions Non‑Viral Unique [FB Org] |
| 0 |
Post Clicks [FB Org] |
| 0 |
Post Clicks Unique [FB Org] |
| 0 |
Post Engagements [FB Org] |
| 0 |
Post Engagement Fans [FB Org] |
| 0 |
Reactions “Wow” [FB Org] |
| 0 |
Reactions “Haha” [FB Org] |
| 0 |
Reactions “Sad” [FB Org] |
| 0 |
Reactions “Angry” [FB Org] |
| 0 |
Reactions “Love” [FB Org] |
| 0 |
Reactions “Like” [FB Org] |
| 0 |
🔗 Joins
These connectors do not define built‑in joins, but both tables share the Page ID (first 16 digits of post_id) enabling manual joins if page insights and post performance need to be blended.
✅ Overall Summary
• Facebook Pages: Tracks audience growth, reactions, and consumptions at the page level, refreshed daily.
• Facebook Posts: Captures reach, clicks, detailed reactions, and engagement at the post level, also refreshed daily.
Both connectors leverage a common advertiser token and Page ID list, enabling scalable organic Facebook analytics without overlapping metrics. Optional custom composite metrics (e.g., Post Engagement Rate) can be built downstream using provided columns.