I'm getting this error inside of CSV reports !!!1|||3333344|||Unexpected exception??? for most but not all of the accounts that I am trying to pull ad performance report data for. Some of the reports come back ok, and some give me the above error one minute, and good content a few minutes later.
Here is a sample of the SOAP request to define the report <?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/v201008"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <soapenv:Header> <v20:RequestHeader> <v20:authToken>xx </ v20:authToken> <v20:developerToken>xx</v20:developerToken> <v20:userAgent>V2010 Get Ad Performance</v20:userAgent> <v20:clientEmail>xx</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>Headline</ v20:fields> <v20:fields>Date</v20:fields> <v20:fields>Id</v20:fields> <v20:fields>Impressions</v20:fields> <v20:fields>Clicks</v20:fields> <v20:fields>Cost</v20:fields> <v20:fields>Ctr</v20:fields> <v20:fields>AverageCpc</v20:fields> <v20:fields>MaxCpc</v20:fields> <v20:fields>Status</v20:fields> <v20:fields>IsNegative</v20:fields> <v20:fields>Conversions</v20:fields> <v20:fields>AdGroupName</ v20:fields> <v20:fields>CampaignName</v20:fields> <v20:fields>AdGroupId</v20:fields> <v20:fields>CampaignId</v20:fields> <v20:fields>Url</v20:fields> <v20:fields>CostPerConversionManyPerClick</v20:fields> <v20:fields>ConversionsManyPerClick</v20:fields> <v20:fields>ConversionRateManyPerClick</v20:fields> <v20:fields>AveragePosition</v20:fields> <v20:fields>ConversionRate</ v20:fields> <v20:fields>CostPerConversion</v20:fields> <v20:fields>AdNetworkType1</v20:fields> <v20:fields>AdNetworkType2</ v20:fields> <v20:fields>AdType</v20:fields> <v20:dateRange> <v20:min>20101118</v20:min> <v20:max>20101118</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>CSV</v20:downloadFormat> </v20:operand> </ v20:operations> </v20:mutate> </soapenv:Body> </soapenv:Envelope> Here is the response: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/ envelope/"><soap:Header><ResponseHeader xmlns="https:// adwords.google.com/api/adwords/cm/ v201008"><requestId>c63c936ae836f3b8fe42a98985d6da03</ requestId><operations>1</operations><responseTime>466</ responseTime><units>400</units></ResponseHeader></ soap:Header><soap:Body><mutateResponse xmlns="https:// adwords.google.com/api/adwords/cm/v201008"><rval><id>5775744</ id><selector><fields>Headline</fields><fields>Date</fields><fields>Id</ fields><fields>Impressions</fields><fields>Clicks</ fields><fields>Cost</fields><fields>Ctr</fields><fields>AverageCpc</ fields><fields>MaxCpc</fields><fields>Status</ fields><fields>IsNegative</fields><fields>Conversions</ fields><fields>AdGroupName</fields><fields>CampaignName</ fields><fields>AdGroupId</fields><fields>CampaignId</ fields><fields>Url</fields><fields>CostPerConversionManyPerClick</ fields><fields>ConversionsManyPerClick</ fields><fields>ConversionRateManyPerClick</ fields><fields>AveragePosition</fields><fields>ConversionRate</ fields><fields>CostPerConversion</fields><fields>AdNetworkType1</ fields><fields>AdNetworkType2</fields><fields>AdType</ fields><dateRange><min>20101118</min><max>20101118</max></dateRange></ selector><reportName>Ad Perf Rpt</ reportName><reportType>AD_PERFORMANCE_REPORT</ reportType><hasAttachment>false</ hasAttachment><dateRangeType>CUSTOM_DATE</ dateRangeType><downloadFormat>CSV</ downloadFormat><creationTime>20101119 053523 America/Los_Angeles</ creationTime></rval></mutateResponse></soap:Body></soap:Envelope> Here is the download URL: https://adwords.google.com/api/adwords/reportdownload?__rd=5775744 which comes back with http status of 200 OK but the CSV file is 40 bytes and has the above error string in it. The report definition response has no errors in it. Eh? thanks, -reed -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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
