Follow our setup guide to connect Facebook Ads Insights to Fivetran.
To connect Facebook Ads Insights to Fivetran, you need:
- An active Facebook account with permissions to access data from accounts you’d like to sync
- To decide which breakdowns and fields you’d like to sync
To authorize Fivetran to connect to your Facebook Ads Insights account, follow these instructions:
- In the connector setup form, enter your chosen destination schema name.
- Enter your chosen destination table name.
- Click Authorize.
- Authorize Facebook to log in through OAuth.
- Choose your Sync Mode: Sync All Accounts or Sync Specific Accounts.
- If you choose Sync Specific Accounts, select the accounts you’d like to sync.
- Choose the Configuration Type: Pre-built Report or Custom Report.
- If you choose Pre-built Report, select one of the available Prebuilt Reports you’d like to sync.
- If you choose Custom Report, select the breakdowns, action breakdowns, and fields that you want to sync. Then choose the aggregation: Day, Week, or Month.
- (Optional) Set the Show Advanced Options toggle to ON to select the click and view attribution windows, and the action report time value.
- Select how many months of reporting data you’d like to include in your initial sync.
- Click Save & Test. Fivetran will take it from here and sync your data from your Facebook Ad Insights account.