creative structure report error : BusinessName, BusinessAddress
saurabh purnaye
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: psau...@live.com
AdWords API Advisor
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
saurabh purnaye
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
On Nov 3, 10:20 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
wrote:
AdWords API Advisor
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
>
> read more »
Ayup
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>
>
> read more »
AdWords API Advisor
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
>
> read more »
kc
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
schedule that report doesn't include at least one object that returns
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>
>
> read more »
AdWords API Advisor
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
>
> read more »
Ayup
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>
>
> read more »
AdWords API Advisor
At this point it probably makes sense for me to look at these two
campaigns in more detail. Please email the campaign IDs to
adwordsa...@google.com and update this thread after you have
done so.
Thanks,
- Eric
>
> read more »
Ayup
Email sent
Regards,
Jeff
On Nov 25, 7:22 am, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> Hi Jeff,
>
> campaigns in more detail. Please email the campaign IDs to
>
> read more »
AdWords API Advisor
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
>
> read more »
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:
> > > > > haveMobileor Local Business Ads? I believe that having the ads in a
> > > > > > > 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 »
AdWords API Advisor
I would like to investigate this further, could please email me the
account IDs of the accounts in question, as well as some sample SOAP
requests that demonstrate the issue? Please send them to
adwordsa...@google.com and then update this thread so I know to
check that mailbox.
Best,
- Eric K.
> > > > > > > > > would hope that this...
>
> read more »
Eric
information necessary to pursue it. However, I attended the AdWords
API Hack Day in SF and talked to Adam and Stan about the general
problem of undocumented ReportService behavior. As discussed in this
thread, we would like the ReportService to not fail if we don't have
something of a particular type in order to use a particular column.
We would simply like the ReportService to just leave the cell blank if
the column does not apply to the data. Can you please remind Adam and
Stan to check that the v2009 ReportService does not carry along this
behavior?
Thanks.
-Eric T.
On Dec 22 2009, 7:14 am, AdWords API Advisor
<adwordsapiadvi...@google.com> wrote:
> Hi Eric,
>
> I would like to investigate this further, could please email me the
> account IDs of the accounts in question, as well as some sample SOAP
> requests that demonstrate the issue? Please send them to
> adwordsapiadvi...@google.com and then update this thread so I know to
> check that mailbox.
>
> Best,
> - Eric K.
>
> On Dec 18, 1:16 pm, Eric <wetr...@gmail.com> wrote:
>
> > 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 theBusinessNamecolumn error.
> > > > > > > > for it with bothBusinessNameand BusinessAddress included in the
> > > > > > > > > used theBusinessNamecolumn, 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 theBusinessNamecolumn 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
> > > > > > > > >BusinessNamecolumn try to schedule the report again removing that
> ...
>
> read more »
AdWords API Advisor
I'm glad you were able to attend the event and get some of your
questions answered. I'll pass this on to Stan and Adam and relay any
information they find.
Best,
- Eric K.
> > > > > > > > > > > The first point to make is that for...
>
> read more »