Mobile 勉強会 Wantedly x チームラボ #5 で発表したスライドになります https://wantedly.connpass.com/event/244011/
©2022 Wantedly, Inc.ΞϓϦͷϩάΛνʔϜ֎Ͱ׆༻ͯ͠Β͏ͨΊʹͬͨ͜ͱ.PCJMFษڧձShota Kashihara @kashihararara
View Slide
©2022 Wantedly, Inc.λΠτϧͷิͰ͢ΞϓϦͷϩάΛ → Treasure Data / Google Analytics for Firebase ͷϩάνʔϜ֎Ͱ → ϞόΠϧΞϓϦνʔϜҎ֎ͷϝϯόʔ׆༻͢Δ → తͷࢦඪʹ͍ͭͯूܭ͢Δ͜ͱ࠷ॳʹ
©2022 Wantedly, Inc.5SFBTVSF%BUB("GPS'JSFCBTFͷϩάΛϞόΠϧΞϓϦνʔϜҎ֎ͷϝϯόʔ͕తͷࢦඪʹ͍ͭͯࣗ༝ʹूܭ͢ΔͨΊʹͬͨ͜ͱ.PCJMFษڧձShota Kashihara @kashihararara
©2022 Wantedly, Inc.ཧͱݱ࣮
©2022 Wantedly, Inc.՝ΞϓϦͷϩάΞϓϦΤϯδχΞ ඇΞϓϦΤϯδχΞ࣮ ར༻ཧ
©2022 Wantedly, Inc.՝ΞϓϦͷϩάΞϓϦΤϯδχΞ ඇΞϓϦΤϯδχΞूܭґཔݱ࣮
©2022 Wantedly, Inc.՝ϩάར༻ʹ͔͔Δ༷ʑͳϋʔυϧw ͭͷUBCMF EBUBTFUʹશͯͷϩά͕ೖ͍ͬͯΔw ཉ͍͠ϩάʹରԠ͢ΔFWFOU@OBNF FWFOU@QBSBNT͕Θ͔Βͳ͍w TDIFNF͕ͳ͍w FWFOU@OBNF FWFOU@QBSBNTͷΓํ͕όϥόϥw ҉ͷʑw J04 "OESPJEͰFWFOU@OBNF͕ҟͳΔw J04 "OESPJE͓Αͼ࢞ຓΞϓϦͷϩάಉҰUBCMFʹೖ͍ͬͯΔw 4XJGU,PUMJOͷΫϥε໊࣮༝དྷͷ͕ϩάʹೖ͍ͬͯΔw લʹFWFOU@OBNFͷUZQPΛͨ͠FUD
©2022 Wantedly, Inc.՝-- εΫϦʔϯϩάΛूܭ͢Δ Viewselectcase (select value.string_valuefrom unnest(event_params)where key = "screen_name")when "UserViewController" then "Ϣʔβʔը໘"when "SettingViewController" then "ઃఆը໘"... -- @ը໘͚ͩelse ""end,... -- user_id ͳͲfrom `.analytics.events_*`where _table_suffix = "20220401"and event_name = "screen_event"and app_info.id = "com.wantedly.app"w ը໘ͱΫϥε໊ͷରԠΛ͍ͬͯΔ ඞཁ͕͋Δw εΫϦʔϯϩάͷFWFOU@OBNFΛ͍ͬͯΔw తͷΞϓϦͷCVOEMFJEFOUJfiFSΛ͍ͬͯΔूܭ͢ΔͨΊʹɺΒͳ͍ͱ͍͚ͳ͍͜ͱ͕ଟ͍
©2022 Wantedly, Inc.՝ॱ൪ʹϩάΛཧ͍ͯ͘͠w ੳ͍͢͠ܗʹΠϕϯτͷཻΛἧ͑Δw ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δw ࡞ͬͨ7JFXͷΫΤϦΛ(JU)VCͰཧ͢Δ
©2022 Wantedly, Inc.ੳ͍͢͠ܗʹΠϕϯτͷཻΛἧ͑ΔτοϓϨϕϧͷFWFOU@OBNFʹͯ͢ͷΠϕϯτΛྻڍ͢ΔͷͰͳ͘ɺΠϕϯτΛΧςΰϦ͝ͱʹू͢Δޙड़͢ΔɺFWFOU@OBNFͰ·ͱ·ͬͨ7JFXΛ࡞ΔͨΊͷԼ४උenum EventName {case tapControl(name: TapControlName)...}enum TapControlName {case userShareButton(userId: String)case companyShareButton(companyId: String)...}
©2022 Wantedly, Inc.enum EventName {// DO NOT EDITextension Event {var name: String {switch self {case .tapControl:return "tap_control"}}var params: [String: Any] {switch self {case .tapControl(name):switch name {case .userShareButton(let userId):return ["name": "user_share_button", "user_id": userId]case .companyShareButton(let companyId):return ["name": "company_share_button", "company_id": companyId]}}}}TUFDJM📄
©2022 Wantedly, Inc.ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δશͯͷϩά͕ೖ͍ͬͯΔςʔϒϧ͔ΒɺΧςΰϦ͝ͱʹ7JFXΛΓग़͢ඇΞϓϦΤϯδχΞཁٻ͞ΕΔ༷ʑͳ҉BOBMZUJDTFWFOUT@-- εΫϦʔϯϩάΛूܭ͢Δ Viewselectcase (select value.string_valuefrom unnest(event_params)where key = "screen_name")when "UserViewController" then "Ϣʔβʔը໘"when "SettingViewController" then "ઃఆը໘"... -- @ը໘͚ͩelse ""end,... -- user_id ͳͲfrom `.analytics.events_*`where _table_suffix = "20220401"and event_name = "screen_event"and app_info.id = "com.wantedly.app"
©2022 Wantedly, Inc.ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δશͯͷϩά͕ೖ͍ͬͯΔςʔϒϧ͔ΒɺΧςΰϦ͝ͱʹ7JFXΛΓग़͢ඇΞϓϦΤϯδχΞ҉ΛӅṭͨ͠7JFX-- εΫϦʔϯϩάΛूܭ͢Δ Viewselect *from `ios_screen_view`JPT@TDSFFO@WJFXJPT@TDSFFO@WJFXJPT@TDSFFO@WJFXBOBMZUJDTFWFOUT@-- εΫϦʔϯϩάΛूܭ͢Δ Viewselectcase (select value.string_valuefrom unnest(event_params)where key = "screen_name")when "UserViewController" then "Ϣʔβʔը໘"when "SettingViewController" then "ઃఆը໘"... -- @ը໘͚ͩelse ""end,... -- user_id ͳͲfrom `.analytics.events_*`where _table_suffix = "20220401"and event_name = "screen_event"and app_info.id = "com.wantedly.app"
©2022 Wantedly, Inc.ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δ7JFXΛΈ߹ΘͤΔw ఆٛࡁΈ7JFXΛ࠶ར༻͢Δ͜ͱͰෳࡶΛ͑ͳ͕Β༷ʑͳूܭΛՄೳʹ͢Δselectcount(receive.id) receive_count,count(open.id) open_count,count(open.id) / count(receive.id) open_rate,from `ios_receive_push_notifications` receiveleft outer join `ios_open_push_notifications` open using (id)w ྫϓογϡ௨ͷड৴ϩά։෧ϩάϓογϡ௨ͷ։෧ͷूܭ
©2022 Wantedly, Inc.࡞ͬͨ7JFXͷΫΤϦΛ(JU)VCͰཧ͢Δ#JH2VFSZͷ7JFX6%'Λ(JU)VCͰཧ͢ΔπʔϧSFSPTUCRWhttps://www.wantedly.com/companies/wantedly/post_articles/286165
©2022 Wantedly, Inc.࡞ͬͨ7JFXͷΫΤϦΛ(JU)VCͰཧ͢Δ#JH2VFSZͷ7JFX6%'Λ(JU)VCͰཧ͢ΔπʔϧSFSPTUCRWw ΫΤϦͷϨϏϡʔ͕ग़དྷΔw ΫΤϦͷଐਓԽɺൿͷλϨԽΛ͙
©2022 Wantedly, Inc.՝7JFXΞϓϦΤϯδχΞ ඇΞϓϦΤϯδχΞ࣮ ར༻ݱࡏΞϓϦͷϩά
©2022 Wantedly, Inc.͓͞Β͍ॱ൪ʹϩάΛཧ͍ͯ͘͠w ੳ͍͢͠ܗʹΠϕϯτͷཻΛἧ͑Δw ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δw ࡞ͬͨ7JFXͷΫΤϦΛ(JU)VCͰཧ͢Δ
ϖʔδλΠτϧ ϖʔδαϒλΠτϧ©2022 Wantedly, Inc.5IBOLT