ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

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'

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062