用户ID未显示在BigQuery中 [英] User ID not showing up in BigQuery

问题描述

BigQuery中的user_id是null的原因可能是什么?来自Analytics(分析)的数据会发送到BigQuery，但不会传递user_id. user_id已发送到Google Analytics(分析)，但这是什么原因导致BigQuery不可用?

What can be the reason the user_id is null in BigQuery? Data from Analytics is sent to BigQuery but the user_id is not passed along. The user_id is sent to Google Analytics but what could be the reason it is not available in BigQuery?

推荐答案

由Google Analytics(分析)360支持确认，在从Google Analytics(分析)中启用了用户ID的视图导出的BigQuery表中，userId仅具有非空值.对于非用户ID视图，您只能看到userId列的null值，并且必须使用自定义维度来捕获用户ID并在BigQuery中查询它们.

Confirmed by Google Analytics 360 support, the userId only have non-null values in BigQuery tables that are exported from User-ID enabled views in Google Analytics. For non-User-ID views, you only see null values for the userIdcolumn and you have to use a custom dimension to capture User Ids and query them in BigQuery.

要检查您已链接到BigQuery的哪个Google Analytics(分析)视图，可以查看BigQuery中的数据集ID(与Analytics(分析)视图ID相同)，也可以直接在管理>所有产品中链接到Google Analytics(分析)视图[属性列]> Google Analytics(分析)用户界面中的BigQuery.

In order to check which Google Analytics view you have linked to BigQuery, you can either look at the dataset ID in BigQuery (which is the same as the Analytics View ID) or directly the linked Google Analytics view in Admin > All Products [Property column] > BigQuery in the Google Analytics UI.

这篇关于用户ID未显示在BigQuery中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！