Eric,

We are also experiencing the same problem but when we switch to using
a sub-MCC.  So our structure looks like

Main MCC
  Sub MCC #1
    Account #1
      ...
        MobileAd
    Account #2
    Account #3
      ...
        MobileAd
  Sub MCC #2
    ...

When we submit the report request using the Main MCC credentials,
everything works fine.  We are not providing the clientEmail header,
but are providing the clientEmail in the report request along with
crossClient set to true.  When we switch to using Sub MCC #1, the
report request fails with the BusinessName column error.

Let me know if you need us to provide the captured SOAP requests and
responses to provide another data point.  Our collection vague
recollection was that there was something that had to be set at the
MCC level, but that "feature" was removed in subsequent releases of
AdWords.

I agree with Jeff's assertion that "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."  This, I feel, is a problem that plagues the
Report API as we have encountered similar problems with
LocalBusinessAds to the point that we have had to remove support for
this from our product.  I understand they are legacy and we were
fortunate that none of our clients were using them.  Saying that we
should catch the exception and then remove columns from the report
request increases the complexity of our code and puts a lot of burden
on us trying to figure out undocumented behaviors of the API.

Thanks.

-Eric T.

On Nov 25, 1:33 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> Hi Jeff,
>
> I'll pass this information on to our core engineering team to see if
> they can pinpoint the cause of this issue.  I can't say if or when
> this issue will be resolved, and in the mean time I would recommend
> working around the issue using one of the suggestions we discussed
> previously.
>
> Best,
> - Eric
>
> On Nov 25, 1:54 am, Ayup <ehupj...@gmail.com> wrote:
>
> > Hi Eric
>
> > Email sent
>
> > Regards,
> > Jeff
>
> > On Nov 25, 7:22 am, AdWords API Advisor <adwordsapiadvi...@google.com>
> > wrote:
>
> > > Hi Jeff,
>
> > > At this point it probably makes sense for me to look at these two
> > > campaigns in more detail.  Please email the campaign IDs to
> > > adwordsapiadvi...@google.com and update this thread after you have
> > > done so.
>
> > > Thanks,
> > > - Eric
>
> > > On Nov 23, 10:15 pm, Ayup <ehupj...@gmail.com> wrote:
>
> > > > Hi Eric
>
> > > > Confirming that there are no deleted campaigns in the account for
> > > > which the report was successfully run.
>
> > > > Regards,
> > > > Jeff
>
> > > > On Nov 24, 8:22 am, AdWords API Advisor <adwordsapiadvi...@google.com>
> > > > wrote:
>
> > > > > Hi Jeff,
>
> > > > > Can you ensure that there are no deleted campaigns in the account that
> > > > > haveMobileor 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 thatMobileAds 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 (HasMobileAds)
> > > > > > > - Account #2 (Has NoMobileAds)
>
> > > > > > > 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 oneMobileAdit 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 aMobileAd.
>
> > > > > > > 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, pausedMobileAdin every account.
> > > > > > > 3) Schedule all reports from an MCC account that has at least one
> > > > > > > account with aMobileAd.
>
> > > > > > > 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 anyadgroups 
> > > > > > > > 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 forMobileAds, which make use of the BusinessName
> > > > > > > > field when the "click-to-call" attribute is defined for thead.  
> > > > > > > > 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 BusinessAd.  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 retrievemobileads 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 formobileads. There are no Local 
> > > > > > > > > > Business or
> > > > > > > > > >Mobileads 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
>
> ...
>
> 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=en.


Reply via email to