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