full-vase-45670
11/30/2021, 5:49 AMfresh-football-47124
full-vase-45670
11/30/2021, 6:00 AMfuture-teacher-7046
average-carpet-44531
12/03/2021, 8:58 PMSELECT
user_id,
domain_userid as anonymous_id,
cast(derived_tstamp as DATETIME) as timestamp,
se_label as experiment_id,
se_property as variation_id
FROM
`snowplow_prod.snowplow-events`
WHERE se_category = 'Growthbook' and
se_action = 'Experiment Viewed'
and
Our Metric Query
SELECT
domain_userid as anonymous_id,
cast(derived_tstamp as datetime) as timestamp
FROM
`snowplow_prod.snowplow-events`
WHERE se_action = 'Sign Up Completed'