“first”是指在此次应用程序运行期间(直到应用程序终止并重新启动)的第一次,还是跨越多次运行的第一次?
我原以为这些字段只有一个值,但实际上它们经常有两个。当我运行此查询时:
SELECT
user_pseudo_id,
COUNT(*) AS the_count
FROM (
SELECT
DISTINCT user_pseudo_id,
user_first_touch_timestamp AS user_first_touch_timestamp
FROM
`noctacam.<my project>.events*`
WHERE
app_info.id = "<my bundle ID>"
ORDER BY
user_pseudo_id)
GROUP BY
user_pseudo_id
ORDER BY
the_count DESC
我发现我的用户中有0.6%的人拥有两个不同的user_first_touch_timestamp值。这是Firebase中的一个bug吗?
同样的情况也出现在first_open_time中:
SELECT
user_pseudo_id,
COUNT(*) AS the_count
FROM (
SELECT
DISTINCT user_pseudo_id,
user_properties.value.int_value AS first_open_time
FROM
`noctacam.<my project>.events*`,
UNNEST(user_properties) AS user_properties
WHERE
app_info.id = "<my bundle ID>"
AND user_properties.key = "first_open_time"
ORDER BY
user_pseudo_id)
GROUP BY
user_pseudo_id
ORDER BY
the_count DESC
同样的,0.6%的用户在这个字段上有两个不同的值。
参考资料: https://support.google.com/firebase/answer/7029846?hl=en https://support.google.com/firebase/answer/6317486?hl=en