
ã第500åã Marketing Cloud Next ïŒ ãããŒã§èšç®æžã¿ã€ã³ãµã€ããäœ¿ãæ¹æ³
ä»åã®èšäºã¯ Marketing Cloud Next Growth & Advanced Edition ã®ãã»ã°ã¡ã³ãããªã¬ãŒãããŒãã§ãèšç®æžã¿ã€ã³ãµã€ããå©çšããéã®æ³šæç¹ ã«ã€ããŠæŽçããŠã¿ãããšæããŸãã
äžèŠã·ã³ãã«ã«èŠããŸãããããã€ããããããããã€ã³ãããããããå®è£ åã«æŒãããŠããããšãããããããŸãã
äž»ãªãã€ã³ãã¯ä»¥äžã® 3 ã€ã§ãã
ãã£ã¡ã³ã·ã§ã³èšå®ãå¿ é
Get Records ã§ã¯ãªããªãœãŒã¹ã䜿çšãã
èšç®ã§ããªãã£ãã¬ã³ãŒããçšæãã
ãããã解説ããŸãã
ãã£ã¡ã³ã·ã§ã³èšå®ãå¿ é
ãŸãåºæ¬ãšãªãèšå®ã§ãã
ãããŒå ã§èšç®æžã¿ã€ã³ãµã€ããå©çšããå ŽåãWHERE æ¡ä»¶ãšããŠããã£ã¡ã³ã·ã§ã³ããæå®ããå¿ èŠããããŸãã

Marketing Cloud Next ã§ã¯ãéåžž Unified Individual ããŒã¹ã®ããŒã¿ã°ã©ããåæãšãªã£ãŠãããèšç®æžã¿ã€ã³ãµã€ãã Unified Individual ID ãåºæºã«äœæãããŠããŸããïŒæšæºã®ã¹ã³ã¢ãªã³ã°ãªã©ãåæ§ã§ãïŒ
ãã®ããããã£ã¡ã³ã·ã§ã³ã«ã¯ Unified Individual ID ãèšå®ããããšã«ãªããŸãã
ãªãããã®èšå®ãè¡ããªãå Žåã¯ã以äžã®ãããªãããŒä¿åæã«ãšã©ãŒãçºçãããããæ¯èŒçæ°ã¥ãããããã€ã³ãã§ãã

Get Records ã§ã¯ãªããªãœãŒã¹ã䜿çšãã
次ã«éèŠãªã®ããUnified Individual ID ã®æ±ãã§ãã
çšã«ãæŒç®åãéžæã§ããããEqualsãããå©çšã§ããªãå ŽåããããŸãã
ãã®æãäžèŠãããšãGet Records èŠçŽ ã䜿ã£ãŠ Unified Individual ID ãååŸããããªããŸããããã®æ¹æ³ã§ã¯å€ã NULL ã«ãªããŸãã

ããã¯ãããã°ã»æ¬çªãšãã«åæ§ã§ãçµæãšããŠãã¹ãŠã®ã¬ã³ãŒããããã©ã«ããã¹ã«æµããŠããŸããŸãã
ãã®åé¡ãåé¿ããããã«ã¯ã
æ°èŠãªãœãŒã¹ã§ã倿°ããäœæ
ããªã¬ãŒããã Unified Individual ID ããã®å€æ°ã«å²ãåœãŠã
ãšããæ¹æ³ãåããŸãã

ãã®å€æ°ããã£ã¡ã³ã·ã§ã³ã«äœ¿çšããããšã§ããããã°ã»æ¬çªãšãã«æ£åžžã«åäœããŸãã

TipsïŒæŒç®åãéžæå¯èœã§ããå Žåã¯ããªãœãŒã¹å€æ°ãäœããã«ãIs Null = Falseããšããããšãå¯èœã§ãã
èšç®ã§ããªãã£ãã¬ã³ãŒããçšæãã
ãããæãèŠèœãšãããã¡ãªãã€ã³ãã§ãã
æšæºã®ã¹ã³ã¢ãªã³ã°ã®èšç®æžã¿ã€ã³ãµã€ãã§ã¯ããã¹ãŠã® Unified Individual ã«å¯ŸããŠå€ãçšæãããŠããŸããã¹ã³ã¢ãååšããªãå Žåã§ãã0ããšããŠä¿æãããŠããŸãã
ããããã«ã¹ã¿ã ã§äœæããèšç®æžã¿ã€ã³ãµã€ãã¯ã©ãã§ããããã
äŸãã°ã売äžããŒã¿ïŒSales Order Product Engagement ãªã©ïŒãå ã«éèšããå Žåãåœç¶ãªãããè³Œå ¥ãã人ãã®ããŒã¿ããååšããŸãããäŸãã°ãè³Œå ¥åæ°ãã«ãŠã³ããããããªå ŽåãäŸã«ãããš
è³Œå ¥ãã人 â èšç®æžã¿ã€ã³ãµã€ãã® ã¬ã³ãŒããã
è³Œå ¥ããŠããªã人 â èšç®æžã¿ã€ã³ãµã€ãã® ã¬ã³ãŒããªã
ãšããç¶æ ã«ãªããŸãã
ãã®ç¶æ ã§å岿¡ä»¶ã«èšç®æžã¿ã€ã³ãµã€ãã䜿çšãããšã
è³Œå ¥ãã人ïŒã¬ã³ãŒãããã®äººïŒ â æ£åžžã«åå² Â

è³Œå ¥ããŠããªã人ïŒã¬ã³ãŒããªãã®äººïŒ â ãšã©ãŒã§ãããŒãã匷å¶éåº

ãšããæåã«ãªããŸããæ¬çªã§ã以äžã®éãã§ãã

ãã®ãããŒããããŸããŸéåºããŠãåé¡ãªãã±ãŒã¹ã§ããã°æç«ããŸããããæªè³Œå ¥è ã«ã¡ãŒã«ãéãããããããªã·ããªãªã§ã¯èŽåœçã§ãã
ãã®ãããã«ã¹ã¿ã ã®èšç®æžã¿ã€ã³ãµã€ããäœæããéã¯ã
ð å¿ ããå€ãååšããªã人 ïŒ 0ãã®ã¬ã³ãŒããçšæãã
ãšããèšèšã培åºããããšãéèŠã§ãã
å€ãååšããªã人ãçšæããå Žå â ãšã©ãŒãšãªãããEnd ãŸã§é²ã


ãããã§ããã§ããããã
ä»åã玹ä»ããå 容ã®ãã¡ãæç¢ºã«ãšã©ãŒãšããŠæ€ç¥ãããã®ã¯ããã£ã¡ã³ã·ã§ã³èšå®ããäžè¶³ããŠããã±ãŒã¹ã®ã¿ã§ãããã以å€ã®ãã€ã³ãã«ã€ããŠã¯ãå®è¡æã«åããŠåé¡ãšããŠçŸããããããããã°ãè¡ããªãéãèŠæãããšãé£ããå 容ãšãªã£ãŠããŸãã
Marketing Cloud Next ã¯è€æ°ã®ä»çµã¿ãçµã¿åãããŠæ§æãããŠãããããäžèŠæ£åžžã«èŠããŠããæå³ããªãæåãåŒãèµ·ãã âãµã€ã¬ã³ããšã©ãŒâ ãçºçããããç¹æ§ããããŸãã
æ¬èšäºã®å 容ããäžå¯§ã«ãããã°ãè¡ãã°çºèŠã§ãããã®ã§ã¯ãããŸãããéã«èšãã°ãããã°ãæ ããšèŠéãããŠããŸãå¯èœæ§ãé«ããã€ã³ãã§ããããŸãã
ãã®ããããæ±ºå®ãèŠçŽ ããçµäºæ¡ä»¶ãã«ã€ããŠã¯ãè€æ°ã®ãã¿ãŒã³ãæ³å®ããªãããå¿ ãç¹°ãè¿ãæ€èšŒãè¡ãããšã匷ãããããããŸãã
ãªããé¢é£å±æ§ãWHERE ã§ãã£ã¡ã³ã·ã§ã³ãå¿ é ãšãªããŸãããé¢é£å±æ§ã®å Žåã¯ãäŸãã°ããè³Œå ¥ãã人ãã®ããŒã¿ãååšãããšãããšã©ãŒã¯çºçããŸããããšã©ãŒãçºçããã®ã¯ãèšç®æžã¿ã€ã³ãµã€ãã®å Žåã®ã¿ ã§ãã
ããã§ããã°ãåžžã«é¢é£å±æ§ã䜿ãã° ã»ã»ã» ãšæããããããŸããããååŸã§ããããŒã¿ã®ã¿ã€ã ãªãããã«å·®ããããŸãã
é¢é£å±æ§ã§ååŸã§ããããŒã¿ã®ã¿ã€ã ãªãããïŒããã©ã«ã 7 æ¥å
â» æå€§ 30 æ¥åãŸã§å»¶é·å¯èœïŒè©³çްã¯ãã¡ãïŒèšç®æžã¿ã€ã³ãµã€ãã§ååŸã§ããããŒã¿ã®ã¿ã€ã ãªãããïŒå¶éç¡ã
ãã®ãããèšç®æžã¿ã€ã³ãµã€ããå©çšããå¿ èŠãããå Žåããããèšç®æžã¿ã€ã³ãµã€ããå©çšããå Žåã¯ãäžèšã®äºé ãèæ ®ããŠãã ããã
ä»åã¯ä»¥äžã§ãã