DisplayAdsReportFields
Retrieve the available report fields for a given report type.
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 ReportType is required to make a request and the rest of the filter is executed client-side within the connector.
- ReportType supports the '='.
SELECT * FROM DisplayAdsReportFields WHERE ReportType = 'ACCOUNT'
Columns
| Name | Type | References | Description |
| DisplayFieldNameEn | String | Field Name for the Downloaded Report (En). | |
| DisplayFieldNameJa | String | Field Name for the Downloaded Report (Ja). | |
| FieldName | String | Field Name. | |
| FieldType | String | Field type (number, string, ENUM, etc.) | |
| Filterable | Boolean | Whether the field filter can be specified or not (true: Filter can be specified). | |
| XmlAttributeName | String | XML attribute for the Downloaded Report | |
| ImpossibleCombinationFields | String | Invalid field combinations. | |
| ReportType | String | Serves category type of report. Conversion Path Report: CONVERSION_PATH, Cross-campaign Reach Report: CROSS_CAMPAIGN_REACHES, Reach Frequency Report: FREQUENCY, Reach Report: REACH. Only CONVERSION_PATH,CROSS_CAMPAIGN_REACHES,FREQUENCY and REACH can be specified in ADD operation.
使用できる値は次のとおりです。AD, AUDIENCE_CATEGORY, CONVERSION_PATH, CROSS_CAMPAIGN_REACHES, AUDIENCE_LIST_TARGET, SEARCH_TARGET, PLACEMENT_TARGET, LABEL, SITE_CATEGORY, REACH, URL, MODEL_COMPARISON, CONTENT_KEYWORD_LIST, UNKNOWN |