Excel Add-In for Yahoo! Ads

Build 24.0.9062

KeywordPlanIdeas

Suggests new related keywords based on the specified value.

Table Specific Information

Select

The 本製品 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 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062