Error in Ad Performance Report

[chris h]

If I query requesting all fields, I get an xml load error

'adID' is a duplicate attribute name

[chris h]

As an experiment, I removed the field ID from the report definition,
and now get error:

!!!Unexpected exception|||1581255

[chris h]

Nore Info. Putting ID field back in query, the results have:

<table>
<columns>
<column name='impressions' display='Impressions'/>
<column name='clicks' display='Clicks'/>
<column name='cost' display='Cost'/>
<column name='avgCPC' display='Avg. CPC'/>
<column name='avgCPM' display='Avg. CPM'/>
<column name='avgposition' display='Avg. position'/>
<column name='convrate1perclick' display='Conv. rate (1-per-
click)'/>
<column name='convratemanyperclick' display='Conv. rate (many-
per-click)'/>
<column name='conv1perclick' display='Conv. (1-per-click)'/>
<column name='convmanyperclick' display='Conv. (many-per-click)'/
>
<column name='ctr' display='CTR'/>
<column name='costconv1perclick' display='Cost / conv. (1-per-
click)'/>
<column name='costconvmanyperclick' display='Cost / conv. (many-
per-click)'/>
<column name='adID' display='Ad ID'/>
<column name='adtype' display='Ad type'/>
<column name='adformat' display='Ad format'/>
<column name='ad' display='Ad'/>
<column name='descriptionline1' display='Description line 1'/>
<column name='descriptionline2' display='Description line 2'/>
<column name='imageadname' display='Image ad name'/>
<column name='visibleURL' display='Visible URL'/>
<column name='destinationURL' display='Destination URL'/>
<column name='state' display='State'/>
<column name='adID' display='Ad ID'/>
</columns>
<row impressions='0' clicks='0' cost='$0.00' avgCPC='$0.00'
avgCPM='$0.00' avgposition='0.0' convrate1perclick='0.00%'
convratemanyperclick='0.00%' conv1perclick='0' convmanyperclick='0'
ctr='0.00%' costconv1perclick='$0.00' costconvmanyperclick='$0.00'
adID='12996778' adtype='Text ad' adformat='text/narrow'
ad='Headline:XXXXXXX' descriptionline1='XXXXXXX'
descriptionline2='XXXXXXXXX' imageadname='' visibleURL='XXXXXX'
destinationURL='XXXXXXXXXXXX' state='disabled' adID='13609158'/>

So two Google API bugs here
1. duplicate column
2. cannot query without Id field

[Reed]

I was seeing this all day yesterday, and was about to post about it
when you did your posting. But today it seems to be working - if I
leave out "<v20:fields>Id</v20:fields>" from the selector, I get back
a valid xml document that includes the adID value. Yesterday I was
getting the exact behavior you posted, and noticed that when it sent
me back two adIDs when I included Id in the selector, they were not
the same value on any of the rows.

It still seems to be sporadic, sometimes it happens, sometimes it
doesn't. I tried it again and got
!!!Unexpected exception|||1641975
This seems to only happen when I include "<v20:fields>Headline</
v20:fields>" in the selector. I can include the Description1/2 and
have no problems, but whenever the headline is in there, I get the
error. If it helps, the Id that is returned from the report
definition call is 1643535, and the SOAP request is


<?xml version="1.0" encoding="UTF-8"?> <soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:v20="https://adwords.google.com/api/adwords/cm/v201003"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header> <v20:RequestHeader> <v20:authToken>xyzzy</
v20:authToken> <v20:developerToken>xyzzy</v20:developerToken>
<v20:userAgent> V2010 Get Report Fields</v20:userAgent>
<v20:clientEmail>xyzzy</v20:clientEmail> </v20:RequestHeader> </
soapenv:Header> <soapenv:Body> <v20:mutate> <v20:operations
xsi:type="v20:ReportDefinitionOperation"> <v20:operator>ADD</
v20:operator> <v20:operand> <v20:selector> <v20:fields>Status</
v20:fields> <v20:fields>AdGroupId</v20:fields>
<v20:fields>Impressions</v20:fields> <v20:fields>Clicks</v20:fields>
<v20:fields>Cost</v20:fields> <v20:fields>Conversions</v20:fields>
<v20:fields>CostPerConversionManyPerClick</v20:fields>
<v20:fields>ConversionsManyPerClick</v20:fields>
<v20:fields>ConversionRateManyPerClick</v20:fields>
<v20:fields>DisplayUrl</v20:fields> <v20:fields>Url</v20:fields>
<v20:fields>Ctr</v20:fields> <v20:fields>AverageCpc</v20:fields>
<v20:fields>AveragePosition</v20:fields> <v20:fields>ConversionRate</
v20:fields> <v20:fields>CostPerConversion</v20:fields>
<v20:fields>Description2</v20:fields> <v20:fields>Description1</
v20:fields> <v20:fields>Headline</v20:fields> <v20:dateRange>
<v20:min>20100708</v20:min> <v20:max>20100708</v20:max> </
v20:dateRange> </v20:selector> <v20:reportName>Ad Perf Rpt</
v20:reportName> <v20:reportType>AD_PERFORMANCE_REPORT</v20:reportType>
<v20:dateRangeType>CUSTOM_DATE</v20:dateRangeType>
<v20:downloadFormat>XML</v20:downloadFormat> </v20:operand> </
v20:operations> </v20:mutate> </soapenv:Body> </soapenv:Envelope>

[rayden]

I`m having the same problems.

Noone from AdWords is anwsering this question. Any idea?

Best,
Luka Orehek

On Jul 9, 7:55 pm, Reed <r...@PowellGenealogy.com> wrote:
> I was seeing this all day yesterday, and was about to post about it
> when you did your posting.  But today it seems to be working - if I
> leave out "<v20:fields>Id</v20:fields>" from the selector, I get back

> a valid xml document that includes theadIDvalue.  Yesterday I was

[AdWords API Advisor]

Hi All,

The problem with duplicate adID attributes in the XML is known, and
the core engineering team is working on a resolution. In the mean
time, try excluding the "Id" field from your selector, since it should
be inserted automatically. As for the
"Unexpected exception" errors, you may want to retry your request
after that happens, as that seemed to work for me in some cases.

Best,
- Eric Koleda, AdWords API Team