On a daily basis, we gather performance reports for our clients. Up until a couple of weeks ago we were able to get approximately 1,500 accounts via about 15 MCCs. Over the past two weeks, we have only been able to get accounts under 4 of the MCCs. As far as we know, the MCCs have not changed nor our code (Java). Below is an example request (post validation through the ReportService) and response. Anybody else getting "Internal Server Errors" for report requests that used to work?
Based on a suggestion, we set cross client to false and removed client emails on the report request and set the clientEmail SOAP header. We get reports, but critical columns, specifically KeywordStatus, KeywordTypeDisplay, and Keyword are empty. 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.4 Host: adwords.google.com Cache-Control: no-cache Pragma: no-cache SOAPAction: "" Content-Length: 5045 <?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:useragent xmlns:ns1="https://adwords.google.com/api/adwords/ v13" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; soapenv:mustUnderstand="0">---</ns1:useragent> <ns2:email xmlns:ns2="https://adwords.google.com/api/adwords/v13"; soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; soapenv:mustUnderstand="0">---</ns2:email> <ns3:password xmlns:ns3="https://adwords.google.com/api/adwords/ v13" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; soapenv:mustUnderstand="0">---</ns3:password> <ns4:developerToken xmlns:ns4="https://adwords.google.com/api/ adwords/v13" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/ next" soapenv:mustUnderstand="0">---</ns4:developerToken> <ns5:applicationToken xmlns:ns5="https://adwords.google.com/api/ adwords/v13" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/ next" soapenv:mustUnderstand="0">---</ns5:applicationToken> </soapenv:Header> <soapenv:Body> <validateReportJob xmlns="https://adwords.google.com/api/adwords/ v13"> <job xmlns:ns6="https://adwords.google.com/api/adwords/v13"; xsi:type="ns6:DefinedReportJob"> <ns6:clientEmails xsi:type="xsd:string">---</ns6:clientEmails> <ns6:crossClient xsi:type="xsd:boolean">true</ns6:crossClient> <ns6:endDay xsi:type="xsd:date">2010-06-28</ns6:endDay> <ns6:name xsi:type="xsd:string">---</ns6:name> <ns6:startDay xsi:type="xsd:date">2010-06-28</ns6:startDay> <ns6:aggregationTypes xsi:type="xsd:string">Summary</ ns6:aggregationTypes> <ns6:selectedColumns xsi:type="xsd:string">CampaignId</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">CampaignStatus</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">Campaign</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">AdWordsType</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">DailyBudget</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">AdGroupId</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">AdGroupStatus</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">AdGroup</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">MaxContentCPC</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">CreativeId</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">AdStatus</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">CreativeType</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">CreativeDestUrl</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">DescriptionLine1</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">DescriptionLine2</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">DescriptionLine3</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">VisibleUrl</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">BusinessName</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">PhoneNo</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">ImageAdName</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">ImageHostingKey</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">Preview</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">KeywordId</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">KeywordStatus</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">KeywordTypeDisplay</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">Keyword</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">KeywordDestUrlDisplay</ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">MaximumCPC</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">MaximumCPM</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">FirstPageCpc</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">QualityScore</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">BottomPosition</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">TopPosition</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">Impressions</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">DestinationURL</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">Clicks</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">Cost</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">AveragePosition</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">CPC</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">CPM</ ns6:selectedColumns> <ns6:selectedColumns xsi:type="xsd:string">CTR</ ns6:selectedColumns> <ns6:selectedReportType xsi:type="xsd:string">Creative</ ns6:selectedReportType> </job> </validateReportJob> </soapenv:Body> </soapenv:Envelope> HTTP/1.0 500 Internal Server Error Content-Type text/xml; charset=utf-8 Date Wed, 30 Jun 2010 00:02:12 GMT Expires Wed, 30 Jun 2010 00:02:12 GMT Cache-Control private, max-age=0 X-Content-Type-Options nosniff X-Frame-Options SAMEORIGIN X-XSS-Protection 1; mode=block Server GSE no Content-Length XML received: ----------------------------------------------- <?xml version="1.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 xmlns="https://adwords.google.com/api/adwords/v13"; soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; soapenv:mustUnderstand="0">340</responseTime> <operations xmlns="https://adwords.google.com/api/adwords/v13"; soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; soapenv:mustUnderstand="0">0</operations> <units xmlns="https://adwords.google.com/api/adwords/v13"; soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; soapenv:mustUnderstand="0">0</units> <requestId xmlns="https://adwords.google.com/api/adwords/v13"; soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; soapenv:mustUnderstand="0">---</requestId> </soapenv:Header> <soapenv:Body> <soapenv:Fault> <faultcode>soapenv:Server.generalException</faultcode> <faultstring>An internal error has occurred. Please retry your request.</faultstring> <detail> <ns1:fault xmlns:ns1="https://adwords.google.com/api/adwords/ v13"> <ns1:code>0</ns1:code> <ns1:message>An internal error has occurred. Please retry your request.</ns1:message> </ns1:fault> </detail> </soapenv:Fault> </soapenv:Body> </soapenv:Envelope> -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
