select value.string_value from unnest(event_params) where key = "screen_name" ) when "UserViewController" then "Ϣʔβʔը໘" when "SettingViewController" then "ઃఆը໘" ... -- @ը໘͚ͩ else "" end, ... -- user_id ͳͲ from `<project>.analytics.events_*` where _table_suffix = "20220401" and event_name = "screen_event" and app_info.id = "com.wantedly.app" w ը໘ͱΫϥε໊ͷରԠΛͬͯ ͍Δ ඞཁ͕͋Δ w εΫϦʔϯϩάͷ[email protected] Λ͍ͬͯΔ w తͷΞϓϦͷCVOEMF JEFOUJ fi FSΛ͍ͬͯΔ ूܭ͢ΔͨΊʹɺΒͳ͍ͱ͍͚ͳ͍͜ͱ͕ଟ͍
View select case ( select value.string_value from unnest(event_params) where key = "screen_name" ) when "UserViewController" then "Ϣʔβʔը໘" when "SettingViewController" then "ઃఆը໘" ... -- @ը໘͚ͩ else "" end, ... -- user_id ͳͲ from `<project>.analytics.events_*` where _table_suffix = "20220401" and event_name = "screen_event" and app_info.id = "com.wantedly.app"
select * from `ios_screen_view` [email protected]@WJFX [email protected]@WJFX [email protected]@WJFX BOBMZUJDT[email protected] -- εΫϦʔϯϩάΛूܭ͢Δ View select case ( select value.string_value from unnest(event_params) where key = "screen_name" ) when "UserViewController" then "Ϣʔβʔը໘" when "SettingViewController" then "ઃఆը໘" ... -- @ը໘͚ͩ else "" end, ... -- user_id ͳͲ from `<project>.analytics.events_*` where _table_suffix = "20220401" and event_name = "screen_event" and app_info.id = "com.wantedly.app"
count(open.id) open_count, count(open.id) / count(receive.id) open_rate, from `ios_receive_push_notifications` receive left outer join `ios_open_push_notifications` open using (id) w ྫ ϓογϡ௨ͷड৴ϩά ։෧ϩάϓογϡ௨ͷ։෧ͷूܭ