UPDATE: Google Analytics now gives you up to 5000 rows, so you don’t need to do this trick unless you have > 5,000 rows in a report. Thanks, Goog!
When you create a report in Google Analytics (GA), the interface limits you to 500 rows. You can get around that limit though. Your browser will probably give out before you hit the limit of rows you can export from a GA report. Mine normally starts coughing up blood at about 30,000 rows.
But here’s what to do:
Step 1: Change the Show rows drop-down in the bottom-right corner of your report from 10 to 25.
Step 2: Take note of how many line items you need to export. In the example of the screenshot above, we would need at least 6001, although I usually include extra for good measure.
Step 3: Look at very end of the report URL. You’ll see table.rowCount%3D25/. Change that 25 to however many rows you need and press Enter (Mac: Return).
Step 4: Click Export > CSV from the top drop-down menu.