> For the complete documentation index, see [llms.txt](https://docs.quanti.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.quanti.io/connectors/marketing-connectors/facebookorganic.md).

# Facebook Organic

<a href="https://dbdiagram.io/e/6943dbc1e4bb1dd3a98c5af8/6944301ee4bb1dd3a9961b6b" class="button primary" data-icon="table-tree">Prebuilt reports and definition</a>

***

## 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

{% stepper %}
{% step %}

#### 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
  {% endstep %}

{% step %}

#### **Connector Information**

* **Connector Name**: Define a unique name for your connector
* **Dataset ID**: Specify the BigQuery dataset ID where tables will be created
  * The dataset will be created automatically if it doesn't exist
* Click **Next**
  {% endstep %}

{% step %}

#### 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**
  {% endstep %}

{% step %}

#### Select Prebuilt reports

* Review the available Prebuilt reports (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**
  {% endstep %}

{% step %}

#### **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
  {% endstep %}
  {% endstepper %}

***

## Prebuilt reports

* **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).

***

<a href="https://dbdiagram.io/e/6943dbc1e4bb1dd3a98c5af8/6944301ee4bb1dd3a9961b6b" class="button primary" data-icon="table-tree">Prebuilt reports and definition</a>

***

## 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

<details>

<summary>Connection Issues</summary>

* 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

</details>

<details>

<summary>Missing Data</summary>

* 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

</details>

<details>

<summary>Need Help?</summary>

Contact QUANTI support at <support@quanti.io> or consult our comprehensive documentation at <https://docs.quanti.io>

</details>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.quanti.io/connectors/marketing-connectors/facebookorganic.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.