Facebook Ads

Facebook Ads ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

v3.3

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

Facebook Ads account email Facebook Ads account password

Replication Type: Key Based Incremental

Replication Key: Date

Suggested Replication Frequency: 24 hrs

Tables/APIs Supported

Insights

Ads

Campaigns

AdCreatives

AdInsightsBreakdownCountry

AdInsightsBreakdownRegion

AdInsightsBreakdownGender

AdInsightsBreakdownDevicePlatform

Integrate Facebook Ads with Daton

  1. Signin to Daton

  2. Select Facebook Ads from Integrations page

  3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

  4. You will be redirected to Facebook Ads login for authorizing Daton to extract data periodically

  5. Post successful authentication, you will be prompted to choose from the list of available Facebook Ad accounts

  6. Select required tables from the available list of tables

  7. Then select all required fields for each table

  8. Submit the integration

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Facebook Ads Data

Insights

Purpose: Provides interface to retrive data related to ads.

Source API Documentation https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights/v3.3

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name

Target Datatype

account_currency

STRING

account_id

STRING

account_name

STRING

action_values

RECORD

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

buying_type

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMERIC

clicks

NUMERIC

cost_per_estimated_ad_recallers

NUMERIC

cost_per_inline_link_click

NUMERIC

cost_per_inline_post_engagement

NUMERIC

cost_per_unique_click

NUMERIC

cost_per_unique_inline_link_click

NUMERIC

cpc

NUMERIC

cpm

NUMERIC

cpp

NUMERIC

ctr

NUMERIC

date_start

STRING

date_stop

STRING

estimated_ad_recall_rate

NUMERIC

estimated_ad_recallers

NUMERIC

frequency

NUMERIC

impressions

NUMERIC

inline_link_clicks

NUMERIC

inline_post_engagement

NUMERIC

objective

STRING

reach

NUMERIC

social_spend

NUMERIC

spend

NUMERIC

unique_clicks

NUMERIC

unique_ctr

NUMERIC

unique_inline_link_click_ctr

NUMERIC

unique_inline_link_clicks

NUMERIC

website_ctr

RECORD

Ads

Purpose: Ads object has the necessary data of each ad. Each Ad is linked with an corresponding adset.

Source API Documentation https://developers.facebook.com/docs/marketing-api/reference/adgroup

Replication: Key-Based Replication

Replication Key: lastRunRecordDate

Fields

Name

Target Datatype

id

STRING

account_id

STRING

adlabels

RECORD

adset_id

STRING

bid_amount

NUMERIC

campaign_id

STRING

configured_status

STRING

created_time

STRING

name

STRING

source_ad_id

STRING

status

STRING

creative

RECORD

Campaigns

Purpose: A campaign is a grouping of ad sets which are organized by the same business objective. Each campaign has an objective that must be valid across the ad sets within that campaign.

Source API Documentation https://developers.facebook.com/docs/marketing-api/reference/ad-campaign-group

Replication: Key-Based Replication

Replication Key: lastRunRecordDate

Fields

Name

Target Datatype

id

STRING

account_id

STRING

adlabels

RECORD

name

STRING

objective

STRING

effective_status

STRING

buying_type

STRING

spend_cap

STRING

start_time

STRING

updated_time

STRING

AdCreatives

Purpose: Adcreatives table consists information of the layout and content for the ad.

Source API Documentation https://developers.facebook.com/docs/marketing-api/reference/ad-creative

Replication: Key-Based Replication

Replication Key: AdAccount

Fields

Name

Target Datatype

body

STRING

image_url

STRING

id

STRING

account_id

STRING

actor_id

STRING

applink_treatment

STRING

call_to_action_type

STRING

effective_instagram_story_id

STRING

effective_object_story_id

STRING

title

STRING

name

STRING

instagram_permalink_url

STRING

instagram_story_id

STRING

link_og_id

STRING

object_id

STRING

object_story_id

STRING

object_type

STRING

object_url

STRING

product_set_id

STRING

status

STRING

template_url

STRING

thumbnail_url

STRING

image_hash

STRING

url_tags

STRING

video_id

STRING

link_url

STRING

AdInsightsBreakdownCountry

Purpose: Provides interface to retrive data related to ads divided using breakdown country.

Source API Documentation https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights/v3.3

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name

Target Datatype

account_currency

STRING

account_id

STRING

account_name

STRING

action_values

RECORD

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

buying_type

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMERIC

clicks

NUMERIC

cost_per_estimated_ad_recallers

NUMERIC

cost_per_inline_link_click

NUMERIC

cost_per_inline_post_engagement

NUMERIC

cost_per_unique_click

NUMERIC

cost_per_unique_inline_link_click

NUMERIC

cpc

NUMERIC

cpm

NUMERIC

cpp

NUMERIC

ctr

NUMERIC

date_start

STRING

date_stop

STRING

estimated_ad_recall_rate

NUMERIC

estimated_ad_recallers

NUMERIC

frequency

NUMERIC

impressions

NUMERIC

inline_link_clicks

NUMERIC

inline_post_engagement

NUMERIC

objective

STRING

reach

NUMERIC

social_spend

NUMERIC

spend

NUMERIC

unique_clicks

NUMERIC

unique_ctr

NUMERIC

unique_inline_link_click_ctr

NUMERIC

unique_inline_link_clicks

NUMERIC

website_ctr

RECORD

AdInsightsBreakdownRegion

Purpose: Provides interface to retrive data related to ads divided using breakdown Region.

Source API Documentation https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights/v3.3

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name

Target Datatype

account_currency

STRING

account_id

STRING

account_name

STRING

action_values

RECORD

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

buying_type

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMERIC

clicks

NUMERIC

cost_per_estimated_ad_recallers

NUMERIC

cost_per_inline_link_click

NUMERIC

cost_per_inline_post_engagement

NUMERIC

cost_per_unique_click

NUMERIC

cost_per_unique_inline_link_click

NUMERIC

cpc

NUMERIC

cpm

NUMERIC

cpp

NUMERIC

ctr

NUMERIC

date_start

STRING

date_stop

STRING

estimated_ad_recall_rate

NUMERIC

estimated_ad_recallers

NUMERIC

frequency

NUMERIC

impressions

NUMERIC

inline_link_clicks

NUMERIC

inline_post_engagement

NUMERIC

objective

STRING

reach

NUMERIC

social_spend

NUMERIC

spend

NUMERIC

unique_clicks

NUMERIC

unique_ctr

NUMERIC

unique_inline_link_click_ctr

NUMERIC

unique_inline_link_clicks

NUMERIC

website_ctr

RECORD

AdInsightsBreakdownGender

Purpose: Provides interface to retrive data related to ads divided using breakdown Gender.

Source API Documentation https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights/v3.3

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name

Target Datatype

account_currency

STRING

account_id

STRING

account_name

STRING

action_values

RECORD

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

buying_type

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMERIC

clicks

NUMERIC

cost_per_estimated_ad_recallers

NUMERIC

cost_per_inline_link_click

NUMERIC

cost_per_inline_post_engagement

NUMERIC

cost_per_unique_click

NUMERIC

cost_per_unique_inline_link_click

NUMERIC

cpc

NUMERIC

cpm

NUMERIC

cpp

NUMERIC

ctr

NUMERIC

date_start

STRING

date_stop

STRING

estimated_ad_recall_rate

NUMERIC

estimated_ad_recallers

NUMERIC

frequency

NUMERIC

impressions

NUMERIC

inline_link_clicks

NUMERIC

inline_post_engagement

NUMERIC

objective

STRING

reach

NUMERIC

social_spend

NUMERIC

spend

NUMERIC

unique_clicks

NUMERIC

unique_ctr

NUMERIC

unique_inline_link_click_ctr

NUMERIC

unique_inline_link_clicks

NUMERIC

website_ctr

RECORD

AdInsightsBreakdownDevicePlatform

Purpose: Provides interface to retrive data related to ads divided using breakdown Device Platform.

Source API Documentation https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights/v3.3

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name

Target Datatype

account_currency

STRING

account_id

STRING

account_name

STRING

action_values

RECORD

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

buying_type

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMERIC

clicks

NUMERIC

cost_per_estimated_ad_recallers

NUMERIC

cost_per_inline_link_click

NUMERIC

cost_per_inline_post_engagement

NUMERIC

cost_per_unique_click

NUMERIC

cost_per_unique_inline_link_click

NUMERIC

cpc

NUMERIC

cpm

NUMERIC

cpp

NUMERIC

ctr

NUMERIC

date_start

STRING

date_stop

STRING

estimated_ad_recall_rate

NUMERIC

estimated_ad_recallers

NUMERIC

frequency

NUMERIC

impressions

NUMERIC

inline_link_clicks

NUMERIC

inline_post_engagement

NUMERIC

objective

STRING

reach

NUMERIC

social_spend

NUMERIC

spend

NUMERIC

unique_clicks

NUMERIC

unique_ctr

NUMERIC

unique_inline_link_click_ctr

NUMERIC

unique_inline_link_clicks

NUMERIC

website_ctr

RECORD