BiqQuery vs Google Analytics，哪些数据更准确？ [英] BiqQuery vs Google Analytics, which data is more accurate?
问题描述
我倾向于倾向于倾向因为我们实际上可以看到原始数据，但是我们没有深入了解Google Analyitcs用于计算其数量的方法。我也认为很多都与SAMPLING有关。
当您为单个页面计算一些简单的总页面浏览量时，Google Analytics数字与中的BigQuery排列在一起0.00001％：
总和（case regexp_match（hits.page.pagepath，r'（？i：/contact.aspx）' ）和hits.type =pagethen 1 else 0 end）as total_pageviews
当您为单个页面计算更复杂的内容时， Google Analytics数据比BigQuery大5％。请注意，它是采样最大1百万：
count（distinct（case when regexp_match（hits.page.pagepath，r'（？i：/ contact.aspx）'）和hits.type =page，然后concat（fullvisitorid，string（visitid））end），1000000）作为unique_pageviews
I希望了解别人的想法或Google开发人员自己可以解释的内容。 这就成了你对很多数据有很大的了解。 Google Analytics API会在您的数据很多时对您的数据进行采样，这可以通过提高采样级别来尝试和预防。即使将采样级别设置为高精度，您仍然可以从API获取采样数据。
检查Json从API返回，它会告诉你，如果你的数据正在被抽样。
Big Query不会对您的数据进行抽样，有一种方法可以让优质客户使用带抽样数据的API，但我认为您必须联系Google关于设置。
Big Queries支持的重点在于，您不仅限于7个维度，还有10个指标（如Google Analytics API）。
注意：我不是Google开发者，但我是Google Analytics专家。
As a Premium Google Analytics/BigQuery customer, our question is, Which data is more accurate?
I tend to want to lean toward BigQuery being more accurate because we can actually see the raw data, but we have no insight into the method Google Analyitcs is using to calculate its numbers.
I also think that a lot of it has to do with SAMPLING.
When you calculate something simple like Total Pageviews for a single page, the Google Analytics numbers line up to BigQuery within .00001%:
sum(case when regexp_match(hits.page.pagepath,r'(?i:/contact.aspx)') and hits.type = "page" then 1 else 0 end) as total_pageviews
When you calculate something more complex like Unique Pageviews for a single page, Google Analytics numbers are 5% greater than BigQuery. Note that it is sampling by the max 1 Million:
count(distinct (case when regexp_match(hits.page.pagepath,r'(?i:/contact.aspx)') and hits.type = "page" then concat(fullvisitorid, string(visitid)) end), 1000000) as unique_pageviews
I would love to know what others think or what the Google Developers themselves can explain.
If you are a premium customer I am assuming that's becomes you have a large sight with a lot of data. The Google Analytics API will sample your data if there's to much, this is something you can try and prevent by putting the sampling level up. Even with the sampling level set to high precision you will still get sampled data back from the API.
Check the Json coming back from the API, it will tell you if your data is being sampled.
Big Query wont sample your data, there is a way for premium customers to use the API with out sampling data but I think you have to contact Google about setting that up.
The bigger point in Big Queries favor is that you aren't limited to 7 dimensions and 10 metrics like you are with the Google Analytics API.
Note: I am not a Google Developer but I am a Google Developer Expert for Google Analytics.
这篇关于BiqQuery vs Google Analytics，哪些数据更准确？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
