version: 1.0.0
Category: Marketing Analytics
Tier: 3
Api version: v19
Type: Source
Authentication:
OAuth
Token (Manual entry of long lived access token)
Resources Supported:
Reference: https://developers.facebook.com/docs/marketing-api/insights
Resource Name | Sub Resource | Description | Parameter |
Campaign | All Campaigns - Insights | Lists all Insights on a Campaign level | Ad Account |
Ad | All Ads - Insights | Lists all Insights on an Ad level | Ad Account |
Adset | All Adsets - Insights | Lists all Insights on a Adset level | Ad Account |
Connection Properties
Authentication Mode: OAuth
Name | Mandatory | Description |
|---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of connection |
Fill up required fields (name)
Click Authorize
You will be redirected to facebook for oauth
Approve the request and you will be redirected to EazyDI
Test connection to confirm
2. Authentication Mode: Token
Name | Mandatory | Description |
|---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of connection |
Token | Yes | The long lived access token |
Permission required for manual entry of token
read_insights
ads_read
Retrieve my access token manually
Create an app in https://developers.facebook.com/apps/
Choose other
Choose type as business
Name the app and click create
Add products marketing api and facebook login for business
Go to Settings → Basic and retrieve the appid and secret
Go to Tools → Graph api explorer
Select your app and add the permissions needed. Click Generate token
Copy the token and create a Long lived Access Token https://developers.facebook.com/docs/facebook-login/guides/access-tokens/get-long-lived/
Creating a connection
Fill up required fields (name, token)
Click Test Connection to check if token is valid
Configuring Object
Choose from the Resource Type, Sub Resource Type, and Advertiser Id that will be used as source
Fields
The fields are based on schema defined in https://developers.facebook.com/docs/marketing-api/insights v19.0 but automatically flattened to be able to map easily
Running a Pipeline with Facebook as Source
Facebook data:
Target (Snowflake):
Reauthorize:
If token has been stale, invalid, uninstalled in your Facebook account, or you are receiving unauthorized error, You can reauthorize your connection by clicking the Reauthorize button for OAuth or manually regenerating a long lived access token as seen above