ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

SearchKeywordIdeas

Get the keyword for search targeting.

Table Specific Information

SELECT

The 本製品 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 本製品. 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 '='.
For example:
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

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