SearchAdsAdGroupAdAdResponsiveSearchAdDescriptions
Retrieve the details for AdGroupAd ResponsiveSearchAd Descriptions.The columns values set read-only false can be inserted in the parent table using Temp tables
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 本製品.
- AdId supports the '=,IN'.
- AccountId supports the '='.
- AdGroupId supports the '=,IN'.
- AdType supports the '=,IN'.
- ApprovalStatus supports the '=,IN'.
- CampaignId supports the '=,IN'.
- UserStatus supports the '=,IN'.
- ContainsLabel supports the '='.
- LabelId supports the '='.
- StartDate supports the '='.
- EndDate supports the '='.
For example:
SELECT * FROM SearchAdsAdGroupAdAdResponsiveSearchAdDescriptions WHERE AccountId = '25687';
SELECT * FROM SearchAdsAdGroupAdAdResponsiveSearchAdDescriptions WHERE AccountId = '25687' AND AdId IN ('456971')
SELECT * FROM SearchAdsAdGroupAdAdResponsiveSearchAdDescriptions WHERE AccountId = '25687' AND AdGroupId IN ('8520')
Columns
| Name | Type | References | Description |
| AdId | Int64 | Ad ID. | |
| AccountId | Int64 |
SearchAdsAccounts.AccountId | Account ID. |
| AdGroupId | Int64 |
SearchAdsAdGroups.AdGroupId | Ad group ID. |
| AdType | String | Device type and number of title and description character.
使用できる値は次のとおりです。EXTENDED_TEXT_AD, DYNAMIC_SEARCH_LINKED_AD, TEXT_AD2, APP_AD, RESPONSIVE_SEARCH_AD, UNKNOWN | |
| ApprovalStatus | String | Displays Editorial Status.
使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVAL, POST_DISAPPROVAL, UNKNOWN | |
| DisapprovalReasonCodes | String | Reject reason code. | |
| PinnedField | String | A field that specifies where to fix the display position of the description.
使用できる値は次のとおりです。SPECIFIED, DESCRIPTION1, DESCRIPTION2, UNKNOWN | |
| Text | String | Text of parameter. | |
| ActiveStatus | String | Displays the availability of assets appears.
使用できる値は次のとおりです。ACTIVE, DEACTIVE, PENDING_REVIEW, PENDING_DELETE, UNKNOWN |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ContainsLabel | String | Describes acquisition flag of label data.
使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
| LabelIds | Int64 | Label Ids. | |
| StartDate | Date | This is the start date of the search target period. | |
| EndDate | Date | This is the end date of the search target period. | |
| ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |