Guides
Start typing to search…

Facebook Ads

Prerequisites

  • An active Meta Ads Manager account with the following permissions for any accounts you want to sync:
    • ads\_read to sync Ads report information for any Ad accounts you own or have been granted access to through this permission.
    • ads\_management to sync Ads account metadata. This permission also requests 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 is mandatory to ensure a successful setup. Without this permission, setup tests will fail..

Setup Instructions

RECOMMENDED: User Access
  1. Select Grant User Access to authorize through OAuth.
  2. Click Authorize to allow Fivetran to access your Facebook Ads account using OAuth.
  • We recommend this authentication method for most users because it bases the API rate limit on the Fivetran application rather than an individual user’s advertising account. The Fivetran application has a higher rate limit than a system user token.
  1. Select the appropriate Sync Mode. If you select Sync Specific Accounts, choose the specific accounts you want to sync.
  2. Click Save & Test. Fivetran will then sync metadata and insights from your Facebook account.
NOT RECOMMENDED: System User Token
  1. Select Use System User Token to authorize through a system user token.
  • We recommend this authentication method only for organizations that do not want to ask their end-users to grant user access (for example, marketing agencies). This method is significantly more difficult and time-consuming than the User Access method and, because of required authorizations, may drastically increase the amount of time it takes to begin using Prescient.
  • For details on creating a system user, see Facebook’s resource here.
  • You must grant the ads_read, ads_management, and business_management permissions when generating the system user token.
  1. In the Access Token field, enter your system user token.
  2. Click Validate system user access token to verify the token permissions.
  3. Select the appropriate Sync Mode. If you select Sync Specific Accounts, choose the specific accounts you want to sync.
  4. Click Save & Test. Fivetran will then sync metadata and insights from your Facebook account.

Additional Details

How Will Meta’s Health & Wellness Tracking Changes Impact My MMM?

With Meta’s upcoming changes to data and conversion event tracking for health and wellness brands, it is more crucial than ever to leverage non-pixel-based solutions for measurement and optimization—namely MMMs, incrementality testing, and first-party data.

Read our full blog post on the topic here.

System User Token Details

Fivetran’s Facebook connector offers two possible methods for granting access: User Access and System User Token.

In some cases, Prescient users who belong to a Business Manager (BM) account will attempt to grant User Access. This only works if your personal Facebook account has access to the specific entity whose data you want to sync. If your personal account does not have access (but their BM account does), you will see an error when trying to connect.

This error indicates that your personal Facebook account doesn’t have the access level needed to request the data. It does not imply that there is an issue with the BM account. The Fivetran connector simply checks what a user has access to, not what your BM account has access to.

There are two ways to proceed if you encounter this error:

  1. Grant user access to the ads entity you are trying to sync. This involves granting entity access to a personal Facebook account and then authorizing via the User Access flow.
  2. Use the system user token flow, a more involved process that requires creating a Facebook app that Fivetran will use to access your data. Please note the following caveats:
    1. You may need Advanced app approval from Facebook, which allows you to create multiple system users (e.g., one specifically for Prescient).
    2. If you don’t have Advanced app approval, you may have either a Standard app or a Draft app:
      1. Standard apps allow only one system user token to be created. If you haven’t yet created a system user or don’t mind regenerating a token, you can create a system user and use that token to connect with Prescient.
      2. Draft apps cannot have the necessary permissions. You must publish the app to allow Fivetran to access the required data.
  3. If you have a Standard app and already have a system user, you can still generate a new token. However, any old tokens will remain valid and retain the same permissions unless explicitly revoked. Generating a new token with fewer permissions may break anything still using the old token.
📘

Tip

We strongly recommend avoiding the system user authorization flow. The strict approval process and access management requirements often increase the time it takes to start syncing data to Prescient. It is generally simpler to grant user access to an ad entity and authorize using the User Access flow.

If you do opt for the system user authorization process, please review Facebook's System User documentation carefully.

Updated 8 months ago