
ãšã³ãžãã¢ã®åã匷ã¿ã掻ãããŠæœçæšé²ããããç°æ¬¡å ã®è§åºŠã§æ°åã䌞ã³ã¡ãã£ã話
ããã«ã¡ã¯ããšã³ãžãã¢ã®æ·å°(@shikichee)ã§ãã
çŸåšAIå蚺çžè«ãŠããŒã®ãããã¯ããªãŒããŒããã£ãŠããŸãã
èªåãå ¥ã£ãŠããããªããŒã¿ãŒæ°ã2ã¶æåã§5åã«

ä»åã¯ãšã³ãžãã¢ãšããŠå¹ã£ãã¹ãã«ã掻ãããªãããæœçã®ç«æ¡ããå®è¡ãŸã§è¡ãã2ã¶æåã§ãªããŒã¿ãŒæ°ã5åã«ãªã£ãäºäŸã玹ä»ã§ããã°ãšæããŸããã¿ã€ãã«ã¯è¥å¹²ãµããããã§ãããç¬
â»ãã®èšäºã¯ Ubie Advent Calendar 2020 ã® 21 æ¥ç®ã®èšäºã§ãã
0. çªç¶ã®ããŒã ç§»å&課é¡ã ããã®ç°å¢
Ubieã«å ¥ã£ãŠ3幎éãç é¢åãã®ãããã¯ãAIå蚺ãŠããŒããœãããŠã§ã¢ãšã³ãžãã¢ãšããŠãã£ãšéçºããŠãã®ã§ãããä»å¹Žã®10æã«AIå蚺çžè«ãŠããŒãšããäžè¬ãŠãŒã¶ãŒåãã®ãµãŒãã¹éçºããŒã ã«ç°åããããšã«ãªããŸããã
AIå蚺çžè«ãŠããŒãšã¯


質åã«çãããŠããšãåèç
åãé©åãªå»çæ©é¢ãåºãŠããã·ã³ãã«ãªãµãŒãã¹ã§ãããã²å
·åãæªããªã£ããšãã«äœ¿ã£ãŠã¿ãŠãã ãããhttps://ubie.app/
2022幎ã«USçïŒhttps://ubiehealth.com/ïŒããªãªãŒã¹ãããŠããŸãã
â»2023幎3æè¿œèš
éçºã¡ã³ããŒã¯ããšã³ãžãã¢ã3人ããã¶ã€ããŒ1人ã®å°ããªããŒã ã§ããã
ãªãªãŒã¹ããŠå幎çµã¡20äžåŒ±ã®MAUããã£ããã®ã®ããµãŒãã¹ãšããŠã¯äŒžã³æ©ãã§ããŸããã
課é¡ã ããã®ç°å¢ã§ããããã¯ããªãŒããŒã«
ããŒã ã«å
¥ã£ãç¬éã«ãã«ãªã¹ãªç°å¢ã ã»ã»ã»ããšæããã®ãæ£çŽãªãšããã§ãã
ç§»åããåœåãæ§ã ãªåé¡ããããŸããã
1. ç®æšèšå®ïŒç®æšãæœè±¡çã§ãæ§ã ãªèª²é¡ã«å¯Ÿå¿ããããŠãã
2. æœçç«æ¡ïŒææã«ç¹ããæœçãåºãªã
3. å®è¡ïŒäœã®ããã«ããã®ãåãããªããŸãŸéçº
æåã¯ãšã³ãžãã¢ãšããŠéåžžéãæœçã®éçºãããäºå®ã§ãããããã®ãŸãŸã§ã¯ãŸãããšæããèªåãããããã¯ããªãŒããŒã«ãªãããšã宣èšããæœçãæšé²ããŠããããšã«ããŸããã
1. äžçªæé·ã«å¯äžãã課é¡ãç¹å®ããçµæãå¯èŠåã§ããç°å¢äœã
ç®æšãæœè±¡çã§ãæ§ã
ãªèª²é¡ã«å¯Ÿå¿ããããŠããåé¡
åœæã®ããŒã ã®ç®æšæ°å€ã¯ãNPS(顧客æºè¶³åºŠ) ãé«ããããšãããã®ã§ããããµãŒãã¹ã¯å幎ããçµã£ãŠããããæ§ã
ãªåé¡ãæ±ããŠããŸããã
質åãåããã«ããããã£ãšå
·äœçãªçç¶ãå
¥ããããç
åãåèã«ãªããªããªã©ããŠãŒã¶ãŒã®å£°ãæãåºããããããããããŸãããããŒã ã«4人ããã¡ã³ããŒãããªããããå
šãŠã«å¯Ÿå¿ããŠããæã¯ãããŸããã
çæéã§ææãåºãã«ã¯ãäžçªã©ãããããã¯ãã®æé·ã«ã¬ãã¬ããžãå¹ããã€ã³ããªã®ããèŠæ¥µããã©ãŒã«ã¹ããå¿
èŠããããŸãã
誰ã«ã©ããã£ãè¡åãããŠæ¬²ããã®ãã
ã·ã³ãã«ã§ãããŸãã¯ãããæ±ºãããšããããå§ããŸããã
ã¿ãŒã²ãããŠãŒã¶ãŒã®æç¢ºå
éå»ã®ã€ã³ã¿ãã¥ãŒå
容ãèŠè¿ãã詊ãã«èªåãã©ããªãµãŒãã¹ã䜿ã£ãŠã¿ãããšããã©ã€ããŠãŒã¶ãŒãå€ãããšãåãã£ãŠããŸããã
ã©ã€ããŠãŒã¶ãŒåãã«æ©èœãäœã£ãŠãããšå¹æãããã«åºãªããããæéãè¶³ããŸããã
AIå蚺çžè«ãŠããŒãéããŠãç é¢ã«è¡ãããã©ããè¿·ã£ãŠã人ãåŸæŒãããç é¢ã«æ©ãã«è¡ã£ãŠããã£ããšæã£ãŠãããããšããããµãŒãã¹ã®äŸ¡å€ã ãšèããŸããã
èŠå»çã®äººããæé©ãªå»çæ©é¢ã«è¡ãã®ããµããŒãããããšããçŽè¿ã®ãããã¯ãã®ã³ã³ã»ãããæ±ºããã¿ãŒã²ãããšèŠãã¹ãææšãå®çŸ©ããŸããã
Before:
ã¿ãŒã²ããïŒå šãŠãŒã¶ãŒ
ææšïŒNPS(顧客æºè¶³åºŠ)
After:
ã¿ãŒã²ããïŒå¹Žéœ¢ãé«ã人ãã€ãçç¶ã®éç床ãé«ã人
ææšïŒå»çæ©é¢ã®è¡šç€ºçãå»çæ©é¢ã®è©³çŽ°è¡šç€ºç
Redashããã·ã¥ããŒãã®äœæ

ã¿ãŒã²ããã»ã°ã¡ã³ããå ã«éèŠææšãå®çŸ©ããåžžã«ããã·ã¥ããŒãã§ææ°åãèŠããããã«ããŸããã
ãšã³ãžãã¢ãšããŠãã©ã®DBã«äœã®ããŒã¿ããããåãããSQLãæžããã®ã§ãåæãä»ã®è·çš®ã®äººããç°¡åã«ã§ããŸããè¶³ããŠããªããã°ããèªåã§ä»èŸŒãããšãã§ããŸããä»åã¯ãç®æšèšå®ããããã·ã¥ããŒãäœããŸã§æ¯èŒç容æã«è¡ãããšãã§ããŸããã
2. ãšã³ãžãã¢ç®ç·ã§ã³ã¹ãã®è¯ãæœçãèãã
ææã«ç¹ããæœçãåºãªãåé¡
äžéãæãããªæ¹åç¹ãçŽããŠããæ°å€ãæ¹åããŠãã£ãã®ã§ãããããæãã以äžäŒžã³ãªããªã£ãŠããŸããã
çµæç»é¢ã§ç
åãèŠãŠãç»é¢ããé¢è±ãã人ãå€ãã£ãã®ã§ãã

ãŠãŒã¶ãŒã衚瀺ãããç
åã«å¯ŸããŠå€æãã€ãããé¢è±ããŠããã®ã§ã¯ãªãããšãã仮説ãç«ãŠãŸããã
ãã ãã©ããã£ãç
æ°ãªã®ã説ææãå
¥ããã«ãæ°åãšç
æ°ã¯ãããããçæéã§å
šãŠã®æç« ãå»åž«ã«äŸé ŒããŠäœæããŠãããããšã¯ã§ããŸããã
æ¢åã®ã¢ã»ãããæŽ»ãããã³ã¹ãæœç
ãŠããŒã¯å蚺æè¡ã匷ã¿ãšããŠæã£ãŠãããå»åž«ç£ä¿®ã®å
çç¶ãšç
æ°ã®çŽã¥ããããŒã¿ãæ°å¹Žééãç¶ããŠããŸãã
ãã®çŽä»ãããŒã¿ã䜿ã£ãŠãç
æ°ã«å¯ŸããŠããããçç¶ãèªåçæã§ããã®ã§ã¯ãªãããšèããŸãããããŒã¿ãµã€ãšã³ã¹ããŒã ãšååãSQLã§æ€èšŒãããšãã»ãŒå
šãŠã®ç
æ°ã§çŽã¥ãçç¶ãäœæããããšãã§ããŸããã

æ°æ¥ã§å®è£ ããããªãªãŒã¹åŸãå»çæ©é¢ã®è¡šç€ºçããªããŒãçãæ¥æ¿ã«äŒžã³ã¯ãããŸããã
ãšã³ãžãã¢ãšããŠããããã¯ãå éšãæ¢åã®ã¢ã»ãããçè§£ããŠãããããéçºã³ã¹ããããããªãæœçããšã³ãžãã¢ã¯èããããã§ããä»åã¯ãããŒã¿ã®ã¢ã»ããã詳现ã«çè§£ã§ããŠããããèããããšãã§ããŸããã
3. æ¯æ¥ãæ€èšŒãšåŠç¿ãã§ããéçºããŒã ã«
äœã®ããã«ãããåãããªããŸãŸã®éçº
ããŒã ã¯æ§ã
ãªåé¡ãæ±ããŠããŸãããã¹ã¯ã©ã éçºãå°å
¥ããŠãããã®ã®ãæ©èœããªãªãŒã¹ããããšãç®çåããŠããããæœçã®åªå
é äœãäŒãã£ãŠãããåã
人ã®åéã§éçºãè¡ããããããŠããç¶æ³ã§ããã
ãã®çµæããªããªãéèŠãªæœçããªãªãŒã¹ãããªãããšãããªãªãŒã¹ããããšããŠãçµæãæ€èšŒãããªãããšãå€çºããŠããŸãããABãã¹ãããã£ãŠããã®çµæãæŸçœ®ãããŠããŸããšãã£ãããšãèµ·ããŠããŸããã
æœçããšã®çµæãç©æ¥µçã«ããŒã¿ã§å¯èŠåããæåäœã
äœã®ããã«éçºããã®ããäœã®æ°å€ãæ€èšŒããã®ãæ¯åèšå®ããŸããããããŠããªãªãŒã¹åŸã®æ€èšŒçµæã®å¯èŠåãæŒããŠããæããèªåãç©æ¥µçã«SQLãæžããããŒã å
ã§å
±æããŠãããŸããã

ãã®çµæãèªç¶ãšæ°åãå
±æããã«ã«ãã£ãŒãåºæ¥äžãããããŒã¿ããªãã³ã§æææ±ºå®ã§ããããã«ãªã£ãŠããŸããã
ããã«ãABãã¹ãã®çµæãå
±æãããã£ã³ãã«ããæ®æ®µslackäžã§æãã€ããã¢ã€ãã£ã¢ãã¹ã¿ã³ãã§æŒããšãæœçãéãŸããã£ã³ãã«ãªã©ãäœã£ãŠãããŸããã

æçµçã«ã¯ãããŒã¿ãå
ã«æ°ããæ ¹æ ã®ããæœçãã¡ã³ããŒããçãŸããããã«ãªã£ãŠãããŸããã
ãšã³ãžãã¢ãšããŠããŒã ã«å ¥ã蟌ãã§ãå šå¡ã§ããŒã¿ãå ã«æœçãèããã«ã«ãã£ãŒäœããã§ããããªãšæã£ãŠããŸãã
4. çµæ
2ã¶æåã§ãªããŒã¿ãŒæ°ã䌞ã³ã
ãªããŒã¿ãŒæ°ã5åã«ãªããŸããã
ä»ããŒã ããã®å£°
ãŠããŒã§ã¯ã瀟å
ã§ããã£ãè¡åãç§°ãåãã«ã«ãã£ãŒãããã®ã§ãããä»åã®ãããžã§ã¯ãã«é¢ãããã®ããŸãšããŠã¿ãŸããã
ãªãªãŒã¹ã®é床ãçµæã«ã€ããŠã®åé¿ãããã£ãããã§ãã

ãšã³ãžãã¢äž»å°ã§æœçæšé²ããŠããå Žåã®ãã¡ãªãã
ãšã³ãžãã¢åºèº«ã ãšãã©ãããŠãå®çŸå¯èœæ§ãèããŠããŸãã®ã§ã¢ã€ãã£ã¢ãå°ãããªã£ãŠããŸãã®ãæããŸããã
æŠç¥ããéç®ããŠã倧èãªæœçãèããããšãæèçã«ãã£ãŠããå¿
èŠããããŸãã
5. ãŸãšã
ãšã³ãžãã¢ãšããŠã®åŒ·ã¿ã掻ãããŠã以äžã®3ã€ã«ã€ããŠç޹ä»ããŸããã
åãçµã¿
1. æé·ã«å¯äžãã課é¡ãç¹å®ããç®æšæ°å€ã®ããã·ã¥ããŒãå
2. æ¢åã®ã¢ã»ãããçè§£ããŠããããããã§ãããã³ã¹ãã®è¯ãæœçç«æ¡
3. ããŒã¿ãå ã«æœçãèããã«ã«ãã£ãŒäœã
çµæ
ãªããŒã¿ãŒæ°ã5åã«
åŒãç¶ãããµãŒãã¹ã®æé·ã«å šåã§ã³ãããããŠãããããšæã£ãŠããŸããä»åŸãããµãŒãã¹ã®æé·éçšã§å·¥å€«ããããšãåŠã³ãªã©ãããã°æžããŠãããŸãã
ããŠããŠããŒã§ã¯ãšã³ãžãã¢å«ããããããè·çš®ã§ç©æ¥µçã«æ¡çšè¡ã£ãŠããŸããä»åã®èšäºã§ãå°ãã§ãèå³ãæã£ãæ¹ã¯ããã²æ¡çšãµã€ãããUbieDayãšãããªã³ã©ã€ã³äŒç€Ÿèª¬æäŒãã«ãžã¥ã¢ã«é¢è«ã«ãè¶ãäžããã