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
EXPLORATORY 1
Slide 2
Slide 2 text
2 εϐʔΧʔ നށ ܟొ Customer Succes EXPLORATORY ུྺ େֶࡏֶதʹϑʔυϩεΛݮΒͨ͢ΊʹɺֶੜஂମΛ্ཱͪ͛දΛ ΊΔɻͦͷޙɺϏδωεΛΔͨΊʹԽֶϝʔΧʔͷσϡϙϯͱ ϑʔυςοΫܥελʔτΞοϓͰӦۀͱϚʔέςΟϯάΛܦݧɻ ΞϓϦͷͷͨΊʹσʔλαΠΤϯε͕ඞཁͩͱײ͡ɺΞϓϦʹ ಛԽͨ͠ϢʔβʔͷߦಈੳπʔϧΛ։ൃ͢ΔاۀʹͯɺΞϓϦۀք ͷKPIੳͳͲΛ୲͢Δɻ ݱࡏExploratory, Inc. ͰΧελϚʔαΫηεΛ୲͢ΔΒɺσʔ λͷՄࢹԽͱ୳ࡧతσʔλੳΛઐͱͯ͠σʔλαΠΤϯεͷීٴ ʹऔΓΉɻ @ShirotoTakato
Slide 3
Slide 3 text
3 • ࣭͝zoomͷνϟοτʹ͝ߘ͍ͩ͘͞ɻ • ηϛφʔͷײʹཱͭใΛTwitterͰϋογϡλάΛ ͚ͭͯπΠʔτΛ͓ئ͍͠·͢ɻ #Exploratoryηϛφʔ Exploratory Hour
Slide 4
Slide 4 text
Exploratory Hour
Slide 5
Slide 5 text
ࠓिͷ࣭ • ಉ͡ͷෳͷจҰͭͷจͱ্ͨ͠ͰɺԿճͷจͳ ͷ͔ٻΊ͍ͨ • ಛఆͷ͔ΒͷʢมԽʣΛ݄͝ͱʹٻΊ͍ͨ 5
Slide 6
Slide 6 text
ࠓिͷ࣭ • ಉ͡ͷෳͷจҰͭͷจͱ্ͨ͠ͰɺԿճͷจͳ ͷ͔ٻΊ͍ͨ • ಛఆͷ͔ΒͷʢมԽʣΛ݄͝ͱʹٻΊ͍ͨ 6
Slide 7
Slide 7 text
7 จσʔλ
Slide 8
Slide 8 text
8 ސ٬͝ͱʹԿճͷจ͔ΛٻΊ͍ͨ
Slide 9
Slide 9 text
ސ٬͝ͱʹจճΛٻΊΔࡍͷεςοϓ • จΛঢॱ(ͷݹ͍ॱ)Ͱฒସ͑ • ސ٬IDͰάϧʔϓԽ • ߦ൪߸ΛՃ 9
Slide 10
Slide 10 text
10 จΛঢॱ(ͷݹ͍ॱ)Ͱฒସ͑Δ
Slide 11
Slide 11 text
11 Customer IDͰάϧʔϓԽ͢Δ
Slide 12
Slide 12 text
12 ߦ൪߸Λͬͯސ٬͝ͱʹจճΛٻΊΔ
Slide 13
Slide 13 text
13 ߦ൪߸Λͬͨํ๏Ͱɺಉ͡ʹෳͷจ͕͋ͬͯɺͦΕͧΕผͷจ ͱͯ͠ٻΊΒΕͯ͠·͏ɻ
Slide 14
Slide 14 text
14 ಉ͡ʹ͋ͬͨจΛ·ͱΊͯ1ճʹΧϯτ͢Δ͜ͱͰ͖ͳ͍͔ʁ 1ճ 2ճ
Slide 15
Slide 15 text
ϥϯΫؔΛ͏͜ͱͰղܾ͢Δʂ 15
Slide 16
Slide 16 text
16 $VTUPNFS*% 0SEFS@%BUF 4BMFT " " # # # " ސ٬ͷจσʔλ
Slide 17
Slide 17 text
17 $VTUPNFS*% 0SEFS@%BUF 4BMFT " " " # # # Customer IDͰάϧʔϓԽ͢Δɻ $VTUPNFS*% 0SEFS@%BUF 4BMFT " " # # # "
Slide 18
Slide 18 text
18 Customer ID͝ͱʹάϧʔϓ͕͚ΒΕΔɻ $VTUPNFS*% 0SEFS@%BUF 4BMFT " " " # # #
Slide 19
Slide 19 text
19 จ(Order_Date)ʹରͯ͠ϥϯΫؔΛ͏͜ͱͰɺಉ͡ʹ͋Δෳͷ จΛҰͭͷจͱͯ͠ٻΊΔ͜ͱ͕Ͱ͖Δɻ $VTUPNFS*% 0SEFS@%BUF 4BMFT 3BOL " " " # # #
Slide 20
Slide 20 text
ಉ͡ʹ͋ΔෳͷจΛҰͭͷจͱͯ͠Կճͷจ͔ٻΊΔͨΊͷεςοϓ • จΛঢॱ(ͷݹ͍ॱ)Ͱฒସ͑ • ސ٬IDͰάϧʔϓԽ • ϥϯΫؔͰจճΛٻΊΔ 20
Slide 21
Slide 21 text
ಉ͡ʹ͋ΔෳͷจΛҰͭͷจͱͯ͠Կճͷจ͔ٻΊΔͨΊͷεςοϓ • จΛঢॱ(ͷݹ͍ॱ)Ͱฒସ͑ • ސ٬IDͰάϧʔϓԽ • ϥϯΫؔͰจճΛٻΊΔ 21
Slide 22
Slide 22 text
22 จͷྻϔομϝχϡʔ͔Βฒͼସ͑ͷঢॱΛબ͢Δɻ
Slide 23
Slide 23 text
23 ฒସ͑ͷμΠΞϩά͕දࣔ͞ΕΔͷͰͦͷ··࣮ߦ͢Δɻ
Slide 24
Slide 24 text
24 จΛঢॱ(ͷݹ͍ॱ)Ͱฒͼସ͑Δ͜ͱ͕Ͱ͖ͨɻ
Slide 25
Slide 25 text
ಉ͡ʹ͋ΔෳͷจΛҰͭͷจͱͯ͠Կճͷจ͔ٻΊΔͨΊͷεςοϓ • จΛঢॱ(ͷݹ͍ॱ)Ͱฒସ͑ • ސ٬IDͰάϧʔϓԽ • ϥϯΫؔͰจճΛٻΊΔ 25
Slide 26
Slide 26 text
26 ྻϔομϝχϡʔ͔ΒάϧʔϓԽΛબ͢Δɻ
Slide 27
Slide 27 text
27 Customer IDͰάϧʔϓԽ͢Δ͜ͱ͕Ͱ͖ͨɻ
Slide 28
Slide 28 text
ಉ͡ʹ͋ΔෳͷจΛҰͭͷจͱͯ͠Կճͷจ͔ٻΊΔͨΊͷεςοϓ • จΛঢॱ(ͷݹ͍ॱ)Ͱฒସ͑ • ސ٬IDͰάϧʔϓԽ • ϥϯΫؔͰจճΛٻΊΔ 28
Slide 29
Slide 29 text
29 ྻϔομϝχϡʔ͔ΒදܭࢉΛ࡞Λબ͢Δɻ
Slide 30
Slide 30 text
30 ϥϯΩϯάʹ2छྨ͋Δɻ
Slide 31
Slide 31 text
31 ϥϯΩϯάGAP͋Γ (min_rank) 1Ґ 3Ґ US Japan UK 1Ґ
Slide 32
Slide 32 text
32 $VTUPNFS*% 0SEFS@%BUF 4BMFT NJO@SBOL " " " min_rank(Order_Date)
Slide 33
Slide 33 text
33 2Ґ US Japan UK ϥϯΩϯάGAPͳ͠ (dense_rank) 1Ґ 1Ґ
Slide 34
Slide 34 text
34 $VTUPNFS*% 0SEFS@%BUF 4BMFT EFOTF@SBOL " " " dense_rank(Order_Date)
Slide 35
Slide 35 text
35 දܭࢉΛ࡞͔ΒϥϯΩϯά (Gapͳ͠)Λબ͢Δɻ
Slide 36
Slide 36 text
36 ϥϯΩϯάΛٻΊΔ͜ͱ͕Ͱ͖Δdense_rank͕ؔೖྗ͞Ε͍ͯΔɻ
Slide 37
Slide 37 text
37 ҙͷྻ໊Λೖྗ࣮ͯ͠ߦ͢Δɻ
Slide 38
Slide 38 text
38 ಉ͡ʹ͋ΔෳͷจΛҰͭͷจͱͯ͠Կճͷจ͔ٻΊΔ͜ͱ͕Ͱ͖ͨ
Slide 39
Slide 39 text
࣍ճηϛφʔ
Slide 40
Slide 40 text
40 EXPLORATORY SaaS ΞφϦςΟΫε ϫʔΫγϣοϓ #7 ίϗʔτੳ Part 2 - ੜଘੳ
Slide 41
Slide 41 text
41 • ୈ1ճɿ SaaSͷ࠷ॏཁKPI ͱͦͷՄࢹԽ Part 1 • ୈ2ճɿ SaaSͷ࠷ॏཁKPI ͱͦͷՄࢹԽ Part 2 • ୈ3ճɿ Τϯήʔδϝϯτ Part 1 - DAU/MAU • ୈ4ճɿΤϯήʔδϝϯτ Part 2 - ύϫʔϢʔβʔɾΧʔϒ • ୈ5ճɿ Τϯήʔδϝϯτ Part 3 - RFV • ୈ6ճɿίϗʔτੳ Part 1 - ϨΠϠʔɾέʔΩɾνϟʔτ • ୈ7ճɿίϗʔτੳ Part 2 - ੜଘੳ - 8/20() • ୈ8ճɿ NPSͷܭࢉͱࣗ༝هड़ͷςΩετੳ SaaS ΞφϦςΟΫεɾϫʔΫγϣοϓ
Slide 42
Slide 42 text
No content
Slide 43
Slide 43 text
No content
Slide 44
Slide 44 text
No content
Slide 45
Slide 45 text
No content
Slide 46
Slide 46 text
݄̕։࠵ʂ ฏ൛: 9݄29(Ր), 30(ਫ), 10݄1() ि൛: 9݄26(), 27(), 10݄3()
Slide 47
Slide 47 text
• ϏδωεͰ͑Δࢥߟྗͷҭ σʔλαΠΤϯεͷεΩϧशಘ͚ͩͰͳ͘ɺσʔλΛͬͨΑΓΑ͍ҙࢥܾఆΛߦ͏ͨ Ίʹඞཁͳ౷ܭతɾ֬తࢥߟྗशಘͰ͖Δɻ • ݱͰ͑ΔεΩϧͷशಘ ڭࣨͷத͚ͩͰ௨༻͢ΔཧΑΓɺ࣮ࡍͷϏδωεͷݱͰͷΛղܾ͢ΔͨΊʹ ͑ΔεΩϧͷशಘʹॏ৺Λ͓͍ͨτϨʔχϯάɻ • ϓϩάϥϛϯάͳ͠ RݴޠͷUIͰ͋ΔExploratoryΛੳπʔϧͱͯ͠༻͢ΔͨΊɺࢥߟྗͱσʔλαΠΤϯ εͷख๏ͷशಘʹ100ˋूதͰ͖Δɻ ಛ
Slide 48
Slide 48 text
No content
Slide 49
Slide 49 text
Q & A
Slide 50
Slide 50 text
Contact Email takato@exploratory.io Twitter Hashtag #ExploratoryHour ͰπΠʔτʂ Twitter @ExploratoryJp Exploratory Hour https://bit.ly/30odd9q
Slide 51
Slide 51 text
EXPLORATORY