PlacementUrlIdeas
Get the candidate URL
Table Specific Information
SELECT
The connector will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator.
- Keyword supports the '='.
- SiteCategory supports the '=,IN'.
SELECT * FROM PlacementUrlIdeas
Columns
| Name | Type | References | Description |
| DesktopAdRequests | Int64 | AD Number of PC(1000 In the case of 0) | |
| DesktopReaches | Int64 | Reach Number of PC(1000 In the case of 0) | |
| Keyword | String | Search Keyword Search all keywords (AND), separated by spaces. Maximum of 250 characters. Maximum of 10 spaces to separate the words | |
| SearchUrl | String | Search Category | |
| SiteCategory | String | URL. Category of URL. Exact match. Search multiple specific keywords (OR) From value: TC-SC-xxxxxx Choose the TC-SC-xxxxxx value from DictionaryService Maximum of 50 cases | |
| SmartPhoneAdRequests | Int64 | AD Number of SmartPhone(1000 In the case of 0) | |
| SmartPhoneReaches | Int64 | Reach Number of SmartPhone (1000 In the case of 0) | |
| TabletAdRequests | Int64 | AD Number of Tablet (1000 In the case of 0) | |
| TabletReaches | Int64 | Tablet(1000 In the case of 0) | |
| AdPlacementName | String | Ad place name |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| KeywordFilterTypes | String | The type of search keyword
使用できる値は次のとおりです。URL, AD_PLACE_NAME, UNKNOWN | |
| AdPlaceFilterTypes | String | The type of ad place to be searched.
使用できる値は次のとおりです。MAIN_AD_PLACE, UNKNOWN | |
| Lang | String | The language selection of the ad place name in the response.
使用できる値は次のとおりです。EN, JA, UNKNOWN | |
| UnknownUrlFilterType | String | Item to filter unknown URLs in the search results
使用できる値は次のとおりです。DISPLAY, HIDE, UNKNOWN | |
| SortField | String | The sorting field
使用できる値は次のとおりです。URL, AD_PLACE_NAME, DESKTOP_REACHES, DESKTOP_AD_REQUESTS, SMART_PHONE_REACHES, SMART_PHONE_AD_REQUESTS, TABLET_REACHES, TABLET_AD_REQUESTS, UNKNOWN | |
| SortType | String | The sorting method
使用できる値は次のとおりです。ASC, DESC, UNKNOWN |