AdGroupCriteria

Read, add, update or delete targeting conditions (criteria) of Ad group.

Table Specific Information

Select

The connector 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 connector.

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.

Tableau Connector for Yahoo! Ads