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