google-api - 如何找出哪些列组合在adwords中有效

Question

我正在使用AdWords API生成报告。
请忍受，因为我对此不太熟悉。
我正在使用API​​的v201409版本。
我使用getReportFields获得了KEYWORD_PERFORMANCE_REPORT的报告列。
然后，我尝试使用这些列的子集下载报告。

对于KEYWORD_PERFORMANCE_REPORT，我得到了错误：


无法选择设备和
AssistClicks，AssistClicksOverLastClicks，AssistImpressions，AssistImpressionsOverLastClicks，AveragePageviews，AverageTimeOnSite，BounceRate，反弹，ClickAssistedConversionValue，ClickAssistedConversionValueLong，ClickAssistedConversionValueNonMoney，ClickAssistedConversions，ClickAssistedConversionsOverLastClickConversions，ImpressionAssistedConversionValue，ImpressionAssistedConversionValueLong，ImpressionAssistedConversionValueNonMoney，ImpressionAssistedConversions，ImpressionAssistedConversionsOverLastClickConversions，LastClickConversions，LastClicks，新访问者，浏览量，PercentNewVisitors，VisitDuration，参观，
类型：ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT。


问题是：如何在不经过反复试验的情况下，找到一组有效的列组合。是否有任何文档可以帮助我呢？

我查看了http://developers.guge.io/adwords/api/docs/appendix/reports中KEYWORD_PERFORMANCE_REPORT的列，并排除了api所说的“不兼容”列。有类似的错误。
谢谢

注意：如果我使用在线示例中提供的列尝试此代码，它将正常工作并按预期下载报告。
代码是：
`
String [] columnNames = {
“ ConversionRateManyPerClickSignificance”，
“ ConversionRateSignificance”，
“ ViewThroughConversionsSignificance”，
“ AccountCurrencyCode”，
“ AccountDescriptiveName”，
“ AccountTimeZoneId”，
“ AdGroupId”，
“ AdGroupName”，
“ AdGroupStatus”，
“ AssistImpressions”，
“ AssistImpressionsOverLastClicks”，
“ AverageCpc”，
“ AverageCpm”，
“ AveragePageviews”，
“ AveragePosition”，
“ AverageTimeOnSite”，
“ BiddingStrategyId”，
“ BiddingStrategyName”，
“ BiddingStrategyType”，
“ CampaignId”，
“ CampaignName”，
“ CampaignStatus”，
“ ClickAssistedConversionsOverLastClickConversions”，
“ ClickAssistedConversionValue”，
“点击次数”，
“ ClickSignificance”，
“ ClickType”，
“ ConversionManyPerClickSignificance”，
“兑换率”，
“ ConversionRateManyPerClick”，
“转化”，
“转化意义”，
“ ConversionsManyPerClick”，
“ ConversionTypeName”，
“转化价值”，
“成本”，
“ CostPerConversion”，
“ CostPerConversionManyPerClick”，
“ CostPerConversionManyPerClickSignificance”，
“ CostPerConversionSignificance”，
“ CostSignificance”，
“ CpcBid”，
“ CpcBidSource”，
“ CpmBid”，
“ CpmSignificance”，
“ CriteriaDestinationUrl”，
“点击率”，
“ CtrSignificance”，
“ CustomerDescriptiveName”，
“ CvrSignificance”，
“日期”，
“ DayOfWeek”，
“设备”，
“ ExternalCustomerId”，
“ FinalAppUrls”，
“ FinalMobileUrls”，
“ FinalUrls”，
“ FirstPageCpc”，
“ID”，
“ ImpressionAssistedConversions”，
“ ImpressionAssistedConversionsOverLastClickConversions”，
“ ImpressionAssistedConversionValue”，
“展示次数”，
“印象意义”，
“为负”，
“ KeywordMatchType”，
“ LabelIds”，
“标签”，
“月”，
“ MonthOfYear”，
“ PlacementUrl”，
“ PositionSignificance”，
“ PrimaryCompanyName”，
“ QualityScore”，
“25美分硬币”，
“ SearchExactMatchImpressionShare”，
“ SearchImpressionShare”，
“ SearchRankLostImpressionShare”，
“广告位”，
“ TrackingUrlTemplate”，
“ UrlCustomParameters”，
“ ValuePerConversion”，
“ ValuePerConversionManyPerClick”，
“ ViewThroughConversions”，
“周”，
“年”

    };
 public static void downloadConsolidatedReportFile(String[] columnNames, final ReportDefinitionDateRangeType forDateRange, final ReportDefinitionReportType reportDefinitionReportType, final String to) throws Exception {
    com.google.api.ads.adwords.lib.jaxb.v201409.Selector selector = new com.google.api.ads.adwords.lib.jaxb.v201409.Selector();
    selector.getFields().addAll(Lists.newArrayList(columnNames));
    ReportDefinition reportDefinition = new ReportDefinition();
    reportDefinition.setReportName("Report " + reportDefinitionReportType.value() + " for dateRange " + forDateRange.value());
    reportDefinition.setDateRangeType(forDateRange);
    reportDefinition.setReportType(reportDefinitionReportType);
    reportDefinition.setDownloadFormat(DownloadFormat.CSV);

    ReportingConfiguration reportingConfiguration = new ReportingConfiguration.Builder()
            .skipReportHeader(true)
            .skipReportSummary(true)
            .build();
    session.setReportingConfiguration(reportingConfiguration);

    reportDefinition.setSelector(selector);

    BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(to)));
    String mccId = session.getClientCustomerId(); //The id from ads.properties file
    Collection<Client> clientIds = getClientAccountIds(mccId);
    try {
        for (Client cl : clientIds) {
            BufferedReader reader = null;
            String customerId = cl.id;
            String name = cl.name;

            session.setClientCustomerId(cl.id);
            try {
                ReportDownloadResponse response =
                        new ReportDownloader(session).downloadReport(reportDefinition);
                if (response == null || response.getHttpStatus() != 200) {
                    handleError(response);
                }
                BufferedInputStream bs = new BufferedInputStream(response.getInputStream());
                reader = new BufferedReader(new InputStreamReader(bs));
                String line = null;
                log.info("getting " + reportDefinition.getReportType().value() + " for " + customerId+" "+name);
                reader.readLine(); //Skip the first line of column names
                while ((line = reader.readLine()) != null) {
                    bw.write(line + "\n");
                }
            } catch (DetailedReportDownloadResponseException e) {
                log.error("An error was thrown downloading report for Customer id: " + customerId+" "+name, e);
                //We have to do this as we have to filter out the mcc id. An exception is thrown by MCC id
                if (e.getType().equals("ReportDefinitionError." + ReportDefinitionErrorReason.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH.getValue())) {
                    continue;
                } else {
                    throw e;
                }

            } catch (Exception e) {
                log.error("An error was thrown downloading report for Customer id: " + customerId+" "+name, e);
                throw e;
            } finally {
                if (reader != null) {
                    reader.close();
                }
            }

        }
    } finally {
        if (bw != null) {
            bw.flush();
            bw.close();
        }
    }
}

`

您在下面的注释中提到的所有列均未使用。

Answer 1

检查以下文档。
https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report#activeviewcpm

对于某些字段，提供了“与以下字段不兼容”选项。单击该选项以检查不兼容的组合