Facebook Ads Setup Guide

Follow our setup guide to connect Facebook Ads to Fivetran.

---

Prerequisites

To connect Facebook Ads to Fivetran, you need:

• An active Facebook account with the following permissions for accounts you'd like to sync:
  • ads_read permission to sync Ads report information for Ad accounts that you own or Ad accounts that you have been granted access to through this permission.
  • ads_management permission to sync Ads accounts' metadata. This permission is also used to request the id and account_timezone fields of Ad accounts. The account_timezone field is required to save the correct report date in the destination.
  • business_management permission to sync Business fields. Every field that starts with the business prefix will be skipped if this permission isn't granted.
• The and you'd like to sync.

---

Setup instructions

1. In the enter the Destination schema name of your choice.

2. 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 . You must provide the and permissions while generating the system user token. Provide the permission if you want to access and sync business details.

   NOTE: The app for which you generated the system token must have the Standard or Advanced . If the app has the default No Access access level, then the system user tokens generated for these apps is not able to 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 connector setup, check your and make sure the requirements for specified access level are met.

   i. In the Access Token field, enter your System User Token.

   ii. Click Validate Access Token to validate the token permissions.

3. 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.

4. Click Add Table.
   

   i. Select the Configuration Type: Pre-built Report or Custom Report.

   ii. Enter your Table Name. It must be unique within this connector and must comply with .

   iii. Specify the report parameters.
   - If you choose Pre-built Report, select the reports you want to sync from the list of .
   - If you choose Custom Report, then add breakdowns, action breakdowns, and fields.

   iv. Select the aggregation: Day, Week, Month or Lifetime.

   v. (Optional) Set the Show Advanced Options toggle to ON.
   - Set the preferred Action Report Time to determine the report time of action stats. For more information on different options, . Default value: Impressions.
   - Pick a value for Click Attribution Window. Default value: 7 days.
   - Pick a value for View Attribution Window. Default value: 1 day.
   - Set the Use unified attribution setting toggle to ON if you want to use for your ad results.

5. Select how many months' worth of reporting data you'd like to include in your initial sync.

6. (Optional) Set the Sync all metadata toggle to OFF if you want to sync only report data without any metadata.

7. Click Save & Test. Fivetran will take it from here and sync metadata and insights from your Facebook account.

TIP: Most API requests sent by Facebook Ads connectors are sent between 3 a.m. and 7 a.m. (UTC). We recommend that you set the start time of your connector outside this high-load period. This action mitigates possible rate limit issues and optimizes sync time.

---

Related articles