full-vase-4567011/30/2021, 5:49 AM
full-vase-4567011/30/2021, 6:00 AM
average-carpet-4453112/03/2021, 8:58 PM
and Our Metric Query
SELECT 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'
SELECT domain_userid as anonymous_id, cast(derived_tstamp as datetime) as timestamp FROM `snowplow_prod.snowplow-events` WHERE se_action = 'Sign Up Completed'