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
Technology
3
1.6k

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

More Decks by Jiro Nagashima

See All by Jiro Nagashima
プロダクトの成長を支えるKPI / KPIs for growing your product
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
16
3.2k
UIViewPropertyAnimatorで実現するリッチなアニメーション表現
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
4
1.5k
ReactorKit at Wantedly
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
2
580
ReactorKitを利用した緩やかなアーキテクチャの移行
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
3
1.1k
限られたリソースで進める段階的なSwit移行
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
2
4.5k
エンジニア・デザイナーで取り組むグロースハック
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
6
2k
iOS 10 時代のアニメーション / Introduction to UIViewPropertyAnimator
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
3
2.8k
How we use fastlane at Wantedly
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
9
10k
fastlaneとCircleCIではじめるアプリ配布の定期実行 / Continuous Deployment with fastlane and CircleCI
03c0e11ea6f2a3e08b3c46db5877c8e1?s=48 hedjirog
10
22k

Other Decks in Technology

See All in Technology
失敗を経験したあなたへ〜建設的なインシデントの振り返りを行うために実践するべきこと〜
8989dfee7c4a1360817fccb657d695bc?s=48 nobuakikikuchi
0
210
Spotify物理コントローラーがほしい
1dceaa2dcea41c16004f430c1723b20e?s=48 miso
0
170
Kubernetesでハマるメタバースと エッジで夢見る世界観
7c1ce501ba8a3e5ebf738a32b5811857?s=48 yudaiono
0
100
OSS ことはじめ
Eabad423977cfc6873b8f5df62b848a6?s=48 hsbt
3
590
toilを解消した話
632368cb0b90fa711cec36a082a7e24e?s=48 asumaywy
0
220
runn is a package/tool for running operations following a scenario. / golang.tokyo #32
69b93af68320a590f607c296e8edff73?s=48 k1low
1
240
成長を続ける組織でのSRE戦略：プレモーテムによる信頼性の認識共有 SRE Next 2022
Dccc861c47a9a7bfc7f71a86e1245897?s=48 niwatakeru
7
3k
[AKIBA.AWS] それ、t2.micro選んで大丈夫？
263066383f82fb9a830ff2a748f73af4?s=48 tsukuboshi
0
380
Microsoft Build 2022 - Azure のデータ & 分析サービス 最新アップデート / Microsoft Build 2022 Updates on Azure Data and Analytics Services
22ac00b36d2057e61ee1c06f0f5dc6cb?s=48 nakazax
1
210
テスト自動化の成功を支えるチームと仕組み/TestAutomation
32fe1b1b174c69d06b455799ed1fb285?s=48 goyoki
2
440
GMO pepabo and hey 2022-05-26
4ab9c4c8dec50dc08b89981e23e111f2?s=48 katsumataryo
0
100
Data-Driven Healthcare - Techplay
Bc9f06dc792f2ab663c7bf10326e649e?s=48 kotaroito
0
120

Featured

See All Featured
Faster Mobile Websites
C620790ae5bf5b50c245b2e0ef95f338?s=48 deanohume
294
28k
The Cult of Friendly URLs
Ded01cdab114abe4ec13511e4c25b9bb?s=48 andyhume
68
4.7k
Web development in the modern age
465724d73fe3a92c0879fdfb43a3a6f3?s=48 philhawksworth
197
9.3k
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
3ab1249be442027903e1180025340b3f?s=48 reverentgeek
172
8.3k
YesSQL, Process and Tooling at Scale
D09fad3e36ae6841f54820be0e907f7a?s=48 rocio
157
12k
How GitHub Uses GitHub to Build GitHub
78b475797a14c84799063c7cd073962f?s=48 holman
465
280k
What's in a price? How to price your products and services
Dad095ea7038f89f760419ce475d5d14?s=48 michaelherold
229
9.3k
Docker and Python
Ecdea9b9714877b86cee08458f085481?s=48 trallard
27
1.5k
Embracing the Ebb and Flow
C9b18d9dff88a9dd2393364c2b3b21bd?s=48 colly
73
3.3k
Statistics for Hackers
56c4053438af8e8b90d6f53cbb7573be?s=48 jakevdp
781
210k
A designer walks into a library…
15f2b8221f247985a27a627d2ece72f0?s=48 pauljervisheath
196
16k
Fireside Chat
864a009ac73600c7c02e1f26629dd989?s=48 paigeccino
11
1.3k

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