AccountDescriptiveName
|
The descriptive name of the Customer account.
Type | String |
Display Name | Account |
XML Attribute | account |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
AdGroupId
|
The ID of the AdGroup.
Type | Long |
Display Name | Ad group ID |
XML Attribute | adGroupID |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
AdGroupName
|
The name of the AdGroup.
Type | String |
Display Name | Ad group |
XML Attribute | adGroup |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
AdGroupStatus
|
Status of the ad group.
Type | AdGroupStatus |
Display Name | Ad group state |
XML Attribute | adGroupState |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
UNKNOWN | unknown |
ENABLED | enabled |
PAUSED | paused |
REMOVED | removed |
|
AdNetworkType1
|
First level network type.
Type | AdNetworkType1 |
Display Name | Network |
XML Attribute | network |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
Predicate values / display values
UNKNOWN | unknown |
SEARCH | Search Network |
CONTENT | Display Network |
YOUTUBE_SEARCH | YouTube Search |
YOUTUBE_WATCH | YouTube Videos |
MIXED | Cross-network |
|
AdNetworkType2
|
Second level network type (includes search partners).
Type | AdNetworkType2 |
Display Name | Network (with search partners) |
XML Attribute | networkWithSearchPartners |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
Predicate values / display values
UNKNOWN | unknown |
SEARCH | Google search |
SEARCH_PARTNERS | Search partners |
CONTENT | Display Network |
YOUTUBE_SEARCH | YouTube Search |
YOUTUBE_WATCH | YouTube Videos |
MIXED | Cross-network |
|
AggregatorId
|
The multi-client account ID from Merchant Center.
Type | Long |
Display Name | MCA Id |
XML Attribute | mCAId |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
AllConversionRate
|
AllConversions divided by total clicks that can be conversion-tracked. This is how often a click on your ad resulted in a conversion. Percentage returned as "x.xx%".
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | All conv. rate |
XML Attribute | allConvRate |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
AllConversions
|
Best estimate of the total number of conversions that Google Ads drives. Includes website, cross-device, and phone call conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | All conv. |
XML Attribute | allConv |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
AllConversionValue
|
The total value of all of your conversions, including those that are estimated. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | All conv. value |
XML Attribute | allConvValue |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
AverageCpc
|
The total cost of all clicks divided by the total number of clicks received.
Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.
Type | Money |
Display Name | Avg. CPC |
XML Attribute | avgCPC |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ExternalConversionSource
|
Brand
|
The ProductBrand value of the product.
Type | String |
Display Name | Brand |
XML Attribute | brand |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CampaignId
|
The ID of the Campaign.
Type | Long |
Display Name | Campaign ID |
XML Attribute | campaignID |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CampaignName
|
The name of the Campaign.
Type | String |
Display Name | Campaign |
XML Attribute | campaign |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CampaignStatus
|
The status of the Campaign.
Type | CampaignStatus |
Display Name | Campaign state |
XML Attribute | campaignState |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
UNKNOWN | unknown |
ENABLED | enabled |
PAUSED | paused |
REMOVED | removed |
|
CategoryL1
|
The ProductBiddingCategory level 1 value of the product.
Type | String |
Display Name | Category (1st level) |
XML Attribute | category1stLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CategoryL2
|
The ProductBiddingCategory level 2 value of the product.
Type | String |
Display Name | Category (2nd level) |
XML Attribute | category2ndLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CategoryL3
|
The ProductBiddingCategory level 3 value of the product.
Type | String |
Display Name | Category (3rd level) |
XML Attribute | category3rdLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CategoryL4
|
The ProductBiddingCategory level 4 value of the product.
Type | String |
Display Name | Category (4th level) |
XML Attribute | category4thLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CategoryL5
|
The ProductBiddingCategory level 5 value of the product.
Type | String |
Display Name | Category (5th level) |
XML Attribute | category5thLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
Channel
|
Channel of the product.
Type | ShoppingProductChannel |
Display Name | Channel |
XML Attribute | channel |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
UNKNOWN | unknown |
ONLINE | Online |
LOCAL | Local Stores |
|
ChannelExclusivity
|
Channel exclusivity of the product.
Type | ShoppingProductChannelExclusivity |
Display Name | Channel Exclusivity |
XML Attribute | channelExclusivity |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
UNKNOWN | unknown |
SINGLE_CHANNEL | Single Channel |
MULTI_CHANNEL | Multi-Channel |
|
Clicks
|
The number of clicks.
Type | Long |
Display Name | Clicks |
XML Attribute | clicks |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ExternalConversionSource
|
ClickType
|
Indicates the click type for metric fields such as Impressions. Since ads that serve can be attributed to multiple click types, metric fields may be double-counted and thus totals may not be accurate, especially for Display network campaigns.
Type | ClickType |
Display Name | Click type |
XML Attribute | clickType |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
URL_CLICKS | Headline |
CALLS | Phone calls |
OTHER | Other |
PRODUCT_EXTENSION_CLICKS | Product plusbox offer |
SITELINKS | Sitelink |
PRODUCT_LISTING_AD_CLICKS | Shopping ad - Standard |
GET_DIRECTIONS | Driving direction |
OFFER_PRINTS | Print offer |
BREADCRUMBS | Breadcrumbs |
CALL_TRACKING | Manually dialed phone calls |
MOBILE_CALL_TRACKING | Mobile phone calls |
LOCATION_EXPANSION | Get location details |
STORE_LOCATOR | Show nearby locations |
IN_APP_LINK | Mobile app extension |
PRODUCT_LISTING_AD_LOCAL | Shopping ad - Local |
APP_DEEPLINK | App engagement ad deep link |
PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL | Shopping ad - MultiChannel Local |
PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE | Shopping ad - MultiChannel Online |
PRODUCT_LISTING_ADS_COUPON | Shopping ad - Coupon |
PRODUCT_LISTING_AD_TRANSACTABLE | Shopping ad - Sell on Google |
PRODUCT_AD_APP_DEEPLINK | Shopping ad - App Deeplink |
SHOWCASE_AD_CATEGORY_LINK | Shopping - Showcase - Category |
SHOWCASE_AD_LOCAL_STOREFRONT_LINK | Shopping - Showcase - Local storefront |
SHOWCASE_AD_ONLINE_PRODUCT_LINK | Shopping - Showcase - Online product |
SHOWCASE_AD_LOCAL_PRODUCT_LINK | Shopping - Showcase - Local product |
PRICE_EXTENSION | Price Extension |
VIDEO_WEBSITE_CLICKS | Website |
VIDEO_CALL_TO_ACTION_CLICKS | Call-to-Action overlay |
VIDEO_APP_STORE_CLICKS | App store |
VIDEO_CARD_ACTION_HEADLINE_CLICKS | Cards |
VIDEO_END_CAP_CLICKS | End cap |
CLICK_ON_ENGAGEMENT_AD | Click on engagement ad |
LOCATION_FORMAT_MAP | Map |
LOCATION_FORMAT_LANDING_PAGE | Go to landing page |
LOCATION_FORMAT_STORE_INFO | Go to store info |
LOCATION_FORMAT_DIRECTIONS | Directions |
LOCATION_FORMAT_CALL | Call |
LOCATION_FORMAT_TEXT | Text |
LOCATION_FORMAT_IMAGE | Image(s) |
BROADBAND_PLAN | Broadband Plan |
WIRELESS_PLAN | Wireless Plan |
VISUAL_SITELINKS | Visual Sitelinks |
PROMOTION_EXTENSION | Promotion Extension |
SWIPEABLE_GALLERY_AD_HEADLINE | Ad Headline |
SWIPEABLE_GALLERY_AD_SWIPES | Swipes |
SWIPEABLE_GALLERY_AD_SEE_MORE | See More |
SWIPEABLE_GALLERY_AD_SITELINK_ONE | Sitelink 1 |
SWIPEABLE_GALLERY_AD_SITELINK_TWO | Sitelink 2 |
SWIPEABLE_GALLERY_AD_SITELINK_THREE | Sitelink 3 |
SWIPEABLE_GALLERY_AD_SITELINK_FOUR | Sitelink 4 |
SWIPEABLE_GALLERY_AD_SITELINK_FIVE | Sitelink 5 |
HOTEL_PRICE | Hotel price |
HOTEL_BOOK_ON_GOOGLE_ROOM_SELECTION | Hotel Book-on-Google room selection |
MAPS_PIN_CLICK | Maps Pin Clicks |
UNKNOWN | unknown |
Not compatible with the following fields:
SearchAbsoluteTopImpressionShare
SearchClickShare
SearchImpressionShare
|
ConversionCategoryName
|
A category that describes the action the user will take to complete a conversion. Prevents zero-conversion rows from being returned. Values: "Download", "Lead", "Purchase/Sale", "Signup", "View of a key page", and "Other".
Type | String |
Display Name | Conversion category |
XML Attribute | conversionCategory |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Not compatible with the following fields:
AverageCpc
Clicks
Cost
Ctr
Impressions
SearchAbsoluteTopImpressionShare
SearchClickShare
SearchImpressionShare
|
ConversionRate
|
The number of conversions divided by total clicks that can be tracked to conversions. Percentage returned as "x.xx%".
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Conv. rate |
XML Attribute | convRate |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
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.
Type | Double |
Display Name | Conversions |
XML Attribute | conversions |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
ConversionTrackerId
|
ID of the conversion tracker.
Type | Long |
Display Name | Conversion Tracker Id |
XML Attribute | conversionTrackerId |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Not compatible with the following fields:
AverageCpc
Clicks
Cost
Ctr
Impressions
SearchAbsoluteTopImpressionShare
SearchClickShare
SearchImpressionShare
|
ConversionTypeName
|
The name of the conversion type. Prevents zero-conversion rows from being returned.
Type | String |
Display Name | Conversion name |
XML Attribute | conversionName |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Not compatible with the following fields:
AverageCpc
Clicks
Cost
Ctr
Impressions
SearchAbsoluteTopImpressionShare
SearchClickShare
SearchImpressionShare
|
ConversionValue
|
The sum of conversion values for all conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Total conv. value |
XML Attribute | totalConvValue |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
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.
Type | Money |
Display Name | Cost |
XML Attribute | cost |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ExternalConversionSource
|
CostPerAllConversion
|
Total cost divided by all conversions.
Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.
Type | Money |
Display Name | Cost / all conv. |
XML Attribute | costAllConv |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
CostPerConversion
|
The Cost attributable to conversion-tracked clicks divided by the number of conversions.
Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.
Type | Money |
Display Name | Cost / conv. |
XML Attribute | costConv |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
CountryCriteriaId
|
ID of the country Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
Type | Integer |
Display Name | Country/Territory |
XML Attribute | countryTerritory |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CrossDeviceConversions
|
Conversions from when a customer clicks on an ad on one device, then converts on a different device or browser. Cross-device conversions are already included in your AllConversions column. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Cross-device conv. |
XML Attribute | crossDeviceConv |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
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.
Type | Double |
Display Name | CTR |
XML Attribute | ctr |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ExternalConversionSource
|
CustomAttribute0
|
The ProductCustomAttribute level 0 value of the product.
Type | String |
Display Name | Custom label 0 |
XML Attribute | customLabel0 |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CustomAttribute1
|
The ProductCustomAttribute level 1 value of the product.
Type | String |
Display Name | Custom label 1 |
XML Attribute | customLabel1 |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CustomAttribute2
|
The ProductCustomAttribute level 2 value of the product.
Type | String |
Display Name | Custom label 2 |
XML Attribute | customLabel2 |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CustomAttribute3
|
The ProductCustomAttribute level 3 value of the product.
Type | String |
Display Name | Custom label 3 |
XML Attribute | customLabel3 |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
CustomAttribute4
|
The ProductCustomAttribute level 4 value of the product.
Type | String |
Display Name | Custom label 4 |
XML Attribute | customLabel4 |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
Date
|
The date formatted as yyyy-MM-dd.
Type | Date |
Display Name | Day |
XML Attribute | day |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
|
DayOfWeek
|
The name of the day of the week, e.g., "Monday".
Type | DayOfWeek |
Display Name | Day of week |
XML Attribute | dayOfWeek |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
Predicate values / display values
MONDAY | Monday |
TUESDAY | Tuesday |
WEDNESDAY | Wednesday |
THURSDAY | Thursday |
FRIDAY | Friday |
SATURDAY | Saturday |
SUNDAY | Sunday |
|
Device
|
Device type where the impression was shown.
Type | DeviceType |
Display Name | Device |
XML Attribute | device |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
Predicate values / display values
UNKNOWN | Other |
DESKTOP | Computers |
HIGH_END_MOBILE | Mobile devices with full browsers |
TABLET | Tablets with full browsers |
CONNECTED_TV | Devices streaming video content to TV screens |
|
ExternalConversionSource
|
The source of conversion such as website, import from calls.
Type | ExternalConversionSource |
Display Name | Conversion source |
XML Attribute | conversionSource |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
UNKNOWN | Other |
WEBPAGE | Website |
ANALYTICS | Analytics |
UPLOAD | Import from clicks |
AD_CALL_METRICS | Calls from ads |
OFFERS | Offers |
ENGAGEMENT | Engagement ads |
WEBSITE_CALL_METRICS | Calls from website |
STORE_VISITS | Store visits |
ANDROID_IN_APP | Android in-app action |
ANDROID_DOWNLOAD | Android app install (from Google Play) |
IOS_IN_APP | iOS in-app action |
IOS_FIRST_OPEN | iOS app install (first open) |
APP_UNSPECIFIED | Mobile app |
ANDROID_FIRST_OPEN | Android app install (first open) |
UPLOAD_CALLS | Import from calls |
FIREBASE | Firebase |
CLICK_TO_CALL | Phone number clicks |
SALESFORCE | Salesforce.com |
STORE_SALES_CRM | Store sales (data partner) |
STORE_SALES_PAYMENT_NETWORK | Store sales (automated) |
GOOGLE_PLAY | Google Play |
THIRD_PARTY_APP_ANALYTICS | Third-party app analytics |
GOOGLE_ATTRIBUTION | Google Attribution |
STORE_SALES_DIRECT | Store sales (direct upload) |
Not compatible with the following fields:
AverageCpc
Clicks
Cost
Ctr
Impressions
SearchAbsoluteTopImpressionShare
SearchClickShare
SearchImpressionShare
|
ExternalCustomerId
|
The Customer ID.
Type | Long |
Display Name | Customer ID |
XML Attribute | customerID |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
Impressions
|
Count of how often your ad has appeared on a search results page or website on the Google Network.
Type | Long |
Display Name | Impressions |
XML Attribute | impressions |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ExternalConversionSource
|
LanguageCriteriaId
|
Language of the product information.
Type | Integer |
Display Name | Language |
XML Attribute | language |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
MerchantId
|
ID of the Google Merchant Center account associated with the products being advertised.
Type | Long |
Display Name | MC Id |
XML Attribute | mCId |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
Month
|
The first day of the month, formatted as yyyy-MM-dd.
Type | String |
Display Name | Month |
XML Attribute | month |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
|
OfferId
|
Offer/item ID of the product.
Type | String |
Display Name | Item Id |
XML Attribute | itemId |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
ProductCondition
|
The ProductCanonicalCondition of the product.
Type | ShoppingProductCondition |
Display Name | Condition |
XML Attribute | condition |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
UNKNOWN | unknown |
NEW | New |
REFURBISHED | Refurbished |
USED | Used |
|
ProductTitle
|
The title of the product.
Type | String |
Display Name | Product Title |
XML Attribute | productTitle |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
Not compatible with the following fields:
AllConversionRate
AllConversionValue
AllConversions
ConversionRate
ConversionValue
Conversions
CostPerAllConversion
CostPerConversion
CrossDeviceConversions
ValuePerAllConversion
ValuePerConversion
|
ProductTypeL1
|
The ProductType level 1 value of the product.
Type | String |
Display Name | Product type (1st level) |
XML Attribute | productType1stLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
ProductTypeL2
|
The ProductType level 2 value of the product.
Type | String |
Display Name | Product type (2nd level) |
XML Attribute | productType2ndLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
ProductTypeL3
|
The ProductType level 3 value of the product.
Type | String |
Display Name | Product type (3rd level) |
XML Attribute | productType3rdLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
ProductTypeL4
|
The ProductType level 4 value of the product.
Type | String |
Display Name | Product type (4th level) |
XML Attribute | productType4thLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
ProductTypeL5
|
The ProductType level 5 value of the product.
Type | String |
Display Name | Product type (5th level) |
XML Attribute | productType5thLevel |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
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.
Type | String |
Display Name | Quarter |
XML Attribute | quarter |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
|
SearchAbsoluteTopImpressionShare
|
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.
Type | Double |
Display Name | Search abs. top IS |
XML Attribute | searchAbsTopIS |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ClickType
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ExternalConversionSource
|
SearchClickShare
|
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.
Type | Double |
Display Name | Click share |
XML Attribute | clickShare |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ClickType
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ExternalConversionSource
|
SearchImpressionShare
|
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.
Type | Double |
Display Name | Search Impr. share |
XML Attribute | searchImprShare |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ClickType
ConversionCategoryName
ConversionTrackerId
ConversionTypeName
ExternalConversionSource
StoreId
|
StoreId
|
Store ID of the product.
Type | String |
Display Name | Store Id |
XML Attribute | storeId |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
Not compatible with the following fields:
SearchImpressionShare
|
ValuePerAllConversion
|
The value, on average, of all conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Value / all conv. |
XML Attribute | valueAllConv |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
ValuePerConversion
|
The total value of your conversions divided by the total number of conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Value / conv. |
XML Attribute | valueConv |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | True |
Not compatible with the following fields:
ProductTitle
|
Week
|
The date for the Monday of the week, formatted as yyyy-MM-dd.
Type | String |
Display Name | Week |
XML Attribute | week |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
|
Year
|
The year, formatted as yyyy.
Type | Integer |
Display Name | Year |
XML Attribute | year |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | True |
|