Re: Problem in downloading Ad performance Report of file size above 500MB
Hi Shibu, We too faced the same memory load issue when parsing an big XML file, but we have overcome this problem by using SAX Parser API. The other APIs like SAX Builder will load the whole 500MB file into memory and try to parse which leads to memory load. But this SAXParser doesn't load the file into ram but visits file multiple times for each record. Try this solution. On Mon, May 12, 2014 at 11:14 PM, Anash P. Oommen (AdWords API Team) adwordsapiadvisor+an...@google.com wrote: Hi Shibu, 524MB is a big xml, you might want to increase the memory on your machine, or consider an alternate format like CSV for downloading the reports. Cheers, Anash P. Oommen, AdWords API Advisor. On Thursday, May 8, 2014 8:51:40 AM UTC-7, shibu thomas wrote: Hi - I've successfully been able to create report definitions (Ad Performance Report and Keyword Performance Report) and when I log into the MCC account I'm able to run the reports and it returns with appropriate data. However, when I attempt to download the report via the reportdownload API (v201402), I got an error message and the download process is stopped .The downloaded Report has file size above 524MB .No problem for downloading smaller reports. I've followed the errors- *Warning*: simplexml_load_file(): Memory allocation failed : building node in file name *Warning*: simplexml_load_file(): reports/reportname.xml:1: error: xmlSAX2StartElementNs: out of memory *Warning*: simplexml_load_file(): reports/reportname.xml:1: parser error : Extra content at the end of the document in Any help would be appreciated. Shibu Thomas -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups AdWords API Forum group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups AdWords API Forum group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Problem in downloading Ad performance Report of file size above 500MB
Hi Shibu, 524MB is a big xml, you might want to increase the memory on your machine, or consider an alternate format like CSV for downloading the reports. Cheers, Anash P. Oommen, AdWords API Advisor. On Thursday, May 8, 2014 8:51:40 AM UTC-7, shibu thomas wrote: Hi - I've successfully been able to create report definitions (Ad Performance Report and Keyword Performance Report) and when I log into the MCC account I'm able to run the reports and it returns with appropriate data. However, when I attempt to download the report via the reportdownload API (v201402), I got an error message and the download process is stopped .The downloaded Report has file size above 524MB .No problem for downloading smaller reports. I've followed the errors- *Warning*: simplexml_load_file(): Memory allocation failed : building node in file name *Warning*: simplexml_load_file(): reports/reportname.xml:1: error: xmlSAX2StartElementNs: out of memory *Warning*: simplexml_load_file(): reports/reportname.xml:1: parser error : Extra content at the end of the document in Any help would be appreciated. Shibu Thomas -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups AdWords API Forum group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Problem in downloading Ad performance Report of file size above 500MB
Shibu, Did you call simplexml_load_file directly or was that called from the client library? To process a large amount of XML files, you may want to take a streaming approach instead in order to avoid memory issues. We also recommend users to get data in smaller chunks with smaller date range and narrower predicates. Thanks, Ray On Thursday, May 8, 2014 11:51:40 AM UTC-4, shibu thomas wrote: Hi - I've successfully been able to create report definitions (Ad Performance Report and Keyword Performance Report) and when I log into the MCC account I'm able to run the reports and it returns with appropriate data. However, when I attempt to download the report via the reportdownload API (v201402), I got an error message and the download process is stopped .The downloaded Report has file size above 524MB .No problem for downloading smaller reports. I've followed the errors- *Warning*: simplexml_load_file(): Memory allocation failed : building node in file name *Warning*: simplexml_load_file(): reports/reportname.xml:1: error: xmlSAX2StartElementNs: out of memory *Warning*: simplexml_load_file(): reports/reportname.xml:1: parser error : Extra content at the end of the document in Any help would be appreciated. Shibu Thomas -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups AdWords API Forum group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Problem at downloading Ad Performance Report
Hello Szabolcs, ACTIVE is not a valid status, see: https://developers.google.com/adwords/api/docs/appendix/reports#ad Try predicate: :predicates = [ {:field = 'Status', :operator = 'IN', :values = ['ENABLED', 'PAUSED']} ] Also, note predicates should be an array. -Danial, AdWords API Team. On Friday, September 20, 2013 9:43:50 PM UTC+4, Szabolcs Pal wrote: Hey all, I have problems retrieving Ad Performance Report when adding a predicate to the selector fields. I get a AdwordsApi::Errors::ReportXmlError. My ad report definition is as follows (I'm using the ruby client library v201302): ad_report_definition = { :selector = { :fields = fields, :predicates = { :field = 'Status', :operator = 'IN', :values = ['ACTIVE', 'PAUSED'] }, :date_range = { :min = start_date.gsub('-',''), :max = end_date.gsub('-','') } }, :report_name = 'Custom AD_PERFORMANCE_REPORT', :report_type = 'AD_PERFORMANCE_REPORT', :date_range_type = 'CUSTOM_DATE', :download_format = 'CSV', :include_zero_impressions = true } I wanted to include paused ads in the report, because it seems they are not included by default so I added the predicate with the Status condition, but this change breaks the report request. If I remove the :predicate part the request finishes successfully. Any ideas what I might be missing/misconfiguring? Thanks, Szabolcs. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups AdWords API Forum group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.