グロースを加速する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
   

   View Slide

2. ©2020 Wantedly, Inc.
   ×
   άϩʔε Looker
   

   View Slide

3. ©2020 Wantedly, Inc.
   ×
   άϩʔε Explore
   σʔλ୳ࡧ
   

   View Slide

4. ©2020 Wantedly, Inc.
   ×
   DAU/WAU/MAUूܭ
   Explore
   σʔλ୳ࡧ
   ίϗʔτ෼ੳ
   

   View Slide

5. ©2020 Wantedly, Inc.
   ૑ҙ޻෉
   ×
   DAU/WAU/MAUूܭ
   Explore
   σʔλ୳ࡧ
   ίϗʔτ෼ੳ
   

   View Slide

6. ©2020 Wantedly, Inc.
   https://wantedly.com/id/jiro
   

   View Slide

7. ©2020 Wantedly, Inc.
   ࣗݾ঺հ WantedlyͰͷಇ͖ํ
   άϩʔε
   BI
   ։ൃ iOS Engineer
   Growth Lead / Growth PM
   BI Lead / BI Analyst
   2013
   2015
   2020
   ϓϩμΫτͷ੒௕Λ࣮ݱ͢Δ໾ׂ
   ϓϩμΫτͷ੒௕Λࢧ͑Δ໾ׂ
   

   View Slide

8. ©2020 Wantedly, Inc.
   BIνʔϜ
   ࡢ೥຤ʹ৽ઃ
   

   View Slide

9. ©2020 Wantedly, Inc.
   ϛογϣϯ
   BIνʔϜ
   ҙࢥܾఆࢧԉɾఏݴ
   ։ൃνʔϜ ϓϩμΫτ
   ͷ։ൃ༏ઌ౓ΛܾΊΔࡍͷ
   

   View Slide

10. ©2020 Wantedly, Inc.
    Ξ΢τϓοτ
    BIνʔϜ
    North Star Metricબఆ
    KRͷ໨ඪ஋ઃఆ
    Ϣʔβʔηάϝϯτఆٛ
    KRμογϡϘʔυઃܭ
    LookerҠߦ
    

    View Slide

11. ©2020 Wantedly, Inc.
    ૑ҙ޻෉
    

    View Slide

12. ©2020 Wantedly, Inc.
    ίϗʔτ෼ੳ
    × Explore
    σʔλ୳ࡧ
    DAU/WAU/MAUूܭ
    

    View Slide

13. ©2020 Wantedly, Inc.
    Ϟνϕʔγϣϯ
    ଐੑ͝ͱͷಈ޲ͷ೺Ѳ
    w ྫ
    21ଔͷֶੜ͸૿Ճ܏޲ʹ͋Δ͔ɺࢪࡦΛ࣮ࢪ͢Δͷʹे෼ͳϘϦϡʔϜ͕͋Δ͔
    قઅੑɾपظੑͷ೺Ѳ
    w ྫ
    ֶੜͷϐʔΫ͸ྫ೥͍ͭࠒ͔ɺࢪࡦΛ࣮ࢪ͢Δͷ͸͍͕ͭଥ౰͔
    ͦͷଞ
    w εύϜ༗ແͷ೺Ѳɺ޿ࠂύϑΥʔϚϯεͷ೺ѲͳͲ
    DAU/WAU/MAUूܭ
    

    View Slide

14. ©2020 Wantedly, Inc.
    Exploreͷ࣮ݱྫ
    DAU/WAU/MAUूܭ
    ೔࣍ͷDAU/WAU/MAUਪҠ
    

    View Slide

15. ©2020 Wantedly, Inc.
    ૑ҙ޻෉
    ۙࣅूܭؔ਺ HyperLogLogؔ਺
    
    w ूܭ࣌ͷύϑΥʔϚϯε޲্
    bind_all_filtersύϥϝʔλʔ
    w ूܭ࣌ͷϑΟϧλʔ৚݅ࢦఆ
    DAU/WAU/MAUूܭ
    

    View Slide

16. ©2020 Wantedly, Inc.
    ࣮૷
    DAU/WAU/MAUूܭ
    exploreͷఆٛ
    

    View Slide

17. ©2020 Wantedly, Inc.
    ࣮૷exploreͷఆٛ
    DAU/WAU/MAUूܭ
    Looker
    

    View Slide

18. ©2020 Wantedly, Inc.
    ࣮૷exploreͷఆٛ
    DAU/WAU/MAUूܭ
    Looker
    

    View Slide

19. ©2020 Wantedly, Inc.
    ࣮૷exploreͷఆٛ
    DAU/WAU/MAUूܭ
    Looker
    

    View Slide

20. ©2020 Wantedly, Inc.
    ࣮૷exploreͷఆٛ
    DAU/WAU/MAUूܭ
    Looker
    

    View Slide

21. ©2020 Wantedly, Inc.
    ࣮૷
    DAU/WAU/MAUूܭ
    ࣮ݱ͍ͨ͠ूܭ
    ૑ҙ޻෉1: ۙࣅूܭؔ਺ HyperLogLogؔ਺
    
    

    View Slide

22. ©2020 Wantedly, Inc.
    ࣮ݱ͍ͨ͠ूܭ
    DAU/WAU/MAUूܭ
    BigQuery
    

    View Slide

23. ©2020 Wantedly, Inc.
    ࣮ݱ͍ͨ͠ूܭ
    DAU/WAU/MAUूܭ
    BigQuery
    

    View Slide

24. ©2020 Wantedly, Inc.
    ࣮ݱ͍ͨ͠ूܭ
    DAU/WAU/MAUूܭ
    BigQuery
    

    View Slide

25. ©2020 Wantedly, Inc.
    ࣮ݱ͍ͨ͠ूܭ
    DAU/WAU/MAUूܭ
    BigQuery
    

    View Slide

26. ©2020 Wantedly, Inc.
    ࣮૷
    DAU/WAU/MAUूܭ
    viewͷఆٛ
    ૑ҙ޻෉: bind_all_filtersύϥϝʔλʔ
    

    View Slide

27. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    DAU/WAU/MAUूܭ
    Looker
    

    View Slide

28. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    DAU/WAU/MAUूܭ
    Looker
    

    View Slide

29. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    DAU/WAU/MAUूܭ
    Looker
    

    View Slide

30. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    DAU/WAU/MAUूܭ
    Looker
    

    View Slide

31. ©2020 Wantedly, Inc.
    ิ଍
    DAU/WAU/MAUूܭ
    ୯७ͳूܭͰ͋Ε͹࠷దԽ༻ͷύϥϝʔλʔΛར༻Մೳ
    https://docs.looker.com/reference/field-params/allow_approximate_optimization
    

    View Slide

32. ©2020 Wantedly, Inc.
    DAU/WAU/MAUूܭ × Explore
    σʔλ୳ࡧ
    ίϗʔτ෼ੳ
    

    View Slide

33. ©2020 Wantedly, Inc.
    Ϟνϕʔγϣϯ
    ίϗʔτ෼ੳ
    Ϣʔβʔ
    ৽ن
    Ϣʔβʔ
    ෮ؼ
    Ϣʔβʔ
    ٳ຾
    Ϣʔβʔ
    ύϫʔ
    Ϣʔβʔ
    ܧଓ
    ֫ಘ
    ΞΫ
    ςΟϕʔ
    γ
    ϣ
    ϯ
    ࠶
    ΞΫ
    ςΟϕʔ
    γ
    ϣ
    ϯ
    ཭
    ୤
    ཭
    ୤
    ཭୤
    Ϧ
    β
    Ϩ
    Ϋ
    γ
    ϣ
    ϯ
    

    View Slide

34. ©2020 Wantedly, Inc.
    Ϟνϕʔγϣϯ
    ίϗʔτ෼ੳ
    https://amplitude.com/mastering-retention/retention-lifecycle-framework
    “Retention Lifecycle Framework” ͱͯ͠঺հ
    

    View Slide

35. ©2020 Wantedly, Inc.
    Ϟνϕʔγϣϯ
    ϥΠϑαΠΫϧ͝ͱͷಈ޲೺Ѳ
    w ৽ن / ܧଓ෮ؼٳ຾ͷ4ͭͷίϗʔτͰ෼ྨ
    w ྫ
    Ϣʔβʔ͕૿͍͑ͯΔͷ͸৽نʢ΋͘͠͸ɺ෮ؼʣͷ૿Ճͱٳ຾ͷݮগͷ͍ͣΕ͔
    Τϯήʔδϝϯτ౓߹͍͝ͱͷಈ޲೺Ѳ
    w ΧδϡΞϧίΞύϫʔͷ3ͭͷίϗʔτͰ෼ྨ
    w ྫ
    ૿͍͑ͯΔͷ͸Τϯήʔδϝϯτ౓߹͍ͷߴ͍Ϣʔβʔͱ௿͍Ϣʔβʔͷ͍ͣΕ͔
    ଐੑͱ૊Έ߹Θͤͨίϗʔτ͝ͱͷಈ޲೺Ѳ
    w ྫ
    த్͕૿͍͑ͯΔͷ͸৽نʢ΋͘͠͸ɺ෮ؼʣͷ૿Ճͱٳ຾ͷݮগͷ͍ͣΕ͔
    ίϗʔτ෼ੳ
    

    View Slide

36. ©2020 Wantedly, Inc.
    Exploreͷ࣮ݱྫ
    ίϗʔτ෼ੳ
    ϥΠϑαΠΫϧ͝ͱͷϢʔβʔ਺ਪҠ Τϯήʔδϝϯτ౓߹͍͝ͱͷϢʔβʔൺ཰ਪҠ
    

    View Slide

37. ©2020 Wantedly, Inc.
    ૑ҙ޻෉
    1. PDT
    w ࣄલूܭͱӬଓԽʹΑΔύϑΥʔϚϯε޲্
    group_labelύϥϝʔλʔ
    w ϑΟʔϧυͷ෼ྨʹΑΔརศੑ޲্
    ίϗʔτ෼ੳ
    

    View Slide

38. ©2020 Wantedly, Inc.
    ࣮૷
    ίϗʔτ෼ੳ
    viewͷఆٛ
    ૑ҙ޻෉: PDT
    

    View Slide

39. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    ίϗʔτ෼ੳ
    Looker
    

    View Slide

40. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    ίϗʔτ෼ੳ
    Looker
    

    View Slide

41. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    ίϗʔτ෼ੳ
    Looker
    

    View Slide

42. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    ίϗʔτ෼ੳ
    Looker
    

    View Slide

43. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    ίϗʔτ෼ੳ
    Looker
    

    View Slide

44. ©2020 Wantedly, Inc.
    ࣮૷viewͷఆٛ
    ίϗʔτ෼ੳ
    Looker
    

    View Slide

45. ©2020 Wantedly, Inc.
    ࣮૷
    ίϗʔτ෼ੳ
    measureͷఆٛ
    ૑ҙ޻෉: group_labelύϥϝʔλʔ
    

    View Slide

46. ©2020 Wantedly, Inc.
    ࣮૷measureͷఆٛ
    ίϗʔτ෼ੳ
    Looker
    

    View Slide

47. ©2020 Wantedly, Inc.
    ࣮૷measureͷఆٛ
    ίϗʔτ෼ੳ
    Looker
    

    View Slide

48. ©2020 Wantedly, Inc.
    άϩʔεʹ͓͚ΔExplore׆༻࣌ͷ૑ҙ޻෉
    DAU/WAU/MAUूܭ × Explore σʔλ୳ࡧ
    
    w bind_all_filtersύϥϝʔλʔ
    w ۙࣅूܭؔ਺ HyperLogLogؔ਺
    
    ίϗʔτ෼ੳ × Explore σʔλ୳ࡧ
    
    w PDT
    w group_labelύϥϝʔλʔ
    Summary
    

    View Slide

49. ©2020 Wantedly, Inc.
    άϩʔε Looker
    ×
    ૑ҙ޻෉ʹΑͬͯे෼ʹ׆༻Ͱ͖Δʂ
    

    View Slide

50. ©2020 Wantedly, Inc.
    Appendix
    

    View Slide

51. ©2020 Wantedly, Inc.
    https://mixpanel.com/ja/content/guide-to-product-analytics/chapter_2/
    ͍ͭDAU/WAU/MAUΛܭଌ͢΂͖͔ʢ͋Δ͍͸ɺ͢΂͖Ͱͳ͍͔ʣ
    

    View Slide

52. ©2020 Wantedly, Inc.
    ࠓޙ࣮ݱ͍ͨ͜͠ͱ
    https://clevertap.com/blog/cohort-analysis/
    Triangle Chart
    ִ࣌ؒؒͷࢦఆ΍ଐੑͱ૊Έ߹Θͤͨ෼ੳΛ࣮ݱ͍ͨ͠
    

    View Slide