SearchAdsAdGroups

Create, Read, Update or Delete 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 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'.
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.

Tableau Connector for Yahoo! Ads