Re: Downloading KEYWORD PERFORMANCE REPORT through AdWords API is slow for TSV files
Hi Kumar, I am able to download a report using the report definition you provided in CSV and TSV formats successfully. Could you try increasing the readTimeout for report downloads or use predicates to break up the report request into multiple, smaller requests? You could consider submitting multiple requests that each filter for a subset of Campaign IDs. Thanks, Shwetha, AdWords API Team. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/a01828c6-c7eb-4fcc-bcf6-1ea8c9f442f4%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Downloading KEYWORD PERFORMANCE REPORT through AdWords API is slow for TSV files
includeZeroImpressions = true, ReportDefinitionDateRangeType.YESTERDAY As you can see above, typically I try and retrieve just yesterday's data. I also set includeZeroImpressions to TRUE because we would like to track the behavior of all keywords historically. Setting it to FALSE gives me a relatively smaller dataset (in the hundreds) and it is typically faster due to the size. On Tuesday, September 26, 2017 at 12:59:49 PM UTC-6, Shwetha Vastrad (AdWords API Team) wrote: > > Hi Kumar, > > Could you provide the DateRange used in the report request? Have you set > the includeZeroImpressions header to true? > > Thanks, > Shwetha, AdWords API Team. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/8895ff6a-71e8-49b8-b914-ad31edb527d9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Downloading KEYWORD PERFORMANCE REPORT through AdWords API is slow for TSV files
Hi Kumar, Could you provide the DateRange used in the report request? Have you set the includeZeroImpressions header to true? Thanks, Shwetha, AdWords API Team. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/45dea04b-7ae4-4c50-89ea-90cbe341c8eb%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Downloading KEYWORD PERFORMANCE REPORT through AdWords API is slow for TSV files
Hi Shwetha, I have sent a private message with the report definition and the clientCustomerId. Let me know what you find. Thank you! Kumar On Wednesday, September 20, 2017 at 3:03:06 PM UTC-6, Shwetha Vastrad (AdWords API Team) wrote: > > Hi Kumar, > > Could you provide the compete report definition along with the > clientCustomerId for which you are trying to download the Keyword > Performance Report? The report download request may time out on extremely > large data sets. There is no explicit data size limit; however, the server > may return an error if the report is too large. Could you try a shorter > date range or use predicates to break up the report request into multiple, > smaller requests? > > Thanks, > Shwetha, AdWords API Team. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/8be36371-fd29-4bd6-893f-754cc4517f2a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Downloading KEYWORD PERFORMANCE REPORT through AdWords API is slow for TSV files
Hi Kumar, Could you provide the compete report definition along with the clientCustomerId for which you are trying to download the Keyword Performance Report? The report download request may time out on extremely large data sets. There is no explicit data size limit; however, the server may return an error if the report is too large. Could you try a shorter date range or use predicates to break up the report request into multiple, smaller requests? Thanks, Shwetha, AdWords API Team. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ac959c11-2897-4ce7-9c4a-58101caae898%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Downloading KEYWORD PERFORMANCE REPORT through AdWords API is slow for TSV files
1down votefavorite <https://stackoverflow.com/questions/46247646/downloading-keyword-performance-report-through-adwords-api-is-slow-for-tsv-files?noredirect=1#> I have tried to download the *KEYWORD PERFORMANCE* REPORT through AdWords API in TSV & XML formats and it is crawling to finish and sometimes even times out. reportDefinition.setDownloadFormat(DownloadFormat.TSV) The same report works well when I use the CSV format and the job finishes in about 5 minutes. reportDefinition.setDownloadFormat(DownloadFormat.CSV) In both cases, I am talking about 2.2 million records that I am trying to download through the report. Also, just as a side note, the same TSV worked well with API version 2014 and I am currently using the latest version of the API. import com.google.api.ads.adwords.lib.utils.v201708.ReportDownloader I could use the CSV format, but the issue is that some of the fields/columns in the downloaded report contain "commas" and it gets quite messy dealing with all that upstream. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/c37fc7fc-ac87-49bf-8dde-6c73573871b6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.