Hi Jeff, Thank you for doing such thorough testing and for providing a detailed description of your findings. I wasn't aware that Mobile Ads also used the BusinessName column, so my advice about MCC and Local Business Ads wasn't completely accurate for your circumstance. The general rule still applies though, which is that you cannot include a column in a report if the account used to schedule that report doesn't include at least one object that returns that column.
For example, let's take the following account structure: MCC: - Account #1 (Has Mobile Ads) - Account #2 (Has No Mobile Ads) If you try to schedule a report using the BusinessName column you'll have the following results: - As Account #1 => SUCCESS - As Account #2 => ERROR - As MCC using clientEmail header for Account #1 => SUCCESS - As MCC using clientEmail header for Account #2 => ERROR - As MCC using no clientEmail header and using crossClient option => SUCCESS Since Account #1 has at least one Mobile Ad it can include this column, but since Account #2 does not have any it will return an error. Using an MCC account with a clientEmail specified is the same as logging in with the Account directly. Using an MCC account with no clientEmail but using the crossClient option works as long as one of the client accounts of the MCC includes a Mobile Ad. As for how to handle this in your application, there are a few possibilities: 1) When scheduling a report, catch the exception about the BusinessName column try to schedule the report again removing that column. 2) Include a dummy, paused Mobile Ad in every account. 3) Schedule all reports from an MCC account that has at least one account with a Mobile Ad. Let me know if you have any other questions. Best, - Eric On Nov 12, 9:53 pm, Ayup <ehupj...@gmail.com> wrote: > Hi Eric > > I work with Saurabh and thought I'd chip in with some further > commentary on this one... > > Further to your assertion about an MCC account being a factor in this > issue, I have carried out some investigation against a number of > client accounts to determine if I can prove this. However, my > findings do not lead to this conclusion. > > The first point to make is that for ALL of the Creative Structure > report requests that I have made via the API, I have only ever made > use of the username/password login credentials that belong directly to > the client account - i.e. I have NOT submitted any requests using an > MCC login. However, in some but not all cases, an MCC login has been > granted access to the client account. > > Secondly, in all cases that I have tested, I am confident that there > are no Local Business Ads linked directly to any ad groups belonging > to the client accounts. > > Amongst the tests that I have carried out, I have found cases where > there is no MCC login linked to the client account, yet the report > request has succeeded. As such, I cannot determine what circumstances > lead to the report request being successful or not. Hence, I'd > appreciate it if you could provide further insight into this problem. > > On a broader note, it seems that Google has removed support for Local > Business Ads from the Adwords UI and that the V2009 API does not > support the creation of these ads. This obviously suggests that you > are moving support for these ads away from the Adwords product. As > such, this makes working around this issue with the Creative Structure > report rather difficult - particularly given that we would like to > provide support for Mobile Ads, which make use of the BusinessName > field when the "click-to-call" attribute is defined for the ad. I > would hope that this problem will be rectified when reporting > functionality is added to the V2009 API. Can you advise how we can > workaround this in the meantime? > > Regards, > Jeff > > On Nov 10, 2:53 am, AdWords API Advisor <adwordsapiadvi...@google.com> > wrote: > > > > > Hi Saurabh, > > > I believe that reports using BusinessName will succeed if they are > > scheduled using an MCC account which has at least one client account > > that has a Local Business Ad. Are you using a different MCC account > > when scheduling the failed reports? > > > Best, > > - Eric > > > On Nov 9, 4:10 am, saurabh purnaye <saurabh.purn...@gmail.com> wrote: > > > > Hi Eric, > > > Thanks for your reply. Here is more explanation about my problem, I am > > > trying to retrieve mobile ads from one of my accounts. When only > > > BusinessName is requested, the report request still fails even though > > > I have found from testing other accounts that BusinessName is used > > > when returning data for mobile ads. There are no Local Business or > > > Mobile ads present for the account for which my Creative Structure > > > report getting requested successfully. > > > Could you please help further here? > > > > -- > > > Thanks and Regards > > > Saurabh Purnaye > > > +91-9922071155 > > > skype: sorab_pune > > > yahoo & gtalk: saurabh.purnaye > > > msn: psaur...@live.com > > > > On Nov 3, 10:20 pm, AdWords API Advisor <adwordsapiadvi...@google.com> > > > wrote: > > > > > Hi Saurabh, > > > > > Those columns are only valid for accounts with Local Business Ads. If > > > > the account doesn't have any Local Business Ads the columns will be > > > > rejected. > > > > > Best, > > > > - Eric Koleda, AdWords API Team > > > > > On Oct 30, 5:52 am, saurabh purnaye <saurabh.purn...@gmail.com> wrote: > > > > > > Hi, > > > > > I have two accounts setup for adwords. I am trying to fetch the > > > > > creative structure report. This is failing with the issue of > > > > > The following columns are not supported by the Report Type Structure : > > > > > [BusinessName, BusinessAddress] > > > > > I have checked with both of the accounts, the setting seems to be > > > > > same, but one account fails for the fast fetch while other account > > > > > works well. > > > > > This is the request I am sending and getting failed > > > > > > <?xml version="1.0" encoding="UTF-8" ?> > > > > > - <SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema- > > > > > instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"; > > > > > xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"; > > > > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"; SOAP- > > > > > ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/";> > > > > > - <SOAP-ENV:Header> > > > > > <email xsi:type="xsd:string">XXXXXXXXXXXXXXXXX</email> > > > > > <password xsi:type="xsd:string">XXXXXXXXXXXXXXXXX</password> > > > > > <useragent xsi:type="xsd:string">Test user agent</useragent> > > > > > <developerToken xsi:type="xsd:string">XXXXXXXXXXXXXXXXX</ > > > > > developerToken> > > > > > <applicationToken xsi:type="xsd:string">XXXXXXXXXXXXXXXXX</ > > > > > applicationToken> > > > > > </SOAP-ENV:Header> > > > > > - <SOAP-ENV:Body> > > > > > - <scheduleReportJob> > > > > > - <CustomReportJob xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="DefinedReportJob"> > > > > > - <selectedColumns xsi:type="SOAP-ENC:Array" SOAP- > > > > > ENC:arrayType="xsd:string[19]"> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">CampaignId</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">Campaign</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">CampaignStatus</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">AdGroupId</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">AdGroup</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">AdGroupMaxContentCpc</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">AdGroupMaxCpc</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">AdGroupStatus</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">CreativeId</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">CreativeType</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">DescriptionLine1</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">DescriptionLine2</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">DescriptionLine3</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">BusinessAddress</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">BusinessName</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">PhoneNo</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">VisibleUrl</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">CreativeDestUrl</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="xsd:string">AdStatus</item> > > > > > </selectedColumns> > > > > > <selectedReportType xsi:type="xsd:string">Structure</ > > > > > selectedReportType> > > > > > - <campaigns xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="xsd:int > > > > > [1]"> > > > > > <item xsi:type="xsd:int">XXXXXXXXXX</item> > > > > > </campaigns> > > > > > <name xsi:type="xsd:string">Structure Report</name> > > > > > - <adGroupStatuses xsi:type="SOAP-ENC:Array" SOAP- > > > > > ENC:arrayType="AdGroupStatus[3]"> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="AdGroupStatus">Enabled</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="AdGroupStatus">Paused</item> > > > > > <item xmlns="https://adwords.google.com/api/adwords/v13"; > > > > > xsi:type="AdGroupStatus">Deleted</item> > > > > > </adGroupStatuses> > > > > > <aggregationTypes xsi:type="xsd:string">Creative</aggregationTypes> > > > > > </CustomReportJob> > > > > > </scheduleReportJob> > > > > > </SOAP-ENV:Body> > > > > > </SOAP-ENV:Envelope> > > > > > > -- > > > > > Thanks and Regards > > > > > Saurabh Purnaye > > > > > +91-9922071155 > > > > > skype: sorab_pune > > > > > yahoo & gtalk: saurabh.purnaye > > > > > msn: psaur...@live.com > > > > On Nov 3, 10:20 pm, AdWords API Advisor <adwordsapiadvi...@google.com> > > > wrote: > > > > > Hi Saurabh, > > > > > Those columns are only valid for accounts with Local Business Ads. If > > > > the account doesn't have any Local Business Ads the columns will be > > > > rejected. > > > > > Best, > > > > - Eric Koleda, AdWords API Team > > > > > On Oct 30, 5:52 am, saurabh purnaye <saurabh.purn...@gmail.com> wrote: > > > > > > Hi, > > > > > I have two accounts setup for adwords. I am trying to fetch the > > > > > creative structure report. This is failing with the issue of > > > > > The following columns are not supported by the Report Type Structure : > > > > > [BusinessName, BusinessAddress] > > > > > I have checked with both of the accounts, the setting seems to be > > > > > same, but one account fails for the fast fetch while other account > > > > > works well. > > > > > This is the request I am sending and getting failed > > > > > > <?xml version="1.0" encoding="UTF-8" ?> > > > > > - <SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema- > > > > > instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"; > > > > > xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"; > > ... > > 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 adwords-...@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=.
