Facebook 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 |
|
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 |