KeywordPlanIdeas
Suggests new related keywords based on the specified value.
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 AccountId is required to make a request and the rest of the filter is executed client-side within the connector.
- AccountId supports the '='.
- KeywordAndUrlSeedKeywords supports the '=,IN'.
- KeywordAndUrlSeedUrl supports the '='.
- KeywordSeedKeywords supports the '=,IN'.
- UrlSeedUrl supports the '='.
- SiteSeedSite supports the '='.
- SeedType supports the '='.
For example:
SELECT * FROM KeywordPlanIdeas WHERE AccountId = '1234339' AND SeedType = 'SITE' AND SiteSeedSite = 'https://cdata.com/'
Columns
| Name | Type | References | Description |
| Text | String | Keyword. | |
| AccountId | Int64 | Account ID. | |
| SeedType | String | Describes a type of related keywords creation conditions.
使用できる値は次のとおりです。KEYWORD_AND_URL, KEYWORD, URL, SITE, UNKNOWN |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| Url | String | URL. If seedType is URL, this field is required. | |
| KeywordAndUrlSeedKeywords | String | Keyword. If seedType is KEYWORD_AND_URL, this field is required. | |
| KeywordAndUrlSeedUrl | String | URL. If seedType is KEYWORD_AND_URL, this field is required. | |
| KeywordSeedKeywords | String | Keyword. If seedType is KEYWORD, this field is required. | |
| UrlSeedUrl | String | URL. If seedType is URL, this field is required. | |
| SiteSeedSite | String | Site (domain URL). If seedType is SITE, this field is required. |