most-midnight-63385
10/03/2023, 11:03 PMfresh-football-47124
helpful-application-7107
10/04/2023, 4:04 PMfast-wire-759
10/04/2023, 4:41 PMmost-midnight-63385
10/04/2023, 4:53 PMtimestamp
; do you have doc for setting up dt?helpful-application-7107
10/04/2023, 5:03 PMmost-midnight-63385
10/04/2023, 5:06 PMWITH
__rawExperiment as (
select
anonymous_id,
test_registration_at as timestamp,
test_name as experiment_id,
test_bucket as variation_id
FROM
{table_name}
),
__experiment as ( -- Viewed Experiment
SELECT
e.anonymous_id as anonymous_id,
cast(e.variation_id as varchar) as variation,
e.timestamp as timestamp
FROM
__rawExperiment e
WHERE
e.experiment_id = '{test_name}'
AND e.timestamp >= from_iso8601_timestamp('2023-09-13T00:00:00.000Z')
helpful-application-7107
10/04/2023, 5:12 PMtest_resgistration_at
, right?most-midnight-63385
10/04/2023, 5:13 PMhelpful-application-7107
10/04/2023, 5:15 PMselect
anonymous_id,
test_registration_at as timestamp,
test_name as experiment_id,
test_bucket as variation_id
FROM
{table_name}
WHERE
dt >= {{ startDate }} AND dt <= {{ endDate }}
using the link above to talk about how you cna use these templates to properly filter your tablesmost-midnight-63385
10/04/2023, 5:20 PM