Use SQL-code below to get sequence number of event:
SELECT
event_name,
SPLIT(owox.event_id,'/')[ORDINAL(1)] as event_id,
SPLIT(owox.event_id,'/')[ORDINAL(2)] as part,
SPLIT(owox.event_id,'/')[SAFE_ORDINAL(3)] as auto_event
FROM
`{{project}}.{{dataset}}.events_intraday_{{date}}`
0 Comments