Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
グロースを加速するLooker活用 / Leveraging Looker to accel...
Search
Jiro Nagashima
December 07, 2020
Technology
3
2.9k
グロースを加速するLooker活用 / Leveraging Looker to accelerate growth
Looker User Meetup Online #5 での発表内容。
https://connpass.com/event/198235/
Jiro Nagashima
December 07, 2020
Tweet
Share
More Decks by Jiro Nagashima
See All by Jiro Nagashima
プロダクトの成長を支えるKPI / KPIs for growing your product
hedjirog
17
3.9k
UIViewPropertyAnimatorで実現するリッチなアニメーション表現
hedjirog
4
2.3k
ReactorKit at Wantedly
hedjirog
2
990
ReactorKitを利用した緩やかなアーキテクチャの移行
hedjirog
3
1.5k
限られたリソースで進める段階的なSwit移行
hedjirog
2
5.3k
エンジニア・デザイナーで取り組むグロースハック
hedjirog
6
2.4k
iOS 10 時代のアニメーション / Introduction to UIViewPropertyAnimator
hedjirog
3
3.1k
How we use fastlane at Wantedly
hedjirog
9
11k
fastlaneとCircleCIではじめるアプリ配布の定期実行 / Continuous Deployment with fastlane and CircleCI
hedjirog
10
23k
Other Decks in Technology
See All in Technology
Evolution on AI Agent and Beyond - AGI への道のりと、シンギュラリティの3つのシナリオ
masayamoriofficial
0
170
Preferred Networks (PFN) とLLM Post-Training チームの紹介 / 第4回 関東Kaggler会 スポンサーセッション
pfn
PRO
1
180
Devinを使ったモバイルアプリ開発 / Mobile app development with Devin
yanzm
0
180
LLMエージェント時代に適応した開発フロー
hiragram
1
410
JavaScript 研修
recruitengineers
PRO
2
140
7月のガバクラ利用料が高かったので調べてみた
techniczna
3
260
広島銀行におけるAWS活用の取り組みについて
masakimori
0
130
自社製CMSからmicroCMSへのリプレースがプロダクトグロースを加速させた話
nextbeatdev
0
130
Understanding Go GC #coefl_go_jp
bengo4com
0
1.1k
ECS モニタリング手法大整理
yendoooo
1
120
Yahoo!広告ビジネス基盤におけるバックエンド開発
lycorptech_jp
PRO
1
270
キャリアを支え組織力を高める「多層型ふりかえり」 / 20250821 Kazuki Mori
shift_evolve
PRO
2
300
Featured
See All Featured
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.8k
The Cult of Friendly URLs
andyhume
79
6.5k
Reflections from 52 weeks, 52 projects
jeffersonlam
351
21k
Measuring & Analyzing Core Web Vitals
bluesmoon
9
570
Build The Right Thing And Hit Your Dates
maggiecrowley
37
2.8k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
251
21k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
30
9.6k
Speed Design
sergeychernyshev
32
1.1k
Six Lessons from altMBA
skipperchong
28
4k
StorybookのUI Testing Handbookを読んだ
zakiyama
30
6k
Designing for humans not robots
tammielis
253
25k
4 Signs Your Business is Dying
shpigford
184
22k
Transcript
©2020 Wantedly, Inc. άϩʔεΛՃ͢ΔLooker׆༻ Looker User Meetup #5 Dec 7,
2020 - Jiro Nagashima
©2020 Wantedly, Inc. × άϩʔε Looker
©2020 Wantedly, Inc. × άϩʔε Explore σʔλ୳ࡧ
©2020 Wantedly, Inc. × DAU/WAU/MAUूܭ Explore σʔλ୳ࡧ ίϗʔτੳ
©2020 Wantedly, Inc. ҙ × DAU/WAU/MAUूܭ Explore σʔλ୳ࡧ ίϗʔτੳ
©2020 Wantedly, Inc. https://wantedly.com/id/jiro
©2020 Wantedly, Inc. ࣗݾհ WantedlyͰͷಇ͖ํ άϩʔε BI ։ൃ iOS Engineer
Growth Lead / Growth PM BI Lead / BI Analyst 2013 2015 2020 ϓϩμΫτͷΛ࣮ݱ͢Δׂ ϓϩμΫτͷΛࢧ͑Δׂ
©2020 Wantedly, Inc. BIνʔϜ ࡢʹ৽ઃ
©2020 Wantedly, Inc. ϛογϣϯ BIνʔϜ ҙࢥܾఆࢧԉɾఏݴ ։ൃνʔϜ ϓϩμΫτ ͷ։ൃ༏ઌΛܾΊΔࡍͷ
©2020 Wantedly, Inc. Ξτϓοτ BIνʔϜ North Star Metricબఆ KRͷඪઃఆ Ϣʔβʔηάϝϯτఆٛ
KRμογϡϘʔυઃܭ LookerҠߦ
©2020 Wantedly, Inc. ҙ
©2020 Wantedly, Inc. ίϗʔτੳ × Explore σʔλ୳ࡧ DAU/WAU/MAUूܭ
©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ଐੑ͝ͱͷಈͷѲ w ྫ 21ଔͷֶੜ૿Ճʹ͋Δ͔ɺࢪࡦΛ࣮ࢪ͢ΔͷʹेͳϘϦϡʔϜ͕͋Δ͔ قઅੑɾपظੑͷѲ w
ྫ ֶੜͷϐʔΫྫ͍ͭࠒ͔ɺࢪࡦΛ࣮ࢪ͢Δͷ͍͕ͭଥ͔ ͦͷଞ w εύϜ༗ແͷѲɺࠂύϑΥʔϚϯεͷѲͳͲ DAU/WAU/MAUूܭ
©2020 Wantedly, Inc. Exploreͷ࣮ݱྫ DAU/WAU/MAUूܭ ࣍ͷDAU/WAU/MAUਪҠ
©2020 Wantedly, Inc. ҙ ۙࣅूܭؔ HyperLogLogؔ w ूܭ࣌ͷύϑΥʔϚϯε্
bind_all_filtersύϥϝʔλʔ w ूܭ࣌ͷϑΟϧλʔ݅ࢦఆ DAU/WAU/MAUूܭ
©2020 Wantedly, Inc. ࣮ DAU/WAU/MAUूܭ exploreͷఆٛ
©2020 Wantedly, Inc. ࣮exploreͷఆٛ DAU/WAU/MAUूܭ Looker
©2020 Wantedly, Inc. ࣮exploreͷఆٛ DAU/WAU/MAUूܭ Looker
©2020 Wantedly, Inc. ࣮exploreͷఆٛ DAU/WAU/MAUूܭ Looker
©2020 Wantedly, Inc. ࣮exploreͷఆٛ DAU/WAU/MAUूܭ Looker
©2020 Wantedly, Inc. ࣮ DAU/WAU/MAUूܭ ࣮ݱ͍ͨ͠ूܭ ҙ1: ۙࣅूܭؔ HyperLogLogؔ
©2020 Wantedly, Inc. ࣮ݱ͍ͨ͠ूܭ DAU/WAU/MAUूܭ BigQuery
©2020 Wantedly, Inc. ࣮ݱ͍ͨ͠ूܭ DAU/WAU/MAUूܭ BigQuery
©2020 Wantedly, Inc. ࣮ݱ͍ͨ͠ूܭ DAU/WAU/MAUूܭ BigQuery
©2020 Wantedly, Inc. ࣮ݱ͍ͨ͠ूܭ DAU/WAU/MAUूܭ BigQuery
©2020 Wantedly, Inc. ࣮ DAU/WAU/MAUूܭ viewͷఆٛ ҙ: bind_all_filtersύϥϝʔλʔ
©2020 Wantedly, Inc. ࣮viewͷఆٛ DAU/WAU/MAUूܭ Looker
©2020 Wantedly, Inc. ࣮viewͷఆٛ DAU/WAU/MAUूܭ Looker
©2020 Wantedly, Inc. ࣮viewͷఆٛ DAU/WAU/MAUूܭ Looker
©2020 Wantedly, Inc. ࣮viewͷఆٛ DAU/WAU/MAUूܭ Looker
©2020 Wantedly, Inc. ิ DAU/WAU/MAUूܭ ୯७ͳूܭͰ͋Ε࠷దԽ༻ͷύϥϝʔλʔΛར༻Մೳ https://docs.looker.com/reference/field-params/allow_approximate_optimization
©2020 Wantedly, Inc. DAU/WAU/MAUूܭ × Explore σʔλ୳ࡧ ίϗʔτੳ
©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ίϗʔτੳ Ϣʔβʔ ৽ن Ϣʔβʔ ෮ؼ Ϣʔβʔ
ٳ Ϣʔβʔ ύϫʔ Ϣʔβʔ ܧଓ ֫ಘ ΞΫ ςΟϕʔ γ ϣ ϯ ࠶ ΞΫ ςΟϕʔ γ ϣ ϯ Ϧ β Ϩ Ϋ γ ϣ ϯ
©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ίϗʔτੳ https://amplitude.com/mastering-retention/retention-lifecycle-framework “Retention Lifecycle Framework” ͱͯ͠հ
©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ϥΠϑαΠΫϧ͝ͱͷಈѲ w ৽ن / ܧଓ෮ؼٳͷ4ͭͷίϗʔτͰྨ w
ྫ Ϣʔβʔ͕૿͍͑ͯΔͷ৽نʢ͘͠ɺ෮ؼʣͷ૿Ճͱٳͷݮগͷ͍ͣΕ͔ Τϯήʔδϝϯτ߹͍͝ͱͷಈѲ w ΧδϡΞϧίΞύϫʔͷ3ͭͷίϗʔτͰྨ w ྫ ૿͍͑ͯΔͷΤϯήʔδϝϯτ߹͍ͷߴ͍Ϣʔβʔͱ͍Ϣʔβʔͷ͍ͣΕ͔ ଐੑͱΈ߹Θͤͨίϗʔτ͝ͱͷಈѲ w ྫ த్͕૿͍͑ͯΔͷ৽نʢ͘͠ɺ෮ؼʣͷ૿Ճͱٳͷݮগͷ͍ͣΕ͔ ίϗʔτੳ
©2020 Wantedly, Inc. Exploreͷ࣮ݱྫ ίϗʔτੳ ϥΠϑαΠΫϧ͝ͱͷϢʔβʔਪҠ Τϯήʔδϝϯτ߹͍͝ͱͷϢʔβʔൺਪҠ
©2020 Wantedly, Inc. ҙ 1. PDT w ࣄલूܭͱӬଓԽʹΑΔύϑΥʔϚϯε্ group_labelύϥϝʔλʔ
w ϑΟʔϧυͷྨʹΑΔརศੑ্ ίϗʔτੳ
©2020 Wantedly, Inc. ࣮ ίϗʔτੳ viewͷఆٛ ҙ: PDT
©2020 Wantedly, Inc. ࣮viewͷఆٛ ίϗʔτੳ Looker
©2020 Wantedly, Inc. ࣮viewͷఆٛ ίϗʔτੳ Looker
©2020 Wantedly, Inc. ࣮viewͷఆٛ ίϗʔτੳ Looker
©2020 Wantedly, Inc. ࣮viewͷఆٛ ίϗʔτੳ Looker
©2020 Wantedly, Inc. ࣮viewͷఆٛ ίϗʔτੳ Looker
©2020 Wantedly, Inc. ࣮viewͷఆٛ ίϗʔτੳ Looker
©2020 Wantedly, Inc. ࣮ ίϗʔτੳ measureͷఆٛ ҙ: group_labelύϥϝʔλʔ
©2020 Wantedly, Inc. ࣮measureͷఆٛ ίϗʔτੳ Looker
©2020 Wantedly, Inc. ࣮measureͷఆٛ ίϗʔτੳ Looker
©2020 Wantedly, Inc. άϩʔεʹ͓͚ΔExplore׆༻࣌ͷҙ DAU/WAU/MAUूܭ × Explore σʔλ୳ࡧ
w bind_all_filtersύϥϝʔλʔ w ۙࣅूܭؔ HyperLogLogؔ ίϗʔτੳ × Explore σʔλ୳ࡧ w PDT w group_labelύϥϝʔλʔ Summary
©2020 Wantedly, Inc. άϩʔε Looker × ҙʹΑͬͯेʹ׆༻Ͱ͖Δʂ
©2020 Wantedly, Inc. Appendix
©2020 Wantedly, Inc. https://mixpanel.com/ja/content/guide-to-product-analytics/chapter_2/ ͍ͭDAU/WAU/MAUΛܭଌ͖͔͢ʢ͋Δ͍ɺ͖͢Ͱͳ͍͔ʣ
©2020 Wantedly, Inc. ࠓޙ࣮ݱ͍ͨ͜͠ͱ https://clevertap.com/blog/cohort-analysis/ Triangle Chart ִ࣌ؒؒͷࢦఆଐੑͱΈ߹ΘͤͨੳΛ࣮ݱ͍ͨ͠