Edit

Facebook Organic

Follow our setup guide to connect Facebook Organic to QUANTI:

Pre-built tables and definition

Prerequisites

Before connecting Facebook Organic to QUANTI, ensure you have:

  • Facebook Page Access: Administrator or Editor access to the Facebook Page(s) you want to connect

  • Facebook Business Account: A Facebook Business account linked to your Page(s)

  • Active Facebook Page: Your Page must have published content to retrieve insights

Setup Instructions

1

Authorize Facebook Connection

  • Click on Connect to Facebook

  • You will be redirected to Facebook's authorization page

  • Log in with your Facebook account credentials

  • Review and accept the requested permissions:

  • Click Continue to grant access

2

Select Facebook Page(s)

  • After authorization, you'll see a list of your Facebook Pages

  • Select the Page(s) you want to connect to QUANTI

  • You can select multiple Pages to track organic content from different sources

  • Click Next

3

Select Pre-built Tables

  • Review the available pre-built tables (see section below for details)

  • All tables are selected by default - you can deselect tables you don't need

  • Recommended: Keep all tables enabled for complete organic performance tracking

  • Click Next

4

Finish setup

  • Define a sync period and a lookback window - Click save

  • For the first sync, you have the following options:

    • Activate auto-sync for recurring syncs based on your sync settings by clicking the switch button

    • Launch a historical data recovery by choosing your desired dates in the historical data tab

    • Launch a manual sync immediately by clicking the Sync now button

  • Wait for the sync to complete. Then navigate to your data warehouse to verify that tables are populated

  • Check the connector dashboard for sync status and any potential errors

Pre-built Tables

  • Lifetime_page_info : Basic information about Facebook Pages including page ID, name, category, and follower metrics.

  • Page_posts : Posts published on Facebook Pages with message content, creation time, and permalink.

  • Daily_page_insights : Daily aggregated insights metrics for Facebook Pages including impressions, reach, and engagement.

  • Daily_post_insights : Lifetime engagement metrics for individual posts including reach, clicks, reactions, and activity breakdown.

  • Daily_page_views : Daily page views metrics tracking total visits to the Facebook Page.

  • Lifetime_video_insights : Lifetime performance metrics for video posts including plays, watch time, replays, reactions, and social actions (cumulative data, not daily).

Pre-built tables and definition

Notes

  • Data Refresh: Facebook Organic data is typically updated once per day

  • Historical Limitations: Facebook's API has limitations on historical data retrieval. Some metrics may only be available for the last 90 days

  • Lifetime vs Daily Metrics: Note that video insights and post insights are lifetime/cumulative metrics, while page insights are aggregated daily

  • JSON Fields: Some fields (reactions, activities) are stored as JSON strings for flexible analysis

  • API Rate Limits: Facebook enforces rate limits on API requests. QUANTI automatically manages these limits to ensure reliable data extraction

  • Video Detection: Only posts identified as video content will appear in the lifetime_video_insights table

Troubleshooting

Connection Issues

  • Verify that your Facebook Business account has proper permissions

  • Ensure your Page is not restricted or deactivated

  • Check that API permissions haven't been revoked

Missing Data

  • Some metrics may not be available for all post types

  • Historical data older than 90 days may be limited

  • Private or unpublished posts won't be included

Need Help?

Contact QUANTI support at [email protected] or consult our comprehensive documentation at https://docs.quanti.io

PreviousEmailNextGoogle Ads

Last updated

Was this helpful?