DisplayAdsAdGroupAdCarouselAdCarousels
Retrieve the information of carousel ad.
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 The rest of the filter is executed client side within the connector.
- AdGroupId supports the '=,IN'.
- AccountId supports the '='.
- CampaignId supports the '=,IN'.
- UserStatus supports the '=,IN'.
- CampaignGoalFilterType supports the '='.
- ContainsLabel supports the '='.
- LabelId supports the '=,IN'.
- StartDate supports the '='.
- EndDate supports the '='.
SELECT * FROM DisplayAdsAdGroupAdCarouselAdCarousels WHERE AccountId = '1002504155' SELECT * FROM DisplayAdsAdGroupAdCarouselAdCarousels WHERE AccountId = '1002504155' AND AdGroupId = '437264177'
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 |
UserStatus | String | Delivery status that can be set by an user
使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN | |
Description | String | Ad description.This field is required in SET operation, | |
DisapprovalReasonCodes | String | Reject reason on editorial review. | |
DisplayOrder | Int64 | Carousel display order.If not specified, it will be set automatically. | |
Headline | String | Ad title.This field is requred in ADD and SET operation. | |
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 | Boolean | Flag of contains label ID. | |
LabelId | String | Label ID. | |
StartDate | Date | start date of the search target period.Format: yyyy-MM-dd. | |
EndDate | Date | This is the end date of the search target period.Format: yyyy-MM-dd. |