How to get sequence number of the event?

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}}`
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.