SearchAdsGeographicLocations
Get the information list of geo targeting.
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 Lang is required to make a request and the rest of the filter is executed client-side within the connector.
- Lang supports the 'IN'.
For example:
SELECT * FROM SearchAdsGeographicLocations WHERE Lang = 'JA'
Columns
| Name | Type | References | Description |
| Child | String | undefined. | |
| Code | String | Geographic code. | |
| FullName | String | Name of places (Prefecture and all). | |
| GeographicLocationStatus | String | Status of geographic location.
使用できる値は次のとおりです。ACTIVE, OBSOLETE, PHASING_OUT, UNKNOWN | |
| Name | String | Name of places (City Only). | |
| Order | String | Order of list. | |
| Parent | String | Parent geographic code. | |
| Lang | String | A language selection of the list.
使用できる値は次のとおりです。JA, EN, UNKNOWN |