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

问题描述

我正在尝试通过网站上的预订页面查看总人数的网页浏览量。这是我的查询。

  SELECT sum（totals.pageviews）AS搜索，日期
 FROM`table *`
 WHERE存在（
从unnest（点击）中选择1作为点击
，其中hits.page.pagePath ='预订'
）
和日期='20161109'
 GROUP BY DATE 
  

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

< a href =https://i.stack.imgur.com/wATvO.png =nofollow noreferrer> GA结果

解决方案

我发现解决方案解决了这个问题：

SELECT count（totals。网页浏览）AS搜索，日期
从表，UNNEST（点击）点击
WHERE hits.page.pagePath ='/ booking'和点击。 type ='PAGE'
GROUP BY DATE

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

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

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

GA result

解决方案

I found the solution solve this problem:

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屋！