Follow our setup guide to connect Facebook Ads to Fivetran.
Prerequisiteslink
To connect Facebook Ads to Fivetran, you need:
- An active Facebook account with permission to access data from accounts you’d like to sync.
- The breakdowns and fields you’d like to sync.
Setup instructionslink
-
In the connector setup form enter the Destination schema name of your choice.
-
Select the Authentication Method you want to use:
-
Select Grant User Access to authorize through OAuth. Click Authorize, to authorize Facebook to log in through OAuth.
-
Select Use System User Token to authorize through System User Token. You must provide the
ads_read,ads_management, andbusiness_managementpermissions while generating the system user token.
i. In the Access Token field, enter your System User Token.
ii. Click Validate Access Token to validate the token permissions.
-
-
Select your Sync Mode: Sync All Accounts or Sync Specific Accounts. If you choose Sync Specific Accounts, select the accounts you’d like to sync.
-
Click Add item, and then select the Configuration Type: Pre-built Report or Custom Report.
-
Enter your Table Name. It must be unique within this connector and must comply with Fivetran’s naming conventions.
-
Specify the report parameters.
- If you choose Pre-built Report, select the reports you want to sync from the list of supported reports.
- If you choose Custom Report, then add breakdowns, action breakdowns, and fields.
-
Select the aggregation: Day, Week, or Month.
-
Select how many months of reporting data you’d like to include in your initial sync.
-
(Optional) Set the Show Advanced Options toggle to ON, and then enter values for Click Attribution Window and View Attribution Window.
-
Click Save & Test. Fivetran will take it from here and sync metadata and insights from your Facebook account.
Related Contentlink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration