Google Ads is an online advertising platform developed by Google. Using Google Ads, you can create online ads to reach people exactly when they are interested in your products and services.
Data integration: Skyvia supports importing data from Google Ads to other applications, exporting its data to CSV files, and replicating Google Ads data to relational databases.
Backup: Skyvia Backup does not support Google Ads.
Query: Skyvia Query supports Google Ads.
To create a connection to Google Ads, you need to sign in with your Google credentials and select the Customer.
To create a Google Ads connection, perform the following steps:
Click Sign In with Google in the Connection Editor.
- Enter your Google email and password and click Sign in.
In the next window, click the Allow button to allow Skyvia to access your Google account
Additional Connection Parameters
Click Advanced Settings in the Connection Editor to enable additional connection parameters.
Select this parameter when you use a manager account in Google Ads connection to access an operating customer account to avoid ambiguity.
This parameter determines the period for data queried from the objects with the -Report suffix.
Skyvia represents Google Ads data as objects. The objects containing Report and View in their names are read-only. We need them to get statistical and analytical data about all other objects in Google Ads. For example, CampaignsReport is an object that contains all the fields of the Campaigns object together with additional fields like segments and metrics. Segments are attributes of your data. Metrics are quantitative measurements.
Consider segments and metrics compatibility. You may receive an error in case you query incompatible segments and metrics.
Incremental Replication and Synchronization
The following Google Ads objects support Incremental Replication: AdGroupsReport, AdGroupAdsReport, AdGroupAdAssetView, AdGroupAudienceView, AdScheduleView, AgeRangeView, BiddingStrategiesReport, CampaignsReport, CampaignAudienceView, CampaignBudgetsReport, ClickView, CustomersReport, DetailPlacementView, DisplayKeywordView, DistanceView, DynamicSearchAdsSearchTermView, ExpandedLandingPageView, ExtensionFeedItemsReport, FeedItemsReport, FeedPlaceholderView, GenderView, GeographicView, GroupPlacementView, HotelGroupView, HotelPerformanceView, IncomeRangeView, KeywordView, LandingPageView, ManagedPlacementView, PaidOrganicSearchTermView, ParentalStatusView, ProductGroupView, SearchTermView, TopicView, UserLocationView, VideosReport
Skyvia supports Incremental Replication for objects having the Segments_Date field. This field stores dates without the time part. When performing replication with Incremental Updates, Skyvia only tracks updates up to the last day. Skyvia doesn’t track the updates made on the current date.
It means there is no point in scheduling replication with Incremental Updates more than once daily.
Skyvia doesn’t support Synchronization for Google Ads.
DML Operations Support
|INSERT, UPDATE, DELETE||AdGroups, AdGroupAds, BiddingStrategies, Campaigns, CampaignBudgets, ConversionActions|
Skyvia supports all the common actions for Google Ads.