FeedData
Get the status of uploaded item list.
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 '='.
- FeedId supports the '=,IN'.
- FileUploadStatus supports the '=,IN'.
- ItemListUploadId supports the '=,IN'.
- StartDate supports the '='.
- EndDate supports the '='.
For example, the following queries are processed server side:
SELECT * FROM FeedData WHERE AccountId = '96473'
Columns
| Name | Type | References | Description |
| FeedId [KEY] | Int64 | Feed ID. | |
| AccountId | Int64 |
DisplayAdsAccounts.AccountId | Account ID. |
| CompleteDate | Date | Complete Date. | |
| ErrorCount | Int64 | Number od item list with error. | |
| ErrorRate | String | Error rate. | |
| FileUploadSource | String | Displays source of item list upload.
使用できる値は次のとおりです。CAMPAIGN_MANAGEMENT_TOOL, API, FTP_SCHEDULE, FTP_DIRECT, UNKNOWN | |
| FileUploadStatus | String | Displays status of file upload.
使用できる値は次のとおりです。UPLOADED, COMPLETED, FILE_FORMAT_ERROR, SYSTEM_ERROR, NETWORK_ERROR, FILE_NOT_FOUND_ERROR, FILE_SIZE_OVER_ERROR, AUTH_ERROR, UPLOAD_COUNT_OVER_ERROR, NOT_MODIFIED, UNKNOWN | |
| IsDebug | Boolean | true means to run in debug mode. | |
| ItemListUploadId | Int64 | Uploaded item list ID. | |
| ItemListUploadType | String | Displays upload type of item list.
使用できる値は次のとおりです。UPDATE_PART, UPDATE_ALL, UNKNOWN | |
| UploadDate | Date | Upload date. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| StartDate | Date | Start date. | |
| EndDate | Date | End date. |