GuaranteedAdGroupAds

Create, Read, Update guaranteed ad and use AdGroupAd/remove to delete the guaranteed ad.

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 '='.
AdGroupId supports the '=,IN'.
AdId supports the '=,IN'.
CampaignId supports the '=,IN'.
ContainsLabelIdFlg supports the '='.
LabelId supports the '=,IN'.
MediaId supports the '=,IN'.

For example:

SELECT * FROM GuaranteedAdGroupAds WHERE AccountId = '123436'

Insert

Insert can be executed by specifying the AccountId, AdType, AdGroupId, AdName, CampaignId and UserStatus columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table

INSERT INTO GuaranteedAdGroupLabels#TEMP (Color, Description, LabelId, LabelName) VALUES ('#0000FF', 'Testing GuaranteedAdGroupAdLabels', '1000158197', 'TestGuaranteedAdGroupAdLabel')

INSERT INTO GuaranteedAdGroupAds (AccountId, AdType, BannerImageAdUrl, Labels, AdGroupId, AdName, CampaignId, UserStatus) VALUES ('1002504155', 'BANNER_IMAGE_AD', 'https://www.cdata.com', 'GuaranteedAdGroupLabels#TEMP', '303302921', 'TestAdGroupAd', '437154455', 'ACTIVE')

Update

Update can be executed by specifying the AccountId and AdId in the WHERE Clause. The columns that are not read-only can be Updated. For example:

INSERT INTO GuaranteedAdGroupAdLabels#TEMP (Color, Description, LabelName) VALUES ('#0000FF', 'Updating GuaranteedAdGroupAdLabels', 'TestGuaranteedAdGroupLabel')
UPDATE GuaranteedAdGroupAds SET AdType='BANNER_IMAGE_AD', BannerImageAdDisplayUrl='www.bannerimageaddisplayurl.com', BannerImageAdUrl='www.bannerimageadurl.com', Labels='GuaranteedAdGroupAdLabels#TEMP', AdGroupId=12353463, AdName=UpdateGuaranteedAdGroupAd, CampaignId='8232533', UserStatus='ACTIVE' WHERE AccountId='123436' AND AdId='2737353'

Columns


Name	Type	ReadOnly	References	Description
AccountId	Int64	True	DisplayAdsAccounts.AccountId	Account ID.
AdGroupId	Int64	True	GuaranteedAdGroups.AdGroupId	Ad group ID
AdGroupName	String	False		Ad group name
AdType	String	False		Type of ad. 使用できる値は次のとおりです。BANNER_VIDEO_AD, BANNER_IMAGE_AD, BRANDPANEL_QUINTIE, BRANDPANEL_QUINTIE_VIDEO, BRANDPANEL_PANORAMA, BRANDPANEL_PANORAMA_VIDEO, TOP_IMPACT_SQUARE, TOP_IMPACT_SQUARE_VIDEO, TOP_IMPACT_QUINTIE, TOP_IMPACT_QUINTIE_VIDEO, TOP_IMPACT_PANORAMA, TOP_IMPACT_PANORAMA_VIDEO, TOP_IMPACT_PANORAMA_SIDE_VISION_VIDEO, TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, TOP_IMPACT_THEATER_VIDEO, TOP_IMPACT_SQUARE_SPECIAL, TOP_IMPACT_SQUARE_SPECIAL_VIDEO, TOP_IMPACT_PRIME_DISPLAY_DOUBLE, TOP_IMPACT_PRIME_DISPLAY_DOUBLE_VIDEO, INSTREAM_VIDEO_AD, CAROUSEL_AD, UNKNOWN
BannerImageAdDisplayUrl	String	False		Display URL. If AdType is BANNER_IMAGE_AD, this field is required in ADD operation.
BannerImageAdUrl	String	False		Destination URL. If AdType is BANNER_IMAGE_AD, this field is required in ADD operation.
BannerImageAdCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerImageAdCustomParameters	String	False		Displays the element of custom parameters.
BannerImageAdDisplayUrlLevel	String	False		Display URL.
BannerImageAdFinalUrl	String	False		Final URL.
BannerImageAdSmartphoneFinalUrl	String	False		Final URL (smartphone).
BannerImageAdisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
BannerImageAdisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
BannerImageAdtrackingUrl	String	False		Destination URL.
BannerVideoAdDisplayUrl	String	False		Display URL.
BannerVideoAdAddisplayUrlLevel	String	False		Display URL.
BannerVideoAdAdFinalUrl	String	False		Final URL.
BannerVideoAdAdSmartphoneFinalUrl	String	False		Final URL (smartphone).
BannerVideoAdAdisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
BannerVideoAdAdisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
BannerVideoAdCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerVideoAdCustomParameters	String	False		Displays the element of custom parameters.
BannerVideoAdIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerVideoAdIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerVideoAdIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerVideoAdIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerVideoAdIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerVideoAdIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerVideoAdIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BannerVideoAdThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is BANNER_VIDEO_AD, this field is required in ADD operation.
BannerVideoAdUrl	String	False		Destination URL. If AdType is BANNER_VIDEO_AD, this field is required in ADD operation.
BannerVideoAdVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).Available URL is only (https).
BannerVideoAdVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).Available URL is only (https).
BannerVideoAdVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).Available URL is only (https).
BannerVideoAdVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%).Available URL is only (https).
BannerVideoAdVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%).Available URL is only (https).
BannerVideoAdVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete).Available URL is only (https).
BannerVideoAdVideoStartBeaconUrls	String	False		Viewing Beacon URL (start).Available URL is only (https).
BrandPanelPanoramaAdShrinkMainMediaId	Int64	False		Reduced main image. If AdType is BRANDPANEL_PANORAMA, this field is required in ADD operation.
BrandPanelAddisplayUrlLevel	String	False		Display URL.
BrandPanelFinalUrl	String	False		Final URL.
BrandPanelSmartphoneFinalUrl	String	False		Final URL (smartphone).
BrandPanelisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
BrandPanelisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
BrandPanelCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelCustomParameters	String	False		Displays the element of custom parameters.
BrandPanelPanoramaUrl	String	False		Destination URL. If AdType is BRANDPANEL_PANORAMA, this field is required in ADD operation.
BrandPanelPanoramaVideoAdShrinkMainMediaId	Int64	False		Reduced main image. If AdType is BRANDPANEL_PANORAMA, this field is required in ADD operation.
BrandPanelPanoramaVideoDisplayUrl	String	False		Display URL. If AdType is BRANDPANEL_PANORAMA, this field is required in ADD operation.
BrandPanelPanoramaVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelPanoramaVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelPanoramaVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelPanoramaVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelPanoramaVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelPanoramaVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelPanoramaVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelPanoramaVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is BRANDPANEL_PANORAMA_VIDEO, this field is required in ADD operation.
BrandPanelPanoramaVideoUrl	String	False		Destination URL. If AdType is BRANDPANEL_PANORAMA_VIDEO, this field is required in ADD operation.
BrandPanelPanoramaVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).Available URL is only https.
BrandPanelPanoramaVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).Available URL is only https.
BrandPanelPanoramaVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).Available URL is only https.
BrandPanelPanoramaVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%).Available URL is only https.
BrandPanelPanoramaVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%).Available URL is only https.
BrandPanelPanoramaVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete).Available URL is only https.
BrandPanelPanoramaVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start).Available URL is only https.
BrandPanelQuintieDisplayUrl	String	False		Display URL. If AdType is BRANDPANEL_QUINTIE, this field is required in ADD operation.
BrandPanelQuintieUrl	String	False		Destination URL. If AdType is BRANDPANEL_QUINTIE, this field is required in ADD operation.
BrandPanelQuintieDisplayUrlLevel	String	False		Display URL.
BrandPanelQuintieAdFinalUrl	String	False		Final URL.
BrandPanelQuintieAdSmartphoneFinalUrl	String	False		Final URL (smartphone).
BrandPanelQuintieisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
BrandPanelQuintieisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
BrandPanelQuintieCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelQuintieCustomParameters	String	False		Displays the element of custom parameters.
BrandPanelQuintiePanoramaUrl	String	False		Destination URL. If AdType is BRANDPANEL_PANORAMA, this field is required in ADD operation.
BrandPanelQuintieVideoDisplayUrl	String	False		Display URL. If AdType is BRANDPANEL_QUINTIE, this field is required in ADD operation.
BrandPanelQuintieVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelQuintieVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelQuintieVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelQuintieVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelQuintieVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information itemIf the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelQuintieVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelQuintieVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
BrandPanelQuintieVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is BRANDPANEL_QUINTIE_VIDEO, this field is required in ADD operation.
BrandPanelQuintieVideoUrl	String	False		Destination URL If AdType is BRANDPANEL_QUINTIE_VIDEO, this field is required in ADD operation.
BrandPanelQuintieVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).Available URL is only https.
BrandPanelQuintieVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).Available URL is only https.
BrandPanelQuintieVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).
BrandPanelQuintieVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%).Available URL is only https.
BrandPanelQuintieVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%).Available URL is only https.
BrandPanelQuintieVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete).Available URL is only https.
BrandPanelQuintieVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start).Available URL is only https.
InstreamVideoDisplayUrl	String	False		Display URL. If AdType is INSTREAM_VIDEO_AD, this field is required in ADD operation.
InstreamVideoDisplayUrlLevel	String	False		Display URL.
InstreamVideoAdFinalUrl	String	False		Final URL.
InstreamVideoAdSmartphoneFinalUrl	String	False		Final URL (smartphone).
InstreamVideoisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
InstreamVideoisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
InstreamVideoCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
InstreamVideoCustomParameters	String	False		Displays the element of custom parameters.
InstreamVideoHeadline	String	False		Headline.
InstreamVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
InstreamVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
InstreamVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
InstreamVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
InstreamVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
InstreamVideoUrl	String	False		Destination URL. If AdType is INSTREAM_VIDEO_AD, this field is required in ADD operation.
InstreamVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%)
InstreamVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%)
InstreamVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%)
InstreamVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete)
InstreamVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start)
TopImpactPanoramaAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_PANORAMA, this field is required in ADD operation.
TopImpactPanoramaAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_PANORAMA, this field is required in ADD operation.
TopImpactPanoramaAdShrinkMainMediaId	Int64	False		Reduced main image. If AdType is TOP_IMPACT_PANORAMA, this field is required in ADD operation.
TopImpactPanoramaDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_PANORAMA, this field is required in ADD operation.
TopImpactPanoramaAddisplayUrlLevel	String	False		Display URL.
TopImpactPanoramaFinalUrl	String	False		Final URL.
TopImpactPanoramaSmartphoneFinalUrl	String	False		Final URL (smartphone).
TopImpactPanoramaisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPanoramaisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPanoramaCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaCustomParameters	String	False		Displays the element of custom parameters.
TopImpactPanoramaUrl	String	False		Destination URL. If AdType is TOP_IMPACT_PANORAMA, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoAdLeftSideMediaId2	Int64	False		Left side image. If AdType is TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoAdRightSideMediaId2	Int64	False		Right side image. If AdType is TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoAdShrinkMainMediaId	Int64	False		Reduced main image. If AdType is TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideSwitchVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideSwitchVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideSwitchVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideSwitchVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideSwitchVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideSwitchVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideSwitchVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoUrl	String	False		Destination URL. If AdType is TOP_IMPACT_PANORAMA_SIDE_SWITCH_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideSwitchVideoAddisplayUrlLevel	String	False		Display URL.
TopImpactPanoramaSideSwitchVideoFinalUrl	String	False		Final URL.
TopImpactPanoramaSideSwitchVideoSmartphoneFinalUrl	String	False		Final URL (smartphone).
TopImpactPanoramaSideSwitchVideoisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPanoramaSideSwitchVideoisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPanoramaSideSwitchVideoCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideSwitchVideoCustomParameters	String	False		Displays the element of custom parameters.
TopImpactPanoramaSideSwitchVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).
TopImpactPanoramaSideSwitchVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).
TopImpactPanoramaSideSwitchVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).
TopImpactPanoramaSideSwitchVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%)
TopImpactPanoramaSideSwitchVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%)
TopImpactPanoramaSideSwitchVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete)
TopImpactPanoramaSideSwitchVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start)
TopImpactPanoramaSideVisionVideoAdShrinkMainMediaId	Int64	False		Reduced main image. If AdType is TOP_IMPACT_PANORAMA_SIDE_VISION_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideVisionVideoDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_PANORAMA_SIDE_VISION_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideVisionVideoAddisplayUrlLevel	String	False		Display URL.
TopImpactPanoramaSideVisionVideoFinalUrl	String	False		Final URL.
TopImpactPanoramaSideVisionVideoSmartphoneFinalUrl	String	False		Final URL (smartphone).
TopImpactPanoramaSideVisionVideoisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPanoramaSideVisionVideoisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPanoramaSideVisionVideoCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideVisionVideoCustomParameters	String	False		Displays the element of custom parameters.
TopImpactPanoramaSideVisionVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideVisionVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideVisionVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideVisionVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideVisionVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideVisionVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideVisionVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaSideVisionVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is TOP_IMPACT_PANORAMA_SIDE_VISION_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideVisionVideoUrl	String	False		Destination URL. If AdType is TOP_IMPACT_PANORAMA_SIDE_VISION_VIDEO, this field is required in ADD operation.
TopImpactPanoramaSideVisionVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).
TopImpactPanoramaSideVisionVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).
TopImpactPanoramaSideVisionVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).
TopImpactPanoramaSideVisionVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%)
TopImpactPanoramaSideVisionVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%)
TopImpactPanoramaSideVisionVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete)
TopImpactPanoramaSideVisionVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start)
TopImpactPanoramaVideoAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_PANORAMA_VIDEO, this field is required in ADD operation.
TopImpactPanoramaVideoAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_PANORAMA_VIDEO, this field is required in ADD operation.
TopImpactPanoramaVideoAdShrinkMainMediaId	Int64	False		Reduced main image. If AdType is TOP_IMPACT_PANORAMA_VIDEO, this field is required in ADD operation.
TopImpactPanoramaVideoDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_PANORAMA_VIDEO, this field is required in ADD operation.
TopImpactPanoramaVideoAddisplayUrlLevel	String	False		Display URL.
TopImpactPanoramaVideoFinalUrl	String	False		Final URL.
TopImpactPanoramaVideoSmartphoneFinalUrl	String	False		Final URL (smartphone).
TopImpactPanoramaVideoisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPanoramaVideoisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPanoramaVideoCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaVideoCustomParameters	String	False		Displays the element of custom parameters.
TopImpactPanoramaVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPanoramaVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is TOP_IMPACT_PANORAMA_VIDEO, this field is required in ADD operation.
TopImpactPanoramaVideoUrl	String	False		Destination URL. If AdType is TOP_IMPACT_PANORAMA_VIDEO, this field is required in ADD operation.
TopImpactPanoramaVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).
TopImpactPanoramaVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).
TopImpactPanoramaVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).
TopImpactPanoramaVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%)
TopImpactPanoramaVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%)
TopImpactPanoramaVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete)
TopImpactPanoramaVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start)
TopImpactPrimeDisplayDoubleAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleUrl	String	False		Destination URL. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleVideoAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleVideoAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleVideoDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleVideoAddisplayUrlLevel	String	False		Display URL.
TopImpactPrimeDisplayDoubleVideoFinalUrl	String	False		Final URL.
TopImpactPrimeDisplayDoubleVideoSmartphoneFinalUrl	String	False		Final URL (smartphone).
TopImpactPrimeDisplayDoubleVideoisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPrimeDisplayDoubleVideoisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactPrimeDisplayDoubleVideoCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPrimeDisplayDoubleVideoCustomParameters	String	False		Displays the element of custom parameters.
TopImpactPrimeDisplayDoubleVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPrimeDisplayDoubleVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPrimeDisplayDoubleVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPrimeDisplayDoubleVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPrimeDisplayDoubleVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPrimeDisplayDoubleVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPrimeDisplayDoubleVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactPrimeDisplayDoubleVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleVideoUrl	String	False		Destination URL. If AdType is TOP_IMPACT_PRIME_DISPLAY_DOUBLE, this field is required in ADD operation.
TopImpactPrimeDisplayDoubleVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).
TopImpactPrimeDisplayDoubleVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).
TopImpactPrimeDisplayDoubleVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).
TopImpactPrimeDisplayDoubleVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%)
TopImpactPrimeDisplayDoubleVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%)
TopImpactPrimeDisplayDoubleVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete)
TopImpactPrimeDisplayDoubleVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start)
TopImpactQuintieAdCenterMediaId	Int64	False		Center image. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieFinalUrl	String	False		Final URL.
TopImpactQuintieSmartphoneFinalUrl	String	False		Final URL (smartphone).
TopImpactQuintieisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactQuintieisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactQuintieCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactQuintieCustomParameters	String	False		Displays the element of custom parameters.
TopImpactQuintieUrl	String	False		Destination URL. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieVideoAdCenterMediaId	Int64	False		Center image. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieVideoAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieVideoAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieVideoDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_QUINTIE, this field is required in ADD operation.
TopImpactQuintieVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactQuintieVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactQuintieVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactQuintieVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactQuintieVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactQuintieVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactQuintieVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactQuintieVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is TOP_IMPACT_QUINTIE_VIDEO, this field is required in ADD operation.
TopImpactQuintieVideoUrl	String	False		Destination URL. If AdType is TOP_IMPACT_QUINTIE_VIDEO, this field is required in ADD operation.
TopImpactQuintieVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).
TopImpactQuintieVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).
TopImpactQuintieVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).
TopImpactQuintieVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%)
TopImpactQuintieVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%)
TopImpactQuintieVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete)
TopImpactQuintieVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start)
TopImpactSquareAdCenterMediaId	Int64	False		Center image. If AdType is TOP_IMPACT_SQUARE, this field is required in ADD operation.
TopImpactSquareAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_SQUARE, this field is required in ADD operation.
TopImpactSquareAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_SQUARE, this field is required in ADD operation.
TopImpactSquareDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_SQUARE, this field is required in ADD operation.
topImpactSquareFinalUrl	String	False		Final URL.
topImpactSquareSmartphoneFinalUrl	String	False		Final URL (smartphone).
topImpactSquareisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
topImpactSquareisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
topImpactSquareCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
topImpactSquareCustomParameters	String	False		Displays the element of custom parameters.
TopImpactSquareUrl	String	False		Destination URL. If AdType is TOP_IMPACT_SQUARE, this field is required in ADD operation.
TopImpactSquareSpecialAdCenterMediaId	Int64	False		Center image. If AdType is TOP_IMPACT_SQUARE_SPECIAL, this field is required in ADD operation.
TopImpactSquareSpecialAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_SQUARE_SPECIAL, this field is required in ADD operation.
TopImpactSquareSpecialAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_SQUARE_SPECIAL, this field is required in ADD operation.
TopImpactSquareSpecialDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_SQUARE_SPECIAL, this field is required in ADD operation.
TopImpactSquareSpecialVideoFinalUrl	String	False		Final URL.
TopImpactSquareSpecialVideoSmartphoneFinalUrl	String	False		Final URL (smartphone).
TopImpactSquareSpecialVideoisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactSquareSpecialVideoisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactSquareSpecialVideoCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareSpecialVideoCustomParameters	String	False		Displays the element of custom parameters.
TopImpactSquareSpecialUrl	String	False		Destination URL. If AdType is TOP_IMPACT_SQUARE_SPECIAL, this field is required in ADD operation.
TopImpactSquareSpecialVideoAdCenterMediaId	Int64	False		Center image. If AdType is TOP_IMPACT_SQUARE_SPECIAL_VIDEO, this field is required in ADD operation.
TopImpactSquareSpecialVideoAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_SQUARE_SPECIAL_VIDEO, this field is required in ADD operation.
TopImpactSquareSpecialVideoAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_SQUARE_SPECIAL_VIDEO, this field is required in ADD operation.
TopImpactSquareSpecialVideoDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_SQUARE_SPECIAL_VIDEO, this field is required in ADD operation.
TopImpactSquareSpecialVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareSpecialVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareSpecialVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareSpecialVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareSpecialVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareSpecialVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareSpecialVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareSpecialVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is TOP_IMPACT_SQUARE_SPECIAL_VIDEO, this field is required in ADD operation.
TopImpactSquareSpecialVideoUrl	String	False		Destination URL. If AdType is TOP_IMPACT_SQUARE_SPECIAL_VIDEO, this field is required in ADD operation.
TopImpactSquareSpecialVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).
TopImpactSquareSpecialVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).
TopImpactSquareSpecialVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).
TopImpactSquareSpecialVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%)
TopImpactSquareSpecialVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%)
TopImpactSquareSpecialVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete)
TopImpactSquareSpecialVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start)
TopImpactSquareVideoAdCenterMediaId	Int64	False		Center image. If AdType is TOP_IMPACT_SQUARE_VIDEO, this field is required in ADD operation.
TopImpactSquareVideoAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_SQUARE_VIDEO, this field is required in ADD operation.
TopImpactSquareVideoAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_SQUARE_VIDEO, this field is required in ADD operation.
TopImpactSquareVideoDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_SQUARE_VIDEO, this field is required in ADD operation.
TopImpactSquareVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactSquareVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is TOP_IMPACT_SQUARE_VIDEO, this field is required in ADD operation.
TopImpactSquareVideoUrl	String	False		Destination URL. If AdType is TOP_IMPACT_SQUARE_VIDEO, this field is required in ADD operation.
TopImpactSquareVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).
TopImpactSquareVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).
TopImpactSquareVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).
TopImpactSquareVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%)
TopImpactSquareVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%)
TopImpactSquareVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete)
TopImpactSquareVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start)
TopImpactTheaterVideoAdCenterMediaId	Int64	False		Center image. If AdType is TOP_IMPACT_THEATER_VIDEO, this field is required in ADD operation.
TopImpactTheaterVideoAdLeftSideMediaId	Int64	False		Left side image. If AdType is TOP_IMPACT_THEATER_VIDEO, this field is required in ADD operation.
TopImpactTheaterVideoAdRightSideMediaId	Int64	False		Right side image. If AdType is TOP_IMPACT_THEATER_VIDEO, this field is required in ADD operation.
TopImpactTheaterVideoDisplayUrl	String	False		Display URL. If AdType is TOP_IMPACT_THEATER_VIDEO, this field is required in ADD operation.
TopImpactTheaterVideoFinalUrl	String	False		Final URL.
TopImpactTheaterVideoSmartphoneFinalUrl	String	False		Final URL (smartphone).
TopImpactTheaterVideoisRemoveSmartphoneFinalUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactTheaterVideoisRemoveTrackingUrl	String	False		Flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN.
TopImpactTheaterVideoCustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactTheaterVideoCustomParameters	String	False		Displays the element of custom parameters.
TopImpactTheaterVideoIsRemoveVideo10SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactTheaterVideoIsRemoveVideo25PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactTheaterVideoIsRemoveVideo3SecBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactTheaterVideoIsRemoveVideo50PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactTheaterVideoIsRemoveVideo75PercentBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactTheaterVideoIsRemoveVideoCompleteBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactTheaterVideoIsRemoveVideoStartBeaconUrls	String	False		Flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
TopImpactTheaterVideoThumbnailMediaId	Int64	False		Thumbnail ID. If AdType is TOP_IMPACT_THEATER_VIDEO, this field is required in ADD operation.
TopImpactTheaterVideoUrl	String	False		Destination URL. If AdType is TOP_IMPACT_THEATER_VIDEO, this field is required in ADD operation.
TopImpactTheaterVideoVideo10SecBeaconUrls	String	False		Viewing beacon URL (10 seconds).Available URL is only https.
TopImpactTheaterVideoVideo25PercentBeaconUrls	String	False		Playback viewing beacon URL (25%).Available URL is only https.
TopImpactTheaterVideoVideo3SecBeaconUrls	String	False		Beacon URL (3 seconds).Available URL is only https.
TopImpactTheaterVideoVideo50PercentBeaconUrls	String	False		Playback viewing beacon URL (50%).Available URL is only https.
TopImpactTheaterVideoVideo75PercentBeaconUrls	String	False		Playback viewing beacon URL (75%).Available URL is only https.
TopImpactTheaterVideoVideoCompleteBeaconUrls	String	False		Viewing Beacon URL (complete).Available URL is only https.
TopImpactTheaterVideoVideoStartBeaconUrls	String	False		Viewing Beacon URL (start).Available URL is only https.
AdId	Int64	False		Ad ID
AdName	String	False		Ad name.
AdStyle	String	False		Displays the ad style type. 使用できる値は次のとおりです。IMAGE, VIDEO, UNKNOWN
ApprovalStatus	String	False		Displays editorial status. 使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN
CampaignId	Int64	False	GuaranteedCampaigns.AccountId	Campaign ID
CampaignName	String	False		Campaign name
DisapprovalReasonCodes	String	False		Reject reason on editorial review.
DisapprovalReasonDescription	String	False		Reject reason details on editorial review.
ImpressionBeaconUrls	String	False		Impression beacon URL.
ViewableImpressionBeaconUrls	String	False		Impression beacon URL.
IsRemoveBeaconUrls	String	False		A flag for removing an information item. If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
IsRemoveImpressionBeaconUrls	String	False		A flag for removing an information item. If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
IsRemoveViewableImpressionBeaconUrls	String	False		A flag for removing an information item. If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
IsRemoveThirdPartyTrackingScriptUrl	String	False		A flag for removing an information item. If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
Labels	String	False		Describes label information to be associated.
LandingPageStatus	String	False		Describes the status of the landing page. 使用できる値は次のとおりです。COMPLETED, SPECIFIED_UPDATE_SCHEDULED_TIME, UNKNOWN
LandingPageUpdateScheduledTime	Datetime	False		The scheduled update date and time for the landing page.If landingPageStatus is SPECIFIED_UPDATE_SCHEDULED_TIME, this field is required.
MediaId	Int64	False	Media.MediaId	Media ID.
PreApprovalId	String	False		Pre-approval ID (Only number).
ThirdPartyTrackingScriptUrl	String	False		Third party tracking script URL. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
ThirdPartyTrackingVendor	String	False		Third party tracking vendor (Read only).
UserStatus	String	False		Delivery status that can be set by an user. 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
ContainsLabelIdFlg	Boolean	Flag of contains label ID.
LabelId	String	Label ID.
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.