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.
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.
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.
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.
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.
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.
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.
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.
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
Last modified 2yr ago