Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

Jiro Nagashima
December 07, 2020

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

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

Jiro Nagashima

December 07, 2020
Tweet

More Decks by Jiro Nagashima

Other Decks in Technology

Transcript

  1. ©2020 Wantedly, Inc.
    άϩʔεΛՃ଎͢ΔLooker׆༻
    Looker User Meetup #5
    Dec 7, 2020 - Jiro Nagashima

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  15. ©2020 Wantedly, Inc.
    ૑ҙ޻෉
    ۙࣅूܭؔ਺ HyperLogLogؔ਺

    w ूܭ࣌ͷύϑΥʔϚϯε޲্
    bind_all_filtersύϥϝʔλʔ
    w ूܭ࣌ͷϑΟϧλʔ৚݅ࢦఆ
    DAU/WAU/MAUूܭ

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    ΞΫ
    ςΟϕʔ
    γ
    ϣ
    ϯ




    ཭୤
    Ϧ
    β
    Ϩ
    Ϋ
    γ
    ϣ
    ϯ

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  48. ©2020 Wantedly, Inc.
    άϩʔεʹ͓͚ΔExplore׆༻࣌ͷ૑ҙ޻෉
    DAU/WAU/MAUूܭ × Explore σʔλ୳ࡧ

    w bind_all_filtersύϥϝʔλʔ
    w ۙࣅूܭؔ਺ HyperLogLogؔ਺

    ίϗʔτ෼ੳ × Explore σʔλ୳ࡧ

    w PDT
    w group_labelύϥϝʔλʔ
    Summary

    View full-size slide

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

    View full-size slide

  50. ©2020 Wantedly, Inc.
    Appendix

    View full-size slide

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

    View full-size slide

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

    View full-size slide