GuaranteedPreview
Read the preview of guaranteed campaign.
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, MaterialType, AdId and AdType is required to make a request and rest of the filter is executed client side within the 本製品.
- AccountId supports the '='.
- AdId supports the '='.
- AdLeftSideMediaId supports the '='.
- AdRightSideMediaId supports the '='.
- AdType supports the '='.
- MediaId supports the '='.
- ThumbnailMediaId supports the '='.
- MaterialType supports the '='.
For example:
Select * from GuaranteedPreview WHERE AccountId = '1002504155' AND MaterialType = 'AD' AND AdId = '437760638' AND MediaId = '9307679' AND AdType = 'BRANDPANEL_QUINTIE'
Columns
| Name | Type | References | Description |
| AccountId [KEY] | Int64 |
DisplayAdsAccounts.AccountId | Account ID. |
| AdId | Int64 | Ad ID. | |
| AdCenterMediaId | Int64 | Center image. | |
| AdLeftSideMediaId | Int64 | Left side image. | |
| AdRightSideMediaId | Int64 | Right side image. | |
| AdShrinkMainMediaId | Int64 | Reduced main image. | |
| AdType | String | Describes the type of 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_THEATER_SPECIAL, TOP_IMPACT_THEATER_SPECIAL_VIDEO, TOP_IMPACT_PRIME_DISPLAY_DOUBLE, TOP_IMPACT_PRIME_DISPLAY_DOUBLE_VIDEO, INSTREAM_VIDEO_AD, UNKNOWN | |
| MediaId | Int64 | Media ID. | |
| ThumbnailMediaId | Int64 | Thumbnail ID. | |
| MaterialType | String | Describes the type of the preview material.
使用できる値は次のとおりです。AD, MEDIA, UNKNOWN | |
| PreviewUrl | String | Preview URL. | |
| VideoScreenshot | String | Video start position for video screenshot that appears on both sides of homepage. | |
| Panels | String | It holds information about the preview material (switch image). |