ログの収集とBigQueryを用いた分析 / liberty of analytics
by
sesta
Link
Embed
Share
Beginning
This slide
Copy link URL
Copy link URL
Copy iframe embed code
Copy iframe embed code
Copy javascript embed code
Copy javascript embed code
Share
Tweet
Share
Tweet
Slide 1
Slide 1 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. גࣜձࣾ;0;0ςΫϊϩδʔζ Πϊϕʔγϣϯਪਐ෦ΤϯδχΞ ాमฏ ϩάͷऩूͱ #JH2VFSZΛ༻͍ͨੳ ੳΛͬͱࣗ༝ʹ
Slide 2
Slide 2 text
;0;0ςΫϊϩδʔζ Πϊϕʔγϣϯਪਐ෦ΤϯδχΞ ాमฏTFTUBͤͨ͢ Copyright © ZOZO Technologies, Inc. All Rights Reserved. ϓϩϑΟʔϧ 2 (PPHMF"TTJTUBOUपΓɺ'JSFCBTFɺ'MVUUFSΛ৮ͬͯΔ ҰࣇͷύύͰझຯఉ͍͡Γ %SPJE,BJHJͰొஃ͕ܾ·ͬͨ ͍ͭʹݸਓͰΞϓϦΛग़ͨ͠ͷͰ͖উखͤΔ ϑΝογϣϯࣙయ
Slide 3
Slide 3 text
˓ຊ࠷େڃͷϑΝογϣϯγϣοϐϯάαΠτΞϓϦ ˓ Ҏ্ͷγϣοϓɺ Ҏ্ͷϒϥϯυͷऔΓѻ͍ ˓ৗ࣌ສҎ্ͷΞΠςϜͱຖฏۉ Ҏ্ͷ৽ண Λܝࡌ ˓ଈૹαʔϏεΪϑτϥοϐϯάαʔϏεπέ͍ͳͲ IUUQ[P[PKQ Copyright © ZOZO Technologies, Inc. All Rights Reserved. 3
Slide 4
Slide 4 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. ˓ຊ࠷େڃͷϑΝογϣϯίʔσΟωʔτΞϓϦ ˓ ສμϯϩʔυಥഁɺίʔσΟωʔτߘ૯ສ݅ ˓શੈքʢ"QQ4UPSF(PPHMFQMBZ͕ར༻ՄೳͳશͯͷࠃʣͰμ ϯϩʔυ͕Մೳ ˓ສਓҎ্ͷϑΥϩϫʔΛ࣋ͭϢʔβʔʢ8&"3*45"ʣੜ IUUQTXFBSKQ 4
Slide 5
Slide 5 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. ˓͕ࣾಠࣗʹ։ൃͨ͠࠾ੇ༻ϘσΟʔεʔπ ˓શମʹࢪ͞ΕͨυοτϚʔΧʔΛεϚʔτϑΥϯΧϝϥͰࡱ Ө͢Δ͜ͱͰɺମܕσʔλΛܭଌ ˓ܭଌͨ͠ମܕσʔλɺॠ࣌ʹ%ϞσϧԽ͞Εɺ;0;0508/Ξ ϓϦʹอଘɻ%Ϟσϧ͋ΒΏΔ֯ʹಈ͔͢͜ͱ͕Ͱ͖ɺମܕΛ νΣοΫ͢Δ͜ͱ͕Մೳ IUUQ[P[PKQ[P[PTVJU 5
Slide 6
Slide 6 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. ˓ʮ;0;046*5ʯͰܭଌͨ͠ମܕσʔλΛͱʹɺҰਓͻͱΓͷମ ܕʹ߹ͬͨʮ͋ͳͨαΠζʯͷΞΠςϜ ˓ʮڀۃͷϑΟοτײʯΛ࣮ݱͨ͠ϕʔγοΫΞΠςϜΛఏڙ άϩʔόϧαΠτʮ;0;0DPNʯͰւ֎ల։ ˓ΞΠςϜ̩γϟπɺσχϜύϯπɺγϟπɺϏδωεεʔπɺ ωΫλΠɺϘʔμʔ̩γϟπɺକΫϧʔωοΫ̩γϟπͳͲ IUUQ[P[PKQQC 6
Slide 7
Slide 7 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 7 ࠓճ͢Δ ɾݸਓͰ։ൃͨ͠ʮϑΝογϣϯࣙయʯͷͰ͢
Slide 8
Slide 8 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 8 ੳ
Slide 9
Slide 9 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 9 ੳͯ͠·͔͢ʁ
Slide 10
Slide 10 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 10 Ͳ͏ͬͯ ੳͯ͠·͔͢ʁ
Slide 11
Slide 11 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 11 ੳͷΑ͋͘Δखஈ Actions on Google の Analytics 機能 Dialogflow の Analytics や History 機能
Slide 12
Slide 12 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 12 "P(%JBMPHGMPXͰΘ͔Δ͜ͱ ɾΞϓϦ͕Կճݺͼग़͞Ε͔ͨʁ ɾΤϥʔͲΕ͙Β͍͔ʁ ɾΠϯςϯτͷݺͼग़͞ΕΔॱ൪ʁ ΞϓϦશମͷ༷ࢠ "P("DUJPOTPOHPPHMF
Slide 13
Slide 13 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 13 "P(%JBMPHGMPXͰΘ͔Βͳ͍͜ͱ ɾଟ͘ΘΕ͍ͯΔݴ༿ʁ ɾ͔͚͠ΒΕ͍ͯΔ࣌ؒଳʁ ɾར༻සͷߴ͍Ϣʔβʔͷಛʁ Ұ෦ͷଆ໘ͷ༷ࢠ
Slide 14
Slide 14 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 14 ཁ ࣗ༝ʹੳ͍ͨ͠
Slide 15
Slide 15 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 15 ࣗ༝ʹੳͱ ɾ͖ͳσʔλ͚ͩൈ͖ग़͍ͨ͠ ɾൃ༰ ɾ࣌ؒଳ ɾूܭͷํΛ͍͡Γ͍ͨ ɾશମͷฏۉ ɾ࣌ؒଳ͝ͱͷ߹ܭ ɾϢʔβʔϕʔεͷதԝ #JH2VFSZ
Slide 16
Slide 16 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 16 ࣗ༝ʹੳ͢Δ·Ͱͷखॱ ੜσʔλʹΞΫηε σʔλΛ#JH2VFSZʹಉظ #JH2VFSZΛଘʹୟ͘
Slide 17
Slide 17 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 17 ੜσʔλʹΞΫηε
Slide 18
Slide 18 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 18 ੜσʔλͷ͋Δॴ ɾ4UBDLESJWFS-PHHJOH
Slide 19
Slide 19 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 19 4UBDLESJWFS-PHHJOHͱ ɾ(PPHMF$MPVEͷཧπʔϧͷͭͰɺϩάͷ֨ೲݕࡧ͕Ͱ͖Δ ϦΫΤετϨεϙϯεΛϩάͱͯ͠อଘ ϩάΛूܭͯ͠දࣔ
Slide 20
Slide 20 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 20 4UBDLESJWFS-PHHJOHʹߦ͘ํ๏ ɾ%JBMPHGMPX 4FUUJOH (FOFSBM
Slide 21
Slide 21 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 21 ੜσʔλͷ༷ࢠ ɾʮ(PPHMFΞγελϯτͷૢ࡞ʯ ͰߜΔͱग़͖ͯ·͢
Slide 22
Slide 22 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 22 σʔλΛ#JH2VFSZʹಉظ
Slide 23
Slide 23 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 23 ಉظͷํ๏ ɾ-PHHJOHͷΤΫεϙʔτΛ͏
Slide 24
Slide 24 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 24 ಉظͷઃఆͷ༷ࢠ
Slide 25
Slide 25 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 25 ඞཁͳϩά͚ͩʹϑΟϧλʔ ΞγελϯτؔͷϩάʹߜΔ ΫϩʔϥʔΛআ֎ ɾΞϓϦͷՔಈঢ়ଶΛ֬ೝͯ͠Δ ϦΫΤετ͕ఆظతʹ͘ΔͨΊ %JBMPHGMPXʹૹ͍ͬͯΔϩάʹߜΔ ɾϢʔβʔͷൃ༰͕ೖ͍ͬͯΔͷͬͪ͜ͳͷͰ
Slide 26
Slide 26 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 26 γϯΫ݁Ռ
Slide 27
Slide 27 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 27 #JH2VFSZΛଘʹୟ͘
Slide 28
Slide 28 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 28 ͖ʹୟ͖·͠ΐ͏ ɾʮςʔϒϧΛΫΤϦʯΛԡͤςϯϓϨ͕ग़ΔͷͰ ͦΕΛ͍͍ײ͡ʹ͍͡Δ
Slide 29
Slide 29 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 29 ྫʣൃ͞Εͨݴ༿ϥϯΩϯά 8*5)GPSNBUFE@KTPOBT 4&-&$5 46#453 UFYU1BZMPBE -&/(5) UFYU1BZMPBE BTKTPO KTPOҎ֎ͷ෦ΛΓऔΔ UJNFTUBNQ SFTPVSDFMBCFMTBDUJPO@JEBTBDUJPO '30.AMPHEFNPMPH@EFNP@SFRVFTUBDUJPOT@HPPHMFBQJT@DPN@BDUJPOT@A 8)&3& @5"#-&@46''*9 "/%@5"#-&@46''*9 EBUBBT 4&-&$5 +40/@&953"$5@4$"-"3 KTPO DPOWFSTBUJPODPOWFSTBUJPO*E BTDPOWFSTBUJPO*E εΩϧݺͼग़͠͝ͱͷ*% +40/@&953"$5@4$"-"3 KTPO VTFSVTFS*E BTVTFS*E Ϣʔβʔ*%ɺΞΧϯτ࿈ܞͯ͠ͳ͍߹OVMM +40/@&953"$5@4$"-"3 KTPO JOQVUT<>SBX*OQVUT<>RVFSZ BTRVFSZ ൃ༰ +40/@&953"$5@4$"-"3 KTPO JT*O4BOECPY BTJT4BOECPY ։ൃΞΧϯτ͔Ͳ͏͔ BDUJPO "DUJPOTPO(PPHMFͰೝࣝͰ͖ͨΞΫγϣϯ໊ '03."5@5*.&45".1 :NE).4 UJNFTUBNQ "TJB5PLZP BTEBUFൃͨ࣌ؒ͠ '30.GPSNBUFE@KTPO 4&-&$5RVFSZ $06/5 BTDPVOU '30.EBUB 8)&3&JT4BOECPY*4/6-- "/%RVFSZ*4/05/6-- (3061#:RVFSZ 03%&3#:DPVOU%&4$
Slide 30
Slide 30 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 30 ྫʣ࣌ؒଳ͝ͱͷεΩϧݺͼग़͠ճ 8*5)GPSNBUFE@KTPOBT 4&-&$5 46#453 UFYU1BZMPBE -&/(5) UFYU1BZMPBE BTKTPO KTPOҎ֎ͷ෦ΛΓऔΔ UJNFTUBNQ SFTPVSDFMBCFMTBDUJPO@JEBTBDUJPO '30.AMPHEFNPMPH@EFNP@SFRVFTUBDUJPOT@HPPHMFBQJT@DPN@BDUJPOT@A 8)&3& @5"#-&@46''*9 "/%@5"#-&@46''*9 EBUBBT 4&-&$5 +40/@&953"$5@4$"-"3 KTPO DPOWFSTBUJPODPOWFSTBUJPO*E BTDPOWFSTBUJPO*E εΩϧݺͼग़͠͝ͱͷ*% +40/@&953"$5@4$"-"3 KTPO VTFSVTFS*E BTVTFS*E Ϣʔβʔ*%ɺΞΧϯτ࿈ܞͯ͠ͳ͍߹OVMM +40/@&953"$5@4$"-"3 KTPO JOQVUT<>SBX*OQVUT<>RVFSZ BTRVFSZ ൃ༰ +40/@&953"$5@4$"-"3 KTPO JT*O4BOECPY BTJT4BOECPY ։ൃΞΧϯτ͔Ͳ͏͔ BDUJPO "DUJPOTPO(PPHMFͰೝࣝͰ͖ͨΞΫγϣϯ໊ '03."5@5*.&45".1 ) UJNFTUBNQ "TJB5PLZP BTIPVSൃͨ࣌ؒ͠ '30.GPSNBUFE@KTPO 4&-&$5IPVS $06/5 %*45*/$5DPOWFSTBUJPO*E BTDPVOU '30.EBUB 8)&3&JT4BOECPY*4/6-- "/%RVFSZ*4/05/6-- (3061#:IPVS 03%&3#:IPVS ※ count ഭྗΛग़ͨ͢Ίʹ͍ͬͯ·͢
Slide 31
Slide 31 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 31 ͖উखੳͰ͖ΔΑ͏ʹͳͬͨͷ͔ ɾ͖ͳσʔλ͚ͩൈ͖ग़͍ͨ͠+40/ͷதʹ͋ΔͷͳΒ͍͚Δ ɾൃ༰ ɾ࣌ؒଳ ɾूܭͷํΛ͍͡Γ͍ͨ4UBOEBSU42-͕͍͢͝ͷͰେৎ ɾશମͷฏۉ ɾ࣌ؒଳ͝ͱͷ߹ܭ ɾϢʔβʔϕʔεͷதԝ
Slide 32
Slide 32 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 32 1MVT6MUSB ͞ΒʹߴΈ
Slide 33
Slide 33 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 33 #JH2VFSZͰ͕ΔՄೳੑ ɾଞͷσʔλͱΈ߹ΘͤΔ ɾ'JSFTUPSFʹอଘͯ͠ΔϢʔβʔͷੑผ ɾ(PPHMF"OBMZUJDTͰऔͬͨߦಈཤྺ ɾ৭ʑͳΤΫεϙʔτ ɾ(PPHMFεϓϨουγʔτɺ(PPHMF%BUB4UVEJP ɾ3FEBTI
Slide 34
Slide 34 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 34 Ͱ͖ͦ͏ͳ͜ͱ ɾܗଶૉղੳ ɾͲ͔͜͠Βʹ.F$BCͳΓΛט·ͤΕ͍͚Δͣ ɾձͷϓϩηεͷੳ ɾ"DUJPOTPO(PPHMFͱͷΈ߹Θ͕ͤྑ͍͔
Slide 35
Slide 35 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 35 ·ͱΊ ɾѲ͍ͨ͜͠ͱʹ߹Θͤͯ"P(ͳͷ͔%JBMPHGMPXͳͷ͔ ·ͨɺ#JH2VFSZͳͷ͔ΛબͿΑ͏ʹ͍ͨ͠ ɾࢥͬͨΑΓ؆୯ʹूܭͰ͖ΔΑ͏ʹͳͬͨ ɾ(PPHMFʹମ͕ຬͨ͞Ε͍ͯ͘ײ֮ ɾϓϩμΫτΛ࡞Γʹڵຯ͕͋ΔํΛ͔͚͍ͯͩ͘͞ ɾҰॹʹੈքΛ͔ͬ͜Α͘͠·͠ΐ͏
Slide 36
Slide 36 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved. 36 &/%