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

paid_organic_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}/paidOrganicSearchTermViews/{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

paid_organic_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

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.v17.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.v17.enums.DeviceEnum.Device`
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.v17.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.v17.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_engine_results_page_type
Field description	Type of the search engine results page.
Category	`SEGMENT`
Data Type	`ENUM ADS_AND_ORGANIC ADS_ONLY ORGANIC_ONLY UNKNOWN UNSPECIFIED`
Type URL	`google.ads.googleads.v17.enums.SearchEngineResultsPageTypeEnum.SearchEngineResultsPageType`
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.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.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.combined_clicks
Field description	The 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.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.combined_clicks_per_query
Field description	The 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.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.combined_queries
Field description	The 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.
Category	`METRIC`
Data Type	`INT64`
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.organic_clicks
Field description	The 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.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.organic_clicks_per_query
Field description	The 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.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.organic_impressions
Field description	The 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.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.organic_impressions_per_query
Field description	The 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.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.organic_queries
Field description	The 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.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

paid_organic_search_term_view

Fields/Segments/Metrics

paid_organic_search_term_view.resource_name

paid_organic_search_term_view.search_term

segments.date

segments.day_of_week

segments.device

segments.keyword.ad_group_criterion

segments.keyword.info.match_type

segments.keyword.info.text

segments.month

segments.month_of_year

segments.quarter

segments.search_engine_results_page_type

segments.week

segments.year

metrics.average_cpc

metrics.clicks

metrics.combined_clicks

metrics.combined_clicks_per_query

metrics.combined_queries

metrics.ctr

metrics.impressions

metrics.organic_clicks

metrics.organic_clicks_per_query

metrics.organic_impressions

metrics.organic_impressions_per_query

metrics.organic_queries