chilly-belgium-79464
05/14/2024, 9:26 PMhelpful-application-7107
05/14/2024, 9:56 PMchilly-belgium-79464
05/14/2024, 10:09 PMFORMAT_DATE("%Y%m%d", DATE(TIMESTAMP_SECONDS({{date startDateISO "t"}}), "America/Los_Angeles"))
chilly-belgium-79464
05/14/2024, 10:12 PMchilly-belgium-79464
05/14/2024, 10:12 PMAND ((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
(_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))
chilly-belgium-79464
05/14/2024, 10:16 PMchilly-belgium-79464
05/14/2024, 10:17 PMchilly-belgium-79464
05/14/2024, 10:43 PMSELECT
gbuuid_param.value.string_value AS gbuuid,
TIMESTAMP_MICROS(event_timestamp) AS timestamp
FROM
`stream-p`.`analytics_301842526`.`events_*` AS watchnow_one,
UNNEST(event_params) AS gbuuid_param
WHERE
event_name = '{{eventName}}'
AND gbuuid_param.key = 'gbuuid'
AND gbuuid_param.value.string_value is not null
AND (
(
_TABLE_SUFFIX BETWEEN FORMAT_DATE(
'%Y%m%d',
DATE(
TIMESTAMP_SECONDS({{date startDateISO "t"}}),
"America/Los_Angeles"
)
) AND FORMAT_DATE(
'%Y%m%d',
DATE(
TIMESTAMP_SECONDS({{date endDateISO "t"}}),
"America/Los_Angeles"
)
)
)
OR (
_TABLE_SUFFIX BETWEEN CONCAT(
'intraday_',
FORMAT_DATE(
'%Y%m%d',
DATE(
TIMESTAMP_SECONDS({{date startDateISO "t"}}),
"America/Los_Angeles"
)
)
) AND CONCAT(
'intraday_',
FORMAT_DATE(
'%Y%m%d',
DATE(
TIMESTAMP_SECONDS({{date endDateISO "t"}}),
"America/Los_Angeles"
)
)
)
)
)
helpful-application-7107
05/14/2024, 11:24 PMhelpful-application-7107
05/14/2024, 11:25 PMchilly-belgium-79464
05/14/2024, 11:26 PMchilly-belgium-79464
05/14/2024, 11:27 PMchilly-belgium-79464
05/14/2024, 11:30 PMhelpful-application-7107
05/14/2024, 11:31 PMchilly-belgium-79464
05/14/2024, 11:31 PMchilly-belgium-79464
05/14/2024, 11:31 PMchilly-belgium-79464
05/14/2024, 11:32 PMchilly-belgium-79464
05/14/2024, 11:33 PMchilly-belgium-79464
05/14/2024, 11:34 PMhelpful-application-7107
05/14/2024, 11:42 PMstartDateISO renders to tomorrowLike when you just start an experiment right?
chilly-belgium-79464
05/14/2024, 11:47 PMhelpful-application-7107
05/14/2024, 11:48 PMchilly-belgium-79464
05/14/2024, 11:49 PMchilly-belgium-79464
05/14/2024, 11:50 PMhelpful-application-7107
05/14/2024, 11:51 PMhelpful-application-7107
05/14/2024, 11:52 PMchilly-belgium-79464
05/14/2024, 11:52 PM