SearchQueryPerformance

The Search Terms report includes all statistics aggregated at the search terms level, one row per combination of 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 SearchQueryPerformance report.
AccountDescriptiveName	String	Attribute	Account	Account for the SearchQueryPerformance report.
AccountTimeZone	String	Attribute	Time Zone	Time Zone for the SearchQueryPerformance report.
AdGroupId	Long	Attribute	Ad Group ID	Ad Group ID for the SearchQueryPerformance report.
AdGroupName	String	Attribute	Ad Group	Ad Group for the SearchQueryPerformance report.
AdGroupStatus	String	Attribute	Ad Group State	Ad Group State for the SearchQueryPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CampaignId	Long	Attribute	Campaign ID	Campaign ID for the SearchQueryPerformance report.
CampaignName	String	Attribute	Campaign	Campaign for the SearchQueryPerformance report.
CampaignStatus	String	Attribute	Campaign State	Campaign State for the SearchQueryPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CreativeId	Long	Attribute	Ad ID	Ad ID for the SearchQueryPerformance report.
CustomerDescriptiveName	String	Attribute	Client Name	Client Name for the SearchQueryPerformance report.
DestinationUrl	String	Attribute	Destination URL	Destination URL for the SearchQueryPerformance report.
ExternalCustomerId	Long	Attribute	Customer ID	Customer ID for the SearchQueryPerformance report.
FinalUrl	String	Attribute	Final URL	Final URL for the SearchQueryPerformance report.
KeywordId	Long	Attribute	Keyword ID	Keyword ID for the SearchQueryPerformance report.
KeywordTextMatchingQuery	String	Attribute	Keyword	Keyword for the SearchQueryPerformance report.
Query	String	Attribute	Search Term	Search Term for the SearchQueryPerformance report.
QueryTargetingStatus	String	Attribute	Added Per Excluded	Added Per Excluded for the SearchQueryPerformance report. The allowed values are ADDED, EXCLUDED, BOTH, NONE.
TrackingUrlTemplate	String	Attribute	Tracking Template	Tracking Template for the SearchQueryPerformance report.
AdFormat	String	Segment	Ad Type	Ad Type for the SearchQueryPerformance report. The allowed values are UNKNOWN, TEXT, IMAGE, DYNAMIC_IMAGE, FLASH, VIDEO, HTML, AUDIO, COMPOSITE, PRINT.
AdNetworkType1	String	Segment	Network	Network for the SearchQueryPerformance report. The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
AdNetworkType2	String	Segment	Network (with Search Partners)	Network (with Search Partners) for the SearchQueryPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
ConversionCategoryName	String	Segment	Conversion Category	Conversion Category for the SearchQueryPerformance report.
ConversionTrackerId	Long	Segment	Conversion Tracker Id	Conversion Tracker Id for the SearchQueryPerformance report.
ConversionTypeName	String	Segment	Conversion Name	Conversion Name for the SearchQueryPerformance report.
Date	Date	Segment	Day	Day for the SearchQueryPerformance report.
DayOfWeek	String	Segment	Day Of Week	Day Of Week for the SearchQueryPerformance report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
Device	String	Segment	Device	Device for the SearchQueryPerformance report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.
ExternalConversionSource	String	Segment	Conversion Source	Conversion Source for the SearchQueryPerformance 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 SearchQueryPerformance report.
MonthOfYear	String	Segment	Month Of Year	Month Of Year for the SearchQueryPerformance report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Quarter	String	Segment	Quarter	Quarter for the SearchQueryPerformance report.
QueryMatchTypeWithVariant	String	Segment	Match Type	Match Type for the SearchQueryPerformance report. The allowed values are AUTO, BROAD, EXACT, EXPANDED, PHRASE, NEAR_EXACT, NEAR_PHRASE.
Week	String	Segment	Week	Week for the SearchQueryPerformance report.
Year	Integer	Segment	Year	Year for the SearchQueryPerformance report.
AbsoluteTopImpressionPercentage	Double	Metric	Impr Abs Top	The percent of add impressions shown as the very first ad.
AllConversionRate	Double	Metric	All Conv Rate	All Conv Rate for the SearchQueryPerformance report.
AllConversions	Double	Metric	All Conv	All Conv for the SearchQueryPerformance report.
AllConversionValue	Double	Metric	All Conv Value	All Conv Value for the SearchQueryPerformance report.
AverageCost	Decimal	Metric	Avg Cost	Avg Cost for the SearchQueryPerformance report.
AverageCpc	Decimal	Metric	Avg CPC	Avg CPC for the SearchQueryPerformance report.
AverageCpe	Double	Metric	Avg CPE	Avg CPE for the SearchQueryPerformance report.
AverageCpm	Decimal	Metric	Avg CPM	Avg CPM for the SearchQueryPerformance report.
AverageCpv	Double	Metric	Avg CPV	Avg CPV for the SearchQueryPerformance report.
AveragePosition	Double	Metric	Avg Position	Avg Position for the SearchQueryPerformance report.
Clicks	Long	Metric	Clicks	Clicks for the SearchQueryPerformance report.
ConversionRate	Double	Metric	Conv Rate	Conv Rate for the SearchQueryPerformance report.
Conversions	Double	Metric	Conversions	Conversions for the SearchQueryPerformance report.
ConversionValue	Double	Metric	Total Conv Value	Total Conv Value for the SearchQueryPerformance report.
Cost	Decimal	Metric	Cost	Cost for the SearchQueryPerformance report.
CostPerAllConversion	Decimal	Metric	Cost Per All Conv	Cost Per All Conv for the SearchQueryPerformance report.
CostPerConversion	Decimal	Metric	Cost Per Conv	Cost Per Conv for the SearchQueryPerformance report.
CrossDeviceConversions	Double	Metric