Google Big Query 页面查看计数与 GA 页面查看计数不匹配 [英] Google Big Query page view count does not match with GA page view count

问题描述

我正在尝试获取网站上预订页面的总浏览量.这是我的查询.

I am trying to get the count of total.pageviews of people go through the booking page on website. Here is my query.

SELECT  sum( totals.pageviews ) AS Searches,Date
FROM `table*`
WHERE exists (
select 1 from unnest(hits) as hits
where hits.page.pagePath ='booking'
) 
and date='20161109'
GROUP BY DATE

但我得到的结果比从 Google Analytics 得到的结果要多得多.大查询结果:1M左右GA:约 300,000这是我试图匹配的 GA 页面

But I got way more results than what i got from Google Analytics. Big query result: around 1M GA: around 300,000 This is the GA page that I am trying to match with

推荐答案

我找到了解决这个问题的方案:

I found the solution solve this problem:

SELECT count(totals.pageviews) AS Searches,DateFROM table, UNNEST(hits) as hitsWHERE hits.page.pagePath ='/booking' and hits.type='PAGE'按日期分组

SELECT count(totals.pageviews) AS Searches,Date FROM table, UNNEST(hits) as hits WHERE hits.page.pagePath ='/booking' and hits.type='PAGE' GROUP BY DATE

希望这个答案可以帮助其他人.

Hope this answer can help other people.

这篇关于Google Big Query 页面查看计数与 GA 页面查看计数不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！