AdGroup

An 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

AdGroupAdRotationMode

String

Attribute

AdRotationMode column for table AdGroup

AdGroupBaseAdGroup

String

Attribute

BaseAdGroup column for table AdGroup

AdGroupCampaign

String

Attribute

Campaign column for table AdGroup

AdGroupCpcBidMicros

Long

Attribute

CpcBidMicros column for table AdGroup

AdGroupCpmBidMicros

Long

Attribute

CpmBidMicros column for table AdGroup

AdGroupCpvBidMicros

Long

Attribute

CpvBidMicros column for table AdGroup

AdGroupDisplayCustomBidDimension

String

Attribute

DisplayCustomBidDimension column for table AdGroup

AdGroupEffectiveTargetCpaMicros

Long

Attribute

EffectiveTargetCpaMicros column for table AdGroup

AdGroupEffectiveTargetCpaSource

String

Attribute

EffectiveTargetCpaSource column for table AdGroup

AdGroupEffectiveTargetRoas

Double

Attribute

EffectiveTargetRoas column for table AdGroup

AdGroupEffectiveTargetRoasSource

String

Attribute

EffectiveTargetRoasSource column for table AdGroup

AdGroupExcludedParentAssetFieldTypes

String

Attribute

ExcludedParentAssetFieldTypes column for table AdGroup

AdGroupExplorerAutoOptimizerSettingOptIn

Bool

Attribute

ExplorerAutoOptimizerSettingOptIn column for table AdGroup

AdGroupFinalUrlSuffix

String

Attribute

FinalUrlSuffix column for table AdGroup

AdGroupId

Long

Attribute

Id column for table AdGroup

AdGroupLabels

String

Attribute

Labels column for table AdGroup

AdGroupName

String

Attribute

Name column for table AdGroup

AdGroupPercentCpcBidMicros

Long

Attribute

PercentCpcBidMicros column for table AdGroup

AdGroupResourceName

String

Attribute

ResourceName column for table AdGroup

AdGroupStatus

String

Attribute

Status column for table AdGroup

AdGroupTargetCpaMicros

Long

Attribute

TargetCpaMicros column for table AdGroup

AdGroupTargetCpmMicros

Long

Attribute

TargetCpmMicros column for table AdGroup

AdGroupTargetRoas

Double

Attribute

TargetRoas column for table AdGroup

AdGroupTargetingSettingTargetRestrictions

String

Attribute

TargetingSettingTargetRestrictions column for table AdGroup

AdGroupTrackingUrlTemplate

String

Attribute

TrackingUrlTemplate column for table AdGroup

AdGroupType

String

Attribute

Type column for table AdGroup

AdGroupUrlCustomParameters

String

Attribute

UrlCustomParameters column for table AdGroup

CustomerId

Long

Attribute

ClientCustomerId column for table AdGroup

AbsoluteTopImpressionPercentage

Double

Metric

AbsoluteTopImpressionPercentage column for table Metrics

ActiveViewCpm

Double

Metric

ActiveViewCpm column for table Metrics

ActiveViewCtr

Double

Metric

ActiveViewCtr column for table Metrics

ActiveViewImpressions

Long

Metric

ActiveViewImpressions column for table Metrics

ActiveViewMeasurability

Double

Metric

ActiveViewMeasurability column for table Metrics

ActiveViewMeasurableCostMicros

Long

Metric

ActiveViewMeasurableCostMicros column for table Metrics

ActiveViewMeasurableImpressions

Long

Metric

ActiveViewMeasurableImpressions column for table Metrics

ActiveViewViewability

Double

Metric

ActiveViewViewability column for table Metrics

AllConversions

Double

Metric

AllConversions column for table Metrics

AllConversionsByConversionDate

Double

Metric

AllConversionsByConversionDate column for table Metrics

AllConversionsFromInteractionsRate

Double

Metric

AllConversionsFromInteractionsRate column for table Metrics

AllConversionsValue

Double

Metric

AllConversionsValue column for table Metrics

AllConversionsValueByConversionDate

Double

Metric

AllConversionsValueByConversionDate column for table Metrics

AverageCost

Double

Metric

AverageCost column for table Metrics

AverageCpc

Double

Metric

AverageCpc column for table Metrics

AverageCpe

Double

Metric

AverageCpe column for table Metrics

AverageCpm

Double

Metric

AverageCpm column for table Metrics

AverageCpv

Double

Metric

AverageCpv column for table Metrics

AveragePageViews

Double

Metric

AveragePageViews column for table Metrics

AverageTimeOnSite

Double

Metric

AverageTimeOnSite column for table Metrics

BounceRate

Double

Metric

BounceRate column for table Metrics

Clicks

Long

Metric

Clicks column for table Metrics

ContentImpressionShare

Double

Metric

ContentImpressionShare column for table Metrics

ContentRankLostImpressionShare

Double

Metric

ContentRankLostImpressionShare column for table Metrics

Conversions

Double

Metric

Conversions column for table Metrics

ConversionsByConversionDate

Double

Metric

ConversionsByConversionDate column for table Metrics

ConversionsFromInteractionsRate

Double

Metric

ConversionsFromInteractionsRate column for table Metrics

ConversionsValue

Double

Metric

ConversionsValue column for table Metrics

ConversionsValueByConversionDate

Double

Metric

ConversionsValueByConversionDate column for table Metrics

CostMicros

Long

Metric

CostMicros column for table Metrics

CostPerAllConversions

Double

Metric

CostPerAllConversions column for table Metrics

CostPerConversion

Double

Metric

CostPerConversion column for table Metrics

CostPerCurrentModelAttributedConversion

Double

Metric

CostPerCurrentModelAttributedConversion column for table Metrics

CrossDeviceConversions

Double

Metric

CrossDeviceConversions column for table Metrics

Ctr

Double

Metric

Ctr column for table Metrics

CurrentModelAttributedConversions

Double

Metric

CurrentModelAttributedConversions column for table Metrics

CurrentModelAttributedConversionsValue

Double

Metric

CurrentModelAttributedConversionsValue column for table Metrics

EngagementRate

Double

Metric

EngagementRate column for table Metrics

Engagements

Long

Metric

Engagements column for table Metrics

GmailForwards

Long

Metric

GmailForwards column for table Metrics

GmailSaves

Long

Metric

GmailSaves column for table Metrics

GmailSecondaryClicks

Long

Metric

GmailSecondaryClicks column for table Metrics

Impressions

Long

Metric

Impressions column for table Metrics

InteractionEventTypes

String

Metric

InteractionEventTypes column for table Metrics

InteractionRate

Double

Metric

InteractionRate column for table Metrics

Interactions

Long

Metric

Interactions column for table Metrics

PercentNewVisitors

Double

Metric

PercentNewVisitors column for table Metrics

PhoneCalls

Long

Metric

PhoneCalls column for table Metrics

PhoneImpressions

Long

Metric

PhoneImpressions column for table Metrics

PhoneThroughRate

Double

Metric

PhoneThroughRate column for table Metrics