Skip to content

Instantly share code, notes, and snippets.

@Osiyuks

Osiyuks/firebase_screen_class

Last active August 23, 2020 10:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Osiyuks/72ed5536f3c10a931ce1bedd2ae78d4d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Osiyuks/72ed5536f3c10a931ce1bedd2ae78d4d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
firebase_screen_class
SELECT
event_timestamp,
user_pseudo_id,
-- Какой firebase_screen_class какому экрану соответствует узнайте у своего разработчика
(SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'firebase_screen_class' ) AS screen
FROM `<project_id>.<dataset>.events_*`
WHERE _TABLE_SUFFIX between "20200806" and "20200816"
and event_name = 'screen_view'
order by 2,1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment