Hello Eric, Based on what the reports engineering team told me, one potential reason that this problem might have suddenly arose is if a AdWords account that had a local business ad was just unlinked from your MCCs, or if the local business ads were deleted.
Now that I have the reports engineering team's ear regarding the issue, I'd be happy to pass along any counter-examples that you could identify in your account structure. Cheers, -Jeff Posnick, AdWords API Team On May 12, 11:34 am, Eric <[email protected]> wrote: > Jeff, > > We appreciate the followup. > > Do you have any indication why this would work for four months and > then stop working? Also, this report request fails on only two out of > ten MCCs. We don't believe the other 8 MCCs have accounts with at > least one local business ad. > > On our end, we will look more closely at the MCCs and the accounts and > look for something odd related to your findings. > > Thanks. > > -Eric > > On May 11, 1:50 pm, AdWords API Advisor <[email protected]> > wrote: > > > 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 > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
