如何从Google Analytics(分析)汇出5000多行到Excel [英] How export more than 5000 rows from google analytics to an excel

问题描述

我正在尝试从Google Analytics(分析)中将5000多行数据导出到Excel工作表中，但我无法这样做.我在Google中搜索了很多相关内容，并尝试了将explorer-table.rowCount%3D5000替换为explorer-table.rowCount%3D50000的url修改.但这对我不起作用.它仍然仅返回5000行.请帮忙.预先感谢

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

推荐答案

以下是一些从Google Analytics(分析)中提取5000多行的选项.

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

1)使用Google Analytics(分析)查询资源管理器提取10,000行(最大API查询).将最大结果设置为10,000.使用起始索引来拉取额外的1万行数据块(将起始索引设置为10,001，然后是20,001，然后是30,001，等等.

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)使用 Google Analytics(分析)表添加-打开以拉出10,000行.

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

3)使用Python通过Google Analytics(分析)API一次提取10,000行数据.这是一个解决方案，可让您将超过100万个使用Python从Google Analytics(分析)中未采样的行.

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)使用Google Analytics(分析)边缘之类的Excel连接器工具从Google Analytics(分析)中提取多达100万行数据.

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

这篇关于如何从Google Analytics(分析)汇出5000多行到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！