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

Cross-device Conv

Cross-device Conv for the SearchQueryPerformance report.

Ctr

Double

Metric

CTR

CTR for the SearchQueryPerformance report.

EngagementRate

Double

Metric

Engagement Rate

Engagement Rate for the SearchQueryPerformance report.

Engagements

Long

Metric

Engagements

Engagements for the SearchQueryPerformance report.

Impressions

Long

Metric

Impressions

Impressions for the SearchQueryPerformance report.

InteractionRate

Double

Metric

Interaction Rate

Interaction Rate for the SearchQueryPerformance report.

Interactions

Long

Metric

Interactions

Interactions for the SearchQueryPerformance report.

InteractionTypes

String

Metric

Interaction Types

Interaction Types for the SearchQueryPerformance report.

TopImpressionPercentage

Double

Metric

Impr Top

The percent of add impressions that are shown anywhere above the organic search results.

ValuePerAllConversion

Double

Metric