FeedItems

Create, Read, Update or Delete Feed Item information.

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 '='.
FeedItemId supports the '=,IN'.
ApprovalStatus supports the '=,IN'.
FeedId supports the '=,IN'.
PlaceholderType supports the '=,IN'.

For example:

SELECT * FROM FeedItems WHERE AccountId = '25687'

SELECT * FROM FeedItems WHERE AccountId = '234535' AND FeedItemId = '456971'

SELECT * FROM FeedItems WHERE AccountId = '234535' AND ApprovalStatus IN('APPROVED_WITH_REVIEW')

SELECT * FROM FeedItems WHERE AccountId = '234535' AND FeedId IN ('1470')

SELECT * FROM FeedItems WHERE AccountId = '234535' AND PlaceholderType IN ('CALLEXTENSION', 'AD_CUSTOMIZER')

Columns


Name	Type	References	Description
FeedItemId [KEY]	Int64		Feed Item ID.
AccountId	Int64	SearchAdsAccounts.AccountId	Account ID.
ApprovalStatus	String		FeedItemServiceApprovalStatus displays Editorial Status. 使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN
CustomParametersIsRemove	String		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
CustomParameters	String		Displays the element of custom parameters.
DevicePreference	String		A selection of device to deliver ads in high priority. 使用できる値は次のとおりです。SMART_PHONE, NONE, UNKNOWN デフォルト値はSMART_PHONEです。
DisapprovalReasonCodes	String		Reject reason on editorial review.
StartDate	Date		Start date of ad display.
EndDate	Date		End date of ad display.
FeedId	Int64	SearchAdsFeeds.FeedId	Feed ID.
FeedItemAttribute	String		Object holds the value of Feed Item information.
FeedItemTrackId	Int64		Feed Item ID for tracking.
InvalidedTrademarks	String		Invalided trademarks.
LocationCriterionTypeFeedItem	String		Describes criteria information of location restriction. 使用できる値は次のとおりです。LOCATION, UNKNOWN デフォルト値はLOCATIONです。
LocationGeoRestriction	String		Controls ad delivery of location restriction. 使用できる値は次のとおりです。NONE, LOCATION_OF_PRESENCE, UNKNOWN デフォルト値はNONEです。
LocationIsRemove	String		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
LocationTargetId	String		FeedItemServiceLocation Type Code.
PlaceholderType	String		selects FeeItem information type. 使用できる値は次のとおりです。QUICKLINK, CALLEXTENSION, AD_CUSTOMIZER, CALLOUT, STRUCTURED_SNIPPET, UNKNOWN
ReviewCustomParametersIsRemove	String		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
ReviewCustomParameters	String		Displays the element of custom parameters.
SchedulingSchedules	String		Describes display schedule from Ad Display Option.
TargetingAdGroupTargetingAdGroupId	Int64		Targeting Ad group ID.
TargetingCampaignTargetingCampaignId	Int64		Campaign ID used for ad display.
TargetingKeywordKeywordMatchType	String		Describes keyword match type. 使用できる値は次のとおりです。EXACT, PHRASE, BROAD, UNKNOWN
TargetingKeywordTargetingKeywordId	Int64		ID to identify the Targeting keyword (text).
TargetingKeywordText	String		Keyword text.
TrademarkStatus	String		Describes the status of trademark. 使用できる値は次のとおりです。DISAPPROVAL_CLAIM, DISAPPROVAL_REVIEWER, NO_RESTRICTION, CONFLICT_WITH_TRADEMARK, CLAIM_IN_PROGRESS, UNKNOWN

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
ReferenceNumber	String		This column will be used in Bulk operations to get specific values from the Temp tables.

ADO.NET Provider for Yahoo! Ads

FeedItems

Table Specific Information

Select

Columns

Pseudo-Columns