AdGroupCriterion

An ad group criterion.

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

AdGroup column for table AdGroupCriterion

AdGroupCriterionAgeRangeType

String

Attribute

AgeRangeType column for table AdGroupCriterion

AdGroupCriterionAppPaymentModelType

String

Attribute

AppPaymentModelType column for table AdGroupCriterion

AdGroupCriterionApprovalStatus

String

Attribute

ApprovalStatus column for table AdGroupCriterion

AdGroupCriterionBidModifier

Double

Attribute

BidModifier column for table AdGroupCriterion

AdGroupCriterionCombinedAudienceCombinedAudience

String

Attribute

CombinedAudienceCombinedAudience column for table AdGroupCriterion

AdGroupCriterionCpcBidMicros

Long

Attribute

CpcBidMicros column for table AdGroupCriterion

AdGroupCriterionCpmBidMicros

Long

Attribute

CpmBidMicros column for table AdGroupCriterion

AdGroupCriterionCpvBidMicros

Long

Attribute

CpvBidMicros column for table AdGroupCriterion

AdGroupCriterionCriterionId

Long

Attribute

CriterionId column for table AdGroupCriterion

AdGroupCriterionCustomAffinityCustomAffinity

String

Attribute

CustomAffinityCustomAffinity column for table AdGroupCriterion

AdGroupCriterionCustomAudienceCustomAudience

String

Attribute

CustomAudienceCustomAudience column for table AdGroupCriterion

AdGroupCriterionCustomIntentCustomIntent

String

Attribute

CustomIntentCustomIntent column for table AdGroupCriterion

AdGroupCriterionDisapprovalReasons

String

Attribute

DisapprovalReasons column for table AdGroupCriterion

AdGroupCriterionDisplayName

String

Attribute

DisplayName column for table AdGroupCriterion

AdGroupCriterionEffectiveCpcBidMicros

Long

Attribute

EffectiveCpcBidMicros column for table AdGroupCriterion

AdGroupCriterionEffectiveCpcBidSource

String

Attribute

EffectiveCpcBidSource column for table AdGroupCriterion

AdGroupCriterionEffectiveCpmBidMicros

Long

Attribute

EffectiveCpmBidMicros column for table AdGroupCriterion

AdGroupCriterionEffectiveCpmBidSource

String

Attribute

EffectiveCpmBidSource column for table AdGroupCriterion

AdGroupCriterionEffectiveCpvBidMicros

Long

Attribute

EffectiveCpvBidMicros column for table AdGroupCriterion

AdGroupCriterionEffectiveCpvBidSource

String

Attribute

EffectiveCpvBidSource column for table AdGroupCriterion

AdGroupCriterionEffectivePercentCpcBidMicros

Long

Attribute

EffectivePercentCpcBidMicros column for table AdGroupCriterion

AdGroupCriterionEffectivePercentCpcBidSource

String

Attribute

EffectivePercentCpcBidSource column for table AdGroupCriterion

AdGroupCriterionFinalMobileUrls

String

Attribute

FinalMobileUrls column for table AdGroupCriterion

AdGroupCriterionFinalUrlSuffix

String

Attribute

FinalUrlSuffix column for table AdGroupCriterion

AdGroupCriterionFinalUrls

String

Attribute

FinalUrls column for table AdGroupCriterion

AdGroupCriterionGenderType

String

Attribute

GenderType column for table AdGroupCriterion

AdGroupCriterionIncomeRangeType

String

Attribute

IncomeRangeType column for table AdGroupCriterion

AdGroupCriterionKeywordMatchType

String

Attribute

KeywordMatchType column for table AdGroupCriterion

AdGroupCriterionKeywordText

String

Attribute

KeywordText column for table AdGroupCriterion

AdGroupCriterionLabels

String

Attribute

Labels column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueHotelCityCityCriterion

String

Attribute

ListingGroupCaseValueHotelCityCityCriterion column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueHotelClassValue

Long

Attribute

ListingGroupCaseValueHotelClassValue column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueHotelCountryRegionCountryRegionCriterion

String

Attribute

ListingGroupCaseValueHotelCountryRegionCountryRegionCriterion column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueHotelIdValue

String

Attribute

ListingGroupCaseValueHotelIdValue column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueHotelStateStateCriterion

String

Attribute

ListingGroupCaseValueHotelStateStateCriterion column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductBiddingCategoryCountryCode

String

Attribute

ListingGroupCaseValueProductBiddingCategoryCountryCode column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductBiddingCategoryId

Long

Attribute

ListingGroupCaseValueProductBiddingCategoryId column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductBiddingCategoryLevel

String

Attribute

ListingGroupCaseValueProductBiddingCategoryLevel column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductBrandValue

String

Attribute

ListingGroupCaseValueProductBrandValue column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductChannelChannel

String

Attribute

ListingGroupCaseValueProductChannelChannel column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductChannelExclusivityChannelExclusivity

String

Attribute

ListingGroupCaseValueProductChannelExclusivityChannelExclusivity column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductConditionCondition

String

Attribute

ListingGroupCaseValueProductConditionCondition column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductCustomAttributeIndex

String

Attribute

ListingGroupCaseValueProductCustomAttributeIndex column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductCustomAttributeValue

String

Attribute

ListingGroupCaseValueProductCustomAttributeValue column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductItemIdValue

String

Attribute

ListingGroupCaseValueProductItemIdValue column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductTypeLevel

String

Attribute

ListingGroupCaseValueProductTypeLevel column for table AdGroupCriterion

AdGroupCriterionListingGroupCaseValueProductTypeValue

String

Attribute

ListingGroupCaseValueProductTypeValue column for table AdGroupCriterion

AdGroupCriterionListingGroupParentAdGroupCriterion

String

Attribute

ListingGroupParentAdGroupCriterion column for table AdGroupCriterion

AdGroupCriterionListingGroupType

String

Attribute

ListingGroupType column for table AdGroupCriterion

AdGroupCriterionMobileAppCategoryMobileAppCategoryConstant

String

Attribute

MobileAppCategoryMobileAppCategoryConstant column for table AdGroupCriterion

AdGroupCriterionMobileApplicationAppId

String

Attribute

MobileApplicationAppId column for table AdGroupCriterion

AdGroupCriterionMobileApplicationName

String

Attribute

MobileApplicationName column for table AdGroupCriterion

AdGroupCriterionNegative

Bool

Attribute

Negative column for table AdGroupCriterion

AdGroupCriterionParentalStatusType

String

Attribute

ParentalStatusType column for table AdGroupCriterion

AdGroupCriterionPercentCpcBidMicros

Long

Attribute

PercentCpcBidMicros column for table AdGroupCriterion

AdGroupCriterionPlacementUrl

String

Attribute

PlacementUrl column for table AdGroupCriterion

AdGroupCriterionPositionEstimatesEstimatedAddClicksAtFirstPositionCpc

Long

Attribute

PositionEstimatesEstimatedAddClicksAtFirstPositionCpc column for table AdGroupCriterion

AdGroupCriterionPositionEstimatesEstimatedAddCostAtFirstPositionCpc

Long

Attribute

PositionEstimatesEstimatedAddCostAtFirstPositionCpc column for table AdGroupCriterion

AdGroupCriterionPositionEstimatesFirstPageCpcMicros

Long

Attribute

PositionEstimatesFirstPageCpcMicros column for table AdGroupCriterion

AdGroupCriterionPositionEstimatesFirstPositionCpcMicros

Long

Attribute

PositionEstimatesFirstPositionCpcMicros column for table AdGroupCriterion

AdGroupCriterionPositionEstimatesTopOfPageCpcMicros

Long

Attribute

PositionEstimatesTopOfPageCpcMicros column for table AdGroupCriterion

AdGroupCriterionQualityInfoCreativeQualityScore

String

Attribute

QualityInfoCreativeQualityScore column for table AdGroupCriterion

AdGroupCriterionQualityInfoPostClickQualityScore

String

Attribute

QualityInfoPostClickQualityScore column for table AdGroupCriterion

AdGroupCriterionQualityInfoQualityScore

Int

Attribute

QualityInfoQualityScore column for table AdGroupCriterion

AdGroupCriterionQualityInfoSearchPredictedCtr

String

Attribute

QualityInfoSearchPredictedCtr column for table AdGroupCriterion

AdGroupCriterionResourceName

String

Attribute

ResourceName column for table AdGroupCriterion

AdGroupCriterionStatus

String

Attribute

Status column for table AdGroupCriterion

AdGroupCriterionSystemServingStatus

String

Attribute

SystemServingStatus column for table AdGroupCriterion

AdGroupCriterionTopicPath

String

Attribute

TopicPath column for table AdGroupCriterion

AdGroupCriterionTopicTopicConstant

String

Attribute

TopicTopicConstant column for table AdGroupCriterion

AdGroupCriterionTrackingUrlTemplate

String

Attribute

TrackingUrlTemplate column for table AdGroupCriterion

AdGroupCriterionType

String

Attribute

Type column for table AdGroupCriterion

AdGroupCriterionUrlCustomParameters

String

Attribute

UrlCustomParameters column for table AdGroupCriterion

AdGroupCriterionUserInterestUserInterestCategory

String

Attribute

UserInterestUserInterestCategory column for table AdGroupCriterion

AdGroupCriterionUserListUserList

String

Attribute

UserListUserList column for table AdGroupCriterion

AdGroupCriterionWebpageConditions

String

Attribute

WebpageConditions column for table AdGroupCriterion

AdGroupCriterionWebpageCoveragePercentage

Double

Attribute

WebpageCoveragePercentage column for table AdGroupCriterion

AdGroupCriterionWebpageCriterionName

String

Attribute

WebpageCriterionName column for table AdGroupCriterion

AdGroupCriterionWebpageSampleSampleUrls

String

Attribute

WebpageSampleSampleUrls column for table AdGroupCriterion

AdGroupCriterionYoutubeChannelChannelId

String

Attribute

YoutubeChannelChannelId column for table AdGroupCriterion

AdGroupCriterionYoutubeVideoVideoId

String

Attribute

YoutubeVideoVideoId column for table AdGroupCriterion

CustomerId

Long

Attribute

ClientCustomerId column for table AdGroupCriterion

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

ManagerId

Long

Id of the manager account on behalf of which you are requesting customer data.

Last updated