Mutually exclusive in columns error when report downloading.
19 views
Skip to first unread message
PPL
May 27, 2009, 9:14:40 AM5/27/09
to AdWords API Forum
Hello,
I'm facing the error message "The following columns are mutually
exclusive : [Clicks]" when I scheduled the Creative and Keyword
reports.
I'm downloading the report from the context of MCC account. I didn't
provided any client email in the request header. I set crossClient
field to true and do'nt set any client email to clientEmails field of
the reportJob so that all of the client account's data will be
included in the report. Since I'm downloading the report from the
context of the MCC account I included the columns which footnote are 1
and 2 in the selectedColumns. How can I solve that problem? I've seen
such kind of problems in this forum previously so I tried all of the
possible ways of the suggesions. We are urgent at this moment. So
please help me to find out the solution.
Thanks a lot.
I'm facing the error message "The following columns are mutually
exclusive : [Clicks]" when I scheduled the Creative and Keyword
reports.
I'm downloading the report from the context of MCC account. I didn't
provided any client email in the request header. I set crossClient
field to true and do'nt set any client email to clientEmails field of
the reportJob so that all of the client account's data will be
included in the report. Since I'm downloading the report from the
context of the MCC account I included the columns which footnote are 1
and 2 in the selectedColumns. How can I solve that problem? I've seen
such kind of problems in this forum previously so I tried all of the
possible ways of the suggesions. We are urgent at this moment. So
please help me to find out the solution.
Thanks a lot.
Message has been deleted
Message has been deleted
Message has been deleted
Keporio
May 27, 2009, 2:39:48 PM5/27/09
to AdWords API Forum
I am a member of PPL above. Here is additional info
We are using java library "com.google.api.adwords.lib ver 2.2.0"
provided by Google
We use the below method to create the request header so that the
client_email won't be setted in the header, (we suppose using this
method excludes client_email from the header..)
Method:
com.google.api.adwords.lib.AdWordsUser.AdWordsUser(String email,
String password, String useragent, String developerToken, String
applicationToken, String version, URL alternateUrl)
email is MCC email
password is MCC password
Developer Token and Application Token is valid
version is "v13"
alternateUrl is null
for DefineReportJob object
We set as described below so that we can get a report for all MCC
client accounts set
job.setClientEmails(null);
job.setCrossClient(true);
We tried to comment out the " job.setClientEmails(null);", but still
comes the error message mutually
exclusive error.
====
Even the same error occurs when we used method below to specify the
client account and excluded ClientEmails and
CrossClient fields from the DefineReportJob object.
Method:
com.google.api.adwords.lib.AdWordsUser.AdWordsUser(String email,
String password, String clientId, String useragent, String
developerToken, String applicationToken)
Without "Clicks", getting Report function works.
Although it is not only "Clicks" which causes the mutually exclusive
problem, we think once we find out what's wrong with "Clicks" the
others will be no problem.
Thank you for your help
We are using java library "com.google.api.adwords.lib ver 2.2.0"
provided by Google
We use the below method to create the request header so that the
client_email won't be setted in the header, (we suppose using this
method excludes client_email from the header..)
Method:
com.google.api.adwords.lib.AdWordsUser.AdWordsUser(String email,
String password, String useragent, String developerToken, String
applicationToken, String version, URL alternateUrl)
email is MCC email
password is MCC password
Developer Token and Application Token is valid
version is "v13"
alternateUrl is null
for DefineReportJob object
We set as described below so that we can get a report for all MCC
client accounts set
job.setClientEmails(null);
job.setCrossClient(true);
We tried to comment out the " job.setClientEmails(null);", but still
comes the error message mutually
exclusive error.
====
Even the same error occurs when we used method below to specify the
client account and excluded ClientEmails and
CrossClient fields from the DefineReportJob object.
Method:
com.google.api.adwords.lib.AdWordsUser.AdWordsUser(String email,
String password, String clientId, String useragent, String
developerToken, String applicationToken)
Without "Clicks", getting Report function works.
Although it is not only "Clicks" which causes the mutually exclusive
problem, we think once we find out what's wrong with "Clicks" the
others will be no problem.
Thank you for your help
AdWords API Advisor
May 27, 2009, 3:50:47 PM5/27/09
to AdWords API Forum
Hello,
Could you turn on logging in the Java client library (as per the
instructions at http://code.google.com/p/google-api-adwords-java/source/browse/trunk/README)
and take a look at the SOAP response you get back with the error
message in it. Could you let us know what the value of the "requestId"
SOAP header is in that response?
Cheers,
-Jeff Posnick, AdWords API Team
Could you turn on logging in the Java client library (as per the
instructions at http://code.google.com/p/google-api-adwords-java/source/browse/trunk/README)
and take a look at the SOAP response you get back with the error
message in it. Could you let us know what the value of the "requestId"
SOAP header is in that response?
Cheers,
-Jeff Posnick, AdWords API Team
PPL
May 27, 2009, 11:46:58 PM5/27/09
to AdWords API Forum
Hello Jeff,
The following is the requestId of the SOAP header.
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">c3c4ea8c6cc23fe0d2ac617cc7a7774e</requestId>
I'm looking forward to your reply.
Thanks a lot.
On May 28, 3:50 am, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> > Thank you for your help- Hide quoted text -
>
> - Show quoted text -
The following is the requestId of the SOAP header.
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">c3c4ea8c6cc23fe0d2ac617cc7a7774e</requestId>
I'm looking forward to your reply.
Thanks a lot.
On May 28, 3:50 am, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> Hello,
>
> Could you turn on logging in the Java client library (as per the
> instructions athttp://code.google.com/p/google-api-adwords-java/source/browse/trunk/...)
>
> Could you turn on logging in the Java client library (as per the
>
> - Show quoted text -
PPL
May 28, 2009, 12:02:09 AM5/28/09
to AdWords API Forum
Hello Jeff,
The following are the SOAP request and response for your reference.
I've made 2 request both have the same error.
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
invoke
FINE: Enter: HTTPSender::invoke
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
invoke
FINE: Enter: HTTPSender::invoke
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: XML sent:
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: ---------------------------------------------------
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: XML sent:
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: ---------------------------------------------------
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: POST /api/adwords/v13/ReportService HTTP/1.0
Content-Type: text/xml; charset=utf-8
Accept: application/soap+xml, application/dime, multipart/related,
text/*
User-Agent: Axis/1.2.1
Host: adwords.google.com
Cache-Control: no-cache
Pragma: no-cache
SOAPAction: ""
Content-Length: 6481
<?xml version="1.0" encoding="UTF-8"?>
<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>
<ns1:email soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns:ns1="https://adwords.google.com/api/
adwords/v13">MCC EMAIL ID
</ns1:email>
<ns2:password soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns:ns2="https://adwords.google.com/
api/adwords/v13">MCC PASSWORD
</ns2:password>
<ns3:developerToken soapenv:actor="http://schemas.xmlsoap.org/soap/
actor/next" soapenv:mustUnderstand="0" xmlns:ns3="https://
adwords.google.com/api/adwords/v13">
DEVELOPER TOKEN</ns3:developerToken>
<ns4:applicationToken soapenv:actor="http://schemas.xmlsoap.org/soap/
actor/next" soapenv:mustUnderstand="0" xmlns:ns4="https://
adwords.google.com/api/adwords/v13">
APPLICATION TOKEN</ns4:applicationToken>
<ns5:useragent soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns:ns5="https://adwords.google.com/
api/adwords/v13">
AdWords API Java Client Library v2.2.0: USER AGENT</ns5:useragent>
</soapenv:Header>
<soapenv:Body><validateReportJob xmlns="https://adwords.google.com/api/
adwords/v13"><job xsi:type="ns6:DefinedReportJob" xmlns:ns6="https://
adwords.google.com/api/adwords/v13">
<crossClient xsi:type="xsd:boolean">true</crossClient>
<endDay xsi:type="xsd:date">2009-05-27</endDay>
<name xsi:type="xsd:string">Ad Data Report</name>
<startDay xsi:type="xsd:date">2009-05-27</startDay>
<aggregationTypes xsi:type="xsd:string">Daily</aggregationTypes>
<selectedColumns
xsi:type="xsd:string">AdDistributionWithSearchPartners</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CreativeId</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroup</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupId</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupMaxCpa</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdWordsType</selectedColumns>
<selectedColumns xsi:type="xsd:string">AverageConversionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">AvgPercentOfVideoPlayed</
selectedColumns>
<selectedColumns xsi:type="xsd:string">BottomPosition</
selectedColumns>
<selectedColumns xsi:type="xsd:string">BusinessAddress</
selectedColumns>
<selectedColumns xsi:type="xsd:string">BusinessName</selectedColumns>
<selectedColumns xsi:type="xsd:string">Campaign</selectedColumns>
<selectedColumns xsi:type="xsd:string">CampaignId</selectedColumns>
<selectedColumns xsi:type="xsd:string">CampaignStatus</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Clicks</selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionCategory</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionDescription</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionName</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Conversions</selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerConverstion</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerTransaction</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerVideoPlayback</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CreativeDestUrl</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CreativeType</selectedColumns>
<selectedColumns xsi:type="xsd:string">CustomerName</selectedColumns>
<selectedColumns xsi:type="xsd:string">CustomerTimeZone</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DailyBudget</selectedColumns>
<selectedColumns xsi:type="xsd:string">DescriptionLine1</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DescriptionLine2</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DescriptionLine3</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DestinationURL</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ExternalCustomerId</
selectedColumns>
<selectedColumns xsi:type="xsd:string">FirstPageCpc</selectedColumns>
<selectedColumns xsi:type="xsd:string">ImageAdName</selectedColumns>
<selectedColumns xsi:type="xsd:string">ImageHostingKey</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Keyword</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordId</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordDestUrlDisplay</
selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordMinCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordTypeDisplay</
selectedColumns>
<selectedColumns xsi:type="xsd:string">MaxContentCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">MaximumCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">MaximumCPM</selectedColumns>
<selectedColumns xsi:type="xsd:string">PhoneNo</selectedColumns>
<selectedColumns xsi:type="xsd:string">PreferredCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">PreferredCPM</selectedColumns>
<selectedColumns xsi:type="xsd:string">Preview</selectedColumns>
<selectedColumns xsi:type="xsd:string">QualityScore</selectedColumns>
<selectedColumns xsi:type="xsd:string">TopPosition</selectedColumns>
<selectedColumns xsi:type="xsd:string">TotalConversionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Transactions</selectedColumns>
<selectedColumns xsi:type="xsd:string">ValuePerClick</selectedColumns>
<selectedColumns xsi:type="xsd:string">ValuePerCost</selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybackRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacks</
selectedColumns>
<selectedColumns
xsi:type="xsd:string">VideoPlaybacksThrough100Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough25Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough50Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough75Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoSkips</selectedColumns>
<selectedColumns xsi:type="xsd:string">VisibleUrl</selectedColumns>
<selectedReportType xsi:type="xsd:string">Creative</
selectedReportType>
</job></validateReportJob></soapenv:Body></soapenv:Envelope>
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: POST /api/adwords/v13/ReportService HTTP/1.0
Content-Type: text/xml; charset=utf-8
Accept: application/soap+xml, application/dime, multipart/related,
text/*
User-Agent: Axis/1.2.1
Host: adwords.google.com
Cache-Control: no-cache
Pragma: no-cache
SOAPAction: ""
Content-Length: 6043
<?xml version="1.0" encoding="UTF-8"?>
<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><ns1:email soapenv:actor="http://schemas.xmlsoap.org/
soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns1="https://
adwords.google.com/api/adwords/v13">MCC EMAIL ID </ns1:email>
<ns2:password soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns:ns2="https://adwords.google.com/
api/adwords/v13">MCC PASSWORD </ns2:password>
<ns3:developerToken soapenv:actor="http://schemas.xmlsoap.org/soap/
actor/next" soapenv:mustUnderstand="0" xmlns:ns3="https://
adwords.google.com/api/adwords/v13">DEVELOPER TOKEN</
ns3:developerToken>
<ns4:applicationToken soapenv:actor="http://schemas.xmlsoap.org/soap/
actor/next" soapenv:mustUnderstand="0" xmlns:ns4="https://
adwords.google.com/api/adwords/v13">APPLICATION TOKEN</
ns4:applicationToken>
<ns5:useragent soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns:ns5="https://adwords.google.com/
api/adwords/v13">
AdWords API Java Client Library v2.2.0: USER AGENT</ns5:useragent>
</soapenv:Header>
<soapenv:Body><validateReportJob xmlns="https://adwords.google.com/api/
adwords/v13">
<job xsi:type="ns6:DefinedReportJob" xmlns:ns6="https://
adwords.google.com/api/adwords/v13">
<crossClient xsi:type="xsd:boolean">true</crossClient>
<endDay xsi:type="xsd:date">2009-05-27</endDay>
<name xsi:type="xsd:string">Criteria Report</name>
<startDay xsi:type="xsd:date">2009-05-27</startDay>
<aggregationTypes xsi:type="xsd:string">Daily</aggregationTypes>
<selectedColumns xsi:type="xsd:string">Keyword</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordId</selectedColumns>
<selectedColumns
xsi:type="xsd:string">AdDistributionWithSearchPartners</
selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroup</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupId</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupMaxCpa</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdWordsType</selectedColumns>
<selectedColumns xsi:type="xsd:string">AverageConversionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">AverageInteractions</
selectedColumns>
<selectedColumns xsi:type="xsd:string">AvgPercentOfVideoPlayed</
selectedColumns>
<selectedColumns xsi:type="xsd:string">BottomPosition</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Campaign</selectedColumns>
<selectedColumns xsi:type="xsd:string">CampaignId</selectedColumns>
<selectedColumns xsi:type="xsd:string">CampaignStatus</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Clicks</selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionCategory</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionDescription</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionName</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Conversions</selectedColumns>
<selectedColumns xsi:type="xsd:string">Cost</selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerConverstion</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerTransaction</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerVideoPlayback</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CustomerName</selectedColumns>
<selectedColumns xsi:type="xsd:string">CustomerTimeZone</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DailyBudget</selectedColumns>
<selectedColumns xsi:type="xsd:string">ExternalCustomerId</
selectedColumns>
<selectedColumns xsi:type="xsd:string">FirstPageCpc</selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractedImpressionRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractedImpressions</
selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractionEnabledImpressions</
selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractionRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordDestUrlDisplay</
selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordMinCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordTypeDisplay</
selectedColumns>
<selectedColumns xsi:type="xsd:string">MaxContentCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">MaximumCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">MaximumCPM</selectedColumns>
<selectedColumns xsi:type="xsd:string">PreferredCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">PreferredCPM</selectedColumns>
<selectedColumns xsi:type="xsd:string">QualityScore</selectedColumns>
<selectedColumns xsi:type="xsd:string">TopPosition</selectedColumns>
<selectedColumns xsi:type="xsd:string">TotalConversionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">TotalInteractions</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Transactions</selectedColumns>
<selectedColumns xsi:type="xsd:string">ValuePerClick</selectedColumns>
<selectedColumns xsi:type="xsd:string">ValuePerCost</selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybackRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacks</
selectedColumns>
<selectedColumns
xsi:type="xsd:string">VideoPlaybacksThrough100Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough25Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough50Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough75Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoSkips</selectedColumns>
<selectedReportType xsi:type="xsd:string">Keyword</selectedReportType>
</job></validateReportJob></soapenv:Body></soapenv:Envelope>
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: HTTP/1.0 500 Internal Server Error
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Content-Type text/xml; charset=utf-8
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Date Thu, 28 May 2009 03:39:02 GMT
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Expires Thu, 28 May 2009 03:39:02 GMT
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Cache-Control private, max-age=0
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: X-Content-Type-Options nosniff
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Content-Length 1450
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Server GFE/2.0
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readFromSocket
FINE:
XML received:
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readFromSocket
FINE: -----------------------------------------------
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readFromSocket
FINE: <?xml version="1.0" encoding="UTF-8"?><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/
<operations soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
<units soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultst
> > - Show quoted text -- Hide quoted text -
The following are the SOAP request and response for your reference.
I've made 2 request both have the same error.
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
invoke
FINE: Enter: HTTPSender::invoke
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
invoke
FINE: Enter: HTTPSender::invoke
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: XML sent:
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: ---------------------------------------------------
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: XML sent:
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: ---------------------------------------------------
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: POST /api/adwords/v13/ReportService HTTP/1.0
Content-Type: text/xml; charset=utf-8
Accept: application/soap+xml, application/dime, multipart/related,
text/*
User-Agent: Axis/1.2.1
Host: adwords.google.com
Cache-Control: no-cache
Pragma: no-cache
SOAPAction: ""
Content-Length: 6481
<?xml version="1.0" encoding="UTF-8"?>
<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>
<ns1:email soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns:ns1="https://adwords.google.com/api/
adwords/v13">MCC EMAIL ID
</ns1:email>
<ns2:password soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns:ns2="https://adwords.google.com/
api/adwords/v13">MCC PASSWORD
</ns2:password>
<ns3:developerToken soapenv:actor="http://schemas.xmlsoap.org/soap/
actor/next" soapenv:mustUnderstand="0" xmlns:ns3="https://
adwords.google.com/api/adwords/v13">
DEVELOPER TOKEN</ns3:developerToken>
<ns4:applicationToken soapenv:actor="http://schemas.xmlsoap.org/soap/
actor/next" soapenv:mustUnderstand="0" xmlns:ns4="https://
adwords.google.com/api/adwords/v13">
APPLICATION TOKEN</ns4:applicationToken>
<ns5:useragent soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns:ns5="https://adwords.google.com/
api/adwords/v13">
AdWords API Java Client Library v2.2.0: USER AGENT</ns5:useragent>
</soapenv:Header>
<soapenv:Body><validateReportJob xmlns="https://adwords.google.com/api/
adwords/v13"><job xsi:type="ns6:DefinedReportJob" xmlns:ns6="https://
adwords.google.com/api/adwords/v13">
<crossClient xsi:type="xsd:boolean">true</crossClient>
<endDay xsi:type="xsd:date">2009-05-27</endDay>
<name xsi:type="xsd:string">Ad Data Report</name>
<startDay xsi:type="xsd:date">2009-05-27</startDay>
<aggregationTypes xsi:type="xsd:string">Daily</aggregationTypes>
<selectedColumns
xsi:type="xsd:string">AdDistributionWithSearchPartners</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CreativeId</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroup</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupId</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupMaxCpa</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdWordsType</selectedColumns>
<selectedColumns xsi:type="xsd:string">AverageConversionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">AvgPercentOfVideoPlayed</
selectedColumns>
<selectedColumns xsi:type="xsd:string">BottomPosition</
selectedColumns>
<selectedColumns xsi:type="xsd:string">BusinessAddress</
selectedColumns>
<selectedColumns xsi:type="xsd:string">BusinessName</selectedColumns>
<selectedColumns xsi:type="xsd:string">Campaign</selectedColumns>
<selectedColumns xsi:type="xsd:string">CampaignId</selectedColumns>
<selectedColumns xsi:type="xsd:string">CampaignStatus</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Clicks</selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionCategory</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionDescription</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionName</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Conversions</selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerConverstion</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerTransaction</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerVideoPlayback</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CreativeDestUrl</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CreativeType</selectedColumns>
<selectedColumns xsi:type="xsd:string">CustomerName</selectedColumns>
<selectedColumns xsi:type="xsd:string">CustomerTimeZone</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DailyBudget</selectedColumns>
<selectedColumns xsi:type="xsd:string">DescriptionLine1</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DescriptionLine2</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DescriptionLine3</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DestinationURL</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ExternalCustomerId</
selectedColumns>
<selectedColumns xsi:type="xsd:string">FirstPageCpc</selectedColumns>
<selectedColumns xsi:type="xsd:string">ImageAdName</selectedColumns>
<selectedColumns xsi:type="xsd:string">ImageHostingKey</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Keyword</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordId</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordDestUrlDisplay</
selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordMinCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordTypeDisplay</
selectedColumns>
<selectedColumns xsi:type="xsd:string">MaxContentCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">MaximumCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">MaximumCPM</selectedColumns>
<selectedColumns xsi:type="xsd:string">PhoneNo</selectedColumns>
<selectedColumns xsi:type="xsd:string">PreferredCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">PreferredCPM</selectedColumns>
<selectedColumns xsi:type="xsd:string">Preview</selectedColumns>
<selectedColumns xsi:type="xsd:string">QualityScore</selectedColumns>
<selectedColumns xsi:type="xsd:string">TopPosition</selectedColumns>
<selectedColumns xsi:type="xsd:string">TotalConversionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Transactions</selectedColumns>
<selectedColumns xsi:type="xsd:string">ValuePerClick</selectedColumns>
<selectedColumns xsi:type="xsd:string">ValuePerCost</selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybackRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacks</
selectedColumns>
<selectedColumns
xsi:type="xsd:string">VideoPlaybacksThrough100Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough25Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough50Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough75Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoSkips</selectedColumns>
<selectedColumns xsi:type="xsd:string">VisibleUrl</selectedColumns>
<selectedReportType xsi:type="xsd:string">Creative</
selectedReportType>
</job></validateReportJob></soapenv:Body></soapenv:Envelope>
May 28, 2009 11:39:01 AM org.apache.axis.transport.http.HTTPSender
writeToSocket
FINE: POST /api/adwords/v13/ReportService HTTP/1.0
Content-Type: text/xml; charset=utf-8
Accept: application/soap+xml, application/dime, multipart/related,
text/*
User-Agent: Axis/1.2.1
Host: adwords.google.com
Cache-Control: no-cache
Pragma: no-cache
SOAPAction: ""
Content-Length: 6043
<?xml version="1.0" encoding="UTF-8"?>
<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><ns1:email soapenv:actor="http://schemas.xmlsoap.org/
soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns1="https://
adwords.google.com/api/adwords/v13">MCC EMAIL ID </ns1:email>
<ns2:password soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns:ns2="https://adwords.google.com/
api/adwords/v13">MCC PASSWORD </ns2:password>
<ns3:developerToken soapenv:actor="http://schemas.xmlsoap.org/soap/
actor/next" soapenv:mustUnderstand="0" xmlns:ns3="https://
adwords.google.com/api/adwords/v13">DEVELOPER TOKEN</
ns3:developerToken>
<ns4:applicationToken soapenv:actor="http://schemas.xmlsoap.org/soap/
actor/next" soapenv:mustUnderstand="0" xmlns:ns4="https://
adwords.google.com/api/adwords/v13">APPLICATION TOKEN</
ns4:applicationToken>
<ns5:useragent soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns:ns5="https://adwords.google.com/
api/adwords/v13">
AdWords API Java Client Library v2.2.0: USER AGENT</ns5:useragent>
</soapenv:Header>
<soapenv:Body><validateReportJob xmlns="https://adwords.google.com/api/
adwords/v13">
<job xsi:type="ns6:DefinedReportJob" xmlns:ns6="https://
adwords.google.com/api/adwords/v13">
<crossClient xsi:type="xsd:boolean">true</crossClient>
<endDay xsi:type="xsd:date">2009-05-27</endDay>
<name xsi:type="xsd:string">Criteria Report</name>
<startDay xsi:type="xsd:date">2009-05-27</startDay>
<aggregationTypes xsi:type="xsd:string">Daily</aggregationTypes>
<selectedColumns xsi:type="xsd:string">Keyword</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordId</selectedColumns>
<selectedColumns
xsi:type="xsd:string">AdDistributionWithSearchPartners</
selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroup</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupId</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupMaxCpa</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdGroupStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">AdWordsType</selectedColumns>
<selectedColumns xsi:type="xsd:string">AverageConversionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">AverageInteractions</
selectedColumns>
<selectedColumns xsi:type="xsd:string">AvgPercentOfVideoPlayed</
selectedColumns>
<selectedColumns xsi:type="xsd:string">BottomPosition</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Campaign</selectedColumns>
<selectedColumns xsi:type="xsd:string">CampaignId</selectedColumns>
<selectedColumns xsi:type="xsd:string">CampaignStatus</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Clicks</selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionCategory</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionDescription</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionName</
selectedColumns>
<selectedColumns xsi:type="xsd:string">ConversionRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Conversions</selectedColumns>
<selectedColumns xsi:type="xsd:string">Cost</selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerConverstion</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerTransaction</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CostPerVideoPlayback</
selectedColumns>
<selectedColumns xsi:type="xsd:string">CustomerName</selectedColumns>
<selectedColumns xsi:type="xsd:string">CustomerTimeZone</
selectedColumns>
<selectedColumns xsi:type="xsd:string">DailyBudget</selectedColumns>
<selectedColumns xsi:type="xsd:string">ExternalCustomerId</
selectedColumns>
<selectedColumns xsi:type="xsd:string">FirstPageCpc</selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractedImpressionRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractedImpressions</
selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractionEnabledImpressions</
selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractionRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">InteractionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordDestUrlDisplay</
selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordMinCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordStatus</selectedColumns>
<selectedColumns xsi:type="xsd:string">KeywordTypeDisplay</
selectedColumns>
<selectedColumns xsi:type="xsd:string">MaxContentCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">MaximumCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">MaximumCPM</selectedColumns>
<selectedColumns xsi:type="xsd:string">PreferredCPC</selectedColumns>
<selectedColumns xsi:type="xsd:string">PreferredCPM</selectedColumns>
<selectedColumns xsi:type="xsd:string">QualityScore</selectedColumns>
<selectedColumns xsi:type="xsd:string">TopPosition</selectedColumns>
<selectedColumns xsi:type="xsd:string">TotalConversionValue</
selectedColumns>
<selectedColumns xsi:type="xsd:string">TotalInteractions</
selectedColumns>
<selectedColumns xsi:type="xsd:string">Transactions</selectedColumns>
<selectedColumns xsi:type="xsd:string">ValuePerClick</selectedColumns>
<selectedColumns xsi:type="xsd:string">ValuePerCost</selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybackRate</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacks</
selectedColumns>
<selectedColumns
xsi:type="xsd:string">VideoPlaybacksThrough100Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough25Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough50Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoPlaybacksThrough75Percent</
selectedColumns>
<selectedColumns xsi:type="xsd:string">VideoSkips</selectedColumns>
<selectedReportType xsi:type="xsd:string">Keyword</selectedReportType>
</job></validateReportJob></soapenv:Body></soapenv:Envelope>
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: HTTP/1.0 500 Internal Server Error
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Content-Type text/xml; charset=utf-8
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Date Thu, 28 May 2009 03:39:02 GMT
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Expires Thu, 28 May 2009 03:39:02 GMT
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Cache-Control private, max-age=0
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: X-Content-Type-Options nosniff
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Content-Length 1450
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readHeadersFromSocket
FINE: Server GFE/2.0
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readFromSocket
FINE:
XML received:
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readFromSocket
FINE: -----------------------------------------------
May 28, 2009 11:39:02 AM org.apache.axis.transport.http.HTTPSender
readFromSocket
FINE: <?xml version="1.0" encoding="UTF-8"?><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/v13">46</responseTime>
<operations soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">1</operations>
<units soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">1</units>
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">c3c4ea8c6cc23fe0d2ac617cc7a7774e</requestId>
</soapenv:Header>
adwords/v13">c3c4ea8c6cc23fe0d2ac617cc7a7774e</requestId>
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultst
mariek
May 28, 2009, 4:51:50 AM5/28/09
to AdWords API Forum
I have exactly the same problem. Even if I don't include CLICKS
column. Here are my request and response logs:
POST /api/adwords/v13/ReportService HTTP/1.1
SOAPAction: ""
Content-Type: text/xml; charset=utf-8
User-Agent: SOAP4R/1.5.8 (httpclient.rb/269, ruby 1.8.7 (2008-08-11)
[i486-linux])
Date: Thu, 28 May 2009 08:48:13 GMT
Content-Length: 1508
Host: adwords.google.com
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Header>
<developerToken env:mustUnderstand="0">DEV_TOKEN</
developerToken>
<useragent env:mustUnderstand="0">USERAGENT</useragent>
<applicationToken env:mustUnderstand="0">TOKEN</
applicationToken>
<password env:mustUnderstand="0">PASSWORD</password>
<clientEmail env:mustUnderstand="0"></clientEmail>
<email env:mustUnderstand="0">EMAIL</email>
</env:Header>
<env:Body>
<n1:validateReportJob xmlns:n1="https://adwords.google.com/api/
adwords/v13">
<n1:job xsi:type="n1:DefinedReportJob">
<n1:clientEmails>CLIENT_EMAIL</n1:clientEmails>
<n1:crossClient>true</n1:crossClient>
<n1:endDay>2009-05-28</n1:endDay>
<n1:name>Report-2009-05-28T10:48:12+02:00</n1:name>
<n1:startDay>2009-05-28</n1:startDay>
<n1:aggregationTypes>Weekly</n1:aggregationTypes>
<n1:selectedColumns>AdGroupId</n1:selectedColumns>
<n1:selectedColumns>KeywordId</n1:selectedColumns>
<n1:selectedColumns>Keyword</n1:selectedColumns>
<n1:selectedColumns>ConversionName</n1:selectedColumns>
<n1:selectedReportType>Keyword</n1:selectedReportType>
</n1:job>
</n1:validateReportJob>
</env:Body>
</env:Envelope>
= Response
HTTP/1.1 500 Internal Server Error
Content-Type: text/xml; charset=utf-8
Date: Thu, 28 May 2009 08:48:14 GMT
Expires: Thu, 28 May 2009 08:48:14 GMT
Cache-Control: private, max-age=0
X-Content-Type-Options: nosniff
Content-Length: 1451
Server: GFE/2.0
<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>
faultstring>
<detail>
<ns1:fault xmlns:ns1="https://adwords.google.com/api/adwords/
v13">
<ns1:code>30</ns1:code>
<ns1:message>One or more report job parameters is invalid.</
ns1:message>
<ns1:trigger>The following columns are mutually exclusive :
[Clicks]</ns1:trigger>
</ns1:fault>
</detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>
column. Here are my request and response logs:
POST /api/adwords/v13/ReportService HTTP/1.1
SOAPAction: ""
Content-Type: text/xml; charset=utf-8
User-Agent: SOAP4R/1.5.8 (httpclient.rb/269, ruby 1.8.7 (2008-08-11)
[i486-linux])
Date: Thu, 28 May 2009 08:48:13 GMT
Content-Length: 1508
Host: adwords.google.com
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Header>
<developerToken env:mustUnderstand="0">DEV_TOKEN</
developerToken>
<useragent env:mustUnderstand="0">USERAGENT</useragent>
<applicationToken env:mustUnderstand="0">TOKEN</
applicationToken>
<password env:mustUnderstand="0">PASSWORD</password>
<clientEmail env:mustUnderstand="0"></clientEmail>
<email env:mustUnderstand="0">EMAIL</email>
</env:Header>
<env:Body>
<n1:validateReportJob xmlns:n1="https://adwords.google.com/api/
adwords/v13">
<n1:job xsi:type="n1:DefinedReportJob">
<n1:clientEmails>CLIENT_EMAIL</n1:clientEmails>
<n1:crossClient>true</n1:crossClient>
<n1:endDay>2009-05-28</n1:endDay>
<n1:name>Report-2009-05-28T10:48:12+02:00</n1:name>
<n1:startDay>2009-05-28</n1:startDay>
<n1:aggregationTypes>Weekly</n1:aggregationTypes>
<n1:selectedColumns>AdGroupId</n1:selectedColumns>
<n1:selectedColumns>KeywordId</n1:selectedColumns>
<n1:selectedColumns>Keyword</n1:selectedColumns>
<n1:selectedColumns>ConversionName</n1:selectedColumns>
<n1:selectedReportType>Keyword</n1:selectedReportType>
</n1:job>
</n1:validateReportJob>
</env:Body>
</env:Envelope>
= Response
HTTP/1.1 500 Internal Server Error
Content-Type: text/xml; charset=utf-8
Date: Thu, 28 May 2009 08:48:14 GMT
Expires: Thu, 28 May 2009 08:48:14 GMT
Cache-Control: private, max-age=0
X-Content-Type-Options: nosniff
Content-Length: 1451
Server: GFE/2.0
<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/v13">654</responseTime>
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
<operations soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">1</operations>
<units soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">1</units>
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">d2cf715d4842163f25759f5083ecc79e</requestId>
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">1</operations>
<units soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v13">1</units>
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
</soapenv:Header>
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>One or more report job parameters is invalid.</
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
faultstring>
<detail>
<ns1:fault xmlns:ns1="https://adwords.google.com/api/adwords/
v13">
<ns1:code>30</ns1:code>
<ns1:message>One or more report job parameters is invalid.</
ns1:message>
<ns1:trigger>The following columns are mutually exclusive :
[Clicks]</ns1:trigger>
</ns1:fault>
</detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>
AdWords API Advisor
May 28, 2009, 11:47:02 AM5/28/09
to AdWords API Forum
Hello,
Thanks for passing that along. The logs, especially mariek's which
shows that the Clicks column isn't even being requested, should be
enough for the Reports Engineering team to investigate what certainly
appears to be a bug.
I'll update this thread with more info when I have it.
Cheers,
-Jeff Posnick, AdWords API Team
Thanks for passing that along. The logs, especially mariek's which
shows that the Clicks column isn't even being requested, should be
enough for the Reports Engineering team to investigate what certainly
appears to be a bug.
I'll update this thread with more info when I have it.
Cheers,
-Jeff Posnick, AdWords API Team
AdWords API Advisor
May 29, 2009, 5:22:39 PM5/29/09
to AdWords API Forum
Hello,
The Reports Engineering team has confirmed that this behavior is a
bug, and is working on a resolution. Apologies for any inconvenience
this is causing developers in the meantime, and I'll continue to
update this thread with more info.
Cheers,
-Jeff Posnick, AdWords API Team
On May 28, 11:47 am, AdWords API Advisor
The Reports Engineering team has confirmed that this behavior is a
bug, and is working on a resolution. Apologies for any inconvenience
this is causing developers in the meantime, and I'll continue to
update this thread with more info.
Cheers,
-Jeff Posnick, AdWords API Team
Keporio
Jun 1, 2009, 12:23:09 AM6/1/09
to AdWords API Forum
Hi, Jeff
OK, we are waiting for the solution.
Since i mentioned that not only "clicks" is causing this problem, "#
of conversion" also cause this problem.
"Cost" "Impression" "Viewers" "CPC" "CPN" and "CPR" also cause this
problem.
They are all critiacal data for adwords service. and these data are
what google calls
"Performance Statistics : These columns feature data about how your
ads are performing "
in Add or Remove Columns plane in the page of report collection at
Google Adwords Account Create Report Page.
I hope this info will help your engineers to solve this problem.
Sincerely
On 5月30日, 午前5:22, AdWords API Advisor <adwordsapiadvi...@google.com>
OK, we are waiting for the solution.
Since i mentioned that not only "clicks" is causing this problem, "#
of conversion" also cause this problem.
"Cost" "Impression" "Viewers" "CPC" "CPN" and "CPR" also cause this
problem.
They are all critiacal data for adwords service. and these data are
what google calls
"Performance Statistics : These columns feature data about how your
ads are performing "
in Add or Remove Columns plane in the page of report collection at
Google Adwords Account Create Report Page.
I hope this info will help your engineers to solve this problem.
Sincerely
On 5月30日, 午前5:22, AdWords API Advisor <adwordsapiadvi...@google.com>
AdWords API Advisor
Jun 1, 2009, 7:03:18 PM6/1/09
to AdWords API Forum
Okay, so here's the rundown from the engineering team. It's a bit
complicated, unfortunately. We'll hopefully be able to express all
this concisely in the documentation for future reference.
There are two separate but related issues. First, regarding PPL's
example: if you request any of the ConversionCategory,
ConversionDescription, or ConversionName columns, you can't request
any of Impressions, Avg CPC, Clicks, Cost, CTR, or Avg Position, and
vice versa. This is an undocumented limitation of the reporting
backend, and you'll see it enforced if you try to schedule an
equivalent report using the AdWords web interface.
A little preface before the next issue. If you look at the report
documentation, you'll see that some columns are marked (attribute) and
some are marked (measure). Attribute columns are those that describe
basic properties, and measure columns are those that describe
calculated performance data.
The second issue is illustrated in mariek's example. The problem is
that all the columns requested (AdGroupId, KeywordId, Keyword,
ConversionName) are attribute columns. As it turns out, you can't run
a normal report with only attribute columns (that's what Structure
reports are intended for). Seeing this, the report service tries to
automatically include at least one measure column, namely Clicks. But,
as mentioned in the previous issue, the Clicks and ConversionName
columns are mutually exclusive, and that leads to the error you see.
The workaround would be to explicitly include at least one measure
column that's compatible with the ConversionName column, such as
Conversions.
Apologies that a confluence of arcane limitations and undocumented
behavior has led to this confusion. While the ReportService
automatically inserting the incompatible Clicks column is buggy
behavior, I believe the best course of action right now is to work
around it as described above.
Cheers,
-Jeff Posnick, AdWords API Team
complicated, unfortunately. We'll hopefully be able to express all
this concisely in the documentation for future reference.
There are two separate but related issues. First, regarding PPL's
example: if you request any of the ConversionCategory,
ConversionDescription, or ConversionName columns, you can't request
any of Impressions, Avg CPC, Clicks, Cost, CTR, or Avg Position, and
vice versa. This is an undocumented limitation of the reporting
backend, and you'll see it enforced if you try to schedule an
equivalent report using the AdWords web interface.
A little preface before the next issue. If you look at the report
documentation, you'll see that some columns are marked (attribute) and
some are marked (measure). Attribute columns are those that describe
basic properties, and measure columns are those that describe
calculated performance data.
The second issue is illustrated in mariek's example. The problem is
that all the columns requested (AdGroupId, KeywordId, Keyword,
ConversionName) are attribute columns. As it turns out, you can't run
a normal report with only attribute columns (that's what Structure
reports are intended for). Seeing this, the report service tries to
automatically include at least one measure column, namely Clicks. But,
as mentioned in the previous issue, the Clicks and ConversionName
columns are mutually exclusive, and that leads to the error you see.
The workaround would be to explicitly include at least one measure
column that's compatible with the ConversionName column, such as
Conversions.
Apologies that a confluence of arcane limitations and undocumented
behavior has led to this confusion. While the ReportService
automatically inserting the incompatible Clicks column is buggy
behavior, I believe the best course of action right now is to work
around it as described above.
Cheers,
-Jeff Posnick, AdWords API Team
mariek
Jun 9, 2009, 3:37:20 AM6/9/09
to AdWords API Forum
Thank You for response, as You suggested I got proper report
definition after defining it with web interface and it works
definition after defining it with web interface and it works
Reply all
Reply to author
Forward
0 new messages