SearchAdsAdGroupAds
Create, Read, Update and Delete Ad group information.
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,='.
- AdId supports the 'IN,='.
- AdType supports the 'IN,='.
- ApprovalStatus supports the 'IN,='.
- CampaignId supports the 'IN,='.
- ContainsLabel supports the '='.
- Userstatus supports the 'IN,='.
- LabelIds supports the 'IN,='.
- CreatedStartDate supports the '='.
- CreatedEndDate supports the '='.
- UpdatedStartDate supports the '='.
- UpdatedEndDate supports the '='.
For example:
SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND AdGroupId = '456971' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND AdId = '87952' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND AdType='EXTENDED_TEXT_AD' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND CampaignId = '0147' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND ContainsLabel = '89456' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND Userstatus = 'PAUSED' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND CreatedStartDate = '2021-02-15' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND CreatedEndDate = '2021-06-03' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND UpdatedStartDate = '2021-02-15' SELECT * FROM SearchAdsAdGroupAds WHERE AccountId = '25687' AND UpdatedEndDate = '2021-06-03'
INSERT
Insert can be executed by specifying the UserStatus,AccountId, AdGroupId and AdId columns. The columns that are not read-only can be inserted optionally.
INSERT INTO SearchAdsAdGroupAds (UserStatus,AccountId,AdGroupId,AdId) VALUES ('PAUSED','78955','78945','96272')
UPDATE
Update can be executed by specifying the AccountId, AdGroupId and AdId in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE SearchAdsAdGroupAds SET UserStatus = 'PAUSED' WHERE AccountId = '78955' AND AdGroupId= '78945' AND AdId ='96272'
DELETE
Delete can be executed by specifying the AccountId,AdGroupId and AdId in the WHERE Clause.
For example:
DELETE FROM SearchAdsAdGroupAds WHERE AccountId = '78955' AND AdGroupId = '78945' AND AdId = '96272'
Columns
Name | Type | ReadOnly | References | Description |
AdId [KEY] | Int64 | True |
Ad 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. | |
AdName | String | False |
Ad name. | |
AdTrackId | Int64 | False |
Ad ID for tracking. | |
AdType | String | False |
Device type and number of title and description character. 使用できる値は次のとおりです。EXTENDED_TEXT_AD, DYNAMIC_SEARCH_LINKED_AD, TEXT_AD2, APP_AD, RESPONSIVE_SEARCH_AD, UNKNOWN | |
SmartphoneFinalUrl | String | False |
Landing Page URL (Smartphone). | |
FinalUrl | String | False |
Landing Page URL. | |
AppAdAppId | String | False |
App ID. If adType is APP_AD, this field is required. | |
AppAdAppStore | String | False |
App Store. If adType is APP_AD, this field is required. 使用できる値は次のとおりです。IOS, ANDROID, UNKNOWN | |
AppAdDescription2 | String | False |
Description2 (line2) of the ad.If adType is APP_AD, this field is required. | |
CustomParametersIsRemove | String | False |
Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
CustomParametersParameters | String | False |
displays the element of custom parameters. | |
DevicePreference | String | False |
A device delivering an advertisement with precedence. If adType is EXTENDED_TEXT_AD, this field will be ignored. | |
DisplayUrl | String | False |
Display URL. | |
ExtendedTextAdDescription2 | String | False |
Description on the second line. If adType is EXTENDED_TEXT_AD, this field is required. | |
ExtendedTextAdHeadline2 | String | False |
Title on the second line. If adType is EXTENDED_TEXT_AD, this field is required. | |
ExtendedTextAdHeadline3 | String | False |
Title on the second line. If adType is EXTENDED_TEXT_AD, this field is required. | |
ExtendedTextAdPath1 | String | False |
The path information which complements display URL generated automatically. To specify path2, path1 is required. f adType is EXTENDED_TEXT_AD, this field is required. | |
ExtendedTextAdPath2 | String | False |
The path information which complements display URL generated automatically. If path1 is not specified, path2 will be ignored. f adType is EXTENDED_TEXT_AD, this field is required. | |
ResponsiveSearchAdDescriptions | String | False |
Displays the text asset for the description that specify in responsive ad. If adType is RESPONSIVE_SEARCH_AD, this field is required. | |
ResponsiveSearchAdHeadlines | String | False |
Displays the text asset for the headline that specify in responsive ad. If adType is RESPONSIVE_SEARCH_AD, this field is required. | |
ResponsiveSearchAdPath1 | String | False |
The path information which complements display URL generated automatically. To specify path2, path1 is required. If adType is RESPONSIVE_SEARCH_AD, this field is required. | |
ResponsiveSearchAdPath2 | String | False |
The path information which complements display URL generated automatically. If path1 is not specified, path2 will be ignored. If adType is RESPONSIVE_SEARCH_AD, this field is required. | |
TextAd2Description2 | String | False |
Description2 (line2) of the ad. | |
TrackingUrl | String | False |
Tracking URL. | |
Url | String | False |
Destination URL before upgrading. | |
ApprovalStatus | String | False |
Displays Editorial Status. 使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVAL, POST_DISAPPROVAL, UNKNOWN | |
CampaignId | Int64 | False |
SearchAdsCampaigns.CampaignId |
Campaign ID. |
CampaignName | String | False |
Campaign name. | |
CampaignTrackId | Int64 | False |
Campaign ID for tracking. | |
CreatedDate | Date | True |
Date of Ad made | |
DisapprovalReasonCodes | String | False |
Code of Disapproval reason. | |
FeedId | Int64 | False |
Feed ID. | |
InvalidedTrademarks | String | False |
Invalided trademarks. | |
Labels | String | False |
Describes label information to be associated. | |
TrademarkStatus | String | False |
Describes the status of trademark. 使用できる値は次のとおりです。NO_RESTRICTION, CONFLICT_WITH_TRADEMARK, CLAIM_IN_PROGRESS, DISAPPROVAL_CLAIM, DISAPPROVAL_REVIEWER, UNKNOWN | |
UserStatus | String | False |
Displays ad delivery status that can be set by an user. 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN | |
TextAd2Headline | String | False |
Title of the ad. | |
TextAd2Description | String | False |
Description of the ad. | |
AppAdHeadline | String | False |
Title of the ad. | |
AppAdDescription | String | False |
Description of the ad. | |
ExtendedTextAdHeadline | String | False |
Title of the Ad. | |
ExtendedTextAdDescription | String | False |
Description of the Ad. | |
DynamicSearchLinkedAdDescription | String | False |
Description of the Ad. | |
DynamicSearchLinkedAdDescription2 | String | False |
Description2 of the ad. | |
ResponsiveSearchAdReviewDescriptions | String | False |
Displays the text asset for the description under review. | |
ResponsiveSearchAdReviewHeadlines | String | False |
Displays the text asset for the headline under review. | |
ResponsiveSearchAdIsRemovePath1 | String | False |
It is a flag for removing an information item. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
ResponsiveSearchAdIsRemovePath2 | String | False |
It is a flag for removing an information item (for path2). 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
ResponsiveSearchAdReviewPath1 | String | False |
The path information which complements display URL generated automatically (Under review). | |
ResponsiveSearchAdReviewPath2 | String | False |
The path information which complements display URL generated automatically (Under review). | |
ReviewFinalUrl | String | False |
Landing Page URL on editorial review. | |
ReviewSmartphoneFinalUrl | String | False |
Landing Page URL (Smartphone) on editorial review. | |
IsRemoveSmartphoneFinalUrl | String | False |
It is a flag for removing an information item. | |
ReviewTrackingUrl | String | False |
Tracking URL on editorial review. | |
IsReviewTrackingUrl | String | False |
It is a flag for removing an information item. | |
ReviewCustomParametersIsRemove | String | False |
Delete flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
ReviewCustomParametersParameters | String | False |
Displays the element of custom parameters. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
ContainsLabel | Boolean |
Describes acquisition flag of label data. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN |
LabelIds | 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. |
ReferenceNumber | String |
This column will be used in Bulk operations to get specific values from the Temp tables. |