KeywordlessQuery
The Keywordless Query report includes keywordless ads (dynamic search ads) statistics based on search terms.
Table Specific Information
Select
Google AdWords does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the AdWords console.
To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the AdWords API.
Columns
Name
Type
Behavior
DisplayName
Description
AccountCurrencyCode
String
Attribute
Currency
Currency for the KeywordlessQuery report.
AccountDescriptiveName
String
Attribute
Account
Account for the KeywordlessQuery report.
AccountTimeZone
String
Attribute
Time Zone
Time Zone for the KeywordlessQuery report.
AdGroupId
Long
Attribute
Ad Group ID
Ad Group ID for the KeywordlessQuery report.
AdGroupName
String
Attribute
Ad Group
Ad Group for the KeywordlessQuery report.
AdGroupStatus
String
Attribute
Ad Group State
Ad Group State for the KeywordlessQuery report.
The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CampaignId
Long
Attribute
Campaign ID
Campaign ID for the KeywordlessQuery report.
CampaignName
String
Attribute
Campaign
Campaign for the KeywordlessQuery report.
CampaignStatus
String
Attribute
Campaign State
Campaign State for the KeywordlessQuery report.
The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CategoryPaths
String
Attribute
Categories
Categories for the KeywordlessQuery report.
CriterionId
Long
Attribute
Keyword ID
Keyword ID for the KeywordlessQuery report.
CustomerDescriptiveName
String
Attribute
Client Name
Client Name for the KeywordlessQuery report.
Domain
String
Attribute
Domain
Domain for the KeywordlessQuery report.
ExternalCustomerId
Long
Attribute
Customer ID
Customer ID for the KeywordlessQuery report.
Line1
String
Attribute
Dynamically Generated Headline
Dynamically Generated Headline for the KeywordlessQuery report.
Query
String
Attribute
Search Term
Search Term for the KeywordlessQuery report.
QueryTargetingStatus
String
Attribute
Added Per Excluded
Added Per Excluded for the KeywordlessQuery report.
The allowed values are ADDED, EXCLUDED, BOTH, NONE.
Title
String
Attribute
Landing Page Title
Landing Page Title for the KeywordlessQuery report.
Url
String
Attribute
URL
URL for the KeywordlessQuery report.
ConversionCategoryName
String
Segment
Conversion Category
Conversion Category for the KeywordlessQuery report.
ConversionTrackerId
Long
Segment
Conversion Tracker Id
Conversion Tracker Id for the KeywordlessQuery report.
ConversionTypeName
String
Segment
Conversion Name
Conversion Name for the KeywordlessQuery report.
Date
Date
Segment
Day
Day for the KeywordlessQuery report.
DayOfWeek
String
Segment
Day Of Week
Day Of Week for the KeywordlessQuery report.
The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
ExternalConversionSource
String
Segment
Conversion Source
Conversion Source for the KeywordlessQuery report.
The allowed values are UNKNOWN, WEBPAGE, ANALYTICS, UPLOAD, AD_CALL_METRICS, OFFERS, ENGAGEMENT, WEBSITE_CALL_METRICS, STORE_VISITS, ANDROID_IN_APP, ANDROID_DOWNLOAD, IOS_IN_APP, IOS_FIRST_OPEN, APP_UNSPECIFIED, ANDROID_FIRST_OPEN, UPLOAD_CALLS, FIREBASE, CLICK_TO_CALL, SALESFORCE, STORE_SALES_CRM, STORE_SALES_PAYMENT_NETWORK, GOOGLE_PLAY, THIRD_PARTY_APP_ANALYTICS, GOOGLE_ATTRIBUTION, STORE_SALES_DIRECT.
Month
String
Segment
Month
Month for the KeywordlessQuery report.
MonthOfYear
String
Segment
Month Of Year
Month Of Year for the KeywordlessQuery report.
The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Quarter
String
Segment
Quarter
Quarter for the KeywordlessQuery report.
Week
String
Segment
Week
Week for the KeywordlessQuery report.
Year
Integer
Segment
Year
Year for the KeywordlessQuery report.
AllConversionRate
Double
Metric
All Conv Rate
All Conv Rate for the KeywordlessQuery report.
AllConversions
Double
Metric
All Conv
All Conv for the KeywordlessQuery report.
AllConversionValue
Double
Metric
All Conv Value
All Conv Value for the KeywordlessQuery report.
AverageCpc
Decimal
Metric
Avg CPC
Avg CPC for the KeywordlessQuery report.
AverageCpm
Decimal
Metric
Avg CPM
Avg CPM for the KeywordlessQuery report.
Clicks
Long
Metric
Clicks
Clicks for the KeywordlessQuery report.
ConversionRate
Double
Metric
Conv Rate
Conv Rate for the KeywordlessQuery report.
Conversions
Double
Metric
Conversions
Conversions for the KeywordlessQuery report.
ConversionValue
Double
Metric
Total Conv Value
Total Conv Value for the KeywordlessQuery report.
Cost
Decimal
Metric
Cost
Cost for the KeywordlessQuery report.
CostPerAllConversion
Decimal
Metric
Cost Per All Conv
Cost Per All Conv for the KeywordlessQuery report.
CostPerConversion
Decimal
Metric
Cost Per Conv
Cost Per Conv for the KeywordlessQuery report.
CrossDeviceConversions
Double
Metric
Cross-device Conv
Cross-device Conv for the KeywordlessQuery report.
Ctr
Double
Metric
CTR
CTR for the KeywordlessQuery report.
Impressions
Long
Metric
Impressions
Impressions for the KeywordlessQuery report.
ValuePerAllConversion
Double
Metric
Value Per All Conv
Value Per All Conv for the KeywordlessQuery report.
ValuePerConversion
Double
Metric
Value Per Conv
Value Per Conv for the KeywordlessQuery report.
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name
Type
Description
StartDate
String
Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.
EndDate
String
End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.
Last updated