some-planet-44104
11/11/2022, 11:51 AM__metric as ( -- Metric (Retention [1st Day][GA])
SELECT
user_id as user_id,
1 as value,
CAST(m.timestamp as DATETIME) as timestamp,
CAST(m.timestamp as DATETIME) as conversion_start,
CAST(m.timestamp as DATETIME) as conversion_end
FROM
(
SELECT
CAST(user_id AS INT64) AS user_id,
1 AS value,
created_at AS timestamp
FROM
`normalized.events`
WHERE
event_name = "page_view"
AND DATE(created_at) >= '2022-09-01'
)
future-teacher-7046
some-planet-44104
11/23/2022, 9:55 AMloud-afternoon-54902
11/29/2022, 8:06 AM