Facebook AdInsights
This page describes how to configure a Facebook AdInsights data source. With Data Loader, you can replicate and load your source data into your target destination.
:::info{title='Note'}
- Any existing Facebook OAuth connections must be deleted within the Manage Connections dialog, and recreated.
- Once recreated, all existing Facebook AdAccounts, AdInsights, and Content Insights pipelines that use the OAuth connection should run successfully.
- If you encounter issues with Facebook API rate limits, please recreate the pipeline with fewer views/tables specified per pipeline and schedule them to run at wider intervals so that the rate limit can recover between runs.
- One pipeline will be created per target—this is passed as variable
key_value. :::
Schema Drift Support: Yes. Read Schema Drift to learn more.
Return to any page of this wizard by clicking Previous.
Click X in the upper-right of the UI and then click Yes, discard to close the pipeline creation wizard.
Prerequisites
- Read the Allowed IP addresses topic before you begin. You may not be able to connect to certain data sources without first allowing the Batch IP addresses. In these circumstances, connection tests will always fail and you will not be able to complete the pipeline.
Create pipeline
- In Data Loader, click Add pipeline.
- Choose Facebook AdInsights from the grid of data sources.
- Choose Batch Loading.
Connect to Facebook AdInsights
Configure the Facebook AdInsights database connection settings, specifying the following:
| Property | Description |
|---|---|
| Facebook Ads Connection | Select a connection from the drop-down menu, or click Add Connection if one doesn't exist. |
| Connection Name | Give a unique name for the connection, and click Connect. A new browser tab will open, where Facebook will ask you to confirm authorization using valid credentials. |
| Account Value | A valid account name in the format act_<account-name>. |
| Advanced settings | Additional JDBC parameters or connection settings. Expand the Advanced settings, and choose a parameter from the drop-down menu. Enter a value for the parameter, and click Add parameter for any extra parameters you want to add. For a list of compatible connection properties, read Allowed connection properties. |
Click Test and Continue to test your settings and move forward. You can't continue if the test fails for any reason.
Choose tables
Choose any tables you wish to include in the pipeline. Use the arrow buttons to move tables to the Tables to extract and load listbox and then reorder any tables with click-and-drag. Additionally, select multiple tables using the SHIFT key.
Click Continue with X tables to move forward.
Review your data set
Choose the columns from each table to include in the pipeline. By default, Data Loader selects all columns from a table.
Click Configure on a table to open Select columns. Use the arrow buttons to move columns out of the Columns to extract and load listbox. Order columns with click-and-drag. Select multiple columns using SHIFT.
Click Done to continue.
Click Continue once you have configured each table.
Filter out search results
| Property | Description |
|---|---|
| Sleep Time | A period in seconds to sleep between API calls. Used to manage rate limiting. The default is 60 seconds. |
| Time Increment | The number of days of data aggregation. Accepts an integer between 1-90, or monthly or all_days. This value splits the range or preset date into smaller increments. This value should be less than, or equal to, the Data Preset. |
| Date Preset | A date range will automatically be calculated based on the specified preset value. Please ensure this value is greater than or equal to the Time Increment specified. |
| Action Collection | Select the actions collection to retrieve. The default is 'Actions'. |
| Action Attribution Window | The attribution window for the actions. For example 28d_click means the API will return all actions that happened 28 days after someone clicked on the ad. The default settings are 1d_view, 28d_click. |
| Level | The level to represent the results at. The default setting is account. Other options include ad, adset, and campaign. |
| Data breakdowns | Checkboxes for dataset breakdown options. Not all data breakdowns are available with each configuration. Multiple selection is accepted. |
Choose destination
- Choose an existing destination or click Add a new destination.
- Select a destination from Snowflake, Amazon Redshift, or Google BigQuery.
Set frequency
| Property | Description |
|---|---|
| Pipeline name | A descriptive label for your pipeline. This is how the pipeline appears on the pipeline dashboard and how Data Loader refers to the pipeline. |
| Sync every | The frequency at which the pipeline should sync. Day values include 1—7. Hour values include 1—23. Minute values include 5—59. The input is also the length of delay before the first sync. |
Currently, you can't specify a start time.
Once you are happy with your pipeline configuration, click Create pipeline to complete the process and add the pipeline to your dashboard.