SearchKeywordIdeas
Get the keyword for search targeting.
Table Specific Information
SELECT
The connector will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector. Note: AccountId is required for Select on this table
- SearchKeywordId supports the '=,IN'.
- AvailabilityStatus supports the '='.
- SearchKeyword supports the '=,IN'.
- KeywordFrequency supports the '='.
- KeywordRecency supports the '='.
- MatchType supports the '='.
- SortField supports the '='.
- SortType supports the '='.
SELECT * FROM SearchKeywordIdeas WHERE AvailabilityStatus = 'AVAILABLE' LIMIT 10
Columns
| Name | Type | References | Description |
| SearchKeywordId [KEY] | Int64 | Search Keyword ID | |
| AvailabilityStatus | String | Availability of keywords for search targeting
使用できる値は次のとおりです。AVAILABLE, UNAVAILABLE, UNKNOWN | |
| CloseDate | Date | Stop date of keyword. | |
| DesktopSearchVolume | Int64 | Reach numbers on PC. | |
| ReleaseDate | Date | Additional date of keyword. | |
| SearchKeyword | String | Search Keyword. | |
| SmartPhoneSearchVolume | Int64 | Reach numbers on Smartphone. | |
| TabletSearchVolume | Int64 | Reach numbers on Tablet. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| KeywordFrequency | String | search frequency information on Search Keyword.
使用できる値は次のとおりです。ONCE_OR_MORE, TWICE_OR_MORE, THREE_TIMES_OR_MORE, UNKNOWN | |
| KeywordRecency | String | Storing the effective period information of Search Keyword.
使用できる値は次のとおりです。WITHIN_1DAY, WITHIN_3DAYS, WITHIN_7DAYS, WITHIN_14DAYS, WITHIN_30DAYS, UNKNOWN | |
| MatchType | String | Search method
使用できる値は次のとおりです。EXACT, BROAD, UNKNOWN |