JDBC Driver for Yahoo! Ads

Build 24.0.9062

Recommendations

Get Recommendations information.

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 and Type is required to make a request and the rest of the filter is executed client-side within the 本製品.

  • AccountId supports the '='.
  • Type supports the '=,IN'.

For example:

SELECT * FROM Recommendations WHERE AccountId = '1002504155' AND Type = 'DAILY_BUDGET_OVER'

Columns

Name Type References Description
AccountId Int64 Account ID.
CampaignBiddingStrategyToTargetCpaCampaignBiddingStrategyToTargetCpaCampaignList String Recommendation information about the campaign that is suitable for using autobidding.
DailyBudgetOverDailyBudgetOverCampaignList String Recommendation information about campaigns that reached the daily budget.
ImpsShareBudgetLossOverImpsShareBudgetLossOverCampaignList String Recommendations information of campaigns that have a large lost impression share (budget).
SearchKeywordIdeaSearchKeywordIdeaSearchKeywordList String This describes the detailed information of recommended search keyword to add.
MaximizeConversionsCampaignList String This describes detailed information of Recommendations about the campaign that is suitable for using autobidding(Maximize Conversions).
MaximizeClicksCampaignList String This describes detailed information of Recommendations about the campaign that is suitable for using autobidding(Maximize Clicks).
MaximizeVideoViewsCampaignList String This describes detailed information of Recommendations about the campaign that is suitable for using autobidding(Maximize video views).
UpdateAdCreativeList String This describes the detailed information of ads that have recommendations for updating images or videos.
DuplicateTargetingSettingsAdGroupList String This describes detailed information of recommendations about the ad group with duplicate targeting settings.
NotOptimalAdCountCombinedAdTypeAndImageSizeAdGroupList String This describes detailed information of recommendations about the ad group that have other than 3-5 ads that combine a specific ad type and image size.
AdGroupsForAddingAdsList String This describes detailed information of recommendations about the ad group with recommended image sizes.
DailyBudgetSmallCampaignList String This describes detailed information of recommendations about the campaign with less than 5,000 JPY daily budget.
InsufficientTargetingCampaignList String This describes detailed information of recommendations about the campaign that too narrow down the targeting.
InsufficientAdScheduleTargetingCampaignList String This describes detailed information of recommendations about the campaign that have days of the week with less than six hours available for ad delivery.
InsufficientConversionsCampaignList String This describes detailed information of recommendations about the campaign that need to increase conversions.
InsufficientClicksCampaignList String This describes detailed information of recommendations about the campaign that need to increase clicks.
InsufficientVideoViewsCampaignList String This describes detailed information of Recommendations about the campaign that need to increase video views.
EnhancedCpcCampaignList String This describes recommendation information about the campaign that is suitable for using enhanced CPC.
CreateAdGroupList String This describes detailed information about a recommendation for creating ad groups.
CreateAdList String This describes detailed information about a recommendation for creating ads.
CreateResponsiveDisplayAdsList String This describes detailed information about a recommendation for Responsive Ads for Display.
CreateCampaignRecommendationId Int64 Recommendation ID.
TurnYourAccountOnRecommendationId Int64 Recommendation ID.
TurnYourAdOnRecommendationId Int64 Recommendation ID.
InsufficientAccountBalanceRecommendationId Int64 Recommendation ID.
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

OptimizationScoreLift Double Estimated optimization score increase.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062