SiteCategories
Get the list of site category.
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 '='.
For example:
SELECT * FROM SiteCategories WHERE Lang = 'EN'
SELECT * FROM SiteCategories WHERE Lang = 'EN' AND CODE = 'TC-SC-10110100100100'
Columns
| Name | Type | References | Description |
| Code | String | Category code. | |
| FullName | String | Category name in high level. | |
| Name | String | Category name. | |
| ReachDesktop | Int64 | Reach record number of PC | |
| ReachSmartphone | Int64 | Reach record number of smartphone | |
| ReachTablet | Int64 | Reach record number of tablet | |
| Lang | String | language selection of the list.
使用できる値は次のとおりです。EN, JA, UNKNOWN |