The response data returned for Search Query Performance report using
v201109 API is incorrect for most of our clients' accounts.
The GZIPPED_XML response contains the following for matchType column
definition:
<column name='InvalidColumn_1' display=''/>
A data row looks like the following:
<row searchTerm='adobe web analytics' keywordID='22007851'
InvalidColumn_1='phrase' adGroupID='1132822265' campaignID='30340805'
adID='6930430805' clicks='1' impressions='6' cost='6230000' ctr='16.67%'
avgPosition='2.5' conv1PerClick='0' convRate1PerClick='0.00%'
convRateManyPerClick='0.00%' convManyPerClick='0' totalConvValue='0.0'
costConv1PerClick='0' costConvManyPerClick='0' valueConv1PerClick='0.0'
valueConvManyPerClick='0.0' viewThroughConv='0'/>
Notice that the response contains "InvalidColumn_1" in place of "matchType".
Below is request report definition XML:
<reportDefinition>
<selector>
<fields>Query</fields>
<fields>KeywordId</fields>
<fields>MatchType</fields>
<fields>AdGroupId</fields>
<fields>CampaignId</fields>
<fields>CreativeId</fields>
<fields>Clicks</fields>
<fields>Impressions</fields>
<fields>Cost</fields>
<fields>Ctr</fields>
<fields>AveragePosition</fields>
<fields>Conversions</fields>
<fields>ConversionRate</fields>
<fields>ConversionRateManyPerClick</fields>
<fields>ConversionsManyPerClick</fields>
<fields>ConversionValue</fields>
<fields>CostPerConversion</fields>
<fields>CostPerConversionManyPerClick</fields>
<fields>ValuePerConversion</fields>
<fields>ValuePerConversionManyPerClick</fields>
<fields>ViewThroughConversions</fields>
<dateRange>
<min>20120530</min>
<max>20120530</max>
</dateRange>
</selector>
<reportName>SearchQueryPerformanceReport</reportName>
<reportType>SEARCH_QUERY_PERFORMANCE_REPORT</reportType>
<dateRangeType>CUSTOM_DATE</dateRangeType>
<downloadFormat>GZIPPED_XML</downloadFormat>
</reportDefinition>
Please let us know the cause and solution for this issue.
Thanks.
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
