customer_search_term_insight

Help me build a query

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

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of customer_search_term_insight. However, when you specify customer_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 customer_search_term_insight is specified in the FROM clause.

Is customer_search_term_insight specified in the FROM clause of your query?

No Yes, it is

Resource fields category_label id resource_name

Segments campaign date search_subcategory search_term

Metrics clicks conversions conversions_from_interactions_rate conversions_value ctr impressions search_volume

customer_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

customer_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

customer_search_term_insight.resource_name Field description Output only. The resource name of the customer level search term insight. Customer level search term insight resource names have the form: customers/{customer_id}/customerSearchTermInsights/{category_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

segments.campaign Field description Resource name of the campaign. 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