What is Google ad performance?

The Ad Performance report includes all statistics aggregated at the ad level, one row per ad. If other segment fields are used, you may get more than one row per ad. See segmentation for more information. This is a single attribution report when CriterionId or IsNegative is requested. The CriterionId field will return any criteria that triggered the ad, not just keywords. Discovery campaigns are not supported when this report has Criteria fields added.

info_outline Attribute

layers Segment

show_chart Metric

Download this table in CSV format

AbsoluteTopImpressionPercentage

The percent of your ad impressions that are shown as the very first ad above the organic search results. See this Help Center article for details. A percentage can be returned as a real number ranging from 0.0 to 1.0. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AccentColor

The accent color for the responsive display ad.

AccountCurrencyCode

The currency of the Customer account.

AccountDescriptiveName

The descriptive name of the Customer account.

AccountTimeZone

Name of the timezone selected for the Customer account. For example: "(GMT-05:00) Eastern Time". This field does not reflect the current state of daylight saving time for the timezone.

ActiveViewCpm

Average cost of viewable impressions (ActiveViewImpressions). Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

ActiveViewCtr

How often people clicked your ad after it became viewable. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

ActiveViewImpressions

How often your ad has become viewable on a Display Network site.

ActiveViewMeasurability

The ratio of impressions that could be measured by Active View over the number of served impressions. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

ActiveViewMeasurableCost

The cost of the impressions you received that were measurable by Active View. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

ActiveViewMeasurableImpressions

The number of times your ads are appearing on placements in positions where they can be seen.

ActiveViewViewability

The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AdGroupId

The ID of the AdGroup.

AdGroupName

The name of the AdGroup.

AdGroupStatus

Status of the ad group.

AdNetworkType1

First level network type.

AdNetworkType2

Second level network type (includes search partners).

AdStrengthInfo

The strength information of the ad.

AdType

The type of the Ad. If the ad's type is not supported in the report request's API version, this field will have the value "unknown".

AllConversionRate

AllConversions divided by total clicks that can be conversion-tracked. This is how often a click on your ad resulted in a conversion. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AllConversions

Best estimate of the total number of conversions that Google Ads drives. Includes website, cross-device, and phone call conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AllConversionValue

The total value of all of your conversions, including those that are estimated. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AllowFlexibleColor

Whether the responsive display ad colors must be strictly used.

Automated

Indicates if this ad is automatically created by Google Ads.

AverageCost

The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

AverageCpc

The total cost of all clicks divided by the total number of clicks received. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

AverageCpe

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. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AverageCpm

Average Cost-per-thousand impressions (CPM). Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

AverageCpv

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. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AveragePageviews

Average number of pages viewed per session. Imported from Google Analytics. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AveragePosition

Your ad's position relative to those of other advertisers. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

AverageTimeOnSite

Total duration of all sessions (in seconds) / number of sessions. Imported from Google Analytics. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

BaseAdGroupId

The ID of base ad group of trial ad groups. For regular ad groups, this is equal to AdGroupId. For campaign-level user lists, this will always be 0.

BaseCampaignId

The ID of base campaign of trial campaigns. For regular campaigns, this is equal to CampaignId.

BounceRate

Percentage of clicks where the user only visited a single page on your site, formatted as "x.xx%". Imported from Google Analytics. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

BusinessName

The business name in a reponsive display ad.

CallOnlyPhoneNumber

The phone number of call-only ad.

CallToActionText

The call-to-action text for the responsive display ad.

CampaignId

The ID of the Campaign.

CampaignName

The name of the Campaign.

CampaignStatus

The status of the Campaign.

ClickAssistedConversions

The total number of conversions for which this keyword, ad, ad group, or campaign contributed to one or more assisted clicks. This field is formatted using US locale, i.e., using comma "," for thousands and dot "." for decimals.

ClickAssistedConversionsOverLastClickConversions

The total number of conversions for which this keyword, ad, ad group, or campaign received in assisted clicks divided by the total number of conversions for which it triggered the last click. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

ClickAssistedConversionValue

The total value of all conversions for which this keyword, ad, ad group, or campaign triggered assisted clicks. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

Clicks

The number of clicks.

ClickType

Indicates the click type for metric fields such as Impressions. Since ads that serve can be attributed to multiple click types, metric fields may be double-counted and thus totals may not be accurate, especially for Display network campaigns.

CombinedApprovalStatus

Approval status that combines review state and status.

ConversionAdjustment

Whether the conversion was adjusted or the conversion is original one.

ConversionAdjustmentLagBucket

The number of days between the impression and the conversion or between the impression and adjustments to the conversion.

ConversionCategoryName

A category that describes the action the user will take to complete a conversion. Prevents zero-conversion rows from being returned. Values: "Download", "Lead", "Purchase/Sale", "Signup", "View of a key page", and "Other".

ConversionLagBucket

Days between click and conversion.

ConversionRate

The number of conversions divided by total clicks that can be tracked to conversions. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

Conversions

The number of conversions for all conversion actions that you have opted into optimization. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

ConversionTrackerId

ID of the conversion tracker.

ConversionTypeName

The name of the conversion type. Prevents zero-conversion rows from being returned.

ConversionValue

The sum of conversion values for all conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

Cost

The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

CostPerAllConversion

Total cost divided by all conversions. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

CostPerConversion

The Cost attributable to conversion-tracked clicks divided by the number of conversions. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

CostPerCurrentModelAttributedConversion

Shows how your historic CostPerConversion data would look under the attribution model you've currently selected. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

CreativeDestinationUrl

Destination URL of the ad.

CreativeFinalAppUrls

List of final app URLs of the ad. List entries will start with one of: a) "android-app:" (for Android apps) or b) "os-app:" (for iOS apps). List elements are returned in JSON list format.

CreativeFinalMobileUrls

List of final mobile URLs of the ad. List elements are returned in JSON list format.

CreativeFinalUrls

List of final URLs of the ad. List elements are returned in JSON list format.

CreativeFinalUrlSuffix

The URL template for appending params to final URL of an ad.

CreativeTrackingUrlTemplate

Tracking template of the ad.

CreativeUrlCustomParameters

List of custom parameters of the ad. CustomParameters elements are returned in JSON map format.

CriterionId

The Criterion ID.

CriterionType

The type of criterion.

CrossDeviceConversions

Conversions from when a customer clicks on an ad on one device, then converts on a different device or browser. Cross-device conversions are already included in your AllConversions column. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

Ctr

The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

CurrentModelAttributedConversions

Shows how your historic Conversions data would look under the attribution model you've currently selected. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

CurrentModelAttributedConversionValue

Shows how your historic ConversionValue data would look under the attribution model you've currently selected. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

CustomerDescriptiveName

The descriptive name of the Customer.

Date

The date formatted as yyyy-MM-dd.

DayOfWeek

The name of the day of the week, e.g., "Monday".

Description

The descriptive text of an expanded text ad or responsive display ad.

Description1

Line 1 description of the Ad.

Description2

Line 2 description of the Ad.

Device

Device type where the impression was shown.

DevicePreference

Platform ID of the device preference. You can look up the corresponding name and other information in the Platforms reference.

DisplayUrl

Display URL of the Ad.

EngagementRate

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. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

Engagements

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.

EnhancedDisplayCreativeLandscapeLogoImageMediaId

The ID of the landscape logo image.

EnhancedDisplayCreativeLogoImageMediaId

The ID of the logo image used in the ResponsiveDisplayAd.

EnhancedDisplayCreativeMarketingImageMediaId

"The ID of the marketing image used in the ResponsiveDisplayAd."

EnhancedDisplayCreativeMarketingImageSquareMediaId

The ID of the square marketing image.

ExpandedDynamicSearchCreativeDescription2

The description 2 of the expanded dynamic search ad.

ExpandedTextAdDescription2

The description 2 of the expanded text ad.

ExpandedTextAdHeadlinePart3

The headline part 3 of the expanded text ad.

ExternalConversionSource

The source of conversion such as website, import from calls.

ExternalCustomerId

The Customer ID.

FormatSetting

The format setting of the responsive display ad.

GmailCreativeHeaderImageMediaId

The ID of the header image in the GmailAd.

GmailCreativeLogoImageMediaId

The ID of the logo image in the GmailAd teaser.

GmailCreativeMarketingImageMediaId

The ID of the marketing image in the GmailAd.

GmailForwards

The number of times your ad was forwarded to someone else as a message.

GmailSaves

The number of times someone has saved your Gmail ad to their inbox as a message.

GmailSecondaryClicks

The number of clicks to your landing page on the expanded state of Gmail ads.

GmailTeaserBusinessName

The business name in the GmailAd teaser.

GmailTeaserDescription

The description in the GmailAd teaser.

GmailTeaserHeadline

The headline in the GmailAd teaser.

Headline

The ad headline for a TextAd. For other ad types such as TemplateAds, this field will contain a string representation of the key attributes of the ad.

HeadlinePart1

The first part of an expanded text ad headline.

HeadlinePart2

The second part of an expanded text ad headline.

Id

ID of the main object of this row.

ImageAdUrl

Prefix this value with "https://tpc.googlesyndication.com/pageadimg/imgad?id=" to get the full URL.

ImageCreativeImageHeight

The height of the image ad. For other ad types, this will have no values.

ImageCreativeImageWidth

The width of the image ad. For other ad types, this will have no values.

ImageCreativeMimeType

Image mime type. Only populated for image ads.

ImageCreativeName

Name for the image ad.

ImpressionAssistedConversions

Total number of conversions for which this object triggered assist impressions prior to the last click. This field is formatted using US locale, i.e., using comma "," for thousands and dot "." for decimals.

ImpressionAssistedConversionsOverLastClickConversions

Total number of conversions for which this object triggered assist impressions divided by the total number of conversions for which this object triggered the last click. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

ImpressionAssistedConversionValue

Total value of all conversions for which this object triggered assist impressions. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

Impressions

Count of how often your ad has appeared on a search results page or website on the Google Network.

InteractionRate

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. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

Interactions

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.

InteractionTypes

The types of interactions that are reflected in the Interactions, InteractionRate, and AverageCost columns.

IsNegative

Indicates if the criterion for this row is a negative (exclusion) criterion.

LabelIds

List of label IDs for the main object of this row. List elements are returned in JSON list format.

Labels

List of label names for the main object of this row. List elements are returned in JSON list format.

LongHeadline

The long format of the headline in a responsive display ad.

MainColor

The main color for the responsive display ad.

MarketingImageCallToActionText

The call-to-action text for the GmailAd.

MarketingImageCallToActionTextColor

The call-to-action text color for the GmailAd.

MarketingImageDescription

The description of the marketing image in the GmailAd.

MarketingImageHeadline

The headline of the marketing image in the GmailAd.

Month

The first day of the month, formatted as yyyy-MM-dd.

MonthOfYear

The name of the month of the year, e.g., "December".

MultiAssetResponsiveDisplayAdAccentColor

The accentColor setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdAllowFlexibleColor

The allowFlexibleColor setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdBusinessName

The businessName setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdCallToActionText

The callToActionText setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdDescriptions

The descriptions setting for a MultiAssetResponsiveDisplayAd. List elements are returned in JSON list format. Each list element has fields from AssetLink and TextAsset entities. List elements are returned in JSON list format.

MultiAssetResponsiveDisplayAdDynamicSettingsPricePrefix

The dynamicSettingsPricePrefix setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdDynamicSettingsPromoText

The dynamicSettingsPromoText setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdFormatSetting

The formatSetting setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdHeadlines

The headline setting for a MultiAssetResponsiveDisplayAd. List elements are returned in JSON list format. Each list element has fields from AssetLink and TextAsset entities. List elements are returned in JSON list format.

MultiAssetResponsiveDisplayAdLandscapeLogoImages

The landscapeLogoImages setting for a MultiAssetResponsiveDisplayAd. List elements are returned in JSON list format. Each list element has fields from AssetLink and ImageAsset entities. List elements are returned in JSON list format.

MultiAssetResponsiveDisplayAdLogoImages

The logoImages setting for a MultiAssetResponsiveDisplayAd. List elements are returned in JSON list format. Each list element has fields from AssetLink and ImageAsset entities. List elements are returned in JSON list format.

MultiAssetResponsiveDisplayAdLongHeadline

The longHeadline setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdMainColor

The mainColor setting for a MultiAssetResponsiveDisplayAd.

MultiAssetResponsiveDisplayAdMarketingImages

The marketingImages setting for a MultiAssetResponsiveDisplayAd. List elements are returned in JSON list format. Each list element has fields from AssetLink and ImageAsset entities. List elements are returned in JSON list format.

MultiAssetResponsiveDisplayAdSquareMarketingImages

The squareMarketingImages setting for a MultiAssetResponsiveDisplayAd. List elements are returned in JSON list format. Each list element has fields from AssetLink and ImageAsset entities. List elements are returned in JSON list format.

MultiAssetResponsiveDisplayAdYouTubeVideos

YouTube video ID of the YouTube assets of multi-asset responsive display ad. List elements are returned in JSON list format.

Path2

The text that appears in the ad with the displayed URL for an expanded text ad.

Path2

In addition to "Path2", more text that appears in the ad with the displayed URL for an expanded text ad.

PercentNewVisitors

Percentage of first-time sessions (from people who had never visited your site before), formatted as "x.xx%". Imported from Google Analytics. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

PolicySummary

Policy information for an ad.

PricePrefix

The prefix shown before prices.

PromoText

The promotion text for the responsive display ad.

Quarter

The first day of the quarter, formatted as yyyy-MM-dd. Uses the calendar year for quarters, e.g., the second quarter of 2014 starts on 2014-04-01.

ResponsiveSearchAdDescriptions

A JSON string including details about all descriptive text for a responsive search ad, including the asset text, pinning, and performance label. List elements are returned in JSON list format.

ResponsiveSearchAdHeadlines

A JSON string including details about all headlines for a responsive search ad, including the asset text, pinning, and performance label. List elements are returned in JSON list format.

ResponsiveSearchAdPath2

The text that appears in the ad with the displayed URL for a responsive search ad.

ResponsiveSearchAdPath2

In addition to "ResponsiveSearchAdPath2", more text that appears in the ad with the displayed URL for a responsive search ad.

ShortHeadline

The short format of the headline in a responsive display ad.

Slot

The position of the Ad.

Status

The status of the main object in this row. For example, in a Campaign Performance Report this will be the status of each row's Campaign. In an Ad Group Performance Report this will be the status of each row's AdGroup.

SystemManagedEntitySource

Indicates the source of a system-generated entity.

TopImpressionPercentage

The percent of your ad impressions that are shown anywhere above the organic search results. See this Help Center article for details. A percentage can be returned as a real number ranging from 0.0 to 1.0. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

UniversalAppAdDescriptions

The list of descriptions of the Universal App ad. List elements are returned in JSON list format.

UniversalAppAdHeadlines

The list of headers of the Universal App ad. List elements are returned in JSON list format.

UniversalAppAdHtml5MediaBundles

The HTML5 media bundles attached to the ad. List elements are returned in JSON list format.

UniversalAppAdImages

The marketing images attached to the ad. List elements are returned in JSON list format.

UniversalAppAdMandatoryAdText

The ad text that must be displayed when the ad is served.

UniversalAppAdYouTubeVideos

The YouTube videos attached to the ad. List elements are returned in JSON list format.

ValuePerAllConversion

The value, on average, of all conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

ValuePerConversion

The total value of your conversions divided by the total number of conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

ValuePerCurrentModelAttributedConversion

Shows how your historic ValuePerConversion data would look under the attribution model you've currently selected. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

VideoQuartile100Rate

Percentage of impressions where the viewer watched all of your video. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

VideoQuartile25Rate

Percentage of impressions where the viewer watched 25% of your video. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

VideoQuartile50Rate

Percentage of impressions where the viewer watched 50% of your video. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

VideoQuartile75Rate

Percentage of impressions where the viewer watched 75% of your video. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

VideoViewRate

The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

VideoViews

The number of times your video ads were viewed.

ViewThroughConversions

The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad. This field is formatted using US locale, i.e., using comma "," for thousands and dot "." for decimals.

Week

The date for the Monday of the week, formatted as yyyy-MM-dd.

Year

The year, formatted as yyyy.