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 <[email protected]> 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 <[email protected]> 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: [email protected] > > > On Nov 3, 10:20 pm, AdWords API Advisor <[email protected]> > > 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 <[email protected]> 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: [email protected] > > > On Nov 3, 10:20 pm, AdWords API Advisor <[email protected]> > > 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 <[email protected]> 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 > > ... > > 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=.
