Link
Embed
Share
Beginning
This slide
Copy link URL
Copy link URL
Copy iframe embed code
Copy iframe embed code
Copy javascript embed code
Copy javascript embed code
Share
Tweet
Share
Tweet
Slide 1
Slide 1 text
©2019 Wantedly, Inc. Wantedly ৽ਓݚम ʮBigQuery σʔλੳϊοΫʯΛ࣮ࢪͨ͠ ΤϯδχΞͷ৽ਓݚमNight 17.May 2019 - Yuya Matsumura @yu-ya4
Slide 2
Slide 2 text
©2019 Wantedly, Inc. ✓ Yuya Matsumura ✓ Software Engineer ✓ Wantedly, Inc. Recommendation Team (since April 2018) ✓ Interested in Information Retrieval, Machine Learning Self-Introduction @yu-ya4 @yu__ya4
Slide 3
Slide 3 text
©2019 Wantedly, Inc. 8BOUFEMZʹ͓͚Δ৽ਓݚमͷ֓ཁհ ৽ਓݚमʮ#JH2VFSZੳϊοΫʯͷհ Agenda
Slide 4
Slide 4 text
©2019 Wantedly, Inc. 8BOUFEMZʹ͓͚Δ৽ਓݚमͷ֓ཁհ ৽ਓݚमʮ#JH2VFSZੳϊοΫʯͷհ Agenda
Slide 5
Slide 5 text
©2019 Wantedly, Inc. ʮWantedly ݻ༗ͷࣝʢ৫ɾϓϩμΫτɾจԽͷࣝʣʯʮීวతͳࣝʢΤ ϯδχΞϦϯάͳͲͷઐࣝɺϏδωεϚφʔ๏ͷࣝʣʯΛʹ͚ͭɺ ৽ਓΤϯδχΞ͕Wantedly ͕ظ͢ΔΤϯδχΞ૾ʹۙͮͨ͘Ίͷֶͼͷ Wantedly ʹ͓͚Δ৽ਓݚम ৽ਓΤϯδχΞ Wantedly ͕ظ͢Δ ΤϯδχΞ૾ ৽ਓݚम https://speakerdeck.com/south37/xin-zu-yan-xiu-dexing-u-isucon-falsemei-li?slide=9
Slide 6
Slide 6 text
©2019 Wantedly, Inc. Wantedly ͕ظ͢ΔΤϯδχΞ૾ ϓϩμΫτͰՁΛಧ͚ΔͨΊʹɺٕज़Λ͏ ඞཁͰ͋Ε͋ΒΏΔٕज़ʹઓ͢Δ https://speakerdeck.com/south37/xin-zu-yan-xiu-dexing-u-isucon-falsemei-li?slide=10
Slide 7
Slide 7 text
©2019 Wantedly, Inc. Wantedly ʹ͓͚Δ৽ਓݚम͕ఏڙ͢Δͷ ϓϩμΫτͰՁΛಧ͚ΔͨΊʹɺٕज़Λ͏ ⾣ϓϩμΫτʹՁΛ༩͑Δٕज़ΛֶͿػձ ඞཁͰ͋Ε͋ΒΏΔٕज़ʹઓ͢Δ ⾣ٕज़తʹ͍ྖҬʹ৮ΕΔܦݧ https://speakerdeck.com/south37/xin-zu-yan-xiu-dexing-u-isucon-falsemei-li?slide=10
Slide 8
Slide 8 text
©2019 Wantedly, Inc. Wantedly ʹ͓͚Δ৽ਓݚमͷྫʢ̍ʣ https://speakerdeck.com/tan_z_tan/how-to-get-involved-with- machine-learning-at-wantedly
Slide 9
Slide 9 text
©2019 Wantedly, Inc. Wantedly ʹ͓͚Δ৽ਓݚमͷྫʢ̎ʣ https://speakerdeck.com/south37/new-grad-isucon-for-learning
Slide 10
Slide 10 text
©2019 Wantedly, Inc. Wantedly ʹ͓͚Δ৽ਓݚमͷྫʢ̏ʣ https://speakerdeck.com/kawasy/managing-your-leader
Slide 11
Slide 11 text
©2019 Wantedly, Inc. ଞʹ͍Ζ͍Ζ Wantedly ʹ͓͚Δ৽ਓݚमͷྫ https://wantedlyinc.com/ja/presentations
Slide 12
Slide 12 text
©2019 Wantedly, Inc. 8BOUFEMZʹ͓͚Δ৽ਓݚमͷ֓ཁհ ৽ਓݚमʮ#JH2VFSZੳϊοΫʯͷհ Agenda
Slide 13
Slide 13 text
©2019 Wantedly, Inc. BigQuery σʔλੳϊοΫ ୲ͨ͠ݚम
Slide 14
Slide 14 text
©2019 Wantedly, Inc. ʮBigQuery Λ༻͍ͯ Wantedly ͷαʔϏεʹ͍ͭͯͷ ඞཁͳใΛదʹऔಘͰ͖ΔΑ͏ʹͳΔʯ ͜ͷݚमͷత
Slide 15
Slide 15 text
©2019 Wantedly, Inc. Why Wantedly ͰΞϓϦέʔγϣϯΤϯδχΞ͕ࣗࣗͰσʔλ ੳΛߦͬͯ՝ΛѲͯ͠ࢪࡦΛ࣮ࢪ͠ɼͦͷ݁ՌͷධՁ·Ͱ Λߦ͍ͬͯΔ ࣗతʹಈ͍ͯαʔϏεվળΛਐΊΒΕΔମ੍ εϐʔυײɼαʔϏεѪ…
Slide 16
Slide 16 text
©2019 Wantedly, Inc. ✓ ͍ԾઆΛཱͯΔ ✓ ݕূํ๏Λߟ͑Δ ✓ ࣮͢Δ ✓ ϩάΛऔΔ ✓ ूܭ͢Δ ✓ ධՁ͢Δ https://speakerdeck.com/ngtk/lets-be-able-to-propose-measures-for-product-growth + ͋Δఔج൫͍ͬͯΔͷͰ͋·Γߟ͑Δ͜ͱͳ͍ ࢪࡦ࣮ࢪͷྲྀΕ ίί internal only ͜ͷݚमͷҐஔ͚ͮ
Slide 17
Slide 17 text
©2019 Wantedly, Inc. ͜ͷݚमͷҐஔ͚ͮ ✓ SQL ͷࣝ • ͜Ε͕ͳ͍ͱ࢝·Βͳ͍ɻࢥͬͨ௨ΓͷσʔλΛਖ਼͘͠औಘͰ͖ΔΑ͏ʹʂ ✓ υϝΠϯࣝ • ݻ༗ͷσʔλߏͳͲʢͲ͜ͷςʔϒϧʹͲͷσʔλ͕͋Δͷ͔ʣ • ൺֱతҰൠతͳͷʢbot ͔ΒͷΞΫηεࣗࣾͷࣾһͷσʔλʹؾΛ͚ͭΑ͏ʣ ✓ ౷ܭͳͲͷࣝ • ਖ਼͘͠ࣈΛूܭ͠Α͏ • ਖ਼͘͠ࢪࡦͷ݁ՌΛධՁ͠Α͏ ✓ όΠΞεʹؔ͢Δࣝ • ֬ূόΠΞεͳͲʹؾΛ͚ͭΑ͏ σʔλΛਖ਼͘͠ूܭɾධՁ͢ΔͨΊʹඞཁͳࣝ
Slide 18
Slide 18 text
©2019 Wantedly, Inc. ͜ͷݚमͷҐஔ͚ͮ ✓ SQL ͷࣝ • ͜Ε͕ͳ͍ͱ࢝·Βͳ͍ɻࢥͬͨ௨ΓͷσʔλΛਖ਼͘͠औಘͰ͖ΔΑ͏ʹʂ ✓ υϝΠϯࣝ • ݻ༗ͷσʔλߏͳͲʢͲ͜ͷςʔϒϧʹͲͷσʔλ͕͋Δͷ͔ʣ • ൺֱతҰൠతͳͷʢbot ͔ΒͷΞΫηεࣗࣾͷࣾһͷσʔλʹؾΛ͚ͭΑ͏ʣ ✓ ౷ܭͳͲͷࣝ • ਖ਼͘͠ࣈΛूܭ͠Α͏ • ਖ਼͘͠ࢪࡦͷ݁ՌΛධՁ͠Α͏ ✓ όΠΞεʹؔ͢Δࣝ • ֬ূόΠΞεͳͲʹؾΛ͚ͭΑ͏ σʔλΛਖ਼͘͠ूܭɾධՁ͢ΔͨΊʹඞཁͳࣝ ίί
Slide 19
Slide 19 text
©2019 Wantedly, Inc. 1. BigQuery ͷجຊతͳࣝ • جຊతͳ SQL ͷࣝ͋Δલఏ • BigQuery ͳΒͰͷಛΛ͑ΔʢྻࢦɼARRAY ͷѻ͍ɼWindow ؔ…ʣ 2. Wantedly ͷαʔϏεʹ͍ͭͯͷσʔλͷυϝΠϯࣝ • Ұൠతͳͱ͜ΖʢBotɼRPAɼࣗࣾࣾһͷߦಈ …ʣผͷߨٛʢʰσʔλΛਖ਼͘͠ݟΔͨΊʹʱʣͰ • ςʔϒϧϨϕϧͷࣝʢʮΛฉ͖ʹߦ͖͍ͨʯͷσʔλͱʁɼεΧτػೳͷݕࡧϩάͲ͜ʹ͋Δʁʣ 3. σʔλΛੳ͢Δࡍͷࢦඪʹ͍ͭͯͷࣝ • ҰൠతͳࢦඪʢMAUɼARPUɼRetentionɼPVɼImpression…ʣ • υϝΠϯґଘͳࢦඪʢVisit ͷCVR ͱʁɼ༗ྉاۀͷܧଓͱʁʣ ͜ͷݚमΛ௨ͯ͠ಘͯ΄͍͠ͷ
Slide 20
Slide 20 text
©2019 Wantedly, Inc. ࣮ࡍతͳΛղ͍ͯʹ͚ͭΑ͏ How …Βͳ͖Όʹ͔ͭͳ͍ʂ
Slide 21
Slide 21 text
©2019 Wantedly, Inc. ✓ 20194݄1ʹ͓͚Δ PC͔ΒืूҰཡͷϦΫΤετʢPVʣ ✓ 20194݄1͔Β4݄7·Ͱͷ1िؒͷΞΫςΟϒͳϩάΠϯϢʔβʢWAUʣ ✓ εΧτػೳʹ͓͚ΔΩʔݕࡧʹ༻͍ΒΕͨΩʔϫʔυ͝ͱͷݕࡧճ ✓ 20194݄1ʹ1ؒ͋ͨΓ100ճҎ্ΞΫηε͖͍ͯͯ͠ΔIPΞυϨε ✓ 2018 ͷຊࠃʹ͓͚Δ ARPU ਪҠ What …ଞʹΓͩ͘͞Μʂ
Slide 22
Slide 22 text
©2019 Wantedly, Inc. ѹత Results …ݚमΛड͚ͨ৽ਓΤϯδχΞɼݚमΛ࣮ࢪͨ͠ࢲࣗʂ
Slide 23
Slide 23 text
©2019 Wantedly, Inc. Summary 㾎 8BOUFEMZʹ͓͚Δ৽ਓݚम w ৽ਓΤϯδχΞ͕8BOUFEMZ͕ظ͢ΔΤϯδχΞ૾ʹۙͮͨ͘Ίͷֶͼͷ 㾎 8BOUFEMZʹ͓͚Δ৽ਓݚम͕ఏڙ͢Δͷ w ϓϩμΫτʹՁΛ༩͑Δٕज़ΛֶͿػձ w ٕज़తʹ͍ྖҬʹ৮ΕΔܦݧ 㾎 ʮ#JH2VFSZσʔλੳϊοΫʯͷ࣮ࢪ w #JH2VFSZͷجຊతͳࣝ w 8BOUFEMZͷαʔϏεʹ͍ͭͯͷσʔλͷυϝΠϯࣝ w σʔλΛੳ͢Δࡍͷࢦඪʹ͍ͭͯͷࣝ