ADO.NET Provider for Google Ads

Build 26.0.9655

AdGroupAd

An ad group ad.

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
AdGroupAdActionItems String ATTRIBUTE Output only. A list of recommendations to improve the ad strength. For
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.
AdGroupAdAdAppAdAppDeepLink String ATTRIBUTE An app deep link asset that may be used with the ad.
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.
AdGroupAdAdDemandGenCarouselAdBusinessName String ATTRIBUTE Required. The Advertiser/brand name.
AdGroupAdAdDemandGenCarouselAdCallToActionText String ATTRIBUTE Call to action text.
AdGroupAdAdDemandGenCarouselAdCarouselCards String ATTRIBUTE Required. Carousel cards that will display with the ad. Min 2 max 10.
AdGroupAdAdDemandGenCarouselAdDescription String ATTRIBUTE Required. The descriptive text of the ad.
AdGroupAdAdDemandGenCarouselAdHeadline String ATTRIBUTE Required. Headline of the ad.
AdGroupAdAdDemandGenCarouselAdLogoImage 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%).
AdGroupAdAdDemandGenMultiAssetAdBusinessName String ATTRIBUTE The Advertiser/brand name. Maximum display width is 25. Required.
AdGroupAdAdDemandGenMultiAssetAdCallToActionText String ATTRIBUTE Call to action text.
AdGroupAdAdDemandGenMultiAssetAdDescriptions String ATTRIBUTE The descriptive text of the ad. Maximum display width is 90. At least 1 and max 5 descriptions can be specified.
AdGroupAdAdDemandGenMultiAssetAdHeadlines String ATTRIBUTE Headline text asset of the ad. Maximum display width is 30. At least 1 and max 5 headlines can be specified.
AdGroupAdAdDemandGenMultiAssetAdLogoImages 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.
AdGroupAdAdDemandGenMultiAssetAdMarketingImages 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, portrait_marketing_images, and tall_portrait_marketing_images the maximum is 20.
AdGroupAdAdDemandGenMultiAssetAdPortraitMarketingImages 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, square_marketing_images, and tall_portrait_marketing_images the maximum is 20.
AdGroupAdAdDemandGenMultiAssetAdSquareMarketingImages 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, portrait_marketing_images, and tall_portrait_marketing_images the maximum is 20.
AdGroupAdAdDemandGenMultiAssetAdTallPortraitMarketingImages String ATTRIBUTE Tall portrait marketing image assets to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 600x1067 and the aspect ratio must be 9:16 (+-1%). Combined with marketing_images, square_marketing_images, and portrait_marketing_images, the maximum is 20.
AdGroupAdAdDemandGenProductAdBreadcrumb1 String ATTRIBUTE First part of text that appears in the ad with the displayed URL.
AdGroupAdAdDemandGenProductAdBreadcrumb2 String ATTRIBUTE Second part of text that appears in the ad with the displayed URL.
AdGroupAdAdDemandGenProductAdBusinessName String ATTRIBUTE Required. The advertiser/brand name.
AdGroupAdAdDemandGenProductAdCallToAction String ATTRIBUTE Asset of type CallToActionAsset used for the 'Call To Action' button.
AdGroupAdAdDemandGenProductAdDescription String ATTRIBUTE Required. Text asset used for the description.
AdGroupAdAdDemandGenProductAdHeadline String ATTRIBUTE Required. Text asset used for the short headline.
AdGroupAdAdDemandGenProductAdLogoImage String ATTRIBUTE Required. Logo image 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%).
AdGroupAdAdDemandGenVideoResponsiveAdBreadcrumb1 String ATTRIBUTE First part of text that appears in the ad with the displayed URL.
AdGroupAdAdDemandGenVideoResponsiveAdBreadcrumb2 String ATTRIBUTE Second part of text that appears in the ad with the displayed URL.
AdGroupAdAdDemandGenVideoResponsiveAdBusinessName String ATTRIBUTE Required. The advertiser/brand name.
AdGroupAdAdDemandGenVideoResponsiveAdCallToActions String ATTRIBUTE Assets of type CallToActionAsset used for the 'Call To Action' button.
AdGroupAdAdDemandGenVideoResponsiveAdCompanionBanners String ATTRIBUTE List of image assets used for the companion banner. Currently, only a single value for the companion banner asset is supported.
AdGroupAdAdDemandGenVideoResponsiveAdDescriptions String ATTRIBUTE List of text assets used for the description.
AdGroupAdAdDemandGenVideoResponsiveAdHeadlines String ATTRIBUTE List of text assets used for the short headline.
AdGroupAdAdDemandGenVideoResponsiveAdLogoImages String ATTRIBUTE Logo image 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%).
AdGroupAdAdDemandGenVideoResponsiveAdLongHeadlines String ATTRIBUTE List of text assets used for the long headline.
AdGroupAdAdDemandGenVideoResponsiveAdVideos String ATTRIBUTE List of YouTube video assets used for the ad.
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.

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.

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.
AdGroupAdAdImageAdImageAssetAsset String ATTRIBUTE The Asset resource name of this image.
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.

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.

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, LegacyAppInstallAd, ShoppingComparisonListingAd, VideoAd, VideoResponsiveAd and DemandGen ads.
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.

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 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.

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.
AdGroupAdAdTravelAd String ATTRIBUTE Details pertaining to a travel ad.
AdGroupAdAdType String ATTRIBUTE Output only. The type of ad.

The allowed values are APP_AD, APP_ENGAGEMENT_AD, APP_PRE_REGISTRATION_AD, CALL_AD, DEMAND_GEN_CAROUSEL_AD, DEMAND_GEN_MULTI_ASSET_AD, DEMAND_GEN_PRODUCT_AD, DEMAND_GEN_VIDEO_RESPONSIVE_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, TRAVEL_AD, UNKNOWN, VIDEO_AD, VIDEO_BUMPER_AD, VIDEO_NON_SKIPPABLE_IN_STREAM_AD, VIDEO_RESPONSIVE_AD, VIDEO_TRUEVIEW_IN_STREAM_AD, YOUTUBE_AUDIO_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.
AdGroupAdAdVideoAdAudio String ATTRIBUTE YouTube Audio ad format.
AdGroupAdAdVideoAdBumperActionButtonLabel String ATTRIBUTE Label on the 'Call To Action' button taking the user to the video ad's final URL.
AdGroupAdAdVideoAdBumperActionHeadline String ATTRIBUTE Additional text displayed with the CTA (call-to-action) button to give context and encourage clicking on the button.
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.

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.
AdGroupAdAdVideoResponsiveAdBusinessName String ATTRIBUTE Optional advertiser/brand name. Maximum display width is 25 characters.
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. Currently, only a single value for the short headline is supported.
AdGroupAdAdVideoResponsiveAdLogoImages String ATTRIBUTE Optional logo image to be used in the ad. The minimum size is 128x128 and the aspect ratio must be 1:1(+-1%).
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.
AdGroupAdAdGroupAdAssetAutomationSettings String ATTRIBUTE Settings that control the types of asset automation. See the
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.

AdGroupAdEndDateTime Datetime ATTRIBUTE The last day and time when ad group ad serves. This is added on top of
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.

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.

AdGroupAdPrimaryStatus String ATTRIBUTE Output only. Provides aggregated view into why an ad group ad is not

The allowed values are ELIGIBLE, LIMITED, NOT_ELIGIBLE, PAUSED, PENDING, REMOVED, UNKNOWN.

AdGroupAdPrimaryStatusReasons String ATTRIBUTE Output only. Provides reasons for why an ad group ad is not serving or not

The allowed values are AD_GROUP_AD_APPROVED_LABELED, AD_GROUP_AD_AREA_OF_INTEREST_ONLY, AD_GROUP_AD_DISAPPROVED, AD_GROUP_AD_NO_ADS, AD_GROUP_AD_PAUSED, AD_GROUP_AD_POOR_QUALITY, AD_GROUP_AD_REMOVED, AD_GROUP_AD_UNDER_APPEAL, AD_GROUP_AD_UNDER_REVIEW, AD_GROUP_PAUSED, AD_GROUP_REMOVED, CAMPAIGN_ENDED, CAMPAIGN_PAUSED, CAMPAIGN_PENDING, CAMPAIGN_REMOVED, UNKNOWN.

AdGroupAdResourceName String ATTRIBUTE Immutable. The resource name of the ad.
AdGroupAdStartDateTime Datetime ATTRIBUTE The date and time when ad group ad starts serving. This is added on top of
AdGroupAdStatus String ATTRIBUTE The status of the ad.

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

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
BounceRate Double METRIC Percentage of clicks where the user only visited a single page on your
Clicks Long METRIC The number of clicks.
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,
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
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
RevenueMicros Long METRIC Revenue is the total amount you made from orders attributed to your ads.
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.

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.

KeywordAdGroupCriterion String SEGMENT The AdGroupCriterion resource name.
KeywordInfoMatchType String SEGMENT The match type of the keyword.

The allowed values are BROAD, EXACT, PHRASE, UNKNOWN.

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
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.

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655