Tweet
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

ࠓिͷ࣭໰ • ॅॴσʔλΛ౎ಓ෎ݝɺࢢ۠ொଜɺொ໊൪஍ʹ෼ׂ͍ͨ͠ • 1ϲ݄ޙͷ೔෇ΛٻΊ͍ͨ 5

Slide 6

Slide 6 text

ࠓिͷ࣭໰ • ॅॴσʔλΛ౎ಓ෎ݝɺࢢ۠ொଜɺொ໊൪஍ʹ෼ׂ͍ͨ͠ • 1ϲ݄ޙͷ೔෇ΛٻΊ͍ͨ 6

Slide 7

Slide 7 text

7 Airbnbͷ॓ധࢪઃσʔλ

Slide 8

Slide 8 text

8 ෺݅ͷॅॴ͸͋Δ͕ɺ౎ಓ෎ݝɺࢢ۠ொଜɺொ໊൪஍Ͱ෼͚ΒΕͨྻ͕ͳ͍ɻ

Slide 9

Slide 9 text

9 ೔ຊͷॅॴ͸౎ಓ෎ݝɺࢢ۠ொଜɺொ໊൪஍Ͱߏ੒͞Ε͍ͯΔɻ ౦ژ౎ɹौ୩۠ɹਆٶલ3ஸ໨36 ౎ಓ෎ݝ ࢢ۠ொଜ ொ໊൪஍

Slide 10

Slide 10 text

10 ॅॴΛ౎ಓ෎ݝɺࢢ۠ொଜɺொ໊൪஍ʹ෼ׂ͍ͨ͠ɻ

Slide 11

Slide 11 text

11 zipangu zipangu͸uryu͞Μ͕։ൃ͞Εͨॅॴ΍೔෇ɺ׽ࣈσʔλΛѻ ͍΍͘͢͢ΔͨΊͷύοέʔδɻ zipanguͷseparate_addressΛ࢖͏ͱॅॴΛ෼ׂͰ͖Δʂ https://cran.r-project.org/web/packages/zipangu/readme/README.html

Slide 12

Slide 12 text

12 ϓϩδΣΫτͷϝχϡʔ͔ΒɺʮR ύοέʔδͷ؅ཧʯΛબ୒͠·͢ɻ

Slide 13

Slide 13 text

13 ʮύοέʔδΛΠϯετʔϧʯͷλϒΛબͼɺʮzipanguʯͱλΠϓͯ͠ɺ ʮΠϯετʔϧʯϘλϯΛԡ͠·͢ɻ

Slide 14

Slide 14 text

14 ʮzipanguʯ͕ʮΠϯετʔϧࡁΈͷύοέʔδʯͷϦετͰνΣοΫ͞Εͯ ͍ͨΒ४උ͕׬ྃʂ

Slide 15

Slide 15 text

15 ॅॴͷྻϔομϝχϡʔ͔ΒܭࢉΛ࡞੒Λબ୒͢Δɻ

Slide 16

Slide 16 text

16 ܭࢉΛ࡞੒ͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 17

Slide 17 text

17 ܭࢉΤσΟλʹseparate_addressͱ͍͏ؔ਺Λೖྗ͠ɺׅހͷதʹ͸Ҿ਺ͱ͠ ͯॅॴͷྻ໊Λࢦఆ͢Δɻ

Slide 18

Slide 18 text

18 ॅॴΛ෼ׂͯ͠Ϧετܕͷσʔλͱͯ͠ྻΛ࡞੒͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 19

Slide 19 text

19 ϦετܕͷσʔλΛల։͢Δؔ਺ʹ͸2ͭͷλΠϓ͕͋Δɻ unnest_wider(sep_address) unnest_longer(sep_address)

Slide 20

Slide 20 text

20 unnest_widerΛ࢖ͬͯϦετܕͷσʔλΛྻʹల։͍ͨ͠ɻ

Slide 21

Slide 21 text

21 εςοϓϝχϡʔ͔ΒΧελϜRίϚϯυΛબ୒͢Δɻ

Slide 22

Slide 22 text

22 ΧελϜRίϚϯυʹԼهΛೖྗ࣮ͯ͠ߦ͢Δɻ

Slide 23

Slide 23 text

23 ϦετܕͷσʔλΛྻͰ෼ׂ͠ɺ౎ಓ෎ݝͱࢢ۠ொଜɺொ໊൪஍ͷྻΛ࡞Δ͜ ͱ͕Ͱ͖ͨɻ

Slide 24

Slide 24 text

24 zipanguͷؔ਺ྫ https://cran.r-project.org/web/packages/zipangu/readme/README.html ؔ਺ྫ ग़ྗྫ ৄࡉ TFQBSBUF@BEESFTT ౦ژ౎ौ୩۠ ਆٶલஸ໨ MJTU QSFGFDUVSF౦ژ౎ DJUZौ୩۠ TUSFFUਆٶલஸ໨ ॅॴΛ౎ಓ෎ݝɺࢢ۠ொଜɺொ໊൪஍ ʹ෼ׂ DPOWFSU@KZFBS lฏ੒ݩ೥z ݩ߸͕࢖ΘΕΔ೥දهΛ੢ྐྵʹม׵ ʢ೥ͷΈͷ৔߹ʣ DPOWFSU@KEBUF lฏ੒ݩ೥݄೔z ݩ߸͕࢖ΘΕΔ೥දهΛ੢ྐྵʹม׵ ʢ೥݄೔͕͋Δ৔߹ʣ JT@KIPMJEBZ lz 536& ೔ຊͷॕ೔͔൑ఆɻ ॕ೔ͷ৔߹͸536&͕ฦ͞ΕΔɻ LBOTVKJBSBCJD@BMM l๺ւಓࡳຈࢢ தԝ۠๺Ұ৚੢ೋஸ໨ ๺ւಓࡳຈࢢதԝ۠๺৚੢ஸ໨ ׽਺ࣈΛΞϥϏΞ਺ࣈʹม׵

Slide 25

Slide 25 text

ࠓिͷ࣭໰ • ॅॴσʔλΛ౎ಓ෎ݝɺࢢ۠ொଜɺொ໊൪஍ʹ෼ׂ͍ͨ͠ • 1ϲ݄ޙͷ೔෇ΛٻΊ͍ͨ 25

Slide 26

Slide 26 text

26 ސ٬ͷαΠϯΞοϓσʔλ

Slide 27

Slide 27 text

27 αΠϯΞοϓ͔ͯ͠Β1ϲ݄ؒ͸ແྉτϥΠΞϧ͕෇༩͞ΕΔͨΊɺτϥΠΞ ϧͷऴྃ೔Ͱ͋Δ1ϲ݄ޙͷ೔෇ΛٻΊ͍ͨɻ

Slide 28

Slide 28 text

monthsؔ਺Λ࢖͏ͱ1ϲ݄ޙͷ೔෇ΛٻΊ Δ͜ͱ͕Ͱ͖Δʂ 28

Slide 29

Slide 29 text

29 1ϲ݄ޙͷ೔෇ΛٻΊΔͨΊͷܭࢉࣜ first_date + months(1)

Slide 30

Slide 30 text

30 ྻϔομϝχϡʔ͔ΒܭࢉΛ࡞੒Λબ୒͢Δɻ

Slide 31

Slide 31 text

31 ܭࢉΛ࡞੒ͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 32

Slide 32 text

32 ܭࢉࣜΛೖྗ࣮ͯ͠ߦ͢Δɻ

Slide 33

Slide 33 text

33 τϥΠΞϧͷऴྃ೔ΛٻΊΔ͜ͱ͕Ͱ͖ͨɻ

Slide 34

Slide 34 text

34 αϚϦϏϡʔͰ֬ೝͯ͠ΈΔͱܽଛ஋͕͋ΔΑ͏ͩɻ

Slide 35

Slide 35 text

35 ςʔϒϧϏϡʔͷϑΟϧλΛΫϦοΫ͢Δɻ

Slide 36

Slide 36 text

36 • ྻʹtrial_end_dateΛબ୒͢Δɻ • ԋࢉࢠʹܽଛ஋ͷΈΛ࢒͢Λબ୒͢Δɻ

Slide 37

Slide 37 text

37 τϥΠΞϧऴྃ೔ͷྻͷܽଛ஋ͷΈΛ࢒͢͜ͱ͕Ͱ͖ͨɻ

Slide 38

Slide 38 text

38 Ͳ͏΍Βɺ2019-01-29΍2019-01-30͕ܽଛ஋ʹͳ͍ͬͯΔΑ͏ͩɻ

Slide 39

Slide 39 text

39 pSTU@EBUF USJBM@FOE@EBUF first_date + months(1) ԼهͷܭࢉͰ͸ɺ݄຤͸ߟྀ͞Εͳ͍ͨΊଘࡏ͠ͳ͍೔෇͕ٻΊΒΕ͍ͯΔɻ

Slide 40

Slide 40 text

40 pSTU@EBUF USJBM@FOE@EBUF /" /" /" first_date + months(1) ଘࡏ͠ͳ͍೔෇͸ܽଛ஋(NA)ͱͯ͠஋͕ฦ͞ΕΔɻ

Slide 41

Slide 41 text

ԋࢉࢠʹ%m+%Λ࢖͏ͱ݄຤ͷ೔෇Λߟྀ ্ͨ͠ͰܭࢉͰ͖Δɻ 41

Slide 42

Slide 42 text

42 first_date + months(1) first_date %m+% months(1) લͷ݄ΛٻΊ͍ͨ৔߹ʹ͸%m-%ʹ͢Δɻ

Slide 43

Slide 43 text

43 ԋࢉࢠΛม͑Δ͜ͱͰɺ݄຤Λߟ্ྀͨ͠Ͱ1ϲ݄ޙͷ೔෇ΛٻΊΒΕΔɻ pSTU@EBUF USJBM@FOE@EBUF first_date %m+% months(1)

Slide 44

Slide 44 text

44 ςʔϒϧϏϡʔͷϑΟϧλΛ࡟আ͢Δɻ

Slide 45

Slide 45 text

45 ઌ΄Ͳ࡞੒ͨ͠ܭࢉΛ࡞੒ͷεςοϓͷτʔΫϯΛΫϦοΫ͢Δɻ

Slide 46

Slide 46 text

46 ܭࢉΛ࡞੒ͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 47

Slide 47 text

47 ԋࢉࢠΛ%m+%ʹม࣮͑ͯߦ͢Δɻ

Slide 48

Slide 48 text

48 ݄຤Λߟ্ྀͨ͠Ͱ1ϲ݄ޙͷ೔෇ΛٻΊΔ͜ͱ͕Ͱ͖ͨɻ

Slide 49

Slide 49 text

49 αϚϦϏϡʔʹͯܽଛ஋͕ͳ͍͜ͱ΋֬ೝͰ͖Δɻ

Slide 50

Slide 50 text

࣍ճηϛφʔ

Slide 51

Slide 51 text

51 EXPLORATORY SaaS ΞφϦςΟΫε ϫʔΫγϣοϓ #9 NPSʢωοτɾϓϩϞʔλʔɾείΞʣͷܭࢉ

Slide 52

Slide 52 text

52 • ୈ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ճɿCLVʢސ٬ੜ֔Ձ஋ʣͷܭࢉ • ୈ9ճɿNPSʢωοτɾϓϩϞʔλʔɾείΞʣͷܭࢉ - 8/27(໦) • ୈ10ճɿࣗ༝هड़ͷςΩετ෼ੳ SaaS ΞφϦςΟΫε

Slide 53

Slide 53 text

No content

Slide 54

Slide 54 text

No content

Slide 55

Slide 55 text

No content

Slide 56

Slide 56 text

No content

Slide 57

Slide 57 text

݄̕։࠵ʂ ฏ೔൛: 9݄29(Ր), 30೔(ਫ), 10݄1೔(໦)

Slide 58

Slide 58 text

• ϏδωεͰ࢖͑Δࢥߟྗͷҭ੒ σʔλαΠΤϯεͷεΩϧशಘ͚ͩͰͳ͘ɺσʔλΛ࢖ͬͨΑΓΑ͍ҙࢥܾఆΛߦ͏ͨ Ίʹඞཁͳ౷ܭతɾ֬཰తࢥߟྗ΋शಘͰ͖Δɻ • ݱ৔Ͱ࢖͑ΔεΩϧͷशಘ ڭࣨͷத͚ͩͰ௨༻͢Δཧ࿦ΑΓ΋ɺ࣮ࡍͷϏδωεͷݱ৔Ͱͷ໰୊Λղܾ͢ΔͨΊʹ ࢖͑ΔεΩϧͷशಘʹॏ৺Λ͓͍ͨτϨʔχϯάɻ • ϓϩάϥϛϯάͳ͠ RݴޠͷUIͰ͋ΔExploratoryΛ෼ੳπʔϧͱͯ͠࢖༻͢ΔͨΊɺࢥߟྗͱσʔλαΠΤϯ εͷख๏ͷशಘʹ100ˋूதͰ͖Δɻ ಛ௃

Slide 59

Slide 59 text

No content

Slide 60

Slide 60 text

EDA Salon ୳ࡧతσʔλ෼ੳΛΈΜͳͰֶͿ৔

Slide 61

Slide 61 text

61 ΞϝϦΧͷେ౷ྖબͷੈ࿦ௐࠪσʔλ

Slide 62

Slide 62 text

62 σʔλͷ֓ཁ

Slide 63

Slide 63 text

63 σʔλɾσΟΫγϣφϦ

Slide 64

Slide 64 text

64 τϥϯϓࢯ·ͨ͸όΠσϯࢯͷͲͪΒ͕উ͔ͭ ༧ଌͯ͠Έ͍ͯͩ͘͞ʂ

Slide 65

Slide 65 text

No content

Slide 66

Slide 66 text

No content

Slide 67

Slide 67 text

Q & A

Slide 68

Slide 68 text

Contact Email takato@exploratory.io Twitter Hashtag #ExploratoryHour ͰπΠʔτʂ Twitter @ExploratoryJp Exploratory Hour https://bit.ly/30odd9q

Slide 69

Slide 69 text

EXPLORATORY