How export more than 5000 rows from google analytics to an excel

Question

I am trying to export more than 5000 rows to an excel sheet from google analytics, but I am not able to do so. I have searched a lot about it in google andtried the url modification which replaces explorer-table.rowCount%3D5000 with explorer-table.rowCount%3D50000. But it's not working for me. It still returns 5000 rows only. Please help. Thanks in advance

Answer 1

Here are some options to pull more than 5000 rows from Google Analytics.

1) Use the Google Analytics Query Explorer to pull 10,000 rows (API query max). Set the max-results to 10,000. Use the start-index to pull additional 10k row chunks (set start index to 10,001 then 20,001 then 30,001 etc.

2) Use the Google Analytics Sheets Add-On to pull 10,000 rows.

3) Use Python to pull data 10,000 rows at a time via the Google Analytics API. Here is a solution that will let you pull over 1 million rows unsampled from Google Analytics using Python.

4) Use an Excel Connector tool like Analytics Edge to pull up to 1 million rows of data from Google Analytics.