Hello, To follow up on this, what I heard back from the reports engineering team is that those columns are only valid if the MCC account from which you run the report has a child AdWords account underneath it that has at least one local business ad. Apparently it does not matter whether you're actually including that child AdWords account as a target for the report in question; it's simply the existence of it that enables the BusinessName and BusinessAddress columns as being valid for a given MCC.
This is obviously not intuitive, and is very similar to the old issue that was recently resolved which made all the CPM columns invalid unless there was at least one CPM campaign in your account. The logic was changed to unconditionally allow CPM columns, but I don't think that a similar change is going to be made for the Business* columns. I've pinged the documentation team to ask them to reflect this in the docs, at least. Cheers, -Jeff Posnick, AdWords API Team On Mar 23, 10:59 am, AdWords API Advisor <[email protected]> wrote: > Hello Eric, > > Did something recently change with your MCC account structure, or > were you previously using different MCC credentials in your report? > Based on some experiments I just tried, it looks like those two > columns are flagged as being invalid when they're requested as part of > a cross-client MCC report run under the context of a sub-MCC (i.e. an > MCC that has another MCC as a parent). When I grabbed your MCC's > address from our logs it does correspond to a sub-MCC. > > In any case, it certainly sounds like a bug in the ReportService to > me, and I've asked the reports engineering team to investigate. I'll > let you know what I hear. In the meantime, excluding those two columns > or making the request from your top-level MCC should work around the > problem. > > Cheers, > -Jeff Posnick, AdWords API Team > > On Mar 20, 6:54 pm, Eric <[email protected]> wrote: > > > This report request worked yesterday. Today it stopped working. I've > > double checked the documentation and don't see any reason why these > > columns cannot be requested. > > > Thanks. > > > -Eric > > > ----- request ----- > > <?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">XXX</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">XXX</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">XXX</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">XXX</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">XXX</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">XXX</ns6:clientEmails> > > <ns6:crossClient xsi:type="xsd:boolean">true</ns6:crossClient> > > <ns6:endDay xsi:type="xsd:date">2009-03-14</ns6:endDay> > > <ns6:name xsi:type="xsd:string">XXX</ns6:name> > > <ns6:startDay xsi:type="xsd:date">2009-03-14</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">BusinessAddress</ > > 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> > > > ----- response ----- > > <?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">230</responseTime> > > <operations xmlns="https://adwords.google.com/api/adwords/v13"; > > soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; > > soapenv:mustUnderstand="0">1</operations> > > <units xmlns="https://adwords.google.com/api/adwords/v13"; > > soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; > > soapenv:mustUnderstand="0">1</units> > > <requestId xmlns="https://adwords.google.com/api/adwords/v13"; > > soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"; > > soapenv:mustUnderstand="0">59effbf4a34b2a96d6c1acc9d86a6915</ > > 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 not supported by the > > Report Type Creative : [BusinessName, BusinessAddress]</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 [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 -~----------~----~----~----~------~----~------~--~---
