Hi Jeff, Can you ensure that there are no deleted campaigns in the account that have Mobile or Local Business Ads? I believe that having the ads in a deleted campaign would also allow the column to be validated.
As for the general functionality, I understand your concern with the current way column validation works. I will pass this information on to the core engineering team for further consideration. Best, - Eric On Nov 22, 7:01 pm, kc <karthik.chandrasekha...@gmail.com> wrote: > Eric > > Thanks for your reply last week. > > Unfortunately, your updated assertion still doesn't seem to be > correct. I have an example of an account which has only one campaign > that owns 2 text ads and does not have an associated MCC attached to > it - yet I AM able to successfully request a Creative Structure report > for it with both BusinessName and BusinessAddress included in the > request message. However, I have other similar accounts for which the > request fails. > > Re your statement "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" - can I say that, in my opinion, I consider this to be an > inappropriate way to provide support for a report. If a report is > capable of returning columns "1" thru "X" then the requestor should > ALWAYS be able to ask for any columns regardless of the data > circumstances of a particular account. If a column is inappropriate > for a particular circumstance then it would be better to simply return > a blank value for the column. The Creative Structure report is a > prime example of where this behaviour would be far more appropriate - > how and why should the requestor know in advance what type of ads have > been defined for an account? Given that this report contains the > field CreativeType, the requestor should make use of this field to > determine whether other columns in the returned report are appropriate > or not. > > Regards, > Jeff > On Nov 17, 4:17 am, AdWords API Advisor <adwordsapiadvi...@google.com> > wrote: > > > > > 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>... > > 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=.
