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.8k
UIViewPropertyAnimatorで実現するリッチなアニメーション表現
hedjirog
4
2.3k
ReactorKit at Wantedly
hedjirog
2
980
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
バクラクによるコーポレート業務の自動運転 #BetAIDay
layerx
PRO
1
850
AWS re:Inforce 2025 re:Cap Update Pickup & AWS Control Tower の運用における考慮ポイント
htan
1
210
製造業の課題解決に向けた機械学習の活用と、製造業特化LLM開発への挑戦
knt44kw
0
160
データ基盤の管理者からGoogle Cloud全体の管理者になっていた話
zozotech
PRO
0
340
「Roblox」の開発環境とその効率化 ~DAU9700万人超の巨大プラットフォームの開発 事始め~
keitatanji
0
110
Findy Freelance 利用シーン別AI活用例
ness
0
310
AI人生苦節10年で会得したAIがやること_人間がやること.pdf
shibuiwilliam
1
270
マルチプロダクト×マルチテナントを支えるモジュラモノリスを中心としたアソビューのアーキテクチャ
disc99
1
310
LLM 機能を支える Langfuse / ClickHouse のサーバレス化
yuu26
5
380
✨敗北解法コレクション✨〜Expertだった頃に足りなかった知識と技術〜
nanachi
1
520
Foundation Model × VisionKit で実現するローカル OCR
sansantech
PRO
0
300
마라톤 끝의 단거리 스퍼트: 2025년의 AI
inureyes
PRO
1
690
Featured
See All Featured
Facilitating Awesome Meetings
lara
54
6.5k
A Modern Web Designer's Workflow
chriscoyier
695
190k
Large-scale JavaScript Application Architecture
addyosmani
512
110k
How to train your dragon (web standard)
notwaldorf
96
6.2k
Typedesign – Prime Four
hannesfritz
42
2.7k
How to Think Like a Performance Engineer
csswizardry
25
1.8k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
30
2.2k
Fashionably flexible responsive web design (full day workshop)
malarkey
407
66k
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.4k
A Tale of Four Properties
chriscoyier
160
23k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
8
430
Git: the NoSQL Database
bkeepers
PRO
431
65k
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 ִ࣌ؒؒͷࢦఆଐੑͱΈ߹ΘͤͨੳΛ࣮ݱ͍ͨ͠