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 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 instructions
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 Account's sync mode:
- If you choose Sync All Accounts, we will sync all accounts you have access to.
- If you choose Sync Specific Accounts, select the accounts you'd like to sync.
(Optional) If you want to sync a Custom report, 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: Day, Week, Month or 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's 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.
- Pick a value for Engaged-view Attribution Window. Default value: none.
- 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. Specify Custom report parameters: Breakdowns, Action Breakdowns, and Fields.NOTE: To sync
conversions
andactions
data, include theaction_type
field from the Action Breakdowns selection as well as the following fields:For conversions:
conversions
andactions
from the Fields selection.For conversion values:
conversion_values
andaction_values
from the Fields selection. To avoid discrepancies, we recommend using a union of the two resulting child tables (e.g.,<table_name>_conversions
and<table_name>_actions
).For more information on this configuration and the output of this data, see our Conversions and actions documentation.
vi. Click Save to add your Custom report.
- Set the preferred Action Report Time to determine the report time of action stats. For more information on different options, see Facebook's documentation. Default value: Impressions.
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.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration