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.8k
グロースを加速する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.8k
UIViewPropertyAnimatorで実現するリッチなアニメーション表現
hedjirog
4
2.2k
ReactorKit at Wantedly
hedjirog
2
960
ReactorKitを利用した緩やかなアーキテクチャの移行
hedjirog
3
1.5k
限られたリソースで進める段階的なSwit移行
hedjirog
2
5.2k
エンジニア・デザイナーで取り組むグロースハック
hedjirog
6
2.3k
iOS 10 時代のアニメーション / Introduction to UIViewPropertyAnimator
hedjirog
3
3k
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
AIエージェントのオブザーバビリティについて
yunosukey
0
220
LLMの開発と社会実装の今と未来 / AI Builders' Community (ABC) vol.2
pfn
PRO
2
150
UIパフォーマンス最適化: AIを活用して100倍の速度向上を実現した事例
kinocoboy2
1
300
LangfuseではじめるAIアプリのLLMトレーシング
codenote
0
180
Ruby on Rails の楽しみ方
morihirok
6
2.5k
Part1 GitHubってなんだろう?その2
tomokusaba
2
790
Serverlessだからこそコードと設計にはこだわろう
kenichirokimura
3
1.1k
AIによるコードレビューで開発体験を向上させよう!
moongift
PRO
0
440
事業と組織から目を逸らずに技術でリードする
ogugu9
10
1.7k
LINE 購物幕後推手
line_developers_tw
PRO
0
560
VitePress & MCPでアプリ仕様のオープン化に挑戦する
hal_spidernight
0
110
Part2 GitHub Copilotってなんだろう
tomokusaba
2
820
Featured
See All Featured
VelocityConf: Rendering Performance Case Studies
addyosmani
329
24k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
8
700
The Illustrated Children's Guide to Kubernetes
chrisshort
48
49k
Code Review Best Practice
trishagee
68
18k
Reflections from 52 weeks, 52 projects
jeffersonlam
349
20k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
31
1.2k
The Power of CSS Pseudo Elements
geoffreycrofte
75
5.8k
Building Better People: How to give real-time feedback that sticks.
wjessup
368
19k
4 Signs Your Business is Dying
shpigford
183
22k
How GitHub (no longer) Works
holman
314
140k
Facilitating Awesome Meetings
lara
54
6.4k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
19
1.2k
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 ִ࣌ؒؒͷࢦఆଐੑͱΈ߹ΘͤͨੳΛ࣮ݱ͍ͨ͠