ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

SearchAdsAdGroups

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

  • AccountId supports the '='.
  • AdGroupId supports the '=,IN'.
  • CampaignId supports the '=,IN'.
  • UserStatus supports the '='.
  • PortfolioBiddingIds supports the '='.
  • ContainsLabelId supports the '='.
  • LabelId supports the '='.
  • CreatedStartDate supports the '='.
  • CreatedEndDate supports the '='.
  • UpdatedStartDate supports the '='.
  • UpdatedEndDate supports the '='.
  • Min supports the '='.
  • Max supports the '='.
  • ReferenceNumber supports the '='.

For example:

SELECT * FROM SearchAdsAdGroups WHERE AccountId = '1234339'

SELECT * FROM SearchAdsAdGroupRetargetingLists WHERE AccountId = '1234339' AND AdGroupId IN ('303133212')	

INSERT

Insert can be executed by specifying the AccountId, AdGroupName, CampaignId, UserStatus, CustomParameters and UrlReviewDataInReviewUrlParameters 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 CustomParameters#TEMP (Key, Value) VALUES ('Test1','Test2')
INSERT INTO UrlReviewDataInReviewUrlParameters#TEMP (Key, Value) VALUES('Test3','Test4')
INSERT INTO SearchAdsAdGroups (AccountId, AdGroupName, CampaignId, UserStatus, CustomParameters, UrlReviewDataInReviewUrlParameters) VALUES(1234339, 'Test_Yogesh', '1836854', 'ACTIVE', 'CustomParameters#TEMP', 'UrlReviewDataInReviewUrlParameters#TEMP')

UPDATE

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

UPDATE SearchAdsAdGroups SET AdGroupName = 'TestSearchAdsAdGroupRetargetingLists' WHERE AccountId = '1234339' AND AdGroupId = '303133212' AND CampaignId = '1833923'

DELETE

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

DELETE FROM SearchAdsAdGroups WHERE AccountId = '1234339' AND AdGroupId = '303133212' AND CampaignId = '1833923'

Columns

Name Type ReadOnly References Description
AdGroupId [KEY] Int64 True

Ad group ID.

AccountId Int64 True

SearchAdsAccounts.AccountId

Account ID.

AdGroupName String False

Ad Group name.

AdGroupTrackId Int64 False

Ad Group ID for tracking.

CampaignId Int64 False

SearchAdsCampaigns.CampaignId

Campaign ID.

CampaignName String False

Campaign name.

CampaignTrackId Int64 False

Campaign ID for tracking.

CreatedDate Date False

Date of Ad Group made.

CustomParametersIsRemove String False

The Delete flag.

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

CustomParameters String False

Displays the element of custom parameters.

Labels String False

Describes label information to be associated.

SettingsCriterionType String False

Display the type of criteria.The default value in ADD operation for the case of no setting 'TargetingSetting' is TARGET_LIST.

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

デフォルト値はTARGET_LISTです。

SettingsTargetingSettingTargetAll String False

Describes the setting of target(include) users on Site Retargeting.

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

デフォルト値はACTIVEです。

TrackingUrl String False

Tracking URL

UrlReviewDataDisapprovalReasonCodes String False

Code of Disapproval reason.

UrlReviewDataDisapprovalReviewUrlParameters String False

Displays the element of custom parameters.

UrlReviewDataDisapprovalReviewUrlTrackingUrl String False

Tracking URL.

UrlReviewDataInReviewUrlParameters String False

Displays the element of custom parameters.

UrlReviewDataInReviewUrlTrackingUrl String False

Tracking URL.

UrlReviewDataUrlApprovalStatus String False

A review status of URL.

使用できる値は次のとおりです。REVIEW, DISAPPROVAL, NONE, APPROVED, APPROVED_WITH_REVIEW, UNKNOWN

UserStatus String False

Displays ad delivery status that can be set by an user.

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

CampaignBiddingStrategyType String False

Displays the Auto Bidding type.

CpcBiddingSchemeCpc Int64 False

Max bid of ad group (CPC).

TargetCpaBiddingSchemeTargetCpa Int64 False

Target CPA (tCPA) of ad group.

TargetCpaBiddingSchemeIsRemoveTargetCpa String False

Flag for removing an information item.

TargetRoasBiddingSchemeTargerRoas String False

Target ROAS (tROAS) of ad group.

TargetRoasBiddingSchemeIsRemoveTargerRoas String False

Flag for removing an information item.

MaximizeConversionsBiddingSchemeTargetCpa Int64 False

Target CPA (tCPA) of ad group.

MaximizeConversionsBiddingSchemeIsRemoveTargetCpa String False

Flag for removing an information item.

MaximizeConversionValueBiddingSchemeTargetRoas Double False

Target ROAS (tROAS) of ad group.

MaximizeConversionValueBiddingSchemeIsRemoveTargetRoas String False

Flag for removing an information item.

PortfolioBiddingId Int64 False

Portfolio bidding ID.

PortfolioBiddingName String False

Portfolio bidding name.

FrequentlyRunBetterPerformingAdsMode String False

It represents the preferred display setting for highly effective ads.

IsRemoveTrackingUrl String False

Flag for removing an information item.

Pseudo-Columns

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

Name Type Description
PortfolioBiddingIds Int64

Portfolio Bidding Ids.

ContainsLabelId String

Describes acquisition flag of label data.

LabelId Int64

Label Ids.

CreatedStartDate Date

This is the start date of the search target period by the creation date.

CreatedEndDate Date

This is the end date of the search target period by the creation date.

UpdatedStartDate Date

This is the start date of the search target period by the update date.

UpdatedEndDate Date

This is the end date of the search target period by the update date.

Min String

Maximum value of the search range.

Max String

Minimum value of the search range.

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 24.0.9062