Facebook Ads:

Facebook Ads is the advertising platform that allows businesses and individuals to create targeted ads on Facebook and its affiliated apps, such as Instagram and Messenger.

Grab credentials

Grab Account ID

Ensure you have Ads Manager activated for your Facebook account.
Locate your account ID, which is a lengthy number. You can find it by clicking on the Account Overview dropdown in Ads Manager or by checking the link address. For example, adsmanager.facebook.com/adsmanager/manage/accounts?act={accountId}.
Copy the account ID.

Grab Access_Token

Please sign up for a developer account at https://developers.facebook.com.
Log in to your developer account and click on My Apps in the top right corner.
Create an app, choose Other as the type, select Business as the category, and click Next.
Enter the name of your app and select the associated business manager account.
Navigate to the Basic settings in the left-hand side menu.
Copy the App ID and App secret.
Next, obtain a short-lived access token at https://developers.facebook.com/tools/explorer/.
Select the created app, add ads_read and lead_retrieval permissions, and generate a short-lived access token.
Copy the access token.

Connection Properties

The config section in a YAML file includes the following properties:

Connectorname**: FacebookAds
Access_token**: FacebookAds access token
Client_id**: Client’s id
Client_secret**: Client’s secret
Account_id**: FacebookAds Account ID

Incremental Mode:

The Facebook ads doesn’t support incremental mode and Facebook insights supports incremental mode.

properties:
        type: insights
        initial_load_past_days: 30
        attribution_window_days_lag: 7
        time_increment_days: 1

The incremental mode loads the new data instead of loading the entire dataset. In the given example, the initial load is set to 30 days. It loads the data for the past 30 days, which is incremented daily since the time increment day is set to one. The attribution is how far the system should go back to consider data attribution.

Example Configuration

Facebook ads

version: 1
encrypt_credentials: false
plugins:
  extractors:
    - name: fb_data
      connectorname: FacebookAds
      config:
        access_token: <ACCESS TOKEN>
        client_id: <CLIENT ID>
        client_secret: <CLIENT SECRET>
        account_id: <ACCOUNT ID>
      select:
        - ads
        - ads1

Facebook insights

version: 1
encrypt_credentials: false
plugins:
  extractors:
    - name: fb_data
      connectorname: FacebookAds
      config:
        access_token: <ACCESS TOKEN>
        client_id: <CLIENT ID>
        client_secret: <CLIENT SECRET>
        account_id: <ACCOUNT ID>
      properties:
        type: insights
        initial_load_past_days: 30
        attribution_window_days_lag: 7
        time_increment_days: 1

Configure the ETL to connect Facebook Ads

To start, Click the Bold ETL icon on the Navigation Pane.

Facebook ADs ETL - BoldBI

Click Add Project and provide the name for the new project.

Facebook ADs ETL - BoldBI

Select the newly created project and add the Facebook Ads template.

Facebook ADs ETL - BoldBI

Update the access token and account ID in the template. Also, Update the resources on the select property and save it to the BoldBI Data Store.

Facebook ADs ETL - BoldBI

The available resources are supported in Facebook Ads 
- campaigns 
- ads 
- ad_creatives 
- leads 
- ad_sets

Warning:

1. The `Encrypt_Credentials` property should be set to false when updating the new access token on the template. If you have modified other properties, such as 'select' or 'account id', the `Encrypt_Credentials` property must be set to true.  
2. The default lifetime of the access token is 1 hour. Therefore, you need to convert it to a long-lived access token in order to use the same token for 60 days. Existing tables should be maintained even if the token has expired or is being used as an invalid token.