Facebook Ads Setup Guide link
Follow our setup guide to connect Facebook Ads to Fivetran.
Prerequisiteslink
To connect Facebook Ads to Fivetran, you need:
- An active Meta Ads Manager 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 theid
andaccount_timezone
fields of Ad accounts. Theaccount_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 thebusiness
prefix will be skipped if this permission isn't granted.
- 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.
NOTE: To ensure authorization of the correct account, we recommend that you open your browser in Incognito mode.
Select Use System User Token to authorize through System User Token. You must provide the
ads_read
andads_management
permissions while generating the system user token. Provide thebusiness_management
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 access level. 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 App review status 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 system user 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 + Custom report.
i. Enter the Report name. It must be unique within this connector and must comply with Fivetran's naming conventions.
ii. Select the Aggregation. Available values are as follows:
- Day
- Week
- Month
- Lifetime
iii. (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, see Facebook documentation. 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 the unified attribution settings for your ad results.
iv. Click Next.
v. Select breakdowns, action breakdowns, and fields.
vi. Click Save.
In the Historical Sync Time Frame drop-down, select how many months' worth of reporting data you'd like to include in your initial sync.
(Optional) Set the Sync all metadata toggle to OFF if you want to sync only report data without any metadata.
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.
NOTE: Pre-built reports are now active by default and are available in the Schema tab. See release notes for further details.
Related articleslink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration