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

ActionItems column for table AdGroupAd

AdGroupAdAdAddedByGoogleAds

Bool

Attribute

AdAddedByGoogleAds column for table AdGroupAd

AdGroupAdAdAppAdDescriptions

String

Attribute

AdAppAdDescriptions column for table AdGroupAd

AdGroupAdAdAppAdHeadlines

String

Attribute

AdAppAdHeadlines column for table AdGroupAd

AdGroupAdAdAppAdHtml5MediaBundles

String

Attribute

AdAppAdHtml5MediaBundles column for table AdGroupAd

AdGroupAdAdAppAdImages

String

Attribute

AdAppAdImages column for table AdGroupAd

AdGroupAdAdAppAdMandatoryAdText

String

Attribute

AdAppAdMandatoryAdText column for table AdGroupAd

AdGroupAdAdAppAdYoutubeVideos

String

Attribute

AdAppAdYoutubeVideos column for table AdGroupAd

AdGroupAdAdAppEngagementAdDescriptions

String

Attribute

AdAppEngagementAdDescriptions column for table AdGroupAd

AdGroupAdAdAppEngagementAdHeadlines

String

Attribute

AdAppEngagementAdHeadlines column for table AdGroupAd

AdGroupAdAdAppEngagementAdImages

String

Attribute

AdAppEngagementAdImages column for table AdGroupAd

AdGroupAdAdAppEngagementAdVideos

String

Attribute

AdAppEngagementAdVideos column for table AdGroupAd

AdGroupAdAdCallAdBusinessName

String

Attribute

AdCallAdBusinessName column for table AdGroupAd

AdGroupAdAdCallAdCallTracked

Bool

Attribute

AdCallAdCallTracked column for table AdGroupAd

AdGroupAdAdCallAdConversionAction

String

Attribute

AdCallAdConversionAction column for table AdGroupAd

AdGroupAdAdCallAdConversionReportingState

String

Attribute

AdCallAdConversionReportingState column for table AdGroupAd

AdGroupAdAdCallAdCountryCode

String

Attribute

AdCallAdCountryCode column for table AdGroupAd

AdGroupAdAdCallAdDescription1

String

Attribute

AdCallAdDescription1 column for table AdGroupAd

AdGroupAdAdCallAdDescription2

String

Attribute

AdCallAdDescription2 column for table AdGroupAd

AdGroupAdAdCallAdDisableCallConversion

Bool

Attribute

AdCallAdDisableCallConversion column for table AdGroupAd

AdGroupAdAdCallAdHeadline1

String

Attribute

AdCallAdHeadline1 column for table AdGroupAd

AdGroupAdAdCallAdHeadline2

String

Attribute

AdCallAdHeadline2 column for table AdGroupAd

AdGroupAdAdCallAdPath1

String

Attribute

AdCallAdPath1 column for table AdGroupAd

AdGroupAdAdCallAdPath2

String

Attribute

AdCallAdPath2 column for table AdGroupAd

AdGroupAdAdCallAdPhoneNumber

String

Attribute

AdCallAdPhoneNumber column for table AdGroupAd

AdGroupAdAdCallAdPhoneNumberVerificationUrl

String

Attribute

AdCallAdPhoneNumberVerificationUrl column for table AdGroupAd

AdGroupAdAdDevicePreference

String

Attribute

AdDevicePreference column for table AdGroupAd

AdGroupAdAdDisplayUploadAdDisplayUploadProductType

String

Attribute

AdDisplayUploadAdDisplayUploadProductType column for table AdGroupAd

AdGroupAdAdDisplayUploadAdMediaBundle

String

Attribute

AdDisplayUploadAdMediaBundle column for table AdGroupAd

AdGroupAdAdDisplayUrl

String

Attribute

AdDisplayUrl column for table AdGroupAd

AdGroupAdAdExpandedDynamicSearchAdDescription

String

Attribute

AdExpandedDynamicSearchAdDescription column for table AdGroupAd

AdGroupAdAdExpandedDynamicSearchAdDescription2

String

Attribute

AdExpandedDynamicSearchAdDescription2 column for table AdGroupAd

AdGroupAdAdExpandedTextAdDescription

String

Attribute

AdExpandedTextAdDescription column for table AdGroupAd

AdGroupAdAdExpandedTextAdDescription2

String

Attribute

AdExpandedTextAdDescription2 column for table AdGroupAd

AdGroupAdAdExpandedTextAdHeadlinePart1

String

Attribute

AdExpandedTextAdHeadlinePart1 column for table AdGroupAd

AdGroupAdAdExpandedTextAdHeadlinePart2

String

Attribute

AdExpandedTextAdHeadlinePart2 column for table AdGroupAd

AdGroupAdAdExpandedTextAdHeadlinePart3

String

Attribute

AdExpandedTextAdHeadlinePart3 column for table AdGroupAd

AdGroupAdAdExpandedTextAdPath1

String

Attribute

AdExpandedTextAdPath1 column for table AdGroupAd

AdGroupAdAdExpandedTextAdPath2

String

Attribute

AdExpandedTextAdPath2 column for table AdGroupAd

AdGroupAdAdFinalAppUrls

String

Attribute

AdFinalAppUrls column for table AdGroupAd

AdGroupAdAdFinalMobileUrls

String

Attribute

AdFinalMobileUrls column for table AdGroupAd

AdGroupAdAdFinalUrlSuffix

String

Attribute

AdFinalUrlSuffix column for table AdGroupAd

AdGroupAdAdFinalUrls

String

Attribute

AdFinalUrls column for table AdGroupAd

AdGroupAdAdGmailAdHeaderImage

String

Attribute

AdGmailAdHeaderImage column for table AdGroupAd

AdGroupAdAdGmailAdMarketingImage

String

Attribute

AdGmailAdMarketingImage column for table AdGroupAd

AdGroupAdAdGmailAdMarketingImageDescription

String

Attribute

AdGmailAdMarketingImageDescription column for table AdGroupAd

AdGroupAdAdGmailAdMarketingImageDisplayCallToActionText

String

Attribute

AdGmailAdMarketingImageDisplayCallToActionText column for table AdGroupAd

AdGroupAdAdGmailAdMarketingImageDisplayCallToActionTextColor

String

Attribute

AdGmailAdMarketingImageDisplayCallToActionTextColor column for table AdGroupAd

AdGroupAdAdGmailAdMarketingImageDisplayCallToActionUrlCollectionId

String

Attribute

AdGmailAdMarketingImageDisplayCallToActionUrlCollectionId column for table AdGroupAd

AdGroupAdAdGmailAdMarketingImageHeadline

String

Attribute

AdGmailAdMarketingImageHeadline column for table AdGroupAd

AdGroupAdAdGmailAdProductImages

String

Attribute

AdGmailAdProductImages column for table AdGroupAd

AdGroupAdAdGmailAdProductVideos

String

Attribute

AdGmailAdProductVideos column for table AdGroupAd

AdGroupAdAdGmailAdTeaserBusinessName

String

Attribute

AdGmailAdTeaserBusinessName column for table AdGroupAd

AdGroupAdAdGmailAdTeaserDescription

String

Attribute

AdGmailAdTeaserDescription column for table AdGroupAd

AdGroupAdAdGmailAdTeaserHeadline

String

Attribute

AdGmailAdTeaserHeadline column for table AdGroupAd

AdGroupAdAdGmailAdTeaserLogoImage

String

Attribute

AdGmailAdTeaserLogoImage column for table AdGroupAd

AdGroupAdAdHotelAd

String

Attribute

AdHotelAd column for table AdGroupAd

AdGroupAdAdId

Long

Attribute

AdId column for table AdGroupAd

AdGroupAdAdImageAdImageUrl

String

Attribute

AdImageAdImageUrl column for table AdGroupAd

AdGroupAdAdImageAdMimeType

String

Attribute

AdImageAdMimeType column for table AdGroupAd

AdGroupAdAdImageAdName

String

Attribute

AdImageAdName column for table AdGroupAd

AdGroupAdAdImageAdPixelHeight

Long

Attribute

AdImageAdPixelHeight column for table AdGroupAd

AdGroupAdAdImageAdPixelWidth

Long

Attribute

AdImageAdPixelWidth column for table AdGroupAd

AdGroupAdAdImageAdPreviewImageUrl

String

Attribute

AdImageAdPreviewImageUrl column for table AdGroupAd

AdGroupAdAdImageAdPreviewPixelHeight

Long

Attribute

AdImageAdPreviewPixelHeight column for table AdGroupAd

AdGroupAdAdImageAdPreviewPixelWidth

Long

Attribute

AdImageAdPreviewPixelWidth column for table AdGroupAd

AdGroupAdAdLegacyAppInstallAd

String

Attribute

AdLegacyAppInstallAd column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdAccentColor

String

Attribute

AdLegacyResponsiveDisplayAdAccentColor column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdAllowFlexibleColor

Bool

Attribute

AdLegacyResponsiveDisplayAdAllowFlexibleColor column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdBusinessName

String

Attribute

AdLegacyResponsiveDisplayAdBusinessName column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdCallToActionText

String

Attribute

AdLegacyResponsiveDisplayAdCallToActionText column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdDescription

String

Attribute

AdLegacyResponsiveDisplayAdDescription column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdFormatSetting

String

Attribute

AdLegacyResponsiveDisplayAdFormatSetting column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdLogoImage

String

Attribute

AdLegacyResponsiveDisplayAdLogoImage column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdLongHeadline

String

Attribute

AdLegacyResponsiveDisplayAdLongHeadline column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdMainColor

String

Attribute

AdLegacyResponsiveDisplayAdMainColor column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdMarketingImage

String

Attribute

AdLegacyResponsiveDisplayAdMarketingImage column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdPricePrefix

String

Attribute

AdLegacyResponsiveDisplayAdPricePrefix column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdPromoText

String

Attribute

AdLegacyResponsiveDisplayAdPromoText column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdShortHeadline

String

Attribute

AdLegacyResponsiveDisplayAdShortHeadline column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdSquareLogoImage

String

Attribute

AdLegacyResponsiveDisplayAdSquareLogoImage column for table AdGroupAd

AdGroupAdAdLegacyResponsiveDisplayAdSquareMarketingImage

String

Attribute

AdLegacyResponsiveDisplayAdSquareMarketingImage column for table AdGroupAd

AdGroupAdAdLocalAdCallToActions

String

Attribute

AdLocalAdCallToActions column for table AdGroupAd

AdGroupAdAdLocalAdDescriptions

String

Attribute

AdLocalAdDescriptions column for table AdGroupAd

AdGroupAdAdLocalAdHeadlines

String

Attribute

AdLocalAdHeadlines column for table AdGroupAd

AdGroupAdAdLocalAdLogoImages

String

Attribute

AdLocalAdLogoImages column for table AdGroupAd

AdGroupAdAdLocalAdMarketingImages

String

Attribute

AdLocalAdMarketingImages column for table AdGroupAd

AdGroupAdAdLocalAdPath1

String

Attribute

AdLocalAdPath1 column for table AdGroupAd

AdGroupAdAdLocalAdPath2

String

Attribute

AdLocalAdPath2 column for table AdGroupAd

AdGroupAdAdLocalAdVideos

String

Attribute

AdLocalAdVideos column for table AdGroupAd

AdGroupAdAdName

String

Attribute

AdName column for table AdGroupAd

AdGroupAdAdResourceName

String

Attribute

AdResourceName column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdAccentColor

String

Attribute

AdResponsiveDisplayAdAccentColor column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdAllowFlexibleColor

Bool

Attribute

AdResponsiveDisplayAdAllowFlexibleColor column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdBusinessName

String

Attribute

AdResponsiveDisplayAdBusinessName column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdCallToActionText

String

Attribute

AdResponsiveDisplayAdCallToActionText column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdControlSpecEnableAssetEnhancements

Bool

Attribute

AdResponsiveDisplayAdControlSpecEnableAssetEnhancements column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdControlSpecEnableAutogenVideo

Bool

Attribute

AdResponsiveDisplayAdControlSpecEnableAutogenVideo column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdDescriptions

String

Attribute

AdResponsiveDisplayAdDescriptions column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdFormatSetting

String

Attribute

AdResponsiveDisplayAdFormatSetting column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdHeadlines

String

Attribute

AdResponsiveDisplayAdHeadlines column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdLogoImages

String

Attribute

AdResponsiveDisplayAdLogoImages column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdLongHeadline

String

Attribute

AdResponsiveDisplayAdLongHeadline column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdMainColor

String

Attribute

AdResponsiveDisplayAdMainColor column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdMarketingImages

String

Attribute

AdResponsiveDisplayAdMarketingImages column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdPricePrefix

String

Attribute

AdResponsiveDisplayAdPricePrefix column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdPromoText

String

Attribute

AdResponsiveDisplayAdPromoText column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdSquareLogoImages

String

Attribute

AdResponsiveDisplayAdSquareLogoImages column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdSquareMarketingImages

String

Attribute

AdResponsiveDisplayAdSquareMarketingImages column for table AdGroupAd

AdGroupAdAdResponsiveDisplayAdYoutubeVideos

String

Attribute

AdResponsiveDisplayAdYoutubeVideos column for table AdGroupAd

AdGroupAdAdResponsiveSearchAdDescriptions

String

Attribute

AdResponsiveSearchAdDescriptions column for table AdGroupAd

AdGroupAdAdResponsiveSearchAdHeadlines

String

Attribute

AdResponsiveSearchAdHeadlines column for table AdGroupAd

AdGroupAdAdResponsiveSearchAdPath1

String

Attribute

AdResponsiveSearchAdPath1 column for table AdGroupAd

AdGroupAdAdResponsiveSearchAdPath2

String

Attribute

AdResponsiveSearchAdPath2 column for table AdGroupAd

AdGroupAdAdShoppingComparisonListingAdHeadline

String

Attribute

AdShoppingComparisonListingAdHeadline column for table AdGroupAd

AdGroupAdAdShoppingProductAd

String

Attribute

AdShoppingProductAd column for table AdGroupAd

AdGroupAdAdShoppingSmartAd

String

Attribute

AdShoppingSmartAd column for table AdGroupAd

AdGroupAdAdSmartCampaignAdDescriptions

String

Attribute

AdSmartCampaignAdDescriptions column for table AdGroupAd

AdGroupAdAdSmartCampaignAdHeadlines

String

Attribute

AdSmartCampaignAdHeadlines column for table AdGroupAd

AdGroupAdAdSystemManagedResourceSource

String

Attribute

AdSystemManagedResourceSource column for table AdGroupAd

AdGroupAdAdTextAdDescription1

String

Attribute

AdTextAdDescription1 column for table AdGroupAd

AdGroupAdAdTextAdDescription2

String

Attribute

AdTextAdDescription2 column for table AdGroupAd

AdGroupAdAdTextAdHeadline

String

Attribute

AdTextAdHeadline column for table AdGroupAd

AdGroupAdAdTrackingUrlTemplate

String

Attribute

AdTrackingUrlTemplate column for table AdGroupAd

AdGroupAdAdType

String

Attribute

AdType column for table AdGroupAd

AdGroupAdAdUrlCollections

String

Attribute

AdUrlCollections column for table AdGroupAd

AdGroupAdAdUrlCustomParameters

String

Attribute

AdUrlCustomParameters column for table AdGroupAd

AdGroupAdAdVideoAdBumperCompanionBanner

String

Attribute

AdVideoAdBumperCompanionBanner column for table AdGroupAd

AdGroupAdAdVideoAdDiscoveryDescription1

String

Attribute

AdVideoAdDiscoveryDescription1 column for table AdGroupAd

AdGroupAdAdVideoAdDiscoveryDescription2

String

Attribute

AdVideoAdDiscoveryDescription2 column for table AdGroupAd

AdGroupAdAdVideoAdDiscoveryHeadline

String

Attribute

AdVideoAdDiscoveryHeadline column for table AdGroupAd

AdGroupAdAdVideoAdInStreamActionButtonLabel

String

Attribute

AdVideoAdInStreamActionButtonLabel column for table AdGroupAd

AdGroupAdAdVideoAdInStreamActionHeadline

String

Attribute

AdVideoAdInStreamActionHeadline column for table AdGroupAd

AdGroupAdAdVideoAdInStreamCompanionBanner

String

Attribute

AdVideoAdInStreamCompanionBanner column for table AdGroupAd

AdGroupAdAdVideoAdMediaFile

String

Attribute

AdVideoAdMediaFile column for table AdGroupAd

AdGroupAdAdVideoAdNonSkippableCompanionBanner

String

Attribute

AdVideoAdNonSkippableCompanionBanner column for table AdGroupAd

AdGroupAdAdVideoAdOutStreamDescription

String

Attribute

AdVideoAdOutStreamDescription column for table AdGroupAd

AdGroupAdAdVideoAdOutStreamHeadline

String

Attribute

AdVideoAdOutStreamHeadline column for table AdGroupAd

AdGroupAdAdVideoResponsiveAdCallToActions

String

Attribute

AdVideoResponsiveAdCallToActions column for table AdGroupAd

AdGroupAdAdVideoResponsiveAdCompanionBanners

String

Attribute

AdVideoResponsiveAdCompanionBanners column for table AdGroupAd

AdGroupAdAdVideoResponsiveAdDescriptions

String

Attribute

AdVideoResponsiveAdDescriptions column for table AdGroupAd

AdGroupAdAdVideoResponsiveAdHeadlines

String

Attribute

AdVideoResponsiveAdHeadlines column for table AdGroupAd

AdGroupAdAdVideoResponsiveAdLongHeadlines

String

Attribute

AdVideoResponsiveAdLongHeadlines column for table AdGroupAd

AdGroupAdAdVideoResponsiveAdVideos

String

Attribute

AdVideoResponsiveAdVideos column for table AdGroupAd

AdGroupAdAdGroup

String

Attribute

AdGroup column for table AdGroupAd

AdGroupAdAdStrength

String

Attribute

AdStrength column for table AdGroupAd

AdGroupAdLabels

String

Attribute

Labels column for table AdGroupAd

AdGroupAdPolicySummaryApprovalStatus

String

Attribute

PolicySummaryApprovalStatus column for table AdGroupAd

AdGroupAdPolicySummaryPolicyTopicEntries

String

Attribute

PolicySummaryPolicyTopicEntries column for table AdGroupAd

AdGroupAdPolicySummaryReviewStatus

String

Attribute

PolicySummaryReviewStatus column for table AdGroupAd

AdGroupAdResourceName

String

Attribute

ResourceName column for table AdGroupAd

AdGroupAdStatus

String

Attribute

Status column for table AdGroupAd

CustomerId

Long

Attribute

ClientCustomerId column for table AdGroupAd

AbsoluteTopImpressionPercentage

Double

Metric

AbsoluteTopImpressionPercentage column for table Metrics

ActiveViewCpm

Double

Metric

ActiveViewCpm column for table Metrics

ActiveViewCtr

Double

Metric

ActiveViewCtr column for table Metrics

ActiveViewImpressions

Long

Metric

ActiveViewImpressions column for table Metrics

ActiveViewMeasurability

Double

Metric

ActiveViewMeasurability column for table Metrics

ActiveViewMeasurableCostMicros

Long

Metric

ActiveViewMeasurableCostMicros column for table Metrics

ActiveViewMeasurableImpressions

Long

Metric

ActiveViewMeasurableImpressions column for table Metrics

ActiveViewViewability

Double

Metric

ActiveViewViewability column for table Metrics

AllConversions

Double

Metric

AllConversions column for table Metrics

AllConversionsByConversionDate

Double

Metric

AllConversionsByConversionDate column for table Metrics

AllConversionsFromInteractionsRate

Double

Metric

AllConversionsFromInteractionsRate column for table Metrics

AllConversionsValue

Double

Metric

AllConversionsValue column for table Metrics

AllConversionsValueByConversionDate

Double

Metric

AllConversionsValueByConversionDate column for table Metrics

AverageCost

Double

Metric

AverageCost column for table Metrics

AverageCpc

Double

Metric

AverageCpc column for table Metrics

AverageCpe

Double

Metric

AverageCpe column for table Metrics

AverageCpm

Double

Metric

AverageCpm column for table Metrics

AverageCpv

Double

Metric

AverageCpv column for table Metrics

AveragePageViews

Double

Metric

AveragePageViews column for table Metrics

AverageTimeOnSite

Double

Metric

AverageTimeOnSite column for table Metrics

BounceRate

Double

Metric

BounceRate column for table Metrics

Clicks

Long

Metric

Clicks column for table Metrics

Conversions

Double

Metric

Conversions column for table Metrics

ConversionsByConversionDate

Double

Metric

ConversionsByConversionDate column for table Metrics

ConversionsFromInteractionsRate

Double

Metric

ConversionsFromInteractionsRate column for table Metrics

ConversionsValue

Double

Metric

ConversionsValue column for table Metrics

ConversionsValueByConversionDate

Double

Metric

ConversionsValueByConversionDate column for table Metrics

CostMicros

Long

Metric

CostMicros column for table Metrics

CostPerAllConversions

Double

Metric

CostPerAllConversions column for table Metrics

CostPerConversion

Double

Metric

CostPerConversion column for table Metrics

CostPerCurrentModelAttributedConversion

Double

Metric

CostPerCurrentModelAttributedConversion column for table Metrics

CrossDeviceConversions

Double

Metric

CrossDeviceConversions column for table Metrics

Ctr

Double

Metric

Ctr column for table Metrics

CurrentModelAttributedConversions

Double

Metric

CurrentModelAttributedConversions column for table Metrics

CurrentModelAttributedConversionsValue

Double

Metric

CurrentModelAttributedConversionsValue column for table Metrics

EngagementRate

Double

Metric

EngagementRate column for table Metrics

Engagements

Long

Metric

Engagements column for table Metrics

GmailForwards

Long

Metric

GmailForwards column for table Metrics

GmailSaves

Long

Metric

GmailSaves column for table Metrics

GmailSecondaryClicks

Long

Metric

GmailSecondaryClicks column for table Metrics

Impressions

Long

Metric

Impressions column for table Metrics

InteractionEventTypes

String

Metric

InteractionEventTypes column for table Metrics

InteractionRate

Double

Metric

InteractionRate column for table Metrics

Interactions

Long

Metric

Interactions column for table Metrics

PercentNewVisitors

Double

Metric

PercentNewVisitors column for table Metrics

TopImpressionPercentage

Double

Metric

TopImpressionPercentage column for table Metrics

ValuePerAllConversions

Double

Metric

ValuePerAllConversions column for table Metrics

ValuePerAllConversionsByConversionDate

Double

Metric

ValuePerAllConversionsByConversionDate column for table Metrics

ValuePerConversion

Double

Metric

ValuePerConversion column for table Metrics

ValuePerConversionsByConversionDate

Double

Metric

ValuePerConversionsByConversionDate column for table Metrics

ValuePerCurrentModelAttributedConversion

Double

Metric

ValuePerCurrentModelAttributedConversion column for table Metrics

VideoQuartileP100Rate

Double

Metric

VideoQuartileP100Rate column for table Metrics

VideoQuartileP25Rate

Double

Metric

VideoQuartileP25Rate column for table Metrics

VideoQuartileP50Rate

Double

Metric

VideoQuartileP50Rate column for table Metrics

VideoQuartileP75Rate

Double

Metric

VideoQuartileP75Rate column for table Metrics

VideoViewRate

Double

Metric

VideoViewRate column for table Metrics

VideoViews

Long

Metric

VideoViews column for table Metrics

ViewThroughConversions

Long

Metric

ViewThroughConversions column for table Metrics

AdDestinationType

String

Segment

AdDestinationType column for table Segments

AdNetworkType

String

Segment

AdNetworkType column for table Segments

ClickType

String

Segment

ClickType column for table Segments

ConversionAction

String

Segment

ConversionAction column for table Segments

ConversionActionCategory

String

Segment

ConversionActionCategory column for table Segments

ConversionActionName

String

Segment

ConversionActionName column for table Segments

ConversionAdjustment

Bool

Segment

ConversionAdjustment column for table Segments

ConversionLagBucket

String

Segment

ConversionLagBucket column for table Segments

ConversionOrAdjustmentLagBucket

String

Segment

ConversionOrAdjustmentLagBucket column for table Segments

Date

Date

Segment

Date column for table Segments

DayOfWeek

String

Segment

DayOfWeek column for table Segments

Device

String

Segment

Device column for table Segments

ExternalConversionSource

String

Segment

ExternalConversionSource column for table Segments

KeywordAdGroupCriterion

String

Segment

KeywordAdGroupCriterion column for table Segments

KeywordInfoMatchType

String

Segment

KeywordInfoMatchType column for table Segments

KeywordInfoText

String

Segment

KeywordInfoText column for table Segments

Month

Date

Segment

Month column for table Segments

MonthOfYear

String

Segment

MonthOfYear column for table Segments

Quarter

Date

Segment

Quarter column for table Segments

Slot

String

Segment

Slot column for table Segments

Week

Date

Segment

Week column for table Segments

Year

Int

Segment

Year column for table Segments

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.

Last updated