å€ãã®äŒæ¥ã§ã¯ã顧客åãã®ã¢ã³ã±ãŒãã瀟å ã¢ã³ã±ãŒããªã©ãå®æœããŠãããåçã®éèšãåæã«å€ãã®ã³ã¹ããå²ããŠããŸãã
ã¢ã³ã±ãŒãå ¥å代è¡ã§ã¯ããããŸã§èªç€Ÿã§ããŠããã¢ã³ã±ãŒãåçã®å ¥åæ¥åãéèšã»åææ¥åã代è¡ããŠããããããèªç€Ÿã®æ¥åè² æ ã®åæžãå¯èœã§ãã
ãã ãã¢ã³ã±ãŒãå ¥å代è¡ãå©çšããŠããªãäŒæ¥ã¯ãã©ã®ããã«ããŠæ¥è ãéžã¶ã®ãç¥ããªãã±ãŒã¹ãå°ãªããããŸããã
ããã§ä»åã¯ãã¢ã³ã±ãŒãå ¥å代è¡ã®æŠèŠãéžã¶éã®ãã€ã³ãã解説ãããšã¯ã»ã«ã§ã¢ã³ã±ãŒãçµæãéèšããæ¹æ³ã玹ä»ããŸãã
formrunã¯ãã¢ã³ã±ãŒããäœæããããã®ããã°ã©ãã³ã°äžèŠã§ãã¢ã³ã±ãŒãåçã®éèšãèªåã§ã§ãããããåããŠã§ãå®å¿ããŠå©çšã§ããŸããããã«ãèªåè¿ä¿¡ã¡ãŒã«ããµã³ã¯ã¹ã¡ãŒã«ãåçå 容ã®ã¡ãŒã«éä¿¡ãå¯èœã§ãã
æ¡ä»¶åå²é ç®ããããªã¯ã¹åœ¢åŒã§ã®åçé ç®ã®èšçœ®ãã¢ã³ã±ãŒãã®å ±æãåã蟌ã¿ãç°¡åã«ã§ããŸãã
ç¡æãã©ã³ã¯æ°žå¹Žå©çšå¯èœã§ææãã©ã³ãç¡æãã©ã€ã¢ã«ãããããã©ã€ã¢ã«åŸã«èªåã§è«æ±ãããå¿é
ãäžèŠãªãããæ°ã«ãªãæ¹ã¯ãè©Šãã§å©çšããŠã¿ãŠãã ããã
ç®æ¬¡ [é衚瀺]
- ã¢ã³ã±ãŒãå ¥å代è¡ãšã¯ïŒ
- ã¢ã³ã±ãŒãå ¥å代è¡ãµãŒãã¹ãéžã¶ãã€ã³ã
- ãšã¯ã»ã«ã§ã¢ã³ã±ãŒããéèšããæ¹æ³
- ã¢ã³ã±ãŒãå ¥å代è¡ã«é¢é£ãããããã質å
- ã¢ã³ã±ãŒãäœæãç°¡åã«ã§ãããã©ãŒã äœæããŒã«ãformrunããããããïŒ
- ã¢ã³ã±ãŒãå ¥å代è¡ã®çµæããšã¯ã»ã«ã§éèšãããïŒ
ã¢ã³ã±ãŒãå ¥å代è¡ãšã¯ïŒ

ã¢ã³ã±ãŒãå ¥å代è¡ãšã¯ãå°éã®æ¥è ãèªç€Ÿã«ä»£ãã£ãŠã¢ã³ã±ãŒãã®å ¥åæ¥åãããŠããããµãŒãã¹ã§ãã
èªç€Ÿå ã§äººæäžè¶³ãã¹ãã«äžè¶³ã«ãªã£ãŠããå Žåã¯ã代è¡æ¥è ã«äŸé Œãããšèªç€Ÿã§è£ããªãæ¥åãè¡ã£ãŠããããããæ¥åå¹çåã«ãªããŸãããŸããã¢ã³ã±ãŒãã®éèšããåæãŸã§äŸé Œã§ããŸãã
ãã®ãããã¢ã³ã±ãŒãã®å ¥åæ¥åãåæããªãœãŒã¹äžè¶³ã§ååã«ã§ããªãäŒæ¥ã«ã¯ãæé©ã§ãã
ã¢ã³ã±ãŒãå ¥å代è¡ãµãŒãã¹ãéžã¶ãã€ã³ã

ã¢ã³ã±ãŒãå ¥å代è¡ãµãŒãã¹ãéžã¶ãã€ã³ãã¯ãäž»ã«ä»¥äžã®3ã€ã§ãã
- éèšããåæãŸã§ããŠãããã
- å ¥å粟床ãé«ãã
- æéã¯é«ããªãã
éžã¶ãã€ã³ããããããèŠãŠãããŸãããã
éèšããåæãŸã§ããŠãããã
äž»ã«æ¥åå¹çåãæ¥åè² æ ã®åæžãç®çã«ã¢ã³ã±ãŒãå ¥å代è¡ã«äŸé Œããã±ãŒã¹ãã»ãšãã©ã§ãããã®ãããäŸé Œããã¢ã³ã±ãŒãå ¥å代è¡æ¥è ãéèšããåæãŸã§ããŠããããã¯å€§åãªãã€ã³ãã§ãã
ã¢ã³ã±ãŒãã®å ¥åæ¥åã¯ããŠãããŠãéèšãåæã¯å¯Ÿå¿ããŠããªãå Žåã¯ãã¢ã³ã±ãŒãæ¥åã§æãè² æ ã®å€§ããæ¥åãæ®ãããç¶æ ã«ãªããŸãã
ååã«èªç€Ÿã®ç®çãæºãããªããããäŸé Œããå¹æã¯ã»ãšãã©åŸããããæ¥åå¹çåãæ¥åè² æ ã®åæžã¯æåŸ ã§ããŸããã
äŸé Œããå Žåã¯ããµãŒãã¹å 容ãååã«ç¢ºèªããŠããã®ãããããã§ãã
å ¥å粟床ãé«ãã
ã¢ã³ã±ãŒãã®å ¥å粟床ã®é«ãã確èªãã¹ããã€ã³ãã®1ã€ã§ãã
å®äŸ¡ã§çæéã§å¯Ÿå¿ããŠãããå ¥å代è¡ãµãŒãã¹ãå©çšããçµæããå ¥åå 容ã«èª€ããå€ãä¿®æ£ã«æéãããã£ãŠããŸãããªã©ã®ã±ãŒã¹ã¯å°ãªããããŸããã
å€éšã«æ¥åãäŸé Œããã®ã«ãé¢ãããä¿®æ£ã«æéãããã£ãŠããŸã£ãããäŸé Œããæå³ããªããªããŸãããŸãã顧客æ å ±ã®èª€ããªã©ã¯ä¿¡çšã倱ããªã¹ã¯ãããããã泚æãå¿ èŠã§ãã
ãã®ãããå ¥å代è¡æ¥è ã®è©å€ããµãŒãã¹ã®å質ãªã©ããã£ãããšç¢ºèªããŠãããŸãããã
æéã¯é«ããªãã
ã¢ã³ã±ãŒãå ¥å代è¡ãµãŒãã¹ã®æéã¯ãäž»ã«ããŒã¿1é ç®ããã0.5ã2åã»ã©ã§ãã
極端ã«å®äŸ¡ãªãµãŒãã¹ãé«é¡ãªãµãŒãã¹ãã»ãšãã©ãªããããäŸé Œããæ¥è ã«ãã£ãŠè²»çšãå€§å¹ ã«ç°ãªãã±ãŒã¹ã¯ãããŸããããã ãã¢ã³ã±ãŒãã®åç圢åŒãéžæåŒã®åäžåçã§ã¯ãªãèªç±èšè¿°ã ãšæéãæåæ°ã§èšç®ãããå Žåãããããã泚æãå¿ èŠã§ãã
ããã«ãéèšãåæã®æ¹æ³ã«å¿ããŠæéãå€åããå Žåããããããäºåã«çºçããå¯èœæ§ã®ããæéã調ã¹ãŠæ¯èŒããŠããããã«ããŸãããã
ãšã¯ã»ã«ã§ã¢ã³ã±ãŒããéèšããæ¹æ³

ãšã¯ã»ã«ã§åäžåçã®éèšãè¡ãå ŽåããCOUNTIFé¢æ°ãã䜿ããŸãã
COUNTIFé¢æ°ãšã¯ãæå®ããç¯å²å ã§æ¡ä»¶ã«åã£ãã»ã«ãæ°ããé¢æ°ã§ãã
äžèŠ§è¡šã«ãŸãšããåäžåçãå ¥åããŠããã»ã«ããã¹ãŠãCOUNTIFé¢æ°ãã§å²ã¿ãŸãããŸããéèšãããç¯å²ã®ã»ã«ã®è¡ãšåãå ¥åããåŸã«ããâãã§æ¡ä»¶ãå²ãã§å ããŸãã
- COUNTIF(E3:E15âåçâ)
è€æ°åçã®éèšãè¡ãå ŽåããSUMé¢æ°ããINDEXé¢æ°ãã®2ã€ã䜿ããŸãã
SUMé¢æ°ãšã¯æå®ããç¯å²å ã®ã»ã«ã®æ°ã®åèšå€ãæ±ããé¢æ°ã§ãINDEXé¢æ°ãšã¯æå®ããç¯å²å ã®ã»ã«ã®å€ãæ±ããé¢æ°ã§ãã
- ã=SUMïŒç¯å²ïŒã
- ãïŒINDEXïŒç¯å², B3, B9ïŒã
- ã=SUM(INDEX([ç¯å²],0,[åçªå·]))ã
以äžã®äŸãåèã«ã»ã«ã«å ¥åããã°ããšã¯ã»ã«ã§è€æ°åçã®éèšãã§ããŸãã
⌠formrunã§ã¯ãªã¢ã«ã¿ã€ã ã§åçãéèšãããã®ã§ãåççµæãããŒã«å
ã§ç°¡åã«å¯èŠåããããšãã§ããŸãã
CSVãã¡ã€ã«ãžã®ãšã¯ã¹ããŒãæ©èœãGoogleã¹ãã¬ããã·ãŒããšã®é£æºæ©èœã䜿ãã°ãã奜ããªåœ¢ã§ããŒã¿éèšãã§ããã®ã§ããã²ãå©çšããŠãã ããïŒ
ã¢ã³ã±ãŒãå ¥å代è¡ã«é¢é£ãããããã質å

ã¢ã³ã±ãŒãå ¥å代è¡ã«é¢é£ãããããã質åãæŽçããŸãããããããã®è³ªåãšåçãèŠãŠãããŸãããã
ã¢ã³ã±ãŒãå ¥åã®ãã€ãã¯ãããŸããïŒ
ã¢ã³ã±ãŒãå ¥åã®ãã€ãã¯ãããŸããŸãªæ±äººãµã€ãã§åéãããŠããŸãã
幎霢ãåŠæŽãªã©ãäžåã§ã誰ã§ãæ°è»œã«å¿åã§ããæ¡ä»¶ã«ãªã£ãŠããã±ãŒã¹ãã»ãšãã©ãªããããå°é£ã皌ããæã€ã¶ããªã©ãç®çã«ãã€ãããŠããæ¹ãããŸãããã ãæäœéããœã³ã³ãExcelãªã©ã®æäœãç解ããŠããå¿ èŠããããããçµéšããªãæ¹ã¯æ³šæãå¿ èŠã§ãã
ãŸã£ããããœã³ã³ãããŒã«ãæ±ããªãæ¹ã®å Žåãæ¡çšãããªãå¯èœæ§ããããŸãã
ã¢ã³ã±ãŒãã®åçããŒã¿å ¥åã®ãã€ãã¯åšå® ã§ã§ããŸããïŒ
ã¢ã³ã±ãŒãã®åçããŒã¿å ¥åã®ãã€ãã¯ãåšå® ã§ãã§ããŸãã
ã€ã³ã¿ãŒãããç°å¢ãæŽã£ãŠããããœã³ã³ãæã£ãŠããæ¹ã§ããã°ãäŸé Œå ããããŒã¿ããããåšå® ã§æ¥åãå¯èœã§ãããŸããæ±äººãµã€ããã¯ã©ãŠããœãŒã·ã³ã°ãµã€ãã§ã¯ãåšå® ã§ã§ããããŒã¿å ¥åæ¥åãåéããŠããäŒæ¥ãå€ããããŸãã
ãã®ãããåšå® ã§åããããšèããŠããæ¹ã¯æ¢ããŠã¿ãã®ãããããããŸãã
ã¢ã³ã±ãŒãå ¥åãç·Žç¿ãããšå ¥å代è¡ãã€ãã§åœ¹ç«ã¡ãŸããïŒ
ã¢ã³ã±ãŒãã®å ¥åæ¥åã¯ããšã«ããæåãããŒã¿ãå ¥åãç¶ããä»äºã§ãããã®ãããå ¥åäœæ¥ãæ©ãæ¹ãã¿ã€ãã³ã°ãæ©ãæ¹ã¯å ¥å代è¡ãã€ãã§åœ¹ç«ã¡ãŸãã
ã¢ã³ã±ãŒãå ¥å代è¡ã®ãã€ããåšå® ã§è¡ãå Žåãæ絊å¶ã§ã¯ãªãæåæ°ãããŒã¿ã®é ç®ããšã«å䟡ã決ãŸã£ãŠããã±ãŒã¹ãã»ãšãã©ã§ãã
ãã®ãããåãæéã§ã§ããã ãå€ãã®ãéã皌ããããšèããŠããæ¹ã¯ãå ¥åé床ãæ©ãæ¹ãæå©ã«ãªããŸãã
ãšã¯ã»ã«ã§ã¢ã³ã±ãŒãã®å ¥åãã©ãŒã ã¯äœæã§ããŸããïŒ
ãšã¯ã»ã«ã§ã¢ã³ã±ãŒãã®å ¥åãã©ãŒã ã®äœæã¯å¯èœã§ããäž»ãªäœææé ã¯ã以äžã®éãã§ãã
- éçºã¿ããéã
ïŒãã®æããšã¯ã»ã«ãããã©ã«ãã®ç¶æ ã§ã¯ãéçºã¿ããã衚瀺ãããŠããªããããããã¡ã€ã«ãâããªãã·ã§ã³ãâããªãã³ã®ãŠãŒã¶ãŒèšå®ãâãéçºãã®ãã§ãã¯ããã¯ã¹ã«ãã§ãã¯ãå ¥ããïŒ
- 質åäºé ãšè§£çæ¬ãå ¥åãã
- åçãå ¥åããã»ã«ãéžæããŠãã»ã«ã®æžåŒèšå®ããéžã¶
- ãã»ã«ã®æžåŒèšå®ããããä¿è·ããéžæããŠãããã¯ãã®ãã§ãã¯ãå€ã
- ã·ãŒãã®ä¿è·ã®èšå®ãã§ãããå®äº
ãšã¯ã»ã«ã¯ãäœã³ã¹ãã§ç°¡åã«ã¢ã³ã±ãŒãã®å ¥åãã©ãŒã ãäœæã§ãããããã¢ã³ã±ãŒããè¡ãå Žåã¯ãšã¯ã»ã«ããäœæããŠã¿ãŠãã ããã
ã¢ã³ã±ãŒãäœæãç°¡åã«ã§ãããã©ãŒã äœæããŒã«ãformrunããããããïŒ

ã¢ã³ã±ãŒãäœæãç°¡åã«ã§ãããã©ãŒã äœæããŒã«ãformrunãã®ç¹åŸŽã¯ãäž»ã«ä»¥äžã®éãã§ãã
- ãã©ãŒã äœæãç°¡åã«ã§ãã
- ã¢ã³ã±ãŒãã®åçã®éèšãèªåã§ã§ãã
- EFOïŒãã©ãŒã æé©åïŒã§åçè ã®é¢è±ãé²ãã
ããããã®ç¹åŸŽãèŠãŠãããŸãããã
ã¢ã³ã±ãŒããã©ãŒã äœæãç°¡åã«ã§ãã
éãšã³ãžãã¢ã§ãããŠã¹ã ãã®ç°¡åãªæäœäžå¿ã§ãã©ãŒã ãäœæã§ããããããã©ãŒã å©çšãŸã§ã«æºåæéãçãå Žåã«ã圹ç«ã¡ãŸãã
åããã©ãŒã äœæããŒã«ã®Googleãã©ãŒã ãšæ¯ã¹ãŠãã»ãã¥ãªãã£æ¡ä»¶ãé«ãã现ããèšå®ãŸã§æ©èœãè±å¯ãšãªã£ãŠããããã
ããžãã¹å©çšç®çã§ã¯ãformrunã®ãŠãŒã¶ãŒã®ãã¡7å²ãGoogleãã©ãŒã ããå€æŽããŠããŸãã
ã¡ãŒã«ã¢ãã¬ã¹ãããã°ç¡æç»é²å¯èœïŒç¡æéã§ç¡æãã©ã³ãå©çšã§ããããformrunã§ãã²ãã©ãŒã ãäœæããŠã¿ãŠãã ããã
ãã³ãã¬ãŒãã¯ãã¡ãããã芧ãã ãã
>> ãã³ãã¬ãŒãäžèŠ§
ã¢ã³ã±ãŒãåçã®éèšãèªåã§ã§ãã
formrunïŒãã©ãŒã ã©ã³ïŒã§ã¯ãåçããªã¢ã«ã¿ã€ã ã§éèšãããŠããããããã€ã§ãåççµæã確èªã§ããŸãã
èªåã§ããŒã¿ãã°ã©ãåãèªåã§åçããŒã¿ãäžèŠ§åã§ãããããç°¡åãªéèšã»ç¢ºèªäœæ¥ã¯formrunã§å®çµããŸãã
ãŸããGoogleã¹ãã¬ããã·ãŒããšé£æºããããŒã¿éèšãExcelãã¡ã€ã«ãžã®ãšã¯ã¹ããŒããå¯èœãªãããããè€éãªéèšäœæ¥ãå¯èœã§ãã
ãããŸã§ã¢ã³ã±ãŒãåçç¶æ³ã®å ±åã«éèšã®æéãããã£ãŠããæ¹ã¯ããã²formrunã§ã¢ã³ã±ãŒããã©ãŒã ãäœæããéèšäœæ¥ãŸã§å¹çåããŠã¿ãŠãã ããã
EFOïŒãã©ãŒã æé©åïŒã§åçè ã®é¢è±ãé²ãã
éä¿¡ããéã®ãšã©ãŒããé ç®æ°ã衚瀺ãããŠããªãããã©ãŠã¶ãééããŠéããŠããŸããªã©ã
ãã©ãŒã ã«ãŸã€ããããããäžèšã®ãããªã¹ãã¬ã¹ãåå ã§ãã©ãŒã ããé¢è±ãããŠãŒã¶ãŒã¯7å²ãè¶ ãããšèšãããŠããŸãã
ãããã®é¢è±ãé²ããããåçè ã䟿å©ã«ãã©ãŒã ãå©çšã§ããåãçµã¿ãšããŠãæ®é ç®æ°è¡šç€ºããããŒãžåå²æ©èœãå ¥åéäžä¿åããªã¢ã«ã¿ã€ã ã§ã®ãšã©ãŒè¡šç€ºæ©èœãªã©ããããŸãã
ãã®ãããŠãŒã¶ãŒã¯ããèªåã®å ¥åå 容ã«ééãããªããããããšäœåã§å®äºãããããªã©ãåžžã«ææ¡ã§ãããããåçè² æ ãå€§å¹ ã«æžããŸãã
EFOæ©èœãå°å ¥ããã«ã¯çŽ30,000åã®è²»çšããããããšãäžè¬çã§ãããformrunã§ã¯ãããã3,000åãEFOæ©èœãå°å ¥ã§ããŸãã
ãã²formrunã§EFOæ©èœãå°å
¥ãããã©ãŒã ã®ééçãäžããçµéšãããŠã¿ãŠãã ããã
ã¢ã³ã±ãŒãå ¥å代è¡ã®çµæããšã¯ã»ã«ã§éèšãããïŒ

ã¢ã³ã±ãŒãã®å ¥å代è¡ã¯ããããŸã§èªç€Ÿã§ããŠããã¢ã³ã±ãŒãã®å ¥åæ¥åãäŸé Œã§ãããããæ¥åå¹çåãæ¥åè² æ ã®åæžã«ãªããŸãããŸããæ¥è ã«ãã£ãŠã¯éèšããåæãŸã§å¯Ÿå¿ããŠããããããå€§å¹ ãªã³ã¹ãåæžãå¯èœã§ãã
ãã ãæ¥è ã«ãã£ãŠã¯ãµãŒãã¹ã®å質ãäœã察å¿ããŠããæ¥åã®å¹ ãçãå¯èœæ§ããããŸããåãæéã§äŸé Œããå Žåã§ãæ¥è ããšã«å質ãå¹æã倧ããç°ãªãå¯èœæ§ããããããå ¥å代è¡ãéžã¶éã¯ãæ éã«æ€èšããã®ã倧åã§ãã
ããããã¢ã³ã±ãŒãå ¥å代è¡ãäŸé Œããå Žåã¯ããã²åèã«ããŠã¿ãŠãã ããã
formrunã¯ãã¢ã³ã±ãŒããäœæããããã®ããã°ã©ãã³ã°äžèŠã§ãã¢ã³ã±ãŒãåçã®éèšãèªåã§ã§ãããããåããŠã§ãå®å¿ããŠå©çšã§ããŸããããã«ãèªåè¿ä¿¡ã¡ãŒã«ããµã³ã¯ã¹ã¡ãŒã«ãåçå 容ã®ã¡ãŒã«éä¿¡ãå¯èœã§ãã
æ¡ä»¶åå²é ç®ããããªã¯ã¹åœ¢åŒã§ã®åçé ç®ã®èšçœ®ãã¢ã³ã±ãŒãã®å ±æãåã蟌ã¿ãç°¡åã«ã§ããŸãã
ç¡æãã©ã³ã¯æ°žå¹Žå©çšå¯èœã§ææãã©ã³ãç¡æãã©ã€ã¢ã«ãããããã©ã€ã¢ã«åŸã«èªåã§è«æ±ãããå¿é
ãäžèŠãªãããæ°ã«ãªãæ¹ã¯ãè©Šãã§å©çšããŠã¿ãŠãã ããã
formrunããã©ãŒã äœæã顧客管çã«é¢ããæ å ±ãçºä¿¡ããŠãããŸãã
EFOïŒãšã³ããªãŒãã©ãŒã æé©åïŒãåãåãã察å¿ãªã©ã
ãã©ãŒã ã«é¢ãããæ©ã¿ã解決ããŸãã