ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData Power BI Connector for Google Ads ビュー
| 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. |
| AccountHourlyStatsReport | Account-level performance stats by Ad Network and Device. Hourly data is returned with a default date range of the last 7 days not including today. |
| AccountLink | Represents the data sharing connection between a Google Ads account and another account |
| AccountStatsReport | Account-level performance stats by Ad Network and Device. Daily data is returned with a default date range of the last 7 days not including today. |
| Ad | An ad. |
| 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. The ad_group_criterion report only returns criteria that were explicitly added to the ad group. |
| 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. |
| AdGroupHourlyStatsReport | Ad Group-level performance stats by Ad Network and Device. Hourly data is returned with a default date range of the last 7 days not including today. |
| 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 |
| AdGroupStatsReport | Ad Group-level performance stats by Ad Network and Device. Daily data is returned with a default date range of the last 7 days not including today. |
| 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. |
| AdStatsReport | Ad-level performance stats by Ad Network and Device. Daily data is returned with a default date range of the last 7 days not including today. |
| AgeRangeView | An age range view. |
| AndroidPrivacySharedKeyGoogleAdGroup | An Android privacy shared key view for Google ad group key. |
| AndroidPrivacySharedKeyGoogleCampaign | An Android privacy shared key view for Google campaign key. |
| AndroidPrivacySharedKeyGoogleNetworkType | An Android privacy shared key view for Google network type key. |
| 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. |
| AssetGroupProductGroupView | An asset group product group view. |
| 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. |
| AssetGroupTopCombinationView | A view on the usage of ad group ad asset combination. |
| 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. |
| AudienceStatsReport | Audience-level performance stats by Ad Network and Device. Daily data is returned with a default date range of the last 7 days not including today. |
| 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. |
| CampaignAggregateAssetView | A campaign-level aggregate asset view that shows where the asset is linked, performamce of the asset and stats. |
| 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. |
| CampaignCustomizer | A customizer value for the associated CustomizerAttribute at the Campaign level. |
| CampaignDraft | A campaign draft. |
| CampaignExtensionSetting | A campaign extension setting. |
| CampaignFeed | A campaign feed. |
| CampaignGroup | A campaign group. |
| CampaignHourlyStatsReport | Campaign-level performance stats by Ad Network and Device. Hourly data is returned with a default date range of the last 7 days not including today. |
| CampaignLabel | Represents a relationship between a campaign and a label. |
| CampaignLifecycleGoal | Campaign level customer lifecycle goal settings. |
| CampaignSearchTermInsight | A Campaign search term view. Historical data is available starting March 2023. |
| 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 * MULTI_CHANNEL - TARGET_ROAS - UNIFORM * DISCOVERY - TARGET_CPA - DEFAULT * DISPLAY - TARGET_CPA - UNIFORM * PERFORMANCE_MAX - TARGET_CPA - UNIFORM * PERFORMANCE_MAX - TARGET_ROAS - UNIFORM * PERFORMANCE_MAX - BUDGET - UNIFORM |
| CampaignStatsReport | Campaign-level performance stats by Ad Network and Device. Daily data is returned with a default date range of the last 7 days not including today. |
| CarrierConstant | A carrier criterion that can be used in campaign targeting. |
| ChangeEvent | Describes the granular change of returned resources of certain resource types. Changes made through the UI or API in the past 30 days are included. Previous and new values of the changed fields are shown. 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. |
| ChannelAggregateAssetView | A channel-level aggregate asset view that shows where the asset is linked, performamce of the asset and stats. |
| 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. |
| ClickViewFilteredReport | 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 | Represents customer client link relationship. |
| 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. |
| CustomerLifecycleGoal | Account level customer lifecycle goal settings. |
| CustomerManagerLink | Represents customer-manager link relationship. |
| CustomerNegativeCriterion | A negative criterion for exclusions at the customer level. |
| CustomerSearchTermInsight | A Customer search term view. Historical data is available starting March 2023. |
| 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. The gender_view resource reflects the effective serving state, rather than what criteria were added. An ad group without gender criteria by default shows to all genders, so all genders appear in gender_view with stats. |
| 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. |
| KeywordStatsReport | Keyword-level performance stats by Ad Network and Device. Daily data is returned with a default date range of the last 7 days not including today. |
| 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. |
| LocalServicesEmployee | A local services employee resource. |
| LocalServicesLead | Data from Local Services Lead. Contains details of Lead which is generated when user calls, messages or books service from advertiser. More info: https://ads.google.com/local-services-ads |
| LocalServicesLeadConversation | Data from Local Services Lead Conversation. Contains details of Lead Conversation which is generated when user calls, messages or books service from advertiser. These are appended to a Lead. More info: https://ads.google.com/local-services-ads |
| LocalServicesVerificationArtifact | A local services verification resource. |
| LocationView | A location view summarizes the performance of campaigns by a Location criterion. If no Location criterion is set, no results are returned; instead, use geographic_view or user_location_view for visitor location data. |
| ManagedPlacementView | A managed placement view. |
| MediaFile | A media file. |
| MobileAppCategoryConstant | A mobile application category constant. |
| MobileDeviceConstant | A mobile device constant. |
| OfflineConversionUploadClientSummary | Offline conversion upload summary at customer level. |
| OfflineConversionUploadConversionActionSummary | Offline conversion upload summary at conversion action level. |
| 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 | A per store view. This view provides per store impression reach and local action conversion stats for advertisers. |
| ProductCategoryConstant | A Product Category. |
| ProductGroupView | A product group view. |
| ProductLink | Represents the data sharing connection between a Google Ads customer and another product. |
| ProductLinkInvitation | Represents an invitation for data sharing connection between a Google Ads account and another account. |
| QualifyingQuestion | Qualifying Questions for Lead Form. |
| Recommendation | A recommendation. |
| RecommendationSubscription | Recommendation Subscription resource |
| 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. |
| ShoppingProduct | A shopping product from Google Merchant Center that can be advertised by campaigns. The resource returns currently existing products from Google Merchant Center accounts linked with the customer. A campaign includes a product by specifying its merchant id (or, if available, the Multi Client Account id of the merchant) in the ShoppingSetting, and can limit the inclusion to products having a specified feed label. Standard Shopping campaigns can also limit the inclusion through a campaign_criterion.listing_scope. Queries to this resource specify a scope: Account: - Filters on campaigns or ad groups are not specified. - All products from the linked Google Merchant Center accounts are returned. - Metrics and some fields (see the per-field documentation) are aggregated across all Shopping and Performance Max campaigns that include a product. Campaign: - An equality filter on campaign is specified. Supported campaign types are Shopping, Performance Max, Demand Gen, Video. - Only products that are included by the specified campaign are returned. - Metrics and some fields (see the per-field documentation) are restricted to the specified campaign. Ad group: - An equality filter on ad group and campaign is specified. Supported campaign types are Shopping, Demand Gen, Video. - Only products that are included by the specified campaign are returned. - Metrics and some fields (see the per-field documentation) are restricted to the specified ad group. Note that segmentation by date segments is not permitted and will return UNSUPPORTED_DATE_SEGMENTATION error. On the other hand, filtering on date segments is allowed. |
| 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. |
| TravelActivityGroupView | A travel activity group view. |
| TravelActivityPerformanceView | A travel activity performance 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. |
| UserListCustomerType | A user list customer type |
| 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. |