Re: Exception downloading Performance Report with java

[Anash P. Oommen (AdWords API Team)]

Hi Adrian,

When setting String Cid = "XXX-XXX-XXXX"; is this an advertiser account's CID or an MCC account's CID? From the error it looks like you are setting an MCC account CID here.

Cheers,
Anash P. Oommen,
AdWords API Advisor.

On Wednesday, January 30, 2013 10:12:20 PM UTC+5:30, Adrian Castro Solís wrote:

Hi

Im having this error in my java code, when I trying to download an adhoc report...  This is exception:

Report was not downloaded. 400: HTTP code: 400, type: "ReportDefinitionError.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH", trigger: "", fieldPath: ""

This is the java code

import com.google.api.adwords.lib.AdWordsServiceLogger;

import com.google.api.adwords.lib.AdWordsUser;

import com.google.api.adwords.lib.AuthToken;

import com.google.api.adwords.lib.utils.v201209.ReportDownloadResponse;

import com.google.api.adwords.lib.utils.v201209.ReportUtils;

import com.google.api.adwords.v201209.jaxb.cm.DownloadFormat;

import com.google.api.adwords.v201209.jaxb.cm.ReportDefinition;

import com.google.api.adwords.v201209.jaxb.cm.ReportDefinitionDateRangeType;

import com.google.api.adwords.v201209.jaxb.cm.ReportDefinitionReportType;

import com.google.api.adwords.v201209.jaxb.cm.Selector;

import java.io.File;

import java.io.FileOutputStream;

import java.net.HttpURLConnection;

import java.util.List;

public class AddMccReportDefinition {

  public static void main(String[] args) {

    try {

String email = "xxx...@mail.com";

String password = "XXXXXXXXXXXX";

String userAgent = "mycompany.com";

String developerToken = "XXXXXXXX";

String Cid = "XXX-XXX-XXXX";

      // Log SOAP XML request and response.

      AdWordsServiceLogger.log();

      // Get AdWordsUser from "~/adwords.properties".

      AdWordsUser user = new AdWordsUser(email, password, Cid, userAgent, developerToken);

      // Location to download report to.

      String reportFile = "report.csv";

      // Create selector.

      Selector selector = new Selector();

      List<String> fields = selector.getFields();

      fields.add("AdGroupId");

      fields.add("Id");

      fields.add("KeywordText");

      fields.add("KeywordMatchType");

      fields.add("Impressions");

      fields.add("Clicks");

      fields.add("Cost");

      // Create report definition.

      ReportDefinition reportDefinition = new ReportDefinition();

      reportDefinition.setReportName("Keywords performance report #" + System.currentTimeMillis());

      reportDefinition.setDateRangeType(ReportDefinitionDateRangeType.LAST_30_DAYS );

      reportDefinition.setReportType(ReportDefinitionReportType.ACCOUNT_PERFORMANCE_REPORT);

      reportDefinition.setDownloadFormat(DownloadFormat.CSV);

      reportDefinition.setIncludeZeroImpressions(false);

      reportDefinition.setSelector(selector);

      

      FileOutputStream fos = new FileOutputStream(new File(reportFile));

      

     

      ReportDownloadResponse response = ReportUtils.downloadReport( user , reportDefinition, fos);

      

      if (response.getHttpStatus() == HttpURLConnection.HTTP_OK) {

        System.out.println("Report successfully downloaded: " + reportFile);

      } else {

        System.out.println("Report was not downloaded. " + response.getHttpStatus() + ": "

            + response.getHttpResponseMessage());

      }

    } catch (Exception e) {

      e.printStackTrace();

    }

  }

}

[Assaf Frank]

Hi Anash,

Is there anyway to use the AccountPerformaceReport (or any other report) to get statistics for each account (1 row per account) under my MCC account?

Many thanks,

[Anash P. Oommen (AdWords API Team)]

Hi Assaf,

No, AdWords API doesn't support or have future plans to support MCC level reports.

Cheers,
Anash P. Oommen,
AdWords API Advisor.