aoxu
11/15/2018 - 6:55 AM

查询矿层已解锁指定矿层的人数

[BigQuery] 公开的中间脚本

user_count_by_layer.sql
content_copyfile_download
SELECT
    user_id,
    event_params.key,
    event_params.value.int_value
FROM
  `analytics_168921341.events_*` AS T,
  T.event_params
WHERE
  event_name = 'activate_manto'
  AND event_params.key = 'manto_id'
  AND event_params.value.int_value = 2
  AND _TABLE_SUFFIX BETWEEN '20181108' AND '20181108'