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

会社で眠っているアクセスログを活用する5つのプラクティス/practices-to-utilize-access-logs

 会社で眠っているアクセスログを活用する5つのプラクティス/practices-to-utilize-access-logs

ikedaosushi

March 23, 2019
Tweet

More Decks by ikedaosushi

Other Decks in Technology

Transcript

  1. ϩάΛղੳ͠ଓ͚ͯΘ͔ͬͨɺ
    ձࣾͰ຾͍ͬͯΔΞΫηεϩά
    Λ׆༻͢ΔͭͷϓϥΫςΟε
    *LFEB:VUBSP!JLFEBPTVTIJ
    3BJMT%.

    View Slide

  2. ஑ా༤ଠ࿠!JLFEBPTVTIJ
    σʔλղੳػցֶश1ZUIPOϦϞʔτϫʔΫͭ͘͹ஜ೾େֶ
    ࣗݾ঺հ
    SZPQFLP͞Μ͔ΒύεΛड͚ͯདྷ·ͨ͠

    View Slide

  3. ࣗݾ঺հ

    View Slide

  4. ,BJ[FO1MBUGPSN*OD
    ,BJ[FO1MBUGPSN
    ,BJ[FO"E
    8FCαʔϏεͷ6*69վળΛ࣮ݱ͢ΔϓϥοτϑΥʔϜ
    ϞόΠϧ޿ࠂΛ1%$"Ͱվળ͢Δ
    We're Hiring!

    View Slide

  5. ,BJ[FO1MBUGPSNͰͷ࢓ࣄ
    ώʔτϚοϓπʔϧͷ࣮૷
    άϥϑ࡞੒ͷࣗಈԽͳͲ
    ղੳʹඞཁͳσʔλ͕͋Ε͹
    +4λάσʔλϑϩʔͷ࣮૷΋
    FUD

    View Slide

  6. ର৅ऀ
    ϓϩμΫτɾαʔϏεͷ
    σʔλղੳʹͳΜΒ͔ͷܗͰ
    ؔΘ͍ͬͯΔPSؔΘΓͦ͏ͳํ
    σʔλαΠΤϯςΟετʹؔΘΒͣ

    View Slide

  7. ࿩͢͜ͱ
    ཷ·͍ͬͯΔཷΊ͍ͯΔϩάͷ׆༻ํ๏
    ऩूج൫σʔλύΠϓϥΠϯͷ࿩
    3BJMTʹؔ͢Δ࿩

    View Slide

  8. ࢿྉ͸ϒϩάͰެ։͠·͢

    View Slide

  9. ΞδΣϯμ
    ෼ੳͰؕΓ΍͍͢མͱ݀͠ͱ୤ग़ํ๏
    ͳͥϩάΛ׆༻Ͱ͖ͳ͍ͷ͔
    Ұൠతͳσʔλ෼ੳϫʔΫϑϩʔ

    View Slide

  10. ͳͥϩάΛ׆༻Ͱ͖ͳ͍ͷ͔

    View Slide

  11. ϩάΛ׆༻Ͱ͖͍ͯ·͔͢ʁ
    ,BJ[FOͰ΋׆༻͖͠Ε͍ͯͳ͔ͬͨ
    ଞࣾ͞Μʹฉ͍ͯ΋׆༻Ͱ͖ͯͳ͍έʔε͕ଟ਺
    ͣͬͱϩάղੳΛ΍͖ͬͯͨ

    View Slide

  12. ͳ͔ͥ
    ʮσʔλղੳʯʹٻΊΒΕΔཁ݅ͷߴ·Γ
    ΢Σϒղੳऴྃͷ͓஌Βͤ

    http://www.pablos.jp/web-analytics/end-of-web-analytics/
    ؆୯୯७ͳղੳʹ
    ࢢ৔Ձ஋͕͋Δ࣌୅͸
    ऴΘͬͨ

    View Slide

  13. ҰےೄͰ͸͍͔ͳ͍
    ୯७ͳࢦඪΛ୯७ʹݟͤΕ͹͍͍࣌୅͸ऴΘͬͨ
    ΑΓߴ౓ͳཁ݅ʹ౴͑ΒΕΔͨΊʹ
    ղੳͷϨϕϧΛվળ͍͚ͯ͠Δϑϩʔͷ੔උ͕ඞཁ

    View Slide

  14. Ұൠతͳσʔλղੳͷ
    ϫʔΫϑϩʔ

    View Slide

  15. ҰൠతͳϫʔΫϑϩʔ
    ϏδωεαΠυ ΤϯδχΞαΠυ
    ཁ݅੔ཧ σʔλநग़
    ෼ੳ
    ใࠂ
    ར༻
    ՝୊ σʔλ

    View Slide

  16. ϋϚΓ͕ͪͳམͱ݀͠
    ͱ
    ͦͷ୤ग़ํ๏
    ͱ͍͏͔ϋϚͬͨ

    View Slide

  17. མͱ݀͠ΰʔϧ͕ͳ͍
    ϏδωεαΠυ ΤϯδχΞαΠυ
    ཁ݅੔ཧ σʔλநग़
    ෼ੳ
    ใࠂ
    ར༻
    ՝୊ σʔλ

    View Slide

  18. མͱ݀͠ΰʔϧ͕ͳ͍
    ͱΓ͋͑ͣσʔλݟͯΈΑ͏
    ࣮ମݧ
    ͜ͷล͕ؾʹͳΔ͔Βσʔλݟ͔ͯΒߟ͑Α͏

    View Slide

  19. མͱ݀͠ΰʔϧ͕ͳ͍
    ݁Ռ
    ͏ʔΜɺΑ͘Θ͔Βͳ͍ɻҧ͏σʔλΛʜ
    ໘ന͍σʔλͩͶɻͦΕͰͲ͏͢Δʁ
    ͦͯ͠ແݶϧʔϓ

    View Slide

  20. Ͳ͏͠Α͏

    View Slide

  21. ϓϥΫςΟεΠγϡʔ͔Β͸͡ΊΔ
    Πγϡʔ͔Β͸͡ΊΑ――஌తੜ࢈ͷʮγϯϓϧͳຊ࣭ʯ/ ҆୐࿨ਓ

    https://www.amazon.co.jp/dp/4862760856
    όϦϡʔΠγϡʔ౓ºղͷ࣭
    ղͷ࣭
    Πγϡʔ౓
    Πγϡʔ౓Λ্͛Δ
    ͱબ୒ࢶ͸ݶΒΕΔ
    ߴόϦϡʔ

    View Slide

  22. ࣄ৅͸ଟ໘తɺґཔ͸໘
    σʔλαΠΤϯςΟετཆ੒ಡຊ Ϗδωε׆༻ฤ

    https://www.amazon.co.jp/gp/product/B07JNLX5C4
    ΠϯλϏϡʔΛͯ͠ΠγϡʔΛଟ࣍ݩతʹ௫Ή

    View Slide

  23. ΠγϡʔΛ୳Δ࣭໰Λͯ͠ΈΔ
    ͱΓ͋͑ͣσʔλݟͯΈΑ͏
    ʮओޠʯͱʮಈࢺʯΛ୳Δ
    ͲΜͳϢʔβʔͷಈ͖ΛΈ͍ͨͰ͕͢ʁ ओޠ

    ϢʔβʔͷͲͷΞΫγϣϯΛݟ͍ͨͰ͔͢ʁ ಈࢺ

    View Slide

  24. ΠγϡʔΛ୳Δ࣭໰Λͯ͠ΈΔ
    ʮ8):ʯͰͳ͘ʮ8)&3&ʯʮ8)"5ʯʮ)08ʯ
    ͲͪΒͷํ޲ʹ޲͔͍·͔͢ʁ 8)&3&

    ԿΛݟΔ΂͖Ͱ͔͢ʁ 8)"5

    ϓϩδΣΫτ͸Ͳ͏ਐΊ·͔͢ʁ )08

    View Slide

  25. ࣍ͷམͱ݀͠

    View Slide

  26. མͱ݀͠ෳࡶ͗͢Δ
    ϏδωεαΠυ ΤϯδχΞαΠυ
    ཁ݅੔ཧ σʔλநग़
    ෼ੳ
    ใࠂ
    ར༻
    ՝୊ σʔλ

    View Slide

  27. མͱ݀͠ෳࡶ͗͢Δ
    ϢʔβʔΛձһඇձһͰ෼͚ͯɺΞΫςΟϒ
    ඇΞΫςΟϒͰ෼͚ͯFUDFUD
    ηάϝϯτ"#$%&'(Ͱ੾ͬͯ
    ސ٬ߦಈΛʜ
    ࣮ମݧ

    View Slide

  28. མͱ݀͠ෳࡶ͗͢Δ
    ݁Ռ
    ΄ͱΜͲͷ৔߹ɺ੒Ռ͕Ͱͳ͍
    μϝͩͬͨͱ͖ʹരࢮ͢Δ ΍Γ௚͠ෆՄೳ

    ηάϝϯτ෼͚ͷ޻਺େˍ૊Έ߹Θͤരൃ

    View Slide

  29. Ͳ͏͠Α͏

    View Slide

  30. ϓϥΫςΟεՄೳͳݶΓγϯϓϧʹ
    ඞཁͳ෼͚ͩෳࡶʹ
    4JNQMFJTCFUUFSUIBO"DDVSBUF
    ਫ਼៛͞ʹͩ͜ΘΒͳ͍
    Simple Data Analytics Leads impact - Speaker Deck

    https://speakerdeck.com/hik0107/simple-data-analytics-leads-impact
    4UBSUXJUI4JNQMF4PQIJTUJDBUF-BUFS
    ͋ͱ͔Βਫ਼៛ԽͰ͖Δ

    View Slide

  31. ඞཁͳ෼͚ͩෳࡶʹ
    ୯७͔ΒෳࡶʹঃʑʹϘτϧμ΢ϯ
    " #
    $ % & '

    Ͱ͖Δ্͚ͩͰࡁ·͢
    ඞཁʹͳͬͨΒ
    Լ͛Δ

    View Slide

  32. ࣍ͷམͱ݀͠

    View Slide

  33. མͱ݀݁͠ہ࢖ΘΕͳ͍
    ϏδωεαΠυ ΤϯδχΞαΠυ
    ཁ݅੔ཧ σʔλநग़
    ෼ੳ
    ใࠂ
    ར༻
    ՝୊ σʔλ

    View Slide

  34. མͱ݀݁͠ہ࢖ΘΕͳ͍
    ৽͍͠μογϡϘʔυ࡞ͬͯΈ·ͨ͠ʂ
    ͜Μͳߴ౓ͳ౷ܭղੳͰ͖·ͨ͠ʂ
    ࣮ମݧ

    View Slide

  35. མͱ݀݁͠ہ࢖ΘΕͳ͍
    ݁Ռ
    ग़ͨ͠ͱ͖͸ྑ͍൓Ԡ צҧ͍͠΍͍͢

    ͔͠͠िؒޙʹ͸୭΋ݟ͍ͯͳ͍
    Ϗδωε ͓ۚՔ͗
    ʹશ͘د༩͍ͯ͠ͳ͍

    View Slide

  36. Ͳ͏͠Α͏

    View Slide

  37. ϓϥΫςΟε࢖ΘΕ͍ͯΔ΋ͷΛ࡞Δ
    ࠓɺख࡞ۀͰग़͍ͯ͠Δ΋ͷΛࣗಈԽ͢Δ
    yuzutas0 Jupyter(Python)ͱBigQueryʹΑΔσʔλ෼ੳج൫ͷDevOps #pyconjp 

    https://speakerdeck.com/yuzutas0/20170909
    4MBDLͰάϥϑΛྲྀ͢
    ΦϖϨʔγϣϯΛ
    ࣗಈԽ
    3FDSVJU͞Μͷࣄྫ

    View Slide

  38. ϓϥΫςΟε࢖ΘΕ͍ͯΔ΋ͷΛ࡞Δ
    ,BJ[FOࣾ಺Ͱසൟʹ
    ࢖ΘΕ͍ͯͨάϥϑ
    ࣗಈͰग़ྗͰ͖ΔΑ͏
    ʹͨ͠άϥϑ

    View Slide

  39. Ͳ͏΍ͬͯ୳͔͢
    νϟοτ΍ࢿྉͰͲΜͳάϥϑ͕ڞ༗͞Ε͍ͯΔ͔
    ͲΜͳ,1*͕ձ࿩ʹΑ͘ग़ͯ͘Δͷ͔
    ؍࡯ͯ͠ΈΔ

    View Slide

  40. ࣍ͷམͱ݀͠

    View Slide

  41. མͱ݀࣍͠ʹ׆͔͞Εͳ͍
    ϏδωεαΠυ ΤϯδχΞαΠυ
    ཁ݅੔ཧ σʔλநग़
    ෼ੳ
    ใࠂ
    ར༻
    ՝୊ σʔλ

    View Slide

  42. མͱ݀࣍͠ʹ׆͔͞Εͳ͍
    ෼ੳ
    ใࠂ
    ར༻
    '#
    ϏδωεαΠυ ΤϯδχΞαΠυ

    View Slide

  43. མͱ݀࣍͠ʹ׆͔͞Εͳ͍
    ґཔ͞Ε͍ͯͨσʔλͰ͢
    ࣗ෼ͷମݧஊ
    ͋Γ͕ͱ͏͍͟͝·ͨ͠
    Ҏ্

    View Slide

  44. མͱ݀࣍͠ʹ׆͔͞Εͳ͍
    ݁Ռ
    ݁ՌΛؒҧ͑ͯ࢖ΘΕͯ͠·ͬͨ
    ෼͔ΓͮΒ͍σʔλ͸ͣͬͱ࢖ΘΕͳ͍
    ෆཁͳσʔλͳͷʹͣͬͱग़͠ଓ͚͍ͯͨ

    View Slide

  45. ΠςϨʔγϣϯΛճ͞ͳ͍ͱվળͰ͖ͳ͍
    inspiral pathways

    http://www.inspiralpathways.com/
    ϑΟʔυόοΫΛ΋ΒΘͳ͍ͱ
    ཐટ֊ஈΛొ͍͚ͬͯͳ͍

    View Slide

  46. Ͳ͏͠Α͏

    View Slide

  47. ϓϥΫςΟεϑΟʔυόοΫΛ΋Β͏
    Կ΋͠ͳ͔ͬͨΒ΄΅΋Β͑ͳ͍
    ඞͣʮϑΟʔυόοΫ͍ͩ͘͞ʯ
    "TBOBͷλεΫςϯϓϨʔτΛ࢖ͬͯ࢓૊ΈԽ

    View Slide

  48. ϑΟʔυόοΫΛ΋Β͏ϙΠϯτ
    σʔλαΠΤϯςΟετཆ੒ಡຊ Ϗδωε׆༻ฤ

    https://www.amazon.co.jp/gp/product/B07JNLX5C4
    Ͱ͖Δ͚ͩ0VUDPNFΛݟͤͯ΋Β͏

    View Slide

  49. ϑΟʔυόοΫΛ΋Β͏ϙΠϯτ
    σʔλαΠΤϯςΟετཆ੒ಡຊ Ϗδωε׆༻ฤ

    https://www.amazon.co.jp/gp/product/B07JNLX5C4
    Ͱ͖Δ͚ͩ0VUDPNFΛݟͤͯ΋Β͏
    σʔλղੳ͸ʮඞͣʯϏδωε੒ՌΛಘΔ
    ͨΊʹߦ͍ͬͯΔ

    View Slide

  50. ࣍ͷམͱ݀͠

    View Slide

  51. མͱ݀͠վળ͠ਏ͍
    ෼ੳ
    ใࠂ
    ར༻
    '#
    ϏδωεαΠυ ΤϯδχΞαΠυ

    View Slide

  52. མͱ݀͠վળ͠ਏ͍
    ͜ͷσʔλ෼ྨํ๏Λม͑ͯग़͠௚ͯ͠ཉ͍͠Ͱ͢
    42-਺ඦߦ͋ͬͯɺվमʹिؒ΄͍͠Ͱ͢
    ࣗࣾμογϡϘʔυͷ࣮૷ͷେ෯վम͕ඞཁͳͷͰདྷظͰʜ
    ͜Μͳܦݧ

    View Slide

  53. Ͳ͏͠Α͏

    View Slide

  54. ϓϥΫςΟεπʔϧΛ࢖͍෼͚Δ
    ϢʔβʔϑϨϯυϦʔ
    վम͠΍͢͞
    ಺੡μογϡϘʔυ
    ˞৔ॴ͸ձࣾʹΑΔͱࢥ͍·͢
    ࣗಈԽ͠΍͢͞

    View Slide

  55. ϓϥΫςΟεπʔϧΛ࢖͍෼͚Δ
    ϢʔβʔϑϨϯυϦʔ
    վम͠΍͢͞
    ಺੡μογϡϘʔυ
    ˞৔ॴ͸ձࣾʹΑΔͱࢥ͍·͢
    ࣗಈԽ͠΍͢͞
    ࠷ॳ͸ϢʔβʔϑϨϯυϦʔˍࣗಈԽ͸ࣺͯΔ
    ʮܕʯ͕ݟ͖͑ͯͨΒߟ͑Δ

    View Slide

  56. ϓϥΫςΟεπʔϧΛ࢖͍෼͚Δ
    ϢʔβʔϑϨϯυϦʔ
    վम͠΍͢͞
    ಺੡μογϡϘʔυ
    ˞৔ॴ͸ձࣾʹΑΔͱࢥ͍·͢
    ࣗಈԽ

    View Slide

  57. +VQZUFS)VC

    View Slide

  58. +VQZUFS)VCΛ࢖ͬͨղੳπʔϧར༻
    σʔλαΠΤϯςΟετ
    ςϯϓϨʔτΛ࢖࣮ͬͯߦ
    GFUDI
    QVTI
    ϑΟʔυόοΫ
    ϏδωεαΠυ

    View Slide

  59. +VQZUFS)VCΛ࢖ͬͨڞ༗ͷϝϦοτ
    ਺஋άϥϑͳͲ͞·͟·ͳग़ྗܗࣜʹରԠ͠΍͍͢
    ϞδϡʔϧԽ͢Δ͜ͱͰ࠶ར༻ੑ͕ߴ·Δ
    ϑΟʔυόοΫՕॴΛվमͯ͠൓ө͢Δεϐʔυ͕ߴ଎

    View Slide

  60. ͜ΕͰऴΘΓͰ͢ʂ

    View Slide

  61. ·ͱΊ

    View Slide

  62. མͱ݀͠ͱ୤ग़ํ๏
    ΰʔϧ͕ͳ͍
    ෳࡶ͗͢Δ
    ࢖ΘΕͳ͍
    ࣍ʹ׆͔͞Εͳ͍
    վળ͠ਏ͍
    ΠγϡʔΛಛఆ͢Δ࣭໰Λ
    γϯϓϧʹ͸͡ΊϘτϧμ΢ϯ
    Կ͕࢖ΘΕ͍ͯΔ͔؍࡯͢Δ
    ϑΟʔυόοΫϧʔϓΛճ͢
    πʔϧͷ࢖͍෼͚
    +VQZUFS)VCΛ࢖ͬͯΈΔ

    View Slide

  63. ·ͱΊ
    σʔλղੳͷ࣮ફϓϥΫςΟεΛ࿩͠·ͨ͠
    օ͞Μͷܦݧ΍ϓϥΫςΟε΋ੋඇڭ͍͑ͯͩ͘͞

    View Slide

  64. ࢿྉ͸ϒϩάͰެ։͠·͢

    View Slide

  65. THANK YOU
    FOR LISTENING

    View Slide