Facebook Ads Setup Guide

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

1. In the connector setup form 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 System User Token. You must provide the ads_read, ads_management, and business_management permissions while generating the system user token.

   NOTE: The app for which you generated the system token must have the standard (or higher) access level. The app cannot have the default access level, development access, because system user tokens generated for these apps cannot make Ads API requests.

   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 item, and then select the Configuration Type: Pre-built Report or Custom Report.

5. Enter your Table Name. It must be unique within this connector and must comply with Fivetran’s naming conventions.

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

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

8. Select how many months of reporting data you’d like to include in your initial sync.

9. (Optional) Set the Show Advanced Options toggle to ON, and then enter values for Click Attribution Window and View Attribution Window.

10. (Optional) Set the Use unified attribution setting toggle to OFF if you don’t want to use the unified attribution settings for you ad results.

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

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

assignment Release Notes

settings API Connector Configuration

home Documentation Home