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.