AdGroupAd
An ad group ad.
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 |
| AdGroupAdActionItems | String | ATTRIBUTE | Output only. A list of recommendations to improve the ad strength. For example, a recommendation could be 'Your headlines are a little too similar. Try adding more distinct headlines.'. |
| AdGroupAdAdAddedByGoogleAds | Bool | ATTRIBUTE | Output only. Indicates if this ad was automatically added by Google Ads and not by a user. For example, this could happen when ads are automatically created as suggestions for new ads based on knowledge of how existing ads are performing. |
| AdGroupAdAdAppAdDescriptions | String | ATTRIBUTE | List of text assets for descriptions. When the ad serves the descriptions will be selected from this list. |
| AdGroupAdAdAppAdHeadlines | String | ATTRIBUTE | List of text assets for headlines. When the ad serves the headlines will be selected from this list. |
| AdGroupAdAdAppAdHtml5MediaBundles | String | ATTRIBUTE | List of media bundle assets that may be used with the ad. |
| AdGroupAdAdAppAdImages | String | ATTRIBUTE | List of image assets that may be displayed with the ad. |
| AdGroupAdAdAppAdMandatoryAdText | String | ATTRIBUTE | Mandatory ad text. |
| AdGroupAdAdAppAdYoutubeVideos | String | ATTRIBUTE | List of YouTube video assets that may be displayed with the ad. |
| AdGroupAdAdAppEngagementAdDescriptions | String | ATTRIBUTE | List of text assets for descriptions. When the ad serves the descriptions will be selected from this list. |
| AdGroupAdAdAppEngagementAdHeadlines | String | ATTRIBUTE | List of text assets for headlines. When the ad serves the headlines will be selected from this list. |
| AdGroupAdAdAppEngagementAdImages | String | ATTRIBUTE | List of image assets that may be displayed with the ad. |
| AdGroupAdAdAppEngagementAdVideos | String | ATTRIBUTE | List of video assets that may be displayed with the ad. |
| AdGroupAdAdAppPreRegistrationAdDescriptions | String | ATTRIBUTE | List of text assets for descriptions. When the ad serves the descriptions will be selected from this list. |
| AdGroupAdAdAppPreRegistrationAdHeadlines | String | ATTRIBUTE | List of text assets for headlines. When the ad serves the headlines will be selected from this list. |
| AdGroupAdAdAppPreRegistrationAdImages | String | ATTRIBUTE | List of image asset IDs whose images may be displayed with the ad. |
| AdGroupAdAdAppPreRegistrationAdYoutubeVideos | String | ATTRIBUTE | List of YouTube video asset IDs whose videos may be displayed with the ad. |
| AdGroupAdAdCallAdBusinessName | String | ATTRIBUTE | The business name in the ad. |
| AdGroupAdAdCallAdCallTracked | Bool | ATTRIBUTE | Whether to enable call tracking for the creative. Enabling call tracking also enables call conversions. |
| AdGroupAdAdCallAdConversionAction | String | ATTRIBUTE | The conversion action to attribute a call conversion to. If not set a default conversion action is used. This field only has effect if call_tracked is set to true. Otherwise this field is ignored. |
| AdGroupAdAdCallAdConversionReportingState | String | ATTRIBUTE | The call conversion behavior of this call ad. It can use its own call conversion setting, inherit the account level setting, or be disabled.
The allowed values are DISABLED, UNKNOWN, UNSPECIFIED, USE_ACCOUNT_LEVEL_CALL_CONVERSION_ACTION, USE_RESOURCE_LEVEL_CALL_CONVERSION_ACTION. |
| AdGroupAdAdCallAdCountryCode | String | ATTRIBUTE | The country code in the ad. |
| AdGroupAdAdCallAdDescription1 | String | ATTRIBUTE | The first line of the ad's description. |
| AdGroupAdAdCallAdDescription2 | String | ATTRIBUTE | The second line of the ad's description. |
| AdGroupAdAdCallAdDisableCallConversion | Bool | ATTRIBUTE | Whether to disable call conversion for the creative. If set to true, disables call conversions even when call_tracked is true. If call_tracked is false, this field is ignored. |
| AdGroupAdAdCallAdHeadline1 | String | ATTRIBUTE | First headline in the ad. |
| AdGroupAdAdCallAdHeadline2 | String | ATTRIBUTE | Second headline in the ad. |
| AdGroupAdAdCallAdPath1 | String | ATTRIBUTE | First part of text that can be appended to the URL in the ad. Optional. |
| AdGroupAdAdCallAdPath2 | String | ATTRIBUTE | Second part of text that can be appended to the URL in the ad. This field can only be set when path1 is also set. Optional. |
| AdGroupAdAdCallAdPhoneNumber | String | ATTRIBUTE | The phone number in the ad. |
| AdGroupAdAdCallAdPhoneNumberVerificationUrl | String | ATTRIBUTE | The URL to be used for phone number verification. |
| AdGroupAdAdDevicePreference | String | ATTRIBUTE | The device preference for the ad. You can only specify a preference for mobile devices. When this preference is set the ad will be preferred over other ads when being displayed on a mobile device. The ad can still be displayed on other device types, for example, if no other ads are available. If unspecified (no device preference), all devices are targeted. This is only supported by some ad types.
The allowed values are CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN, UNSPECIFIED. |
| AdGroupAdAdDiscoveryCarouselAdBusinessName | String | ATTRIBUTE | Required. The Advertiser/brand name. |
| AdGroupAdAdDiscoveryCarouselAdCallToActionText | String | ATTRIBUTE | Call to action text. |
| AdGroupAdAdDiscoveryCarouselAdCarouselCards | String | ATTRIBUTE | Required. Carousel cards that will display with the ad. Min 2 max 10. |
| AdGroupAdAdDiscoveryCarouselAdDescription | String | ATTRIBUTE | Required. The descriptive text of the ad. |
| AdGroupAdAdDiscoveryCarouselAdHeadline | String | ATTRIBUTE | Required. Headline of the ad. |
| AdGroupAdAdDiscoveryCarouselAdLogoImage | String | ATTRIBUTE | Required. Logo image to be used in the ad. The minimum size is 128x128 and the aspect ratio must be 1:1(+-1%). |
| AdGroupAdAdDiscoveryMultiAssetAdBusinessName | String | ATTRIBUTE | The Advertiser/brand name. Maximum display width is 25. Required. |
| AdGroupAdAdDiscoveryMultiAssetAdCallToActionText | String | ATTRIBUTE | Call to action text. |
| AdGroupAdAdDiscoveryMultiAssetAdDescriptions | String | ATTRIBUTE | The descriptive text of the ad. Maximum display width is 90. At least 1 and max 5 descriptions can be specified. |
| AdGroupAdAdDiscoveryMultiAssetAdHeadlines | String | ATTRIBUTE | Headline text asset of the ad. Maximum display width is 30. At least 1 and max 5 headlines can be specified. |
| AdGroupAdAdDiscoveryMultiAssetAdLeadFormOnly | Bool | ATTRIBUTE | Boolean option that indicates if this ad must be served with lead form. |
| AdGroupAdAdDiscoveryMultiAssetAdLogoImages | String | ATTRIBUTE | Logo image assets to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 128x128 and the aspect ratio must be 1:1(+-1%). At least 1 and max 5 logo images can be specified. |
| AdGroupAdAdDiscoveryMultiAssetAdMarketingImages | String | ATTRIBUTE | Marketing image assets to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 600x314 and the aspect ratio must be 1.91:1 (+-1%). Required if square_marketing_images is not present. Combined with square_marketing_images and portrait_marketing_images the maximum is 20. |
| AdGroupAdAdDiscoveryMultiAssetAdPortraitMarketingImages | String | ATTRIBUTE | Portrait marketing image assets to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 480x600 and the aspect ratio must be 4:5 (+-1%). Combined with marketing_images and square_marketing_images the maximum is 20. |
| AdGroupAdAdDiscoveryMultiAssetAdSquareMarketingImages | String | ATTRIBUTE | Square marketing image assets to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 300x300 and the aspect ratio must be 1:1 (+-1%). Required if marketing_images is not present. Combined with marketing_images and portrait_marketing_images the maximum is 20. |
| AdGroupAdAdDisplayUploadAdDisplayUploadProductType | String | ATTRIBUTE | The product type of this ad. See comments on the enum for details.
The allowed values are DYNAMIC_HTML5_CUSTOM_AD, DYNAMIC_HTML5_EDUCATION_AD, DYNAMIC_HTML5_FLIGHT_AD, DYNAMIC_HTML5_HOTEL_AD, DYNAMIC_HTML5_HOTEL_RENTAL_AD, DYNAMIC_HTML5_JOB_AD, DYNAMIC_HTML5_LOCAL_AD, DYNAMIC_HTML5_REAL_ESTATE_AD, DYNAMIC_HTML5_TRAVEL_AD, HTML5_UPLOAD_AD, UNKNOWN, UNSPECIFIED. |
| AdGroupAdAdDisplayUploadAdMediaBundle | String | ATTRIBUTE | A media bundle asset to be used in the ad. For information about the media bundle for HTML5_UPLOAD_AD, see https://support.google.com/google-ads/answer/1722096 Media bundles that are part of dynamic product types use a special format that needs to be created through the Google Web Designer. See https://support.google.com/webdesigner/answer/7543898 for more information. |
| AdGroupAdAdDisplayUrl | String | ATTRIBUTE | The URL that appears in the ad description for some ad formats. |
| AdGroupAdAdExpandedDynamicSearchAdDescription | String | ATTRIBUTE | The description of the ad. |
| AdGroupAdAdExpandedDynamicSearchAdDescription2 | String | ATTRIBUTE | The second description of the ad. |
| AdGroupAdAdExpandedTextAdDescription | String | ATTRIBUTE | The description of the ad. |
| AdGroupAdAdExpandedTextAdDescription2 | String | ATTRIBUTE | The second description of the ad. |
| AdGroupAdAdExpandedTextAdHeadlinePart1 | String | ATTRIBUTE | The first part of the ad's headline. |
| AdGroupAdAdExpandedTextAdHeadlinePart2 | String | ATTRIBUTE | The second part of the ad's headline. |
| AdGroupAdAdExpandedTextAdHeadlinePart3 | String | ATTRIBUTE | The third part of the ad's headline. |
| AdGroupAdAdExpandedTextAdPath1 | String | ATTRIBUTE | The text that can appear alongside the ad's displayed URL. |
| AdGroupAdAdExpandedTextAdPath2 | String | ATTRIBUTE | Additional text that can appear alongside the ad's displayed URL. |
| AdGroupAdAdFinalAppUrls | String | ATTRIBUTE | A list of final app URLs that will be used on mobile if the user has the specific app installed. |
| AdGroupAdAdFinalMobileUrls | String | ATTRIBUTE | The list of possible final mobile URLs after all cross-domain redirects for the ad. |
| AdGroupAdAdFinalUrlSuffix | String | ATTRIBUTE | The suffix to use when constructing a final URL. |
| AdGroupAdAdFinalUrls | String | ATTRIBUTE | The list of possible final URLs after all cross-domain redirects for the ad. |
| AdGroupAdAdHotelAd | String | ATTRIBUTE | Details pertaining to a hotel ad. |
| AdGroupAdAdId | Long | ATTRIBUTE | Output only. The ID of the ad. |
| AdGroupAdAdImageAdImageUrl | String | ATTRIBUTE | URL of the full size image. |
| AdGroupAdAdImageAdMimeType | String | ATTRIBUTE | The mime type of the image.
The allowed values are AUDIO_MP3, AUDIO_WAV, FLASH, HTML5_AD_ZIP, IMAGE_GIF, IMAGE_JPEG, IMAGE_PNG, MSEXCEL, MSWORD, PDF, RTF, TEXT_HTML, UNKNOWN, UNSPECIFIED. |
| AdGroupAdAdImageAdName | String | ATTRIBUTE | The name of the image. If the image was created from a MediaFile, this is the MediaFile's name. If the image was created from bytes, this is empty. |
| AdGroupAdAdImageAdPixelHeight | Long | ATTRIBUTE | Height in pixels of the full size image. |
| AdGroupAdAdImageAdPixelWidth | Long | ATTRIBUTE | Width in pixels of the full size image. |
| AdGroupAdAdImageAdPreviewImageUrl | String | ATTRIBUTE | URL of the preview size image. |
| AdGroupAdAdImageAdPreviewPixelHeight | Long | ATTRIBUTE | Height in pixels of the preview size image. |
| AdGroupAdAdImageAdPreviewPixelWidth | Long | ATTRIBUTE | Width in pixels of the preview size image. |
| AdGroupAdAdLegacyAppInstallAd | String | ATTRIBUTE | Immutable. Details pertaining to a legacy app install ad. |
| AdGroupAdAdLegacyResponsiveDisplayAdAccentColor | String | ATTRIBUTE | The accent color of the ad in hexadecimal, for example, #ffffff for white. If one of main_color and accent_color is set, the other is required as well. |
| AdGroupAdAdLegacyResponsiveDisplayAdAllowFlexibleColor | Bool | ATTRIBUTE | Advertiser's consent to allow flexible color. When true, the ad may be served with different color if necessary. When false, the ad will be served with the specified colors or a neutral color. The default value is true. Must be true if main_color and accent_color are not set. |
| AdGroupAdAdLegacyResponsiveDisplayAdBusinessName | String | ATTRIBUTE | The business name in the ad. |
| AdGroupAdAdLegacyResponsiveDisplayAdCallToActionText | String | ATTRIBUTE | The call-to-action text for the ad. |
| AdGroupAdAdLegacyResponsiveDisplayAdDescription | String | ATTRIBUTE | The description of the ad. |
| AdGroupAdAdLegacyResponsiveDisplayAdFormatSetting | String | ATTRIBUTE | Specifies which format the ad will be served in. Default is ALL_FORMATS.
The allowed values are ALL_FORMATS, NATIVE, NON_NATIVE, UNKNOWN, UNSPECIFIED. |
| AdGroupAdAdLegacyResponsiveDisplayAdLogoImage | String | ATTRIBUTE | The MediaFile resource name of the logo image used in the ad. |
| AdGroupAdAdLegacyResponsiveDisplayAdLongHeadline | String | ATTRIBUTE | The long version of the ad's headline. |
| AdGroupAdAdLegacyResponsiveDisplayAdMainColor | String | ATTRIBUTE | The main color of the ad in hexadecimal, for example, #ffffff for white. If one of main_color and accent_color is set, the other is required as well. |
| AdGroupAdAdLegacyResponsiveDisplayAdMarketingImage | String | ATTRIBUTE | The MediaFile resource name of the marketing image used in the ad. |
| AdGroupAdAdLegacyResponsiveDisplayAdPricePrefix | String | ATTRIBUTE | Prefix before price. For example, 'as low as'. |
| AdGroupAdAdLegacyResponsiveDisplayAdPromoText | String | ATTRIBUTE | Promotion text used for dynamic formats of responsive ads. For example 'Free two-day shipping'. |
| AdGroupAdAdLegacyResponsiveDisplayAdShortHeadline | String | ATTRIBUTE | The short version of the ad's headline. |
| AdGroupAdAdLegacyResponsiveDisplayAdSquareLogoImage | String | ATTRIBUTE | The MediaFile resource name of the square logo image used in the ad. |
| AdGroupAdAdLegacyResponsiveDisplayAdSquareMarketingImage | String | ATTRIBUTE | The MediaFile resource name of the square marketing image used in the ad. |
| AdGroupAdAdLocalAdCallToActions | String | ATTRIBUTE | List of text assets for call-to-actions. When the ad serves the call-to-actions will be selected from this list. At least 1 and at most 5 call-to-actions must be specified. |
| AdGroupAdAdLocalAdDescriptions | String | ATTRIBUTE | List of text assets for descriptions. When the ad serves the descriptions will be selected from this list. At least 1 and at most 5 descriptions must be specified. |
| AdGroupAdAdLocalAdHeadlines | String | ATTRIBUTE | List of text assets for headlines. When the ad serves the headlines will be selected from this list. At least 1 and at most 5 headlines must be specified. |
| AdGroupAdAdLocalAdLogoImages | String | ATTRIBUTE | List of logo image assets that may be displayed with the ad. The images must be 128x128 pixels and not larger than 120KB. At least 1 and at most 5 image assets must be specified. |
| AdGroupAdAdLocalAdMarketingImages | String | ATTRIBUTE | List of marketing image assets that may be displayed with the ad. The images must be 314x600 pixels or 320x320 pixels. At least 1 and at most 20 image assets must be specified. |
| AdGroupAdAdLocalAdPath1 | String | ATTRIBUTE | First part of optional text that can be appended to the URL in the ad. |
| AdGroupAdAdLocalAdPath2 | String | ATTRIBUTE | Second part of optional text that can be appended to the URL in the ad. This field can only be set when path1 is also set. |
| AdGroupAdAdLocalAdVideos | String | ATTRIBUTE | List of YouTube video assets that may be displayed with the ad. At least 1 and at most 20 video assets must be specified. |
| AdGroupAdAdName | String | ATTRIBUTE | Immutable. The name of the ad. This is only used to be able to identify the ad. It does not need to be unique and does not affect the served ad. The name field is currently only supported for DisplayUploadAd, ImageAd, ShoppingComparisonListingAd and VideoAd. |
| AdGroupAdAdResourceName | String | ATTRIBUTE | Immutable. The resource name of the ad. Ad resource names have the form: customers/{customer_id}/ads/{ad_id} |
| AdGroupAdAdResponsiveDisplayAdAccentColor | String | ATTRIBUTE | The accent color of the ad in hexadecimal, for example, #ffffff for white. If one of main_color and accent_color is set, the other is required as well. |
| AdGroupAdAdResponsiveDisplayAdAllowFlexibleColor | Bool | ATTRIBUTE | Advertiser's consent to allow flexible color. When true, the ad may be served with different color if necessary. When false, the ad will be served with the specified colors or a neutral color. The default value is true. Must be true if main_color and accent_color are not set. |
| AdGroupAdAdResponsiveDisplayAdBusinessName | String | ATTRIBUTE | The advertiser/brand name. Maximum display width is 25. |
| AdGroupAdAdResponsiveDisplayAdCallToActionText | String | ATTRIBUTE | The call-to-action text for the ad. Maximum display width is 30. |
| AdGroupAdAdResponsiveDisplayAdControlSpecEnableAssetEnhancements | Bool | ATTRIBUTE | Whether the advertiser has opted into the asset enhancements feature. |
| AdGroupAdAdResponsiveDisplayAdControlSpecEnableAutogenVideo | Bool | ATTRIBUTE | Whether the advertiser has opted into auto-gen video feature. |
| AdGroupAdAdResponsiveDisplayAdDescriptions | String | ATTRIBUTE | Descriptive texts for the ad. The maximum length is 90 characters. At least 1 and max 5 headlines can be specified. |
| AdGroupAdAdResponsiveDisplayAdFormatSetting | String | ATTRIBUTE | Specifies which format the ad will be served in. Default is ALL_FORMATS.
The allowed values are ALL_FORMATS, NATIVE, NON_NATIVE, UNKNOWN, UNSPECIFIED. |
| AdGroupAdAdResponsiveDisplayAdHeadlines | String | ATTRIBUTE | Short format headlines for the ad. The maximum length is 30 characters. At least 1 and max 5 headlines can be specified. |
| AdGroupAdAdResponsiveDisplayAdLogoImages | String | ATTRIBUTE | Logo images to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 512x128 and the aspect ratio must be 4:1 (+-1%). Combined with square_logo_images, the maximum is 5. |
| AdGroupAdAdResponsiveDisplayAdLongHeadline | String | ATTRIBUTE | A required long format headline. The maximum length is 90 characters. |
| AdGroupAdAdResponsiveDisplayAdMainColor | String | ATTRIBUTE | The main color of the ad in hexadecimal, for example, #ffffff for white. If one of main_color and accent_color is set, the other is required as well. |
| AdGroupAdAdResponsiveDisplayAdMarketingImages | String | ATTRIBUTE | Marketing images to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 600x314 and the aspect ratio must be 1.91:1 (+-1%). At least one marketing_image is required. Combined with square_marketing_images, the maximum is 15. |
| AdGroupAdAdResponsiveDisplayAdPricePrefix | String | ATTRIBUTE | Prefix before price. For example, 'as low as'. |
| AdGroupAdAdResponsiveDisplayAdPromoText | String | ATTRIBUTE | Promotion text used for dynamic formats of responsive ads. For example 'Free two-day shipping'. |
| AdGroupAdAdResponsiveDisplayAdSquareLogoImages | String | ATTRIBUTE | Square logo images to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 128x128 and the aspect ratio must be 1:1 (+-1%). Combined with square_logo_images, the maximum is 5. |
| AdGroupAdAdResponsiveDisplayAdSquareMarketingImages | String | ATTRIBUTE | Square marketing images to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 300x300 and the aspect ratio must be 1:1 (+-1%). At least one square marketing_image is required. Combined with marketing_images, the maximum is 15. |
| AdGroupAdAdResponsiveDisplayAdYoutubeVideos | String | ATTRIBUTE | Optional YouTube videos for the ad. A maximum of 5 videos can be specified. |
| AdGroupAdAdResponsiveSearchAdDescriptions | String | ATTRIBUTE | List of text assets for descriptions. When the ad serves the descriptions will be selected from this list. |
| AdGroupAdAdResponsiveSearchAdHeadlines | String | ATTRIBUTE | List of text assets for headlines. When the ad serves the headlines will be selected from this list. |
| AdGroupAdAdResponsiveSearchAdPath1 | String | ATTRIBUTE | First part of text that can be appended to the URL in the ad. |
| AdGroupAdAdResponsiveSearchAdPath2 | String | ATTRIBUTE | Second part of text that can be appended to the URL in the ad. This field can only be set when path1 is also set. |
| AdGroupAdAdShoppingComparisonListingAdHeadline | String | ATTRIBUTE | Headline of the ad. This field is required. Allowed length is between 25 and 45 characters. |
| AdGroupAdAdShoppingProductAd | String | ATTRIBUTE | Details pertaining to a Shopping product ad. |
| AdGroupAdAdShoppingSmartAd | String | ATTRIBUTE | Details pertaining to a Smart Shopping ad. |
| AdGroupAdAdSmartCampaignAdDescriptions | String | ATTRIBUTE | List of text assets, each of which corresponds to a description when the ad serves. This list consists of a minimum of 2 and up to 4 text assets. |
| AdGroupAdAdSmartCampaignAdHeadlines | String | ATTRIBUTE | List of text assets, each of which corresponds to a headline when the ad serves. This list consists of a minimum of 3 and up to 15 text assets. |
| AdGroupAdAdSystemManagedResourceSource | String | ATTRIBUTE | Output only. If this ad is system managed, then this field will indicate the source. This field is read-only.
The allowed values are AD_VARIATIONS, UNKNOWN, UNSPECIFIED. |
| AdGroupAdAdTextAdDescription1 | String | ATTRIBUTE | The first line of the ad's description. |
| AdGroupAdAdTextAdDescription2 | String | ATTRIBUTE | The second line of the ad's description. |
| AdGroupAdAdTextAdHeadline | String | ATTRIBUTE | The headline of the ad. |
| AdGroupAdAdTrackingUrlTemplate | String | ATTRIBUTE | The URL template for constructing a tracking URL. |
| AdGroupAdAdType | String | ATTRIBUTE | Output only. The type of ad.
The allowed values are APP_AD, APP_ENGAGEMENT_AD, APP_PRE_REGISTRATION_AD, CALL_AD, DISCOVERY_CAROUSEL_AD, DISCOVERY_MULTI_ASSET_AD, DYNAMIC_HTML5_AD, EXPANDED_DYNAMIC_SEARCH_AD, EXPANDED_TEXT_AD, HOTEL_AD, HTML5_UPLOAD_AD, IMAGE_AD, IN_FEED_VIDEO_AD, LEGACY_APP_INSTALL_AD, LEGACY_RESPONSIVE_DISPLAY_AD, LOCAL_AD, RESPONSIVE_DISPLAY_AD, RESPONSIVE_SEARCH_AD, SHOPPING_COMPARISON_LISTING_AD, SHOPPING_PRODUCT_AD, SHOPPING_SMART_AD, SMART_CAMPAIGN_AD, TEXT_AD, UNKNOWN, UNSPECIFIED, VIDEO_AD, VIDEO_BUMPER_AD, VIDEO_NON_SKIPPABLE_IN_STREAM_AD, VIDEO_OUTSTREAM_AD, VIDEO_RESPONSIVE_AD, VIDEO_TRUEVIEW_IN_STREAM_AD. |
| AdGroupAdAdUrlCollections | String | ATTRIBUTE | Additional URLs for the ad that are tagged with a unique identifier that can be referenced from other fields in the ad. |
| AdGroupAdAdUrlCustomParameters | String | ATTRIBUTE | The list of mappings that can be used to substitute custom parameter tags in a tracking_url_template, final_urls, or mobile_final_urls. For mutates, use url custom parameter operations. |
| AdGroupAdAdVideoAdBumperCompanionBannerAsset | String | ATTRIBUTE | The Asset resource name of this image. |
| AdGroupAdAdVideoAdInFeedDescription1 | String | ATTRIBUTE | First text line for the ad. |
| AdGroupAdAdVideoAdInFeedDescription2 | String | ATTRIBUTE | Second text line for the ad. |
| AdGroupAdAdVideoAdInFeedHeadline | String | ATTRIBUTE | The headline of the ad. |
| AdGroupAdAdVideoAdInFeedThumbnail | String | ATTRIBUTE | Video thumbnail image to use.
The allowed values are DEFAULT_THUMBNAIL, THUMBNAIL_1, THUMBNAIL_2, THUMBNAIL_3, UNKNOWN, UNSPECIFIED. |
| AdGroupAdAdVideoAdInStreamActionButtonLabel | String | ATTRIBUTE | Label on the CTA (call-to-action) button taking the user to the video ad's final URL. Required for TrueView for action campaigns, optional otherwise. |
| AdGroupAdAdVideoAdInStreamActionHeadline | String | ATTRIBUTE | Additional text displayed with the CTA (call-to-action) button to give context and encourage clicking on the button. |
| AdGroupAdAdVideoAdInStreamCompanionBannerAsset | String | ATTRIBUTE | The Asset resource name of this image. |
| AdGroupAdAdVideoAdNonSkippableActionButtonLabel | String | ATTRIBUTE | Label on the 'Call To Action' button taking the user to the video ad's final URL. |
| AdGroupAdAdVideoAdNonSkippableActionHeadline | String | ATTRIBUTE | Additional text displayed with the 'Call To Action' button to give context and encourage clicking on the button. |
| AdGroupAdAdVideoAdNonSkippableCompanionBannerAsset | String | ATTRIBUTE | The Asset resource name of this image. |
| AdGroupAdAdVideoAdOutStreamDescription | String | ATTRIBUTE | The description line. |
| AdGroupAdAdVideoAdOutStreamHeadline | String | ATTRIBUTE | The headline of the ad. |
| AdGroupAdAdVideoAdVideoAsset | String | ATTRIBUTE | The Asset resource name of this video. |
| AdGroupAdAdVideoResponsiveAdBreadcrumb1 | String | ATTRIBUTE | First part of text that appears in the ad with the displayed URL. |
| AdGroupAdAdVideoResponsiveAdBreadcrumb2 | String | ATTRIBUTE | Second part of text that appears in the ad with the displayed URL. |
| AdGroupAdAdVideoResponsiveAdCallToActions | String | ATTRIBUTE | List of text assets used for the button, for example, the 'Call To Action' button. Currently, only a single value for the button is supported. |
| AdGroupAdAdVideoResponsiveAdCompanionBanners | String | ATTRIBUTE | List of image assets used for the companion banner. Currently, only a single value for the companion banner asset is supported. |
| AdGroupAdAdVideoResponsiveAdDescriptions | String | ATTRIBUTE | List of text assets used for the description. Currently, only a single value for the description is supported. |
| AdGroupAdAdVideoResponsiveAdHeadlines | String | ATTRIBUTE | List of text assets used for the short headline, for example, the 'Call To Action' banner. Currently, only a single value for the short headline is supported. |
| AdGroupAdAdVideoResponsiveAdLongHeadlines | String | ATTRIBUTE | List of text assets used for the long headline. Currently, only a single value for the long headline is supported. |
| AdGroupAdAdVideoResponsiveAdVideos | String | ATTRIBUTE | List of YouTube video assets used for the ad. Currently, only a single value for the YouTube video asset is supported. |
| AdGroupAdAdGroup | String | ATTRIBUTE | Immutable. The ad group to which the ad belongs. |
| AdGroupAdAdStrength | String | ATTRIBUTE | Output only. Overall ad strength for this ad group ad.
The allowed values are AVERAGE, EXCELLENT, GOOD, NO_ADS, PENDING, POOR, UNKNOWN, UNSPECIFIED. |
| AdGroupAdLabels | String | ATTRIBUTE | Output only. The resource names of labels attached to this ad group ad. |
| AdGroupAdPolicySummaryApprovalStatus | String | ATTRIBUTE | Output only. The overall approval status of this ad, calculated based on the status of its individual policy topic entries.
The allowed values are APPROVED, APPROVED_LIMITED, AREA_OF_INTEREST_ONLY, DISAPPROVED, UNKNOWN, UNSPECIFIED. |
| AdGroupAdPolicySummaryPolicyTopicEntries | String | ATTRIBUTE | Output only. The list of policy findings for this ad. |
| AdGroupAdPolicySummaryReviewStatus | String | ATTRIBUTE | Output only. Where in the review process this ad is.
The allowed values are ELIGIBLE_MAY_SERVE, REVIEWED, REVIEW_IN_PROGRESS, UNDER_APPEAL, UNKNOWN, UNSPECIFIED. |
| AdGroupAdResourceName | String | ATTRIBUTE | Immutable. The resource name of the ad. Ad group ad resource names have the form: customers/{customer_id}/adGroupAds/{ad_group_id}~{ad_id} |
| AdGroupAdStatus | String | ATTRIBUTE | The status of the ad.
The allowed values are ENABLED, PAUSED, REMOVED, UNKNOWN, UNSPECIFIED. |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| AbsoluteTopImpressionPercentage | Double | METRIC | The percent of your ad impressions that are shown as the very first ad above the organic search results. |
| ActiveViewCpm | Double | METRIC | Average cost of viewable impressions (active_view_impressions). |
| ActiveViewCtr | Double | METRIC | Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network. |
| ActiveViewImpressions | Long | METRIC | A measurement of how often your ad has become viewable on a Display Network site. |
| ActiveViewMeasurability | Double | METRIC | The ratio of impressions that could be measured by Active View over the number of served impressions. |
| ActiveViewMeasurableCostMicros | Long | METRIC | The cost of the impressions you received that were measurable by Active View. |
| ActiveViewMeasurableImpressions | Long | METRIC | The number of times your ads are appearing on placements in positions where they can be seen. |
| ActiveViewViewability | Double | METRIC | The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions). |
| AllConversions | Double | METRIC | The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. |
| AllConversionsByConversionDate | Double | METRIC | The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/google-ads/answer/9549009. |
| AllConversionsFromInteractionsRate | Double | METRIC | All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions. |
| AllConversionsValue | Double | METRIC | The value of all conversions. |
| AllConversionsValueByConversionDate | Double | METRIC | The value of all conversions. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/google-ads/answer/9549009. |
| AverageCost | Double | METRIC | The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions. |
| AverageCpc | Double | METRIC | The total cost of all clicks divided by the total number of clicks received. |
| AverageCpe | Double | METRIC | The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements. |
| AverageCpm | Double | METRIC | Average cost-per-thousand impressions (CPM). |
| AverageCpv | Double | METRIC | The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views. |
| AveragePageViews | Double | METRIC | Average number of pages viewed per session. |
| AverageTimeOnSite | Double | METRIC | Total duration of all sessions (in seconds) / number of sessions. Imported from Google Analytics. |
| BounceRate | Double | METRIC | Percentage of clicks where the user only visited a single page on your site. Imported from Google Analytics. |
| Clicks | Long | METRIC | The number of clicks. |
| Conversions | Double | METRIC | The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| ConversionsByConversionDate | Double | METRIC | The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/google-ads/answer/9549009. |
| ConversionsFromInteractionsRate | Double | METRIC | Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| ConversionsValue | Double | METRIC | The value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| ConversionsValueByConversionDate | Double | METRIC | The value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/google-ads/answer/9549009. |
| CostMicros | Long | METRIC | The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. |
| 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 conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| CostPerCurrentModelAttributedConversion | Double | METRIC | The cost of ad interactions divided by current model attributed conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| CrossDeviceConversions | Double | METRIC | Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions. |
| Ctr | Double | METRIC | The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). |
| CurrentModelAttributedConversions | Double | METRIC | Shows how your historic conversions data would look under the attribution model you've currently selected. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| CurrentModelAttributedConversionsValue | Double | METRIC | The value of current model attributed conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| EngagementRate | Double | METRIC | How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown. |
| Engagements | Long | METRIC | The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics. |
| 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 message. |
| GmailSecondaryClicks | Long | METRIC | The number of clicks to the landing page on the expanded state of Gmail ads. |
| Impressions | Long | METRIC | Count of how often your ad has appeared on a search results page or website on the Google Network. |
| InteractionEventTypes | String | METRIC | The types of payable and free interactions.
The allowed values are UNSPECIFIED, UNKNOWN, CLICK, ENGAGEMENT, VIDEO_VIEW, NONE. |
| InteractionRate | Double | METRIC | How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown. |
| Interactions | Long | METRIC | The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on. |
| PercentNewVisitors | Double | METRIC | Percentage of first-time sessions (from people who had never visited your site before). Imported from Google Analytics. |
| TopImpressionPercentage | Double | METRIC | The percent of your ad impressions that are shown anywhere above the organic search results. |
| 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 this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/google-ads/answer/9549009. |
| ValuePerConversion | Double | METRIC | The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| ValuePerConversionsByConversionDate | Double | METRIC | The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/google-ads/answer/9549009. |
| ValuePerCurrentModelAttributedConversion | Double | METRIC | The value of current model attributed conversions divided by the number of the conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| 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. |
| VideoViewRate | Double | METRIC | The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads. |
| VideoViews | Long | METRIC | The number of times your video ads were viewed. |
| ViewThroughConversions | Long | METRIC | The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (for example, clicking on) another ad. |
| 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, UNSPECIFIED, WEBSITE, YOUTUBE. |
| AdNetworkType | String | SEGMENT | Ad network type.
The allowed values are CONTENT, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, UNSPECIFIED, YOUTUBE_SEARCH, YOUTUBE_WATCH. |
| ClickType | String | SEGMENT | Click type.
The allowed values are APP_DEEPLINK, BREADCRUMBS, BROADBAND_PLAN, CALLS, CALL_TRACKING, CLICK_ON_ENGAGEMENT_AD, 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_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, UNKNOWN, UNSPECIFIED, URL_CLICKS, VIDEO_APP_STORE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_END_CAP_CLICKS, 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, UNSPECIFIED. |
| ConversionActionName | String | SEGMENT | Conversion action name. |
| ConversionAdjustment | Bool | SEGMENT | This segments your conversion columns by the original conversion and conversion value versus the delta if conversions were adjusted. False row has the data as originally stated; While true row has the delta between data now and the data as originally stated. Summing the two together results post-adjustment data. |
| ConversionLagBucket | String | SEGMENT | An enum value representing the number of days between the impression and the conversion.
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, UNSPECIFIED. |
| ConversionOrAdjustmentLagBucket | String | SEGMENT | An enum value representing the number of days between the impression and the conversion or between the impression and adjustments to the conversion.
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, UNSPECIFIED. |
| Date | Date | SEGMENT | Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. |
| DayOfWeek | String | SEGMENT | Day of the week, for example, MONDAY.
The allowed values are FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, UNSPECIFIED, WEDNESDAY. |
| Device | String | SEGMENT | Device to which metrics apply.
The allowed values are CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN, UNSPECIFIED. |
| 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, UNSPECIFIED, UPLOAD, UPLOAD_CALLS, WEBPAGE, WEBSITE_CALL_METRICS. |
| KeywordAdGroupCriterion | String | SEGMENT | The AdGroupCriterion resource name. |
| KeywordInfoMatchType | String | SEGMENT | The match type of the keyword.
The allowed values are BROAD, EXACT, PHRASE, UNKNOWN, UNSPECIFIED. |
| KeywordInfoText | String | SEGMENT | The text of the keyword (at most 80 characters and 10 words). |
| Month | Date | SEGMENT | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. |
| 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, UNSPECIFIED. |
| 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. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. |
| 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, UNSPECIFIED. |
| Week | Date | SEGMENT | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. |
| Year | Int | SEGMENT | Year, formatted as yyyy. |
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. |