Facebook Ads
Facebook Ads is a service promoting customer products, services, websites, etc. from Facebook.
Data integration: Skyvia supports importing data to and from Facebook Ads, exporting Facebook Ads data to CSV files, replicating Facebook Ads data to relational databases, and synchronizing Facebook Ads data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Facebook Ads backup.
Query: Skyvia Query supports Facebook Ads.
Establishing Connection
To create a connection with Facebook Ads, sign in with Facebook Ads and specify the Ad Account Id.
Getting Credentials
You can find the Ad Account Id in your Facebook Ads Manager. The Ad Account Id value is located above the search and filter bar, in the account dropdown menu or in the page URL.
Creating Connection
To connect to Facebook Ads, perform the following steps:
- Click Sign In with Facebook.
-
Enter your facebook credentials and click Log In.
- Enter your Ad Account Id
Connector Specifics
Object Peculiarities
There are two types of objects in Facebook Ads: standard objects and *Insights objects.
Insights Objects
Objects with *Insights suffix in their names are the metrics for the random period from DateStart to DateStop. Objects with Monthly*…*Insights names are the metrics for the completed calendar months. Objects with Daily*…*Insights names are the metrics for the completed days.
All these objects are read-only. They include only the data for the completed periods in the query results by default.
If you query the Daily*…*Insights objects, current date data is not included in the query results, because the day is not ended yet.
When you query Monthly*…*Insights objects, current month data is not included in the query results, because the current month is not ended yet.
Campaigns
Campaigns in the Draft status are not displayed in the query results by default.
Filtering Specifics
The *Insights objects natively support the following logical operators for filtering: =, !=, >, >=, <, <=, IN, NOT_IN, IN_RANGE, NOT_IN_RANGE.
Facebook Ads API supports native filters by the following fields:
| Object | Field |
|---|---|
| Campaigns | Id, Name, Objective, BuyingType, SpendCap, CreatedTime, EffectiveStatus, UpdatedTime |
| AdSets | Id, Name, CampaignId, BillingEvent, OptimizationGoal, BidAmount, LifetimeBudget, DailyBudget, CreatedTime, UpdatedTime |
| Ads | Id, Name, CampaignId, AdSetId, BidAmount, CreatedTime, UpdatedTime |
| AdCreatives, AdVideos, AdImages | Id |
DML Operations Support
| Operation | Object |
|---|---|
| INSERT, UPDATE, DELETE | Campaigns, AdSets, Ads |
| INSERT, DELETE | AdImages, AdVideos |
| INSERT | LeadgenForms |
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates for the following Facebook Ads objects:
AccountInsights, AccountInsightsByCountry, AdImages, AdInsights, AdInsightsByCountry, Ads, AdSetInsights, AdSetInsightsByCountry, AdSets, AdVideos, CampaignInsights, CampaignInsightsByCountry, Campaigns, DailyAccountInsights, DailyAccountInsightsByCountry, DailyAdInsights, DailyAdInsightsByCountry, DailyAdSetInsights, DailyAdSetInsightsByCountry, DailyCampaignInsights, DailyCampaignInsightsByCountry, LeadgenForms, MonthlyAccountInsights, MonthlyAccountInsightsByCountry, MonthlyAdInsights, MonthlyAdInsightsByCountry, MonthlyAdSetInsights, MonthlyAdSetInsightsByCountry, MonthlyCampaignInsights, MonthlyCampaignInsightsByCountry.
Skyvia detects only new records and doesn’t track the updated records for the LeadgenForms object.
Skyvia tracks the object changes using the DateStart and DateStop fields.
By default, Skyvia replicates Monthly*…*Insights data for the last 12 months and Daily*…*Insights data — for the last month during the initial replication run. To replicate reports for earlier periods, you can set the LastSyncTime parameter to the needed start date before the initial replication run.
Skyvia supports Synchronization for the following Facebook Ads objects: Ads, AdSets, Campaigns.
Supported Actions
Skyvia supports all the common actions for Facebook Ads.