用户 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 支持确认，userId 在从启用 User-ID 导出的 BigQuery 表中只有非空值谷歌分析中的视图.对于非用户 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屋！