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')

INSERT

Insert can be executed by specifying the AccountId,CustomParameters,FeedItemAttribute,LocationTargetId,ReviewCustomParameters,TargetingKeywordKeywordMatchType and TargetingKeywordText columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table

INSERT INTO FeedItems(AccountId,CustomParameters,FeedItemAttribute,LocationTargetId,ReviewCustomParameters,TargetingKeywordKeywordMatchType,TargetingKeywordText) VALUES('4698','Testparameter','Feedobject','RA11','parameter1','PHRASE','DISAPPROVAL_REVIEWER');

UPDATE

Update can be executed by specifying the AccountId, FeedItemId, CustomParameters, ReviewCustomParameters, TargetingKeywordKeywordMatchType and TargetingKeywordText in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE FeedItems SET TargetScheduleTargetDayOfWeek='WEDNESDAY' WHERE AccountId = '78955' AND FeedItemId = '56279' AND CustomParameters = 'Testparameter' AND ReviewCustomParameters = 'parameter1' AND TargetingKeywordKeywordMatchType = 'EXACT' AND TargetingKeywordText = 'KEY'

DELETE

Delete can be executed by specifying the AccountId and FeedItemId in the WHERE Clause. For example:

DELETE FROM FeedItems WHERE AccountId = '78955' AND FeedItemId = '475219' AND PlaceholderType = 'QUICKLINK'

Columns


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

CData Python Connector for Yahoo! Ads