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.v15.common.SearchVolumeRange
Filterable False
Selectable True
Sortable True
Repeated False