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:

  1. Go to you Ads Manager Account
  2. Head to the drop down at the top of the screen next to the Campaigns title
  3. 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


FeatureSupportNotes
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
CampaignDATE_STOPCAMPAIGN_ID, DATE_START, DATE_STOP, BREAKDOWNAdInsights
AdsetDATE_STOPADSET_ID, DATE_START, DATE_STOP, BREAKDOWNAdInsights
AdDATE_STOPAD_ID, DATE_START, DATE_STOP, BREAKDOWNAdInsights
Ad CreativesAD_DATE_STOPID, AD_DATE_STOPAdCreatives

πŸ“˜

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