with account_session_ste as (
FROM `table`
where exists(select 1 from unnest(hits) h 
            where regexp_contains(, r''))
and _table_suffix = FORMAT_DATE('%Y%m%d', DATE_SUB(CURRENT_DATE(), INTERVAL 4 DAY))
-- group by 1,2)
fullVisitorId AS user_id, as hostname, as pagePath,
hits.hitNumber as hit_number 
-- *
from account_session_ste, unnest(hits) as hits
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter