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

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

03c0e11ea6f2a3e08b3c46db5877c8e1?s=47 Jiro Nagashima
December 07, 2020

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

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

03c0e11ea6f2a3e08b3c46db5877c8e1?s=128

Jiro Nagashima

December 07, 2020
Tweet

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