Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Amazon Pinpointを用いて、LINEとメール配信のCRM設計 / AWS Dev Day 2022 B-2

Amazon Pinpointを用いて、LINEとメール配信のCRM設計 / AWS Dev Day 2022 B-2

AWS Dev Day 2022 Japan
2022/11/09 B-2
Amazon Pinpointを用いて、LINEとメール配信のCRM設計

おやつの定期便
https://snaq.me

直営点
https://kiyosumi.snaq.me/

hayato miyoshi

November 09, 2022
Tweet

More Decks by hayato miyoshi

Other Decks in Technology

Transcript

  1. σʔλΛ׆͔ͨ͠঎඼։ൃ ʰ͓΍ͭମݧʱ ఆظศ͓ಧ͚ස౓ • ̎िؒʹ̍ճ • ̐िؒʹ̍ճ • ͓΍ͭ΁ͷϑΟʔυόοΫ •

    ϦΫΤετ • ޷͖ݏ͍ͷొ࿥ • ͓ಧ͚ΛॏͶΔ͝ͱʹ ΑΓ޷Έʹۙͮ͘BOX • BOXΛ։෧͢Δ࣌ͷɹ Θ͘Θ͘ײ • σʔλ෼ੳ • ঎඼։ൃ • ύʔιφϥΠζ ͞Ε͓ͨ΍ͭͷબఆ Ϣʔβʔ͔Βͷ ධՁσʔλΛ׆͔͠ɺ 1ϲ݄΄ͲͰ৽঎඼ͷ اը։ൃ͕Մೳ ঎඼։ൃαΠΫϧ
  2. 6 ͓΋͠Ζ͍ʂ ࣦഊΛڪΕͣʹνϟϨϯδ͢Δ͜ͱΛ঑ྭ͢ΔจԽ ΍ͬͯΈΑʂ ͭ͗ʹ͍͔ͦ͏ʂ ೉қ౓΍޻਺͡Όͳ͘ʮͦΕͬͯ໘ന͍ʁʯΛ࣠ʹɺ 
 ”ϫΫϫΫϑΝʔετ”Ͱߦಈ͠·͢ɻ 
 ͓΋͠Ζ͍΄͏͕΍Δؾ͕ग़Δ͠ɺ͓٬༷ʹتΜͰ͍͚ͨͩΔ͔Βɻ

    ͪ͝Όͪ͝Όݴͬͯͳ͍Ͱ”Φʔφʔγοϓ”Λ࣋ͬͯ·ͣ΍ͬͯΈΑ͏ ࣦഊ͍͍ͨͬͯ͠ɻֶͼ͕͋Ε͹Ṷ͚΋ͷɻ 
 ࣦഊΛڪΕͣͲΜͲΜ”νϟϨϯδ”͍͖ͯ͠·͠ΐ͏ɻ 
 ΈΜͳ΍͍͔͞͠Βࣦഊͨͬͯ͠େৎ෉ͩΑʂ εφοΫϛʔͰಇ͘ਓͨͪͷՁ஋؍
  3. SNAQ Scale Out ΤϯδχΞϦϯάͰࣄۀ੒௕ΛҾͬ ு͍͚ͬͯΔΑ͏ͳ։ൃΛ͍ͯ͜͠ ͏ɻͦͷҝʹ΋εέʔϧ͠΍͍͢࢓ ૊Έͷ։ൃΛ৺͕͚Α͏ɻ Next ೔ʑͷ௅ઓͷதͰࣦഊΛͯ͠͠·ͬͨ࣌ʹ Ͱ΋ɺ࣍΁ͷҰา͕౿Έग़͠΍͍͢࢓૊Έ

    ͮ͘ΓΛ৺͕͚Α͏ɻյ͠΍͍͢࢓૊Έͩ ͬͨΓɺ࠷଎Ͱ։ൃɾվળ͍͚ͯ͠ΔΑ͏ ͳ؀ڥΛ࣋ͪଓ͚Α͏ɻ Agile খ͘͞ૣ͘εϐʔυײΛ࣋ͬͯɺ ܧଓతʹվળΛੵΈॏͶ͍ͯ͜͏ɻ Quality Ϣʔβʔʹͱͬͯ Ұ൪ྑ͍΋ͷΛ࡞͍ͬͯ͜͏ɻ ΤϯδχΞνʔϜͷόϦϡʔ
  4. 11 εφοΫϛʔͰ͸ ίχϡχέʔγϣϯͷऔΓํҎԼέʔε ݸผ ηάϝϯτ Email Πϯό΢ϯυ ͱ Ξ΢τόϯυ ରԠ

    શϢʔβʔͰ͸ͳ͘ Use caseʹ߹Θͤͯ ͦΕͧΕͷνϟωϧͰ௨஌ LINE ͦͷଞ SNSͳͲ ×
  5. 12 εφοΫϛʔͰ͸ ίχϡχέʔγϣϯͷऔΓํҎԼέʔε ݸผ ηάϝϯτ Email Πϯό΢ϯυ ͱ Ξ΢τόϯυ ରԠ

    શϢʔβʔͰ͸ͳ͘ Use caseʹ߹Θͤͯ ͦΕͧΕͷνϟωϧͰ௨஌ LINE ͦͷଞ SNSͳͲ ×
  6. 18 "84-BNCEBͰ௨஌͢Δؔ਺ͷ࡞੒ • ΧελϜνϟωϧ͸ ૹ৴෦෼ΛશͯࣗࣾͰ؅ཧ • ૹ৴ઌͷ؀ڥߏங (ΞΫηεΩʔ΍֎෦SDKͳͲ) • ड͚औΔσʔλ

    (jsonͰ஋Λऔಘ) • ϝοηʔδΛಈతʹมߋ͢Δॲཧ (໊લͳͲ) AWS Lambda Amazon Pinpoint AWS Lambda AWS Lambda AWS Lambda Aνϟωϧ Bνϟωϧ Cνϟωϧ
  7. 19 "84-BNCEBͰ௨஌͢Δؔ਺ͷ࡞੒ ड͚औΔσʔλ • ApplicationId – Ωϟϯϖʔϯ͕ଐ͢Δ Amazon Pinpoint ϓϩδΣΫτͷ

    IDɻ ࠷େ50ͷΤϯυϙΠϯτʹϝοηʔδΛ഑৴Ͱ͖Δ • ActivityId – ΩϟϯϖʔϯʹΑ࣮ͬͯߦதͷΞΫςΟϏςΟͷ IDɻ • CampaignId – Lambda ؔ਺Λݺͼग़ͨ͠ Amazon Pinpoint Ωϟϯϖʔϯͷ IDɻ • Data – ΧελϜνϟϯωϧʹૹ৴͢ΔϝοηʔδϖΠϩʔυΛؚΉ JSON จࣈྻɻ • Endpoints – ΩϟϯϖʔϯͷλʔήοτͱͳͬͨΤϯυϙΠϯτͷϦετɻ֤ϖΠϩʔυʹ͸ɺ࠷େ 50 ͷΤ ϯυϙΠϯτΛؚΊΔ͜ͱ͕Ͱ͖·͢ɻΩϟϯϖʔϯͷૹ৴ઌηάϝϯτʹ 50 Ҏ্ͷΤϯυϙΠϯτؚ͕· Ε͍ͯΔ৔߹ɺAmazon Pinpoint ͸͢΂ͯͷΤϯυϙΠϯτ͕ॲཧ͞ΕΔ·Ͱɺ܁Γฦؔ͠਺Λݺͼग़͠·͢ (࠷େͰҰ౓ʹ 50 ͷΤϯυϙΠϯτ)ɻ
  8. 20 -BNCEBؔ਺Λݺͼग़ͨ͢Ίͷ"NB[PO1JOQPJOUΞΫηεڐՄΛ෇༩͢Δ aws lambda add-permission \ --function-name myFunction \ --statement-id

    sid0 \ --action lambda:InvokeFunction \ --principal pinpoint.ap-northeast-1.amazonaws.com \ --source-arn arn:aws:mobiletargeting:ap-northeast-1:111122223333:apps/* --source-account 111122223333 ΧελϜνϟωϧΛਐΊΔͱ͖ʹPinpoint͔ΒLambdaͷΞΫηεڐՄΛ෇༩ͤͣ Ωϟϯϖʔϯ͸੒ޭ͍ͯ͠Δ͕Ұ޲ʹLambda͕ىಈ͠ͳ͍έʔε͕͋ΔͷͰ஫ҙ
  9. AWS Step Functions Workflow Amazon S3 AWS Lambda AWS Lambda

    Amazon DynamoDB DONE? Amazon Simple Notification Service AWS Batch Users -*/&"1* Amazon Pinpoint Users Import Segment Create Campaign +40/ 'JMF Segment Info Custom Channel Amazon Simple Email 
 Service
  10. ഑৴ํ๏͸ͳΜͱͳ͘೺ѲͰ͖ͨ ҰํͰ഑৴͢ΔͨΊͷߟ͑ํ͸Ͳ͏͢Δ͔ େ͖͘෼͚Δͱ ୯ൃ഑৴ͱܧଓ഑৴ʹ෼͚ΒΕΔ ୯ൃ഑৴ : 1౓͖Γͷ഑৴ / ಉ͡Ͱ΋ຖճίϯςϯπ͕େ͖͘ҟͳΔ (Ex.

    اըͷॳ௨஌ɺαʔϏεͷप೥ࡇ௨஌ͳͲ) ܧଓ഑৴ : ܧଓతʹ഑৴͢Δ (Ex. ຖिͷ৽঎඼௨஌ɺॳճొ࿥ͷΦϯϘʔσΟϯά௨஌ͳͲ)
  11. 30 ୯ൃ഑৴ͱܧଓ഑৴ͷߟ͑ํ ୯ൃ഑৴ ܧଓ഑৴ ୯ൃ഑৴ ςετΛ܁Γฦ͢ ݁Ռ͕ग़ͨ৔߹ ܧଓ΁Ҡߦ ܧଓ഑৴ ܧଓ഑৴

    ୯ൃ഑৴ ݁Ռ͕ग़ͳ͍৔߹ ͦͷ഑৴ࣗମετοϓ ੒Ռ͕ग़Δ഑৴Λ ߟ͑Δ A/Bςετ ίϯςϯπͳͲͷ ςετ࣮ࢪ
  12. 33 ഑৴Λ؅ཧ͢Δํ๏ ഑৴͢ΔͨΊͷΞʔΩςΫνϟ͸͞·͟·͋Γɺςετ഑৴΍਺͕গͳ͍৔߹͸Ͳͷύλʔϯ Ͱ΋େ͖ͳࠩ͸ଘࡏ͠ʹ͍͘ɻ(޷Έɺ΍Γқ͞ͳͲ) AWS Lambda AWS Batch Amazon S3

    PC Amazon Simple Email 
 Service (Amazon SES) Amazon Simple Email 
 Service (Amazon SES) AWS Step Functions workflow খن໛ͷ഑৴ தʙେن໛ͷ഑৴ workflowͰͷ഑৴ ࣾ಺؅ཧը໘͔Β഑৴
  13. 34 ഑৴Λ؅ཧ͢Δํ๏ • 1೔ʹ1ճ΄Ͳͷ഑৴ͷछྨ͕૿͑Δ • ഑৴λΠϛϯάͷ؅ཧ • ഑৴ίϯςϯπ • ΤϥʔϋϯυϦϯά

    (௨஌Ͱ͖ͨͷ͔ࣦഊͨ͠ͷ͔ݕ஌) ഑৴͢Δछྨ͕1छྨͰ͋Ε͹ಛʹ1ͭͷLambdaΛ࡞੒͠഑৴͍͚ͯ͠͹ྑ͍͕ɺ छྨ͕ଟ͘ͳΔͱ͞·͟·ͳ͜ͱʹߟྀ͢Δඞཁ͕͋Δ
  14. 35 ഑৴Λ؅ཧ͢Δํ๏ • 1೔ʹ1ճ΄Ͳͷ഑৴ͷछྨ͕૿͑Δ • ഑৴λΠϛϯάͷ؅ཧ • ഑৴ίϯςϯπ • ΤϥʔϋϯυϦϯά

    (௨஌Ͱ͖ͨͷ͔ࣦഊͨ͠ͷ͔ݕ஌) ഑৴͢Δछྨ͕1छྨͰ͋Ε͹ಛʹ1ͭͷLambdaΛ࡞੒͠഑৴͍͚ͯ͠͹ྑ͍͕ɺ छྨ͕ଟ͘ͳΔͱ͞·͟·ͳ͜ͱʹߟྀ͢Δඞཁ͕͋Δ → Lambdaͷ؅ཧ͕ࠔ೉ʹͳͬͯ͘Δ (1഑৴1ؔ਺ͷ৔߹) → ഑৴λΠϛϯάΛ֬ೝ͠ʹ͍͘ͱೝࣝͷᴥᴪ͕ੜ·Ε΍͍͢ → ίϯςϯπͷࠩ͠ସ͑ʹ1,2೔͔͔Δ৔߹΍ࠓͲͷίϯςϯπΛ഑৴͍ͯ͠Δͷ͔֬ೝͮ͠Β͍ → Τϥʔݕ஌Ͱ͖Δج൫Λ੔͑Δඞཁ͕͋Δ
  15. 36 Ҏલͷ഑৴ΞʔΩςΫνϟ AWS Step Functions workflow AWS Lambda End Fail

    ҰͭͷLambdaؔ਺ʹStep FunctionsͷworkflowΛ࡞੒ࣦ͠ഊͷ৔߹͸ࣦഊͷࢫΛ௨஌ Lambdaؔ਺ͱStep Functionsͷworkflowͷ਺͕ൺྫͯ͠૿͍͑ͯ͘
  16. 39 ίϯςϯπͷ؅ཧ • PinpointͷtemplateͰ؅ཧ • S3ͳͲʹίϯςϯπΛ഑ஔ͠؅ཧ PinpointͰίϯςϯπΛ؅ཧ͢Δํ๏ͱͯ͠ҎԼͷ2ύλʔϯ͋Γɺ֤ʑͷӡ༻໘Ͱܾఆ͢Δ → όʔδϣϯ؅ཧɺAWS Console͔Β΋௥ՃมߋՄೳ

    ɹίϯςϯπͱηάϝϯτΛผʑͰਐΊΔ৔߹ʹͦΕͧΕૄ݁߹ʹͳΔͷͰ؅ཧ͠΍͍͢ ɹൺֱత௚ײతʹ࡞੒Ͱ͖Δ͕ϦονͳίϯςϯπΛ࡞Γ͍ͨ৔߹͸html λάΛཧղ͢Δඞཁ͋Γ → ηάϝϯτ΋ίϯςϯπΛҰॹʹ؅ཧ͢ΔͰӨڹൣғ͕Θ͔Γ΍͍͢ ɹίϯςϯπΛ࡞੒ͷ೉қ౓͕templateΑΓߴ͍ (ίϯςϯπ࡞੒πʔϧ͕ͳ͍ͱҰ͔ΒhtmlΛॻ͘͜ͱʹ)
  17. 42 • ΩϟϯϖʔϯͷOpen rate΍Click rate [શମ] ഑৴ͷޮՌݕূΛਤΔͱ͖େ → খͷηάϝϯτ୯ҐͰଌΔ ഑৴ͷޮՌݕূ

    • A/Bςετ΍ϗʔϧυΞ΢τ [ൺֱ] • ഑৴ޙͷΞϓϦέʔγϣϯ಺ͷΠϕϯτ [۩ମతͳޮՌ]
  18. 43 • ΩϟϯϖʔϯͷOpen rate΍Click rate [શମ] ഑৴ͷޮՌݕূΛਤΔͱ͖େ → খͷηάϝϯτ୯ҐͰଌΔ ഑৴ͷޮՌݕূ

    • A/Bςετ΍ϗʔϧυΞ΢τ [ൺֱ] • ഑৴ޙͷΞϓϦέʔγϣϯ಺ͷΠϕϯτ [۩ମతͳޮՌ] → ҰൠతͳޮՌଌఆɻ։͍͍ͯͳ͍ίϯςϯπ͸͸ಡ·Εͯͳ͍͕ɺ։͍͍ͯΔίϯςϯπ͸ಡ·Ε͍ͯΔ → Ծઆʹର͢Δࢪࡦͷൺֱ͕ՄೳɻίϯςϯπΛมߋ͢Δͱ͖طଘͱޮՌΑΓޮՌ͕͋Δͷ͔ͳͲ →Open rateͳͲͰ͸ଌΕͳ͍ࢦඪͷޮՌΛଌఆɻOpen rate͸ߴ͘ͳ͍͕ച্্͕͕ΔͳͲ
  19. 44 • ΩϟϯϖʔϯͷOpen rate΍Click rate [શମ] ഑৴ͷޮՌݕূΛਤΔͱ͖େ → খͷηάϝϯτ୯ҐͰଌΔ ഑৴ͷޮՌݕূ

    • A/Bςετ΍ϗʔϧυΞ΢τ [ൺֱ] • ഑৴ޙͷΞϓϦέʔγϣϯ಺ͷΠϕϯτ [۩ମతͳޮՌ] → ҰൠతͳޮՌଌఆɻ։͍͍ͯͳ͍ίϯςϯπ͸͸ಡ·Εͯͳ͍͕ɺ։͍͍ͯΔίϯςϯπ͸ಡ·Ε͍ͯΔ → Ծઆʹର͢Δࢪࡦͷൺֱ͕ՄೳɻίϯςϯπΛมߋ͢Δͱ͖طଘͱޮՌΑΓޮՌ͕͋Δͷ͔ͳͲ →Open rateͳͲͰ͸ଌΕͳ͍ࢦඪͷޮՌΛଌఆɻOpen rate͸ߴ͘ͳ͍͕ച্্͕͕ΔͳͲ શମ
  20. 45 • ΩϟϯϖʔϯͷOpen rate΍Click rate [શମ] ഑৴ͷޮՌݕূΛਤΔͱ͖େ → খͷηάϝϯτ୯ҐͰଌΔ ഑৴ͷޮՌݕূ

    • A/Bςετ΍ϗʔϧυΞ΢τ [ൺֱ] • ഑৴ޙͷΞϓϦέʔγϣϯ಺ͷΠϕϯτ [۩ମతͳޮՌ] → ҰൠతͳޮՌଌఆɻ։͍͍ͯͳ͍ίϯςϯπ͸͸ಡ·Εͯͳ͍͕ɺ։͍͍ͯΔίϯςϯπ͸ಡ·Ε͍ͯΔ → Ծઆʹର͢Δࢪࡦͷൺֱ͕ՄೳɻίϯςϯπΛมߋ͢Δͱ͖طଘͱޮՌΑΓޮՌ͕͋Δͷ͔ͳͲ →Open rateͳͲͰ͸ଌΕͳ͍ࢦඪͷޮՌΛଌఆɻOpen rate͸ߴ͘ͳ͍͕ച্্͕͕ΔͳͲ શମ # $POUFOUT " $POUFOUT
  21. 46 • ΩϟϯϖʔϯͷOpen rate΍Click rate [શମ] ഑৴ͷޮՌݕূΛਤΔͱ͖େ → খͷηάϝϯτ୯ҐͰଌΔ ഑৴ͷޮՌݕূ

    • A/Bςετ΍ϗʔϧυΞ΢τ [ൺֱ] • ഑৴ޙͷΞϓϦέʔγϣϯ಺ͷΠϕϯτ [۩ମతͳޮՌ] → ҰൠతͳޮՌଌఆɻ։͍͍ͯͳ͍ίϯςϯπ͸͸ಡ·Εͯͳ͍͕ɺ։͍͍ͯΔίϯςϯπ͸ಡ·Ε͍ͯΔ → Ծઆʹର͢Δࢪࡦͷൺֱ͕ՄೳɻίϯςϯπΛมߋ͢Δͱ͖طଘͱޮՌΑΓޮՌ͕͋Δͷ͔ͳͲ →Open rateͳͲͰ͸ଌΕͳ͍ࢦඪͷޮՌΛଌఆɻOpen rate͸ߴ͘ͳ͍͕ച্্͕͕ΔͳͲ શମ # $POUFOUT " $POUFOUT ച্ ධՁ ϦΫΤετ ച্ ධՁ ϦΫΤετ ղ໿
  22. 47 ഑৴ͷޮՌݕূ • Ωϟϯϖʔϯͷશମ೺Ѳ Open rate΍Click rate, Bounce rate ͳͲͰશମΛ೺Ѳ͠

    ϢʔβʔผʹEmailΠϕϯτΛऔಘՄೳ Ωϟϯϖʔϯ໊ ૹ৴਺ ։෧཰ ΫϦοΫ཰ ό΢ϯε཰ $BNQBJHO@"      $BNQBJHO@#      $BNQBJHO@$      $BNQBJHO@%     
  23. 48 ഑৴ͷޮՌݕূ Amazon Pinpoint Amazon Kinesis Data Streams Amazon Simple

    Storage Service Amazon Athena AWS Lambda Amazon Simple Email 
 Service Users Users AWS Glue 
 Elastic Views 1ϢʔβʔผʹEmailΠϕϯτΛऔಘՄೳ (send, delivered, open, click, rejected, hardbounce, softbounce, complaint, rendering_failure)
  24. 52 ഑৴ͷޮՌݕূ ഑৴ޙͷΞϓϦέʔγϣϯ಺ͷΠϕϯτ [۩ମతͳޮՌ] ࢥΘ͵ޮՌΛଌΕΔঢ়ଶ͸next actionΛߟ͑Δ্Ͱେࣄ • ഑৴ΩϟϯϖʔϯͱΞϓϦέʔγϣϯͷΠϕϯτΛඥ෇͚Δ • ଐੑσʔλ΋͋Δ৔߹͸ඥ͚ͮΔ

    • ྲྀೖݩ͸࢒͢લఏͰΠϕϯτઃܭ͢Δ → Πϕϯτ͕ͲͷΩϟϯϖʔϯܦ༝͔Θ͔ΔΑ͏ͳঢ়ଶ͢Δ → ػछɾ஍ҬੑͳͲ͋Δ৔߹͸σϑΥϧτͰ࢒͢ → ྲྀೖผͰޮՌ͕ҧ͏͜ͱ͸Α͋͘Δ͜ͱͳͷͰͦ͜ͰൺֱͰ͖Δঢ়ଶʹ͢Δ
  25. 53 ഑৴ͷޮՌݕূ ഑৴ޙͷΞϓϦέʔγϣϯ಺ͷΠϕϯτ [۩ମతͳޮՌ] ࢥΘ͵ޮՌΛଌΕΔঢ়ଶ͸next actionΛߟ͑Δ্Ͱେࣄ • ഑৴ΩϟϯϖʔϯͱΞϓϦέʔγϣϯͷΠϕϯτΛඥ෇͚Δ • ଐੑσʔλ΋͋Δ৔߹͸ඥ͚ͮΔ

    • ྲྀೖݩ͸࢒͢લఏͰΠϕϯτઃܭ͢Δ Content A Content B Content C େ খ த → Πϕϯτ͕ͲͷΩϟϯϖʔϯܦ༝͔Θ͔ΔΑ͏ͳঢ়ଶ͢Δ → ػछɾ஍ҬੑͳͲ͋Δ৔߹͸σϑΥϧτͰ࢒͢ → ྲྀೖผͰޮՌ͕ҧ͏͜ͱ͸Α͋͘Δ͜ͱͳͷͰͦ͜ͰൺֱͰ͖Δঢ়ଶʹ͢Δ
  26. 54 ഑৴ͷޮՌݕূ ഑৴ޙͷΞϓϦέʔγϣϯ಺ͷΠϕϯτ [۩ମతͳޮՌ] ࢥΘ͵ޮՌΛଌΕΔঢ়ଶ͸next actionΛߟ͑Δ্Ͱେࣄ • ഑৴ΩϟϯϖʔϯͱΞϓϦέʔγϣϯͷΠϕϯτΛඥ෇͚Δ • ଐੑσʔλ΋͋Δ৔߹͸ඥ͚ͮΔ

    • ྲྀೖݩ͸࢒͢લఏͰΠϕϯτઃܭ͢Δ → Πϕϯτ͕ͲͷΩϟϯϖʔϯܦ༝͔Θ͔ΔΑ͏ͳঢ়ଶ͢Δ → ػछɾ஍ҬੑͳͲ͋Δ৔߹͸σϑΥϧτͰ࢒͢ → ྲྀೖผͰޮՌ͕ҧ͏͜ͱ͸Α͋͘Δ͜ͱͳͷͰͦ͜ͰൺֱͰ͖Δঢ়ଶʹ͢Δ ͜ͷΠϕϯτʹͩ͜ΘΓ͗͢Δͱશମ૾͕ݟ͑ͳ͘ͳΓɺ χονͳࢪࡦΛ܁Γฦ͢৔߹͕͋ΔͷͰ஫ҙ͸ඞཁ͕ͩɺҙࣝͯ͠औΓ૊ΊΔͱྑ͍
  27. 57 ඇΤϯδχΞ #J[%FW ͱͷؔΘΓํ • Ͱ͖ΔݶΓ৺ཧత҆શੑΛߴΊͨઃܭ΁ • σʔλ͔Βࢪࡦͷٯࢉ΁ • ૹͬͯऴΘΓʹ͠ͳ͍

    ͲͷΑ͏ͳ഑৴͕Ϣʔβʔʹͱͬͯྑ͍ͷ͔఺Ͱଊ͑ͯઢͰ΋ݟΔ → ΤϯδχΞ͕ϑΥϩʔ͠ͳͯ͘΋Ͱ͖ΔΑ͏ʹ (ଐਓੑͷഉআ) → ҼࢠΛݟ͚ͭʮԿͱͳ͘ʯ͔Βʮ֬৴ʯ΁ม׵͍ͯ͘͠ → ୯ൃͰૹ৴ͨ͠΋ͷ͸୹ظతʹܭଌͰ͖Δ͕ɺܧଓ഑৴ͷ΋ͷ͸֬ೝ͠ͳ͘ͳΔ܏޲͕͋Δ
  28. ৺ཧత҆શੑΛߴΊͨઃܭ΁ • ഑৴಺༰ͷݱঢ়ͷ೺Ѳ • ίϯςϯπͷ੔ཧ • ηάϝϯτநग़΍σʔλϦςϥγʔ Ұͭͷ഑৴͔ΒશମΛ೺Ѳ͢Δͱ͖ʹۃྗෛ୲Λͳ͘͢ಈ͖͕ඞཁ ඞཁͳϒϥοΫϘοΫεԽͱෆཁͳϒϥοΫϘοΫεԽ →

    ഑৴಺༰ྔʹ૯ͯ͡ݱঢ়ͷ೺Ѳ͕ͮ͠Β͍ͷͰɺ഑৴ͷߟ͑ํͷ੔ཧ͓ͯ͘͠ → ্هʹ௨͡Δ෦෼΋͋Γ·͕͢ɺίϯςϯπࠩ͠ସ͑ͨͷʹมΘͬͯͳ͔ͬͨͳͲྑ͋͘Δ → ͍ΘΏΔSQLͷϨϕϧ΍σʔλϦςϥγʔ͸͋Δ͚ͩ෯͕޿͕ΔͷͰษڧձͳͲͰ ඇΤϯδχΞͷࢹ࠲Λ্͛Δ
  29. 64 • A/BςετΛࢭΊͳ͍ • աڈ͔ΒݱࡏΛ೺Ѳ͢Δ • ഑৴ετοϓ΋ৗʹߟ͑Δ A/Bςετ͠ଓ͚Δ౔৕͸੔͍͑ͯ͘ ୯ൃͰૹ৴ͨ͠΋ͷ͸୹ظతʹܭଌͰ͖Δ͕ɺܧଓ഑৴ͷ΋ͷ͸֬ೝ͠ͳ͘ͳΔ܏޲͕͋Δ →

    ׂ߹͸௿ͯ͘΋഑৴ׂ߹Λ 100 : 0 ʹۃྗ͠ͳ͍ → ࢖͍ํ͸࣌୅΍αʔϏεల։ʹΑΓ࠷దͳํ๏͸มΘ͍ͬͯ͘ͷͰɺCRM͔ΒͰ΋ଌΔ → ࢪࡦͳͲߟ͍͑ͯ͘ͱ͖ɺجຊ +1 ͷ͜ͱΛߟ͕͕͑ͪͩ ஌Β͵ؒʹ1೔਺े௨ૹ͍ͬͯͨέʔε͕͋Δɻ ͦͷͨΊɺޮՌ͕ͳ͍΋ͷͳͲ͸഑৴ετοϓ͠࠷దͳ഑৴਺Λߟྀͯ͠ਐΊΔ ૹͬͯऴΘΓʹ͠ͳ͍