aoxu
11/9/2018 - 7:15 AM

sample.sql

sample.sql
content_copyfile_download
SELECT
   DISTINCT user_id
FROM
  `analytics_168921341.events_*` AS T,
  T.event_params
WHERE
  event_name = 'tutorial_complete'
  AND event_params.key = 'guide_id'
  AND event_params.value.int_value = 51
  AND geo.country = 'United States' /* 修改为指定国家 */
  AND _TABLE_SUFFIX BETWEEN '20181108' AND '20181108' /* 修改为events数据范围 */