PaidOrganicSearchTermView
A paid organic search term view providing a view of search stats across
View-Specific Information
Select
Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are returned. In general, these defaults are the same fields that are exposed through the Ads console. To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.
Columns
| Name | Type | Behavior | Description |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| PaidOrganicSearchTermViewResourceName | String | ATTRIBUTE | Output only. The resource name of the search term view. |
| PaidOrganicSearchTermViewSearchTerm | String | ATTRIBUTE | Output only. The search term. |
| AverageCpc | Double | METRIC | The total cost of all clicks divided by the total number of clicks |
| Clicks | Long | METRIC | The number of clicks. |
| CombinedClicks | Long | METRIC | The number of times your ad or your site's listing in the unpaid |
| CombinedClicksPerQuery | Double | METRIC | The number of times your ad or your site's listing in the unpaid |
| CombinedQueries | Long | METRIC | The number of searches that returned pages from your site in the unpaid |
| Ctr | Double | METRIC | The number of clicks your ad receives (Clicks) divided by the number |
| Impressions | Long | METRIC | Count of how often your ad has appeared on a search results page or |
| OrganicClicks | Long | METRIC | The number of times someone clicked your site's listing in the unpaid |
| OrganicClicksPerQuery | Double | METRIC | The number of times someone clicked your site's listing in the unpaid |
| OrganicImpressions | Long | METRIC | The number of listings for your site in the unpaid search results. See the |
| OrganicImpressionsPerQuery | Double | METRIC | The number of times a page from your site was listed in the unpaid search |
| OrganicQueries | Long | METRIC | The total number of searches that returned your site's listing in the |
| Date | Date | SEGMENT | Date to which metrics apply. |
| DayOfWeek | String | SEGMENT | Day of the week, for example, MONDAY.
The allowed values are FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY. |
| Device | String | SEGMENT | Device to which metrics apply.
The allowed values are CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN. |
| KeywordAdGroupCriterion | String | SEGMENT | The AdGroupCriterion resource name. |
| KeywordInfoMatchType | String | SEGMENT | The match type of the keyword.
The allowed values are BROAD, EXACT, PHRASE, UNKNOWN. |
| KeywordInfoText | String | SEGMENT | The text of the keyword (at most 80 characters and 10 words). |
| Month | Date | SEGMENT | Month as represented by the date of the first day of a month. Formatted as |
| MonthOfYear | String | SEGMENT | Month of the year, for example, January.
The allowed values are APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN. |
| Period | String | SEGMENT | Predefined date range.
The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN. |
| Quarter | Date | SEGMENT | Quarter as represented by the date of the first day of a quarter. |
| SearchEngineResultsPageType | String | SEGMENT | Type of the search engine results page.
The allowed values are ADS_AND_ORGANIC, ADS_ONLY, ORGANIC_ONLY, UNKNOWN. |
| Week | Date | SEGMENT | Week as defined as Monday through Sunday, and represented by the date of |
| Year | Int | SEGMENT | Year, formatted as yyyy. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |