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.
| Resource name | Description | Documentation |
|---|---|---|
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 | An ad group. | |
ad_group_ad | An ad group ad. | |
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 | A campaign | |
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 | A customer. | |
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 | A Feed. | |
feed_item | A 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. | |
gender_view | A gender 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. | |
label | A label. | |
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. | |
media_file | A media file. | |
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"). | |
topic_view | A topic view. | |
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 | |
video | A video. | |
webpage_view | A webpage view. |
Last updated