Invalid XML

[di...@easyleads.com]

Hi,

For several accounts I get a bad formatted XML, it happens only for one row (I think random) in the report.

I'm using v201605 and can't upgrade to later version since we still use Converted Clicks.

I'm downloading CAMPAIGN_PERFORMANCE_REPORT with the following columns:

<columns>

<column name='campaignID' display='Campaign ID'/>

<column name='cost' display='Cost'/>

<column name='clicks' display='Clicks'/>

<column name='impressions' display='Impressions'/>

<column name='convertedClicks' display='Converted clicks'/>

<column name='conversions' display='Conversions'/>

<column name='day' display='Day'/>

<column name='searchLostISBudget' display='Search Lost IS (budget)'/>

<column name='contentLostISBudget' display='Content Lost IS (budget)'/>

<column name='contentImprShare' display='Content Impr. share'/>

<column name='searchImprShare' display='Search Impr. share'/>

<column name='searchLostISRank' display='Search Lost IS (rank)'/>

<column name='contentLostISRank' display='Content Lost IS (rank)'/>

<column name='phoneCalls' display='Phone calls'/>

<column name='totalConvValue' display='Total conv. value'/>

</columns>

Result example:

<row campaignID='XXXXX' cost='18660000' clicks='22' impressions='19851' convertedClicks='0' conversions='0.0' day='2016-09-19' searchLostISBudget='--' contentLostISBudget='0.02%' contentImprShare='&lt; 10%' searchImprShare='--' searchLostISRank='--' contentLostISRank='&gt; 90%' phoneCalls='0' totalConvValue='0.0'/>

<row campaignID='XXXXX' cost='35140000' clicks='44' impressions='32699' convertedClicks='0' conversions='0.0' day='2016-09-17' searchLostISBudget='--' contentLostISBudget='0.00%' contentImprShare='&lt; 10%' searchImprShare='--' searchLostISRank='--' contentLostISRank='&gt; 90%' phoneCalls='0' totalConvValue='0.0'/>

<row campaignID='XXXXX' cost='2690000' clicks='5' impressions='3365' convertedClicks='0' conversions='0.0' day='2016-09-25' searchLostISBudget='--' contentLostISBudget='0.00%' contentImprShare='&lt; 10%' searchImprShare='--' searchLostISRank='--' contentLostISRank='&gt; 90%' phoneCalls='0' totalConvValue='0.0'/>

<row campaignID='XXXXX' cost='13480000' clicks='22' impressions='19020' convertedClicks='0' conversions='0.0' day='2016-09-08' searchLost.66%' contentImprShare='15.51%' searchImprShare='--' searchLostISRank='--' contentLostISRank='49.83%' phoneCalls='0' totalConvValue='0.0'/>

<row campaignID='XXXXX' cost='10200000' clicks='8' impressions='1796' convertedClicks='0' conversions='0.0' day='2016-09-07' searchLostISBudget='--' contentLostISBudget='49.03%' contentImprShare='15.50%' searchImprShare='--' searchLostISRank='--' contentLostISRank='35.46%' phoneCalls='0' totalConvValue='0.0'/>

<row campaignID='XXXXX' cost='0' clicks='0' impressions='188' convertedClicks='0' conversions='0.0' day='2016-09-12' searchLostISBudget='--' contentLostISBudget='22.37%' contentImprShare='15.10%' searchImprShare='--' searchLostISRank='--' contentLostISRank='62.53%' phoneCalls='0' totalConvValue='0.0'/>

This XML is invalid due to the 4th row:

Attribute name "searchLost.66" associated with an element type "row" must be followed by the ' = ' character

What is the problem? Known issue?

Thanks

[Shwetha Vastrad (AdWords API Team)]

Hi,

Could you provide the complete report definition used along with a sample clientCustomerId where you observed this? I see the fields selected from the Campaign Performance Report, but did you use any predicates in the report definition? I also observed that the row in question is missing the "contentLostISBudget" attribute in addition to the incorrectly formatted "searchLostISBudget" attribute. Do you observe this happening for other fields in other report types, or is it isolated to Campaign Performance report? 

Thanks,

Shwetha, AdWords API Team.

[Zweitze]

Hi,

That's a weird report - it seems a few dozen characters just disappeared.

We get reports with broken XML too, usually the report just stops in the middle. To work with this, whenever we get problems with parsing XML, we just wait 30 seconds and download the report again. This is usually sufficient.

So, see if you can retry the request to get better results? If that doesn't help but you have more findings, will you let us know?

Thanks!