Skip to content

Instantly share code, notes, and snippets.

@aoxu

aoxu/sample.sql

Created November 9, 2018 07:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save aoxu/36dfe87e33b28747c0fd9963095ca7ec to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save aoxu/36dfe87e33b28747c0fd9963095ca7ec to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sample.sql
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数据范围 */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment