Un - supported report columns

[rajeesh]

Hi,

I want to pull an ad performance report with columns customer name,
customerid, impressions,clicks,cost.
but I am getting the following exception:

faultCode: {http://schemas.xmlsoap.org/soap/
envelope/}Server.userException
faultSubcode:
faultString: One or more report job parameters is invalid.
faultActor:
faultNode:
faultDetail:
{https://adwords.google.com/api/adwords/v12}fault:
<ns1:code>30</ns1:code>

<ns1:message>One or more report job parameters is invalid.</
ns1:message>

<ns1:trigger> The following columns are not supported by the
Report Type Creative : [CustomerName, ExternalCustomerId]</
ns1:trigger>

These 2 columns need MCC account to access. But I am using MCC
account. The code sequence is as follows:
String[] customOptions =
{
"CustomerName" ,
"ExternalCustomerId",
"Campaign" ,
"AdGroup" ,
"Keyword" ,
"DescriptionLine1" ,
"DescriptionLine2" ,
"DescriptionLine3" ,
"VisibleUrl" ,
"CreativeId" ,
"CreativeType" ,
"AdWordsType" ,
"DestinationURL" ,
"CampaignStatus" ,
"Impressions" ,
"Clicks" ,
"Cost" ,
"AveragePosition"
};
myReportJob.setSelectedColumns(customOptions);


can you help me to solve this issue?

[AdWords API Advisor]

Hello Rajeesh,

While you may be specifying a MCC account in your <email> header, can
you confirm that you're not passing anything for the <clientEmail> or
<clientCustomerId> headers? If you set those then you're no longer
going to be working in the context of your MCC account.

If you're sure that you're not setting either of those headers, could
you please provide the value of the <requestId> header from your SOAP
response so I can look up your request in our logs?

Cheers,
-Jeff Posnick, AdWords API Team

[mona.venning]

Hi Jeff and Rajeesh,

Just wondering how that issue was resolved because I seem to be facing
a similar issue running a top level URL performance report with
AdWords API v12 and receiving report validation errors where ‘One or
more report job parameters are invalid’: those being customerid.
Just to confirm: I am not passing anything for the <clientEmail> or
<clientCustomerId> headers.

Here’s the SOAP RequestId:
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns=https://adwords.google.com/api/
adwords/v12>
2cb31fa7124b1deb6950628064f1cd5f
</requestId>

The SOAP Request:

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:ns1="https://adwords.google.com/api/adwords/v12"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<SOAP-ENV:Header>
<ns1:email>xxxxx</ns1:email>
<ns1:password>xxxx</ns1:password>
<ns1:useragent>Top level Activity Data Import</ns1:useragent>
<ns1:applicationToken>xxxxx</ns1:applicationToken>
<ns1:developerToken>xxxxxx</ns1:developerToken>
</SOAP-ENV:Header>

<SOAP-ENV:Body>
<ns1:validateReportJob>
<ns1:job xsi:type="ns1:DefinedReportJob">
<ns1:crossClient>false</ns1:crossClient>
<ns1:endDay>2008-07-24</ns1:endDay>
<ns1:name>URL Performance Report For: 2008-07-24</ns1:name>
<ns1:startDay>2008-07-24</ns1:startDay>
<ns1:aggregationTypes>Daily</ns1:aggregationTypes>
<ns1:selectedColumns>customerid</ns1:selectedColumns>
<ns1:selectedColumns>acctname</ns1:selectedColumns>
<ns1:selectedColumns>CampaignId</ns1:selectedColumns>
<ns1:selectedColumns>Campaign</ns1:selectedColumns>
<ns1:selectedColumns>AdGroupId</ns1:selectedColumns>
<ns1:selectedColumns>AdGroup</ns1:selectedColumns>
<ns1:selectedColumns>KeywordId</ns1:selectedColumns>
<ns1:selectedColumns>Keyword</ns1:selectedColumns>
<ns1:selectedColumns>KeywordTypeDisplay</ns1:selectedColumns>
<ns1:selectedColumns>KeywordDestUrlDisplay</ns1:selectedColumns>
<ns1:selectedColumns>AdWordsType</ns1:selectedColumns>
<ns1:selectedColumns>AveragePosition</ns1:selectedColumns>
<ns1:selectedColumns>Impressions</ns1:selectedColumns>
<ns1:selectedColumns>Clicks</ns1:selectedColumns>
<ns1:selectedColumns>Cost</ns1:selectedColumns>
<ns1:selectedColumns>Conversions</ns1:selectedColumns>
<ns1:selectedColumns>LeadCount</ns1:selectedColumns>
<ns1:selectedColumns>DestinationURL</ns1:selectedColumns>
<ns1:selectedColumns>KeywordStatus</ns1:selectedColumns>
<ns1:selectedColumns>AdGroupStatus</ns1:selectedColumns>
<ns1:selectedColumns>CampaignStatus</ns1:selectedColumns>
<ns1:selectedColumns>MaximumCPC</ns1:selectedColumns>
<ns1:selectedColumns>KeywordMinCPC</ns1:selectedColumns>
<ns1:selectedReportType>Url</ns1:selectedReportType>
</ns1:job></ns1:validateReportJob>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

The SOAP Response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Header>
<responseTime soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">104</responseTime>
<operations soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">1</operations>
<units soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">1</units>
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">2cb31fa7124b1deb6950628064f1cd5f</requestId>
</soapenv:Header>

<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>One or more report job parameters is invalid.</
faultstring>
<detail>
<ns1:fault xmlns:ns1="https://adwords.google.com/api/adwords/
v12">

<ns1:code>30</ns1:code>
<ns1:message>One or more report job parameters is invalid.</
ns1:message>

<ns1:trigger>Unknown Column Type:customerid</ns1:trigger>
</ns1:fault>
</detail>
</soapenv:Fault>
</soapenv:Body>

</soapenv:Envelope>


Thanks in advance.

Kind Regards,
- Mona Venning

[AdWords API Advisor]

Hello Mona,

I think you're running into something different than Rajeesh. Those
column names you're requesting are legitimately invalid. The list of
supported column names in your SOAP requests is at

http://www.google.com/apis/adwords/developer/adwords_api_report_url.html

Specifically, instead of asking for the "customerid" and "acctname"
columns, you should specify the "ExternalCustomerId" and
"CustomerName" columns. (The report XML that is returned will have the
columns labeled as "customerid" and "acctname". Yes, having to keep
track of different names for the request and responses is definitely
less than ideal.)

Please note that "ExternalCustomerId" and "CustomerName" are only
valid columns if you're running the report from an MCC account. And if
you are running the report from an MCC account, you should be setting
<crossClient> to true and specifying one or more value for the
<clientEmails> SOAP parameter (which is distinct from the
"clientEmail" SOAP header).

Cheers,
-Jeff Posnick, AdWords API Team

On Jul 25, 7:27 am, "mona.venning" <mona.venn...@googlemail.com>
wrote: