campaign_search_term_insight

Help me build a query

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?

No Yes, it is

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