Introduction

Datasources and destinations

Fields listing for Google Ads

Impr. (Abs. Top) %
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.
Field IDAbsoluteTopImpressionPercentage
TypePERCENT
Data Typemetric
Age
Age
Field IDAge
TypeTEXT
Data Typedimension
Keyword
Keyword
Field IDKeyword
TypeTEXT
Data Typedimension
Gender
Gender
Field IDGender
TypeTEXT
Data Typedimension
Campaigns labels
Associate campaign labels.
Field IDCampaignLabels
TypeTEXT
Data Typedimension
Ad group labels
Associate adgroup labels.
Field IDAdgroupLabels
TypeTEXT
Data Typedimension
Ad labels
Associate ad labels.
Field IDAdLabels
TypeTEXT
Data Typedimension
Account Currency
The currency of the Customer account.
Field IDAccountCurrencyCode
TypeTEXT
Data Typedimension
Account
The descriptive name of the Customer account.
Field IDAccountDescriptiveName
TypeTEXT
Data Typedimension
Time zone
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.
Field IDAccountTimeZone
TypeTEXT
Data Typedimension
Active View avg. CPM
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.
Field IDActiveViewCpm
TypeNUMBER
Data Typemetric
Active View viewable CTR
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.
Field IDActiveViewCtr
TypeNUMBER
Data Typemetric
Active View viewable impressions
How often your ad has become viewable on a Display Network site.
Field IDActiveViewImpressions
TypeNUMBER
Data Typemetric
Active View measurable impr. / impr.
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.
Field IDActiveViewMeasurability
TypeNUMBER
Data Typemetric
Active View measurable cost
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.
Field IDActiveViewMeasurableCost
TypeNUMBER
Data Typemetric
Active View measurable impr.
The number of times your ads are appearing on placements in positions where they can be seen.
Field IDActiveViewMeasurableImpressions
TypeNUMBER
Data Typemetric
Active View viewable impr. / measurable impr.
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.
Field IDActiveViewViewability
TypeNUMBER
Data Typemetric
Network
First level network type.
Field IDAdNetworkType1
TypeTEXT
Data Typedimension
Network (with search partners)
Second level network type (includes search partners).
Field IDAdNetworkType2
TypeTEXT
Data Typedimension
All conv. rate
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.
Field IDAllConversionRate
TypeNUMBER
Data Typemetric
All conv.
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.
Field IDAllConversions
TypeNUMBER
Data Typemetric
All conv. value
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.
Field IDAllConversionValue
TypeNUMBER
Data Typemetric
Avg. Cost
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.
Field IDAverageCost
TypeNUMBER
Data Typemetric
Avg. CPC
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.
Field IDAverageCpc
TypeNUMBER
Data Typemetric
Avg. CPE
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.
Field IDAverageCpe
TypeNUMBER
Data Typemetric
Avg. CPM
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.
Field IDAverageCpm
TypeNUMBER
Data Typemetric
Avg. CPV
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.
Field IDAverageCpv
TypeNUMBER
Data Typemetric
Avg. position
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.
Field IDAveragePosition
TypeNUMBER
Data Typemetric
Can manage clients
Indicates if the account is an MCC account (true) or a regular Google Ads account (false).
Field IDCanManageClients
TypeTEXT
Data Typedimension
Clicks
The number of clicks.
Field IDClicks
TypeNUMBER
Data Typemetric
Click type
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.
Field IDClickType
TypeTEXT
Data Typedimension
Content Lost IS (budget)
The estimated percent of times that your ad was eligible to show on the Display Network but didn't because your budget was too low. A percentage returned as "xx.xx%", or the special value "> 90%".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.
Field IDContentBudgetLostImpressionShare
TypePERCENT
Data Typemetric
Content Impr. share
The impressions you've received on the Display Network divided by the estimated number of impressions you were eligible to receive. A percentage returned as "xx.xx%", or the special value "< 10%".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.
Field IDContentImpressionShare
TypePERCENT
Data Typemetric
Content Lost IS (rank)
The estimated percentage of impressions on the Display Network that your ads didn't receive due to poor Ad Rank. A percentage returned as "xx.xx%", or the special value "> 90%".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.
Field IDContentRankLostImpressionShare
TypePERCENT
Data Typemetric
Conversion adjustment
Whether the conversion was adjusted or the conversion is original one.
Field IDConversionAdjustment
TypeTEXT
Data Typedimension
Days to conversion or adjustment
The number of days between the impression and the conversion or between the impression and adjustments to the conversion.
Field IDConversionAdjustmentLagBucket
TypeTEXT
Data Typedimension
Conversion category
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".
Field IDConversionCategoryName
TypeTEXT
Data Typedimension
Days to conversion
Days between click and conversion.
Field IDConversionLagBucket
TypeTEXT
Data Typedimension
Conv. rate
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.
Field IDConversionRate
TypeNUMBER
Data Typemetric
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.
Field IDConversions
TypeNUMBER
Data Typemetric
Conversion Tracker Id
ID of the conversion tracker.
Field IDConversionTrackerId
TypeNUMBER
Data Typedimension
Conversion name
The name of the conversion type. Prevents zero-conversion rows from being returned.
Field IDConversionTypeName
TypeTEXT
Data Typedimension
Total conv. value
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.
Field IDConversionValue
TypeNUMBER
Data Typemetric
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.
Field IDCost
TypeNUMBER
Data Typemetric
Cost / all conv.
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.
Field IDCostPerAllConversion
TypeNUMBER
Data Typemetric
Cost / conv.
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.
Field IDCostPerConversion
TypeNUMBER
Data Typemetric
Cross-device conv.
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.
Field IDCrossDeviceConversions
TypeNUMBER
Data Typemetric
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.
Field IDCtr
TypeNUMBER
Data Typemetric
Client name
The descriptive name of the Customer.
Field IDCustomerDescriptiveName
TypeTEXT
Data Typedimension
Day
The date formatted as yyyy-MM-dd.
Field IDDate
TypeYEAR_MONTH_DAY
Data Typedimension
Day of week
The name of the day of the week, e.g., "Monday".
Field IDDayOfWeek
TypeDAY_OF_WEEK
Data Typedimension
Device
Device type where the impression was shown.
Field IDDevice
TypeTEXT
Data Typedimension
Engagement rate
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.
Field IDEngagementRate
TypeNUMBER
Data Typemetric
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.
Field IDEngagements
TypeNUMBER
Data Typemetric
Conversion source
The source of conversion such as website, import from calls.
Field IDExternalConversionSource
TypeTEXT
Data Typedimension
Customer ID
The Customer ID.
Field IDExternalCustomerId
TypeNUMBER
Data Typedimension
Hour of day
The hour of day as a number between 0 and 23, inclusive.
Field IDHourOfDay
TypeHOUR
Data Typedimension
Impressions
Count of how often your ad has appeared on a search results page or website on the Google Network.
Field IDImpressions
TypeNUMBER
Data Typemetric
Interaction Rate
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.
Field IDInteractionRate
TypeNUMBER
Data Typemetric
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.
Field IDInteractions
TypeNUMBER
Data Typemetric
Interaction Types
The types of interactions that are reflected in the Interactions, InteractionRate, and AverageCost columns.
Field IDInteractionTypes
TypeTEXT
Data Typemetric
Invalid click rate
The percentage ("x.xx%") of clicks filtered out of your total number of clicks (filtered + non-filtered clicks) during the reporting period.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.
Field IDInvalidClickRate
TypeNUMBER
Data Typemetric
Invalid clicks
Number of clicks Google considers illegitimate and doesn't charge you for.
Field IDInvalidClicks
TypeNUMBER
Data Typemetric
Auto tagging enabled
Indicates if auto tagging is enabled on the account.
Field IDIsAutoTaggingEnabled
TypeTEXT
Data Typedimension
Test account
Indicates if the account is a test account.
Field IDIsTestAccount
TypeTEXT
Data Typedimension
Month
The first day of the month, formatted as yyyy-MM-dd.
Field IDMonth
TypeYEAR_MONTH
Data Typedimension
Month of Year
The name of the month of the year, e.g., "December".
Field IDMonthOfYear
TypeMONTH
Data Typedimension
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.
Field IDQuarter
TypeYEAR_QUARTER
Data Typedimension
Search Lost IS (budget)
The estimated percent of times that your ad was eligible to show on the Search Network but didn't because your budget was too low. A percentage returned as "xx.xx%", or the special value "> 90%".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.
Field IDSearchBudgetLostImpressionShare
TypePERCENT
Data Typemetric
Search Exact match IS
The impressions you've received divided by the estimated number of impressions you were eligible to receive on the Search Network for search terms that matched your keywords exactly (or were close variants of your keyword), regardless of your keyword match types. A percentage returned as "xx.xx%", or the special value "< 10%".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.
Field IDSearchExactMatchImpressionShare
TypePERCENT
Data Typemetric
Search Impr. share
The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. A percentage returned as "xx.xx%", or the special value "< 10%".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.
Field IDSearchImpressionShare
TypePERCENT
Data Typemetric
Search Lost IS (rank)
The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank. A percentage returned as "xx.xx%", or the special value "> 90%".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.
Field IDSearchRankLostImpressionShare
TypePERCENT
Data Typemetric
Top vs. Other
The position of the Ad.
Field IDSlot
TypeTEXT
Data Typedimension
Impr. (Top) %
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.
Field IDTopImpressionPercentage
TypeNUMBER
Data Typemetric
Value / all conv.
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.
Field IDValuePerAllConversion
TypeNUMBER
Data Typemetric
Value / conv.
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.
Field IDValuePerConversion
TypeNUMBER
Data Typemetric
View rate
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.
Field IDVideoViewRate
TypeNUMBER
Data Typemetric
Views
The number of times your video ads were viewed.
Field IDVideoViews
TypeNUMBER
Data Typemetric
View-through conv.
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.
Field IDViewThroughConversions
TypeNUMBER
Data Typemetric
Week
The date for the Monday of the week, formatted as yyyy-MM-dd.
Field IDWeek
TypeWEEK
Data Typedimension
Year
The year, formatted as yyyy.
Field IDYear
TypeYEAR
Data Typedimension
AdGroup Desktop bid adj.
Desktop bid modifier override at the ad group level.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.
Field IDAdGroupDesktopBidModifier
TypeNUMBER
Data Typedimension
Ad group ID
The ID of the AdGroup.
Field IDAdGroupId
TypeNUMBER
Data Typedimension
AdGroup Mobile bid adj.
Mobile bid modifier override at ad group level.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.
Field IDAdGroupMobileBidModifier
TypeNUMBER
Data Typedimension
Ad group
The name of the AdGroup.
Field IDAdGroupName
TypeTEXT
Data Typedimension
Ad group state
Status of the ad group.
Field IDAdGroupStatus
TypeTEXT
Data Typedimension
AdGroup Tablet bid adj.
Tablet bid modifier override at the ad group level.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.
Field IDAdGroupTabletBidModifier
TypeNUMBER
Data Typedimension
Ad group type
The type of ad group.
Field IDAdGroupType
TypeTEXT
Data Typedimension
Ad rotation mode
How often the ads in the ad group will be served relative to one another.
Field IDAdRotationMode
TypeTEXT
Data Typedimension
Pages / session
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.
Field IDAveragePageviews
TypeNUMBER
Data Typemetric
Avg. session duration (seconds)
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.
Field IDAverageTimeOnSite
TypeNUMBER
Data Typemetric
Base Ad group ID
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.
Field IDBaseAdGroupId
TypeNUMBER
Data Typedimension
Base Campaign ID
The ID of base campaign of trial campaigns. For regular campaigns, this is equal to CampaignId.
Field IDBaseCampaignId
TypeNUMBER
Data Typedimension
Bid Strategy ID
The ID of the BiddingStrategyConfiguration.
Field IDBiddingStrategyId
TypeNUMBER
Data Typedimension
Bid Strategy Name
The name of the BiddingStrategyConfiguration.
Field IDBiddingStrategyName
TypeTEXT
Data Typedimension
Bidding Strategy Source
Indicates where the bidding strategy is associated i.e. campaign, ad group or ad group criterion.
Field IDBiddingStrategySource
TypeTEXT
Data Typedimension
Bid Strategy Type
The type of the BiddingStrategyConfiguration.
Field IDBiddingStrategyType
TypeTEXT
Data Typedimension
Bounce rate
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.
Field IDBounceRate
TypeNUMBER
Data Typemetric
Campaign ID
The ID of the Campaign.
Field IDCampaignId
TypeNUMBER
Data Typedimension
Campaign Name
The name of the Campaign.
Field IDCampaignName
TypeTEXT
Data Typedimension
Campaign state
The status of the Campaign.
Field IDCampaignStatus
TypeTEXT
Data Typedimension
Click Assisted Conv.
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.
Field IDClickAssistedConversions
TypeNUMBER
Data Typemetric
Click Assisted Conv. / Last Click Conv.
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.
Field IDClickAssistedConversionsOverLastClickConversions
TypeNUMBER
Data Typemetric
Click Assisted Conv. Value
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.
Field IDClickAssistedConversionValue
TypeNUMBER
Data Typemetric
Content Network Bid Dimension
The type of criteria the ad group uses for absolute bids on the Display Network.
Field IDContentBidCriterionTypeGroup
TypeTEXT
Data Typedimension
Cost / conv. (current model)
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.
Field IDCostPerCurrentModelAttributedConversion
TypeNUMBER
Data Typemetric
Default max. CPC
Cost per click bid. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if AdWords is automatically setting the bid via the chosen bidding strategy, or c) "--" if no CPC bid applies to the row.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.
Field IDCpcBid
TypeNUMBER
Data Typedimension
Max. CPM
CPM (cost per thousand impressions) bid.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.
Field IDCpmBid
TypeNUMBER
Data Typedimension
Max. CPV
Cost per view bid.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.
Field IDCpvBid
TypeNUMBER
Data Typedimension
Conversions (current model)
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.
Field IDCurrentModelAttributedConversions
TypeNUMBER
Data Typemetric
Conv. value (current model)
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.
Field IDCurrentModelAttributedConversionValue
TypeNUMBER
Data Typemetric
Affective Target ROAS
The effective target ROAS, taking overrides into account.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.
Field IDEffectiveTargetRoas
TypeNUMBER
Data Typedimension
Target ROAS Source
The source of the effective target ROAS, taking overrides into account.
Field IDEffectiveTargetRoasSource
TypeTEXT
Data Typedimension
Enhanced CPC enabled
Indicates if enhanced CPC is enabled on the bidding strategy.
Field IDEnhancedCpcEnabled
TypeTEXT
Data Typedimension
Final URL suffix
URL template for appending params to final URL.
Field IDFinalUrlSuffix
TypeTEXT
Data Typedimension
Gmail forwards
The number of times your ad was forwarded to someone else as a message.
Field IDGmailForwards
TypeNUMBER
Data Typemetric
Gmail saves
The number of times someone has saved your Gmail ad to their inbox as a message.
Field IDGmailSaves
TypeNUMBER
Data Typemetric
Gmail clicks to website
The number of clicks to your landing page on the expanded state of Gmail ads.
Field IDGmailSecondaryClicks
TypeNUMBER
Data Typemetric
Impr. Assisted Conv.
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.
Field IDImpressionAssistedConversions
TypeNUMBER
Data Typemetric
Impr. Assisted Conv. / Last Click Conv.
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.
Field IDImpressionAssistedConversionsOverLastClickConversions
TypeNUMBER
Data Typemetric
Impr. Assisted Conv. Value
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.
Field IDImpressionAssistedConversionValue
TypeNUMBER
Data Typemetric
Label IDs
List of label IDs for the main object of this row.List elements are returned in JSON list format.
Field IDLabelIds
TypeTEXT
Data Typedimension
Labels
List of label names for the main object of this row.List elements are returned in JSON list format.
Field IDLabels
TypeTEXT
Data Typedimension
Phone impressions
Number of offline phone impressions.
Field IDNumOfflineImpressions
TypeNUMBER
Data Typemetric
Phone calls
Number of offline phone calls.
Field IDNumOfflineInteractions
TypeNUMBER
Data Typemetric
PTR
Number of phone calls received (NumOfflineInteractions) divided by the number of times your phone number is shown (NumOfflineImpressions).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.
Field IDOfflineInteractionRate
TypeNUMBER
Data Typemetric
% new sessions
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.
Field IDPercentNewVisitors
TypeNUMBER
Data Typemetric
Relative CTR
Your clickthrough rate (Ctr) divided by the average clickthrough rate of all advertisers on the websites that show your ads. Measures how your ads perform on Display Network sites compared to other ads on the same sites.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.
Field IDRelativeCtr
TypeNUMBER
Data Typemetric
Search abs. top IS
The impressions you've received in the absolute top location (the very first ad above the organic search results) divided by the estimated number of impressions you were eligible to receive in the top location. See this Help Center article for details. A percentage returned as "xx.xx%", or the special value "< 10%".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.
Field IDSearchAbsoluteTopImpressionShare
TypePERCENT
Data Typemetric
Search lost abs. top IS (budget)
The number estimating how often your ad wasn't the very first ad above the organic search results due to a low budget. See this Help Center article for details. A percentage returned as "xx.xx%", or the special value "< 10%".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.
Field IDSearchBudgetLostAbsoluteTopImpressionShare
TypePERCENT
Data Typemetric
Search lost top IS (budget)
The number estimating how often your ad didn't show anywhere above the organic search results due to a low budget. See this Help Center article for details. A percentage returned as "xx.xx%", or the special value "< 10%".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.
Field IDSearchBudgetLostTopImpressionShare
TypePERCENT
Data Typemetric
Search lost abs. top IS (rank)
The number estimating how often your ad wasn't the very first ad above the organic search results due to poor Ad Rank. 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.
Field IDSearchRankLostAbsoluteTopImpressionShare
TypePERCENT
Data Typemetric
Search lost top IS (rank)
The number estimating how often your ad didn't show anywhere above the organic search results due to poor Ad Rank. 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.
Field IDSearchRankLostTopImpressionShare
TypePERCENT
Data Typemetric
Search top IS
The impressions you've received in the top location (anywhere above the organic search results) compared to the estimated number of impressions you were eligible to receive in the top location. 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.
Field IDSearchTopImpressionShare
TypePERCENT
Data Typemetric
Target CPA
The current target CPA set on the Target CPA bidding strategy.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.
Field IDTargetCpa
TypeNUMBER
Data Typedimension
Target CPA source
The level at which the target CPA bid was set. This is applicable only at the ad group level.
Field IDTargetCpaBidSource
TypeTEXT
Data Typedimension
Tracking URL template
Tracking template of the main object of this row.
Field IDTrackingUrlTemplate
TypeTEXT
Data Typedimension
Custom parameter
Custom URL parameters of the main object of this row.CustomParameters elements are returned in JSON map format.
Field IDUrlCustomParameters
TypeTEXT
Data Typedimension
Value / conv. (current model)
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.
Field IDValuePerCurrentModelAttributedConversion
TypeNUMBER
Data Typemetric
Video played to 100%
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.
Field IDVideoQuartile100Rate
TypeNUMBER
Data Typemetric
Video played to 25%
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.
Field IDVideoQuartile25Rate
TypeNUMBER
Data Typemetric
Video played to 50%
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.
Field IDVideoQuartile50Rate
TypeNUMBER
Data Typemetric
Video played to 75%
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.
Field IDVideoQuartile75Rate
TypeNUMBER
Data Typemetric
Ad ID
The ID of the Ad. This field may contain IDs of ads that are not supported in the report request's API version.
Field IDAdId
TypeNUMBER
Data Typedimension
Feed ID
The Feed ID.
Field IDFeedId
TypeNUMBER
Data Typedimension
Feed Item Attribute Values
List of attribute values for the FeedItem.
Field IDFeedItemAttributes
TypeTEXT
Data Typedimension
Feed Item End date
End time at which the FeedItem is no longer effective and will stop serving.
Field IDFeedItemEndTime
TypeNUMBER
Data Typedimension
Item ID
The FeedItem ID.
Field IDFeedItemId
TypeNUMBER
Data Typedimension
Feed Item Start date
Start time when the FeedItem is effective and can begin serving.
Field IDFeedItemStartTime
TypeNUMBER
Data Typedimension
Item state
Status of the FeedItem.
Field IDFeedItemStatus
TypeTEXT
Data Typedimension
Target location
Location ID of the feed item's geoTargeting.
Field IDGeoTargetingCriterionId
TypeNUMBER
Data Typedimension
Keyword Targeting ID
The ID of the feed item's keyword targeting.
Field IDKeywordTargetingId
TypeNUMBER
Data Typedimension
Target keyword match type
Match type of the feed item's keywordTargeting.
Field IDKeywordTargetingMatchType
TypeTEXT
Data Typedimension
Target keyword text
Text of the feed item's keywordTargeting.
Field IDKeywordTargetingText
TypeTEXT
Data Typedimension
Target ad group ID
Ad group ID of the feed item's adGroupTargeting.
Field IDTargetingAdGroupId
TypeNUMBER
Data Typedimension
Target campaign ID
Campaign ID of the feed item's campaignTargeting.
Field IDTargetingCampaignId
TypeNUMBER
Data Typedimension
Accent color (responsive)
The accent color for the responsive display ad.
Field IDAccentColor
TypeTEXT
Data Typedimension
Ad strength
The strength information of the ad.
Field IDAdStrengthInfo
TypeTEXT
Data Typedimension
Ad type
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".
Field IDAdType
TypeTEXT
Data Typedimension
Allow flexible color (responsive)
Whether the responsive display ad colors must be strictly used.
Field IDAllowFlexibleColor
TypeTEXT
Data Typedimension
Auto-applied ad suggestion
Indicates if this ad is automatically created by Google Ads.
Field IDAutomated
TypeTEXT
Data Typedimension
Business name
The business name in a reponsive display ad.
Field IDBusinessName
TypeTEXT
Data Typedimension
Call-only ad phone number
The phone number of call-only ad.
Field IDCallOnlyPhoneNumber
TypeTEXT
Data Typedimension
Call to action text (responsive)
The call-to-action text for the responsive display ad.
Field IDCallToActionText
TypeTEXT
Data Typedimension
Approval status
Approval status that combines review state and status.
Field IDCombinedApprovalStatus
TypeTEXT
Data Typedimension
Ad Destination URL
Destination URL of the ad.
Field IDCreativeDestinationUrl
TypeTEXT
Data Typedimension
Ad Final App final URL
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.
Field IDCreativeFinalAppUrls
TypeTEXT
Data Typedimension
Ad Mobile final URL
List of final mobile URLs of the ad.List elements are returned in JSON list format.
Field IDCreativeFinalMobileUrls
TypeTEXT
Data Typedimension
Ad Final URL
List of final URLs of the ad.List elements are returned in JSON list format.
Field IDCreativeFinalUrls
TypeTEXT
Data Typedimension
Ad Final URL suffix
The URL template for appending params to final URL of an ad.
Field IDCreativeFinalUrlSuffix
TypeTEXT
Data Typedimension
Ad Tracking template
Tracking template of the ad.
Field IDCreativeTrackingUrlTemplate
TypeTEXT
Data Typedimension
Ad Custom parameter
List of custom parameters of the ad.CustomParameters elements are returned in JSON map format.
Field IDCreativeUrlCustomParameters
TypeTEXT
Data Typedimension
Criterion ID
The Criterion ID.
Field IDCriterionId
TypeNUMBER
Data Typedimension
Criterion Type
The type of criterion.
Field IDCriterionType
TypeTEXT
Data Typedimension
Description
The descriptive text of an expanded text ad or responsive display ad.
Field IDDescription
TypeTEXT
Data Typedimension
Description line 1
Line 1 description of the Ad.
Field IDDescription1
TypeTEXT
Data Typedimension
Description line 2
Line 2 description of the Ad.
Field IDDescription2
TypeTEXT
Data Typedimension
Device preference
Platform ID of the device preference. You can look up the corresponding name and other information in the Platforms reference.
Field IDDevicePreference
TypeNUMBER
Data Typedimension
Display URL
Display URL of the Ad.
Field IDDisplayUrl
TypeTEXT
Data Typedimension
Landscape logo ID (responsive)
The ID of the landscape logo image.
Field IDEnhancedDisplayCreativeLandscapeLogoImageMediaId
TypeNUMBER
Data Typedimension
Logo ID (responsive)
The ID of the logo image used in the ResponsiveDisplayAd.
Field IDEnhancedDisplayCreativeLogoImageMediaId
TypeNUMBER
Data Typedimension
Image ID (responsive)
"The ID of the marketing image used in the ResponsiveDisplayAd."
Field IDEnhancedDisplayCreativeMarketingImageMediaId
TypeNUMBER
Data Typedimension
Square image ID (responsive)
The ID of the square marketing image.
Field IDEnhancedDisplayCreativeMarketingImageSquareMediaId
TypeNUMBER
Data Typedimension
Expanded Dynamic Search Ad Description 2
The description 2 of the expanded dynamic search ad.
Field IDExpandedDynamicSearchCreativeDescription2
TypeTEXT
Data Typedimension
Expanded Text Ad Description 2
The description 2 of the expanded text ad.
Field IDExpandedTextAdDescription2
TypeTEXT
Data Typedimension
Expanded Text Ad Headline 3
The headline part 3 of the expanded text ad.
Field IDExpandedTextAdHeadlinePart3
TypeTEXT
Data Typedimension
Ad format preference (responsive)
The format setting of the responsive display ad.
Field IDFormatSetting
TypeTEXT
Data Typedimension
Gmail ad header image media id
The ID of the header image in the GmailAd.
Field IDGmailCreativeHeaderImageMediaId
TypeNUMBER
Data Typedimension
Gmail ad logo image media id
The ID of the logo image in the GmailAd teaser.
Field IDGmailCreativeLogoImageMediaId
TypeNUMBER
Data Typedimension
Gmail ad marketing image media id
The ID of the marketing image in the GmailAd.
Field IDGmailCreativeMarketingImageMediaId
TypeNUMBER
Data Typedimension
Gmail ad business name
The business name in the GmailAd teaser.
Field IDGmailTeaserBusinessName
TypeTEXT
Data Typedimension
Gmail ad description
The description in the GmailAd teaser.
Field IDGmailTeaserDescription
TypeTEXT
Data Typedimension
Gmail ad headline
The headline in the GmailAd teaser.
Field IDGmailTeaserHeadline
TypeTEXT
Data Typedimension
Ad
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.
Field IDHeadline
TypeTEXT
Data Typedimension
Headline 1
The first part of an expanded text ad headline.
Field IDHeadlinePart1
TypeTEXT
Data Typedimension
Headline 2
The second part of an expanded text ad headline.
Field IDHeadlinePart2
TypeTEXT
Data Typedimension
ID
ID of the main object of this row.
Field IDId
TypeNUMBER
Data Typedimension
Image Ad URL
Prefix this value with "https://tpc.googlesyndication.com/pageadimg/imgad?id=" to get the full URL.
Field IDImageAdUrl
TypeTEXT
Data Typedimension
Image Height
The height of the image ad. For other ad types, this will have no values.
Field IDImageCreativeImageHeight
TypeNUMBER
Data Typedimension
Image Width
The width of the image ad. For other ad types, this will have no values.
Field IDImageCreativeImageWidth
TypeNUMBER
Data Typedimension
Image Mime Type
Image mime type. Only populated for image ads.
Field IDImageCreativeMimeType
TypeNUMBER
Data Typedimension
Image ad name
Name for the image ad.
Field IDImageCreativeName
TypeTEXT
Data Typedimension
Is negative
Indicates if the criterion for this row is a negative (exclusion) criterion.
Field IDIsNegative
TypeTEXT
Data Typedimension
Long headline
The long format of the headline in a responsive display ad.
Field IDLongHeadline
TypeTEXT
Data Typedimension
Main color (responsive)
The main color for the responsive display ad.
Field IDMainColor
TypeTEXT
Data Typedimension
Gmail ad marketing image call to action text
The call-to-action text for the GmailAd.
Field IDMarketingImageCallToActionText
TypeTEXT
Data Typedimension
Gmail ad marketing image call to action text color
The call-to-action text color for the GmailAd.
Field IDMarketingImageCallToActionTextColor
TypeTEXT
Data Typedimension
Gmail ad marketing image description
The description of the marketing image in the GmailAd.
Field IDMarketingImageDescription
TypeTEXT
Data Typedimension
Gmail ad marketing image headline
The headline of the marketing image in the GmailAd.
Field IDMarketingImageHeadline
TypeTEXT
Data Typedimension
Accent color (multi asset responsive display)
The accentColor setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdAccentColor
TypeTEXT
Data Typedimension
Allow flexible color (multi asset responsive display)
The allowFlexibleColor setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdAllowFlexibleColor
TypeTEXT
Data Typedimension
Business name (multi asset responsive display)
The businessName setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdBusinessName
TypeTEXT
Data Typedimension
Call to action text (multi asset responsive display)
The callToActionText setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdCallToActionText
TypeTEXT
Data Typedimension
Descriptions (multi asset responsive display)
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.
Field IDMultiAssetResponsiveDisplayAdDescriptions
TypeTEXT
Data Typedimension
Price prefix (multi asset responsive display)
The dynamicSettingsPricePrefix setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdDynamicSettingsPricePrefix
TypeTEXT
Data Typedimension
Promotion text (multi asset responsive display)
The dynamicSettingsPromoText setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdDynamicSettingsPromoText
TypeTEXT
Data Typedimension
Ad format preference (multi asset responsive display)
The formatSetting setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdFormatSetting
TypeTEXT
Data Typedimension
Headlines (multi asset responsive display)
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.
Field IDMultiAssetResponsiveDisplayAdHeadlines
TypeTEXT
Data Typedimension
Landscape logos (multi asset responsive display)
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.
Field IDMultiAssetResponsiveDisplayAdLandscapeLogoImages
TypeTEXT
Data Typedimension
Logos (multi asset responsive display)
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.
Field IDMultiAssetResponsiveDisplayAdLogoImages
TypeTEXT
Data Typedimension
Long headline (multi asset responsive display)
The longHeadline setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdLongHeadline
TypeTEXT
Data Typedimension
Main color (multi asset responsive display)
The mainColor setting for a MultiAssetResponsiveDisplayAd.
Field IDMultiAssetResponsiveDisplayAdMainColor
TypeTEXT
Data Typedimension
Images (multi asset responsive display)
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.
Field IDMultiAssetResponsiveDisplayAdMarketingImages
TypeTEXT
Data Typedimension
Square images (multi asset responsive display)
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.
Field IDMultiAssetResponsiveDisplayAdSquareMarketingImages
TypeTEXT
Data Typedimension
Youtube videos (multi asset responsive display)
YouTube video ID of the YouTube assets of multi-asset responsive display ad.List elements are returned in JSON list format.
Field IDMultiAssetResponsiveDisplayAdYouTubeVideos
TypeTEXT
Data Typedimension
Path 1
The text that appears in the ad with the displayed URL for an expanded text ad.
Field IDPath1
TypeTEXT
Data Typedimension
Path 2
In addition to "Path1", more text that appears in the ad with the displayed URL for an expanded text ad.
Field IDPath2
TypeTEXT
Data Typedimension
Policy
Policy information for an ad.
Field IDPolicySummary
TypeTEXT
Data Typedimension
Price prefix (responsive)
The prefix shown before prices.
Field IDPricePrefix
TypeTEXT
Data Typedimension
Promotion text (responsive)
The promotion text for the responsive display ad.
Field IDPromoText
TypeTEXT
Data Typedimension
Responsive Search Ad descriptions
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.
Field IDResponsiveSearchAdDescriptions
TypeTEXT
Data Typedimension
Responsive Search Ad headlines
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.
Field IDResponsiveSearchAdHeadlines
TypeTEXT
Data Typedimension
Responsive Search Ad path 1
The text that appears in the ad with the displayed URL for a responsive search ad.
Field IDResponsiveSearchAdPath1
TypeTEXT
Data Typedimension
Responsive Search Ad path 2
In addition to "ResponsiveSearchAdPath1", more text that appears in the ad with the displayed URL for a responsive search ad.
Field IDResponsiveSearchAdPath2
TypeTEXT
Data Typedimension
Short headline
The short format of the headline in a responsive display ad.
Field IDShortHeadline
TypeTEXT
Data Typedimension
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.
Field IDStatus
TypeTEXT
Data Typedimension
System managed Entity Source
Indicates the source of a system-generated entity.
Field IDSystemManagedEntitySource
TypeTEXT
Data Typedimension
Universal App Ad descriptions
The list of descriptions of the Universal App ad.List elements are returned in JSON list format.
Field IDUniversalAppAdDescriptions
TypeTEXT
Data Typedimension
Universal App Ad headlines
The list of headers of the Universal App ad.List elements are returned in JSON list format.
Field IDUniversalAppAdHeadlines
TypeTEXT
Data Typedimension
Universal App Ad html5 media bundles
The HTML5 media bundles attached to the ad.List elements are returned in JSON list format.
Field IDUniversalAppAdHtml5MediaBundles
TypeTEXT
Data Typedimension
Universal App Ad images
The marketing images attached to the ad.List elements are returned in JSON list format.
Field IDUniversalAppAdImages
TypeTEXT
Data Typedimension
Universal App Ad mandatory ad text
The ad text that must be displayed when the ad is served.
Field IDUniversalAppAdMandatoryAdText
TypeTEXT
Data Typedimension
Universal App Ad youTube videos
The YouTube videos attached to the ad.List elements are returned in JSON list format.
Field IDUniversalAppAdYouTubeVideos
TypeTEXT
Data Typedimension
Bid adj.
The bid modifier. To filter by this field, use values greater than 0 and less than or equal to 1. 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.
Field IDBidModifier
TypeNUMBER
Data Typedimension
Max CPC source
Source of the CPC bid.
Field IDCpcBidSource
TypeTEXT
Data Typedimension
Max CPM Source
Source of the CPM bid.
Field IDCpmBidSource
TypeTEXT
Data Typedimension
Criteria
Descriptive string for the Criterion. For more information on the format of criteria types in reports, see the Criteria prefixes section of the reporting guide.
Field IDCriteria
TypeTEXT
Data Typedimension
Criterion Destination URL
Destination URL of the criterion that triggered ads.
Field IDCriteriaDestinationUrl
TypeTEXT
Data Typedimension
Final App final URL
List of final app URLs of the main object of this row. List entries will start with one of: a) "android-app:" (for Android apps) or b) "os-app:" (for iOS apps).AppUrlList elements are returned in JSON list format.
Field IDFinalAppUrls
TypeTEXT
Data Typedimension
Mobile final URL
List of final mobile URLs of the main object of this row.UrlList elements are returned in JSON list format.
Field IDFinalMobileUrls
TypeTEXT
Data Typedimension
Finals URL
List of final URLs of the main object of this row.UrlList elements are returned in JSON list format.
Field IDFinalUrls
TypeTEXT
Data Typedimension
Is restricting
A value of 'true' indicates that the criterion type is used for bidding and restricting targeting. A value of 'false' indicates that the criterion type is used only for bidding. This will have the opposite value from that of targetAll for the criteria's corresponding AdGroup.TargetingSettingDetail. For example, if the TargetingSettingDetail for criterionTypeGroup = PLACEMENT has targetAll = true, then the IsRestrict field will be false for Placement criteria.
Field IDIsRestrict
TypeTEXT
Data Typedimension
Level
The level at which the criterion association is defined.
Field IDCriterionAttachmentLevel
TypeTEXT
Data Typedimension
User list name
The name of the AdwordsUserList.
Field IDUserListName
TypeTEXT
Data Typedimension
Ad Format
The underlying media format of the ad. Values can be one of the formats on the Template Ads page, or a MediaType enum.
Field IDAdFormat
TypeTEXT
Data Typedimension
Criteria Parameters
Descriptive string for the Criterion. For more information on the format of criteria types in reports, see the Criteria prefixes section of the reporting guide.
Field IDCriteriaParameters
TypeTEXT
Data Typedimension
Criteria Display Name
Descriptive name for the criterion. For more information on the format of criteria types in reports, see the Criteria prefixes section of the reporting guide.
Field IDDisplayName
TypeTEXT
Data Typedimension
Domain
The domain of the URL (placement) where the impression was shown.
Field IDDomain
TypeTEXT
Data Typedimension
Targeting Mode
Indicates if Display Campaign Optimizer is enabled for the ad group. Corresponds to the ad group's ExplorerAutoOptimizerSetting.
Field IDIsAutoOptimized
TypeTEXT
Data Typedimension
Added
Indicates if the placement was added as a criterion.
Field IDIsBidOnPath
TypeBOOLEAN
Data Typedimension
Excluded
Indicates if the URL or placement is currently excluded.
Field IDIsPathExcluded
TypeBOOLEAN
Data Typedimension
Ad Groups
The count of AdGroup objects using the bidding strategy.
Field IDAdGroupCount
TypeNUMBER
Data Typemetric
Keywords
The count of AdGroupCriterion objects using the bidding strategy or label.
Field IDAdGroupCriteriaCount
TypeNUMBER
Data Typemetric
Campaigns
The count of Campaign objects using the bidding strategy.
Field IDCampaignCount
TypeNUMBER
Data Typemetric
Currency
ISO 4217 codes to specify the currency of monetary values.
Field IDCurrencyCode
TypeTEXT
Data Typedimension
Name
The name of the main object in this row. For example, in a Campaign Performance Report this will be the name of each row's Campaign. In an Ad Group Performance Report this will be the name of each row's AdGroup.
Field IDName
TypeTEXT
Data Typedimension
Non-Removed Ad Groups
The count of non-removed ad groups using the bidding strategy.
Field IDNonRemovedAdGroupCount
TypeNUMBER
Data Typemetric
Non-Removed Keywords
The count of non-removed ad group criteria using the bidding strategy.
Field IDNonRemovedAdGroupCriteriaCount
TypeNUMBER
Data Typemetric
Non-Removed Campaigns
The count of non-removed campaigns using the bidding strategy.
Field IDNonRemovedCampaignCount
TypeNUMBER
Data Typemetric
Bid limit (Target search page location)
Maximum bid limit for the PageOnePromotedBiddingScheme.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.
Field IDPageOnePromotedBidCeiling
TypeNUMBER
Data Typedimension
Bid automation (Target search page location)
Whether the PageOnePromoted strategy always follows bid estimate changes (false), or only increases (true).
Field IDPageOnePromotedBidChangesForRaisesOnly
TypeTEXT
Data Typedimension
Bid adjustment (Target search page location)
Bid multiplier defined on the PageOnePromotedBiddingScheme.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.
Field IDPageOnePromotedBidModifier
TypeNUMBER
Data Typedimension
Limited budgets (Target search page location)
Whether the PageOnePromoted strategy is allowed to raise bids if the campaign is "Limited by budget".
Field IDPageOnePromotedRaiseBidWhenBudgetConstrained
TypeTEXT
Data Typedimension
Low quality keywords (Target search page location)
Whether the PageOnePromoted strategy is allowed to raise bids on keywords with lower-range quality scores.
Field IDPageOnePromotedRaiseBidWhenLowQualityScore
TypeTEXT
Data Typedimension
Location (Target search page location)
Strategy goal of where impressions will show on search result pages.
Field IDPageOnePromotedStrategyGoal
TypeTEXT
Data Typedimension
Upper Bid limit (Target CPA)
The maximum CPC bid limit for the Target CPA bidding strategy.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.
Field IDTargetCpaMaxCpcBidCeiling
TypeNUMBER
Data Typedimension
Lower Bid limit (Target CPA)
The minimum CPC bid limit for the Target CPA bidding strategy.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.
Field IDTargetCpaMaxCpcBidFloor
TypeNUMBER
Data Typedimension
Target outranking share
Target fraction of auctions where the advertiser should outrank the competitor.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.
Field IDTargetOutrankShare
TypeNUMBER
Data Typedimension
Bid automation (Target Outranking Share)
Whether the TargetRoas strategy always follows bid estimate changes (false), or only increases (true).
Field IDTargetOutrankShareBidChangesForRaisesOnly
TypeTEXT
Data Typedimension
Competitor domain (Target Outranking Share)
The competitor's visible domain URL for the TargetRoas strategy.
Field IDTargetOutrankShareCompetitorDomain
TypeTEXT
Data Typedimension
Upper Max Cpc Bid limit (Target Outranking Share)
The TargetRoas strategy's ceiling on max CPC bids.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.
Field IDTargetOutrankShareMaxCpcBidCeiling
TypeNUMBER
Data Typedimension
Low quality keywords (Target Outranking Share)
Whether the TargetRoas strategy is allowed to raise bids on keywords with lower-range quality scores.
Field IDTargetOutrankShareRaiseBidWhenLowQualityScore
TypeTEXT
Data Typedimension
Target ROAS
The desired revenue (based on conversion data) per unit of spend for the TargetRoas BiddingStrategyConfiguration.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.
Field IDTargetRoas
TypeNUMBER
Data Typedimension
Upper Bid limit (Target ROAS)
Maximum bid limit that applies to all keywords managed by the TargetRoas BiddingStrategyConfiguration.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.
Field IDTargetRoasBidCeiling
TypeNUMBER
Data Typedimension
Lower Bid limit (Target ROAS)
Minimum bid limit that applies to all keywords managed by the TargetRoas BiddingStrategyConfiguration.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.
Field IDTargetRoasBidFloor
TypeNUMBER
Data Typedimension
Bid limit (Maximize clicks)
The largest max CPC bid that can be set by the TargetSpend BiddingStrategyConfiguration.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.
Field IDTargetSpendBidCeiling
TypeNUMBER
Data Typedimension
Target spend (Maximize clicks)
The spend target under which to maximize clicks. Specified by the TargetSpend BiddingStrategyConfiguration.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.
Field IDTargetSpendSpendTarget
TypeNUMBER
Data Typedimension
Type
The type of the main object in this row. For example, in a Bid Goal Performance Report this will be the type of the BiddingStrategyConfiguration. In a Shared Set Report this will be the type of the SharedSet.
Field IDType
TypeTEXT
Data Typedimension
Budget
The daily budget. On the Campaign Performance Report this column reflects the entire shared budget if the campaign draws from a shared budget.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.
Field IDAmount
TypeNUMBER
Data Typedimension
Associated Campaign ID
The ID of a Campaign associated with the Budget.
Field IDAssociatedCampaignId
TypeNUMBER
Data Typedimension
Associated Campaign Name
The name of a Campaign associated with the Budget.
Field IDAssociatedCampaignName
TypeTEXT
Data Typedimension
Associated Campaign state
The status of a Campaign associated with the Budget.
Field IDAssociatedCampaignStatus
TypeTEXT
Data Typedimension
Budget usage
The status of the association between the Budget and the associated Campaign.
Field IDBudgetCampaignAssociationStatus
TypeTEXT
Data Typedimension
Budget ID
The ID of the Budget.
Field IDBudgetId
TypeNUMBER
Data Typedimension
Budget Name
The name of the Budget.
Field IDBudgetName
TypeTEXT
Data Typedimension
# Campaigns
The number of campaigns actively using the budget.
Field IDBudgetReferenceCount
TypeNUMBER
Data Typedimension
Budget state
The status of the Budget.
Field IDBudgetStatus
TypeTEXT
Data Typedimension
Delivery method
Budget delivery method. Determines the rate at which the budget is spent.
Field IDDeliveryMethod
TypeTEXT
Data Typedimension
Has recommended Budget
Whether there is a recommended budget for this object.
Field IDHasRecommendedBudget
TypeTEXT
Data Typedimension
Explicitly shared
Indicates if the budget is a shared budget (true) or specific to the campaign (false).
Field IDIsBudgetExplicitlyShared
TypeTEXT
Data Typedimension
Budget period
Period over which to spend the budget.
Field IDPeriod
TypeTEXT
Data Typedimension
Recommended Budget amount
The recommended budget amount.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.
Field IDRecommendedBudgetAmount
TypeNUMBER
Data Typedimension
Estimated change in weekly clicks at recommended Budget
The estimated change in weekly clicks if the recommended budget is applied.
Field IDRecommendedBudgetEstimatedChangeInWeeklyClicks
TypeNUMBER
Data Typemetric
Estimated change in weekly cost at recommended Budget
The estimated change in weekly cost if the recommended budget is applied.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.
Field IDRecommendedBudgetEstimatedChangeInWeeklyCost
TypeNUMBER
Data Typemetric
Estimated change in weekly interactions at recommended Budget
The estimated change in weekly interactions if the recommended budget is applied.
Field IDRecommendedBudgetEstimatedChangeInWeeklyInteractions
TypeNUMBER
Data Typemetric
Estimated change in weekly views at recommended Budget
The estimated change in weekly views if the recommended budget is applied.
Field IDRecommendedBudgetEstimatedChangeInWeeklyViews
TypeNUMBER
Data Typemetric
Total Budget amount
The total budget amount, if you set a campaign's total budget in the Google Ads UI. Currently, campaign total budgets are only available for video campaigns with a specific start and end date. See this Help Center article to learn more about this option.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.
Field IDTotalAmount
TypeNUMBER
Data Typedimension
Duration (seconds)
The duration of the call, in seconds.
Field IDCallDuration
TypeNUMBER
Data Typedimension
End time
The end date and time of the call.
Field IDCallEndTime
TypeNUMBER
Data Typedimension
Caller country code
Country code of the caller.
Field IDCallerCountryCallingCode
TypeTEXT
Data Typedimension
Caller area code
Area code of the caller.
Field IDCallerNationalDesignatedCode
TypeTEXT
Data Typedimension
Call Start time
The start date and time of the call.
Field IDCallStartTime
TypeNUMBER
Data Typedimension
Call Status
The status of the call.
Field IDCallStatus
TypeTEXT
Data Typedimension
Call source
Location (e.g., ad or landing page) of the impression where the phone number was shown.
Field IDCallTrackingDisplayLocation
TypeTEXT
Data Typedimension
Call type
The type of the call.
Field IDCallType
TypeTEXT
Data Typedimension
Criteria Type
The type of the Criterion.
Field IDCriteriaType
TypeTEXT
Data Typedimension
Keyword Match type
The match type for the Keyword.
Field IDKeywordMatchType
TypeTEXT
Data Typedimension
Vertical ID
The ID of vertical.
Field IDVerticalId
TypeNUMBER
Data Typedimension
Advertising Sub Channel
Optional refinement of the campaign's AdvertisingChannelType.
Field IDAdvertisingChannelSubType
TypeTEXT
Data Typedimension
Advertising Channel
Primary serving target for ads in the campaign.
Field IDAdvertisingChannelType
TypeTEXT
Data Typedimension
Avg. impr. freq. per cookie
Average number of times a unique cookie was exposed to your ad over a given time period. Imported from Google Analytics. Deprecated. This field is only populated for dates prior to 2019-08-01.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.
Field IDAverageFrequency
TypeNUMBER
Data Typemetric
Campaign Desktop bid adj.
Desktop bid modifier override at the campaign level.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.
Field IDCampaignDesktopBidModifier
TypeNUMBER
Data Typedimension
Campaign Group ID
The ID of campaign group.
Field IDCampaignGroupId
TypeNUMBER
Data Typedimension
Campaign Mobile bid adj.
Mobile bid modifier of the campaign. To filter by this field, use values greater than 0 and less than or equal to 1. 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.
Field IDCampaignMobileBidModifier
TypeNUMBER
Data Typedimension
Campaign Tablet bid adj.
Tablet bid modifier override at the campaign level.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.
Field IDCampaignTabletBidModifier
TypeNUMBER
Data Typedimension
Campaign Trial Type
The type of campaign. This shows if the campaign is a trial campaign or not.
Field IDCampaignTrialType
TypeTEXT
Data Typedimension
Ad event type
The event type to which the conversion was attributed.
Field IDConversionAttributionEventType
TypeTEXT
Data Typedimension
Campaign End date
The end date of the campaign, formatted as yyyy-MM-dd.
Field IDEndDate
TypeYEAR_MONTH_DAY
Data Typedimension
Unique cookies
Number of unique cookies that were exposed to your ad over a given time period, or the special value "< 100" if the number of cookies is less than 100. Deprecated. This field is only populated for dates prior to 2019-08-01.
Field IDImpressionReach
TypeNUMBER
Data Typemetric
Target ROAS (Maximize Conversion Value)
The target ROAS that was set for maximizing revenue while averaging the target return on ad spend.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.
Field IDMaximizeConversionValueTargetRoas
TypeNUMBER
Data Typedimension
Click share
The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive. A percentage returned as "xx.xx%", or the special value "< 10%".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.
Field IDSearchClickShare
TypeNUMBER
Data Typemetric
Campaign serving status
Indicates if the Campaign is serving ads.
Field IDServingStatus
TypeTEXT
Data Typedimension
Campaign Start date
The start date of the campaign, formatted as yyyy-MM-dd.
Field IDStartDate
TypeYEAR_MONTH_DAY
Data Typedimension
Shared Set ID
The ID of the SharedSet.
Field IDSharedSetId
TypeNUMBER
Data Typedimension
Shared Set Name
The name of the SharedSet.
Field IDSharedSetName
TypeTEXT
Data Typedimension
Shared Set Type
The type of the SharedSet.
Field IDSharedSetType
TypeTEXT
Data Typedimension
Ad Variation Control Trial Arm ID
If the impression was part of an ad variation and in the control arm, this represents the ad variation control arm ID.
Field IDAdVariationControlTrialArmId
TypeNUMBER
Data Typedimension
Ad Variation Treatment Trial Arm ID
If the impression was part of an ad variation and in the treatment arm, this represents the ad variation treatment arm ID.
Field IDAdVariationTreatmentTrialArmId
TypeNUMBER
Data Typedimension
Ad Variation Trial ID
If the impression was part of an ad variation, this represents the ad variation trial ID.
Field IDAdVariationTrialId
TypeNUMBER
Data Typedimension
City (Location of interest)
ID of the city of the Location criterion matching the location of interest associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDAoiCityCriteriaId
TypeNUMBER
Data Typedimension
Country/Territory (Location of interest)
ID of the country of the Location criterion matching the location of interest associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDAoiCountryCriteriaId
TypeNUMBER
Data Typedimension
Metro area (Location of interest)
ID of the metro area of the Location criterion matching the location of interest associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDAoiMetroCriteriaId
TypeNUMBER
Data Typedimension
Most specific location target (Location of interest)
The most specific location target (Location of interest).
Field IDAoiMostSpecificTargetId
TypeNUMBER
Data Typedimension
Region (Location of interest)
ID of the region of the Location criterion matching the location of interest associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDAoiRegionCriteriaId
TypeNUMBER
Data Typedimension
Campaign location target
Location ID of the matching campaign criterion.
Field IDCampaignLocationTargetId
TypeNUMBER
Data Typedimension
Creative ID
ID of the ad.
Field IDCreativeId
TypeNUMBER
Data Typedimension
Criteria ID
The Criterion ID.
Field IDCriteriaId
TypeNUMBER
Data Typedimension
Google Click ID
The Google Click ID.
Field IDGclId
TypeTEXT
Data Typedimension
City (Physical location)
ID of the city of the Location criterion matching the physical location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDLopCityCriteriaId
TypeNUMBER
Data Typedimension
Country/Territory (Physical location)
ID of the country of the Location criterion matching the physical location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDLopCountryCriteriaId
TypeNUMBER
Data Typedimension
Metro area (Physical location)
ID of the metro area of the Location criterion matching the physical location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDLopMetroCriteriaId
TypeNUMBER
Data Typedimension
Most specific location target (Physical location)
The most specific location target (Physical location).
Field IDLopMostSpecificTargetId
TypeNUMBER
Data Typedimension
Region (Physical location)
ID of the region of the Location criterion matching the physical location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDLopRegionCriteriaId
TypeNUMBER
Data Typedimension
Page
Page number in search results where the ad was shown.
Field IDPage
TypeNUMBER
Data Typedimension
User List ID
The ID of the UserList (audience).
Field IDUserListId
TypeNUMBER
Data Typedimension
Free click rate
The number of clicks that converted divided by your total clicks that can be tracked to a conversion. 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.
Field IDCreativeConversionRate
TypeNUMBER
Data Typemetric
Free clicks
The number of clicks that converted within your chosen conversion window. This field is formatted using US locale, i.e., using comma "," for thousands and dot "." for decimals.
Field IDCreativeConversions
TypeNUMBER
Data Typemetric
Criteria Type Name
The descriptive name of the CriteriaType.
Field IDCriteriaTypeName
TypeTEXT
Data Typedimension
Approval Status
Approval status of the criterion.
Field IDApprovalStatus
TypeTEXT
Data Typedimension
Max CPV source
The source of the cost per view bid.
Field IDCpvBidSource
TypeTEXT
Data Typedimension
Ad Quality Score
The quality score of the ad.
Field IDCreativeQualityScore
TypeTEXT
Data Typedimension
Est. add. clicks/wk (first position bid)
Estimate of how many clicks per week you might get by changing your keyword bid to the value in FirstPositionCpc.
Field IDEstimatedAddClicksAtFirstPositionCpc
TypeNUMBER
Data Typedimension
Est. add. cost/wk (first position bid)
Estimate of how your cost per week might change when changing your keyword bid to the value in FirstPositionCpc.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.
Field IDEstimatedAddCostAtFirstPositionCpc
TypeNUMBER
Data Typedimension
First page CPC
Estimate of the CPC bid required in order to show your ad on the first page of search results.Usually a number in micros, but may be prefixed with "auto: " or may simply be the string "auto" if automatic bidding is used.
Field IDFirstPageCpc
TypeTEXT
Data Typedimension
First position CPC
Estimate of the amount you might need to pay for your ad to be displayed in the first position at the top of the first page of Google search results.Usually a number in micros, but may be prefixed with "auto: " or may simply be the string "auto" if automatic bidding is used.
Field IDFirstPositionCpc
TypeTEXT
Data Typedimension
Has Quality Score
Whether the QualityScore field of the criterion has value. Use this field in a report request predicate to include or exclude criteria with or without a value for the QualityScore field.
Field IDHasQualityScore
TypeTEXT
Data Typedimension
Dynamic ad target
The WebpageParameter criterion.
Field IDParameter
TypeTEXT
Data Typedimension
Landing page experience
The quality score of the landing page.
Field IDPostClickQualityScore
TypeTEXT
Data Typedimension
Ad Group Quality score
The quality score of the AdGroupCriterion. Ranges from 1 (lowest) to 10 (highest). If quality score information is missing, then "--" will be returned. You can filter using the "HasQualityScore" column to include or exclude criteria with or without a value for the QualityScore field. See the reporting concepts guide for more details.
Field IDQualityScore
TypeNUMBER
Data Typedimension
Expected clickthrough rate
Clickthrough rate compared to that of other advertisers.
Field IDSearchPredictedCtr
TypeTEXT
Data Typedimension
Criterion serving status
Serving status of the criterion.
Field IDSystemServingStatus
TypeTEXT
Data Typedimension
Top of page CPC
Estimate of the CPC bid required in order to show your ad on the top of the first page of search results.Usually a number in micros, but may be prefixed with "auto: " or may simply be the string "auto" if automatic bidding is used.
Field IDTopOfPageCpc
TypeTEXT
Data Typedimension
Effective Final URL
Effective final URL of the impressions.
Field IDEffectiveFinalUrl
TypeTEXT
Data Typedimension
Effective Tracking template
Effective tracking URL of the impressions.
Field IDEffectiveTrackingUrlTemplate
TypeTEXT
Data Typedimension
City
ID of the city Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDCityCriteriaId
TypeNUMBER
Data Typedimension
Country Code
ID of the country Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDCountryCriteriaId
TypeCOUNTRY_CODE
Data Typedimension
Is Targetable
Indicates whether the row's location (among all of the locations associated with an impression) was the targeting location for the impressions in that row.
Field IDIsTargetingLocation
TypeTEXT
Data Typedimension
Location type
The type of location. Location of interest (AREA_OF_INTEREST) indicates a location that the user showed interest in. Physical location (LOCATION_OF_PRESENCE) is where a user is located or is regularly located.
Field IDLocationType
TypeTEXT
Data Typedimension
Metro area
ID of the metro area Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDMetroCriteriaId
TypeNUMBER
Data Typedimension
Most specific location
ID of the most specific Location criterion associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDMostSpecificCriteriaId
TypeNUMBER
Data Typedimension
Region
ID of the region Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Field IDRegionCriteriaId
TypeNUMBER
Data Typedimension
Top level categories
Top level theme category of the pages in your website domain.
Field IDCategory0
TypeTEXT
Data Typedimension
First level sub-categories
First level theme category of the pages in your website domain.
Field IDCategory1
TypeTEXT
Data Typedimension
Second level sub-categories
Second level theme category of the pages in your website domain.
Field IDCategory2
TypeTEXT
Data Typedimension
Categories
The themes of the pages in your website domain derived from your website's structure.
Field IDCategoryPaths
TypeTEXT
Data Typedimension
Dynamically generated Headline
The dynamically generated headline of the Dynamic Search Ad.
Field IDLine1
TypeTEXT
Data Typedimension
Search term
If the string for this attribute is longer than 128 char bytes, the returned result will NOT be a single aggregated row.
Field IDQuery
TypeTEXT
Data Typedimension
Added/Excluded
Indicates whether the search term is currently one of your targeted or excluded keywords.
Field IDQueryTargetingStatus
TypeTEXT
Data Typedimension
Landing Page Title
Title of the landing page.
Field IDTitle
TypeTEXT
Data Typedimension
URL
The dynamically selected destination URL of the impression.
Field IDUrl
TypeTEXT
Data Typedimension
Ad relevance (hist.)
The quality of historical ad relevance.
Field IDHistoricalCreativeQualityScore
TypeTEXT
Data Typemetric
Landing page experience (hist.)
The quality of historical landing page experience.
Field IDHistoricalLandingPageQualityScore
TypeTEXT
Data Typemetric
Qual. score (hist.)
The historical quality score.
Field IDHistoricalQualityScore
TypeNUMBER
Data Typemetric
Expected clickthrough rate (hist.)
The historical expected clickthrough rate.
Field IDHistoricalSearchPredictedCtr
TypeTEXT
Data Typemetric
Ad group creatives count
The count of AdGroupAd objects using the label.
Field IDAdGroupCreativesCount
TypeNUMBER
Data Typemetric
Ad groups count
The count of ad groups using the bidding strategy or label.
Field IDAdGroupsCount
TypeNUMBER
Data Typemetric
Campaigns count
The count of Campaign objects using the label.
Field IDCampaignsCount
TypeNUMBER
Data Typemetric
Label ID
The ID of the Label.
Field IDLabelId
TypeNUMBER
Data Typedimension
Label name
The name of the Label.
Field IDLabelName
TypeTEXT
Data Typedimension
User lists count
The count of UserList objects using the label.
Field IDUserListsCount
TypeNUMBER
Data Typemetric
Expanded landing page
The final URL with ValueTrack parameters replaced with their final rendered values.
Field IDExpandedFinalUrlString
TypeTEXT
Data Typedimension
Mobile-friendly click rate
The percentage of mobile clicks that go to a mobile-friendly page.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.
Field IDPercentageMobileFriendlyClicks
TypeNUMBER
Data Typemetric
Valid AMP click rate
The percentage of ad clicks to AMP (accelerated mobile pages) landing pages that reach a valid AMP page.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.
Field IDPercentageValidAcceleratedMobilePagesClicks
TypeNUMBER
Data Typemetric
Mobile speed score
A measure of how quickly your page loads after clicks on your mobile ads. The score is a range from 1 to 10, 10 being fastest.
Field IDSpeedScore
TypeNUMBER
Data Typemetric
Landing page
The final URL with ValueTrack parameter templates left in place.
Field IDUnexpandedFinalUrlString
TypeTEXT
Data Typedimension
Combined Clicks
Clicks from ads or organic search results.
Field IDCombinedAdsOrganicClicks
TypeNUMBER
Data Typemetric
Combined Clicks/Query
CombinedAdsOrganicClicks divided by CombinedAdsOrganicQueries. 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.
Field IDCombinedAdsOrganicClicksPerQuery
TypeNUMBER
Data Typemetric
Combined Queries
Total number of searches that returned pages from your site in the organic search results or triggered one of your ads.
Field IDCombinedAdsOrganicQueries
TypeNUMBER
Data Typemetric
Keyword ID
The ID of the Keyword that triggered the ad.
Field IDKeywordId
TypeNUMBER
Data Typedimension
Keyword Match Query
Keyword that matched the query and triggered the ad.
Field IDKeywordTextMatchingQuery
TypeTEXT
Data Typedimension
Organic Average Position
Average top position of your organic listing (or multiple listings) for each query. 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.
Field IDOrganicAveragePosition
TypeNUMBER
Data Typemetric
Organic Clicks
Number of times someone clicked your site's listing in the unpaid results for a particular query.
Field IDOrganicClicks
TypeNUMBER
Data Typemetric
Organic Clicks/Query
Number of clicks you've received on your organic search listings divided by the total number of searches that returned pages from your site. 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.
Field IDOrganicClicksPerQuery
TypeNUMBER
Data Typemetric
Organic Listings
Number of organic search listing impressions.
Field IDOrganicImpressions
TypeNUMBER
Data Typemetric
Organic Listings/Query
Average number of times a page from your site was listed per query. 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.
Field IDOrganicImpressionsPerQuery
TypeNUMBER
Data Typemetric
Organic Queries
Total number of searches that returned organic search results for your site over the given period.
Field IDOrganicQueries
TypeNUMBER
Data Typemetric
Query Match type
Match type of the keyword that triggered the ad.
Field IDQueryMatchType
TypeTEXT
Data Typedimension
Query
Query that led to the impression.
Field IDSearchQuery
TypeTEXT
Data Typedimension
Search Result Type
The type of search result.
Field IDSerpType
TypeTEXT
Data Typedimension
Attribute Values
The FeedItem's attribute values.List elements are returned in JSON list format.
Field IDAttributeValues
TypeTEXT
Data Typedimension
Disapproval reasons
List of reasons why the FeedItem is not approved.List elements are returned in JSON list format.
Field IDDisapprovalShortNames
TypeTEXT
Data Typedimension
End Time
The end time in which the FeedItem is no longer effective and will stop serving.
Field IDEndTime
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Target location restriction
The type of location that can be used for targeting.
Field IDGeoTargetingRestriction
TypeTEXT
Data Typedimension
This extension vs. Other
Indicates if the extension for the placeholder feed item of this row was clicked (true) or merely displayed (false).
Field IDIsSelfAction
TypeTEXT
Data Typedimension
Placeholder Type
Placeholder type indicating the type of extension.
Field IDPlaceholderType
TypeNUMBER
Data Typedimension
Scheduling
Schedule specifying when the FeedItem may serve.FeedItemScheduling elements are returned in JSON list format.
Field IDScheduling
TypeTEXT
Data Typedimension
Start time
The start time in which the FeedItem is effective and can begin serving.
Field IDStartTime
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Validation Details
Details about the validation state for the FeedItem.List elements are returned in JSON list format.
Field IDValidationDetails
TypeTEXT
Data Typedimension
Extension Placeholder Creative Id
ID of the ad where the extension appeared.
Field IDExtensionPlaceholderCreativeId
TypeNUMBER
Data Typedimension
Extension Placeholder Type
Placeholder type indicating the type of extension.
Field IDExtensionPlaceholderType
TypeNUMBER
Data Typedimension
Benchmark Max. CPC
Indicates how other advertisers are bidding on similar products.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.
Field IDBenchmarkAverageMaxCpc
TypeNUMBER
Data Typemetric
Benchmark CTR
Indicates how other advertisers' Shopping ads for similar products are performing based on how often people who see their ad end up clicking on it.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.
Field IDBenchmarkCtr
TypeNUMBER
Data Typemetric
Parent Criterion ID
Criterion ID of the product partition's parent.
Field IDParentCriterionId
TypeNUMBER
Data Typedimension
Partition Type
The partition type of the ProductPartition criterion.
Field IDPartitionType
TypeTEXT
Data Typedimension
Product Group
Path to the ProductPartition, including all of its parent partitions.
Field IDProductGroup
TypeTEXT
Data Typedimension
Search Query Destination URL
Destination URL for the impression.
Field IDDestinationUrl
TypeTEXT
Data Typedimension
Search Query Final URL
Final URL of the impressions.
Field IDFinalUrl
TypeTEXT
Data Typedimension
Query Match type with variant
Match type of the keyword that triggered the ad, including variants. See https://support.google.com/google-ads/answer/2472708 for an explanation of close variants.
Field IDQueryMatchTypeWithVariant
TypeTEXT
Data Typedimension
Member Count
The number of entities in the shared set.
Field IDMemberCount
TypeNUMBER
Data Typemetric
Reference Count
The number of campaigns that actively use the shared set.
Field IDReferenceCount
TypeNUMBER
Data Typemetric
MCA Id
The multi-client account ID from Merchant Center.
Field IDAggregatorId
TypeNUMBER
Data Typedimension
Brand
The ProductBrand value of the product.
Field IDBrand
TypeTEXT
Data Typedimension
Category (1st level)
The ProductBiddingCategory level 1 value of the product.
Field IDCategoryL1
TypeTEXT
Data Typedimension
Category (2nd level)
The ProductBiddingCategory level 2 value of the product.
Field IDCategoryL2
TypeTEXT
Data Typedimension
Category (3rd level)
The ProductBiddingCategory level 3 value of the product.
Field IDCategoryL3
TypeTEXT
Data Typedimension
Category (4th level)
The ProductBiddingCategory level 4 value of the product.
Field IDCategoryL4
TypeTEXT
Data Typedimension
Category (5th level)
The ProductBiddingCategory level 5 value of the product.
Field IDCategoryL5
TypeTEXT
Data Typedimension
Channel
Channel of the product.
Field IDChannel
TypeTEXT
Data Typedimension
Channel Exclusivity
Channel exclusivity of the product.
Field IDChannelExclusivity
TypeTEXT
Data Typedimension
Custom label 0
The ProductCustomAttribute level 0 value of the product.
Field IDCustomAttribute0
TypeTEXT
Data Typedimension
Custom label 1
The ProductCustomAttribute level 1 value of the product.
Field IDCustomAttribute1
TypeTEXT
Data Typedimension
Custom label 2
The ProductCustomAttribute level 2 value of the product.
Field IDCustomAttribute2
TypeTEXT
Data Typedimension
Custom label 3
The ProductCustomAttribute level 3 value of the product.
Field IDCustomAttribute3
TypeTEXT
Data Typedimension
Custom label 4
The ProductCustomAttribute level 4 value of the product.
Field IDCustomAttribute4
TypeTEXT
Data Typedimension
Language
Language of the product information.
Field IDLanguageCriteriaId
TypeNUMBER
Data Typedimension
MC Id
ID of the Google Merchant Center account associated with the products being advertised.
Field IDMerchantId
TypeNUMBER
Data Typedimension
Item Id
Offer/item ID of the product.
Field IDOfferId
TypeTEXT
Data Typedimension
Condition
The ProductCanonicalCondition of the product.
Field IDProductCondition
TypeTEXT
Data Typedimension
Product Title
The title of the product.
Field IDProductTitle
TypeTEXT
Data Typedimension
Product type (1st level)
The ProductType level 1 value of the product.
Field IDProductTypeL1
TypeTEXT
Data Typedimension
Product type (2nd level)
The ProductType level 2 value of the product.
Field IDProductTypeL2
TypeTEXT
Data Typedimension
Product type (3rd level)
The ProductType level 3 value of the product.
Field IDProductTypeL3
TypeTEXT
Data Typedimension
Product type (4th level)
The ProductType level 4 value of the product.
Field IDProductTypeL4
TypeTEXT
Data Typedimension
Product type (5th level)
The ProductType level 5 value of the product.
Field IDProductTypeL5
TypeTEXT
Data Typedimension
Store Id
Store ID of the product.
Field IDStoreId
TypeTEXT
Data Typedimension
Keyword/Placement state
Status of the ad group criterion (keyword, placement, etc.).
Field IDAdGroupCriterionStatus
TypeTEXT
Data Typedimension
Distance from location extensions
Grouping of user distance from location extensions.
Field IDDistanceBucket
TypeTEXT
Data Typedimension
Ad state
Status of the ad.
Field IDCreativeStatus
TypeTEXT
Data Typedimension
Video Channel Id
The video channel ID.
Field IDVideoChannelId
TypeTEXT
Data Typedimension
Video Duration
The duration of the video in milliseconds.
Field IDVideoDuration
TypeNUMBER
Data Typedimension
Video Id
The video ID.
Field IDVideoId
TypeTEXT
Data Typedimension
Video Title
The video title.
Field IDVideoTitle
TypeTEXT
Data Typedimension
ROAS
Return on ad spend.
Field IDROAS
TypeNUMBER
Data Typemetric
Country
Country.
Field IDCountry
TypeCOUNTRY
Data Typedimension
Campaign Performance Name
Campaign Performance Name
Field IDCampaignPerformanceName
TypeTEXT
Data Typedimension
Campaign Performance Type Repartition
Campaign Performance Type Repartition
Field IDCampaignPerformanceRepartition
TypeTEXT
Data Typedimension
Youtube Video Id
Youtube Video Id
Field IDYoutubeVideoId
TypeTEXT
Data Typedimension
Youtube Video Title
Youtube Video Title
Field IDYoutubeVideoTitle
TypeTEXT
Data Typedimension
Asset Text
Asset Text
Field IDAssetText
TypeTEXT
Data Typedimension
Asset ID
Asset ID
Field IDAssetId
TypeTEXT
Data Typedimension
Asset Image
Asset Image
Field IDAssetImage
TypeURL
Data Typedimension
Asset Name
Asset Name
Field IDAssetName
TypeTEXT
Data Typedimension
Asset Source
Asset Source
Field IDAssetSource
TypeTEXT
Data Typedimension
Asset Group Asset Field Type
Asset Group Asset Field Type
Field IDAssetGroupAssetFieldType
TypeTEXT
Data Typedimension
Asset Group Name
Asset Group Name
Field IDAssetGroupName
TypeTEXT
Data Typedimension
Asset Group Id
Asset Group Id
Field IDAssetGroupId
TypeTEXT
Data Typedimension
Asset Group Ad Strength
Asset Group Ad Strength
Field IDAssetGroupAdStrength
TypeTEXT
Data Typedimension
Asset Group Status
Asset Group Status
Field IDAssetGroupStatus
TypeTEXT
Data Typedimension
Asset Group Performance Label
Asset Group Performance Label
Field IDAssetGroupAssetPerformanceLabel
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension