KeywordsPerformance
The Keywords Performance report includes all statistics aggregated at the keyword level, one row per keyword.
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 KeywordsPerformance report.
AccountDescriptiveName
String
Attribute
Account
Account for the KeywordsPerformance report.
AccountTimeZone
String
Attribute
Time Zone
Time Zone for the KeywordsPerformance report.
AdGroupId
Long
Attribute
Ad Group ID
Ad Group ID for the KeywordsPerformance report.
AdGroupName
String
Attribute
Ad Group
Ad Group for the KeywordsPerformance report.
AdGroupStatus
String
Attribute
Ad Group State
Ad Group State for the KeywordsPerformance report.
The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
ApprovalStatus
String
Attribute
Approval Status
Approval Status for the KeywordsPerformance report.
The allowed values are APPROVED, PENDING_REVIEW, UNDER_REVIEW, DISAPPROVED.
BaseAdGroupId
Long
Attribute
Base Ad Group ID
Base Ad Group ID for the KeywordsPerformance report.
BaseCampaignId
Long
Attribute
Base Campaign ID
Base Campaign ID for the KeywordsPerformance report.
BiddingStrategyId
Long
Attribute
Bid Strategy ID
Bid Strategy ID for the KeywordsPerformance report.
BiddingStrategyName
String
Attribute
Bid Strategy Name
Bid Strategy Name for the KeywordsPerformance report.
BiddingStrategySource
String
Attribute
Bidding Strategy Source
Bidding Strategy Source for the KeywordsPerformance report.
The allowed values are CAMPAIGN, ADGROUP, CRITERION.
BiddingStrategyType
String
Attribute
Bid Strategy Type
Bid Strategy Type for the KeywordsPerformance report.
The allowed values are MANUAL_CPC, MANUAL_CPV, MANUAL_CPM, PAGE_ONE_PROMOTED, TARGET_SPEND, TARGET_CPA, TARGET_ROAS, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, TARGET_OUTRANK_SHARE, NONE, UNKNOWN.
CampaignId
Long
Attribute
Campaign ID
Campaign ID for the KeywordsPerformance report.
CampaignName
String
Attribute
Campaign
Campaign for the KeywordsPerformance report.
CampaignStatus
String
Attribute
Campaign State
Campaign State for the KeywordsPerformance report.
The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
ConversionAdjustment
String
Attribute
Conversion Adjustment
Conversion Adjustment for the KeywordsPerformance report.
The allowed values are TRUE, FALSE.
CpcBid
Decimal
Attribute
Max CPC
Max CPC for the KeywordsPerformance report.
CpcBidSource
String
Attribute
Max CPC Source
Max CPC Source for the KeywordsPerformance report.
The allowed values are ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.
CpmBid
Decimal
Attribute
Max CPM
Max CPM for the KeywordsPerformance report.
CreativeQualityScore
String
Attribute
Ad Relevance
Ad Relevance for the KeywordsPerformance report.
The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.
Criteria
String
Attribute
Keyword
Keyword for the KeywordsPerformance report.
CriteriaDestinationUrl
String
Attribute
Destination URL
Destination URL for the KeywordsPerformance report.
CustomerDescriptiveName
String
Attribute
Client Name
Client Name for the KeywordsPerformance report.
EnhancedCpcEnabled
String
Attribute
Enhanced CPC Enabled
Enhanced CPC Enabled for the KeywordsPerformance report.
The allowed values are TRUE, FALSE.
EstimatedAddClicksAtFirstPositionCpc
Long
Attribute
Est Add Clicks Per wk (first Position Bid)
Est Add Clicks Per wk (first Position Bid) for the KeywordsPerformance report.
EstimatedAddCostAtFirstPositionCpc
Decimal
Attribute
Est Add Cost Per wk (first Position Bid)
Est Add Cost Per wk (first Position Bid) for the KeywordsPerformance report.
ExternalCustomerId
Long
Attribute
Customer ID
Customer ID for the KeywordsPerformance report.
FinalAppUrls
String
Attribute
App Final URL
App Final URL for the KeywordsPerformance report.
FinalMobileUrls
String
Attribute
Mobile Final URL
Mobile Final URL for the KeywordsPerformance report.
FinalUrls
String
Attribute
Final URL
Final URL for the KeywordsPerformance report.
FinalUrlSuffix
String
Attribute
Final URL Suffix
Final URL Suffix for the KeywordsPerformance report.
FirstPageCpc
String
Attribute
First Page CPC
First Page CPC for the KeywordsPerformance report.
FirstPositionCpc
String
Attribute
First Position CPC
First Position CPC for the KeywordsPerformance report.
HasQualityScore
String
Attribute
Has Quality Score
Has Quality Score for the KeywordsPerformance report.
The allowed values are TRUE, FALSE.
Id
Long
Attribute
Keyword ID
Keyword ID for the KeywordsPerformance report.
IsNegative
String
Attribute
Is Negative
Is Negative for the KeywordsPerformance report.
The allowed values are TRUE, FALSE.
KeywordMatchType
String
Attribute
Match Type
Match Type for the KeywordsPerformance report.
The allowed values are EXACT, PHRASE, BROAD.
LabelIds
String
Attribute
Label IDs
Label IDs for the KeywordsPerformance report.
Labels
String
Attribute
Labels
Labels for the KeywordsPerformance report.
PostClickQualityScore
String
Attribute
Landing Page Experience
Landing Page Experience for the KeywordsPerformance report.
The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.
QualityScore
Integer
Attribute
Quality Score
Quality Score for the KeywordsPerformance report.
SearchPredictedCtr
String
Attribute
Expected Clickthrough Rate
Expected Clickthrough Rate for the KeywordsPerformance report.
The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.
Status
String
Attribute
Keyword State
Keyword State for the KeywordsPerformance report.
The allowed values are ENABLED, REMOVED, PAUSED.
SystemServingStatus
String
Attribute
Criterion Serving Status
Criterion Serving Status for the KeywordsPerformance report.
The allowed values are ELIGIBLE, RARELY_SERVED.
TopOfPageCpc
String
Attribute
Top Of Page CPC
Top Of Page CPC for the KeywordsPerformance report.
TrackingUrlTemplate
String
Attribute
Tracking Template
Tracking Template for the KeywordsPerformance report.
UrlCustomParameters
String
Attribute
Custom Parameter
Custom Parameter for the KeywordsPerformance report.
VerticalId
Long
Attribute
Vertical ID
Vertical ID for the KeywordsPerformance report.
AdNetworkType1
String
Segment
Network
Network for the KeywordsPerformance 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 KeywordsPerformance report.
The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
ClickType
String
Segment
Click Type
Click Type for the KeywordsPerformance report.
The a