Un - supported report columns
The group you are posting to is a
Usenet group . Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
From:
rajeesh <rajee... @gmail.com>
Date: Fri, 18 Jul 2008 08:01:15 -0700 (PDT)
Local: Fri, Jul 18 2008 11:01 am
Subject: Un - supported report columns
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?
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
AdWords API Advisor <adwordsapiadvi... @google.com>
Date: Fri, 18 Jul 2008 13:49:46 -0700 (PDT)
Local: Fri, Jul 18 2008 4:49 pm
Subject: Re: Un - supported report columns
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
On Jul 18, 11:01 am, rajeesh <rajee... @gmail.com> wrote:
> 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?
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
"mona.venning" <mona.venn... @googlemail.com>
Date: Fri, 25 Jul 2008 04:27:30 -0700 (PDT)
Local: Fri, Jul 25 2008 7:27 am
Subject: Re: Un - supported report columns (URL Performance Reports)
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
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
AdWords API Advisor <adwordsapiadvi... @google.com>
Date: Fri, 25 Jul 2008 08:50:50 -0700 (PDT)
Local: Fri, Jul 25 2008 11:50 am
Subject: Re: Un - supported report columns (URL Performance Reports)
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:
> 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
You must
Sign in before you can post messages.
You do not have the permission required to post.