Sunday, October 30, 2011

View and export more than 500 rows of data in Google Analytics

Google Analytics provides a maximum of 500 rows of data per page. This applies to all data within Google Analytics, such as , keywords, referrers, content pages etc.  Sometimes, the need comes to view and export more than 500 rows of data in a single page.

Google says that full data can be exported when we export as CSV.
But, sometimes, we need to see the maximum data in the web interface itself.

More than 500 rows can be fetched easily.Even Google officially recommends this for advanced users.
Remember that this trick no longer works in the older GA version. This will only work out in the newer GA version.
First,we need to get to the report page where we want more than 500 rows.Then change the row count from the default 10 to 500.

Screenshot of Google Analytics Keywords Page - Address bar parameter is highlighted in green
Notice the green highlighted area, it contains the parameter called explorer-table.rowCount%3D500

Change this 500 number to any number that is needed.Here, i am changing it into 600. You can change it into 6000, if your analytics profile has that much data.
Dont forget to press "Enter" after modifying this number.

Now, the page will display 600 rows, as in below screenshot.

No comments:

Post a Comment