历史数据的非抽样报告自动化 [英] Unsampled reports automation for historical data

问题描述

我们有一个客户每天有 2-4 百万次访问，所以我们只能得到非抽样报告，因为它超过了谷歌的限制:

We have a client who receives 2-4 million visits a day, so off the bat we can only get unsampled reports because it exceeds google's limit :

数据尚未存储的特殊查询的最大会话数为 500,000.

500,000 maximum sessions for special queries where the data is not already stored.

我们正在尝试收集为期 1 天的唯一身份访问者和访问次数.事实证明，在对数据进行采样时，使用 Google API 是轻而易举的.

We are attempting to collect Unique Visitors and Visits for a 1 day period. Using the Google API has proved frivolous as the data is sampled.

我们每天都会设置非抽样报告，这些报告会转储到 Google 云端硬盘中，我们的应用程序会提取新文件并下载它们.我们遇到的问题是，20 份报告需要 2 年的每日数据.我们可以使用谷歌分析网络界面运行非抽样报告的最大范围是超过查询限制前 1 周.因此，要设置 52 周 x 2 年 x 20 份不同的报告是 2080 份预定的非抽样报告，而且这仅适用于 1 个客户.

We have set up Unsampled reports on a daily basis that get dumped into Google Drive and our application picks up the new files and downloads them just fine. The problem we are running into is that we need 2 years worth of daily data for 20 reports. The maximum range we can run an unsampled report using google analytics web interface is 1 week before we exceed a query limit. So 52 weeks of reports x 2 years x 20 different reports to set up is 2080 scheduled unsampled reports and this is for 1 client only.

我们是否可以使用 GA API 或任何编程方法自动生成非抽样报告以提取具有前面提到的约束的历史数据?我们还有 Google Analytics Premium

Can we automate unsampled reports using GA API or any programming method to pull historical data with the constraints previously mentioned? Also we do have Google Analytics Premium

推荐答案

Cris G，在无法访问 Premium 的情况下避免在 Google Analytics 中进行数据采样的唯一方法是分时段技术 = 您将数据请求拆分为将选定的时间段转换为较短的时间段查询(通常是几天)，然后然后将所有数字相加.如果您查看每日数字时未对您的个人资料/浏览量进行抽样，这可以解决您的问题.

Cris G, the only way to avoid data-sampling in Google Analytics without having an access to Premium is day-parting technique = you split a data-request for selected time period into shorter period queries (typically days) and then add all the numbers up. If your profiles/views are not sampled if you look at daily numbers, this could solve you issue.

但是，这不适用于唯一身份访问者，因为他们每次都是唯一的(您每天都在运行数据请求)，因此很可能会出现重复和夸大的总数如果您的网站吸引了大量回访者.

However, this doesn't work on Unique Visitors, since they will be unique every single time (you are running data requests on daily basis), so there will be most likely duplicates and inflated totals if your site is attracting lots of returning visitors.

为了自动化某些工作，我建议使用诸如 Analytics Canvas.它可以让您的生活更轻松，我认为它可能是满足您需求的完美工具.请记住关于唯一身份访问者(以及其他一些指标)的限制.

To automate some of the work, I suggest using tools like Analytics Canvas. It can make your life much easier and I think it could be the perfect tool for what you need to. Bear in mind the limitations about unique visitors (and some other metrics).

话虽如此，我仍然认为最好的选择是利用 Premium 的优势以及为您的报告获取非抽样数据的能力.

Having said that, I still think the best choice would be to use the benefits of Premium and the ability to get unsampled data for your reports.

这篇关于历史数据的非抽样报告自动化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！