ADO.NET Provider for Yahoo! Ads

Build 23.0.8839


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

Table Specific Information


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

For example, the following queries are processed server side:

SELECT * FROM GuaranteedAdGroups WHERE AccountId = '123436'


Name Type References Description
AdGroupId [KEY] Int64 Ad Group ID.
AccountId Int64


Account ID.
AdGroupName String Ad group name.
AdGroupTargets String Contains targeting information specified in ad group.
CampaignId Int64


Campaign ID.
CampaignName String Campaign name.
Device String Displays types of devices to be posted on. The allowed values are DESKTOP,SMARTPHONE,TABLET,NONE,UNKNOWN
DeviceApp String Serves application types for devices. The allowed values are APP,WEB,NONE,UNKNOWN
DeviceOs String Serves OS types for devices to be posted on. The allowed values are IOS,ANDROID,NONE,UNKNOWN
IsCreativeProfile Boolean If the value of this field is true, it indicates that the ad group was added using a creative profile.
Labels String Object describes label information to be associated.
UserStatus String Serves ad delivery status that can be set by an user.

使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN


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

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

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