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

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 ִ࣌ؒؒͷࢦఆ΍ଐੑͱ૊Έ߹Θͤͨ෼ੳΛ࣮ݱ͍ͨ͠