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 On Jun 1, 12:23 am, Keporio <kepo...@gmail.com> wrote: > 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> > wrote: > > > > > 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 > > > <adwordsapiadvi...@google.com> wrote: > > > 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 > > > > On May 28, 4:51 am, mariek <marek.byt...@gmail.com> wrote: > > > > > 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> > > > > <responseTime soapenv:actor="http://schemas.xmlsoap.org/soap/actor/ > > > > next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/ > > > > adwords/v13">654</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">d2cf715d4842163f25759f5083ecc79e</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/ > > > > 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> --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
