GuaranteedPreviewPanels
It holds information about the preview material.
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 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 GuaranteedPreviewPanels 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. |
| PanelsMediaId | Int64 | Media ID. | |
| SwitchMediaId | Int64 | Media ID of switch image. | |
| MaterialType | String | Describes the type of the preview material.
使用できる値は次のとおりです。AD, MEDIA, UNKNOWN | |
| AdLeftSideMediaId | String | Left side image. | |
| AdRightSideMediaId | String | Right side image. | |
| MediaId | Int64 | Media ID. | |
| AdId | Int64 | Ad ID. | |
| 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 |