busy-air-96466
05/02/2023, 4:14 PMfresh-football-47124
busy-air-96466
05/02/2023, 5:23 PMfresh-football-47124
busy-air-96466
05/02/2023, 5:31 PMfresh-football-47124
busy-air-96466
05/02/2023, 5:45 PMSELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
1 as value
FROM
``analytics_xxx.events_intraday_*``
WHERE
event_name = 'Click counter button'
AND _TABLE_SUFFIX BETWEEN '20230330' AND '20231130'
UNION ALL
SELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
1 as value
FROM
``analytics_xxx.events_*``
WHERE
event_name = 'Click counter button'
AND _TABLE_SUFFIX BETWEEN '20230330' AND '20231130'
fresh-football-47124
busy-air-96466
05/02/2023, 5:46 PMfresh-football-47124
busy-air-96466
05/02/2023, 5:52 PMfresh-football-47124
busy-air-96466
05/03/2023, 4:09 AMfresh-football-47124
busy-air-96466
05/03/2023, 4:33 AMfresh-football-47124
busy-air-96466
05/03/2023, 9:42 AM