ãã®èšäºã®ãããã¯ã¯æ¬¡ã®ãšããã§ãã
- ãã¹ãŠã®è¡šåœ¢åŒããŒã¿ã¢ãã«ã®ãã¹ã ãã©ã¯ãã£ã¹
- 衚圢åŒã® AutoML ã¢ãã«ã®ãã¹ã ãã©ã¯ãã£ã¹
- 衚圢åŒã®äºæž¬ã¢ãã«ã®ãã¹ã ãã©ã¯ãã£ã¹
- ããŒã¿åœ¢åŒã®ãã¹ã ãã©ã¯ãã£ã¹
ãã¹ãŠã®è¡šåœ¢åŒããŒã¿ã¢ãã«ã®ãã¹ã ãã©ã¯ãã£ã¹
以äžã®ãã¹ã ãã©ã¯ãã£ã¹ã¯ãAutoML ã¢ãã«ãŸãã¯è¡šåœ¢åŒããŒã¿ã䜿çšããã«ã¹ã¿ã ãã¬ãŒãã³ã° ã¢ãã«ãäœæããå Žåã«é©çšãããŸãã
ããŒã¿æŒæŽ©ãé¿ãã
æšè«ãæ±ããéã«å©çšã§ããªãäºæž¬æ å ±ããã¬ãŒãã³ã° ããŒã¿ã«å«ãŸããŠãããšãããŒã¿æŒæŽ©ãçºçããŸããããŒã¿æŒæŽ©ããããšãã¢ãã«ã¯åªããè©äŸ¡ææšã瀺ããŸãããå®éã®ããŒã¿ã§ã¯ããã©ãŒãã³ã¹ãæªåããŸãã
ããšãã°ãææ¥ã©ã®ãããã®éã®ã¢ã€ã¹ã¯ãªãŒã ã売ãããç¥ããããšããŸããã¿ãŒã²ãããšããæ¥ã®æ°æž©ããã¬ãŒãã³ã° ããŒã¿ã«å«ããããšã¯ã§ããŸãããæªæ¥ã®æ£ç¢ºãªæ°æž©ã¯äºåã«ã¯ããããªãããã§ãããã ãã忥ããäºæž¬ããæ°æž©ãæšè«ãªã¯ãšã¹ãã«å«ããããšã¯ã§ããŸãã
è€æ°ã®ããŒã¿åå²ã§åãããŒã¿ã䜿çšããå ŽåãããŒã¿æŒæŽ©ãçºçããå¯èœæ§ããããŸããæç³»åããŒã¿ã䜿çšããå Žåã¯ãåãæ¥ä»ã®ããŒã¿ã 3 ã€ã®ããŒã¿åå²ã®ããããã§ã®ã¿äœ¿çšãããããã«ããŸãã
ãã¬ãŒãã³ã° / ãµãŒãã³ã° ã¹ãã¥ãŒãé¿ãã
ãã¬ãŒãã³ã° / ãµãŒãã³ã° ã¹ãã¥ãŒã¯ãæšè«ããªã¯ãšã¹ãããããã«äœ¿çšããããŒã¿ãäœæããã®ãšç°ãªãæ¹æ³ã§ãã¬ãŒãã³ã° ããŒã¿ãäœæãããšèµ·ãããŸãã
ããšãã°å¹³åå€ã䜿çšããå Žåã§ããã¬ãŒãã³ã°ã®é㯠10 æ¥éã®å¹³åãåºããæšè«ããªã¯ãšã¹ããããšãã¯éå» 1 ãæã®å¹³åãåºããªã©ã§ãã
äžè¬ã«ããã¬ãŒãã³ã° ããŒã¿ãäœæããæ¹æ³ãšãµãŒãã³ã° ããŒã¿ïŒæšè«ãçæããããã«äœ¿çšããããŒã¿ïŒãäœæããæ¹æ³ã®éã«éããããå Žåã¯ããã¬ãŒãã³ã° / ãµãŒãã³ã° ã¹ãã¥ãŒãé²ãããã«ç¢ºèªããå¿ èŠããããŸãã
ãã¬ãŒãã³ã° / ãµãŒãã³ã° ã¹ãã¥ãŒãšããŒã¿ååž
ãã¬ãŒãã³ã° / ãµãŒãã³ã° ã¹ãã¥ãŒã¯ããã¬ãŒãã³ã°ãæ€èšŒããã¹ãã®ããŒã¿åå²ã«ãããããŒã¿ååžã«åºã¥ããŠçºçããããšããããŸããæ¬çªç°å¢ã«ãããã€ããããšãã«ã¢ãã«ã«ç€ºãããããŒã¿ååžãšãã¢ãã«ã®ãã¬ãŒãã³ã°ã«äœ¿çšãããããŒã¿ã»ããã®ããŒã¿ååžã«ã¯ãå€ãã®å ŽåéãããããŸããããšãã°ãæ¬çªç°å¢ã§ã¯ãã¢ãã«ã¯ããã¬ãŒãã³ã°äžã«èŠãããã®ãšã¯ãŸã£ããç°ãªããŠãŒã¶ãŒã®éå£ã«é©çšãããããšããããŸãããŸããæçµçãªãã¬ãŒãã³ã° ããŒã¿ãèšé²ãããŠãã 30 æ¥åŸã«æšè«ã«äœ¿çšãããããšããããŸãã
æè¯ã®çµæãåŸãã«ã¯ãã¢ãã«ã®äœæã«äœ¿çšãããããŒã¿åå²ã®ååžãããã¬ãŒãã³ã° ããŒã¿ãšæ¬çªç°å¢ã§æšè«ãè¡ãããŒã¿ã®éããæ£ç¢ºã«åæ ããããã«ããŸããVertex AI ã¯å調ã§ãªãæšè«ãçæããå¯èœæ§ããããŸããæ¬çªç°å¢ã®ããŒã¿ããã¬ãŒãã³ã° ããŒã¿ãšã¯éåžžã«ç°ãªãååžãããµã³ããªã³ã°ãããå Žåãå調ã§ãªãæšè«ã¯ããŸãä¿¡é Œæ§ããããŸããã
ããã«ãæ¬çªç°å¢ã®ããŒã¿ãšãã¬ãŒãã³ã° ããŒã¿ã®éãã¯ãæ€èšŒããŒã¿åå²ãšãã¬ãŒãã³ã° ããŒã¿åå²ã®éããããã³ãã¹ãããŒã¿åå²ãšæ€èšŒããŒã¿åå²ã®éãã«åæ ãããå¿ èŠããããŸãã
ããšãã°ãä»åŸ 30 æ¥éã®ãŠãŒã¶ãŒã®ã©ã€ãã¿ã€ã ããªã¥ãŒïŒLTVïŒã«ã€ããŠæšè«ãè¡ãå Žåã¯ãæ€èšŒããŒã¿åå²ã®ããŒã¿ããã¬ãŒãã³ã° ããŒã¿åå²ã®ããŒã¿ãã 30 æ¥åŸã®ããŒã¿ã§ããããã¹ãããŒã¿åå²ã®ããŒã¿ãæ€èšŒããŒã¿åå²ã®ããŒã¿ãã 30 æ¥åŸã®ããŒã¿ã§ããããšã確èªããŸãã
åæ§ã«ãã¢ãã«ã調æŽããŠæ°ãããŠãŒã¶ãŒã«é¢ããäžè¬çãªæšè«ãè¡ãå Žåã¯ãç¹å®ã®ãŠãŒã¶ãŒã®ããŒã¿ããã¬ãŒãã³ã° ããŒã¿ã® 1 ã€ã®åå²ã®ã¿ã«å«ãŸããããã«ããŸããããšãã°ãuser1
ã«é¢é£ãããã¹ãŠã®è¡ã¯ãã¬ãŒãã³ã° ããŒã¿åå²ã«å«ãŸããuser2
ã«é¢é£ãããã¹ãŠã®è¡ã¯æ€èšŒããŒã¿åå²ã«å«ãŸããuser3
ã«é¢é£ãããã¹ãŠã®è¡ã¯ãã¹ãããŒã¿åå²ã«å«ãŸããããã«ããŸãã
ã¿ã€ã ã·ã°ãã«ãæäŸãã
åé¡ã¢ãã«ãšååž°ã¢ãã«ã§ãããŒã¿ã®åºç€ãšãªããã¿ãŒã³ãæéã®çµéãšãšãã«å€åããå¯èœæ§ãããå ŽåïŒæéå ã§ã©ã³ãã ã«ååžããŠããªãå ŽåïŒããã®æ å ±ã Vertex AI ã«æäŸããŸããã¿ã€ã ã·ã°ãã«ã¯ã次ã®ãããªæ¹æ³ã§æäŸã§ããŸãã
ããŒã¿ã®åè¡ã«ã¿ã€ã ã¹ã¿ã³ããããå Žåã¯ããã®åãå«ããããã«ãã倿åã
Timestamp
ã§ãããã¢ãã«ããã¬ãŒãã³ã°ãããšãã«ã[æé] åãšããŠèšå®ãããããã«ããŸãããã®é åºä»ãã¯ãããŒã¿ãåå²ããŠãææ°ã®ããŒã¿ããã¹ãããŒã¿ã«ããæå€ã®ããŒã¿ããã¬ãŒãã³ã° ããŒã¿ãšããããã«äœ¿çšãããŸãã詳现[æé] åã«ããåå¥ã®å€ãå€ããªãå Žåã¯ã[æé] åã䜿çšããã®ã§ã¯ãªããæååå²ã䜿çšããŠããŒã¿ãåå²ããŸããããããªããšãåããŒã¿ã»ããã§ååãªè¡ãåŸãããããã¬ãŒãã³ã°ã倱æããå¯èœæ§ããããŸãã
æå»æ å ±ãåäžã®åã«å«ãŸããŠããªãå Žåã¯ãæåããŒã¿åå²ã䜿çšããŠææ°ã®ããŒã¿ããã¹ãããŒã¿ãšããŠäœ¿çšããæãå€ãããŒã¿ããã¬ãŒãã³ã° ããŒã¿ãšããŠäœ¿çšã§ããŸãã
æ å ±ãå¿ èŠã«å¿ããŠæç¢ºåãã
äžéšã®ããŒã¿ ããªããã£ãã§ã¯ãç¹åŸŽãèšèšããããšã«ãã£ãŠã¢ãã«ã®å質ãåäžãããããšãã§ããŸãã
ããšãã°ãããŒã¿ã«çµåºŠãšç·¯åºŠãå«ãŸããŠããå Žåããããã®åã¯æ°å€ãšããŠæ±ãããç¹å¥ãªèšç®ã¯è¡ãããŸãããå Žæãè·é¢ãåé¡ã®ã·ã°ãã«ãåºãå Žåã¯ããã®æ å ±ãæç€ºçã«æäŸããç¹åŸŽãèšèšããŸãã
ç¹åŸŽãšã³ãžãã¢ãªã³ã°ãå¿ èŠã«ãªãããšãããäžéšã®ããŒã¿åãæ¬¡ã«ç€ºããŸãã
- çµåºŠ / 緯床
- URL
- IP ã¢ãã¬ã¹
- ã¡ãŒã«ã¢ãã¬ã¹
- é»è©±çªå·
- ãã®ä»ã®å°çã³ãŒãïŒéµäŸ¿çªå·ãªã©ïŒ
èšç®ããŒã¿ãŸãã¯éèšããŒã¿ãè¡ã«å«ãã
Vertex AI ã¯ã1 è¡ã®å ¥åããŒã¿ã®ã¿ã䜿çšããŠããã®è¡ã®ã¿ãŒã²ããå€ãäºæž¬ããŸããè¡ã®äºæž¬å€ã®æ±ºå®ã«åœ¹ç«ã€ä»ã®è¡ããœãŒã¹ã®èšç®ããŒã¿ãŸãã¯éèšããŒã¿ãããå Žåã¯ããã®ããŒã¿ããœãŒã¹è¡ã«å«ããŸããæ°ããåã§ããŒã¿æŒæŽ©ããã¬ãŒãã³ã° / ãµãŒãã³ã° ã¹ãã¥ãŒãçºçããªãããã«æ³šæããŠãã ããã
ããšãã°ãååã®ç¿é±ã®éèŠãäºæž¬ããå Žåãæ¬¡ã®å€ãæã€åãå«ããããšã§æšè«ã®åè³ªãæ¹åã§ããŸãã
- ååãšåãã«ããŽãªã®åšåº«åç®ã®åèšæ°ã
- ååãšåãã«ããŽãªã®åšåº«åç®ã®å¹³åäŸ¡æ Œã
- æšè«ããªã¯ãšã¹ãããããšãããæ¢ç¥ã®äŒæ¥ãŸã§ã®æ¥æ°ã
å¥ã®äŸã§ã¯ãç¹å®ã®ãŠãŒã¶ãŒãååãè³Œå ¥ãããã©ãããäºæž¬ããå Žåãæ¬¡ã®å€ãæã€åãå«ããããšã§æšè«ã®åè³ªãæ¹åã§ããŸãã
- ç¹å®ã®ãŠãŒã¶ãŒã®éå»ã®å¹³åã³ã³ããŒãžã§ã³çãŸãã¯ã¯ãªãã¯çã
- çŸåšãŠãŒã¶ãŒã®ã·ã§ããã³ã° ã«ãŒãã«ããååã®æ°ã
åããé¿ãã
ãã¬ãŒãã³ã° ããŒã¿ã¯ãæšè«ã®å¯Ÿè±¡ãšãªãæœåšçããŒã¿ã®å šé åã衚ããã®ã«ãªãããã«ããŠãã ãããããšãã°ã顧客ãäžçäžã«ããå Žåã¯ã1 ã€ã®åœã ãã®ãã¬ãŒãã³ã° ããŒã¿ã䜿çšããªãã§ãã ããã
衚圢åŒã® AutoML ã¢ãã«ã®ãã¹ã ãã©ã¯ãã£ã¹
AutoML 衚圢åŒã®ã¢ãã«çšã«è¡šåœ¢åŒã®ãã¬ãŒãã³ã° ããŒã¿ãäœæããã®ããã¹ã ãã©ã¯ãã£ã¹ã§ãã
null å€ãé©åã«è¡šã
CSV ããã€ã³ããŒãããå Žåãnull å€ã¯ç©ºã®æååã§è¡šããŠãã ãããBigQuery ããã€ã³ããŒãããå Žåã¯ãNULL å€ã䜿çšããŠãã ããã
ããŒã¿ã§ç¹æ®æåãŸãã¯æ°åã䜿çšã㊠null å€ïŒãŒããå«ãïŒã衚ããšããããã®å€ã誀ã£ãŠè§£éãããã¢ãã«ã®å質ãäœäžããŸãã
å¯èœã§ããã°æ¬ æå€ãé¿ãã
ããŒã¿ã«æ¬ æå€ããªãã確èªããå¯èœã§ããã°ä¿®æ£ããŸãããã以å€ã®å Žåã¯ãå€ã空çœã®ãŸãŸã«ã㊠null å€ãšããŠæ±ãããšãã§ããŸãã
ã¹ããŒã¹ã䜿ã£ãŠããã¹ããåºåã
Vertex AI ã¯ããã¹ãæååãããŒã¯ã³åããŠãåã ã®åèªãããã¬ãŒãã³ã° ã·ã°ãã«ãå°ãåºãããšãã§ããŸããåèªã¯ã¹ããŒã¹ã§åºåããããããä»ã®æåã§åºåãããŠããåèªã¯ 1 ã€ã®ãšã³ãã£ãã£ãšããŠæ±ãããŸãã
ããšãã°ãããã¹ããred/green/blueããæå®ããå Žåããredãããgreenãããblueãã«ããŒã¯ã³åãããŸããããããã®åã ã®åèªãã¢ãã«ã®ãã¬ãŒãã³ã°ã§éèŠã«ãªããããããªãå Žåã¯ããã®ããã¹ãããred green blueãã«å€æããŠãããã¬ãŒãã³ã° ããŒã¿ã«å«ããŠãã ããã
ã«ããŽãªåã®ç¹åŸŽãæ£ç¢ºãã€ã¯ãªãŒã³ã«ãã
ããŒã¿ã®äžæŽåãåå ã§ã«ããŽãªã誀ã£ãŠåå²ãããå¯èœæ§ããããŸããããšãã°ãããŒã¿ã«ãBrownããšãbrownããå«ãŸããŠããå Žåããã®å€ãåãã«ããŽãªãšèããŠããå Žåã§ããVertex AI ã¯å¥ã®ã«ããŽãªãšããŠäœ¿çšããŸããã¹ãã«ãã¹ãåæ§ã®çµæã«ãªããŸãããã¬ãŒãã³ã° ããŒã¿ãäœæããåã«ãããããçš®é¡ã®äžæŽåãã«ããŽãªããŒã¿ããåé€ããŠãããŠãã ããã
åé¡ã¢ãã«ã®ã¯ã©ã¹ã®äžåè¡¡ã«ååã«æ³šæãã
ã¯ã©ã¹ãäžåè¡¡ïŒãã£ãã«èŠãããªãã1 ã€ä»¥äžã®çµæã«é¢é£ããåé¡äžã®åé¡ïŒã§ããå Žåã¯ã次ã®ãã³ããã芧ãã ããã
å°æ°æŽŸã®ã¯ã©ã¹ã«ååãªãã¬ãŒãã³ã° ããŒã¿ãçšæãã
1 ã€ã®ã¯ã©ã¹ã§ããŒã¿ãæ°è¡ãããªããšãã¢ãã«ã®è³ªãäœäžããŸããå¯èœã§ããã°ããã¹ãŠã®ã¯ã©ã¹ã« 100 è¡ä»¥äžã®ããŒã¿ãçšæããŠãã ããã
æååå²ã®äœ¿çšãæ€èšãã
Vertex AI ã¯ããã¹ã ããŒã¿ã»ããã®è¡ãã©ã³ãã ã«ïŒããã確å®çã«ïŒéžæããŸããã¯ã©ã¹ãäžåè¡¡ã§ããå Žåããã¹ã ããŒã¿ã»ããã«å°æ°æŽŸã®ã¯ã©ã¹ããããããããããããã¯ãŸã£ããå«ãŸããããã¬ãŒãã³ã°ã倱æããããšããããŸãã
ã¯ã©ã¹ãäžåè¡¡ã§ããå Žåã¯ãæååå²ãå²ãåœãŠãŠãå°æ°æŽŸã®çµæãå«ãååãªè¡æ°ããã¹ãŠã®åå²ã«å«ããããšãã§ããŸãã
ååãªãã¬ãŒãã³ã° ããŒã¿ãçšæãã
ååãªãã¬ãŒãã³ã° ããŒã¿ãæäŸããªãå ŽåãçµæãšããŠåŸãããã¢ãã«ã®ããã©ãŒãã³ã¹ãæªããªãå ŽåããããŸããã¢ãã«ã®ãã¬ãŒãã³ã°ã«äœ¿çšããåãå€ãã»ã©ãæäŸããå¿ èŠãããããŒã¿ã¯å€ããªããŸãã
ããŒã¿ã»ããã¯å¿ ã 1,000 è¡ä»¥äžã«ããªããã°ãªããŸããã
次ã®è¡šã¯ãç®çã«å¿ããŠãçšæãããã¬ãŒãã³ã° ããŒã¿éã«é¢ãããã¥ãŒãªã¹ãã£ã¯ã¹ã瀺ãããã®ã§ãã
ç®ç | æšå¥šããããã¬ãŒãã³ã° ããŒã¿ã®æå°é |
---|---|
åé¡ | åæ°ã® 10 å以äžã®è¡æ°ã |
äºæž¬ | ã¢ãã«ã®ãã¬ãŒãã³ã°ã«äœ¿çšããåããšã« 10 以äžã®æç³»åã |
ååž° | åæ°ã® 50 å以äžã®è¡æ°ã |
ä»ã®ãã¹ãŠã®ååŠçãšå€æã Vertex AI ã«æ®ã
ç¹ã«æãã®ãªãéããAutoML ã¢ãã«ããã¬ãŒãã³ã°ãããšãã«ãVertex AI ã«ç¹åŸŽéãšã³ãžãã¢ãªã³ã°ãå§ããŸããAutoML ã¯ãåºã«ãªãããŒã¿ã«ã¢ã¯ã»ã¹ã§ããå Žåã«æè¯ã®æ§èœãçºæ®ããŸããAutoML ã倿ã¿ã€ãã§è¡ããã¹ãŠã®å€æã«ã€ããŠã¯ãVertex AI ã®å€æãã芧ãã ããã
衚圢åŒã®äºæž¬ã¢ãã«ã®ãã¹ã ãã©ã¯ãã£ã¹
äºæž¬ã¢ãã«çšã®ãã¬ãŒãã³ã° ããŒã¿ã«ã¯ãç¹å¥ãªèæ ®äºé ããããŸãã
ããŒã¿ã®ç²åºŠãéžæããéã®èæ ®äºé
äºæž¬ã¢ãã«ããã¬ãŒãã³ã°ããå Žåã¯ãããŒã¿ã®ç²åºŠãã€ãŸããã¬ãŒãã³ã° ããŒã¿è¡ã®éã®æéééãæå®ããŸããæéééã¯ãæéãæ¥ãé±ãæã幎ã®åäœã§æå®ã§ããŸãããŸãã1 åããšã5 åããšã10 åããšã15 åããšã30 åããšã®åäœã§ãæå®ã§ããŸãã
ããŒã¿ã®ç²åºŠã¯ããã¬ãŒãã³ã° ããŒã¿ãšãã¹ãŠã®ãããæšè«ããŒã¿ãšã®éã§äžè²«ããŠããå¿ èŠããããŸãã1 æ¥åäœã®ç²åºŠãæå®ãã2 ã€ã®ãã¬ãŒãã³ã° ããŒã¿è¡ã®éã« 2 æ¥ããå ŽåãVertex AI ã¯äžéã®æ¥ãæ¬ èœããŒã¿ãšããŠæ±ããã¢ãã«ã®ããã©ãŒãã³ã¹ãäœäžãããå¯èœæ§ããããŸããåãã¿ã€ãã¹ã¿ã³ããæã€åãæç³»åå ã®è€æ°ã®è¡ïŒç²åºŠã«ãã£ãŠæ±ºå®ãããïŒã¯ããã¬ãŒãã³ã°æã«æ€èšŒãšã©ãŒãšã¿ãªãããŸãã
éåžžã¯ãããŒã¿åéæ¹æ³ã«ãã£ãŠããŒã¿ã®ç²åºŠã決å®ããŸãã
ã³ã³ããã¹ã ãŠã£ã³ããŠã«é©åãªå€ãèŠã€ããæ¹æ³
éå»ã«ã¯æ¡åŒµããªãæšè«ããŒã¿ïŒã³ãŒã«ã ã¹ã¿ãŒãïŒã倧éã«çºçãããšäºæ³ãããå Žåã¯ããŸãã³ã³ããã¹ã ãŠã£ã³ããŠã 0 ã«èšå®ããŸãããã以å€ã®å Žåã¯ãäºæž¬ãã©ã€ãºã³ã®ãµã€ãºãšäºæž¬ãã©ã€ãºã³ã®ãµã€ãºã® 10 åã®éã«ã³ã³ããã¹ã ãŠã£ã³ããŠãèšå®ãããšãæ£åžžã«æ©èœããŸãã
ããŒã¿ã«åã£ãå€ãèŠã€ããã«ã¯ã以äžã®æé ãã詊ããã ããã
æåã®ãã¬ãŒãã³ã° ã€ãã¬ãŒã·ã§ã³ã§ãã³ã³ããã¹ã ãŠã£ã³ããŠãšäºæž¬ãã©ã€ãºã³ã«åãå€ãèšå®ãããã¬ãŒãã³ã°äºç®ã 6 æé以äžã«èšå®ããŸãã
åããã¬ãŒãã³ã°äºç®ãèšå®ããŠå床ã¢ãã«ããã¬ãŒãã³ã°ããŸãããã³ã³ããã¹ã ãŠã£ã³ããŠã®ãµã€ãºããäºæž¬ãã©ã€ãºã³ã® 2 åãŸã§åå¢ãããŸãã
2 åç®ã®ã¢ãã«ã®è©äŸ¡ææšãå€§å¹ ã«æ¹åãããå Žåã¯ãã³ã³ããã¹ã ãŠã£ã³ããŠãäºæž¬ãã©ã€ãºã³ã®ãµã€ãºã® 5 åã«å¢ãããŠãã¢ãã«ãå床ãã¬ãŒãã³ã°ããŸãããã¬ãŒãã³ã°äºç®ãæ¯äŸããŠå¢å ãããããšãæ€èšããŠãã ããïŒæåã®æé ã§ 10 æéãã¬ãŒãã³ã°ããå Žåã¯ããã¬ãŒãã³ã°äºç®ã 50 æéã«å¢ãããŸãïŒã
è©äŸ¡ææšã®æ¹åãèŠãããªããªãããçµæã«æºè¶³ãããŸã§ãã³ã³ããã¹ã ãŠã£ã³ããŠãå¢ãããŠãã ããã蚱容ãããçµæããããããã³ã³ããã¹ã ãŠã£ã³ããŠã®æå°å€ãŸã§æ»ããŠãã ããã
ã³ã³ããã¹ã ãŠã£ã³ããŠãå¢ãããšã次ã®ãããªåœ±é¿ããããŸãã
ãã¬ãŒãã³ã°æéãé·ããªã
ã³ã³ããã¹ã ãŠã£ã³ããŠãå¢ãããšãã¢ãã«ã¯ããå€ãã®ããŒã¿ãã€ã³ãã䜿çšããããããã¬ãŒãã³ã°æéãé·ããªããŸãã
æšè«ããŒã¿ã«å¿ èŠãªå±¥æŽã®éãå¢å ãã
æšè«ããŒã¿ã¯ãã³ã³ããã¹ã ãŠã£ã³ããŠã®å€ãšåçšåºŠã®æ°ã®å±¥æŽããŒã¿ãã€ã³ããæäŸããå¿ èŠããããŸãã
ããŒã¿åœ¢åŒã®ãã¹ã ãã©ã¯ãã£ã¹
ãã¬ãŒãã³ã° ããŒã¿ã¯ãã¯ã€ã圢åŒãŸãã¯ãããŒåœ¢åŒã®ã©ã¡ãã§ãäœæã§ããŸããååž°ã¢ãã«ãšåé¡ã¢ãã«ã§ã¯ãã¯ã€ã圢åŒãåºã䜿çšãããæ§ç¯ãšç¢ºèªãããç°¡åã«è¡ããŸããäºæž¬ã¢ãã«ã§ã¯ããããŒåœ¢åŒã䜿çšãããšãããŒã¿ãšã¿ãŒã²ããïŒããŒã¿æŒæŽ©ïŒãšã®éã®æå³ããªãæ¥ç¶ã®èšå®ãåé¿ã§ããŸãã
äºæž¬ã¢ãã«ããã¬ãŒãã³ã°ããããã®ãã¬ãŒãã³ã° ããŒã¿ãäœæããå Žåãåè¡ã¯ 1 ã€ã®æç³»åã§ 1 ã€ã®èŠ³æž¬å€ã衚ãå¿ èŠããããŸããæç³»åèå¥åïŒæç³»åãä»ã®æç³»åãšåºå¥ããæ¹æ³ïŒã衚ãåãšãäºæž¬ããå€ïŒã¿ãŒã²ããïŒã衚ãåãå¿ èŠã§ããæ¬¡ã«ãã¿ãŒã²ããã®æšè«ããªã¯ãšã¹ããããšããã¢ãã«ã®ãã¬ãŒãã³ã°ã«äœ¿çšãããè¡ã«ãä»ã®ãã¹ãŠã®å€ãååšããŠããå¿ èŠããããŸãã
以äžã®ïŒç°¡ç¥åããçç¥ãããïŒãµã³ãã« ãã¬ãŒãã³ã° ããŒã¿ãèããŠã¿ãŸãããã
æ¥ä» | ãŠã£ãžã§ãã_1_éèŠ | ãŠã£ãžã§ãã_2_éèŠ | ãŠã£ãžã§ãã_3_éèŠ | å²åŒ | å°å |
---|---|---|---|---|---|
01/01/2019 | 112 | 241 | 0 | 0 | CA |
01/02/2019 | 141 | 219 | 0 | 1 | CA |
01/03/2019 | 149 | 244 | 0 | 0 | CA |
01/01/2019 | 52 | 0 | 43 | 0 | IL |
01/02/2019 | 81 | 0 | 26 | 1 | IL |
01/03/2019 | 89 | 0 | 86 | 0 | IL |
ãã®è¡šã¯ã¯ã€ã圢åŒã§ãããžãã¹ããŒã¿ãæ¥ä»ããšã«è¡šç€ºãããŠããŸãããçŸåšã®åœ¢åŒã§ã¯äºæž¬ã¢ãã«ã§ã¯äœ¿çšã§ããŸãããã¿ãŒã²ããåã 1 ã€ã§ã¯ãªããæç³»å ID åããããŸããããŸããç¹å®ã®æ¥ä»ã§ã¯ãæšè«æã®ä»ã®ãŠã£ãžã§ããã®éèŠã¯ææ¡ã§ããŸããã
ãã®ããŒãã«ã¯æ¬¡ã®åœ¢åŒã«å€æã§ããŸãã
æ¥ä» | åå | å°å_CA_éèŠ | å°å_IL_éèŠ | å²åŒ |
---|---|---|---|---|
01/01/2019 | ãŠã£ãžã§ãã_1 | 112 | 52 | 0 |
01/02/2019 | ãŠã£ãžã§ãã_1 | 141 | 81 | 1 |
01/03/2019 | ãŠã£ãžã§ãã_1 | 149 | 89 | 0 |
01/01/2019 | ãŠã£ãžã§ãã_2 | 241 | 0 | 0 |
01/02/2019 | ãŠã£ãžã§ãã_2 | 219 | 0 | 1 |
01/03/2019 | ãŠã£ãžã§ãã_2 | 244 | 0 | 0 |
01/01/2019 | ãŠã£ãžã§ãã_3 | 0 | 43 | 0 |
01/02/2019 | ãŠã£ãžã§ãã_3 | 0 | 26 | 1 |
01/03/2019 | ãŠã£ãžã§ãã_3 | 0 | 86 | 0 |
æç³»å ID ãšããŠäœ¿çšã§ãããååãåãäœæããŸããããã ãããã®åœ¢åŒã¯äžæ¹ã®å°åã®äºæž¬ã«ã®ã¿äœ¿çšã§ããŸããããäžæ¹ã®å°åã®ããŒã¿ã¯ãæšè«æã«ã¯ææ¡ããŠããå¿ èŠããããŸãã
è§£æ±ºæ¹æ³ã¯ãåè¡ã 1 ã€ã®èŠ³æž¬å€ã衚ãããã«ããã®è¡šããããŒåœ¢åŒã«å€æããããšã§ããæç³»åã«äŸåããªãããŒã¿ã¯ãåè¡ã§ç¹°ãè¿ãããŸãã
æ¥ä» | éèŠ | ID | å²åŒ |
---|---|---|---|
01/01/2019 | 112 | ãŠã£ãžã§ãã_1_CA | 0 |
01/02/2019 | 141 | ãŠã£ãžã§ãã_1_CA | 1 |
01/03/2019 | 149 | ãŠã£ãžã§ãã_1_CA | 0 |
01/01/2019 | 52 | ãŠã£ãžã§ãã_1_IL | 0 |
01/02/2019 | 81 | ãŠã£ãžã§ãã_1_IL | 1 |
01/03/2019 | 89 | ãŠã£ãžã§ãã_1_IL | 0 |
01/01/2019 | 241 | ãŠã£ãžã§ãã_2_CA | 0 |
01/02/2019 | 219 | ãŠã£ãžã§ãã_2_CA | 1 |
01/03/2019 | 244 | ãŠã£ãžã§ãã_2_CA | 0 |
01/01/2019 | 0 | ãŠã£ãžã§ãã_2_IL | 0 |
01/02/2019 | 0 | ãŠã£ãžã§ãã_2_IL | 1 |
01/03/2019 | 0 | ãŠã£ãžã§ãã_2_IL | 0 |
01/01/2019 | 0 | ãŠã£ãžã§ãã_3_CA | 0 |
01/02/2019 | 0 | ãŠã£ãžã§ãã_3_CA | 1 |
01/03/2019 | 0 | ãŠã£ãžã§ãã_3_CA | 0 |
01/01/2019 | 43 | ãŠã£ãžã§ãã_3_IL | 0 |
01/02/2019 | 26 | ãŠã£ãžã§ãã_3_IL | 1 |
01/03/2019 | 86 | ãŠã£ãžã§ãã_3_IL | 0 |
ããã§ãæç³»åèå¥åïŒIDïŒãã¿ãŒã²ããåïŒéèŠïŒãæéåïŒæ¥ä»ïŒã®åãäœæãããŸããããŸããåè¡ã¯ 1 ã€ã®èŠ³æž¬å€ã«åºã¥ããŠãããããã䜿çšããŠã¿ãŒã²ããå€ãäºæž¬ã§ããŸããå²åŒåã¯ãã¢ãã«ããã¬ãŒãã³ã°ããããã®ç¹åŸŽãšããŠäœ¿çšãããŸãã
å®éã«ã¯ããã®äŸãããå€ãã®è¡ãšåãå¿ èŠã«ãªããŸãããã ããããŒã¿æŒæŽ©ãé²ãããã«ã¯ãããã§èª¬æããã¬ã€ãã©ã€ã³ã«æ²¿ã£ãŠããŒã¿ãæ§é åããå¿ èŠããããŸãã
次ã®ã¹ããã
- ããŒã¿ãæ©æ¢°åŠç¿ã«åœ¹ç«ã€ããšã確èªããããã®äºåãã§ãã¯ãªã¹ã
- æ©æ¢°åŠç¿çšã®ããŒã¿ãæºåããã¥ã¬ãŒããã