ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

AdGroupCriteria

Read, add, update or delete targeting conditions (criteria) of 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 and Use 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'.
  • CriterionId supports the '=,IN'.
  • ApprovalStatus supports the '=,IN'.
  • CampaignId supports the '=,IN'.
  • KeywordMatchType supports the '='.
  • KeywordText supports the '='.
  • PortfolioBiddingId supports the '=,IN'.
  • ContainsLabelId supports the '='.
  • LabelIds supports the '=,IN'.
  • UserStatus supports the '=,IN'.
  • Use supports the '='.
  • Min supports the '='.
  • Max supports the '='.

For example, the following queries are processed server side:

SELECT * FROM AdGroupCriteria WHERE AccountId = '1234339' AND Use = 'BIDDABLE'

SELECT * FROM AdGroupCriteria WHERE AccountId = '1234339' AND Use = 'BIDDABLE' AND AdGroupId = '303252478'

INSERT

Insert can be executed by specifying the AccountId , AdGroupId, CampaignId, CriterionType, KeywordMatchType, KeywordText, Use and userStatus columns. The columns that are not read-only can be inserted optionally. For example:

INSERT INTO AdGroupCriteria (AccountId, AdGroupId, CampaignId, CriterionType, KeywordMatchType, KeywordText, Use, userStatus) VALUES ('1234339', '303252478', '1836566', 'KEYWORD', 'PHRASE', 'tests cdata', 'BIDDABLE', 'ACTIVE')

UPDATE

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

UPDATE  AdGroupCriteria SET AdGroupName = 'cdata test', Use = 'BIDDABLE', CriterionType = 'KEYWORD' WHERE AccountId = '1234339' AND AdGroupId = '303244006' AND CampaignId = '1767536' AND CriterionId = '1872965100'

DELETE

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

DELETE FROM  AdGroupCriteria  WHERE AccountId = '1234339' AND AdGroupId = '303244006' AND CampaignId = '1767536' AND CriterionId = '1872965100' AND CriterionType = 'KEYWORD' AND Use = 'BIDDABLE'

Columns

Name Type ReadOnly References Description
CriterionId [KEY] Long True

Criterion ID.

AccountId Int64 True

SearchAdsAccounts.AccountId

Account ID.

AdGroupId Int64 True

SearchAdsAdGroups.AdGroupId

Ad group ID.

AdGroupName String False

Ad group name.

AdGroupTrackId Int64 False

Ad group ID for tracking.

SmartphoneFinalUrl String False

Upgraded Custom URL (Smartphone).

Finalurl String False

Upgraded Custom URL. If upgraded and tracking Url is specified, it is required in ADD operation.

ApprovalStatus String False

Displays Editorial Status.

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

BidAdGroupCpc Int64 False

CPC of Ad group.

BidSource String False

displays which level bid belongs to criterion or ad group.

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

BidKeywordCpc Int64 False

CPC of Keyword.

BidCpc Int64 False

CPC of Keyword. The default value in ADD operation will be 1. Confirmed as no setting, if value is set 0.

CustomParametersIsRemove String False

Delete flag.

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

CustomParameters String False

Displays the element of custom parameters.

DestinationUrl String False

Custom URL of before upgrading.

DisapprovalReasonCodes String False

Code of Disapproval reason.

ReviewSmartphoneFinalUrl String False

Upgraded Custom URL (Smartphone), in review.

ReviewFinalUrl String False

Upgraded Custom URL, in review.

ReviewCustomParametersIsRemove String False

Delete flag.

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

ReviewCustomParametersParameters String False

Displays the element of custom parameters.

ReviewDestinationUrl String False

Custom URL of before upgrading, in review.

ReviewTrackingUrl String False

Tracking URL, in review.

TrackingUrl String False

Tracking URL.

UserStatus String False

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

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

CampaignId Int64 False

SearchAdsCampaigns.CampaignId

Campaign ID.

CampaignName String False

Campaign name.

CampaignTrackId Int64 False

Campaign ID for tracking.

CriterionTrackId Int64 False

AdGroupCriterionServiceCriterion ID for tracking.

CriterionType String False

AdGroupCriterionServiceCriterionType displays the type of criteria.

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

KeywordMatchType String False

Describes keyword match type.

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

KeywordText String False

AdGroupCriterionServiceKeyword element.Maximum of 80 letters, 10 words.

InvalidedTrademarks String False

Invalided trademarks.

Labels String False

Describes label information.

TrademarkStatus String False

describes the status of trademark.

使用できる値は次のとおりです。NO_RESTRICTION, CONFLICT_WITH_TRADEMARK, CLAIM_IN_PROGRESS, DISAPPROVED_CLAIM, DISAPPROVED_REVIEWER, UNKNOWN

Use String False

Describes criterion to be selected.

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

Pseudo-Columns

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

Name Type Description
PortfolioBiddingId Int64

Portfolio bidding ID.

ContainsLabelId String

Describes acquisition flag of label data.

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

LabelIds Int64

Label ID.

Min Int64

Minimum value of the search range.

Max Int64

Maximum value of the search range.

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