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.6k
グロースを加速する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.7k
UIViewPropertyAnimatorで実現するリッチなアニメーション表現
hedjirog
4
2.1k
ReactorKit at Wantedly
hedjirog
2
910
ReactorKitを利用した緩やかなアーキテクチャの移行
hedjirog
3
1.4k
限られたリソースで進める段階的なSwit移行
hedjirog
2
5.1k
エンジニア・デザイナーで取り組むグロースハック
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
VPoE Meetup Vol.1 VPoEとして実践してきたことと反省点
coconala_engineer
2
180
最新のWasm事情
askua
5
2.5k
RAG: from dumb implementation to serious results
glaforge
0
670
Road to Single Activity Uncovered
yurihondo
0
110
フェンリルの SwiftUI の研修を覗いてみる / Fenrir SwiftUI Training
studio_rookery
0
160
SOLID - Architecture and Architectural Decisions - Devfest Goa 2024
rivuchk
0
160
MobileActOsaka_241018.pdf
akaitadaaki
0
110
テストを楽に書きたい
tomorrowkey
2
270
JPOUG_10_20241018_OracleDB_AWS_v1.3.pdf
asahihidehiko
1
190
Reality is not an End-to-End Prediction Problem: Applied NLP in the Age of Generative AI
inesmontani
PRO
0
190
入社半年(合計1年)でGoogle Cloud 認定を全冠した秘訣🤫
risatube
1
280
サーバレスで挑む IoT プロジェクトの現実解 / Real solutions for the IoT project using serverless service
genkiogasawara
1
130
Featured
See All Featured
Keith and Marios Guide to Fast Websites
keithpitt
408
22k
Testing 201, or: Great Expectations
jmmastey
38
7k
The Language of Interfaces
destraynor
154
24k
Visualization
eitanlees
143
15k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
159
15k
What's new in Ruby 2.0
geeforr
342
31k
The Cost Of JavaScript in 2023
addyosmani
44
5.9k
Why You Should Never Use an ORM
jnunemaker
PRO
53
9k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
26
710
What’s in a name? Adding method to the madness
productmarketing
PRO
22
3.1k
Building Adaptive Systems
keathley
38
2.2k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.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 ִ࣌ؒؒͷࢦఆଐੑͱΈ߹ΘͤͨੳΛ࣮ݱ͍ͨ͠