DisplayAdsGeographicLocations
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.
- GeographicLocationType supports the '='.
- Lang supports the '='.
For example:
SELECT * From DisplayAdsGeographicLocations WHERE Lang = 'EN' SELECT * FROM DisplayAdsGeographicLocations WHERE Lang = 'EN' AND GeographicLocationType = 'TARGETING'
Columns
| Name | Type | References | Description |
| Child | String | undefined. | |
| Code | String | Geographic code.The 'Other' geo code (TC-CI-00000073) is not available for geo targeting. | |
| FullName | String | Name of places (Prefecture and all). | |
| 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 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| GeographicLocationType | String | Describes the type of location information.
使用できる値は次のとおりです。TARGETING, FEED, UNKNOWN |