SearchTermView
A search term view with metrics aggregated by search term at the ad group level.
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
SearchTermViewAdGroup
String
Attribute
AdGroup column for table SearchTermView
SearchTermViewResourceName
String
Attribute
ResourceName column for table SearchTermView
SearchTermViewSearchTerm
String
Attribute
SearchTerm column for table SearchTermView
SearchTermViewStatus
String
Attribute
Status column for table SearchTermView
CustomerId
Long
Attribute
ClientCustomerId column for table SearchTermView
AbsoluteTopImpressionPercentage
Double
Metric
AbsoluteTopImpressionPercentage column for table Metrics
AllConversions
Double
Metric
AllConversions 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
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
Clicks
Long
Metric
Clicks column for table Metrics
Conversions
Double
Metric
Conversions column for table Metrics
ConversionsFromInteractionsRate
Double
Metric
ConversionsFromInteractionsRate column for table Metrics
ConversionsFromInteractionsValuePerInteraction
Double
Metric
ConversionsFromInteractionsValuePerInteraction column for table Metrics
ConversionsValue
Double
Metric
ConversionsValue 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
CrossDeviceConversions
Double
Metric
CrossDeviceConversions column for table Metrics
Ctr
Double
Metric
Ctr column for table Metrics
EngagementRate
Double
Metric
EngagementRate column for table Metrics
Engagements
Long
Metric
Engagements 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
TopImpressionPercentage
Double
Metric
TopImpressionPercentage column for table Metrics
ValuePerAllConversions
Double
Metric
ValuePerAllConversions column for table Metrics
ValuePerConversion
Double
Metric
ValuePerConversion column for table Metrics
VideoQuartileP100Rate
Double
Metric
VideoQuartileP100Rate column for table Metrics
VideoQuartileP25Rate
Double
Metric
VideoQuartileP25Rate column for table Metrics
VideoQuartileP50Rate
Double
Metric
VideoQuartileP50Rate column for table Metrics
VideoQuartileP75Rate
Double
Metric
VideoQuartileP75Rate column for table Metrics
VideoViewRate
Double
Metric
VideoViewRate column for table Metrics
VideoViews
Long
Metric
VideoViews column for table Metrics
ViewThroughConversions
Long
Metric
ViewThroughConversions column for table Metrics
AdNetworkType
String
Segment
AdNetworkType column for table Segments
ConversionAction
String
Segment
ConversionAction column for table Segments
ConversionActionCategory
String
Segment
ConversionActionCategory column for table Segments
ConversionActionName
String
Segment
ConversionActionName column for table Segments
Date
Date
Segment
Date column for table Segments
DayOfWeek
String
Segment
DayOfWeek column for table Segments
Device
String
Segment
Device column for table Segments
ExternalConversionSource
String
Segment
ExternalConversionSource column for table Segments
KeywordAdGroupCriterion
String
Segment
KeywordAdGroupCriterion column for table Segments
KeywordInfoMatchType
String
Segment
KeywordInfoMatchType column for table Segments
KeywordInfoText
String
Segment
KeywordInfoText column for table Segments
Month
Date
Segment
Month column for table Segments
MonthOfYear
String
Segment
MonthOfYear column for table Segments
Quarter
Date
Segment
Quarter column for table Segments
SearchTermMatchType
String
Segment
SearchTermMatchType column for table Segments
Week
Date
Segment
Week column for table Segments
Year
Int
Segment
Year column for table Segments
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name
Type
Description
ManagerId
Long
Id of the manager account on behalf of which you are requesting customer data.
Last updated