AdGroup
An ad group.
View-Specific Information
Select
Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are 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 using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.
Columns
| Name | Type | Behavior | Description |
| AdGroupAdRotationMode | String | ATTRIBUTE | The ad rotation mode of the ad group.
The allowed values are OPTIMIZE, ROTATE_FOREVER, UNKNOWN. |
| AdGroupAiMaxAdGroupSettingDisableSearchTermMatching | Bool | ATTRIBUTE | Disable search term matching for this adgroup when AI Max is enabled. Search term matching uses broad match, asset-based, and landing page-based technology to improve reach. |
| AdGroupAudienceSettingUseAudienceGrouped | Bool | ATTRIBUTE | Immutable. If true, this ad group uses an Audience resource for audience targeting. If false, this ad group may use audience segment criteria instead. |
| AdGroupBaseAdGroup | String | ATTRIBUTE | Output only. For draft or experiment ad groups, this field is the resource |
| AdGroupCampaign | String | ATTRIBUTE | Immutable. The campaign to which the ad group belongs. |
| AdGroupCpcBidMicros | Long | ATTRIBUTE | The maximum CPC (cost-per-click) bid. This field is used when the |
| AdGroupCpmBidMicros | Long | ATTRIBUTE | The maximum CPM (cost-per-thousand viewable impressions) bid. |
| AdGroupCpvBidMicros | Long | ATTRIBUTE | The CPV (cost-per-view) bid. |
| AdGroupDemandGenAdGroupSettingsChannelControlsChannelConfig | String | ATTRIBUTE | Output only. Channel configuration reflecting which field in the oneof is populated.
The allowed values are CHANNEL_STRATEGY, SELECTED_CHANNELS, UNKNOWN. |
| AdGroupDemandGenAdGroupSettingsChannelControlsChannelStrategy | String | ATTRIBUTE | High level channel strategy.
The allowed values are ALL_CHANNELS, ALL_OWNED_AND_OPERATED_CHANNELS, UNKNOWN. |
| AdGroupDemandGenAdGroupSettingsChannelControlsSelectedChannelsDiscover | Bool | ATTRIBUTE | Whether to enable ads on the Discover channel. |
| AdGroupDemandGenAdGroupSettingsChannelControlsSelectedChannelsDisplay | Bool | ATTRIBUTE | Whether to enable ads on the Display channel. |
| AdGroupDemandGenAdGroupSettingsChannelControlsSelectedChannelsGmail | Bool | ATTRIBUTE | Whether to enable ads on the Gmail channel. |
| AdGroupDemandGenAdGroupSettingsChannelControlsSelectedChannelsYoutubeInFeed | Bool | ATTRIBUTE | Whether to enable ads on the YouTube In-Feed channel. |
| AdGroupDemandGenAdGroupSettingsChannelControlsSelectedChannelsYoutubeInStream | Bool | ATTRIBUTE | Whether to enable ads on the YouTube In-Stream channel. |
| AdGroupDemandGenAdGroupSettingsChannelControlsSelectedChannelsYoutubeShorts | Bool | ATTRIBUTE | Whether to enable ads on the YouTube Shorts channel. |
| AdGroupDisplayCustomBidDimension | String | ATTRIBUTE | Lets advertisers specify a targeting dimension on which to place
The allowed values are AGE_RANGE, AUDIENCE, GENDER, INCOME_RANGE, KEYWORD, PARENTAL_STATUS, PLACEMENT, TOPIC, UNKNOWN. |
| AdGroupEffectiveCpcBidMicros | Long | ATTRIBUTE | Output only. Value will be same as that of the CPC (cost-per-click) bid |
| AdGroupEffectiveTargetCpaMicros | Long | ATTRIBUTE | Output only. The effective target CPA (cost-per-acquisition). |
| AdGroupEffectiveTargetCpaSource | String | ATTRIBUTE | Output only. Source of the effective target CPA.
The allowed values are AD_GROUP, AD_GROUP_CRITERION, CAMPAIGN_BIDDING_STRATEGY, UNKNOWN. |
| AdGroupEffectiveTargetCpc | Long | ATTRIBUTE | Output only. The effective target CPC (cost-per-click). |
| AdGroupEffectiveTargetCpcSource | String | ATTRIBUTE | Output only. Source of the effective target CPC.
The allowed values are AD_GROUP, AD_GROUP_CRITERION, CAMPAIGN_BIDDING_STRATEGY, UNKNOWN. |
| AdGroupEffectiveTargetRoas | Double | ATTRIBUTE | Output only. The effective target ROAS (return-on-ad-spend). |
| AdGroupEffectiveTargetRoasSource | String | ATTRIBUTE | Output only. Source of the effective target ROAS.
The allowed values are AD_GROUP, AD_GROUP_CRITERION, CAMPAIGN_BIDDING_STRATEGY, UNKNOWN. |
| AdGroupExcludeDemographicExpansion | Bool | ATTRIBUTE | When this value is true, demographics will be excluded from the types of |
| AdGroupExcludedParentAssetFieldTypes | String | ATTRIBUTE | The asset field types that should be excluded from this ad group. Asset
The allowed values are AD_IMAGE, BOOK_ON_GOOGLE, BUSINESS_LOGO, BUSINESS_MESSAGE, BUSINESS_NAME, CALL, CALLOUT, CALL_TO_ACTION, CALL_TO_ACTION_SELECTION, DEMAND_GEN_CAROUSEL_CARD, DESCRIPTION, HEADLINE, HOTEL_CALLOUT, HOTEL_PROPERTY, LANDING_PAGE_PREVIEW, LANDSCAPE_LOGO, LEAD_FORM, LOGO, LONG_DESCRIPTION, LONG_HEADLINE, MANDATORY_AD_TEXT, MARKETING_IMAGE, MEDIA_BUNDLE, MOBILE_APP, PORTRAIT_MARKETING_IMAGE, PRICE, PROMOTION, RELATED_YOUTUBE_VIDEOS, SITELINK, SQUARE_MARKETING_IMAGE, STRUCTURED_SNIPPET, TALL_PORTRAIT_MARKETING_IMAGE, UNKNOWN, VIDEO, YOUTUBE_VIDEO. |
| AdGroupExcludedParentAssetSetTypes | String | ATTRIBUTE | The asset set types that should be excluded from this ad group. Asset set
The allowed values are BUSINESS_PROFILE_DYNAMIC_LOCATION_GROUP, CHAIN_DYNAMIC_LOCATION_GROUP, DYNAMIC_CUSTOM, DYNAMIC_EDUCATION, DYNAMIC_FLIGHTS, DYNAMIC_HOTELS_AND_RENTALS, DYNAMIC_JOBS, DYNAMIC_LOCAL, DYNAMIC_REAL_ESTATE, DYNAMIC_TRAVEL, HOTEL_PROPERTY, LOCATION_SYNC, MERCHANT_CENTER_FEED, PAGE_FEED, STATIC_LOCATION_GROUP, TRAVEL_FEED, UNKNOWN. |
| AdGroupFinalUrlSuffix | String | ATTRIBUTE | URL template for appending params to Final URL. |
| AdGroupFixedCpmMicros | Long | ATTRIBUTE | The fixed amount in micros that the advertiser pays for every thousand |
| AdGroupId | Long | ATTRIBUTE | Output only. The ID of the ad group. |
| AdGroupLabels | String | ATTRIBUTE | Output only. The resource names of labels attached to this ad group. |
| AdGroupName | String | ATTRIBUTE | The name of the ad group. |
| AdGroupOptimizedTargetingEnabled | Bool | ATTRIBUTE | True if optimized targeting is enabled. Optimized Targeting is the |
| AdGroupPercentCpcBidMicros | Long | ATTRIBUTE | The percent cpc bid amount, expressed as a fraction of the advertised price |
| AdGroupPrimaryStatus | String | ATTRIBUTE | Output only. Provides aggregated view into why an ad group is not serving
The allowed values are ELIGIBLE, LIMITED, NOT_ELIGIBLE, PAUSED, PENDING, REMOVED, UNKNOWN. |
| AdGroupPrimaryStatusReasons | String | ATTRIBUTE | Output only. Provides reasons for why an ad group is not serving or not
The allowed values are AD_GROUP_ADS_PAUSED, AD_GROUP_INCOMPLETE, AD_GROUP_PAUSED, AD_GROUP_PAUSED_DUE_TO_LOW_ACTIVITY, AD_GROUP_REMOVED, CAMPAIGN_DRAFT, CAMPAIGN_ENDED, CAMPAIGN_PAUSED, CAMPAIGN_PENDING, CAMPAIGN_REMOVED, HAS_ADS_DISAPPROVED, HAS_ADS_LIMITED_BY_POLICY, KEYWORDS_PAUSED, MOST_ADS_UNDER_REVIEW, NO_AD_GROUP_ADS, NO_KEYWORDS, UNKNOWN. |
| AdGroupResourceName | String | ATTRIBUTE | Immutable. The resource name of the ad group. |
| AdGroupStatus | String | ATTRIBUTE | The status of the ad group.
The allowed values are ENABLED, PAUSED, REMOVED, UNKNOWN. |
| AdGroupTargetCpaMicros | Long | ATTRIBUTE | The target CPA (cost-per-acquisition). If the ad group's campaign |
| AdGroupTargetCpcMicros | Long | ATTRIBUTE | Average amount in micros that the advertiser is willing to pay for every ad |
| AdGroupTargetCpmMicros | Long | ATTRIBUTE | Average amount in micros that the advertiser is willing to pay for every |
| AdGroupTargetCpvMicros | Long | ATTRIBUTE | Average amount in micros that the advertiser is willing to pay for every ad |
| AdGroupTargetRoas | Double | ATTRIBUTE | The target ROAS (return-on-ad-spend) for this ad group. |
| AdGroupTargetingSettingTargetRestrictions | String | ATTRIBUTE | The per-targeting-dimension setting to restrict the reach of your campaign or ad group. |
| AdGroupTrackingUrlTemplate | String | ATTRIBUTE | The URL template for constructing a tracking URL. |
| AdGroupType | String | ATTRIBUTE | Immutable. The type of the ad group.
The allowed values are DISPLAY_STANDARD, HOTEL_ADS, PROMOTED_HOTEL_ADS, SEARCH_DYNAMIC_ADS, SEARCH_STANDARD, SHOPPING_COMPARISON_LISTING_ADS, SHOPPING_PRODUCT_ADS, SHOPPING_SMART_ADS, SMART_CAMPAIGN_ADS, TRAVEL_ADS, UNKNOWN, VIDEO_BUMPER, VIDEO_EFFICIENT_REACH, VIDEO_NON_SKIPPABLE_IN_STREAM, VIDEO_RESPONSIVE, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_TRUE_VIEW_IN_STREAM, YOUTUBE_AUDIO. |
| AdGroupUrlCustomParameters | String | ATTRIBUTE | The list of mappings used to substitute custom parameter tags in a |
| AdGroupVerticalAdsFormatSettingDisableTextAds | Bool | ATTRIBUTE | If true, text ads will be disabled for this ad group. |
| AdGroupVerticalAdsFormatSettingEnableBookingLinks | Bool | ATTRIBUTE | If true, booking links will be enabled for this ad group. |
| AdGroupVerticalAdsFormatSettingEnableVerticalPromotionAds | Bool | ATTRIBUTE | If true, vertical promotion ads will be enabled for this ad group. |
| AdGroupVideoAdGroupSettingsVideoAdSequenceStepId | Long | ATTRIBUTE | The ID of this sequence step from an existing campaign.video_campaign_settings.video_ad_sequence definition. Only one Ad Group can point to a given step_id. |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| AbsoluteTopImpressionPercentage | Double | METRIC | Search absolute top impression share is the percentage of your Search ad |
| ActiveViewAudibilityInvalidGivtMeasurableImpressionsRate | Double | METRIC | The number of impressions for which Active View could measure audibility, |
| ActiveViewAudibilityInvalidMeasurableImpressionsRate | Double | METRIC | The number of impressions for which Active View could measure audibility, |
| ActiveViewAudibilityMeasurableImpressions | Long | METRIC | The number of impressions for which Active View could measure if the ad was |
| ActiveViewAudibilityMeasurableImpressionsRate | Double | METRIC | The number of impressions for which Active View could measure if the ad was |
| ActiveViewAudibleImpressions | Long | METRIC | The number of impressions that were audible (volume > 0%) at any point |
| ActiveViewAudibleImpressionsRate | Double | METRIC | The number of impressions that were audible (volume > 0%) at any point |
| ActiveViewAudibleQuartileP100Rate | Double | METRIC | The number of impressions that were audible at the fourth quartile of the |
| ActiveViewAudibleQuartileP25Rate | Double | METRIC | The number of impressions that were audible at the first quartile of the |
| ActiveViewAudibleQuartileP50Rate | Double | METRIC | The number of impressions that were audible at the second quartile of the |
| ActiveViewAudibleQuartileP75Rate | Double | METRIC | The number of impressions that were audible at the third quartile of the |
| ActiveViewAudibleThirtySecondsImpressions | Long | METRIC | The number of impressions that were audible for at least 30 seconds |
| ActiveViewAudibleThirtySecondsImpressionsRate | Double | METRIC | The number of impressions that were audible for at least 30 seconds |
| ActiveViewAudibleTwoSecondsImpressions | Long | METRIC | The number of impressions that were audible for at least 2 seconds |
| ActiveViewAudibleTwoSecondsImpressionsRate | Double | METRIC | The number of impressions that were audible for at least 2 seconds |
| ActiveViewCpm | Double | METRIC | Average cost of viewable impressions (active_view_impressions). |
| ActiveViewCtr | Double | METRIC | Active view measurable clicks divided by active view viewable impressions. |
| ActiveViewImpressions | Long | METRIC | A measurement of how often your ad has become viewable on a Display |
| ActiveViewMeasurability | Double | METRIC | The ratio of impressions that could be measured by Active View over the |
| ActiveViewMeasurableCostMicros | Long | METRIC | The cost of the impressions you received that were measurable by Active |
| ActiveViewMeasurableImpressions | Long | METRIC | The number of times your ads are appearing on placements in positions |
| ActiveViewViewability | Double | METRIC | The percentage of time when your ad appeared on an Active View enabled site |
| AllConversions | Double | METRIC | The total number of conversions. This includes all conversions regardless |
| AllConversionsByConversionDate | Double | METRIC | The total number of conversions. This includes all conversions regardless |
| AllConversionsFromInteractionsRate | Double | METRIC | All conversions from interactions (as oppose to view through conversions) |
| AllConversionsValue | Double | METRIC | The value of all conversions. |
| AllConversionsValueByConversionDate | Double | METRIC | The value of all conversions. When this column is selected with date, the |
| AllNewCustomerLifetimeValue | Double | METRIC | All of new customers' lifetime conversion value. If you have set up |
| AverageCartSize | Double | METRIC | Average cart size is the average number of products in each order |
| AverageCost | Double | METRIC | The average amount you pay per interaction. This amount is the total cost |
| AverageCpc | Double | METRIC | The total cost of all clicks divided by the total number of clicks |
| AverageCpe | Double | METRIC | The average amount that you've been charged for an ad engagement. This |
| AverageCpm | Double | METRIC | Average cost-per-thousand impressions (CPM). |
| AverageOrderValueMicros | Long | METRIC | Average order value is the average revenue you made per order attributed to |
| AveragePageViews | Double | METRIC | Average number of pages viewed per session. |
| AverageTimeOnSite | Double | METRIC | Total duration of all sessions (in seconds) / number of sessions. Imported |
| AverageVideoWatchTimeDurationMillis | Long | METRIC | Average video watch time duration in milliseconds for video impressions |
| BiddableCohortAppPostInstallConversions | Double | METRIC | Participated in-app actions. The number of in app actions that come |
| BiddableIndirectInstallFirstInAppConversionMicros | Long | METRIC | The number of biddable first in app conversions where the app install was |
| BounceRate | Double | METRIC | Percentage of clicks where the user only visited a single page on your |
| Clicks | Long | METRIC | The number of clicks. |
| ContentImpressionShare | Double | METRIC | The impressions you've received on the Display Network divided |
| ContentRankLostImpressionShare | Double | METRIC | The estimated percentage of impressions on the Display Network |
| Conversions | Double | METRIC | The number of conversions. This only includes conversion actions which |
| ConversionsByConversionDate | Double | METRIC | The number of conversions. This only includes conversion actions which |
| ConversionsFromInteractionsRate | Double | METRIC | Conversions from interactions divided by the number of ad interactions |
| ConversionsValue | Double | METRIC | The value of conversions. This only includes conversion actions which |
| ConversionsValueByConversionDate | Double | METRIC | The value of conversions. This only includes conversion actions which |
| CostConvertedCurrencyPerPlatformComparableConversion | Double | METRIC | The cost of the platform comparable conversion in the currency of the |
| CostMicros | Long | METRIC | The sum of your cost-per-click (CPC) and cost-per-thousand impressions |
| CostOfGoodsSoldMicros | Long | METRIC | Cost of goods sold (COGS) is the total cost of the products you sold in |
| CostPerAllConversions | Double | METRIC | The cost of ad interactions divided by all conversions. |
| CostPerConversion | Double | METRIC | The cost of ad interactions divided by conversions. This only includes |
| CostPerCurrentModelAttributedConversion | Double | METRIC | The cost of ad interactions divided by current model attributed |
| CostPerPlatformComparableConversion | Double | METRIC | The cost of ad interactions divided by the number of platform comparable |
| CrossDeviceConversions | Double | METRIC | Conversions from when a customer clicks on a Google Ads ad on one device, |
| CrossDeviceConversionsByConversionDate | Double | METRIC | The number of cross-device conversions by conversion date. |
| CrossDeviceConversionsValueByConversionDate | Double | METRIC | The sum of cross-device conversions value by conversion date. |
| CrossDeviceConversionsValueMicros | Long | METRIC | The sum of the value of cross-device conversions, in micros. |
| CrossSellCostOfGoodsSoldMicros | Long | METRIC | Cross-sell cost of goods sold (COGS) is the total cost of products sold as |
| CrossSellGrossProfitMicros | Long | METRIC | Cross-sell gross profit is the profit you made from products sold as a |
| CrossSellRevenueMicros | Long | METRIC | Cross-sell revenue is the total amount you made from products sold as a |
| CrossSellUnitsSold | Double | METRIC | Cross-sell units sold is the total number of products sold as a result of |
| Ctr | Double | METRIC | The number of clicks your ad receives (Clicks) divided by the number |
| CurrentModelAttributedConversions | Double | METRIC | Shows how your historic conversions data would look under the attribution |
| CurrentModelAttributedConversionsValue | Double | METRIC | The value of current model attributed conversions. This only includes |
| EngagementRate | Double | METRIC | How often people engage with your ad after it's shown to them. This is the |
| Engagements | Long | METRIC | The number of engagements. |
| GmailForwards | Long | METRIC | The number of times the ad was forwarded to someone else as a message. |
| GmailSaves | Long | METRIC | The number of times someone has saved your Gmail ad to their inbox as a |
| GmailSecondaryClicks | Long | METRIC | The number of clicks to the landing page on the expanded state of Gmail |
| GrossProfitMargin | Double | METRIC | Gross profit margin is the percentage gross profit you made from orders |
| GrossProfitMicros | Long | METRIC | Gross profit is the profit you made from orders attributed to your ads |
| Impressions | Long | METRIC | Count of how often your ad has appeared on a search results page or |
| InteractionEventTypes | String | METRIC | The types of payable and free interactions.
The allowed values are CLICK, ENGAGEMENT, NONE, UNKNOWN, VIDEO_VIEW. |
| InteractionRate | Double | METRIC | How often people interact with your ad after it is shown to them. |
| Interactions | Long | METRIC | The number of interactions. |
| LeadCostOfGoodsSoldMicros | Long | METRIC | Lead cost of goods sold (COGS) is the total cost of products sold as a |
| LeadGrossProfitMicros | Long | METRIC | Lead gross profit is the profit you made from products sold as a result of |
| LeadRevenueMicros | Long | METRIC | Lead revenue is the total amount you made from products sold as a result of |
| LeadUnitsSold | Double | METRIC | Lead units sold is the total number of products sold as a result of |
| NewCustomerLifetimeValue | Double | METRIC | New customers' lifetime conversion value. If you have set up |
| Orders | Double | METRIC | Orders is the total number of purchase conversions you received attributed |
| PercentNewVisitors | Double | METRIC | Percentage of first-time sessions (from people who had never visited your |
| PhoneCalls | Long | METRIC | Number of offline phone calls. |
| PhoneImpressions | Long | METRIC | Number of offline phone impressions. |
| PhoneThroughRate | Double | METRIC | Number of phone calls received (phone_calls) divided by the number of |
| PlatformComparableConversions | Double | METRIC | The number of platform comparable conversions. This only includes |
| PlatformComparableConversionsByConversionDate | Double | METRIC | The number of platform comparable conversions. When this metric is |
| PlatformComparableConversionsFromInteractionsRate | Double | METRIC | Platform comparable conversions from interactions divided by the number of |
| PlatformComparableConversionsFromInteractionsValuePerInteraction | Double | METRIC | The value of platform comparable conversions from interactions divided by |
| PlatformComparableConversionsValue | Double | METRIC | The value of platform comparable conversions. This only includes conversion |
| PlatformComparableConversionsValueByConversionDate | Double | METRIC | The value of platform comparable conversions. When this metric is segmented |
| PlatformComparableConversionsValuePerCost | Double | METRIC | The value of conversions divided by the cost of ad interactions. This only |
| RelativeCtr | Double | METRIC | Your clickthrough rate (Ctr) divided by the average clickthrough rate of |
| RevenueMicros | Long | METRIC | Revenue is the total amount you made from orders attributed to your ads. |
| SearchAbsoluteTopImpressionShare | Double | METRIC | The percentage of the customer's Shopping or Search ad impressions that are |
| SearchBudgetLostAbsoluteTopImpressionShare | Double | METRIC | The number estimating how often your ad wasn't the very first ad among the |
| SearchBudgetLostTopImpressionShare | Double | METRIC | The number estimating how often your ad didn't show adjacent to the top |
| SearchExactMatchImpressionShare | Double | METRIC | The impressions you've received divided by the estimated number of |
| SearchImpressionShare | Double | METRIC | The impressions you've received on the Search Network divided |
| SearchRankLostAbsoluteTopImpressionShare | Double | METRIC | The number estimating how often your ad wasn't the very first ad among the |
| SearchRankLostImpressionShare | Double | METRIC | The estimated percentage of impressions on the Search Network |
| SearchRankLostTopImpressionShare | Double | METRIC | The number estimating how often your ad didn't show adjacent to the top |
| SearchTopImpressionShare | Double | METRIC | The impressions you've received among the top ads compared to the estimated |
| TopImpressionPercentage | Double | METRIC | The percent of your ad impressions that are shown adjacent to the top |
| TrueviewAverageCpv | Double | METRIC | The average amount you pay each time someone views your ad. |
| UnitsSold | Double | METRIC | Units sold is the total number of products sold from orders attributed to |
| ValuePerAllConversions | Double | METRIC | The value of all conversions divided by the number of all conversions. |
| ValuePerAllConversionsByConversionDate | Double | METRIC | The value of all conversions divided by the number of all conversions. When |
| ValuePerConversion | Double | METRIC | The value of conversions divided by the number of conversions. This only |
| ValuePerConversionsByConversionDate | Double | METRIC | The value of conversions divided by the number of conversions. This only |
| ValuePerCurrentModelAttributedConversion | Double | METRIC | The value of current model attributed conversions divided by the number of |
| ValuePerPlatformComparableConversion | Double | METRIC | The value of platform comparable conversions divided by the number of |
| ValuePerPlatformComparableConversionsByConversionDate | Double | METRIC | The value of platform comparable conversions divided by the number of |
| VideoQuartileP100Rate | Double | METRIC | Percentage of impressions where the viewer watched all of your video. |
| VideoQuartileP25Rate | Double | METRIC | Percentage of impressions where the viewer watched 25% of your video. |
| VideoQuartileP50Rate | Double | METRIC | Percentage of impressions where the viewer watched 50% of your video. |
| VideoQuartileP75Rate | Double | METRIC | Percentage of impressions where the viewer watched 75% of your video. |
| VideoTrueviewViewRate | Double | METRIC | The number of TrueView views your video ad receives divided by its number |
| VideoTrueviewViewRateInFeed | Double | METRIC | The number of TrueView views divided by number of impressions that can |
| VideoTrueviewViewRateInStream | Double | METRIC | The number of TrueView views divided by number of impressions that can |
| VideoTrueviewViewRateShorts | Double | METRIC | The number of TrueView views divided by number of impressions that can |
| VideoTrueviewViews | Long | METRIC | The number of TrueView views your video ads received. |
| VideoWatchTimeDurationMillis | Long | METRIC | Total watch time duration in milliseconds for video impressions that |
| ViewThroughConversions | Long | METRIC | The total number of view-through conversions. |
| AdDestinationType | String | SEGMENT | Ad Destination type.
The allowed values are APP_DEEP_LINK, APP_STORE, LEAD_FORM, LOCATION_LISTING, MAP_DIRECTIONS, MESSAGE, NOT_APPLICABLE, PHONE_CALL, UNKNOWN, UNMODELED_FOR_CONVERSIONS, WEBSITE, YOUTUBE. |
| AdFormatType | String | SEGMENT | Ad Format type.
The allowed values are AUDIO, BUMPER, INFEED, INSTREAM_NON_SKIPPABLE, INSTREAM_SKIPPABLE, MASTHEAD, OTHER, OUTSTREAM, PAUSE, SHORTS, TEXT, UNKNOWN, UNSEGMENTED, VERTICAL_ADS_BOOKING_LINK, VERTICAL_ADS_PROMOTION. |
| AdNetworkType | String | SEGMENT | Ad network type.
The allowed values are CONTENT, DISCOVER, GMAIL, GOOGLE_OWNED_CHANNELS, GOOGLE_TV, MAPS, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, YOUTUBE. |
| AdSubNetworkType | String | SEGMENT | Ad sub network type. Currently only available for ads running as part of
The allowed values are UNKNOWN, UNSEGMENTED, YOUTUBE_INFEED, YOUTUBE_INSTREAM, YOUTUBE_SHORTS. |
| AssetInteractionTargetAsset | String | SEGMENT | The asset resource name. |
| AssetInteractionTargetInteractionOnThisAsset | Bool | SEGMENT | Only used with CustomerAsset, CampaignAsset and AdGroupAsset metrics. Indicates whether the interaction metrics occurred on the asset itself or a different asset or ad unit. |
| AuctionInsightDomain | String | SEGMENT | Domain (visible URL) of a participant in the Auction Insights report. |
| ClickType | String | SEGMENT | Click type.
The allowed values are AD_IMAGE, APP_DEEPLINK, BREADCRUMBS, BROADBAND_PLAN, CALLS, CALL_TRACKING, CLICK_ON_ENGAGEMENT_AD, CLICK_TO_MESSAGE_LANDING_PAGE_CLICK, CLICK_TO_MESSAGE_THIRD_PARTY_CLICK, CROSS_NETWORK, GET_DIRECTIONS, HOTEL_BOOK_ON_GOOGLE_ROOM_SELECTION, HOTEL_PRICE, LOCATION_EXPANSION, LOCATION_FORMAT_CALL, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_IMAGE, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_MAP, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_TEXT, MOBILE_CALL_TRACKING, OFFER_PRINTS, OTHER, PRICE_EXTENSION, PRODUCT_AD_APP_DEEPLINK, PRODUCT_ASSETS, PRODUCT_EXTENSION_CLICKS, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_CLICKS, PRODUCT_LISTING_AD_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_AD_TRANSACTABLE, PROMOTION_EXTENSION, SHOPPING_COMPARISON_LISTING, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SITELINKS, STORE_LOCATOR, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SWIPES, TRAVEL_ASSETS, UNKNOWN, URL_CLICKS, VEHICLE_ASSETS, VIDEO_APP_STORE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_CHANNEL_CLICK, VIDEO_END_CAP_CLICKS, VIDEO_RELATED_VIDEOS_CLICK, VIDEO_WEBSITE_CLICKS, VISUAL_SITELINKS, WIRELESS_PLAN. |
| ConversionAction | String | SEGMENT | Resource name of the conversion action. |
| ConversionActionCategory | String | SEGMENT | Conversion action category.
The allowed values are ADD_TO_CART, BEGIN_CHECKOUT, BOOK_APPOINTMENT, CONTACT, CONVERTED_LEAD, DEFAULT, DOWNLOAD, ENGAGEMENT, GET_DIRECTIONS, IMPORTED_LEAD, OUTBOUND_CLICK, PAGE_VIEW, PHONE_CALL_LEAD, PURCHASE, QUALIFIED_LEAD, REQUEST_QUOTE, SIGNUP, STORE_SALE, STORE_VISIT, SUBMIT_LEAD_FORM, SUBSCRIBE_PAID, UNKNOWN, YOUTUBE_FOLLOW_ON_VIEWS. |
| ConversionActionName | String | SEGMENT | Conversion action name. |
| ConversionAdjustment | Bool | SEGMENT | This segments your conversion columns by the original conversion and |
| ConversionLagBucket | String | SEGMENT | An enum value representing the number of days between the impression and
The allowed values are EIGHT_TO_NINE_DAYS, ELEVEN_TO_TWELVE_DAYS, FIVE_TO_SIX_DAYS, FORTY_FIVE_TO_SIXTY_DAYS, FOURTEEN_TO_TWENTY_ONE_DAYS, FOUR_TO_FIVE_DAYS, LESS_THAN_ONE_DAY, NINE_TO_TEN_DAYS, ONE_TO_TWO_DAYS, SEVEN_TO_EIGHT_DAYS, SIXTY_TO_NINETY_DAYS, SIX_TO_SEVEN_DAYS, TEN_TO_ELEVEN_DAYS, THIRTEEN_TO_FOURTEEN_DAYS, THIRTY_TO_FORTY_FIVE_DAYS, THREE_TO_FOUR_DAYS, TWELVE_TO_THIRTEEN_DAYS, TWENTY_ONE_TO_THIRTY_DAYS, TWO_TO_THREE_DAYS, UNKNOWN. |
| ConversionOrAdjustmentLagBucket | String | SEGMENT | An enum value representing the number of days between the impression and
The allowed values are ADJUSTMENT_EIGHT_TO_NINE_DAYS, ADJUSTMENT_ELEVEN_TO_TWELVE_DAYS, ADJUSTMENT_FIVE_TO_SIX_DAYS, ADJUSTMENT_FORTY_FIVE_TO_SIXTY_DAYS, ADJUSTMENT_FOURTEEN_TO_TWENTY_ONE_DAYS, ADJUSTMENT_FOUR_TO_FIVE_DAYS, ADJUSTMENT_LESS_THAN_ONE_DAY, ADJUSTMENT_NINETY_TO_ONE_HUNDRED_AND_FORTY_FIVE_DAYS, ADJUSTMENT_NINE_TO_TEN_DAYS, ADJUSTMENT_ONE_TO_TWO_DAYS, ADJUSTMENT_SEVEN_TO_EIGHT_DAYS, ADJUSTMENT_SIXTY_TO_NINETY_DAYS, ADJUSTMENT_SIX_TO_SEVEN_DAYS, ADJUSTMENT_TEN_TO_ELEVEN_DAYS, ADJUSTMENT_THIRTEEN_TO_FOURTEEN_DAYS, ADJUSTMENT_THIRTY_TO_FORTY_FIVE_DAYS, ADJUSTMENT_THREE_TO_FOUR_DAYS, ADJUSTMENT_TWELVE_TO_THIRTEEN_DAYS, ADJUSTMENT_TWENTY_ONE_TO_THIRTY_DAYS, ADJUSTMENT_TWO_TO_THREE_DAYS, ADJUSTMENT_UNKNOWN, CONVERSION_EIGHT_TO_NINE_DAYS, CONVERSION_ELEVEN_TO_TWELVE_DAYS, CONVERSION_FIVE_TO_SIX_DAYS, CONVERSION_FORTY_FIVE_TO_SIXTY_DAYS, CONVERSION_FOURTEEN_TO_TWENTY_ONE_DAYS, CONVERSION_FOUR_TO_FIVE_DAYS, CONVERSION_LESS_THAN_ONE_DAY, CONVERSION_NINE_TO_TEN_DAYS, CONVERSION_ONE_TO_TWO_DAYS, CONVERSION_SEVEN_TO_EIGHT_DAYS, CONVERSION_SIXTY_TO_NINETY_DAYS, CONVERSION_SIX_TO_SEVEN_DAYS, CONVERSION_TEN_TO_ELEVEN_DAYS, CONVERSION_THIRTEEN_TO_FOURTEEN_DAYS, CONVERSION_THIRTY_TO_FORTY_FIVE_DAYS, CONVERSION_THREE_TO_FOUR_DAYS, CONVERSION_TWELVE_TO_THIRTEEN_DAYS, CONVERSION_TWENTY_ONE_TO_THIRTY_DAYS, CONVERSION_TWO_TO_THREE_DAYS, CONVERSION_UNKNOWN, UNKNOWN. |
| Date | Date | SEGMENT | Date to which metrics apply. |
| DayOfWeek | String | SEGMENT | Day of the week, for example, MONDAY.
The allowed values are FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY. |
| Device | String | SEGMENT | Device to which metrics apply.
The allowed values are CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN. |
| ExternalConversionSource | String | SEGMENT | External conversion source.
The allowed values are AD_CALL_METRICS, ANALYTICS, ANALYTICS_SEARCH_ADS_360, ANDROID_FIRST_OPEN, ANDROID_IN_APP, APP_UNSPECIFIED, CLICK_TO_CALL, DISPLAY_AND_VIDEO_360_FLOODLIGHT, FIREBASE, FIREBASE_SEARCH_ADS_360, FLOODLIGHT, GOOGLE_ATTRIBUTION, GOOGLE_HOSTED, GOOGLE_PLAY, IOS_FIRST_OPEN, IOS_IN_APP, SALESFORCE, SEARCH_ADS_360, STORE_SALES, STORE_SALES_CRM, STORE_SALES_DIRECT_UPLOAD, STORE_SALES_PAYMENT_NETWORK, STORE_VISITS, THIRD_PARTY_APP_ANALYTICS, UNKNOWN, UPLOAD, UPLOAD_CALLS, WEBPAGE, WEBSITE_CALL_METRICS. |
| Hour | Int | SEGMENT | Hour of day as a number between 0 and 23, inclusive. |
| Month | Date | SEGMENT | Month as represented by the date of the first day of a month. Formatted as |
| MonthOfYear | String | SEGMENT | Month of the year, for example, January.
The allowed values are APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN. |
| NewVersusReturningCustomers | String | SEGMENT | This is for segmenting conversions by whether the user is a new customer
The allowed values are NEW, NEW_AND_HIGH_LTV, RETURNING, UNKNOWN. |
| Period | String | SEGMENT | Predefined date range.
The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN. |
| Quarter | Date | SEGMENT | Quarter as represented by the date of the first day of a quarter. |
| Slot | String | SEGMENT | Position of the ad.
The allowed values are CONTENT, MIXED, SEARCH_OTHER, SEARCH_PARTNER_OTHER, SEARCH_PARTNER_TOP, SEARCH_SIDE, SEARCH_TOP, UNKNOWN. |
| TravelDestinationCity | String | SEGMENT | The city the user is searching for at query time. |
| TravelDestinationCountry | String | SEGMENT | The country the user is searching for at query time. |
| TravelDestinationRegion | String | SEGMENT | The region the user is searching for at query time. |
| VerticalAdsEventParticipantDisplayNames | String | SEGMENT | The display names of participants in an event listing, like performers, |
| VerticalAdsHotelClass | Long | SEGMENT | The class of the hotel. Generally in the range of 1 to 5 stars, but fully |
| VerticalAdsListing | String | SEGMENT | The listing associated with a listing impression, click or conversion. |
| VerticalAdsListingBrand | String | SEGMENT | The brand associated with a specific listing within a Vertical Ads |
| VerticalAdsListingCity | String | SEGMENT | The city where the vertical ads listing is located. |
| VerticalAdsListingCountry | String | SEGMENT | The country where the vertical ads listing is located. |
| VerticalAdsListingRegion | String | SEGMENT | The region where the vertical ads listing is located. |
| VerticalAdsPartnerAccount | Long | SEGMENT | A specific partner account within a Partner Center (for example, Hotel |
| VerticalAdsVertical | String | SEGMENT | Type of vertical ad, such as Vacation Rentals, Car Rentals, or
The allowed values are EVENTS, FLIGHTS, HOTELS, RENTAL_CARS, THINGS_TO_DO, UNKNOWN, VACATION_RENTALS. |
| Week | Date | SEGMENT | Week as defined as Monday through Sunday, and represented by the date of |
| Year | Int | SEGMENT | Year, formatted as yyyy. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |