Videos

Read, Update or Delete Video Ads.

Table Specific Information

Select

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

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.