PageFeedItems
Get information related to page feed item.
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 and FeedId is required to make a request and the rest of the filter is executed client-side within the 本製品.
- AccountId supports the '='.
- FeedId supports the '=,IN'.
- ApprovalStatussupports the '=,IN'.
- PageFeedCustomLabelsupports the '=,IN'.
- MatchTypesupports the '='.
- Textsupports the '='.
For example:
SELECT * FROM PageFeedItems WHERE AccountId = '12353' AND FeedId = '8962'
SELECT * FROM PageFeedItems WHERE AccountId = '12353' AND FeedId = '8962' AND ApprovalStatus IN ('APPROVED')
SELECT * FROM PageFeedItems WHERE AccountId = '12353' AND FeedId = '8962' AND PageFeedCustomLabel IN ('LABEL')
SELECT * FROM PageFeedItems WHERE AccountId = '12353' AND MatchType = 'EXACT' AND FeedId='8962' AND Text = 'www.computerhope.com/jargon/u/url.htm'
SELECT * FROM PageFeedItems WHERE AccountId = '13525' AND FeedId IN ('8962')
Columns
| Name | Type | References | Description |
| PageFeedItemId [KEY] | Int64 | Page feed Item ID. | |
| AccountId | Int64 |
SearchAdsAccounts.AccountId | Account ID. |
| FeedId | Int64 |
SearchAdsFeeds.FeedId | Label ID. |
| ApprovalStatus | String | Displays Editorial Status.
使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN | |
| DisapprovalReasonCodes | String | Codes of disapproval reason. | |
| DisapprovalReasonComment | String | Comment of disapproval reason. | |
| PageFeedCustomLabel | String | Custom label. | |
| PageFeedUrl | String | object stores search condition of page feed URL. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| MatchType | String | Search method of page feed URL.
使用できる値は次のとおりです。EXACT, BROAD, UNKNOWN | |
| Text | String | Page feed URL |