Google Ads
Google Ads ETL connector for data replication
Snapshot
Features
Details
Release Status
Released
Source API Version
v14
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Google ads Login Id Password
Replication Type
Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
24 hrs
Integrate Google Ads with Daton
Sign in to Daton
Select GoogleAds from Integrations page
Provide Integration Name, Replication Frequency, Attribution window and History. Integration name would be used in creating tables for the integration and cannot be changed later
You will be redirected to GoogleAds login for authorizing Daton to extract data periodically
Post successful authentication, you will be prompted to create table names and link a resource.
Select a combination of Attributes, Metrics and Dimensions
Submit the integration
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Google Ads Resources Documentation
Official Documentation: https://developers.google.com/google-ads/api/fields/v10/overview
The Campaign.status column retrieves the current status of a campaign, and data in the campaigns table (resource) in the Google Ads API is fetched for all possible statuses. The possible statuses for a campaign are:
ENABLED
PAUSED
REMOVED
UNKNOWN
UNSPECIFIED
However, when validating data against the UI, you may not retrieve campaigns with the statuses "REMOVED," "UNKNOWN," or "UNSPECIFIED," which could lead to data discrepancies. To address this, you can either filter out these campaigns using the Campaign.status column or ensure you fetch data for all campaigns directly from the UI.
accessible_bidding_strategy
Represents a view of BiddingStrategies owned by and shared with the customer.
account_budget
An account-level budget. It contains information about the budget itself, as well as the most recently approved changes to the budget and proposed changes that are pending approval.
account_budget_proposal
An account-level budget proposal.
account_link
Represents the data sharing connection between a Google Ads account and another account
ad_group_ad_asset_combination_view
A view on the usage of ad group ad asset combination. Now we only support AdGroupAdAssetCombinationView for Responsive Search Ads, with more ad types planned for the future.
ad_group_ad_asset_view
A link between an AdGroupAd and an Asset. Currently we only support AdGroupAdAssetView for AppAds.
ad_group_ad_label
A relationship between an ad group ad and a label.
ad_group_asset
A link between an ad group and an asset.
ad_group_audience_view
An ad group audience view. Includes performance data from interests and remarketing lists for Display Network and YouTube Network ads, and remarketing lists for search ads (RLSA), aggregated at the audience level.
ad_group_bid_modifier
Represents an ad group bid modifier.
ad_group_criterion
An ad group criterion.
ad_group_criterion_customizer
A customizer value for the associated CustomizerAttribute at the AdGroupCriterion level.
ad_group_criterion_label
A relationship between an ad group criterion and a label.
ad_group_criterion_simulation
An ad group criterion simulation. Supported combinations of advertising channel type, criterion type, simulation type, and simulation modification method
ad_group_customizer
A customizer value for the associated CustomizerAttribute at the AdGroup level.
ad_group_extension_setting
An ad group extension setting.
ad_group_feed
An ad group feed.
ad_group_label
A relationship between an ad group and a label.
ad_group_simulation
An ad group simulation. Supported combinations of advertising channel type, simulation type and simulation modification method
ad_parameter
An ad parameter that is used to update numeric values (such as prices or inventory levels) in any text line of an ad (including URLs). There can be a maximum of two AdParameters per ad group criterion. (One with parameter_index = 1 and one with parameter_index = 2.)
ad_schedule_view
An ad schedule view summarizes the performance of campaigns by AdSchedule criteria.
age_range_view
An age range view.
asset
sset is a part of an ad which can be shared across multiple ads. It can be an image (ImageAsset), a video (YoutubeVideoAsset), etc. Assets are immutable and cannot be removed. To stop an asset from serving, remove the asset from the entity that is using it.
asset_field_type_view
An asset field type view. This view reports non-overcounted metrics for each asset field type when the asset is used as extension.
asset_group
An asset group. AssetGroupAsset will be used to link an asset to the asset group. AssetGroupHint will be used to associate a hint to an asset group.
asset_group_asset
AssetGroupAsset is the link between an asset and an asset group. Adding an AssetGroupAsset links an asset with an asset group.
asset_group_listing_group_filter
AssetGroupListingGroupFilter represents a listing group filter tree node in an asset group.
asset_group_product_group_view
An asset group product group view.
asset_group_signal
AssetGroupSignal represents a signal in an asset group. The existence of a signal tells the performance max campaign who's most likely to convert. Performance Max uses the signal to look for new people with similar or stronger intent to find conversions across Search, Display, Video, and more.
asset_set
An asset set representing a collection of assets. Use AssetSetAsset to link an asset to the asset set.
asset_set_asset
AssetSetAsset is the link between an asset and an asset set. Adding an AssetSetAsset links an asset with an asset set.
audience
Audience is an effective targeting option that allows you to intersect different segment attributes, such as detailed demographics and affinities, to create audiences that represent sections of your target segments.
batch_job
A list of mutates being processed asynchronously. The mutates are uploaded by the user.
bidding_data_exclusion
Represents a bidding data exclusion. See "About data exclusions" at https://support.google.com/google-ads/answer/10370710.
bidding_seasonality_adjustment
Represents a bidding seasonality adjustment. See "About seasonality adjustments" at https://support.google.com/google-ads/answer/10369906.
bidding_strategy
A bidding strategy.
bidding_strategy_simulation
A bidding strategy simulation. Supported combinations of simulation type and simulation modification method are detailed below respectively. TARGET_CPA - UNIFORM TARGET_ROAS - UNIFORM
billing_setup
A billing setup, which associates a payments account and an advertiser. A billing setup is specific to one advertiser.
call_view
A call view that includes data for call tracking of call-only ads or call extensions.
campaign_asset
A link between a Campaign and an Asset.
campaign_asset_set
CampaignAssetSet is the linkage between a campaign and an asset set. Adding a CampaignAssetSet links an asset set with a campaign.
campaign_audience_view
A campaign audience view. Includes performance data from interests and remarketing lists for Display Network and YouTube Network ads, and remarketing lists for search ads (RLSA), aggregated by campaign and audience criterion. This view only includes audiences attached at the campaign level.
campaign_bid_modifier
Represents a bid-modifiable only criterion at the campaign level.
campaign_budget
A campaign budget.
campaign_conversion_goal
The biddability setting for the specified campaign only for all conversion actions with a matching category and origin.
campaign_criterion
A campaign criterion.
campaign_criterion_simulation
A campaign criterion simulation. Supported combinations of advertising channel type, criterion ids, simulation type and simulation modification method is detailed below respectively. SEARCH - 30000,30001,30002 - BID_MODIFIER - UNIFORM DISPLAY - 30001 - BID_MODIFIER - UNIFORM
campaign_customizer
A customizer value for the associated CustomizerAttribute at the Campaign level.
campaign_draft
A campaign draft.
campaign_experiment
An A/B experiment that compares the performance of the base campaign (the control) and a variation of that campaign (the experiment).
campaign_extension_setting
A campaign extension setting.
campaign_feed
A campaign feed.
campaign_label
Represents a relationship between a campaign and a label.
campaign_shared_set
CampaignSharedSets are used for managing the shared sets associated with a campaign.
campaign_simulation
A campaign simulation. Supported combinations of advertising channel type, simulation type and simulation modification method is detailed below respectively. SEARCH - CPC_BID - UNIFORM SEARCH - CPC_BID - SCALING SEARCH - TARGET_CPA - UNIFORM SEARCH - TARGET_CPA - SCALING SEARCH - TARGET_ROAS - UNIFORM SEARCH - TARGET_IMPRESSION_SHARE - UNIFORM SEARCH - BUDGET - UNIFORM SHOPPING - BUDGET - UNIFORM SHOPPING - TARGET_ROAS - UNIFORM MULTIPLE - TARGET_CPA - UNIFORM OWNED_AND_OPERATED - TARGET_CPA - DEFAULT DISPLAY - TARGET_CPA - UNIFORM
carrier_constant
A carrier criterion that can be used in campaign targeting.
combined_audience
Describe a resource for combined audiences which includes different audiences.
conversion_action
A conversion action.
conversion_custom_variable
A conversion custom variable See "About custom variables for conversions" at https://support.google.com/google-ads/answer/9964350
conversion_goal_campaign_config
Conversion goal settings for a Campaign.
conversion_value_rule
A conversion value rule
conversion_value_rule_set
A conversion value rule set
currency_constant
A currency constant.
custom_audience
A custom audience. This is a list of users by interest.
custom_conversion_goal
Custom conversion goal that can make arbitrary conversion actions biddable.
custom_interest
A custom interest. This is a list of users by interest.
customer_asset
A link between a customer and an asset.
customer_client
A link between the given customer and a client customer. CustomerClients only exist for manager customers. All direct and indirect client customers are included, as well as the manager itself.
customer_client_link
Represents customer client link relationship.
customer_conversion_goal
Biddability control for conversion actions with a matching category and origin.
customer_customizer
A customizer value for the associated CustomizerAttribute at the Customer level.
customer_extension_setting
A customer extension setting.
customer_feed
A customer feed
customer_label
Represents a relationship between a customer and a label. This customer may not have access to all the labels attached to it. Additional CustomerLabels may be returned by increasing permissions with login-customer-id.
customer_manager_link
Represents customer-manager link relationship
customer_negative_criterion
A negative criterion for exclusions at the customer level.
customer_user_access
Represents the permission of a single user onto a single customer.
customer_user_access_invitation
Represent an invitation to a new user on this customer account.
customizer_attribute
A customizer attribute. Use CustomerCustomizer, CampaignCustomizer, AdGroupCustomizer, or AdGroupCriterionCustomizer to associate a customizer attribute and set its value at the customer, campaign, ad group, or ad group criterion level, respectively.
detail_placement_view
A view with metrics aggregated by ad group and URL or YouTube video.
detailed_demographic
A detailed demographic: a particular interest-based vertical to be targeted to reach users based on long-term life facts.
display_keyword_view
A display keyword view.
distance_view
A distance view with metrics aggregated by the user's distance from an advertiser's location extensions. Each DistanceBucket includes all impressions that fall within its distance and a single impression will contribute to the metrics for all DistanceBuckets that include the user's distance.
domain_category
A category generated automatically by crawling a domain. If a campaign uses the DynamicSearchAdsSetting, then domain categories will be generated for the domain. The categories can be targeted using WebpageConditionInfo. See: https://support.google.com/google-ads/answer/2471185
dynamic_search_ads_search_term_view
A dynamic search ads search term view.
expanded_landing_page_view
A landing page view with metrics aggregated at the expanded final URL level.
experiment
A Google ads experiment for users to experiment changes on multiple campaigns, compare the performance, and apply the effective changes.
experiment_arm
A Google ads experiment for users to experiment changes on multiple campaigns, compare the performance, and apply the effective changes.
extension_feed_item
An extension feed item.
feed_item_set
Represents a set of feed items. The set can be used and shared among certain feed item features. For instance, the set can be referenced within the matching functions of CustomerFeed, CampaignFeed, and AdGroupFeed.
feed_item_set_link
Represents a link between a FeedItem and a FeedItemSet.
feed_item_target
A feed item target.
feed_mapping
A feed mapping.
feed_placeholder_view
A feed placeholder view.
geo_target_constant
A geo target constant.
geographic_view
Geographic View includes all metrics aggregated at the country level, one row per country. It reports metrics at either actual physical location of the user or an area of interest. If other segment fields are used, you may get more than one row per country.
group_placement_view
A group placement view.
hotel_group_view
A hotel group view.
hotel_performance_view
A hotel performance view.
hotel_reconciliation
A hotel reconciliation. It contains conversion information from Hotel bookings to reconcile with advertiser records. These rows may be updated or canceled before billing via Bulk Uploads.
income_range_view
An income range view.
keyword_plan
A Keyword Planner plan. Max number of saved keyword plans: 10000. It's possible to remove plans if limit is reached.
keyword_plan_ad_group
A Keyword Planner ad group. Max number of keyword plan ad groups per plan: 200.
keyword_plan_ad_group_keyword
A Keyword Plan ad group keyword. Max number of keyword plan keywords per plan: 10000.
keyword_plan_campaign
A Keyword Plan campaign. Max number of keyword plan campaigns per plan allowed: 1.
keyword_plan_campaign_keyword
A Keyword Plan Campaign keyword. Only negative keywords are supported for Campaign Keyword.
keyword_theme_constant
A Smart Campaign keyword theme constant.
keyword_view
A keyword view.
landing_page_view
A landing page view with metrics aggregated at the unexpanded final URL level.
language_constant
A language.
life_event
A life event: a particular interest-based vertical to be targeted to reach users when they are in the midst of important life milestones.
location_view
A location view summarizes the performance of campaigns by Location criteria.
managed_placement_view
A managed placement view.
mobile_app_category_constant
A mobile application category constant.
mobile_device_constant
A mobile device constant.
offline_user_data_job
A job containing offline user data of store visitors, or user list members that will be processed asynchronously. The uploaded data isn't readable and the processing results of the job can only be read using GoogleAdsService.Search/SearchStream
operating_system_version_constant
A mobile operating system version or a range of versions, depending on operator_type. List of available mobile platforms at https://developers.google.com/google-ads/api/reference/data/codes-formats#mobile-platforms
paid_organic_search_term_view
A paid organic search term view providing a view of search stats across ads and organic listings aggregated by search term at the ad group level.
parental_status_view
A parental status view.
product_bidding_category_constant
A Product Bidding Category.
product_group_view
A product group view.
recommendation
A recommendation.
remarketing_action
A remarketing action. A snippet of JavaScript code that will collect the product id and the type of page people visited (product page, shopping cart page, purchase page, general site visit) on an advertiser's website.
search_term_view
A search term view with metrics aggregated by search term at the ad group level.
shared_criterion
A criterion belonging to a shared set.
shared_set
SharedSets are used for sharing criterion exclusions across multiple campaigns.
shopping_performance_view
Shopping performance view. Provides Shopping campaign statistics aggregated at several product dimension levels. Product dimension values from Merchant Center such as brand, category, custom attributes, product condition and product type will reflect the state of each dimension as of the date and time when the corresponding event was recorded.
smart_campaign_search_term_view
A Smart campaign search term view.
smart_campaign_setting
Settings for configuring Smart campaigns.
third_party_app_analytics_link
A data sharing connection, allowing the import of third party app analytics into a Google Ads Customer.
topic_constant
Use topics to target or exclude placements in the Google Display Network based on the category into which the placement falls (for example, "Pets & Animals/Pets/Dogs").
user_interest
A user interest: a particular interest-based vertical to be targeted.
user_list
A user list. This is a list of users a customer may target.
user_location_view
User Location View includes all metrics aggregated at the country level, one row per country. It reports metrics at the actual physical location of the user by targeted or not targeted location. If other segment fields are used, you may get more than one row per country
webpage_view
A webpage view.
Last updated