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 description	Output only. The ID of the campaign.
Category	`ATTRIBUTE`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

campaign_search_term_insight.category_label
Field description	Output 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.
Category	`ATTRIBUTE`
Data Type	`STRING`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

campaign_search_term_insight.id
Field description	Output only. The ID of the insight.
Category	`ATTRIBUTE`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

campaign_search_term_insight.resource_name
Field description	Output 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}`
Category	`ATTRIBUTE`
Data Type	`RESOURCE_NAME`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

segments.ad_group
Field description	Resource name of the ad group.
Category	`SEGMENT`
Data Type	`RESOURCE_NAME`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

segments.asset_group
Field description	Resource name of the asset group.
Category	`SEGMENT`
Data Type	`RESOURCE_NAME`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

segments.date
Field description	Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
Category	`SEGMENT`
Data Type	`DATE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.search_subcategory
Field description	A search term subcategory. An empty string denotes the catch-all subcategory for search terms that didn't fit into another subcategory.
Category	`SEGMENT`
Data Type	`STRING`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

segments.search_term
Field description	A search term.
Category	`SEGMENT`
Data Type	`STRING`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

metrics.clicks
Field description	The number of clicks.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.conversions
Field description	The 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.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.conversions_from_interactions_rate
Field description	Conversions 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.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.conversions_value
Field description	The 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.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.ctr
Field description	The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.impressions
Field description	Count of how often your ad has appeared on a search results page or website on the Google Network.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.search_volume
Field description	Search volume range for a search term insight category.
Category	`METRIC`
Data Type	`MESSAGE`
Type URL	`google.ads.googleads.v17.common.SearchVolumeRange`
Filterable	False
Selectable	True
Sortable	True
Repeated	False

campaign_search_term_insight

Fields/Segments/Metrics

campaign_search_term_insight.campaign_id

campaign_search_term_insight.category_label

campaign_search_term_insight.id

campaign_search_term_insight.resource_name

segments.ad_group

segments.asset_group

segments.date

segments.search_subcategory

segments.search_term

metrics.clicks

metrics.conversions

metrics.conversions_from_interactions_rate

metrics.conversions_value

metrics.ctr

metrics.impressions

metrics.search_volume