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.
使用できる値は次のとおりです。FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY |
| Device | String | SEGMENT | Device to which metrics apply.
使用できる値は次のとおりです。CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN |
| KeywordAdGroupCriterion | String | SEGMENT | The AdGroupCriterion resource name. |
| KeywordInfoMatchType | String | SEGMENT | The match type of the keyword.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN |
| Period | String | SEGMENT | Predefined date range.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |