Skip to main content
Feedback

Facebook Ads connection

Integrate Facebook Ads with Data Integration to extract, transform, and load advertising data for advanced analytics and reporting. Manage campaigns, analyze ad performance, and monitor key metrics. Data Integration provides a flexible and reliable way to automate your data workflows.

You can connect Facebook Ads to Data Integration using:

  • Your Facebook account: Sign in with your email and password.
  • Custom App: Use the Facebook Developer Console to create a custom app.

Configure security features like two-factor authentication and link Instagram Business Accounts.

Prerequisite

Ensure you have Administrator access to the Facebook Ads account.

Connecting with your Facebook account

Procedure

  1. Enter a connection name.
  2. Click Connect with Facebook.
    • A Facebook login pop-up appears. Sign in with the Facebook account you want to use in Data Integration.
  3. Once authenticated, click Save to store the connection in your Data Integration account.
note

If no pop-up appears after clicking Connect with Facebook:

  • Check for a pop-up Blocked notification near the browser address bar.
  • Select Always Allow Popups from Data Integration and retry connecting.
  1. Click Test Connection to verify the setup. If the test passes, the connection is ready for use.

Configuring custom App connection with Facebook Ads in Data Integration

Procedure

Step 1: Creating a custom App in the Facebook Developer Console

  • Navigate to Facebook Developer Console.
  • Click Apps and then select Create App.
  • Enter the required details, such as the App Name, App Email.
  • Add Use Cases.
  • Select a Business Portfolio and click Go to Dashboard.

Step 2: Generating API credentials

  • Navigate to App Settings > Basic to retrieve the App ID (Client ID) and App Secret (Client Secret).
  • These credentials will be used in Data Integration for authentication.

Step 3: Configuring App domains and IP whitelist

  • Go to App Settings under the Basic tab.
    • Add your Data Integration console URL (For example, https://console.rivery.io/) and https://rivery.io/ to the App Domains section.
    • Enter the Privacy Policy URL: https://rivery.io/privacy-policy/
    • Enter the Terms of Service URL: https://rivery.io/terms-of-use/
    • Select the Category that best fits your app.
  • In the Advanced tab, go to the Security section and include the whitelisted IPs for your specific region.

Step 4: Authorizing the App

  • Navigate to the Publish section and click Publish to publish your app.
  • Under the Review section, complete the app review, business verification and any other necessary processes with Facebook.
  • After Facebook approves and authorizes your app, you can establish a connection in Data Integration using the Custom App.

Step 5: Setting up Facebook permissions and features

  • Navigate to the App Review section and open Permissions & Features.
  • Add the following permissions for Facebook Ads:
  • Permissions:
    • ads_read- to retrieve campaign, ad set, ad, and insight data.
    • read_insights - for Page or Business-level performance metrics.
  • Features:
    • business_management - required by Facebook to read data across Business-managed ad accounts.

Step 6: Configuring the custom App in Data Integration

  1. Navigate to the Data Integration console.
  2. Select Connections and click Create New Connection.
  3. Choose Facebook Ads.
  4. Select Custom App as the Authentication method. Enter the App ID (Client ID) and App Secret (Client Secret) retrieved from the Facebook Developer Console.
  5. Click Test Connection to authenticate with Facebook Ads.
  6. Click Save to keep that account in your Data Integration account.

Step 7: Testing the connection

  • After successful authorization, test the connection to ensure it works correctly.
  • Once connected, you can start building data pipelines in Data Integration using Facebook Ads data.
important

Regularly review app permissions and refresh access tokens to ensure continuous operation.

Enforce two-factor authentication

To enhance the security of your Facebook account, enable Two-Factor Authentication (2FA).

  1. Access security settings

    • Log in to your Facebook account and go to the Security and Login section in your account settings.

  2. Enable two-factor authentication

    • Locate the Use two-factor authentication option and click Edit.

  3. Select verification method

    • Choose Use Text Message as the method for receiving your authentication code.

  4. Connect Facebook to Data Integration

    • Create a Facebook connection in Data Integration once two-factor authentication is set up.
    • During the connection setup, enter your username, password, and the Two-factor authentication code sent to your phone.
    • After the connection is established with Two-factor authentication, it is unnecessary to set it up again.

Adding a Facebook page to your Instagram business account

You can connect a Facebook page to enhance your Instagram Business Account capabilities. This connection enables you to use additional business tools, including managing ads through Facebook.

To learn more, use this link.

Prerequisites

  • Convert your Instagram account to a professional account.
  • Admin of the Facebook page you want to connect.

Procedure

  1. Access profile settings

    • Navigate to your Instagram profile and select Edit Profile.

  2. Connect a page

    • Under Public Business Information, select Page.
    • Choose an existing Facebook page from your account or create a new one.

Troubleshooting issues

If you encounter the following error:
Facebook Error: (#100) Pages Public Content Access, or if no data is returned from reports such as promoted pages, ads leads, or ad creative:

1. Verify connection settings

  • Open your Facebook connection in an incognito browser session.
  • If you cannot access the connection settings, clear cookies related to Facebook and try again.

2. Adjust permissions

  • Ensure the Manage Pages permission is enabled for all pages listed.
  • Select all pages displayed in the list:
    Manage pages

3. Grant metadata permissions

  • Enable all permissions relevant to metadata extraction.
  • Turn Manage Your Pages to Yes. This lets Data Integration to read page posts and fields, but does not provide write access.

Assigning a role to a Facebook page

The account connected to Facebook in Data Integration must have the appropriate role on the page you want to access. Ensure your Facebook account has the permission to read data from the target page.

Assign Role

On this Page