Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

like image 708
Arthur Vandeley Avatar asked Mar 19 '23 20:03

Arthur Vandeley


1 Answers

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.

like image 115
Ryan Praskievicz Avatar answered Apr 25 '23 16:04

Ryan Praskievicz