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.
AbsoluteTopImpressionPercentage	Double	Metric	Impr Abs Top	The percent of add impressions shown as the very first ad.
ActiveViewCpm	Decimal	Metric	Active View Avg CPM	Active View Avg CPM for the AdgroupPerformance report.
ActiveViewCtr	Double	Metric	Active View Viewable CTR	Active View Viewable CTR for the AdgroupPerformance report.
ActiveViewImpressions	Long	Metric	Active View Viewable Impressions	Active View Viewable Impressions for the AdgroupPerformance report.
ActiveViewMeasurability	Double	Metric	Active View Measurable Impr Per Impr	Active View Measurable Impr Per Impr for the AdgroupPerformance report.
ActiveViewMeasurableCost	Decimal	Metric	Active View Measurable Cost	Active View Measurable Cost for the AdgroupPerformance report.
ActiveViewMeasurableImpressions	Long	Metric	Active View Measurable Impr	Active View Measurable Impr for the AdgroupPerformance report.
ActiveViewViewability	Double	Metric	Active View Viewable Impr Per Measurable Impr	Active View Viewable Impr Per Measurable Impr for the AdgroupPerformance report.
AllConversionRate	Double	Metric	All Conv Rate	All Conv Rate for the AdgroupPerformance report.
AllConversions	Double	Metric	All Conv	All Conv for the AdgroupPerformance report.
AllConversionValue	Double	Metric	All Conv Value	All Conv Value for the AdgroupPerformance report.
AverageCost	Decimal	Metric	Avg Cost	Avg Cost for the AdgroupPerformance report.
AverageCpc	Decimal	Metric	Avg CPC	Avg CPC for the AdgroupPerformance report.
AverageCpe	Double	Metric	Avg CPE	Avg CPE for the AdgroupPerformance report.
AverageCpm	Decimal	Metric	Avg CPM	Avg CPM for the AdgroupPerformance report.
AverageCpv	Double	Metric	Avg CPV	Avg CPV for the AdgroupPerformance report.
AveragePageviews	Double	Metric	Pages Per Session	Pages Per Session for the AdgroupPerformance report.
AveragePosition	Double	Metric	Avg Position	Avg Position for the AdgroupPerformance report.
AverageTimeOnSite	Double	Metric	Avg Session Duration (seconds)	Avg Session Duration (seconds) for the AdgroupPerformance report.
BounceRate	Double	Metric	Bounce Rate	Bounce Rate for the AdgroupPerformance report.
ClickAssistedConversions	Long	Metric	Click Assisted Conv	Click Assisted Conv for the AdgroupPerformance report.
ClickAssistedConversionsOverLastClickConversions	Double	Metric	Click Assisted Conv Per Last Click Conv	Click Assisted Conv Per Last Click Conv for the AdgroupPerformance report.
ClickAssistedConversionValue	Double	Metric	Click Assisted Conv Value	Click Assisted Conv Value for the AdgroupPerformance report.
Clicks	Long	Metric	Clicks	Clicks for the AdgroupPerformance report.
ContentImpressionShare	Double	Metric	Content Impr Share	Content Impr Share for the AdgroupPerformance report.
ContentRankLostImpressionShare	Double	Metric	Content Lost IS (rank)	Content Lost IS (rank) for the AdgroupPerformance report.
ConversionRate	Double	Metric	Conv Rate	Conv Rate for the AdgroupPerformance report.
Conversions	Double	Metric	Conversions	Conversions for the AdgroupPerformance report.
ConversionValue	Double	Metric	Total Conv Value	Total Conv Value for the AdgroupPerformance report.
Cost	Decimal	Metric	Cost	Cost for the AdgroupPerformance report.
CostPerAllConversion	Decimal	Metric	Cost Per All Conv	Cost Per All Conv for the AdgroupPerformance report.
CostPerConversion	Decimal	Metric	Cost Per Conv	Cost Per Conv for the AdgroupPerformance report.
CostPerCurrentModelAttributedConversion	Double	Metric	Cost Per Conv (current Model)	Cost Per Conv (current Model) for the AdgroupPerformance report.
CrossDeviceConversions	Double	Metric	Cross-device Conv	Cross-device Conv for the AdgroupPerformance report.
Ctr	Double	Metric	CTR	CTR for the AdgroupPerformance report.
CurrentModelAttributedConversions	Double	Metric	Conversions (current Model)	Conversions (current Model) for the AdgroupPerformance report.
CurrentModelAttributedConversionValue	Double	Metric	Conv Value (current Model)	Conv Value (current Model) for the AdgroupPerformance report.
EngagementRate	Double	Metric	Engagement Rate	Engagement Rate for the AdgroupPerformance report.
Engagements	Long	Metric	Engagements	Engagements for the AdgroupPerformance report.
GmailForwards	Long	Metric	Gmail Forwards	Gmail Forwards for the AdgroupPerformance report.
GmailSaves	Long	Metric	Gmail Saves	Gmail Saves for the AdgroupPerformance report.
GmailSecondaryClicks	Long	Metric	Gmail Clicks To Website	Gmail Clicks To Website for the AdgroupPerformance report.
ImpressionAssistedConversions	Long	Metric	Impr Assisted Conv	Impr Assisted Conv for the AdgroupPerformance report.
ImpressionAssistedConversionsOverLastClickConversions	Double	Metric	Impr Assisted Conv Per Last Click Conv	Impr Assisted Conv Per Last Click Conv for the AdgroupPerformance report.
ImpressionAssistedConversionValue	Double	Metric	Impr Assisted Conv Value	Impr Assisted Conv Value for the AdgroupPerformance report.
Impressions	Long	Metric	Impressions	Impressions for the AdgroupPerformance report.
InteractionRate	Double	Metric	Interaction Rate	Interaction Rate for the AdgroupPerformance report.
Interactions	Long	Metric	Interactions	Interactions for the AdgroupPerformance report.
InteractionTypes	String	Metric	Interaction Types	Interaction Types for the AdgroupPerformance report.
NumOfflineImpressions	Long	Metric	Phone Impressions	Phone Impressions for the AdgroupPerformance report.
NumOfflineInteractions	Long	Metric	Phone Calls	Phone Calls for the AdgroupPerformance report.
OfflineInteractionRate	Double	Metric	PTR	PTR for the AdgroupPerformance report.
PercentNewVisitors	Double	Metric	Percent New Sessions	Percent New Sessions for the AdgroupPerformance report.
RelativeCtr	Double	Metric	Relative CTR	Relative CTR for the AdgroupPerformance report.
SearchAbsoluteTopImpressionShare	Double	Metric	Search Abs Top IS	Search Abs Top IS for the AdgroupPerformance report.
SearchExactMatchImpressionShare	Double	Metric	Search Exact Match IS	Search Exact Match IS for the AdgroupPerformance report.
SearchImpressionShare	Double	Metric	Search Impr Share	Search Impr Share for the AdgroupPerformance report.
SearchRankLostImpressionShare	Double	Metric	Search Lost IS (rank)	Search Lost IS (rank) for the AdgroupPerformance report.
TopImpressionPercentage	Double	Metric	Impr Top	The percent of add impressions that are shown anywhere above the organic search results.
ValuePerAllConversion	Double	Metric	Value Per All Conv	Value Per All Conv for the AdgroupPerformance report.
ValuePerConversion	Double	Metric	Value Per Conv	Value Per Conv for the AdgroupPerformance report.
ValuePerCurrentModelAttributedConversion	Double	Metric	Value Per Conv (current Model)	Value Per Conv (current Model) for the AdgroupPerformance report.
VideoQuartile100Rate	Double	Metric	Video Played To 100Percent	Video Played To 100Percent for the AdgroupPerformance report.
VideoQuartile25Rate	Double	Metric	Video Played To 25Percent	Video Played To 25Percent for the AdgroupPerformance report.
VideoQuartile50Rate	Double	Metric	Video Played To 50Percent	Video Played To 50Percent for the AdgroupPerformance report.
VideoQuartile75Rate	Double	Metric	Video Played To 75Percent	Video Played To 75Percent for the AdgroupPerformance report.
VideoViewRate	Double	Metric	View Rate	View Rate for the AdgroupPerformance report.
VideoViews	Long	Metric	Views	Views for the AdgroupPerformance report.
ViewThroughConversions	Long	Metric	View-through Conv	View-through Conv for the AdgroupPerformance report.

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
StartDate	String	Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.
EndDate	String	End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.