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.
To create a connection with Facebook Ads, sign in with Facebook Ads and specify the Ad Account Id.
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.
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
There are two types of objects in Facebook Ads: standard objects and -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. Objects with the -InsightsByCountry suffix store the same metrics as the above objects but grouped by countries and containing the Country field.
All these objects are read-only. These objects 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 in the Draft status are not returned in the query results by default.
DML Operations Support
|INSERT, UPDATE, DELETE||Campaigns, AdSets, Ads|
|INSERT, DELETE||AdImages, AdVideos|
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates for the following Facebook Ads objects:
Campaigns, AdSets, Ads, AdImages, AdVideos, AccountInsights, CampaignInsights, AdSetInsights, AdInsights, DailyAccountInsights, MonthlyAccountInsights, DailyCampaignInsights, MonthlyCampaignInsights, DailyAdSetInsights, MonthlyAdSetInsights, DailyAdInsights, MonthlyAdInsights, AccountInsightsByCountry, DailyAccountInsightsByCountry, MonthlyAccountInsightsByCountr, CampaignInsightsByCountry, DailyCampaignInsightsByCountry, MonthlyCampaignInsightsByCountry, AdSetInsightsByCountry, DailyAdSetInsightsByCountry, MonthlyAdSetInsightsByCountry, AdInsightsByCountry, DailyAdInsightsByCountry, MonthlyAdInsightsByCountry.
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.
Skyvia supports all the common actions for Facebook Ads.