When working in Google Analytics and trying to export more than 500 you face a problem where you cant export more than 500 rows of data. This is a problem for user with no access to Google Analytics tools for keyword expansion. A quick and easy way around this is by changing the URL. This is very useful if you want to export for example a large number of non-paid keywords and adding them to your PPC campaigns.If you have thousands of rows that require multiple exports, you can use the convenient workaround below to export all your rows in one go.
This should give you 5000 rows of data in the CSV file.