AdGroupAdResponsiveAdAssetDescriptionAssets
Represents a description asset to specify in responsive display ads.
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'.
- AdId supports the '=,IN'.
- ApprovalStatus supports the '=,IN'.
- CampaignId supports the '=,IN'.
- MediaId supports the '=,IN'.
- UserStatus supports the '=,IN'.
- CampaignGoalFilterType supports the '='.
- ContainsLabel supports the '='.
- StartDate supports the '='.
- EndDate supports the '='.
SELECT * FROM AdGroupAdResponsiveAdAssetDescriptionAssets WHERE AccountId = '125466'
SELECT * FROM AdGroupAdResponsiveAdAssetDescriptionAssets WHERE AccountId = '123436' AND AdId IN ('4561', '6996')
Columns
| Name | Type | References | Description |
| AdId | Int64 | Ad ID | |
| AccountId | Int64 |
DisplayAdsAccounts.AccountId | Account ID |
| AdGroupId | Int64 |
DisplayAdsAdGroups.AdGroupId | Ad group ID |
| ApprovalStatus | String | Editorial status
使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN | |
| CampaignId | Int64 |
DisplayAdsCampaigns.CampaignId | Campaign ID |
| MediaId | Int64 |
Media.MediaId | Media ID |
| UserStatus | String | Delivery status that can be set by an user
使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN | |
| Text | String | Description text.. | |
| DisapprovalReasonCodes | String | Reject reason on editorial review. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| CampaignGoalFilterType | String | Setting for filtering campaigns (with campaignGoal) or (with no campaignGoal).
使用できる値は次のとおりです。ALL, NON_GOAL, UNKNOWN デフォルト値はALLです。 | |
| ContainsLabel | String | Flag of contains label ID. | |
| StartDate | Date | start date of the search target period. | |
| EndDate | Date | This is the end date of the search target period. |