Upgrade to Pro — share decks privately, control downloads, hide ads and more …

グロースを加速するLooker活用 / Leveraging Looker to accel...

Jiro Nagashima
December 07, 2020

グロースを加速するLooker活用 / Leveraging Looker to accelerate growth

Looker User Meetup Online #5 での発表内容。
https://connpass.com/event/198235/

Jiro Nagashima

December 07, 2020
Tweet

More Decks by Jiro Nagashima

Other Decks in Technology

Transcript

  1. ©2020 Wantedly, Inc. ࣗݾ঺հ WantedlyͰͷಇ͖ํ άϩʔε BI ։ൃ iOS Engineer

    Growth Lead / Growth PM BI Lead / BI Analyst 2013 2015 2020 ϓϩμΫτͷ੒௕Λ࣮ݱ͢Δ໾ׂ ϓϩμΫτͷ੒௕Λࢧ͑Δ໾ׂ
  2. ©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ଐੑ͝ͱͷಈ޲ͷ೺Ѳ w ྫ 21ଔͷֶੜ͸૿Ճ܏޲ʹ͋Δ͔ɺࢪࡦΛ࣮ࢪ͢Δͷʹे෼ͳϘϦϡʔϜ͕͋Δ͔ قઅੑɾपظੑͷ೺Ѳ w

    ྫ ֶੜͷϐʔΫ͸ྫ೥͍ͭࠒ͔ɺࢪࡦΛ࣮ࢪ͢Δͷ͸͍͕ͭଥ౰͔ ͦͷଞ w εύϜ༗ແͷ೺Ѳɺ޿ࠂύϑΥʔϚϯεͷ೺ѲͳͲ DAU/WAU/MAUूܭ
  3. ©2020 Wantedly, Inc. ૑ҙ޻෉  ۙࣅूܭؔ਺ HyperLogLogؔ਺  w ूܭ࣌ͷύϑΥʔϚϯε޲্

     bind_all_filtersύϥϝʔλʔ w ूܭ࣌ͷϑΟϧλʔ৚݅ࢦఆ DAU/WAU/MAUूܭ
  4. ©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ίϗʔτ෼ੳ Ϣʔβʔ ৽ن Ϣʔβʔ ෮ؼ Ϣʔβʔ

    ٳ຾ Ϣʔβʔ ύϫʔ Ϣʔβʔ ܧଓ ֫ಘ ΞΫ ςΟϕʔ γ ϣ ϯ ࠶ ΞΫ ςΟϕʔ γ ϣ ϯ ཭ ୤ ཭ ୤ ཭୤ Ϧ β Ϩ Ϋ γ ϣ ϯ
  5. ©2020 Wantedly, Inc. Ϟνϕʔγϣϯ ϥΠϑαΠΫϧ͝ͱͷಈ޲೺Ѳ w ৽ن / ܧଓ෮ؼٳ຾ͷ4ͭͷίϗʔτͰ෼ྨ w

    ྫ Ϣʔβʔ͕૿͍͑ͯΔͷ͸৽نʢ΋͘͠͸ɺ෮ؼʣͷ૿Ճͱٳ຾ͷݮগͷ͍ͣΕ͔ Τϯήʔδϝϯτ౓߹͍͝ͱͷಈ޲೺Ѳ w ΧδϡΞϧίΞύϫʔͷ3ͭͷίϗʔτͰ෼ྨ w ྫ ૿͍͑ͯΔͷ͸Τϯήʔδϝϯτ౓߹͍ͷߴ͍Ϣʔβʔͱ௿͍Ϣʔβʔͷ͍ͣΕ͔ ଐੑͱ૊Έ߹Θͤͨίϗʔτ͝ͱͷಈ޲೺Ѳ w ྫ த్͕૿͍͑ͯΔͷ͸৽نʢ΋͘͠͸ɺ෮ؼʣͷ૿Ճͱٳ຾ͷݮগͷ͍ͣΕ͔ ίϗʔτ෼ੳ
  6. ©2020 Wantedly, Inc. άϩʔεʹ͓͚ΔExplore׆༻࣌ͷ૑ҙ޻෉  DAU/WAU/MAUूܭ × Explore σʔλ୳ࡧ 

    w bind_all_filtersύϥϝʔλʔ w ۙࣅूܭؔ਺ HyperLogLogؔ਺   ίϗʔτ෼ੳ × Explore σʔλ୳ࡧ  w PDT w group_labelύϥϝʔλʔ Summary