Skip the download limit for Google Analytics exports
Tuesday, September 8th, 2009 | Greasemonkey
It’s a well-known solution to have more rows in your Google Analytics reports export. Just add &limit=50000 to the URL and you will have 50000 rows (or change to the number of rows you want).
To skip this time consuming step I wrote a small Greasemonkey script. Have fun!
4 Comments to Skip the download limit for Google Analytics exports
The export is limited to 50000 rows. If you have to export more than 50000 rows, add &limit=50000 to the url and hit enter, type 50001 in the go to row box and hit enter. Now you can export row 50001 to 100000
March 5, 2010 at 21:06
I needed that but in the e-mailing part.
Limit is no recognized but theres other place with the mail row limit. You can find TROWS now with 5000 that I changed. You can still find the &limit but it does nothing.
The best part is that TROWS is always present so you shoul change this instead of adding the &limit, i believe.
reporting/setup_email?id=554371
&pdr=20100304-20100304
&cmp=average
&trows=5000
&gdfmt=nth_day
&rpt=TopContentReport
&segkey=request_uri
&tst=0
&afs=false
&fmt=0
&limit=5000#lts=1267814938515
March 5, 2010 at 22:20
Skipping the download limit works only for CSV (not CSV for Excel) and TSV export or email
Thanks, Yoon!
Leave a comment
About Arjan
Hi, I'm Arjan Snaterse and in my daily life I'm working as SEO and Frontend manager at Jaludo.
There I'm working on casual gaming sites like Funny games and Titter girl games.
In my spare time I'm developing websites in Wordpress or Typolight. HTML standards, semantics and CSS are words that make me happy. So if you need someone who converts your design (PSD) to HTML/Wordpress just contact me.
- Teun van der Hoek: Exactly what I was looking for! Thnx! ... Guia de Negocios: I´ll try it out!! Great tip!Arjan: @Willem Indeed, that's a cool idea and i...Willem: Geweldige tool! Wat ik er nog aan toe z...Arjan: Thanks ;-)
September 9, 2009 at 0:21