paid_organic_search_term_view

A paid organic search term view providing a view of search stats across ads and organic listings 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.

Fields/Segments/Metrics

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

Is paid_organic_search_term_view specified in the FROM clause of your query?

 Resource fields
resource_name
search_term
 Segments
date
day_of_week
device
keyword.ad_group_criterion
keyword.info.match_type
keyword.info.text
month
month_of_year
quarter
search_engine_results_page_type
week
year
 Metrics
average_cpc
clicks
combined_clicks
combined_clicks_per_query
combined_queries
ctr
impressions
organic_clicks
organic_clicks_per_query
organic_impressions
organic_impressions_per_query
organic_queries
Field descriptionOutput only. The resource name of the search term view. Search term view resource names have the form: customers/{customer_id}/paidOrganicSearchTermViews/{campaign_id}~ {ad_group_id}~{URL-base64 search term}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse
Field descriptionOutput only. The search term.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.date

Field descriptionDate to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.day_of_week

Field descriptionDay of the week, for example, MONDAY.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v17.enums.DayOfWeekEnum.DayOfWeek
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.device

Field descriptionDevice to which metrics apply.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v17.enums.DeviceEnum.Device
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.keyword.ad_group_criterion

Field descriptionThe AdGroupCriterion resource name.
CategorySEGMENT
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.keyword.info.match_type

Field descriptionThe match type of the keyword.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v17.enums.KeywordMatchTypeEnum.KeywordMatchType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.keyword.info.text

Field descriptionThe text of the keyword (at most 80 characters and 10 words).
CategorySEGMENT
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.month

Field descriptionMonth as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.month_of_year

Field descriptionMonth of the year, for example, January.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v17.enums.MonthOfYearEnum.MonthOfYear
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.quarter

Field descriptionQuarter 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.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.search_engine_results_page_type

Field descriptionType of the search engine results page.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v17.enums.SearchEngineResultsPageTypeEnum.SearchEngineResultsPageType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.week

Field descriptionWeek as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.year

Field descriptionYear, formatted as yyyy.
CategorySEGMENT
Data TypeINT32
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpc

Field descriptionThe total cost of all clicks divided by the total number of clicks received.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.clicks

Field descriptionThe number of clicks.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.combined_clicks

Field descriptionThe number of times your ad or your site's listing in the unpaid results was clicked. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.combined_clicks_per_query

Field descriptionThe number of times your ad or your site's listing in the unpaid results was clicked (combined_clicks) divided by combined_queries. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.combined_queries

Field descriptionThe number of searches that returned pages from your site in the unpaid results or showed one of your text ads. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.ctr

Field descriptionThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.impressions

Field descriptionCount of how often your ad has appeared on a search results page or website on the Google Network.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.organic_clicks

Field descriptionThe number of times someone clicked your site's listing in the unpaid results for a particular query. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.organic_clicks_per_query

Field descriptionThe number of times someone clicked your site's listing in the unpaid results (organic_clicks) divided by the total number of searches that returned pages from your site (organic_queries). See the help page at https://support.google.com/google-ads/answer/3097241 for details.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.organic_impressions

Field descriptionThe number of listings for your site in the unpaid search results. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.organic_impressions_per_query

Field descriptionThe number of times a page from your site was listed in the unpaid search results (organic_impressions) divided by the number of searches returning your site's listing in the unpaid results (organic_queries). See the help page at https://support.google.com/google-ads/answer/3097241 for details.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.organic_queries

Field descriptionThe total number of searches that returned your site's listing in the unpaid results. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse