JDBC Driver for Google Ads

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Google Ads Views

Name Description
AccessibleBiddingStrategy Represents a view of BiddingStrategies owned by and shared with the customer. In contrast to BiddingStrategy, this resource includes strategies owned by managers of the customer and shared with this customer - in addition to strategies owned by this customer. This resource does not provide metrics and only exposes a limited subset of the BiddingStrategy attributes.
AccountBudget 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. The proposed changes that are pending approval, if any, are found in 'pending_proposal'. Effective details about the budget are found in fields prefixed 'approved_', 'adjusted_' and those without a prefix. Since some effective details may differ from what the user had originally requested (for example, spending limit), these differences are juxtaposed through 'proposed_', 'approved_', and possibly 'adjusted_' fields. This resource is mutated using AccountBudgetProposal and cannot be mutated directly. A budget may have at most one pending proposal at any given time. It is read through pending_proposal. Once approved, a budget may be subject to adjustments, such as credit adjustments. Adjustments create differences between the 'approved' and 'adjusted' fields, which would otherwise be identical.
AccountBudgetProposal An account-level budget proposal. All fields prefixed with 'proposed' may not necessarily be applied directly. For example, proposed spending limits may be adjusted before their application. This is true if the 'proposed' field has an 'approved' counterpart, for example, spending limits. Note that the proposal type (proposal_type) changes which fields are required and which must remain empty.
AccountLink Represents the data sharing connection between a Google Ads account and another account
AdGroup An ad group.
AdGroupAd An ad group ad.
AdGroupAdAssetCombinationView 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.
AdGroupAdAssetView A link between an AdGroupAd and an Asset. Currently we only support AdGroupAdAssetView for AppAds and Responsive Search Ads.
AdGroupAdLabel A relationship between an ad group ad and a label.
AdGroupAsset A link between an ad group and an asset.
AdGroupAssetSet AdGroupAssetSet is the linkage between an ad group and an asset set. Creating an AdGroupAssetSet links an asset set with an ad group.
AdGroupAudienceView 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.
AdGroupBidModifier Represents an ad group bid modifier.
AdGroupCriterion An ad group criterion.
AdGroupCriterionCustomizer A customizer value for the associated CustomizerAttribute at the AdGroupCriterion level.
AdGroupCriterionLabel A relationship between an ad group criterion and a label.
AdGroupCriterionSimulation An ad group criterion simulation. Supported combinations of advertising channel type, criterion type, simulation type, and simulation modification method are detailed below respectively. Hotel AdGroupCriterion simulation operations starting in V5. 1. DISPLAY - KEYWORD - CPC_BID - UNIFORM 2. SEARCH - KEYWORD - CPC_BID - UNIFORM 3. SHOPPING - LISTING_GROUP - CPC_BID - UNIFORM 4. HOTEL - LISTING_GROUP - CPC_BID - UNIFORM 5. HOTEL - LISTING_GROUP - PERCENT_CPC_BID - UNIFORM
AdGroupCustomizer A customizer value for the associated CustomizerAttribute at the AdGroup level.
AdGroupExtensionSetting An ad group extension setting.
AdGroupFeed An ad group feed.
AdGroupLabel A relationship between an ad group and a label.
AdGroupSimulation An ad group simulation. Supported combinations of advertising channel type, simulation type and simulation modification method is detailed below respectively. 1. SEARCH - CPC_BID - DEFAULT 2. SEARCH - CPC_BID - UNIFORM 3. SEARCH - TARGET_CPA - UNIFORM 4. SEARCH - TARGET_ROAS - UNIFORM 5. DISPLAY - CPC_BID - DEFAULT 6. DISPLAY - CPC_BID - UNIFORM 7. DISPLAY - TARGET_CPA - UNIFORM
AdParameter 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.) In the ad the parameters are referenced by a placeholder of the form '{param#:value}'. For example, '{param1:$17}'
AdScheduleView An ad schedule view summarizes the performance of campaigns by AdSchedule criteria.
AgeRangeView An age range view.
Asset Asset 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.
AssetFieldTypeView An asset field type view. This view reports non-overcounted metrics for each asset field type when the asset is used as extension.
AssetGroup An asset group. AssetGroupAsset is used to link an asset to the asset group. AssetGroupSignal is used to associate a signal to an asset group.
AssetGroupAsset AssetGroupAsset is the link between an asset and an asset group. Adding an AssetGroupAsset links an asset with an asset group.
AssetGroupListingGroupFilter AssetGroupListingGroupFilter represents a listing group filter tree node in an asset group.
AssetGroupSignal 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.
AssetSet An asset set representing a collection of assets. Use AssetSetAsset to link an asset to the asset set.
AssetSetAsset AssetSetAsset is the link between an asset and an asset set. Adding an AssetSetAsset links an asset with an asset set.
AssetSetTypeView An asset set type view. This view reports non-overcounted metrics for each asset set type. Child asset set types are not included in this report. Their stats are aggregated under the parent asset set type.
Audience Audience is an effective targeting option that lets you intersect different segment attributes, such as detailed demographics and affinities, to create audiences that represent sections of your target segments.
BatchJob A list of mutates being processed asynchronously. The mutates are uploaded by the user. The mutates themselves aren't readable and the results of the job can only be read using BatchJobService.ListBatchJobResults.
BiddingDataExclusion Represents a bidding data exclusion. See 'About data exclusions' at https://support.google.com/google-ads/answer/10370710.
BiddingSeasonalityAdjustment Represents a bidding seasonality adjustment. See 'About seasonality adjustments' at https://support.google.com/google-ads/answer/10369906.
BiddingStrategy A bidding strategy.
BiddingStrategySimulation A bidding strategy simulation. Supported combinations of simulation type and simulation modification method are detailed below respectively. 1. TARGET_CPA - UNIFORM 2. TARGET_ROAS - UNIFORM
BillingSetup A billing setup, which associates a payments account and an advertiser. A billing setup is specific to one advertiser.
CallView A call view that includes data for call tracking of call-only ads or call extensions.
Campaign A campaign.
CampaignAsset A link between a Campaign and an Asset.
CampaignAssetSet CampaignAssetSet is the linkage between a campaign and an asset set. Adding a CampaignAssetSet links an asset set with a campaign.
CampaignAudienceView 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.
CampaignBidModifier Represents a bid-modifiable only criterion at the campaign level.
CampaignBudget A campaign budget shared amongst various budget recommendation types.
CampaignConversionGoal The biddability setting for the specified campaign only for all conversion actions with a matching category and origin.
CampaignCriterion A campaign criterion.
CampaignCriterionSimulation A campaign criterion simulation. Supported combinations of advertising channel type, criterion ids, simulation type and simulation modification method is detailed below respectively. 1. SEARCH - 30000,30001,30002 - BID_MODIFIER - UNIFORM 2. DISPLAY - 30001 - BID_MODIFIER - UNIFORM
CampaignCustomizer A customizer value for the associated CustomizerAttribute at the Campaign level.
CampaignDraft A campaign draft.
CampaignExperiment This table has been deprecated for Google Ads API v12. An A/B experiment that compares the performance of the base campaign (the control) and a variation of that campaign (the experiment).
CampaignExtensionSetting A campaign extension setting.
CampaignFeed A campaign feed.
CampaignGroup A campaign group.
CampaignLabel Represents a relationship between a campaign and a label.
CampaignSharedSet CampaignSharedSets are used for managing the shared sets associated with a campaign.
CampaignSimulation 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 * MULTI_CHANNEL - TARGET_CPA - UNIFORM * DISCOVERY - TARGET_CPA - DEFAULT * DISPLAY - TARGET_CPA - UNIFORM
CarrierConstant A carrier criterion that can be used in campaign targeting.
ChangeEvent Describes the granular change of returned resource of certain resource types. Changes made through UI, API and new versions of Editor by external users (including external users, and internal users that can be shown externally) in the past 30 days will be shown. The change shows the old values of the changed fields before the change and the new values right after the change. ChangeEvent could have up to 3 minutes delay to reflect a new change.
ChangeStatus Describes the status of returned resource. ChangeStatus could have up to 3 minutes delay to reflect a new change.
ClickView A click view with metrics aggregated at each click level, including both valid and invalid clicks. For non-Search campaigns, metrics.clicks represents the number of valid and invalid interactions. Queries including ClickView must have a filter limiting the results to one day and can be requested for dates back to 90 days before the time of the request.
CombinedAudience Describe a resource for combined audiences which includes different audiences.
ConversionAction A conversion action.
ConversionCustomVariable A conversion custom variable See 'About custom variables for conversions' at https://support.google.com/google-ads/answer/9964350
ConversionGoalCampaignConfig Conversion goal settings for a Campaign.
ConversionValueRule A conversion value rule
ConversionValueRuleSet A conversion value rule set
CurrencyConstant A currency constant.
CustomAudience A custom audience. This is a list of users by interest.
CustomConversionGoal Custom conversion goal that can make arbitrary conversion actions biddable.
Customer A customer.
CustomerAsset A link between a customer and an asset.
CustomerAssetSet CustomerAssetSet is the linkage between a customer and an asset set. Adding a CustomerAssetSet links an asset set with a customer.
CustomerClient 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.
CustomerClientLink The links between customer client accounts and manager accounts
CustomerConversionGoal Biddability control for conversion actions with a matching category and origin.
CustomerCustomizer A customizer value for the associated CustomizerAttribute at the Customer level.
CustomerExtensionSetting A customer extension setting.
CustomerFeed A customer feed.
CustomerLabel 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.
CustomerManagerLink Represents customer-manager link relationship.
CustomerNegativeCriterion A negative criterion for exclusions at the customer level.
CustomerUserAccess Represents the permission of a single user onto a single customer.
CustomerUserAccessInvitation Represent an invitation to a new user on this customer account.
CustomInterest A custom interest. This is a list of users by interest.
CustomizerAttribute 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.
DetailedDemographic A detailed demographic: a particular interest-based vertical to be targeted to reach users based on long-term life facts.
DetailPlacementView A view with metrics aggregated by ad group and URL or YouTube video.
DisplayKeywordView A display keyword view.
DistanceView 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.
DomainCategory 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
DynamicSearchAdsSearchTermView A dynamic search ads search term view.
ExpandedLandingPageView 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.
ExperimentArm A Google ads experiment for users to experiment changes on multiple campaigns, compare the performance, and apply the effective changes.
ExtensionFeedItem An extension feed item.
Feed A feed.
FeedItem A feed item.
FeedItemSet 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.
FeedItemSetLink Represents a link between a FeedItem and a FeedItemSet.
FeedItemTarget A feed item target.
FeedMapping A feed mapping.
FeedPlaceholderView A feed placeholder view.
GenderView A gender view.
GeographicView A 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.
GeoTargetConstant A geo target constant.
GroupPlacementView A group placement view.
HotelGroupView A hotel group view.
HotelPerformanceView A hotel performance view.
HotelReconciliation A hotel reconciliation. It contains conversion information from Hotel bookings to reconcile with advertiser records. These rows may be updated or canceled before billing through Bulk Uploads.
IncomeRangeView An income range view.
KeywordPlan A Keyword Planner plan. Max number of saved keyword plans: 10000. It's possible to remove plans if limit is reached.
KeywordPlanAdGroup A Keyword Planner ad group. Max number of keyword plan ad groups per plan: 200.
KeywordPlanAdGroupKeyword A Keyword Plan ad group keyword. Max number of keyword plan keywords per plan: 10000.
KeywordPlanCampaign A Keyword Plan campaign. Max number of keyword plan campaigns per plan allowed: 1.
KeywordPlanCampaignKeyword A Keyword Plan Campaign keyword. Only negative keywords are supported for Campaign Keyword.
KeywordThemeConstant A Smart Campaign keyword theme constant.
KeywordView A keyword view.
Label A label.
LandingPageView A landing page view with metrics aggregated at the unexpanded final URL level.
LanguageConstant A language.
LeadFormSubmissionData Data from lead form submissions.
LifeEvent A life event: a particular interest-based vertical to be targeted to reach users when they are in the midst of important life milestones.
LocationView A location view summarizes the performance of campaigns by Location criteria.
ManagedPlacementView A managed placement view.
MediaFile A media file.
MobileAppCategoryConstant A mobile application category constant.
MobileDeviceConstant A mobile device constant.
OfflineUserDataJob 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.
OperatingSystemVersionConstant 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
PaidOrganicSearchTermView 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.
ParentalStatusView A parental status view.
PerStoreView An per store view. This view provides per store impression reach and local action conversion stats for advertisers.
ProductBiddingCategoryConstant A Product Bidding Category.
ProductGroupView A product group view.
Recommendation A recommendation.
RemarketingAction 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.
Resources List of resources that can be used in order to generate new Reports or re-generate the old one.
SearchTermView A search term view with metrics aggregated by search term at the ad group level.
SharedCriterion A criterion belonging to a shared set.
SharedSet SharedSets are used for sharing criterion exclusions across multiple campaigns.
ShoppingPerformanceView 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.
SmartCampaignSearchTermView A Smart campaign search term view.
SmartCampaignSetting Settings for configuring Smart campaigns.
ThirdPartyAppAnalyticsLink A data sharing connection, allowing the import of third party app analytics into a Google Ads Customer.
TopicConstant 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').
TopicView A topic view.
UserInterest A user interest: a particular interest-based vertical to be targeted.
UserList A user list. This is a list of users a customer may target.
UserLocationView A 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.
WebpageView A webpage view.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462