如何导出完整的 Google Analytics 历史数据? [英] How to export complete Google Analytics historical data?
问题描述
在访问将被关闭之前，我有几天时间从 Google Analytics 帐户导出所有历史数据.需要注意的是，您不能将历史数据(在撰写本文时)从一个 Google Analytics 帐户迁移到另一个帐户.我特别想为 Excel 进行编程，或者更好地获得有关其他人使用过的内容的指导.
我以前从未这样做过，所以想伸出手看看其他人使用了什么?除非别无选择，否则想要避免使用 Google Analytics Data Export API.一个非常活跃的网站有大约 5 年的数据.
更新
当时我决定手动移动信息是最好的方法.可能会有新的解决方案，请参阅下面的链接.
可能对其他人有帮助的相关参考资料:
帐户合并和数据移动选项
Developers.Google.Com - Google 开发指南
我们可以将 Google Analytics 数据移动到其他帐户吗?
从 Google Analytics 导出数据 - 尽量避免 API
Google Analytics 应用程序库 - 应用列表，有人使用这些吗?
您不能(无论如何都不能使用免费版本的 GA).您可以通过 API 导出汇总报告(标准报告最多 50 000 行，即席(非预先计算)报告最多 200 000 行，您可以通过自己编写脚本或使用 Next Analytics 之类的工具(来自应用程序库我自己使用过.但是对于 5 年的数据，您在某个时候会达到 Google API 的礼节限制.而且我不确定当您无法获得原始数据时导出有多大帮助.
来自 google 的数据解放可能包含有关此主题的更新信息 https:///sites.google.com/a/dataliberation.org/www/google/analytics
I was given a few days to export all the historical data from a Google Analytics account before access will be shutoff. Important to note that you cannot migrate historical data (at the time of this post) from one Google Analytics account to another. I would specifically like to program this for Excel or better yet get guidance on what others have used.
I have never done this before so wanted to reach out and see what others have used? Wanted to avoid the Google Analytics Data Export API unless there was no other option. There is about 5 years of data for a very active site.
Update
I decided moving the information manually was the best route to go at that time. There may be new solutions, see links below.
Related references that may be helpful to others:
Account merge and data move options
Developers.Google.Com - Google Dev Guide
Can we move Google Analytics data to other account?
Exporting Data from Google Analytics - Trying to avoid the API
Google Analytics Application Gallery - Apps list, anyone use these?
You can't (not with the free version of GA in any case). You can export aggregated reports (with up to 50 000 rows for standard reports or 200 000 rows for ad-hoc (not pre-calculated) reports via the API either by scripting yourself or using a tool like Next Analytics (the only programm from the Application Gallery I have used myself). But with 5 years of data you will at some point hit the courtesy limits for the Google API. And I'm not sure how helpful the exports are when you cannot get at the raw data.
Data Liberation from google may contanin updated info about this topic https://sites.google.com/a/dataliberation.org/www/google/analytics
这篇关于如何导出完整的 Google Analytics 历史数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
