RecommendationUpdateAdCreativeUpdateAdCreativeList
Retrieve the detailed information of ads that have recommendations for updating images or videos.
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 and Type is required to make a request and the rest of the filter is executed client-side within the connector.
- AccountId supports the '='.
- Type supports the '=,IN'.
For example:
SELECT * FROM RecommendationUpdateAdCreativeUpdateAdCreativeList WHERE AccountId = '1002504155' AND Type = 'DAILY_BUDGET_OVER'
Columns
| Name | Type | References | Description |
| AccountId | Int64 |
DisplayAdsAccounts.AccountId | Account ID. |
| RecommendationId | Int64 | Recommendation ID. | |
| CampaignId | Int64 | Campaign ID. | |
| CampaignName | String | Campaign Name. | |
| AdGroupId | Int64 | Ad group ID. | |
| AdGroupName | String | Ad group name. | |
| AdId | Int64 | Ad ID. | |
| AdName | String | Ad name. | |
| PreviousViewableCtr | Double | Viewable CTR 30 to 16 days ago (average). | |
| LatestViewableCtr | Double | Latest viewable CTR (monthly average). | |
| ViewableCtrDecrease | Double | Viewable CTR decrease. | |
| Type | String | Type of Recommendations
使用できる値は次のとおりです。DAILY_BUDGET_OVER, IMPRESSION_SHARE_BUDGET_LOSS_OVER, BID_STRATEGY_TO_TARGET_CPA, SEARCH_KEYWORD_LIST_IDEA, MAXIMIZE_CONVERSIONS, MAXIMIZE_CLICKS, MAXIMIZE_VIDEO_VIEWS, UPDATE_AD_CREATIVE, DUPLICATE_TARGETING_SETTINGS, NOT_OPTIMAL_AD_COUNT_COMBINED_AD_TYPE_AND_IMAGE_SIZE, ADGROUPS_FOR_ADDING_ADS, DAILY_BUDGET_SMALL, INSUFFICIENT_TARGETING, INSUFFICIENT_AD_SCHEDULE_TARGETING, INSUFFICIENT_CONVERSIONS, INSUFFICIENT_CLICKS, INSUFFICIENT_VIDEO_VIEWS, UNKNOWN |