Power BI Connector for Google Ads

Build 24.0.9062

AdGroupCriterion

An ad group criterion. The ad_group_criterion report only returns criteria that were explicitly added to the ad group.

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.

To use the nondefault fields, explicitly select them in your query.

Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.

Columns

Name Type Behavior Description
AdGroupCriterionAdGroup String ATTRIBUTE Immutable. The ad group to which the criterion belongs.
AdGroupCriterionAgeRangeType String ATTRIBUTE Type of the age range.

使用できる値は次のとおりです。AGE_RANGE_18_24, AGE_RANGE_25_34, AGE_RANGE_35_44, AGE_RANGE_45_54, AGE_RANGE_55_64, AGE_RANGE_65_UP, AGE_RANGE_UNDETERMINED, UNKNOWN, UNSPECIFIED

AdGroupCriterionAppPaymentModelType String ATTRIBUTE Type of the app payment model.

使用できる値は次のとおりです。PAID, UNKNOWN, UNSPECIFIED

AdGroupCriterionApprovalStatus String ATTRIBUTE Output only. Approval status of the criterion.

使用できる値は次のとおりです。APPROVED, DISAPPROVED, PENDING_REVIEW, UNDER_REVIEW, UNKNOWN, UNSPECIFIED

AdGroupCriterionAudienceAudience String ATTRIBUTE The Audience resource name.
AdGroupCriterionBidModifier Double ATTRIBUTE The modifier for the bid when the criterion matches. The modifier must be in the range: 0.1 - 10.0. Most targetable criteria types support modifiers.
AdGroupCriterionCombinedAudienceCombinedAudience String ATTRIBUTE The CombinedAudience resource name.
AdGroupCriterionCpcBidMicros Long ATTRIBUTE The CPC (cost-per-click) bid.
AdGroupCriterionCpmBidMicros Long ATTRIBUTE The CPM (cost-per-thousand viewable impressions) bid.
AdGroupCriterionCpvBidMicros Long ATTRIBUTE The CPV (cost-per-view) bid.
AdGroupCriterionCriterionId Long ATTRIBUTE Output only. The ID of the criterion. This field is ignored for mutates.
AdGroupCriterionCustomAffinityCustomAffinity String ATTRIBUTE The CustomInterest resource name.
AdGroupCriterionCustomAudienceCustomAudience String ATTRIBUTE The CustomAudience resource name.
AdGroupCriterionCustomIntentCustomIntent String ATTRIBUTE The CustomInterest resource name.
AdGroupCriterionDisapprovalReasons String ATTRIBUTE Output only. List of disapproval reasons of the criterion. The different reasons for disapproving a criterion can be found here: https://support.google.com/adspolicy/answer/6008942 This field is read-only.
AdGroupCriterionDisplayName String ATTRIBUTE Output only. The display name of the criterion. This field is ignored for mutates.
AdGroupCriterionEffectiveCpcBidMicros Long ATTRIBUTE Output only. The effective CPC (cost-per-click) bid.
AdGroupCriterionEffectiveCpcBidSource String ATTRIBUTE Output only. Source of the effective CPC bid.

使用できる値は次のとおりです。AD_GROUP, AD_GROUP_CRITERION, CAMPAIGN_BIDDING_STRATEGY, UNKNOWN, UNSPECIFIED

AdGroupCriterionEffectiveCpmBidMicros Long ATTRIBUTE Output only. The effective CPM (cost-per-thousand viewable impressions) bid.
AdGroupCriterionEffectiveCpmBidSource String ATTRIBUTE Output only. Source of the effective CPM bid.

使用できる値は次のとおりです。AD_GROUP, AD_GROUP_CRITERION, CAMPAIGN_BIDDING_STRATEGY, UNKNOWN, UNSPECIFIED

AdGroupCriterionEffectiveCpvBidMicros Long ATTRIBUTE Output only. The effective CPV (cost-per-view) bid.
AdGroupCriterionEffectiveCpvBidSource String ATTRIBUTE Output only. Source of the effective CPV bid.

使用できる値は次のとおりです。AD_GROUP, AD_GROUP_CRITERION, CAMPAIGN_BIDDING_STRATEGY, UNKNOWN, UNSPECIFIED

AdGroupCriterionEffectivePercentCpcBidMicros Long ATTRIBUTE Output only. The effective Percent CPC bid amount.
AdGroupCriterionEffectivePercentCpcBidSource String ATTRIBUTE Output only. Source of the effective Percent CPC bid.

使用できる値は次のとおりです。AD_GROUP, AD_GROUP_CRITERION, CAMPAIGN_BIDDING_STRATEGY, UNKNOWN, UNSPECIFIED

AdGroupCriterionFinalMobileUrls String ATTRIBUTE The list of possible final mobile URLs after all cross-domain redirects.
AdGroupCriterionFinalUrlSuffix String ATTRIBUTE URL template for appending params to final URL.
AdGroupCriterionFinalUrls String ATTRIBUTE The list of possible final URLs after all cross-domain redirects for the ad.
AdGroupCriterionGenderType String ATTRIBUTE Type of the gender.

使用できる値は次のとおりです。FEMALE, MALE, UNDETERMINED, UNKNOWN, UNSPECIFIED

AdGroupCriterionIncomeRangeType String ATTRIBUTE Type of the income range.

使用できる値は次のとおりです。INCOME_RANGE_0_50, INCOME_RANGE_50_60, INCOME_RANGE_60_70, INCOME_RANGE_70_80, INCOME_RANGE_80_90, INCOME_RANGE_90_UP, INCOME_RANGE_UNDETERMINED, UNKNOWN, UNSPECIFIED

AdGroupCriterionKeywordMatchType String ATTRIBUTE The match type of the keyword.

使用できる値は次のとおりです。BROAD, EXACT, PHRASE, UNKNOWN, UNSPECIFIED

AdGroupCriterionKeywordText String ATTRIBUTE The text of the keyword (at most 80 characters and 10 words).
AdGroupCriterionLabels String ATTRIBUTE Output only. The resource names of labels attached to this ad group criterion.
AdGroupCriterionLanguageLanguageConstant String ATTRIBUTE The language constant resource name.
AdGroupCriterionListingGroupCaseValueActivityCityValue String ATTRIBUTE String value of the activity city. The Geo Target Constant resource name.
AdGroupCriterionListingGroupCaseValueActivityCountryValue String ATTRIBUTE String value of the activity country. The Geo Target Constant resource name.
AdGroupCriterionListingGroupCaseValueActivityIdValue String ATTRIBUTE String value of the activity ID.
AdGroupCriterionListingGroupCaseValueActivityRatingValue Long ATTRIBUTE Long value of the activity rating.
AdGroupCriterionListingGroupCaseValueActivityStateValue String ATTRIBUTE String value of the activity state. The Geo Target Constant resource name.
AdGroupCriterionListingGroupCaseValueHotelCityCityCriterion String ATTRIBUTE The Geo Target Constant resource name.
AdGroupCriterionListingGroupCaseValueHotelClassValue Long ATTRIBUTE Long value of the hotel class.
AdGroupCriterionListingGroupCaseValueHotelCountryRegionCountryRegionCriterion String ATTRIBUTE The Geo Target Constant resource name.
AdGroupCriterionListingGroupCaseValueHotelIdValue String ATTRIBUTE String value of the hotel ID.
AdGroupCriterionListingGroupCaseValueHotelStateStateCriterion String ATTRIBUTE The Geo Target Constant resource name.
AdGroupCriterionListingGroupCaseValueProductBrandValue String ATTRIBUTE String value of the product brand.
AdGroupCriterionListingGroupCaseValueProductCategoryCategoryId Long ATTRIBUTE ID of the product category. This ID is equivalent to the google_product_category ID as described in this article: https://support.google.com/merchants/answer/6324436
AdGroupCriterionListingGroupCaseValueProductCategoryLevel String ATTRIBUTE Level of the product category.

使用できる値は次のとおりです。LEVEL1, LEVEL2, LEVEL3, LEVEL4, LEVEL5, UNKNOWN, UNSPECIFIED

AdGroupCriterionListingGroupCaseValueProductChannelChannel String ATTRIBUTE Value of the locality.

使用できる値は次のとおりです。LOCAL, ONLINE, UNKNOWN, UNSPECIFIED

AdGroupCriterionListingGroupCaseValueProductChannelExclusivityChannelExclusivity String ATTRIBUTE Value of the availability.

使用できる値は次のとおりです。MULTI_CHANNEL, SINGLE_CHANNEL, UNKNOWN, UNSPECIFIED

AdGroupCriterionListingGroupCaseValueProductConditionCondition String ATTRIBUTE Value of the condition.

使用できる値は次のとおりです。NEW, REFURBISHED, UNKNOWN, UNSPECIFIED, USED

AdGroupCriterionListingGroupCaseValueProductCustomAttributeIndex String ATTRIBUTE Indicates the index of the custom attribute.

使用できる値は次のとおりです。INDEX0, INDEX1, INDEX2, INDEX3, INDEX4, UNKNOWN, UNSPECIFIED

AdGroupCriterionListingGroupCaseValueProductCustomAttributeValue String ATTRIBUTE String value of the product custom attribute.
AdGroupCriterionListingGroupCaseValueProductItemIdValue String ATTRIBUTE Value of the id.
AdGroupCriterionListingGroupCaseValueProductTypeLevel String ATTRIBUTE Level of the type.

使用できる値は次のとおりです。LEVEL1, LEVEL2, LEVEL3, LEVEL4, LEVEL5, UNKNOWN, UNSPECIFIED

AdGroupCriterionListingGroupCaseValueProductTypeValue String ATTRIBUTE Value of the type.
AdGroupCriterionListingGroupParentAdGroupCriterion String ATTRIBUTE Resource name of ad group criterion which is the parent listing group subdivision. Null for the root group.
AdGroupCriterionListingGroupPath String ATTRIBUTE The path of dimensions defining this listing group.
AdGroupCriterionListingGroupType String ATTRIBUTE Type of the listing group.

使用できる値は次のとおりです。SUBDIVISION, UNIT, UNKNOWN, UNSPECIFIED

AdGroupCriterionLocationGeoTargetConstant String ATTRIBUTE The geo target constant resource name.
AdGroupCriterionMobileAppCategoryMobileAppCategoryConstant String ATTRIBUTE The mobile app category constant resource name.
AdGroupCriterionMobileApplicationAppId String ATTRIBUTE A string that uniquely identifies a mobile application to Google Ads API. The format of this string is '{platform}-{platform_native_id}', where platform is '1' for iOS apps and '2' for Android apps, and where platform_native_id is the mobile application identifier native to the corresponding platform. For iOS, this native identifier is the 9 digit string that appears at the end of an App Store URL (for example, '476943146' for 'Flood-It! 2' whose App Store link is 'http://itunes.apple.com/us/app/flood-it!-2/id476943146'). For Android, this native identifier is the application's package name (for example, 'com.labpixies.colordrips' for 'Color Drips' given Google Play link 'https://play.google.com/store/apps/details?id=com.labpixies.colordrips'). A well formed app id for Google Ads API would thus be '1-476943146' for iOS and '2-com.labpixies.colordrips' for Android. This field is required and must be set in CREATE operations.
AdGroupCriterionMobileApplicationName String ATTRIBUTE Name of this mobile application.
AdGroupCriterionNegative Bool ATTRIBUTE Immutable. Whether to target (false) or exclude (true) the criterion. This field is immutable. To switch a criterion from positive to negative, remove then re-add it.
AdGroupCriterionParentalStatusType String ATTRIBUTE Type of the parental status.

使用できる値は次のとおりです。NOT_A_PARENT, PARENT, UNDETERMINED, UNKNOWN, UNSPECIFIED

AdGroupCriterionPercentCpcBidMicros Long ATTRIBUTE The CPC bid amount, expressed as a fraction of the advertised price for some good or service. The valid range for the fraction is [0,1) and the value stored here is 1,000,000 * [fraction].
AdGroupCriterionPlacementUrl String ATTRIBUTE URL of the placement. For example, 'http://www.domain.com'.
AdGroupCriterionPositionEstimatesEstimatedAddClicksAtFirstPositionCpc Long ATTRIBUTE Output only. Estimate of how many clicks per week you might get by changing your keyword bid to the value in first_position_cpc_micros.
AdGroupCriterionPositionEstimatesEstimatedAddCostAtFirstPositionCpc Long ATTRIBUTE Output only. Estimate of how your cost per week might change when changing your keyword bid to the value in first_position_cpc_micros.
AdGroupCriterionPositionEstimatesFirstPageCpcMicros Long ATTRIBUTE Output only. The estimate of the CPC bid required for ad to be shown on first page of search results.
AdGroupCriterionPositionEstimatesFirstPositionCpcMicros Long ATTRIBUTE Output only. The estimate of the CPC bid required for ad to be displayed in first position, at the top of the first page of search results.
AdGroupCriterionPositionEstimatesTopOfPageCpcMicros Long ATTRIBUTE Output only. The estimate of the CPC bid required for ad to be displayed at the top of the first page of search results.
AdGroupCriterionPrimaryStatus String ATTRIBUTE Output only. The primary status for the ad group criterion.

使用できる値は次のとおりです。ELIGIBLE, NOT_ELIGIBLE, PAUSED, PENDING, REMOVED, UNKNOWN, UNSPECIFIED

AdGroupCriterionPrimaryStatusReasons String ATTRIBUTE Output only. The primary status reasons for the ad group criterion.

使用できる値は次のとおりです。AD_GROUP_CRITERION_BELOW_FIRST_PAGE_BID, AD_GROUP_CRITERION_DISAPPROVED, AD_GROUP_CRITERION_LOW_QUALITY, AD_GROUP_CRITERION_NEGATIVE, AD_GROUP_CRITERION_PAUSED, AD_GROUP_CRITERION_PAUSED_DUE_TO_LOW_ACTIVITY, AD_GROUP_CRITERION_PENDING_REVIEW, AD_GROUP_CRITERION_RARELY_SERVED, AD_GROUP_CRITERION_REMOVED, AD_GROUP_CRITERION_RESTRICTED, AD_GROUP_CRITERION_UNDER_REVIEW, AD_GROUP_PAUSED, AD_GROUP_REMOVED, CAMPAIGN_CRITERION_NEGATIVE, CAMPAIGN_ENDED, CAMPAIGN_PAUSED, CAMPAIGN_PENDING, CAMPAIGN_REMOVED, UNKNOWN, UNSPECIFIED

AdGroupCriterionQualityInfoCreativeQualityScore String ATTRIBUTE Output only. The performance of the ad compared to other advertisers.

使用できる値は次のとおりです。ABOVE_AVERAGE, AVERAGE, BELOW_AVERAGE, UNKNOWN, UNSPECIFIED

AdGroupCriterionQualityInfoPostClickQualityScore String ATTRIBUTE Output only. The quality score of the landing page.

使用できる値は次のとおりです。ABOVE_AVERAGE, AVERAGE, BELOW_AVERAGE, UNKNOWN, UNSPECIFIED

AdGroupCriterionQualityInfoQualityScore Int ATTRIBUTE Output only. The quality score. This field may not be populated if Google does not have enough information to determine a value.
AdGroupCriterionQualityInfoSearchPredictedCtr String ATTRIBUTE Output only. The click-through rate compared to that of other advertisers.

使用できる値は次のとおりです。ABOVE_AVERAGE, AVERAGE, BELOW_AVERAGE, UNKNOWN, UNSPECIFIED

AdGroupCriterionResourceName String ATTRIBUTE Immutable. The resource name of the ad group criterion. Ad group criterion resource names have the form: customers/{customer_id}/adGroupCriteria/{ad_group_id}~{criterion_id}
AdGroupCriterionStatus String ATTRIBUTE The status of the criterion. This is the status of the ad group criterion entity, set by the client. Note: UI reports may incorporate additional information that affects whether a criterion is eligible to run. In some cases a criterion that's REMOVED in the API can still show as enabled in the UI. For example, campaigns by default show to users of all age ranges unless excluded. The UI will show each age range as 'enabled', since they're eligible to see the ads; but AdGroupCriterion.status will show 'removed', since no positive criterion was added.

使用できる値は次のとおりです。ENABLED, PAUSED, REMOVED, UNKNOWN, UNSPECIFIED

AdGroupCriterionSystemServingStatus String ATTRIBUTE Output only. Serving status of the criterion.

使用できる値は次のとおりです。ELIGIBLE, RARELY_SERVED, UNKNOWN, UNSPECIFIED

AdGroupCriterionTopicPath String ATTRIBUTE The category to target or exclude. Each subsequent element in the array describes a more specific sub-category. For example, 'Pets & Animals', 'Pets', 'Dogs' represents the 'Pets & Animals/Pets/Dogs' category.
AdGroupCriterionTopicTopicConstant String ATTRIBUTE The Topic Constant resource name.
AdGroupCriterionTrackingUrlTemplate String ATTRIBUTE The URL template for constructing a tracking URL.
AdGroupCriterionType String ATTRIBUTE Output only. The type of the criterion.

使用できる値は次のとおりです。AD_SCHEDULE, AGE_RANGE, APP_PAYMENT_MODEL, AUDIENCE, BRAND, BRAND_LIST, CARRIER, COMBINED_AUDIENCE, CONTENT_LABEL, CUSTOM_AFFINITY, CUSTOM_AUDIENCE, CUSTOM_INTENT, DEVICE, GENDER, INCOME_RANGE, IP_BLOCK, KEYWORD, KEYWORD_THEME, LANGUAGE, LIFE_EVENT, LISTING_GROUP, LISTING_SCOPE, LOCAL_SERVICE_ID, LOCATION, LOCATION_GROUP, MOBILE_APPLICATION, MOBILE_APP_CATEGORY, MOBILE_DEVICE, NEGATIVE_KEYWORD_LIST, OPERATING_SYSTEM_VERSION, PARENTAL_STATUS, PLACEMENT, PROXIMITY, SEARCH_THEME, TOPIC, UNKNOWN, UNSPECIFIED, USER_INTEREST, USER_LIST, WEBPAGE, YOUTUBE_CHANNEL, YOUTUBE_VIDEO

AdGroupCriterionUrlCustomParameters String ATTRIBUTE The list of mappings used to substitute custom parameter tags in a tracking_url_template, final_urls, or mobile_final_urls.
AdGroupCriterionUserInterestUserInterestCategory String ATTRIBUTE The UserInterest resource name.
AdGroupCriterionUserListUserList String ATTRIBUTE The User List resource name.
AdGroupCriterionWebpageConditions String ATTRIBUTE Conditions, or logical expressions, for webpage targeting. The list of webpage targeting conditions are and-ed together when evaluated for targeting. An empty list of conditions indicates all pages of the campaign's website are targeted. This field is required for CREATE operations and is prohibited on UPDATE operations.
AdGroupCriterionWebpageCoveragePercentage Double ATTRIBUTE Website criteria coverage percentage. This is the computed percentage of website coverage based on the website target, negative website target and negative keywords in the ad group and campaign. For instance, when coverage returns as 1, it indicates it has 100% coverage. This field is read-only.
AdGroupCriterionWebpageCriterionName String ATTRIBUTE The name of the criterion that is defined by this parameter. The name value will be used for identifying, sorting and filtering criteria with this type of parameters. This field is required for CREATE operations and is prohibited on UPDATE operations.
AdGroupCriterionWebpageSampleSampleUrls String ATTRIBUTE Webpage sample urls
AdGroupCriterionYoutubeChannelChannelId String ATTRIBUTE The YouTube uploader channel id or the channel code of a YouTube channel.
AdGroupCriterionYoutubeVideoVideoId String ATTRIBUTE YouTube video id as it appears on the YouTube watch page.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062