Facebook’s Organic APIs allow access to non-paid (organic) page and post data, enabling reporting, monitoring, community-management insights, and performance measurement across Facebook Pages.
The two connectors, which provide distinct types of profile-level and content-level data.
Facebook Pages (page‑level insights)
Facebook Posts (post‑level insights)
These connectors do not include advertising metrics (impressions, cost, clicks), which are only available via the Meta Ads API.
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 API provides page-level insights, metadata, and engagement metrics for managed Facebook Pages. It is used to retrieve information about the Page’s profile, audience, followers, and aggregated performance.
This connector focuses on page analytics, not individual post content.
Data handled by the integration:
Page Profile & Metadata
Page ID
Name, category, description
Verification status
Profile picture & cover photo URLs
Location (if set)
Connected Instagram account (where applicable)
Fan & Audience Insights
Total page followers
New followers / unfollows
Net follower change
Demographic breakdown (age, gender, location) — where permissions allow
Audience distribution
Page-Level Engagement Metrics
Total page views
Page reach
Page impressions
Page likes
Actions on page (button clicks, website clicks, call-to-action events)
Story mentions (high-level)
Message & Community Signals (Limited)
Messaging-enabled status
Responsiveness rating
Community interactions (when supported by permissions)
Granularity
Page level aggregation that is broken down by daily metrics and audience.
Purpose
Monitor overall Page health and audience growth
Analyse reach and engagement trends over time
Track community performance and responsiveness
Support organic social reporting dashboards
Provide profile-level metadata for social media tools
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 API provides content-level data for all posts published by a Page - including performance insights such as reach, reactions, comments, and shares.
This connector is designed for organic content performance reporting, content audits, and social publishing analytics.
Data handled by the integration:
Post Metadata
Post ID
Type (link, photo, video, text, carousel)
Created time & published status
Message (caption text)
Media URLs (image/video)
Permalink
Crossposted or syndicated flags
Post-Level Engagement Metrics
Reactions (total + by type: like, love, wow, etc.)
Comments count
Shares count
Saves (where available)
Clicks (link clicks, post clicks, video clicks when supported)
Reach & Impression Metrics
Total impressions
Organic reach
Viral reach
Paid reach (if page runs boosted posts, but attribution varies)
Unique users reached
Video Metrics (for video posts)
Video views (3-second, 10-second, 1-minute)
View-through rate
Average watch time
Sound-on vs sound-off metrics
Story-Level Insights (if applicable)
Story impressions
Story replies
Story exits
Granularity
This integration retrieves data at; Post level, Daily insights, Media Type granularity and reaction type
Purpose
Provide detailed organic content performance reporting
Identify best-performing posts
Track engagement and reach trends
Support social media content strategy analysis
Audit publishing activity
Refresh cadence
Append daily (5‑day look‑back)
For more information on the Facebook Organic integration please follow this here
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.