Step-by-Step Guide to Connecting Facebook Ads to ETL Using an Access Token

Published:

Configure Facebook Ads in ETL

Prerequisite

Create a new app (if the app is not available).
Generate Access Token
Long-Lived Access Tokens
Account ID

Create a new APP

Log in to your developer account and click on My Apps located in the top right corner.
Click a Create APP.
Select an Other Option and Click a Next.
Select an app type based on your requirement (Business) and click a Next.
Enter an App Name and Click Create App.

Generate Access Token

Open Facebook Explorer https://developers.facebook.com/tools/explorer.
Select an existing app from the Meta App section.
Obtain an access token with the necessary permissions for accessing the Facebook Ads data. You might need to add the below scopes and include any other related scopes if needed. Then, click Generate Access Token.

ads_management
ads_read
read_insights
pages_show_list
leads_retrieval
pages_read_engagement
pages_read_user_content

Long-Lived Access Tokens

If you need a long-lived user access token, you can generate one from a short-lived user access token. A long-lived token typically lasts around 60 days.

You will need the following:

Valid User Access Token
App ID
App Secret

Query the GET oauth/access_token endpoint.

Account Id

Execute the URL below to retrieve the account ID.

me/adaccounts?fields=name, account_id
Pick up your account ID from the response.

Configure the ETL to connect Facebook Ads

Click a Bold ETL.
Click Add Project and provide the name for the new project.
Select the newly created project and add the Facebook Ads template.
Updated the access token and account ID in the template. Also, Updated the resources on the select property.

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

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.
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.

Schedule ETL Job

Click Schedules and select the created facebookETLDSproject.
For on-demand refresh, click Run Now.
After, Complete the on-demand refresh.
To schedule the refresh hourly, please click the Scheduleoption.
The data source was created by ETL in Bold BI.
Click Edit DataSource Option to view the created tables, such as ‘Campaigns’ and ‘Adsets’ tables.