KeywordView

A keyword view.

Table Specific Information

Select

Google Ads 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 Ads 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 Ads API.

Columns

Name	Type	Behavior	Description
KeywordViewResourceName	String	Attribute	ResourceName column for table KeywordView
CustomerId	Long	Attribute	ClientCustomerId column for table KeywordView
AbsoluteTopImpressionPercentage	Double	Metric	AbsoluteTopImpressionPercentage column for table Metrics
ActiveViewCpm	Double	Metric	ActiveViewCpm column for table Metrics
ActiveViewCtr	Double	Metric	ActiveViewCtr column for table Metrics
ActiveViewImpressions	Long	Metric	ActiveViewImpressions column for table Metrics
ActiveViewMeasurability	Double	Metric	ActiveViewMeasurability column for table Metrics
ActiveViewMeasurableCostMicros	Long	Metric	ActiveViewMeasurableCostMicros column for table Metrics
ActiveViewMeasurableImpressions	Long	Metric	ActiveViewMeasurableImpressions column for table Metrics
ActiveViewViewability	Double	Metric	ActiveViewViewability column for table Metrics
AllConversions	Double	Metric	AllConversions column for table Metrics
AllConversionsByConversionDate	Double	Metric	AllConversionsByConversionDate column for table Metrics
AllConversionsFromInteractionsRate	Double	Metric	AllConversionsFromInteractionsRate column for table Metrics
AllConversionsFromInteractionsValuePerInteraction	Double	Metric	AllConversionsFromInteractionsValuePerInteraction column for table Metrics
AllConversionsValue	Double	Metric	AllConversionsValue column for table Metrics
AllConversionsValueByConversionDate	Double	Metric	AllConversionsValueByConversionDate column for table Metrics
AllConversionsValuePerCost	Double	Metric	AllConversionsValuePerCost column for table Metrics
AverageCost	Double	Metric	AverageCost column for table Metrics
AverageCpc	Double	Metric	AverageCpc column for table Metrics
AverageCpe	Double	Metric	AverageCpe column for table Metrics
AverageCpm	Double	Metric	AverageCpm column for table Metrics
AverageCpv	Double	Metric	AverageCpv column for table Metrics
AveragePageViews	Double	Metric	AveragePageViews column for table Metrics
AverageTimeOnSite	Double	Metric	AverageTimeOnSite column for table Metrics
BounceRate	Double	Metric	BounceRate column for table Metrics
Clicks	Long	Metric	Clicks column for table Metrics
Conversions	Double	Metric	Conversions column for table Metrics
ConversionsByConversionDate	Double	Metric	ConversionsByConversionDate column for table Metrics
ConversionsFromInteractionsRate	Double	Metric	ConversionsFromInteractionsRate column for table Metrics
ConversionsValue	Double	Metric	ConversionsValue column for table Metrics
ConversionsValueByConversionDate	Double	Metric	ConversionsValueByConversionDate column for table Metrics
ConversionsValuePerCost	Double	Metric	ConversionsValuePerCost column for table Metrics
CostMicros	Long	Metric	CostMicros column for table Metrics
CostPerAllConversions	Double	Metric	CostPerAllConversions column for table Metrics
CostPerConversion	Double	Metric	CostPerConversion column for table Metrics
CostPerCurrentModelAttributedConversion	Double	Metric	CostPerCurrentModelAttributedConversion column for table Metrics
CrossDeviceConversions	Double	Metric	CrossDeviceConversions column for table Metrics
Ctr	Double	Metric	Ctr column for table Metrics
CurrentModelAttributedConversions	Double	Metric	CurrentModelAttributedConversions column for table Metrics
CurrentModelAttributedConversionsValue	Double	Metric	CurrentModelAttributedConversionsValue column for table Metrics
EngagementRate	Double	Metric	EngagementRate column for table Metrics
Engagements	Long	Metric	Engagements column for table Metrics
GmailForwards	Long	Metric	GmailForwards column for table Metrics
GmailSaves	Long	Metric	GmailSaves column for table Metrics
GmailSecondaryClicks	Long	Metric	GmailSecondaryClicks column for table Metrics
HistoricalCreativeQualityScore	String	Metric	HistoricalCreativeQualityScore column for table Metrics
HistoricalLandingPageQualityScore	String	Metric	HistoricalLandingPageQualityScore column for table Metrics
HistoricalQualityScore	Long	Metric	HistoricalQualityScore column for table Metrics
HistoricalSearchPredictedCtr	String	Metric	HistoricalSearchPredictedCtr column for table Metrics
Impressions	Long	Metric	Impressions column for table Metrics
InteractionEventTypes	String	Metric	InteractionEventTypes column for table Metrics
InteractionRate	Double	Metric	InteractionRate column for table Metrics
Interactions	Long	Metric	Interactions column for table Metrics
PercentNewVisitors	Double	Metric	PercentNewVisitors column for table Metrics
SearchAbsoluteTopImpressionShare	Double	Metric	SearchAbsoluteTopImpressionShare column for table Metrics
SearchBudgetLostAbsoluteTopImpressionShare	Double	Metric	SearchBudgetLostAbsoluteTopImpressionShare column for table Metrics
SearchBudgetLostTopImpressionShare	Double	Metric	SearchBudgetLostTopImpressionShare column for table Metrics
SearchClickShare	Double	Metric	SearchClickShare column for table Metrics
SearchExactMatchImpressionShare	Double	Metric	SearchExactMatchImpressionShare column for table Metrics
SearchImpressionShare	Double	Metric	SearchImpressionShare column for table Metrics
SearchRankLostAbsoluteTopImpressionShare	Double	Metric	SearchRankLostAbsoluteTopImpressionShare column for table Metrics
SearchRankLostImpressionShare	Double	Metric	SearchRankLostImpressionShare column for table Metrics
SearchRankLostTopImpressionShare	Double	Metric	SearchRankLostTopImpressionShare column for table Metrics
SearchTopImpressionShare	Double	Metric	SearchTopImpressionShare column for table Metrics
TopImpressionPercentage	Double	Metric	TopImpressionPercentage column for table Metrics
ValuePerAllConversions	Double	Metric	ValuePerAllConversions column for table Metrics
ValuePerAllConversionsByConversionDate	Double	Metric	ValuePerAllConversionsByConversionDate column for table Metrics