Hello Jeremy, Please see
http://groups.google.com/group/adwords-api/browse_thread/thread/db6dbf408597789/d4bf495934b62ec6 The reports team is definitely aware that this behavior is very developer-unfriendly. While there obviously hasn't been any visible progress towards a cleaner system for dealing with invalid columns in report scheduling requests, it hasn't been forgotten. Cheers, -Jeff Posnick, AdWords API Team On Sep 21, 7:58 am, JezC <[EMAIL PROTECTED]> wrote: > I've just started using the Ruby API - adwords4r. I'm having a > Structure Report problem. > > If I take the example code from the latest adwords4r version, and > amend one line in reports.rb to: > > job.selectedColumns = %w{Campaign AdGroup Keyword KeywordTypeDisplay > MaximumCPC MaximumCPM} > > This should add two columns, for the MaxCPC and MaxCPM described > inhttp://www.google.com/apis/adwords/developer/adwords_api_report_struc... > > I have changed this pair to other values from the same table, and they > work. > > I've set adwords.preferences to point to the sandbox and have changed > the various strings (they have been replaced by "[EMAIL PROTECTED]" below, > etc). The unamended version works, the versions with other values for > the selected columns work, only this pair fail to allow the job to be > queued, AFAICS. > > When I run the revised reports.rb with MaximumCPC and MaximumCPM, I > get an error: > > The following columns are not supported by the Report Type Structure : > [MaximumCPC, MaximumCPM] > > I have the SOAP debug output for the request: > > <?xml version="1.0" encoding="utf-8" ?> > <env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema"; > xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> > <env:Header> > <version env:mustUnderstand="0">v12</version> > <developerToken env:mustUnderstand="0">[EMAIL PROTECTED]</ > developerToken> > <useragent env:mustUnderstand="0">Some Random String</ > useragent> > <applicationToken env:mustUnderstand="0">another random > string</applicationToken> > <password env:mustUnderstand="0">DreamOn</password> > <clientEmail env:mustUnderstand="0">[EMAIL PROTECTED]</ > clientEmail> > <email env:mustUnderstand="0">[EMAIL PROTECTED]</email> > </env:Header> > <env:Body> > <n1:validateReportJob xmlns:n1="https://adwords.google.com/api/ > adwords/v12"> > <n1:job xsi:type="n1:DefinedReportJob"> > <n1:endDay>2008-01-31</n1:endDay> > <n1:name>Report-2008-09-21T12:47:18+01:00</n1:name> > <n1:startDay>2008-01-01</n1:startDay> > <n1:aggregationTypes>Keyword</n1:aggregationTypes> > <n1:selectedColumns>Campaign</n1:selectedColumns> > <n1:selectedColumns>AdGroup</n1:selectedColumns> > <n1:selectedColumns>Keyword</n1:selectedColumns> > <n1:selectedColumns>KeywordTypeDisplay</n1:selectedColumns> > <n1:selectedColumns>MaximumCPC</n1:selectedColumns> > <n1:selectedColumns>MaximumCPM</n1:selectedColumns> > <n1:selectedReportType>Structure</n1:selectedReportType> > </n1:job> > </n1:validateReportJob> > </env:Body> > </env:Envelope> > > and the 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">37</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">a66500b167cd7341b5043dcb43759eb7</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> The following columns are not supported by the > Report Type Structure : [MaximumCPC, MaximumCPM]</ns1:trigger> > > </ns1:fault> > > </detail> > > </soapenv:Fault> > </soapenv:Body> > </soapenv:Envelope> > > I currently believe that there is a documentation error. :) > > Cheers, JeremyC. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en -~----------~----~----~----~------~----~------~--~---
