AdGroupAdResponsiveAdAssetMediaAssets
Represents a media 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'.
- CampaignGoalFilterType supports the '='.
- ContainsLabel supports the '='.
- StartDate supports the '='.
- EndDate supports the '='.
SELECT * FROM AdGroupAdResponsiveAdAssetMediaAssets WHERE AccountId = '125466'
SELECT * FROM AdGroupAdResponsiveAdAssetMediaAssets 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 |
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. |