search_term_view

A search term view with metrics aggregated by search term at the ad group level.

Attributed resources
ad_group
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.

Segmenting resources
ad_group_ad

Fields from the above resources, when selected along with this resource in your SELECT and WHERE clauses, will segment metrics.

Fields/Segments/Metrics

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

Is search_term_view specified in the FROM clause of your query?

Resource fields
ad_group
resource_name
search_term
status

Segments
ad_network_type
conversion_action
conversion_action_category
conversion_action_name
date
day_of_week
device
external_conversion_source
keyword.ad_group_criterion
keyword.info.match_type
keyword.info.text
month
month_of_year
quarter
search_term_match_type
week
year

Metrics
absolute_top_impression_percentage
all_conversions
all_conversions_from_interactions_rate
all_conversions_from_interactions_value_per_interaction
all_conversions_value
all_conversions_value_per_cost
average_cost
average_cpc
average_cpe
average_cpm
average_cpv
clicks
conversions
conversions_from_interactions_rate
conversions_from_interactions_value_per_interaction
conversions_value
conversions_value_per_cost
cost_micros
cost_per_all_conversions
cost_per_conversion
cross_device_conversions
ctr
engagement_rate
engagements
impressions
interaction_event_types
interaction_rate
interactions
top_impression_percentage
value_per_all_conversions
value_per_conversion
video_quartile_p100_rate
video_quartile_p25_rate
video_quartile_p50_rate
video_quartile_p75_rate
video_view_rate
video_views
view_through_conversions

search_term_view.ad_group
Field description	Output only. The ad group the search term served in.
Category	`ATTRIBUTE`
Data Type	`RESOURCE_NAME`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

search_term_view.resource_name
Field description	Output only. The resource name of the search term view. Search term view resource names have the form: `customers/{customer_id}/searchTermViews/{campaign_id}~{ad_group_id}~{URL-base64_search_term}`
Category	`ATTRIBUTE`
Data Type	`RESOURCE_NAME`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

search_term_view.search_term
Field description	Output only. The search term.
Category	`ATTRIBUTE`
Data Type	`STRING`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

search_term_view.status
Field description	Output only. Indicates whether the search term is currently one of your targeted or excluded keywords.
Category	`ATTRIBUTE`
Data Type	`ENUM ADDED ADDED_EXCLUDED EXCLUDED NONE UNKNOWN UNSPECIFIED`
Type URL	`google.ads.googleads.v18.enums.SearchTermTargetingStatusEnum.SearchTermTargetingStatus`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.ad_network_type
Field description	Ad network type.
Category	`SEGMENT`
Data Type	`ENUM CONTENT GOOGLE_OWNED_CHANNELS GOOGLE_TV MIXED SEARCH SEARCH_PARTNERS UNKNOWN UNSPECIFIED YOUTUBE`
Type URL	`google.ads.googleads.v18.enums.AdNetworkTypeEnum.AdNetworkType`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

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

segments.conversion_action_category
Field description	Conversion action category.
Category	`SEGMENT`
Data Type	`ENUM ADD_TO_CART BEGIN_CHECKOUT BOOK_APPOINTMENT CONTACT CONVERTED_LEAD DEFAULT DOWNLOAD ENGAGEMENT GET_DIRECTIONS IMPORTED_LEAD OUTBOUND_CLICK PAGE_VIEW PHONE_CALL_LEAD PURCHASE QUALIFIED_LEAD REQUEST_QUOTE SIGNUP STORE_SALE STORE_VISIT SUBMIT_LEAD_FORM SUBSCRIBE_PAID UNKNOWN UNSPECIFIED`
Type URL	`google.ads.googleads.v18.enums.ConversionActionCategoryEnum.ConversionActionCategory`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.conversion_action_name
Field description	Conversion action name.
Category	`SEGMENT`
Data Type	`STRING`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
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.day_of_week
Field description	Day of the week, for example, MONDAY.
Category	`SEGMENT`
Data Type	`ENUM FRIDAY MONDAY SATURDAY SUNDAY THURSDAY TUESDAY UNKNOWN UNSPECIFIED WEDNESDAY`
Type URL	`google.ads.googleads.v18.enums.DayOfWeekEnum.DayOfWeek`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.device
Field description	Device to which metrics apply.
Category	`SEGMENT`
Data Type	`ENUM CONNECTED_TV DESKTOP MOBILE OTHER TABLET UNKNOWN UNSPECIFIED`
Type URL	`google.ads.googleads.v18.enums.DeviceEnum.Device`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.external_conversion_source
Field description	External conversion source.
Category	`SEGMENT`
Data Type	`ENUM AD_CALL_METRICS ANALYTICS ANALYTICS_SEARCH_ADS_360 ANDROID_FIRST_OPEN ANDROID_IN_APP APP_UNSPECIFIED CLICK_TO_CALL DISPLAY_AND_VIDEO_360_FLOODLIGHT FIREBASE FIREBASE_SEARCH_ADS_360 FLOODLIGHT GOOGLE_ATTRIBUTION GOOGLE_HOSTED GOOGLE_PLAY IOS_FIRST_OPEN IOS_IN_APP SALESFORCE SEARCH_ADS_360 STORE_SALES STORE_SALES_CRM STORE_SALES_DIRECT_UPLOAD STORE_SALES_PAYMENT_NETWORK STORE_VISITS THIRD_PARTY_APP_ANALYTICS UNKNOWN UNSPECIFIED UPLOAD UPLOAD_CALLS WEBPAGE WEBSITE_CALL_METRICS`
Type URL	`google.ads.googleads.v18.enums.ExternalConversionSourceEnum.ExternalConversionSource`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.keyword.ad_group_criterion
Field description	The AdGroupCriterion resource name.
Category	`SEGMENT`
Data Type	`RESOURCE_NAME`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

segments.keyword.info.match_type
Field description	The match type of the keyword.
Category	`SEGMENT`
Data Type	`ENUM BROAD EXACT PHRASE UNKNOWN UNSPECIFIED`
Type URL	`google.ads.googleads.v18.enums.KeywordMatchTypeEnum.KeywordMatchType`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.keyword.info.text
Field description	The text of the keyword (at most 80 characters and 10 words).
Category	`SEGMENT`
Data Type	`STRING`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.month
Field description	Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
Category	`SEGMENT`
Data Type	`DATE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.month_of_year
Field description	Month of the year, for example, January.
Category	`SEGMENT`
Data Type	`ENUM APRIL AUGUST DECEMBER FEBRUARY JANUARY JULY JUNE MARCH MAY NOVEMBER OCTOBER SEPTEMBER UNKNOWN UNSPECIFIED`
Type URL	`google.ads.googleads.v18.enums.MonthOfYearEnum.MonthOfYear`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.quarter
Field description	Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
Category	`SEGMENT`
Data Type	`DATE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.search_term_match_type
Field description	Match type of the keyword that triggered the ad, including variants.
Category	`SEGMENT`
Data Type	`ENUM BROAD EXACT NEAR_EXACT NEAR_PHRASE PHRASE UNKNOWN UNSPECIFIED`
Type URL	`google.ads.googleads.v18.enums.SearchTermMatchTypeEnum.SearchTermMatchType`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.week
Field description	Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
Category	`SEGMENT`
Data Type	`DATE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.year
Field description	Year, formatted as yyyy.
Category	`SEGMENT`
Data Type	`INT32`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.absolute_top_impression_percentage
Field description	Search absolute top impression share is the percentage of your Search ad impressions that are shown in the most prominent Search position.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.all_conversions
Field description	The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.all_conversions_from_interactions_rate
Field description	All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.all_conversions_from_interactions_value_per_interaction
Field description	The value of all conversions from interactions divided by the total number of interactions.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.all_conversions_value
Field description	The value of all conversions.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.all_conversions_value_per_cost
Field description	The value of all conversions divided by the total cost of ad interactions (such as clicks for text ads or views for video ads).
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.average_cost
Field description	The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.average_cpc
Field description	The total cost of all clicks divided by the total number of clicks received.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.average_cpe
Field description	The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.average_cpm
Field description	Average cost-per-thousand impressions (CPM).
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.average_cpv
Field description	The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
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_from_interactions_value_per_interaction
Field description	The value of conversions from interactions divided by the number of ad interactions. 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.conversions_value_per_cost
Field description	The value of conversions divided by the cost of ad interactions. 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.cost_micros
Field description	The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.cost_per_all_conversions
Field description	The cost of ad interactions divided by all conversions.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.cost_per_conversion
Field description	The cost of ad interactions divided by 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.cross_device_conversions
Field description	Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_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.engagement_rate
Field description	How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.engagements
Field description	The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
Category	`METRIC`
Data Type	`INT64`
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.interaction_event_types
Field description	The types of payable and free interactions.
Category	`METRIC`
Data Type	`ENUM`
Type URL	`google.ads.googleads.v18.enums.InteractionEventTypeEnum.InteractionEventType`
Filterable	True
Selectable	True
Sortable	False
Repeated	True

metrics.interaction_rate
Field description	How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.interactions
Field description	The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.top_impression_percentage
Field description	The percent of your ad impressions that are shown adjacent to the top organic search results.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.value_per_all_conversions
Field description	The value of all conversions divided by the number of all conversions.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.value_per_conversion
Field description	The value of conversions divided by 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.video_quartile_p100_rate
Field description	Percentage of impressions where the viewer watched all of your video.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.video_quartile_p25_rate
Field description	Percentage of impressions where the viewer watched 25% of your video.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.video_quartile_p50_rate
Field description	Percentage of impressions where the viewer watched 50% of your video.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.video_quartile_p75_rate
Field description	Percentage of impressions where the viewer watched 75% of your video.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.video_view_rate
Field description	The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.video_views
Field description	The number of times your video ads were viewed.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.view_through_conversions
Field description	The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (for example, clicking on) another ad.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

search_term_view

Fields/Segments/Metrics

search_term_view.ad_group

search_term_view.resource_name

search_term_view.search_term

search_term_view.status

segments.ad_network_type

segments.conversion_action

segments.conversion_action_category

segments.conversion_action_name

segments.date

segments.day_of_week

segments.device

segments.external_conversion_source

segments.keyword.ad_group_criterion

segments.keyword.info.match_type

segments.keyword.info.text

segments.month

segments.month_of_year

segments.quarter

segments.search_term_match_type

segments.week

segments.year

metrics.absolute_top_impression_percentage

metrics.all_conversions

metrics.all_conversions_from_interactions_rate

metrics.all_conversions_from_interactions_value_per_interaction

metrics.all_conversions_value

metrics.all_conversions_value_per_cost

metrics.average_cost

metrics.average_cpc

metrics.average_cpe

metrics.average_cpm

metrics.average_cpv

metrics.clicks

metrics.conversions

metrics.conversions_from_interactions_rate

metrics.conversions_from_interactions_value_per_interaction

metrics.conversions_value

metrics.conversions_value_per_cost

metrics.cost_micros

metrics.cost_per_all_conversions

metrics.cost_per_conversion

metrics.cross_device_conversions

metrics.ctr

metrics.engagement_rate

metrics.engagements

metrics.impressions

metrics.interaction_event_types

metrics.interaction_rate

metrics.interactions

metrics.top_impression_percentage

metrics.value_per_all_conversions

metrics.value_per_conversion

metrics.video_quartile_p100_rate

metrics.video_quartile_p25_rate

metrics.video_quartile_p50_rate

metrics.video_quartile_p75_rate

metrics.video_view_rate

metrics.video_views

metrics.view_through_conversions