How export more than 5000 rows from google analyti

问题:

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

回答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.

回答2:

As a fairly frequent GA user, I can confirm that the replacement of "D500" to "D100000" in the URL used to work fine for me, minus the occasional browser crashing, but now now matter what I change that value to, I still can only get a max of 5000 rows. Not sure when specifically, but I'm pretty sure I was able to use the workaround ~6 months ago.

回答3:

Google were recently pushing Premium Analytics at me, but at $150,000 per annum it's a non-starter. But I suspect, like the curse of data sampling (there's no sampling with Premium), they are endeavouring to make the free version slightly less usable by quietly putting a block on that old export modifier trick. It used to work fine for me, but no more.