Facebook Pages Setup Guide
Follow our setup guide to connect Facebook Pages to Fivetran.
Prerequisites
To connect your Facebook Pages to Fivetran, you need a Facebook account with permission to access data from the pages you would like to sync. To check that your account has the required access rights, read the following Facebook reference articles:
Setup instructions
In the connection setup form, enter the Destination schema name of your choice.
Select the Authentication Method you want to use:
- Select Grant User Access to connect through OAuth. Click Authorize to grant Fivetran access to the Facebook Pages APIs using the OAuth 2.0 protocol.
We recommend logging in while in Incognito mode to ensure authorization of the correct account.
- Select Use System User Token to authenticate using a System User Token. We recommend this authentication method for organizations that don't want to ask their end-users to grant user access, such as digital marketing agencies or Powered by Fivetran users.
- Go to Meta for Business and log in with your Facebook account.
- Navigate to Settings > Users > System Users.
- Choose an existing System User or create a new one.
- Click Generate New Token.
- Select your app from the drop-down menu.
- Select the expiration time.
- Grant the following permissions while generating the system user token:
- Go back to the connection's setup form and in the Access Token field, enter your System User Token.
- Click Validate system user access token to validate the token permissions.
The app for which you generated the system token must have the Standard or Advanced access level. If the app has the default No Access level, the system user tokens generated for these apps cannot query the Ads API. Note that requirements for each access level are managed by a third party and can be changed at any time. If you see sudden access level errors after the connection setup, check your App review status and make sure the requirements for the specified access level are met.
Select your sync mode:
- Select Sync all pages to sync all pages you have access to.
- Select Sync specific pages to sync specific pages only. Under Pages, select the pages you want to sync.
Click Save & Test. Fivetran will take it from here and sync your data from your Facebook Pages.