AdgroupPerformance

The Ad Group Performance report includes all statistics aggregated by default at the ad group level, one row per ad group.

Table Specific Information

Select

Google AdWords 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 AdWords console.

To use the nondefault fields, explicitly select them in your query. For example, the following query uses Device instead of the default Date segment to query Ad Group Performance data:\

SELECT AdGroupId, AdGroupName, CampaignName, Device, Clicks, ConversionRate, Impressions FROM AdGroupPerformance

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 AdWords API. All filters must be joined by the AND keyword as OR is not supported by the AdWords API. For example, the following query will return only AdGroups in enabled Campaigns with a conversion rate greater than 0:\

SELECT AdGroupId, AdGroupName, CampaignName, Device, Clicks, ConversionRate, Impressions FROM AdGroupPerformance WHERE CampaignStatus='ENABLED' AND ConversionRate > 0

Columns

Name

Type

Behavior

DisplayName

Description

AccountCurrencyCode

String

Attribute

Currency

Currency for the AdgroupPerformance report.

AccountDescriptiveName

String

Attribute

Account

Account for the AdgroupPerformance report.

AccountTimeZone

String

Attribute

Time Zone

Time Zone for the AdgroupPerformance report.

AdGroupDesktopBidModifier

Double

Attribute

Desktop Bid Adj

Desktop Bid Adj for the AdgroupPerformance report.

AdGroupId

Long

Attribute

Ad Group ID

Ad Group ID for the AdgroupPerformance report.

AdGroupMobileBidModifier

Double

Attribute

Mobile Bid Adj

Mobile Bid Adj for the AdgroupPerformance report.

AdGroupName

String

Attribute

Ad Group

Ad Group for the AdgroupPerformance report.

AdGroupStatus

String

Attribute

Ad Group State

Ad Group State for the AdgroupPerformance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

AdGroupTabletBidModifier

Double

Attribute

Tablet Bid Adj

Tablet Bid Adj for the AdgroupPerformance report.

AdGroupType

String

Attribute

Ad Group Type

Ad Group Type for the AdgroupPerformance report.

The allowed values are UNKNOWN, SEARCH_STANDARD, SEARCH_DYNAMIC_ADS, DISPLAY_STANDARD, DISPLAY_ENGAGEMENT, SHOPPING_PRODUCT_ADS, SHOPPING_SHOWCASE_ADS, SHOPPING_GOAL_OPTIMIZED_ADS, VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER, VIDEO_NON_SKIPPABLE_IN_STREAM, HOTEL_ADS.

AdRotationMode

String

Attribute

Ad Rotation Mode

Ad Rotation Mode for the AdgroupPerformance report.

The allowed values are UNKNOWN, OPTIMIZE, ROTATE_FOREVER.

BaseAdGroupId

Long

Attribute

Base Ad Group ID

Base Ad Group ID for the AdgroupPerformance report.

BaseCampaignId

Long

Attribute

Base Campaign ID

Base Campaign ID for the AdgroupPerformance report.

BiddingStrategyId

Long

Attribute

Bid Strategy ID

Bid Strategy ID for the AdgroupPerformance report.

BiddingStrategyName

String

Attribute

Bid Strategy Name

Bid Strategy Name for the AdgroupPerformance report.

BiddingStrategySource

String

Attribute

Bidding Strategy Source

Bidding Strategy Source for the AdgroupPerformance report.

The allowed values are CAMPAIGN, ADGROUP, CRITERION.

BiddingStrategyType

String

Attribute

Bid Strategy Type

Bid Strategy Type for the AdgroupPerformance report.

The allowed values are MANUAL_CPC, MANUAL_CPV, MANUAL_CPM, PAGE_ONE_PROMOTED, TARGET_SPEND, TARGET_CPA, TARGET_ROAS, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, TARGET_OUTRANK_SHARE, NONE, UNKNOWN.

CampaignId

Long

Attribute

Campaign ID

Campaign ID for the AdgroupPerformance report.

CampaignName

String

Attribute

Campaign

Campaign for the AdgroupPerformance report.

CampaignStatus

String

Attribute

Campaign State

Campaign State for the AdgroupPerformance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

ContentBidCriterionTypeGroup

String

Attribute

Content Network Bid Dimension

Content Network Bid Dimension for the AdgroupPerformance report.

The allowed values are KEYWORD, USER_INTEREST_AND_LIST, VERTICAL, GENDER, AGE_RANGE, PLACEMENT, PARENT, INCOME_RANGE, NONE, UNKNOWN.

ConversionAdjustment

String

Attribute

Conversion Adjustment

Conversion Adjustment for the AdgroupPerformance report.

The allowed values are TRUE, FALSE.

CpcBid

Decimal

Attribute

Default Max CPC

Default Max CPC for the AdgroupPerformance report.

CpmBid

Decimal

Attribute

Max CPM

Max CPM for the AdgroupPerformance report.

CpvBid

Decimal

Attribute

Max CPV

Max CPV for the AdgroupPerformance report.

CustomerDescriptiveName

String

Attribute

Client Name

Client Name for the AdgroupPerformance report.

EffectiveTargetRoas

Double

Attribute

Target ROAS

Target ROAS for the AdgroupPerformance report.

EffectiveTargetRoasSource

String

Attribute

Target ROAS Source

Target ROAS Source for the AdgroupPerformance report.

The allowed values are UNKNOWN, ADGROUP, ADGROUP_CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.

EnhancedCpcEnabled

String

Attribute

Enhanced CPC Enabled

Enhanced CPC Enabled for the AdgroupPerformance report.

The allowed values are TRUE, FALSE.

ExternalCustomerId

Long

Attribute

Customer ID

Customer ID for the AdgroupPerformance report.

FinalUrlSuffix

String

Attribute

Final URL Suffix

Final URL Suffix for the AdgroupPerformance report.

LabelIds

String

Attribute

Label IDs

Label IDs for the AdgroupPerformance report.

Labels

String

Attribute

Labels

Labels for the AdgroupPerformance report.

TargetCpa

Decimal

Attribute

Target CPA

Target CPA for the AdgroupPerformance report.

TargetCpaBidSource

String

Attribute

Target CPA Source

Target CPA Source for the AdgroupPerformance report.

The allowed values are ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.

TrackingUrlTemplate

String

Attribute

Tracking Template

Tracking Template for the AdgroupPerformance report.

UrlCustomParameters

String

Attribute

Custom Parameter

Custom Parameter for the AdgroupPerformance report.

AdNetworkType1

String

Segment

Network

Network for the AdgroupPerformance report.

The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

AdNetworkType2

String

Segment

Network (with Search Partners)

Network (with Search Partners) for the AdgroupPerformance report.

The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

ClickType

String

Segment

Click Type

Click Type for the AdgroupPerformance report.

The allowed values are URL_CLICKS, CALLS, OTHER, PRODUCT_EXTENSION_CLICKS, SITELINKS, PRODUCT_LISTING_AD_CLICKS, GET_DIRECTIONS, OFFER_PRINTS, BREADCRUMBS, CALL_TRACKING, MOBILE_CALL_TRACKING, LOCATION_EXPANSION, STORE_LOCATOR, PRODUCT_LISTING_AD_LOCAL, APP_DEEPLINK, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_TRANSACTABLE, PRODUCT_AD_APP_DEEPLINK, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, PRICE_EXTENSION, VIDEO_WEBSITE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_APP_STORE_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_END_CAP_CLICKS, CLICK_ON_ENGAGEMENT_AD, LOCATION_FORMAT_MAP, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_CALL, LOCATION_FORMAT_TEXT, LOCATION_FORMAT_IMAGE, BROADBAND_PLAN, WIRELESS_PLAN, VISUAL_SITELINKS, PROMOTION_EXTENSION, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SWIPES, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, UNKNOWN.

ConversionAdjustmentLagBucket

String

Segment

Days To Conversion Or Adjustment

Days To Conversion Or Adjustment for the AdgroupPerformance report.

The allowed values are UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS, ADJUSTMENT_0_TO_1_DAY, ADJUSTMENT_1_TO_2_DAYS, ADJUSTMENT_2_TO_3_DAYS, ADJUSTMENT_3_TO_4_DAYS, ADJUSTMENT_4_TO_5_DAYS, ADJUSTMENT_5_TO_6_DAYS, ADJUSTMENT_6_TO_7_DAYS, ADJUSTMENT_7_TO_8_DAYS, ADJUSTMENT_8_TO_9_DAYS, ADJUSTMENT_9_TO_10_DAYS, ADJUSTMENT_10_TO_11_DAYS, ADJUSTMENT_11_TO_12_DAYS, ADJUSTMENT_12_TO_13_DAYS, ADJUSTMENT_13_TO_14_DAYS, ADJUSTMENT_14_TO_21_DAYS, ADJUSTMENT_21_TO_30_DAYS, ADJUSTMENT_30_TO_45_DAYS, ADJUSTMENT_45_TO_60_DAYS, ADJUSTMENT_60_TO_90_DAYS, ADJUSTMENT_90_TO_145_DAY, CONVERSION_UNKNOWN, ADJUSTMENT_UNKNOWN.

ConversionCategoryName

String

Segment

Conversion Category

Conversion Category for the AdgroupPerformance report.

ConversionLagBucket

String

Segment

Days To Conversion

Days To Conversion for the AdgroupPerformance report.

The allowed values are UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS.

ConversionTrackerId

Long

Segment

Conversion Tracker Id

Conversion Tracker Id for the AdgroupPerformance report.

ConversionTypeName

String

Segment

Conversion Name

Conversion Name for the AdgroupPerformance report.

Date

Date

Segment

Day

Day for the AdgroupPerformance report.

DayOfWeek

String

Segment

Day Of Week

Day Of Week for the AdgroupPerformance report.

The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.

Device

String

Segment

Device

Device for the AdgroupPerformance report.

The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.

ExternalConversionSource

String

Segment

Conversion Source

Conversion Source for the AdgroupPerformance report.

The allowed values are UNKNOWN, WEBPAGE, ANALYTICS, UPLOAD, AD_CALL_METRICS, OFFERS, ENGAGEMENT, WEBSITE_CALL_METRICS, STORE_VISITS, ANDROID_IN_APP, ANDROID_DOWNLOAD, IOS_IN_APP, IOS_FIRST_OPEN, APP_UNSPECIFIED, ANDROID_FIRST_OPEN, UPLOAD_CALLS, FIREBASE, CLICK_TO_CALL, SALESFORCE, STORE_SALES_CRM, STORE_SALES_PAYMENT_NETWORK, GOOGLE_PLAY, THIRD_PARTY_APP_ANALYTICS, GOOGLE_ATTRIBUTION, STORE_SALES_DIRECT.

HourOfDay

Integer

Segment

Hour Of Day

Hour Of Day for the AdgroupPerformance report.

Month

String

Segment

Month

Month for the AdgroupPerformance report.

MonthOfYear

String

Segment

Month Of Year

Month Of Year for the AdgroupPerformance report.

The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.

Quarter

String

Segment

Quarter

Quarter for the AdgroupPerformance report.

Slot

String

Segment

Top Vs Other

Top Vs Other for the AdgroupPerformance report.

The allowed values are SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN.

Week

String

Segment

Week

Week for the AdgroupPerformance report.

Year

Integer

Segment

Year

Year for the AdgroupPerformance report.