The Facebook connector

You can use this connector for source endpoints.

Source endpoint configuration

  1. Specify the Start date from which you want to replicate the data for all incremental streams.

    Note that you need to provide the date and time in the ISO 8601 format: YYYY-MM-DDT00:00:00Z.

  2. Provide your Account ID.

    Note that an Account ID is a 15-digit number. To find your Account ID:

    1. Go to Ads Manger and click Account Overview in the activity bar on the left.
    2. Find the name of your business account in the frame on the right. The Account ID number will be directly under the name.
  3. Define the End date from which you want to replicate the data for all incremental streams in the YYYY-MM-DDT00:00:00Z format.

    Note

    If you don't specify the End date, the service will always sync the latest data.

  4. Provide the Access token.

    As an option, you can use the Airbyte solution to get the token.

  5. Check the Include deleted box if you want to include the data from your deleted campaigns, ads, and AdSets.

  6. Check the Fetch Thumbnail Images box to fetch thumbnail URLs for each Ad Creative and store them in the thumbnail_data_url table.

To add Custom Insights:

  1. Click Custom InsightsAdd Custom Insights.

  2. Name the insight value you want to replicate.

  3. Select the Field, Breakdown and Action breakdown from the respective drop-down lists.

    For more information on selectable fields, see Meta Marketing API Reference .

Supported tables

The DoubleCloud endpoint supports replication of the following tables from Facebook:

For more information, see Facebook Insights API documentation .

For an example of this endpoint usage in a real scenario, see Marketing analytics end-to-end scenario.