Videos
Read, Update or Delete Video Ads.
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 '='.
- MediaId supports the '=,IN'.
- ApprovalStatus supports the '=,IN'.
- ProcessStatus supports the '=,IN'.
- UserStatus supports the '='.
- StartDate supports the '='.
- EndDate supports the '='.
For example:
SELECT * FROM Videos WHERE AccountId = '1002504155'; SELECT * FROM Videos WHERE AccountId = '1002504155' AND MediaId = '123456' SELECT * FROM Videos WHERE AccountId = '1002504155' AND StartDate = '20210703' SELECT * FROM Videos WHERE AccountId = '1002504155' AND EndDate = '20210703'
UPDATE
Update can be executed by specifying the AccountId and MediaId in the WHERE Clause. The columns that are not read-only can be Updated. For example:
UPDATE Videos SET VideoName = 'Testvideo' WHERE AccountId = '1002504155' AND MediaId = '123456'
DELETE
Delete can be executed by specifying the AccountId and MediaId in the WHERE Clause. For example:
DELETE FROM Videos WHERE AccountId = '1002504155' AND MediaId = '123456'
Columns
Name | Type | ReadOnly | References | Description |
MediaId [KEY] | Int64 | True |
Media.MediaId |
Media ID. |
AccountId | Int64 | True |
DisplayAdsAccounts.AccountId |
Account ID. |
ApprovalStatus | String | False |
Editorial status. 使用できる値は次のとおりです。APPROVED, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN | |
CreatedDate | Date | True |
Date when the video was made. | |
CreatedDateTime | String | False |
Time and date when the video was submitted. | |
DisapprovalReasonCodes | String | False |
Disapproval reason of the video. | |
ProcessStatus | String | False |
process status of videos 使用できる値は次のとおりです。PROCESSING, FINISHED, FAILED, UNKNOWN | |
UserStatus | String | False |
Ad delivery status that can be set by an user. 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN | |
VideoName | String | False |
Video file name. | |
VideoSettingExtraSpecs | String | False |
It is an additional video quality that can be used other than the regular video qualities. | |
VideoSettingFileSize | Int64 | False |
File size of the video. | |
VideoSettingFileType | String | False |
File type of videos. 使用できる値は次のとおりです。MP4, UNKNOWN | |
VideoSettingHeight | Int64 | False |
Height (vertical length) of the video. | |
VideoSettingPlaybackTime | Int64 | False |
Play time (sec) of the video. | |
VideoSettingVideoAdFormat | String | False |
Ad format type of the video ad. | |
VideoSettingVideoAspectRatio | String | False |
Type of aspect ratio. | |
VideoSettingWidth | Int64 | False |
Width of the video. | |
VideoTitle | String | False |
Video name. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
StartDate | Date |
start date of the search target period. |
EndDate | Date |
end date of the search target period. |
ReferenceNumber | String |
This column will be used in Bulk operations to get specific values from the Temp tables. |