Search Query Performance Report (v201609)

The Search Terms report includes all statistics aggregated at the search terms level, one row per combination of search terms. If other segment fields are used, you may get more than one row per combination of search terms. See segmentation for more information.

Note: We only show the first 128 char bytes of a query; so two rows with seemingly identical query strings just indicates that there were some differences past the 128th byte.

info_outline  Attribute

layers  Segment

show_chart  Metric

Ctr

Download this table in CSV format

SEARCH_QUERY_PERFORMANCE_REPORT

AccountCurrencyCode

The currency of the Customer account.

TypeString
Display NameCurrency
XML Attributecurrency
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AccountDescriptiveName

The descriptive name of the Customer account.

TypeString
Display NameAccount
XML Attributeaccount
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AccountTimeZoneId

Name of the timezone selected for the Customer account. For example: "(GMT-05:00) Eastern Time". This field does not reflect the current state of daylight saving time for the timezone.

TypeString
Display NameTime zone
XML AttributetimeZone
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdFormat

The underlying media format of the ad. Values can be one of the formats on the Template Ads page, or a MediaType enum.

TypeAdFormat
Display NameAd type
XML AttributeadType
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupId

The ID of the AdGroup.

TypeLong
Display NameAd group ID
XML AttributeadGroupID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupName

The name of the AdGroup.

TypeString
Display NameAd group
XML AttributeadGroup
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupStatus

Status of the ad group.

TypeAdGroupStatus
Display NameAd group state
XML AttributeadGroupState
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdNetworkType1

First level network type.

TypeAdNetworkType1
Display NameNetwork
XML Attributenetwork
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

AdNetworkType2

Second level network type (includes search partners).

TypeAdNetworkType2
Display NameNetwork (with search partners)
XML AttributenetworkWithSearchPartners
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

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.

TypeDouble
Display NameAll conv. rate
XML AttributeallConvRate
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AllConversions

Best estimate of the total number of conversions that AdWords drives. Includes website, cross-device, and phone call conversions. This field is formatted using US locale, i.e., using comma "," for thousands and dot "." for decimals. 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.

TypeDouble
Display NameAll conv.
XML AttributeallConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AllConversionValue

The total value of all of your conversions, including those that are estimated. 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.

TypeDouble
Display NameAll conv. value
XML AttributeallConvValue
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AverageCost

The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.

TypeMoney
Display NameAvg. Cost
XML AttributeavgCost
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AverageCpc

The total cost of all clicks divided by the total number of clicks received.

TypeMoney
Display NameAvg. CPC
XML AttributeavgCPC
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AverageCpe

The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements. 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.

TypeDouble
Display NameAvg. CPE
XML AttributeavgCPE
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AverageCpm

Average Cost-per-thousand impressions (CPM).

TypeMoney
Display NameAvg. CPM
XML AttributeavgCPM
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AverageCpv

The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views. 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.

TypeDouble
Display NameAvg. CPV
XML AttributeavgCPV
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AveragePosition

Your ad's position relative to those of other advertisers. 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.

TypeDouble
Display NameAvg. position
XML AttributeavgPosition
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CampaignId

The ID of the Campaign.

TypeLong
Display NameCampaign ID
XML AttributecampaignID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CampaignName

The name of the Campaign.

TypeString
Display NameCampaign
XML Attributecampaign
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CampaignStatus

The status of the Campaign.

TypeCampaignStatus
Display NameCampaign state
XML AttributecampaignState
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Clicks

The number of clicks.

TypeLong
Display NameClicks
XML Attributeclicks
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

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".

TypeString
Display NameConversion category
XML AttributeconversionCategory
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

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.

TypeDouble
Display NameConv. rate
XML AttributeconvRate
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

Conversions

The number of conversions for all conversion actions that you have opted into optimization. This field is formatted using US locale, i.e., using comma "," for thousands and dot "." for decimals. 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.

TypeDouble
Display NameConversions
XML Attributeconversions
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

ConversionTrackerId

ID of the conversion tracker.

TypeLong
Display NameConversion Tracker Id
XML AttributeconversionTrackerId
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ConversionTypeName

The name of the conversion type. Prevents zero-conversion rows from being returned.

TypeString
Display NameConversion name
XML AttributeconversionName
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ConversionValue

The sum of conversion values for all conversions. 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.

TypeDouble
Display NameTotal conv. value
XML AttributetotalConvValue
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

Cost

The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.

TypeMoney
Display NameCost
XML Attributecost
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CostPerAllConversion

Total cost divided by all conversions.

TypeMoney
Display NameCost / all conv.
XML AttributecostAllConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CostPerConversion

The Cost attributable to conversion-tracked clicks divided by the number of conversions

TypeMoney
Display NameCost / conv.
XML AttributecostConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CreativeId

ID of the ad.

TypeLong
Display NameAd ID
XML AttributeadID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CrossDeviceConversions

Conversions from when a customer clicks on an AdWords 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 using US locale, i.e., using comma "," for thousands and dot "." for decimals. 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.

TypeDouble
Display NameCross-device conv.
XML AttributecrossDeviceConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

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.

TypeDouble
Display NameCTR
XML Attributectr
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CustomerDescriptiveName

The descriptive name of the Customer.

TypeString
Display NameClient name
XML AttributeclientName
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Date

The date formatted as yyyy-MM-dd.

TypeDate
Display NameDay
XML Attributeday
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

DayOfWeek

The name of the day of the week, e.g., "Monday".

TypeDayOfWeek
Display NameDay of week
XML AttributedayOfWeek
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

DestinationUrl

Destination URL for the impression.

TypeString
Display NameDestination URL
XML AttributedestinationURL
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Device

Device type where the impression was shown.

TypeDeviceType
Display NameDevice
XML Attributedevice
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

EngagementRate

How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown. 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.

TypeDouble
Display NameEngagement rate
XML AttributeengagementRate
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

Engagements

The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.

TypeLong
Display NameEngagements
XML Attributeengagements
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

ExternalConversionSource

The source of conversion such as website, import from calls.

TypeExternalConversionSource
Display NameConversion source
XML AttributeconversionSource
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ExternalCustomerId

The Customer ID.

TypeLong
Display NameCustomer ID
XML AttributecustomerID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

FinalUrl

Final URL of the impressions.

TypeString
Display NameFinal URL
XML AttributefinalURL
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Impressions

Count of how often your ad has appeared on a search results page or website on the Google Network.

TypeLong
Display NameImpressions
XML Attributeimpressions
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

InteractionRate

How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown. 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.

TypeDouble
Display NameInteraction Rate
XML AttributeinteractionRate
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

Interactions

The number of interactions. An interaction is the main user action associated with an ad format--clicks for text and shopping ads, views for video ads, and so on.

TypeLong
Display NameInteractions
XML Attributeinteractions
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

InteractionTypes

The types of interactions that are reflected in the Interactions, InteractionRate, and AverageCost columns.

TypeEnumSet
Display NameInteraction Types
XML AttributeinteractionTypes
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

KeywordId

The ID of the Keyword that triggered the ad.

Typelong
Display NameKeyword ID
XML AttributekeywordID
BehaviorAttribute
FilterableFalse
Supports Zero ImpressionsFalse

KeywordTextMatchingQuery

Keyword that matched the query and triggered the ad.

TypeString
Display NameKeyword
XML Attributekeyword
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Month

The first day of the month, formatted as yyyy-MM-dd.

TypeString
Display NameMonth
XML Attributemonth
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

MonthOfYear

The name of the month of the year, e.g., "December".

TypeMonthOfYear
Display NameMonth of Year
XML AttributemonthOfYear
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

PrimaryCompanyName

Company name of the account.

TypeString
Display NameCompany name
XML AttributecompanyName
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

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.

TypeString
Display NameQuarter
XML Attributequarter
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

Query

If the string for this attribute is longer than 128 char bytes, the returned result will NOT be a single aggregated row.

TypeString
Display NameSearch term
XML AttributesearchTerm
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

QueryMatchTypeWithVariant

Match type of the keyword that triggered the ad, including variants. See https://support.google.com/adwords/answer/2472708 for an explanation of close variants.

TypeQueryMatchTypeWithVariant
Display NameMatch type
XML AttributematchType
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

TrackingUrlTemplate

Tracking template of the main object of this row.

TypeString
Display NameTracking template
XML AttributetrackingTemplate
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

ValuePerAllConversion

The value, on average, of all conversions. 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.

TypeDouble
Display NameValue / all conv.
XML AttributevalueAllConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

ValuePerConversion

The total value of your conversions divided by the total number of conversions. 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.

TypeDouble
Display NameValue / conv.
XML AttributevalueConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

VideoQuartile100Rate

Percentage of impressions where the viewer watched all of your video. 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.

TypeDouble
Display NameVideo played to 100%
XML AttributevideoPlayedTo100
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

VideoQuartile25Rate

Percentage of impressions where the viewer watched 25% of your video. 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.

TypeDouble
Display NameVideo played to 25%
XML AttributevideoPlayedTo25
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

VideoQuartile50Rate

Percentage of impressions where the viewer watched 50% of your video. 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.

TypeDouble
Display NameVideo played to 50%
XML AttributevideoPlayedTo50
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

VideoQuartile75Rate

Percentage of impressions where the viewer watched 75% of your video. 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.

TypeDouble
Display NameVideo played to 75%
XML AttributevideoPlayedTo75
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

VideoViewRate

The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads. 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.

TypeDouble
Display NameView rate
XML AttributeviewRate
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

VideoViews

The number of times your video ads were viewed.

TypeLong
Display NameViews
XML Attributeviews
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

ViewThroughConversions

The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad. This field is formatted using US locale, i.e., using comma "," for thousands and dot "." for decimals.

TypeLong
Display NameView-through conv.
XML AttributeviewThroughConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

Week

The date for the Monday of the week, formatted as yyyy-MM-dd.

TypeString
Display NameWeek
XML Attributeweek
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

Year

The year, formatted as yyyy.

TypeInteger
Display NameYear
XML Attributeyear
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

Send feedback about...

AdWords API
AdWords API
Need help? Visit our support page.