グロースを加速するLooker活用 / Leveraging Looker to accelerate growth

Looker User Meetup Online #5 での発表内容。
https://connpass.com/event/198235/

Transcript

1. ©2020 Wantedly, Inc. άϩʔεΛՃ଎͢ΔLooker׆༻ Looker User Meetup #5 Dec 7, 2020 - Jiro Nagashima
2. ©2020 Wantedly, Inc. × άϩʔε Looker
3. ©2020 Wantedly, Inc. × άϩʔε Explore σʔλ୳ࡧ
4. ©2020 Wantedly, Inc. × DAU/WAU/MAUूܭ Explore σʔλ୳ࡧ ίϗʔτ෼ੳ
5. ©2020 Wantedly, Inc. ૑ҙ޻෉ × DAU/WAU/MAUूܭ Explore σʔλ୳ࡧ ίϗʔτ෼ੳ
6. ©2020 Wantedly, Inc. https://wantedly.com/id/jiro
7. ©2020 Wantedly, Inc. ࣗݾ঺հ WantedlyͰͷಇ͖ํ άϩʔε BI ։ൃ iOS Engineer Growth Lead / Growth PM BI Lead / BI Analyst 2013 2015 2020 ϓϩμΫτͷ੒௕Λ࣮ݱ͢Δ໾ׂ ϓϩμΫτͷ੒௕Λࢧ͑Δ໾ׂ
8. ©2020 Wantedly, Inc. BIνʔϜ ࡢ೥຤ʹ৽ઃ
9. ©2020 Wantedly, Inc. ϛογϣϯ BIνʔϜ ҙࢥܾఆࢧԉɾఏݴ ։ൃνʔϜ
   ϓϩμΫτ
   ͷ։ൃ༏ઌ౓ΛܾΊΔࡍͷ
   
10. ©2020 Wantedly, Inc. Ξ΢τϓοτ BIνʔϜ North Star Metricબఆ KRͷ໨ඪ஋ઃఆ Ϣʔβʔηάϝϯτఆٛ KRμογϡϘʔυઃܭ LookerҠߦ
11. ©2020 Wantedly, Inc. ૑ҙ޻෉
12. ©2020 Wantedly, Inc. ίϗʔτ෼ੳ × Explore σʔλ୳ࡧ DAU/WAU/MAUूܭ
13. ©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ଐੑ͝ͱͷಈ޲ͷ೺Ѳ
    w ྫ
    21ଔͷֶੜ͸૿Ճ܏޲ʹ͋Δ͔ɺࢪࡦΛ࣮ࢪ͢Δͷʹे෼ͳϘϦϡʔϜ͕͋Δ͔
    قઅੑɾपظੑͷ೺Ѳ
    w ྫ
    ֶੜͷϐʔΫ͸ྫ೥͍ͭࠒ͔ɺࢪࡦΛ࣮ࢪ͢Δͷ͸͍͕ͭଥ౰͔
    ͦͷଞ
    w εύϜ༗ແͷ೺Ѳɺ޿ࠂύϑΥʔϚϯεͷ೺ѲͳͲ DAU/WAU/MAUूܭ
14. ©2020 Wantedly, Inc. Exploreͷ࣮ݱྫ DAU/WAU/MAUूܭ ೔࣍ͷDAU/WAU/MAUਪҠ
15. ©2020 Wantedly, Inc. ૑ҙ޻෉  ۙࣅूܭؔ਺
    HyperLogLogؔ਺
    w ूܭ࣌ͷύϑΥʔϚϯε޲্
     bind_all_filtersύϥϝʔλʔ
    w ूܭ࣌ͷϑΟϧλʔ৚݅ࢦఆ DAU/WAU/MAUूܭ
16. ©2020 Wantedly, Inc. ࣮૷ DAU/WAU/MAUूܭ exploreͷఆٛ
17. ©2020 Wantedly, Inc. ࣮૷
    exploreͷఆٛ DAU/WAU/MAUूܭ Looker
18. ©2020 Wantedly, Inc. ࣮૷
    exploreͷఆٛ DAU/WAU/MAUूܭ Looker
19. ©2020 Wantedly, Inc. ࣮૷
    exploreͷఆٛ DAU/WAU/MAUूܭ Looker
20. ©2020 Wantedly, Inc. ࣮૷
    exploreͷఆٛ DAU/WAU/MAUूܭ Looker
21. ©2020 Wantedly, Inc. ࣮૷ DAU/WAU/MAUूܭ ࣮ݱ͍ͨ͠ूܭ ૑ҙ޻෉1: ۙࣅूܭؔ਺
    HyperLogLogؔ਺
    
22. ©2020 Wantedly, Inc. ࣮ݱ͍ͨ͠ूܭ DAU/WAU/MAUूܭ BigQuery
23. ©2020 Wantedly, Inc. ࣮ݱ͍ͨ͠ूܭ DAU/WAU/MAUूܭ BigQuery
24. ©2020 Wantedly, Inc. ࣮ݱ͍ͨ͠ूܭ DAU/WAU/MAUूܭ BigQuery
25. ©2020 Wantedly, Inc. ࣮ݱ͍ͨ͠ूܭ DAU/WAU/MAUूܭ BigQuery
26. ©2020 Wantedly, Inc. ࣮૷ DAU/WAU/MAUूܭ viewͷఆٛ ૑ҙ޻෉: bind_all_filtersύϥϝʔλʔ
27. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ DAU/WAU/MAUूܭ Looker
28. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ DAU/WAU/MAUूܭ Looker
29. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ DAU/WAU/MAUूܭ Looker
30. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ DAU/WAU/MAUूܭ Looker
31. ©2020 Wantedly, Inc. ิ଍ DAU/WAU/MAUूܭ ୯७ͳूܭͰ͋Ε͹࠷దԽ༻ͷύϥϝʔλʔΛར༻Մೳ https://docs.looker.com/reference/field-params/allow_approximate_optimization
32. ©2020 Wantedly, Inc. DAU/WAU/MAUूܭ × Explore σʔλ୳ࡧ ίϗʔτ෼ੳ
33. ©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ίϗʔτ෼ੳ Ϣʔβʔ ৽ن Ϣʔβʔ ෮ؼ Ϣʔβʔ ٳ຾ Ϣʔβʔ ύϫʔ Ϣʔβʔ ܧଓ ֫ಘ ΞΫ ςΟϕʔ γ ϣ ϯ ࠶ ΞΫ ςΟϕʔ γ ϣ ϯ ཭ ୤ ཭ ୤ ཭୤ Ϧ β Ϩ Ϋ γ ϣ ϯ
34. ©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ίϗʔτ෼ੳ https://amplitude.com/mastering-retention/retention-lifecycle-framework “Retention Lifecycle Framework” ͱͯ͠঺հ
35. ©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ϥΠϑαΠΫϧ͝ͱͷಈ޲೺Ѳ
    w ৽ن / ܧଓ
    
    ෮ؼ
    
    ٳ຾ͷ4ͭͷίϗʔτͰ෼ྨ
    w ྫ
    Ϣʔβʔ͕૿͍͑ͯΔͷ͸৽نʢ΋͘͠͸ɺ෮ؼʣͷ૿Ճͱٳ຾ͷݮগͷ͍ͣΕ͔
    Τϯήʔδϝϯτ౓߹͍͝ͱͷಈ޲೺Ѳ
    w ΧδϡΞϧ
    
    ίΞ
    
    ύϫʔͷ3ͭͷίϗʔτͰ෼ྨ
    w ྫ
    ૿͍͑ͯΔͷ͸Τϯήʔδϝϯτ౓߹͍ͷߴ͍Ϣʔβʔͱ௿͍Ϣʔβʔͷ͍ͣΕ͔
    ଐੑͱ૊Έ߹Θͤͨίϗʔτ͝ͱͷಈ޲೺Ѳ
    w ྫ
    த్͕૿͍͑ͯΔͷ͸৽نʢ΋͘͠͸ɺ෮ؼʣͷ૿Ճͱٳ຾ͷݮগͷ͍ͣΕ͔ ίϗʔτ෼ੳ
36. ©2020 Wantedly, Inc. Exploreͷ࣮ݱྫ ίϗʔτ෼ੳ ϥΠϑαΠΫϧ͝ͱͷϢʔβʔ਺ਪҠ Τϯήʔδϝϯτ౓߹͍͝ͱͷϢʔβʔൺ཰ਪҠ
37. ©2020 Wantedly, Inc. ૑ҙ޻෉ 1. PDT w ࣄલूܭͱӬଓԽʹΑΔύϑΥʔϚϯε޲্
     group_labelύϥϝʔλʔ
    w ϑΟʔϧυͷ෼ྨʹΑΔརศੑ޲্ ίϗʔτ෼ੳ
38. ©2020 Wantedly, Inc. ࣮૷ ίϗʔτ෼ੳ viewͷఆٛ ૑ҙ޻෉: PDT
39. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ ίϗʔτ෼ੳ Looker
40. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ ίϗʔτ෼ੳ Looker
41. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ ίϗʔτ෼ੳ Looker
42. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ ίϗʔτ෼ੳ Looker
43. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ ίϗʔτ෼ੳ Looker
44. ©2020 Wantedly, Inc. ࣮૷
    viewͷఆٛ ίϗʔτ෼ੳ Looker
45. ©2020 Wantedly, Inc. ࣮૷ ίϗʔτ෼ੳ measureͷఆٛ ૑ҙ޻෉: group_labelύϥϝʔλʔ
46. ©2020 Wantedly, Inc. ࣮૷
    measureͷఆٛ ίϗʔτ෼ੳ Looker
47. ©2020 Wantedly, Inc. ࣮૷
    measureͷఆٛ ίϗʔτ෼ੳ Looker
48. ©2020 Wantedly, Inc. άϩʔεʹ͓͚ΔExplore׆༻࣌ͷ૑ҙ޻෉
     DAU/WAU/MAUूܭ × Explore σʔλ୳ࡧ
    w bind_all_filtersύϥϝʔλʔ
    w ۙࣅूܭؔ਺
    HyperLogLogؔ਺
     ίϗʔτ෼ੳ × Explore σʔλ୳ࡧ
    w PDT
    w group_labelύϥϝʔλʔ Summary
49. ©2020 Wantedly, Inc. άϩʔε Looker × ૑ҙ޻෉ʹΑͬͯे෼ʹ׆༻Ͱ͖Δʂ
50. ©2020 Wantedly, Inc. Appendix
51. ©2020 Wantedly, Inc. https://mixpanel.com/ja/content/guide-to-product-analytics/chapter_2/ ͍ͭDAU/WAU/MAUΛܭଌ͢΂͖͔ʢ͋Δ͍͸ɺ͢΂͖Ͱͳ͍͔ʣ
52. ©2020 Wantedly, Inc. ࠓޙ࣮ݱ͍ͨ͜͠ͱ https://clevertap.com/blog/cohort-analysis/ Triangle Chart ִ࣌ؒؒͷࢦఆ΍ଐੑͱ૊Έ߹Θͤͨ෼ੳΛ࣮ݱ͍ͨ͠