The Facebook Marketing connector
Note
This connector is based on Airbyte
You can use this connector for source endpoints.
Source endpoint
-
Specify the Start date from which you want to replicate the data for all incremental streams.
Note that you need to provide the date and time in the ISO 8601
YYYY-MM-DDT00:00:00Z
. -
Provide your Account ID.
Note that an Account ID is a 15-digit number. To find your Account ID:
-
Go to Ads Manger and click Account Overview in the activity bar on the left.
-
Find the name of your business account in the frame on the right. The Account ID number will be directly under the name.
-
-
Define the End date from which you want to replicate the data for all incremental streams in the
YYYY-MM-DDT00:00:00Z
format.Note
If you don't specify the End date, the service will always sync the latest data.
-
Provide the Access token:
-
In your App dashboard, click Marketing API → Tools.
-
Select all the available token permissions:
ads_management
,ads_read
,read_insights
,business_management
. -
Click Get token.
-
Copy and paste the token.
-
-
Check the Include deleted box if you want to include the data from your deleted campaigns, ads, and AdSets.
-
Check the Fetch Thumbnail Images box to fetch thumbnail URLs for each Ad Creative and store them in the
thumbnail_data_url
table.
To add Custom Insights:
1. Click **Custom Insights** → **Add Custom Insights**.
1. **Name** the insight value you want to replicate.
1. Select the **Field**, **Breakdown** and **Action breakdown** from the respective drop-down lists.
For more information on selectable fields, see [Meta Marketing API Reference ](https://developers.facebook.com/docs/marketing-api/reference/).
Supported tables
The DoubleCloud endpoint supports replication of the following tables from Facebook:
- Activities
- AdAccount
- AdCreatives
- AdSets
- Ads
- AdInsights
- Campaigns
- Images
- Videos
For more information, see Facebook Insights API documentation
For an example of this endpoint usage in a real scenario, see Marketing analytics end-to-end scenario.
To create a Facebook Marketing source endpoint with API, use the endpoint.airbyte.FacebookMarketingSource model.
Airbyte type | Transfer type |
---|---|
integer |
int64 |
— | int32 |
— | int16 |
— | int8 |
— | uint64 |
— | uint32 |
— | uint16 |
— | uint8 |
— | float |
number |
double |
— | string |
time_without_timezone , time_with_timezone , string |
utf8 |
boolean |
boolean |
date |
date |
date-time |
datetime |
timestamp , timestamp_with_timezone , timestamp_without_timezone |
timestamp |
object , array , REST ... |
any |