campaign_search_term_insight

A Campaign search term view. Historical data is available starting March 2023.

Attributed resources
campaign
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of campaign_search_term_insight. However, when you specify campaign_search_term_insight in the FROM clause, some metrics and segments cannot be used. Use the following filter to show only the fields that can be used when campaign_search_term_insight is specified in the FROM clause.

Is campaign_search_term_insight specified in the FROM clause of your query?

 Resource fields
campaign_id
category_label
id
resource_name
 Segments
ad_group
asset_group
date
search_subcategory
search_term
 Metrics
clicks
conversions
conversions_from_interactions_rate
conversions_value
ctr
impressions
search_volume

campaign_search_term_insight.campaign_id

Field descriptionOutput only. The ID of the campaign.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

campaign_search_term_insight.category_label

Field descriptionOutput only. The label for the search category. An empty string denotes the catch-all category for search terms that didn't fit into another category.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

campaign_search_term_insight.id

Field descriptionOutput only. The ID of the insight.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

campaign_search_term_insight.resource_name

Field descriptionOutput only. The resource name of the campaign level search term insight. Campaign level search term insight resource names have the form: customers/{customer_id}/campaignSearchTermInsights/{campaign_id}~{category_id}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.ad_group

Field descriptionResource name of the ad group.
CategorySEGMENT
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.asset_group

Field descriptionResource name of the asset group.
CategorySEGMENT
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.date

Field descriptionDate to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.search_subcategory

Field descriptionA search term subcategory. An empty string denotes the catch-all subcategory for search terms that didn't fit into another subcategory.
CategorySEGMENT
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.search_term

Field descriptionA search term.
CategorySEGMENT
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

metrics.clicks

Field descriptionThe number of clicks.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions

Field descriptionThe number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions_from_interactions_rate

Field descriptionConversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions_value

Field descriptionThe value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.ctr

Field descriptionThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.impressions

Field descriptionCount of how often your ad has appeared on a search results page or website on the Google Network.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.search_volume

Field descriptionSearch volume range for a search term insight category.
CategoryMETRIC
Data TypeMESSAGE
Type URLgoogle.ads.googleads.v17.common.SearchVolumeRange
FilterableFalse
SelectableTrue
SortableTrue
RepeatedFalse