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