Kerching - spot on. I was running against an empty sandbox, testing the reporting requests.
I'd have expected an empty report, not a syntax error. That's an awfully convoluted error diagnostic :) Thanks for your help and insight. Cheers, JeremyC. On Sep 23, 8:08 pm, AdWords API Advisor <[EMAIL PROTECTED]> wrote: > Hello Jeremy, > > If you're going against the Sandbox environment, could you confirm > that you actually have campaigns, ad groups, and keywords with CPC > bidding set up in the specific Sandbox account against which you're > running the report? I'm not able to reproduce the issue when I run the > same report definition against a test Sandbox account that has an > account structure already set up. > > Cheers, > -Jeff Posnick, AdWords API Team > > On Sep 23, 9:48 am,JezC<[EMAIL PROTECTED]> wrote: > > > Thanks - but surely MaximumCPC *does* make sense for a Keyword > > Structure Report? I can see that Maximum CPM could be a failure... But > > MaxCPC is a valid property of a keyword? > > > Cheers, JeremyC. > > > On Sep 22, 5:09 pm, AdWords API Advisor <[EMAIL PROTECTED]> > > wrote: > > > > Hello Jeremy, > > > > Please see > > > > http://groups.google.com/group/adwords-api/browse_thread/thread/db6db... > > > > 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 -~----------~----~----~----~------~----~------~--~---
