Facebooks Ads Extractor Document 

 

 blobid0.pngFacebook is the largest social media platform globally, meaning it is the destination 

 allowing advertisers to reach the largest majority of potential consumers.  

 

 INTEGRATION OVERVIEW 

The Daasity<>Facebook Ads integration extracts key advertising information from the Facebook Ads platform, which includes Instagram advertising as well. Data such as spend, clicks and impressions are extracted on a daily basis and populate your data warehouse 

 

AVAILABILITY 

This information is incorporated into Daasity’s Unified Marketing Schema for Growth and Pro 2.0 merchants. 

 

It is available in the Google Ads Dashboard for Pro Legacy merchants. Legacy merchants are those whose Daasity accounts were created prior to July 15, 2020 and have their own Looker instance. 

 

SUPPORTED ENDPOINTS 

Endpoint 

Included 

Insights API 

https://developers.facebook.com/docs/marketing-api/insights 

Ads 

https://graph.facebook.com/v6.0/{account_id}/ads 

Adsets 

https://graph.facebook.com/v6.0/{account_id}/adsets 

Ad Spends 

https://graph.facebook.com/v6.0/{account_id}/adspends 

Campaigns 

https://graph.facebook.com/v6.0/{account_id}/campaigns 

 

ERD 

 

 

Ads Table 

Data mapping from source JSON to database columns: 

JSON Element 

Database Column 

id 

id 

Date queried in API 

date 

name 

ad_name 

status 

ad_status 

Facebook Account ID 

ad_account_id 

ID of Merchant in Daasity App 

_account_id 

timestamp when data was extracted from Shopify 

__synced_at 

 

 

Incremental data extraction  

Business Rule 

Value 

Load type 

UPSERT 

Extraction Frequency 

Daily 

 

 

Adsets Table 

Data mapping from source JSON to database columns: 

JSON Element 

Database Column 

id 

id 

Date queried in API 

date 

name 

adset_name 

status 

adset_status 

targeting::geo_locations::countries 

target_country 

targeting::publisher_platforms 

target_platform 

Facebook Account ID 

ad_account_id 

ID of Merchant in Daasity App 

_account_id 

timestamp when data was extracted from Shopify 

__synced_at 

 

 

Incremental data extraction  

Business Rule 

Value 

Load type 

UPSERT 

Extraction Frequency 

Daily 

 

 

Ad Spends Table 

Data mapping from source JSON to database columns: 

JSON Element 

Database Column 

id 

id 

Date queried in API 

date 

campaign_id 

campaign_id 

adset_id 

adset_id 

ad_id 

ad_id 

spend 

spend 

cpc 

cpc 

cpm 

cpm 

cpp 

cpp 

ctr 

ctr 

purchase_value::adspend 

purchase_value 

purchase_count::adspend 

purchase_count 

get_actions_mobile_purchase::adspend 

mobile_purchase_value 

get_action_values_mobile_purchased::adspend 

mobile_purchase_count 

Facebook Account ID 

ad_account_id 

ID of Merchant in Daasity App 

_account_id 

timestamp when data was extracted from Shopify 

__synced_at 

 

 

Incremental data extraction  

Business Rule 

Value 

Load type 

UPSERT 

Extraction Frequency 

Daily 

 

 

Campaigns Table 

Data mapping from source JSON to database columns: 

JSON Element 

Database Column 

id 

id 

Date queried in API 

date 

id 

campaign_id 

name 

campaign_name 

status 

campaign_status 

Facebook Account ID 

ad_account_id 

ID of Merchant in Daasity App 

_account_id 

timestamp when data was extracted from Shopify 

__synced_at 

 

 

Incremental data extraction  

Business Rule 

Value 

Load type 

UPSERT 

Extraction Frequency 

Daily 

 

 

Was this article helpful?
0 out of 0 found this helpful