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.

Connection Editor window

Creating Connection

To connect to Facebook Ads, perform the following steps:

Connection Editor window

  1. Click Sign In with Facebook.
  2. Enter your facebook credentials and click Log In.

    Facebook Sign In window

  3. 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. 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

Operation Object
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.

Supported Actions

Skyvia supports all the common actions for Facebook Ads.