GuaranteedAdGroupAds
Create, Read, Update guaranteed ad and use AdGroupAd/remove to delete the guaranteed ad.
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 '='.
- 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'
Columns
| Name | Type | References | Description |
| AccountId | Integer |
DisplayAdsAccounts.AccountId | Account ID. |
| AdGroupId | Integer |
GuaranteedAdGroups.AdGroupId | Ad group ID. |
| AdGroupName | String | Ad group name. | |
| AdId | Integer | Ad ID. | |
| AdName | String | Ad name. | |
| AdType | String | Describes the type of ad. | |
| BannerAdCustomParametersIsRemove | String | Flag for removing an information item. | |
| BannerAdCustomParametersParameters | String | Displays the element of custom parameters. | |
| BannerAdDisplayUrl | String | Display URL. | |
| BannerAdDisplayUrlLevel | String | Describes a level of URL to display. | |
| BannerAdFinalUrl | String | Final URL. | |
| BannerAdSmartphoneFinalUrl | String | Final URL (smartphone). | |
| BannerAdThumbnailMediaId | Integer | Thumbnail ID. | |
| BannerAdTrackingUrl | String | Tracking URL. | |
| BannerAdVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| BannerAdVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| BannerAdVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| BannerAdVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| BannerAdVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| BannerAdVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| BannerAdVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| BrandPanelPanoramaAdShrinkMainMediaId | Integer | Reduced main image. | |
| BrandPanelPanoramaCustomParametersIsRemove | String | Flag for removing an information item. | |
| BrandPanelPanoramaCustomParametersParameters | String | Displays the element of custom parameters. | |
| BrandPanelPanoramaDisplayUrl | String | Display URL. | |
| BrandPanelPanoramaDisplayUrlLevel | String | Describes a level of URL to display. | |
| BrandPanelPanoramaFinalUrl | String | Final URL. | |
| BrandPanelPanoramaThumbnailMediaId | Integer | Thumbnail ID. | |
| BrandPanelPanoramaTrackingUrl | String | Tracking URL. | |
| BrandPanelPanoramaVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| BrandPanelPanoramaVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| BrandPanelPanoramaVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| BrandPanelPanoramaVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| BrandPanelPanoramaVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| BrandPanelPanoramaVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| BrandPanelPanoramaVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| BrandPanelPanoramaPanelSwitchAdShrinkMainMediaId | Integer | Reduced main image. | |
| BrandPanelPanoramaPanelSwitchCustomParametersIsRemove | String | Flag for removing an information item. | |
| BrandPanelPanoramaPanelSwitchCustomParametersParameters | String | Displays the element of custom parameters. | |
| BrandPanelPanoramaPanelSwitchDisplayUrlLevel | String | Describes a level of URL to display. | |
| BrandPanelPanoramaPanelSwitchFinalUrl | String | Final URL. | |
| BrandPanelPanoramaPanelSwitchPanels | String | Describes detailed information of Brand Panel Panorama Panel-switch ad. | |
| BrandPanelPanoramaPanelSwitchTrackingUrl | String | Tracking URL. | |
| BrandPanelQuintieCustomParametersIsRemove | String | Flag for removing an information item. | |
| BrandPanelQuintieCustomParametersParameters | String | Displays the element of custom parameters. | |
| BrandPanelQuintieDisplayUrl | String | Display URL. | |
| BrandPanelQuintieDisplayUrlLevel | String | Describes a level of URL to display. | |
| BrandPanelQuintieFinalUrl | String | Final URL. | |
| BrandPanelQuintieThumbnailMediaId | Integer | Thumbnail ID. | |
| BrandPanelQuintieTrackingUrl | String | Tracking URL. | |
| BrandPanelQuintieVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| BrandPanelQuintieVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| BrandPanelQuintieVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| BrandPanelQuintieVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| BrandPanelQuintieVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| BrandPanelQuintieVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| BrandPanelQuintieVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| CarouselAdCarousels | String | Describes the detailed information of carousel ad. | |
| CarouselAdCustomParametersIsRemove | String | Flag for removing an information item. | |
| CarouselAdCustomParametersParameters | String | Displays the element of custom parameters. | |
| CarouselAdDisplayUrl | String | Display URL. | |
| CarouselAdDisplayUrlLevel | String | Describes a level of URL to display. | |
| CarouselAdFinalUrl | String | Final URL. | |
| CarouselAdLogoMediaId | Integer | Logo image ID. | |
| CarouselAdPrincipal | String | Advertiser Indication of the ad. | |
| CarouselAdSmartphoneFinalUrl | String | Final URL (smartphone). | |
| CarouselAdTrackingUrl | String | Tracking URL. | |
| InstreamAdActionAfterAdClicks | Boolean | Behavior when clicked on the ad. If true, it will transition to the final URL. | |
| InstreamAdCustomParametersIsRemove | String | Flag for removing an information item. | |
| InstreamAdCustomParametersParameters | String | Displays the element of custom parameters. | |
| InstreamAdDisplayUrl | String | Display URL. | |
| InstreamAdDisplayUrlLevel | String | Describes a level of URL to display. | |
| InstreamAdFinalUrl | String | Final URL. | |
| InstreamAdHeadline | String | Headline. | |
| InstreamAdSmartphoneFinalUrl | String | Final URL (smartphone). | |
| InstreamAdTrackingUrl | String | Tracking URL. | |
| InstreamAdVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| InstreamAdVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| InstreamAdVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| InstreamAdVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| InstreamAdVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| MainMediaFormat | String | Displays the main media format. | |
| TopImpactPanoramaAdLeftSideMediaId | Integer | Left side image. | |
| TopImpactPanoramaAdRightSideMediaId | Integer | Right side image. | |
| TopImpactPanoramaAdShrinkMainMediaId | Integer | Reduced main image. | |
| TopImpactPanoramaCustomParametersIsRemove | String | Flag for removing an information item. | |
| TopImpactPanoramaCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopImpactPanoramaDisplayUrl | String | Display URL. | |
| TopImpactPanoramaDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopImpactPanoramaFinalUrl | String | Final URL. | |
| TopImpactPanoramaThumbnailMediaId | Integer | Thumbnail ID. | |
| TopImpactPanoramaTrackingUrl | String | Tracking URL. | |
| TopImpactPanoramaVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| TopImpactPanoramaVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| TopImpactPanoramaVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| TopImpactPanoramaVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| TopImpactPanoramaVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| TopImpactPanoramaVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| TopImpactPanoramaVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| TopImpactPanoramaPanelSwitchAdShrinkMainMediaId | Integer | Reduced main image. | |
| TopImpactPanoramaPanelSwitchCustomParametersIsRemove | String | Flag for removing an information item. | |
| TopImpactPanoramaPanelSwitchCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopImpactPanoramaPanelSwitchDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopImpactPanoramaPanelSwitchFinalUrl | String | Final URL. | |
| TopImpactPanoramaPanelSwitchPanels | String | Describes detailed information of Top Impact Panorama Panel-switch ad. | |
| TopImpactPanoramaPanelSwitchTrackingUrl | String | Tracking URL. | |
| TopImpactPanoramaSideSwitchAdLeftSideMediaId | Integer | Left side image. | |
| TopImpactPanoramaSideSwitchAdLeftSideMediaId2 | Integer | Left side image. | |
| TopImpactPanoramaSideSwitchAdRightSideMediaId | Integer | Right side image. | |
| TopImpactPanoramaSideSwitchAdRightSideMediaId2 | Integer | Right side image. | |
| TopImpactPanoramaSideSwitchAdShrinkMainMediaId | Integer | Reduced main image. | |
| TopImpactPanoramaSideSwitchCustomParametersIsRemove | String | Flag for removing an information item. | |
| TopImpactPanoramaSideSwitchCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopImpactPanoramaSideSwitchDisplayUrl | String | Display URL. | |
| TopImpactPanoramaSideSwitchDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopImpactPanoramaSideSwitchFinalUrl | String | Final URL. | |
| TopImpactPanoramaSideSwitchThumbnailMediaId | Integer | Thumbnail ID. | |
| TopImpactPanoramaSideSwitchTrackingUrl | String | Tracking URL. | |
| TopImpactPanoramaSideSwitchVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| TopImpactPanoramaSideSwitchVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| TopImpactPanoramaSideSwitchVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| TopImpactPanoramaSideSwitchVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| TopImpactPanoramaSideSwitchVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| TopImpactPanoramaSideSwitchVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| TopImpactPanoramaSideSwitchVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| TopImpactPanoramaSideVisionAdShrinkMainMediaId | Integer | Reduced main image. | |
| TopImpactPanoramaSideVisionCustomParametersIsRemove | String | Flag for removing an information item. | |
| TopImpactPanoramaSideVisionCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopImpactPanoramaSideVisionDisplayUrl | String | Display URL. | |
| TopImpactPanoramaSideVisionDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopImpactPanoramaSideVisionFinalUrl | String | Final URL. | |
| TopImpactPanoramaSideVisionThumbnailMediaId | Integer | Thumbnail ID. | |
| TopImpactPanoramaSideVisionTrackingUrl | String | Tracking URL. | |
| TopImpactPanoramaSideVisionVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| TopImpactPanoramaSideVisionVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| TopImpactPanoramaSideVisionVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| TopImpactPanoramaSideVisionVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| TopImpactPanoramaSideVisionVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| TopImpactPanoramaSideVisionVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| TopImpactPrimeDisplayDoubleAdLeftSideMediaId | Integer | Left side image. | |
| TopImpactPrimeDisplayDoubleAdRightSideMediaId | Integer | Right side image. | |
| TopImpactPrimeDisplayDoubleCustomParametersIsRemove | String | Flag for removing an information item. | |
| TopImpactPrimeDisplayDoubleCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopImpactPrimeDisplayDoubleDisplayUrl | String | Display URL. | |
| TopImpactPrimeDisplayDoubleDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopImpactPrimeDisplayDoubleFinalUrl | String | Final URL. | |
| TopImpactPrimeDisplayDoubleThumbnailMediaId | Integer | Thumbnail ID. | |
| TopImpactPrimeDisplayDoubleTrackingUrl | String | Tracking URL. | |
| TopImpactPrimeDisplayDoubleVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| TopImpactPrimeDisplayDoubleVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| TopImpactPrimeDisplayDoubleVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| TopImpactPrimeDisplayDoubleVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| TopImpactPrimeDisplayDoubleVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| TopImpactPrimeDisplayDoubleVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| TopImpactPrimeDisplayDoubleVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| TopImpactQuintieAdCenterMediaId | Integer | Center image. | |
| TopImpactQuintieAdLeftSideMediaId | Integer | Left side image. | |
| TopImpactQuintieAdRightSideMediaId | Integer | Right side image. | |
| TopImpactQuintieCustomParametersIsRemove | String | Flag for removing an information item. | |
| TopImpactQuintieCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopImpactQuintieDisplayUrl | String | Display URL. | |
| TopImpactQuintieDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopImpactQuintieFinalUrl | String | Final URL. | |
| TopImpactQuintieThumbnailMediaId | Integer | Thumbnail ID. | |
| TopImpactQuintieTrackingUrl | String | Tracking URL. | |
| TopImpactQuintieVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| TopImpactQuintieVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| TopImpactQuintieVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| TopImpactQuintieVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| TopImpactQuintieVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| TopImpactQuintieVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| TopImpactQuintieVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| TopImpactSquareAdCenterMediaId | Integer | Center image. | |
| TopImpactSquareAdLeftSideMediaId | Integer | Left side image. | |
| TopImpactSquareAdRightSideMediaId | Integer | Right side image. | |
| TopImpactSquareCustomParametersIsRemove | String | Flag for removing an information item. | |
| TopImpactSquareCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopImpactSquareDisplayUrl | String | Display URL. | |
| TopImpactSquareDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopImpactSquareFinalUrl | String | Final URL. | |
| TopImpactSquareThumbnailMediaId | Integer | Thumbnail ID. | |
| TopImpactSquareTrackingUrl | String | Tracking URL. | |
| TopImpactSquareVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| TopImpactSquareVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| TopImpactSquareVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| TopImpactSquareVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| TopImpactSquareVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| TopImpactSquareVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| TopImpactSquareVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| TopImpactTheaterAdCenterMediaId | Integer | Center image. | |
| TopImpactTheaterAdLeftSideMediaId | Integer | Left side image. | |
| TopImpactTheaterAdRightSideMediaId | Integer | Right side image. | |
| TopImpactTheaterCustomParametersIsRemove | String | Flag for removing an information item. | |
| TopImpactTheaterCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopImpactTheaterDisplayUrl | String | Display URL. | |
| TopImpactTheaterDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopImpactTheaterFinalUrl | String | Final URL. | |
| TopImpactTheaterThumbnailMediaId | Integer | Thumbnail ID. | |
| TopImpactTheaterTrackingUrl | String | Tracking URL. | |
| TopImpactTheaterVideo10SecBeaconUrls | String | Viewing beacon URL (10 seconds). | |
| TopImpactTheaterVideo25PercentBeaconUrls | String | Playback viewing beacon URL (25%). | |
| TopImpactTheaterVideo3SecBeaconUrls | String | Viewing beacon URL (3 seconds). | |
| TopImpactTheaterVideo50PercentBeaconUrls | String | Playback viewing beacon URL (50%). | |
| TopImpactTheaterVideo75PercentBeaconUrls | String | Playback viewing beacon URL (75%). | |
| TopImpactTheaterVideoCompleteBeaconUrls | String | Viewing beacon URL (complete). | |
| TopImpactTheaterVideoScreenshot | String | Video start position for video screenshot that appears on both sides of homepage. | |
| TopImpactTheaterVideoStartBeaconUrls | String | Viewing beacon URL (start). | |
| ApprovalStatus | String | Displays editorial status. | |
| CampaignId | Integer | Campaign ID. | |
| CampaignName | String | Campaign name. | |
| DisapprovalReasonCodes | String | Reject reason on editorial review. | |
| DisapprovalReasonDescription | String | Reject reason details on editorial review. | |
| ImpressionBeaconUrls | String | Impression beacon URL. | |
| Labels | String | Describes label information to be associated. | |
| LandingPageStatus | String | Describes the status of the landing page. | |
| LandingPageUpdateScheduledTime | String | The scheduled update date and time for the landing page. | |
| MediaId | Integer | Media ID. | |
| PreApprovalId | String | Pre-approval ID (Only number). | |
| ThirdPartyTrackingScriptUrl | String | Third party tracking script URL. | |
| ThirdPartyTrackingVendor | String | Third party tracking vendor (Read only). | |
| UserStatus | String | Describes delivery settings. | |
| ViewableImpressionBeaconUrls | String | Viewable impression beacon URL. | |
| TopPageTopicsPRCustomParametersIsRemove | String | A flag for removing an information item. | |
| TopPageTopicsPRCustomParametersParameters | String | Displays the element of custom parameters. | |
| TopPageTopicsPRDisplayUrl | String | Display URL. | |
| TopPageTopicsPRDisplayUrlLevel | String | Describes a level of URL to display. | |
| TopPageTopicsPRFinalUrl | String | Final URL. | |
| TopPageTopicsPRHeadline | String | Headline. | |
| TopPageTopicsPRPrincipal | String | Advertiser Indication of the ad. | |
| TopPageTopicsPRSmartPhoneFinalUrl | String | Final URL (smartphone). | |
| TopPageTopicsPRTrackingUrl | String | Tracking URL. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| AdGroupAdId | Boolean | Ad ID. | |
| ContainsLabelIdFlg | Boolean | Flag of contains label ID. | |
| LabelId | String | Label ID. |