CData Python Connector for Yahoo! Ads

Build 24.0.9062

RecommendationSearchKeywordIdeaSearchKeywordIdeaSearchKeywordLists

Retrieve the details of recommended search keyword to add. The columns values set read-only false can be inserted in the parent table using Temp tables.

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 RecommendationSearchKeywordIdeaSearchKeywordIdeaSearchKeywordLists WHERE AccountId = '1002504155' AND Type = 'DAILY_BUDGET_OVER'

Columns

Name Type References Description
AccountId Int64

DisplayAdsAccounts.AccountId

Account ID.
CurrentSearchKeywordFrequency String Frequency of search keyword list.
CurrentSearchKeywordListId Int64 Search keyword list ID.
CurrentSearchKeywordListName String Search keyword list name.
CurrentSearchKeywordRecency String Recency of search keyword list.
DesktopSearchVolume Int64 Number of reach in PC with recommended search keyword
RecommendationId Int64 Recommendation ID.
RecommendedSearchKeyword String Recommended search keyword.
RecommendedSearchKeywordId Int64 Recommended search keyword ID.
SmartPhoneSearchVolume Int64 Number of Reach in SmartPhone with recommended search keyword.
TabletSearchVolume Int64 Number of Reach in Tablet with recommended search keyword.
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

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