Facebook Ad Insights (sign in with facebook)
Version 0.2.0
Checkout the Facebook Ad Insights API docs for more information
Set up
To set up the source you just need a Facebook username and password for a user which has been added to the business account from which you would like to retrieve data. You will also need your account ID.
To find your account ID:
- Go to you Ads Manager Account
- Head to the drop down at the top of the screen next to the Campaigns title
- Copy the Ad Account ID for the account you wish to pull data from.
If you don't supply and Ad Account ID, the extracts will by default get data from all Ad Accounts.
Tokens
Facebook authentication can expire for a number of reasons, including the following:
- The user’s password changes
- The user revokes permissions
If this occurs you will receive a 401 authorization error and you will have to re-authenticate the source by clicking edit -> reset.
Features
Feature | Support | Notes |
---|---|---|
Backfill | ✅ | 3 months by default, up to 18 months (not recommended) |
Incremental | ✅ | |
Custom backfill | ❌ | |
API reliability | 🟡 | See callout below |
Async Errors
The Facebook API sometimes returns an Async error, see below. We handle these errors by retrying 5 times. if this error still occurs then please retry the extract.
This error is more likely to occur with larger data volumes.
{
"source-type": "facebook-oauth-jumper",
"message": "Async request for 23849864184600169 failed"
}
Reports detail
⬇️ Report | 🔑 Incremental key | 🔑 Primary key | 📄 Link to API endpoint |
---|---|---|---|
Campaign | DATE_STOP | CAMPAIGN_ID , DATE_START , DATE_STOP , BREAKDOWN | AdInsights |
Adset | DATE_STOP | ADSET_ID , DATE_START , DATE_STOP , BREAKDOWN | AdInsights |
Ad | DATE_STOP | AD_ID , DATE_START , DATE_STOP , BREAKDOWN | AdInsights |
Ad Creatives | AD_DATE_STOP | ID , AD_DATE_STOP | AdCreatives |
Duplicates
As data within the Facebook platform is always updating, the connector will fetch again all data from at least the last 7 days, to ensure you have the most up-to-date data in your warehouse.
This will cause duplicate entries for some days, and you will need to deduplicate, whilst keeping the rows that have the most recent
_KLEENE_EXTRACT_DATE
Updated 3 months ago