DisplayAdsAdGroups

Create, Read, Update or Delete Ad group

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 The rest of the filter is executed client side within the 本製品.

AdGroupId supports the '=,IN'.
AccountId supports the '='.
CampaignId supports the '=,IN'.
UserStatus supports the '=,IN'.
CampaignGoalFilterType supports the '='.
ContainsLabel supports the '='.
LabelId supports the '=,IN'.
StartDate supports the '='.
EndDate supports the '='.

For example:

SELECT * FROM DisplayAdsAdGroups WHERE AccountId = '1002504155'

SELECT * FROM DisplayAdsAdGroups WHERE AccountId = '1002504155' AND AdGroupId = '437264177'

INSERT

Insert can be executed by specifying the AccountId, AdGroupId, AdType, Name, CampaignId, UserStatus columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table

INSERT INTO DisplayAdsAdGroups (AdGroupName, AccountId, CampaignId,device,UserStatus,DeviceApp,DeviceOs) values('Testgroup','1002504155','30799754','SMARTPHONE','ACTIVE','APP','ANDROID');

UPDATE

Update can be executed by specifying the AccountId, AdGroupId AND CampaignId,AdId,UserStatus in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE DisplayAdsAdGroups SET AdGroupName = 'NewTest' WHERE AccountId = '1002504155' AND CampaignId = '30799754' AND AdGroupId = '437264190' AND UserStatus = 'ACTIVE'

DELETE

Delete can be executed by specifying the AccountId, AdGroupId, CampaignId, AdId and UserStatus in the WHERE Clause. For example:

DELETE FROM DisplayAdsAdGroups WHERE AccountId = '1002504155' AND CampaignId = '30799754' AND AdGroupId = '437264190' AND UserStatus = 'ACTIVE'

Columns


Name	Type	ReadOnly	References	Description
AdGroupId [KEY]	Int64	True		Ad group ID.
AdGroupName	String	False		Ad group name.
AccountId	Int64	True	DisplayAdsAccounts.AccountId	Account ID.
CampaignBiddingStrategyType	String	False		Campaign bid strategy type. 使用できる値は次のとおりです。MAXIMIZE_CONVERSIONS, MAXIMIZE_CLICKS, MAXIMIZE_VIDEO_VIEWS, MAXIMIZE_VIEWABLE_IMPRESSIONS, VCPM, CPC, CPV, UNKNOWN
CpcBiddingSchemeCpc	Int64	False		Max bid of ad group(CPC).
CpcBiddingSchemeEnhancedCpcEnabled	String	False		Specifies flag of Maximize Conversions. If this field is TRUE, the bidding strategy on audit log is eCPC. If cpc or isRemoveCpc is specified, this field is required.
CpcBiddingSchemeIsRemoveCpc	Int64	False		It is a flag for removing an information item.
CpvBiddingSchemeCpv	Int64	False		Max bid of ad group (CPV).
CpvBiddingSchemeIsRemoveCpv	Int64	False		It is a flag for removing an information item.
VcpmBiddingSchemeVcpm	Int64	False		Max bid of ad group (vCPM).
VcpmBiddingSchemeIsRemoveVcpm	Int64	False		It is a flag for removing an information item.
MaximizeConversionsBiddingSchemeTargetCpa	Int64	False		Target CPA (tCPA) of ad group.
MaximizeConversionsBiddingSchemeIsRemoveTargetCpa	Int64	False		It is a flag for removing an information item.
CampaignId	Int64	False	DisplayAdsCampaigns.CampaignId	Campaign ID.
CampaignName	String	False		Campaign name.
CreatedDate	Date	True		Date of Ad Group made.
Device	String	False		Types of devices to be posted on .Setting NONE is only available for AdGroupService. The allowed values are DESKTOP,WAP_MOBILE,SMARTPHONE,TABLET,NONE,UNKNOWN
DeviceApp	String	False		Application types for devices.Setting NONE is only available for AdGroupService. The allowed values are APP,WEB,NONE,UNKNOWN
DeviceOs	String	False		OS types for devices to be posted on.Setting NONE is only available for AdGroupService. The allowed values are IOS,ANDROID,NONE,UNKNOWN
DeviceOsVersion	String	False		OS version.To cancel the setting, specify NONE.
FeedSetId	Int64	False	FeedSets.FeedSetId	Feed set ID.If feedSetId is not specified in ADD operation, the default set is associated automatically
Labels	String	False		Label information to be associated.
UserStatus	String	False		Ad delivery status that can be set by an user.This field is required in ADD operation 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN
CustomParametersIsRemove	String	False		Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
CustomParameters	String	False		Displays the element of custom parameters.

Pseudo-Columns

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


Name	Type	Description
CampaignGoalFilterType	String	Setting for filtering campaigns (with campaignGoal) or (with no campaignGoal). 使用できる値は次のとおりです。ALL, NON_GOAL, UNKNOWN デフォルト値はALLです。
ContainsLabel	Boolean	Flag of contains label ID.
LabelId	String	Label ID.
StartDate	Date	This is the start date of the search target period.
EndDate	Date	This is the end date of the search target period.
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.

Power BI Connector for Yahoo! Ads