Unsupported BusinessName and BusinessAddress columns on Creative Summary report

[Eric]

This report request worked yesterday. Today it stopped working. I've
double checked the documentation and don't see any reason why these
columns cannot be requested.

Thanks.

-Eric

----- request -----
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header>
<ns1:useragent xmlns:ns1="https://adwords.google.com/api/adwords/
v13" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0">XXX</ns1:useragent>
<ns2:email xmlns:ns2="https://adwords.google.com/api/adwords/v13"
soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0">XXX</ns2:email>
<ns3:password xmlns:ns3="https://adwords.google.com/api/adwords/
v13" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0">XXX</ns3:password>
<ns4:developerToken xmlns:ns4="https://adwords.google.com/api/
adwords/v13" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0">XXX</ns4:developerToken>
<ns5:applicationToken xmlns:ns5="https://adwords.google.com/api/
adwords/v13" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0">XXX</ns5:applicationToken>
</soapenv:Header>
<soapenv:Body>
<validateReportJob xmlns="https://adwords.google.com/api/adwords/
v13">
<job xmlns:ns6="https://adwords.google.com/api/adwords/v13"
xsi:type="ns6:DefinedReportJob">
<ns6:clientEmails xsi:type="xsd:string">XXX</ns6:clientEmails>
<ns6:crossClient xsi:type="xsd:boolean">true</ns6:crossClient>
<ns6:endDay xsi:type="xsd:date">2009-03-14</ns6:endDay>
<ns6:name xsi:type="xsd:string">XXX</ns6:name>
<ns6:startDay xsi:type="xsd:date">2009-03-14</ns6:startDay>
<ns6:aggregationTypes xsi:type="xsd:string">Summary</
ns6:aggregationTypes>
<ns6:selectedColumns xsi:type="xsd:string">CampaignId</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">CampaignStatus</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">Campaign</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">AdWordsType</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">DailyBudget</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">AdGroupId</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">AdGroupStatus</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">AdGroup</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">MaxContentCPC</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">CreativeId</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">AdStatus</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">CreativeType</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">CreativeDestUrl</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">DescriptionLine1</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">DescriptionLine2</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">DescriptionLine3</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">VisibleUrl</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">BusinessName</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">PhoneNo</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">ImageAdName</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">ImageHostingKey</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">BusinessAddress</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">Preview</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">KeywordId</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">KeywordStatus</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">KeywordTypeDisplay</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">Keyword</
ns6:selectedColumns>
<ns6:selectedColumns
xsi:type="xsd:string">KeywordDestUrlDisplay</ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">MaximumCPC</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">MaximumCPM</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">FirstPageCpc</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">QualityScore</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">BottomPosition</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">TopPosition</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">Impressions</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">DestinationURL</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">Clicks</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">Cost</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">AveragePosition</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">CPC</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">CPM</
ns6:selectedColumns>
<ns6:selectedColumns xsi:type="xsd:string">CTR</
ns6:selectedColumns>
<ns6:selectedReportType xsi:type="xsd:string">Creative</
ns6:selectedReportType>
</job>
</validateReportJob>
</soapenv:Body>
</soapenv:Envelope>

----- response -----
<?xml version="1.0"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header>
<responseTime xmlns="https://adwords.google.com/api/adwords/v13"
soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0">230</responseTime>
<operations xmlns="https://adwords.google.com/api/adwords/v13"
soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0">1</operations>
<units xmlns="https://adwords.google.com/api/adwords/v13"
soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0">1</units>
<requestId xmlns="https://adwords.google.com/api/adwords/v13"
soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0">59effbf4a34b2a96d6c1acc9d86a6915</
requestId>
</soapenv:Header>
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>One or more report job parameters is invalid.</
faultstring>
<detail>
<ns1:fault xmlns:ns1="https://adwords.google.com/api/adwords/
v13">
<ns1:code>30</ns1:code>
<ns1:message>One or more report job parameters is invalid.</
ns1:message>
<ns1:trigger> The following columns are not supported by the
Report Type Creative : [BusinessName, BusinessAddress]</ns1:trigger>
</ns1:fault>
</detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

[AdWords API Advisor]

Hello Eric,

Did something recently change with your MCC account structure, or
were you previously using different MCC credentials in your report?
Based on some experiments I just tried, it looks like those two
columns are flagged as being invalid when they're requested as part of
a cross-client MCC report run under the context of a sub-MCC (i.e. an
MCC that has another MCC as a parent). When I grabbed your MCC's
address from our logs it does correspond to a sub-MCC.

In any case, it certainly sounds like a bug in the ReportService to
me, and I've asked the reports engineering team to investigate. I'll
let you know what I hear. In the meantime, excluding those two columns
or making the request from your top-level MCC should work around the
problem.

Cheers,
-Jeff Posnick, AdWords API Team

[AdWords API Advisor]

Hello,

To follow up on this, what I heard back from the reports engineering
team is that those columns are only valid if the MCC account from
which you run the report has a child AdWords account underneath it
that has at least one local business ad. Apparently it does not matter
whether you're actually including that child AdWords account as a
target for the report in question; it's simply the existence of it
that enables the BusinessName and BusinessAddress columns as being
valid for a given MCC.

This is obviously not intuitive, and is very similar to the old issue
that was recently resolved which made all the CPM columns invalid
unless there was at least one CPM campaign in your account. The logic
was changed to unconditionally allow CPM columns, but I don't think
that a similar change is going to be made for the Business* columns.
I've pinged the documentation team to ask them to reflect this in the
docs, at least.

Cheers,
-Jeff Posnick, AdWords API Team

On Mar 23, 10:59 am, AdWords API Advisor

[Eric]

Jeff,

We appreciate the followup.

Do you have any indication why this would work for four months and
then stop working? Also, this report request fails on only two out of
ten MCCs. We don't believe the other 8 MCCs have accounts with at

least one local business ad.

On our end, we will look more closely at the MCCs and the accounts and
look for something odd related to your findings.

Thanks.

-Eric

On May 11, 1:50 pm, AdWords API Advisor <adwordsapiadvi...@google.com>

> ...
>
> read more »

[AdWords API Advisor]

Hello Eric,

Based on what the reports engineering team told me, one potential
reason that this problem might have suddenly arose is if a AdWords
account that had a local business ad was just unlinked from your MCCs,
or if the local business ads were deleted.

Now that I have the reports engineering team's ear regarding the
issue, I'd be happy to pass along any counter-examples that you could
identify in your account structure.

Cheers,
-Jeff Posnick, AdWords API Team

> ...
>
> read more »