Google Analytics(分析)新用户是否受回溯期影响? [英] Is google analytics new user affected by lookback window?

问题描述

我最近发现，如果用户在183天或更长时间内没有访问过该网站，那么Google Analytics(分析)大型查询导出中的visitNumber将从1开始.我现在正在尝试了解Google Analytics(分析)定义新用户时是否应用了相同的回溯窗口?

I recently found out that visitNumber in big query google analytics export starts over at 1 if a user has not visited the site in 183 days or more. I am now trying to understand if the same lookback window is applied when google analytics defines new users?

推荐答案

bigquery中SUM(totals.newVisits)的结果与导出数据中Google Analytics(分析)受众报告中一天报告的新用户数完全相同即使他们较早访问了我们的网站，该用户也被标记为新访问者.因此，我得出结论，谷歌分析也使用相同的回溯窗口.

The result of SUM(totals.newVisits) in bigquery is exactly the same as the new user count reported in Google Analytics Audience report for a day in my exported data that has users marked as new visitors eventhough they have visited our site earlier. I therefore conclude that google analytics also uses the same lookback window.

我发现，为了根据新用户的实际首次访问(Cookie创建日期)来计算新用户，可以使用客户端ID的最后一部分.例如，此查询查找20181025的新用户数:

I found that in order to count new users depending on their actual first visit (cookie creation date) it's possible to use the last part of the client id. As an example, this query finds the number of new users for 20181025:

   #StandardSQL
   SELECT SUM(CASE WHEN cookie_date = '2018-10-25' THEN 1 ELSE 0 END) AS new_visitors, 
          count(*) AS all_visitors
   FROM (SELECT clientId, 
                DATE(TIMESTAMP_ADD("1970-01-01 00:00:00 UTC", INTERVAL min(CAST(REGEXP_EXTRACT(clientId, r'[0-9]*$') AS INT64)) SECOND), "Europe/Berlin") as 
   cookie_date
         FROM `xxx.ga_sessions_20181025`
         GROUP BY clientId)

这篇关于Google Analytics(分析)新用户是否受回溯期影响?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！