I found myself need to download about 30,000 from an Analytics report recently. Anaytics provides some great info but I needed to join up some of the data with a MySQL database to get a more in depth analysis of what was going on with one of my web projects. Much to my chagrin it looked like Analytics will only give 500 lines in a report.
A little sleuthing in Google groups dug up some posts that have a tip on getting past the 500 line barrier. Just add “&limit=50000” to the Google Analytics URL and you’ll have up to 50,000 lines in your downloaded report. I’ve tried more that that’s as much as they’ll give you.