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

ウェブサービスにおける行動ログ活用基盤を通したデータ駆動マーケティングの実践 / Practice of data driven marketing using behavior log foundation system on web service

Hiroka Zaitsu
February 20, 2018

ウェブサービスにおける行動ログ活用基盤を通したデータ駆動マーケティングの実践 / Practice of data driven marketing using behavior log foundation system on web service

Treasure Data "PLAZMA" 2018 in Digital Belt
Customer Case Study Session
https://plazma.red/

Hiroka Zaitsu

February 20, 2018
Tweet

More Decks by Hiroka Zaitsu

Other Decks in Technology

Transcript

  1. ࡒ௡େՆ(.01FQBCP *OD
    5SFBTVSF%BUBl1-";."zJO%JHJUBM#FMU
    ΢ΣϒαʔϏεʹ͓͚Δ
    ߦಈϩά׆༻ج൫Λ௨ͨ͠
    σʔλۦಈϚʔέςΟϯάͷ࣮ફ

    View Slide

  2. σʔλαΠΤϯςΟετ
    ࡒ௡େՆ![BJNZ
    (.0ϖύϘגࣜձٕࣾज़෦

    View Slide

  3. ࠓ೔ͷ͓࿩
    NJOOFͷϚʔέςΟϯά՝୊
    ߦಈϩά׆༻ج൫l#JHGPPUzͰ

    σʔλۦಈϚʔέςΟϯάΛ࣮ݱ͢Δ
    ,1*؅ཧج൫l1FQBMZUJDTzͰ෼ੳΛਪਐ͢Δ

    View Slide

  4. ՝୊ʹର͢ΔͭͷΞϓϩʔν

    wߦಈϩάج൫z#JHGPPUz
    wߦಈϩάͷऩू෼ੳΛߦ͏
    wγεςϜͱ࿈ܞͨ͠ߦಈϩάͷ׆༻Λߦ͏
    w,1*؅ཧج൫l1FQBMZUJDTz
    wσʔλͷؔ࿈ΛఆࣜԽͯ͠෼ੳΛ༰қʹ͢Δ

    View Slide


  5. View Slide

  6. NJOOF
    wϋϯυϝΠυ࡞඼ͷൢചͱߪೖ͕Ͱ͖ΔαʔϏε
    w8FC J04ΞϓϦ "OESPJEΞϓϦΛఏڙ
    w೥ؒྲྀ௨ֹԯԁ
    w࡞Ո਺ສਓ
    w࡞඼਺ສ఺
    ˞͍ͣΕ΋೥݄ظܾࢉ

    View Slide

  7. NJOOFͷϚʔέςΟϯά՝୊

    View Slide

  8. ೥౰࣌
    αʔϏε։͔࢝Β೥

    View Slide

  9. σʔλ͕
    ແ͍

    View Slide

  10. ೥౰࣌ͷ՝୊
    wαʔϏε։࢝Ҏ߱ΞΫηεղੳπʔϧ౳Λෳ਺ಋೖ
    wઐ೚ऀෆࡏͰઃఆ΍࣮૷ʹෆඋ͕ଟ͍
    w8FC J04ΞϓϦ "OESPJEΞϓϦʹݸผʹಋೖ
    wαʔϏεͷσʔλϕʔεͷ਺ࣈͱ߹Θͳ͍

    View Slide

  11. ՝୊ᶃ
    ܭଌͯ͠ͳ͍ͷͰ෼͔Βͳ͍

    View Slide

  12. ՝୊ᶄ
    ܭଌͯ͠Δ͚Ͳ߹ͬͯͳ͍

    View Slide

  13. ͳΜͱͳ͘ܭଌ͞Ε͍ͯΔɹɹɹ
    ΞΫηεղੳπʔϧ͚͕ͩཔΓ

    View Slide

  14. ͦΜͳதɺ౤ࢿαʔϏε΁

    View Slide

  15. σʔλ͕
    ཉ͍͠

    View Slide

  16. σʔλۦಈϚʔέςΟϯάͷඞཁੑ
    w౤ࢿʹର͢Δਖ਼֬ͳޮՌଌఆ

    ྫʣϓϥοτϑΥʔϜ͝ͱͷച্
    wਖ਼֬ͳσʔλʹجͮ͘ϚʔέςΟϯά
    wϚʔέλʔʹΩϟϯϖʔϯ΍ػೳ࣮૷ͳͲ

    ࢪࡦͷΞΠσΞ͕͋Δ

    View Slide

  17. ͲΜͳσʔλ͕͋Ε͹͍͍ʁ

    View Slide

  18. ΞΫηεղੳπʔϧͷ࠶੔උ
    wطଘͷΞΫηεղੳπʔϧͷ࠶੔උ΋ඞཁ
    wπʔϧͷ࢓༷ʹ΋ґଘ͢ΔͷͰਖ਼֬ੑͷݕূʹ

    ֻ͕͔࣌ؒΔ
    wجຊతʹ͸ϖʔδຖͷूܭ஋Λܭଌ͢Δ͜ͱʹͳΔ
    wूܭ஋΋ඞཁ͕ͩΑΓࡉཻ͔͍౓ͷσʔλ͕ཉ͍͠

    View Slide

  19. ϩάͷधཁ
    wूܭΛࣗલͰߦ͏ඞཁ͸͋Δ
    wਖ਼֬ੑͷݕূΛߦ͍΍͍͢
    wࡉཻ͔͍౓Ͱ෼ੳՄೳ
    w͋Δಈ࡞Λ͢Δͨͼʹه࿥͕࢒Δ

    View Slide

  20. ϩάج൫ͷ։ൃ΁

    View Slide

  21. ߦಈϩάͱ͸
    αʔϏεͷΞϓϦέʔγϣϯ͔Βग़ྗ͢Δϩά
    ͍ͭɺͩΕ͕ɺͳʹΛ΍͔͕ͬͨಛఆͰ͖Δ
    ࠷ऴతͳߦಈ݁Ռ͚ͩͰͳ͘ɺ

    ్தͷͲ͜Ͱ͖͋ΒΊ͔ͨɺͲ͏໎͔͕ͬͨΘ͔Δ

    ը૾ग़య: Icons8

    View Slide

  22. ߦಈϩάʹ͸αʔϏεվળͷ
    ώϯτ͕ͭ·͍ͬͯΔ

    ը૾ग़య: Icons8

    View Slide

  23. ՝୊ʹର͢ΔͭͷΞϓϩʔν

    wߦಈϩάج൫z#JHGPPUz
    wߦಈϩάͷऩू෼ੳΛߦ͏
    wγεςϜͱ࿈ܞͨ͠ߦಈϩάͷ׆༻Λߦ͏
    w,1*؅ཧج൫l1FQBMZUJDTz
    wσʔλͷؔ࿈ΛఆࣜԽͯ͠෼ੳΛ༰қʹ͢Δ

    View Slide

  24. ϖύϘͷߦಈϩά׆༻ج൫
    l#JHGPPUz

    View Slide

  25. ߦಈϩάج൫ʹٻΊΒΕΔ͜ͱ

    View Slide

  26. ׆༻Λ೦಄ʹஔ͍ͨ
    ൚༻ੑͱ۩ମੑ

    View Slide

  27. ߦಈϩάʹ͓͚Δஈ֊ͷఆٛ
    ऩूߦಈϩά͕ग़ྗ͞ΕɺऔΓ·ͱΊΒΕ͍ͯΔ
    ෼ੳऔΓ·ͱΊͨߦಈϩάΛࢹ֮Խɺ෼ੳͰ͖Δ
    ׆༻෼ੳͨ͠ߦಈϩάΛ΋ͱʹܧଓతͳαʔϏε
    վળ͕ߦ͍͑ͯΔ

    ը૾ग़య: Icons8

    View Slide

  28. #JHGPPU
    wϖύϘͷ࣍ੈ୅ߦಈϩάl׆༻zج൫
    wߦಈϩάͷऩूɺ෼ੳɺ׆༻ͷ֤ஈ֊ʹ͓͍ͯɺ

    શࣾͰར༻Ͱ͖Δ൚༻ੑͱ۩ମతͳ׆༻ํ๏Λఏڙ
    wࠃ಺࠷େڃϋϯυϝΠυϚʔέοτ

    NJOOFΛࢧ͑Δϩάج൫

    ը૾ग़య: Icons8

    View Slide

  29. #JHGPPUʹ͓͚ΔσʔλͷྲྀΕ
    rack-bigfoot
    Service
    Request
    Activity
    log
    Services
    DB
    Attribute
    Big Cube
    Cube
    BI
    Recommendation
    Bandit algorithm
    Re-marketing
    Feedback
    Name identification

    ऩू ෼ੳ
    ׆༻
    ը૾ग़య: Icons8

    View Slide

  30. ऩूͱ෼ੳͷ޻෉

    View Slide

  31. ऩूஈ֊
    w਺ߦͷઃఆͰαʔϏεΞϓϦέʔγϣϯͷ

    ௨৴಺༰͔ΒߦಈϩάΛऔΓग़͢SBDLCJHGPPU
    w5SFBTVSF%BUBʹଐੑ৘ใΛૹΔ͜ͱͰ

    ߦಈϩάͱͷ૊Έ߹ΘͤΛՄೳʹ
    w֤αʔϏεͷ*%ͱߦಈϩάͷ୺຤*%ΛϚοϐϯάͯ͠
    ૒ํ޲ͷ*%ม׵ΛՄೳʹ

    View Slide

  32. ෼ੳஈ֊
    w42-ϥΠΫͳ)JWF1SFTUPΛར༻ͯ͠σʔλૢ࡞
    wεέδϡʔϧΫΤϦΛίʔυ؅ཧ͢Δ1FOEVMVN
    w#JH$VCFʹશαʔϏεͷߦಈϩάΛू໿
    w$VCFʹूܭ஋Λอଘͯ͠μογϡϘʔυ͔Βࢀর

    ྫʣ࣌ؒ͝ͱͷച্

    View Slide

  33. σʔλ͕
    ͋Δʂ

    View Slide

  34. ׆༻ஈ֊

    View Slide

  35. σʔλۦಈϚʔέςΟϯάͷ࣮ݱ

    View Slide

  36. ੩తͳσʔλۦಈϚʔέςΟϯά
    w෼ੳͨ݁͠Ռ͔ΒԾઆΛཱͯͯαʔϏεΛվળ͢Δ
    wݩʑ΍Γ͔ͨͬͨ͜ͱ
    wσβΠϯมߋ εςοϓͷݟ௚͠ "#ςετFUD

    View Slide

  37. ಈతͳσʔλۦಈϚʔέςΟϯά

    View Slide

  38. όϯσΟοτΞϧΰϦζϜ
    w&QTJMPO(SFFEZΞϧΰϦζϜ
    w୳ٻ֬཰ЏͰϥϯμϜʹબ୒ͨ͠ύλʔϯΛ࢖༻
    w׆༻֬཰ Џ
    Ͱظ଴஋͕࠷େͷύλʔϯΛ࢖༻
    wϩά͔Β݁Ռͷظ଴஋Λߋ৽
    wػձଛࣦΛݮΒ͢
    Activity
    Epsilon-Greedy algorithm
    User
    1-ε: exploitation
    ε/pattern: exploration
    Click / Not click
    Import
    ը૾ग़య: Icons8

    View Slide

  39. Ϩίϝϯσʔγϣϯ
    wڠௐϑΟϧλϦϯά
    wϢʔβʔߦಈ͔Β࡞ՈΛಘ఺෇͚
    w5SFBTVSF%BUBͷػցֶशϥΠϒϥϦ)JWFNBMMΛར༻

    Activity
    Filter and shuffle
    Users
    fav, follow etc…
    Matrix Factorization
    Recommendation
    import
    DB
    ը૾ग़య: Icons8

    View Slide

  40. ཭୤Ϣʔβʔ΁ͷϦςϯγϣϯ
    wߦಈϩά͔Β཭୤ϢʔβʔΛநग़
    w࡞඼ΛΧʔτʹೖΕ͕ͨങΘͳ͔ͬͨϢʔβʔ
    wಉ͡࡞඼ΛԿ౓΋ݟ͍ͯΔϢʔβʔ
    wϓογϡ௨஌΍ϝʔϧΛ഑৴
    wߴ͍։෧཰ͱ஫จ཰
    HiveQL
    Re-targeting
    ը૾ग़య: Icons8

    View Slide

  41. ܭըతΦʔτεέʔϦϯά
    wॲཧੑೳΛอͪͭͭඞཁ࠷খݶ਺ͷαʔόͰӡ༻͢Δ
    wΫϥ΢υαʔϏεར༻ྉۚͷ཈੍
    wߦಈϩά͔ΒΞΫηε܏޲ΛϞσϧԽͯࣗ͠ಈ੍ޚ

    View Slide

  42. #JHGPPUΛߏஙɾӡ༻ͯ͠

    View Slide

  43. #JHGPPUΛߏஙɾӡ༻ͯ͠
    w׆༻ஈ֊ʹ͓͍ͯσʔλۦಈϚʔέςΟϯάʹΑΔ

    ࢪࡦ͕Մೳͱͳͬͨ
    wͲͷΑ͏ͳࢪࡦΛ࣮ࢪ͢Δ΂͖͔͸

    ༷ʑͳσʔλιʔεͱ༷ʑͳ੾Γޱ͔Β

    ਓ͕ࢥߟ൑அ͢Δඞཁ͕͋Δ

    View Slide

  44. ՝୊ʹର͢ΔͭͷΞϓϩʔν

    wߦಈϩάج൫z#JHGPPUz
    wߦಈϩάͷऩू෼ੳΛߦ͏
    wγεςϜͱ࿈ܞͨ͠ߦಈϩάͷ׆༻Λߦ͏
    w,1*؅ཧج൫l1FQBMZUJDTz
    wσʔλͷؔ࿈ΛఆࣜԽͯ͠෼ੳΛ༰қʹ͢Δ

    View Slide

  45. ϖύϘͷ,1*؅ཧج൫
    l1FQBMZUJDTz

    View Slide

  46. 1FQBMZUJDT

    ྫʣྲྀ௨ֹ ஫จֹ
    Ωϟϯηϧֹ
    w෼ੳΛิॿ͢ΔͨΊσʔλͷؔ࿈Λ,1*πϦʔͰදݱ

    View Slide

  47. ໨ࢦͨ͠΋ͷ
    wैདྷͷ,1*؅ཧͷ՝୊Λղܾͯ͠Ϛʔέλʔ͕,(*ʹ
    ରͯ͠د༩౓ͷߴ͍ࢪࡦʹઐ೦Ͱ͖Δ؀ڥΛ࡞Δ
    w,1*ಉ࢜ͷؔ܎ੑͷ੔ཧ
    wఆٛ΍؅ཧํ๏͔ΒଐਓੑΛഉআ
    wσʔλநग़΍ूܭʹ͔͔Δ޻਺ͷ࡟ݮ

    View Slide

  48. ,1*πϦʔ
    w࿦ཧߏ଄Ͱ,1*ΛҰཡ
    w,(*,1*ͷ஋
    w,(*,1*ͷมಈ͠΍͢͞
    w,(*ʹର͢ΔӨڹ౓
    w໿ϊʔυΛੜ੒
    wྲྀೖݩ·ͰḪΕΔ

    View Slide

  49. σΟϝϯγϣϯ
    wෳ਺ͷσΟϝϯγϣϯͱ
    ୯Ґ࣌ؒΛࢦఆՄೳ
    wάϥϑԽΫϩεूܭ
    wଐੑ৘ใͱߦಈϩάΛɹ
    σΟϝϯγϣϯԽ
    wϢʔβʔଐੑ ஫จ৘ใ
    wӾཡ؀ڥ

    View Slide

  50. Ξγετίϯόʔδϣϯ
    wΞτϦϏϡʔγϣϯϞσϧΛಋೖ
    wίϯόʔδϣϯʹର͢Δηογϣϯͷߩݙ౓Λࢦఆ

    ໊শ આ໌
    ऴ఺ ࠷ޙͷࢀরݩʹߩݙ౓͕100%ׂΓৼΒΕΔ
    ࠷ޙͷؒ઀ΫϦοΫ ௚઀ࢀরΛআ͘࠷ޙͷࢀরݩʹߩݙ౓͕100%ׂΓৼΒΕΔ
    ى఺ ࠷ॳͷࢀরݩʹߩݙ౓͕100%ׂΓৼΒΕΔ
    … …

    View Slide

  51. ෼ੳஈ֊ʹ͓͚Δ
    σʔλۦಈϚʔέςΟϯά΋
    ਐΜͰ͖ͨ

    View Slide

  52. ·ͱΊ

    View Slide

  53. ·ͱΊ
    w#JHGPPUʹΑͬͯಈతͳ

    σʔλۦಈϚʔέςΟϯά͕Մೳͱͳͬͨ
    w1FQBMZUJDTʹΑͬͯਓؒͷߴ࣍ͳ൑அΛ

    ิॿ͢Δ͜ͱ͕Մೳͱͳͬͨ
    wγεςϜ͕ࣗಈతʹࢪࡦΛܾఆɾ࣮ࢪ͢Δ

    ׬શಈతσʔλۦಈϚʔέςΟϯάΛ໨ࢦ͢

    View Slide

  54. ͓ΘΓ

    View Slide

  55. ݚڀһɺੵۃతʹืूதʂ
    https://rand.pepabo.com/

    View Slide