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
小さく始めるDevOps 内製化支援から見えたDevOpsの始め方 / 20250317 Ken Takayanagi
shift_evolve
1
100
お問い合わせ対応の改善取り組みとその進め方
masartz
1
370
数百台のオンプレミスのサーバーをEKSに移行した話
yukiteraoka
0
680
大規模アジャイル開発のリアル!コミュニケーション×進捗管理×高品質
findy_eventslides
0
570
Proxmox VE超入門 〜 無料で作れるご自宅仮想化プラットフォームブックマークする
devops_vtj
0
160
「ラベルにとらわれない」エンジニアでいること/Be an engineer beyond labels
kaonavi
0
160
20250328_RubyKaigiで出会い鯛_____RubyKaigiから始まったはじめてのOSSコントリビュート.pdf
mterada1228
0
160
DevOps文化を育むQA 〜カルチャーバブルを生み出す戦略〜 / 20250317 Atsushi Funahashi
shift_evolve
1
110
職種に名前が付く、ということ/The fact that a job title has a name
bitkey
1
250
OPENLOGI Company Profile
hr01
0
61k
30代エンジニアが考える、エンジニア生存戦略~~セキュリティを添えて~~
masakiokuda
4
2k
初めてのPostgreSQLメジャーバージョンアップ
kkato1
0
440
Featured
See All Featured
The Language of Interfaces
destraynor
157
24k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
227
22k
It's Worth the Effort
3n
184
28k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
34
2.9k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
30
1.1k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
12k
Code Review Best Practice
trishagee
67
18k
Building Flexible Design Systems
yeseniaperezcruz
328
38k
4 Signs Your Business is Dying
shpigford
183
22k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
8
700
Unsuck your backbone
ammeep
670
57k
The Pragmatic Product Professional
lauravandoore
33
6.5k
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 ִ࣌ؒؒͷࢦఆଐੑͱΈ߹ΘͤͨੳΛ࣮ݱ͍ͨ͠