ETL: Facebook Ads Insights Source

​

Connection Setup

​

To create a Facebook Ads Insights connection In Integrate.io ETL

1

Click the Connections icon (lightning bolt) on the top left menu.

2

To create a connection, click New connection.

Choose Facebook Ads Insights.

3

Click Authenticate. You will be redirected to Facebook in order to grant Integrate.io ETL’s Facebook application access to your ad accounts on your behalf.

4

You may need to login to Facebook before Facebook asks you to allow Integrate.io ETL access to your Facebook ads and related stats. Click OK.

5

In the new Facebook Ads Insights connection window, Name the connection and click Create facebook ads insights connection.

​

To modify Facebook Ads Insights connections in Integrate.io ETL

1

Click the Connections icon (lightning bolt) on the top left menu.

2

Click a connection to open and modify it. Make any necessary changes, then click Reconnect, and Save changes. To exit the Facebook Ads Insights connection window without changes, click Back to connections (grey tab on the left side) on the Facebook Ads Insights connection window.

3

To delete a Facebook Ads Insights connection, click on the three vertical dots on the far right of the connection listing and select the Delete connection option.

​

Connection

​

Source Properties

• API version - Integrate.io ETL will use the selected API version when running the job. Facebook releases a new Facebook Marketing API version every few months and sunsets older versions of the API. You should check and update the API versions periodically.
  • Level - Select the report level (account by default).
  • Date range - Select a date range from the dropdown list of ranges. If you select custom date range..., you will be prompted to enter From date and To date. Click on either inputs and select the dates from the calendar. You can also use variables as values for the custom date range in the format yyyy-MM-dd.
• If custom date range option was selected, Run report day by day checkbox will be displayed. When the checkbox is checked, the report will be executed for each day in the selected date range, in order to minimize data sampling. Make sure to include `date_start` and `date_stop` dimensions if checkbox is checked
• Time breakdown - use to break the results by period. The default, All days means that one result will be returned for the entire period. Add the fields date_start and date_stop to get the period per record (in Schema, below).
• Filtering (optional) - use to filter results based on the selected fields values. Filtering field should contain an array of filter objects. Each filter object has three fields: ‘field’, ‘operator’ and ‘value’. Valid filter operators are: 'EQUAL', 'NOT_EQUAL', 'GREATER_THAN', 'GREATER_THAN_OR_EQUAL', 'LESS_THAN', 'LESS_THAN_OR_EQUAL', 'IN_RANGE', 'NOT_IN_RANGE', 'CONTAIN', 'NOT_CONTAIN', 'IN', 'NOT_IN', 'ANY', 'ALL', 'NONE' . Examples:
  • [{'field':'ad.effective_status','operator':'IN','value':['ARCHIVED']}] - will return archived ads.
    • [{field:"ad.impressions",operator:"GREATER_THAN",value:0}] - will retrieve insights only for ad objects with data (at least 1 impression).
• Action report time - determines the report time of action stats (by impression by default). See Facebook Marketing APIs documentation for more details.
• Report on… - by default, return the input for all ad accounts the connection has access to. You may also select specific accounts to report on.
• Include custom conversions fields - If checked, custom conversion fields will be fetched and shown on available fields list.

​

Source Schema

​

Related