Slide 1

Slide 1 text

RͰ࢝ΊΔSalesForce ʙsalesforcerʹΑΔSalesForceσʔλૢ࡞ʙ

Slide 2

Slide 2 text

໨࣍ ૝ఆࢹௌऀͱ໨త……………………………………………………Q ࠓ೔࿩͞ͳ͍͜ͱ……………………………………………………Q SalesForceͱ͸………………………………………………………Qd salesforcerͱ͸………………………………………………………Qd ΦϒδΣΫτͱ͸……………………………………………………Qd SOQLͱ͸………………………………………………………………Qd Ϩϙʔτͱ͸……………………………………………………………Qd ࢀߟจݙ……………………………………………………………………Q salesforce

Slide 3

Slide 3 text

૝ఆࢹௌऀͱ໨త ໨త ૝ఆࢹௌऀ جຊ༻ޠʢΦϒδΣΫτɺSOQLʣ ΛRΛ௨ͯ͠ཧղ͢Δɻ • SalesForceΛ໊લ͔͠஌Βͳ͍ • R͸࢖༻͍ͯ͠Δ • ϚʔέςΟϯάͱؔΘΓ͕͋Δ • GUIʹ௚઀৮Γͨ͘ͳ͍

Slide 4

Slide 4 text

ߴ౓ͳ͜ͱ → ೖ໳ฤͳͷͰ ։ൃͷ͜ͱ → ҰൠϢʔβʔΛ૝ఆʢDeveloper Console͸ͪΐͬͱ࢖͏ʣ Ϩϙʔτܥ → ௐࠪෆ଍ͷͨΊʢεϥΠυ͸͋Δ͚Ͳؒҧ͍͋Δ͔΋ʣ ࠓ೔࿩͞ͳ͍͜ͱ

Slide 5

Slide 5 text

SalesForceͱ͸ salesforce

Slide 6

Slide 6 text

SalesForceͱ͸ Salesforce͸ɺاۀͱސ٬Λͭͳ͙ސ٬؅ཧιϦϡʔγϣϯɻϚʔέςΟϯάɺӦ ۀɺίϚʔεɺαʔϏεͳͲ͢΂ͯͷ෦ॺͰɺސ٬ҰਓͻͱΓͷ৘ใΛҰݩతʹڞ ༗Ͱ͖Δ౷߹CRMϓϥοτϑΥʔϜͰ͢ɻ https://www.salesforce.com/jp/products/what-is-salesforce/ https://www.salesforce.com/campaign/worlds-number-one-CRM/

Slide 7

Slide 7 text

https://www.salesforce.com/jp/hub/crm/what-is-crm/ SalesForceͱ͸ CRMͱ͸ʮCustomer Relationship ManagementʯͷུͰɺ೔ຊޠͰ͸ʮސ ٬ؔ܎؅ཧʯͱݺ͹Ε·͢ɻސ٬ͱͷؔ܎ੑɺίϛϡχέʔγϣϯΛ؅ཧ ͠ɺࣗࣾͷैۀһͱސ٬ͱͷؔ܎ΛҰݩతʹ೺ѲͰ͖ΔΑ͏ʹ͠·͢ɻ

Slide 8

Slide 8 text

SalesForceͱ͸ ຊ೔͸ແྉͰ৮ΕΔσϞΞΧ΢ϯτͰਐΊΔɻ https://developer.salesforce.com/signup

Slide 9

Slide 9 text

SalesForceͱ͸ σϞΞΧ΢ϯτొ࿥׬ྃޙͷτοϓϖʔδɻ

Slide 10

Slide 10 text

Ͱ΍ͬͯΈΑ͏

Slide 11

Slide 11 text

salesforcerͱ͸

Slide 12

Slide 12 text

https://stevenmmortimer.github.io/salesforcer/index.html salesforcerͱ͸ ϦϦʔε೔ɿ ࠷৽Ξοϓσʔτ೔ɿ ։ൃऀ໊ɿSteven M. Mortimer ʢݱࡏʣ RͰSalesForceΛૢ࡞Ͱ͖Δlibraryɻ

Slide 13

Slide 13 text

salesforcerͱ͸ or OAuth libraryΛΠϯετʔϧޙɺೝূ৘ใΛઃఆͯ͠઀ଓɻ Ϣʔβʔ໊ɺύεϫʔυɺηΩϡϦςΟτʔΫϯ͕ඞཁɻ ʢIP੍ݶֻ͕͔͍ͬͯΔͱηΩϡϦςΟτʔΫϯ͕औಘͰ͖ͳ͍ʣ

Slide 14

Slide 14 text

sf_user_infoͰ઀ଓ৘ใͷ֬ೝɻlistܗࣜͰฦ͞ΕΔɻ salesforcerͱ͸

Slide 15

Slide 15 text

ΦϒδΣΫτͱ͸

Slide 16

Slide 16 text

ΦϒδΣΫτͱ͸ ΦϒδΣΫτ ≒ ςʔϒϧ

Slide 17

Slide 17 text

ΦϒδΣΫτͱ͸ SalesForceͷ্෦ʹλϒঢ়ʹ͋Δɺͻͱͭͻͱ͕ͭΦϒδΣΫτɻ

Slide 18

Slide 18 text

https://trailhead.salesforce.com/ja/content/learn/modules/lex_salesforce_basics/lex_salesforce_basics_welcome ΦϒδΣΫτͱ͸ ΦϒδΣΫτʹ͸ॳΊ͔Β༻ҙ͞Ε͍ͯΔʮඪ४ΦϒδΣΫτʯͱɺϢʔ βʔ͕࡞੒͢ΔʮΧελϜΦϒδΣΫτʯ͕͋ΔɻԼͷਤ͸ඪ४ΦϒδΣΫ τͷҰ෦ɻ

Slide 19

Slide 19 text

ͰΦϒδΣΫτҰཡΛऔಘ͢Δ

Slide 20

Slide 20 text

ΦϒδΣΫτͱ͸ sf_list_objectsͰऔಘɻlistܗࣜͰฦ͞ΕΔɻ

Slide 21

Slide 21 text

Ͱ΍Δͱʁ salesforce

Slide 22

Slide 22 text

ΦϒδΣΫτͱ͸ ઃఆ͔ΒDeveloper ConsoleΛ։͘ɻ

Slide 23

Slide 23 text

ΦϒδΣΫτͱ͸ File͔ΒOpen ResourceΛ։͘ɻ

Slide 24

Slide 24 text

ΦϒδΣΫτͱ͸ ݕࡧ૭Ͱʮ.objʯͰऴΘΔ΋ͷΛݕࡧɻ

Slide 25

Slide 25 text

SOQLͱ͸

Slide 26

Slide 26 text

SOQLͱ͸ SOQLʢSalesforce Object Query Languageʣ ≒ SQLʢ*Structured Query Languageʣ *ANSIن֨ͷSQLͱ͍͏໊শ͸ެࣜʹ͸ԿͷུͰ΋ͳ͍ͱ͞ΕΔɻ http://e-words.jp/w/SQL.html

Slide 27

Slide 27 text

ͰΦϒδΣΫτͷத਎Λऔಘ͢Δ

Slide 28

Slide 28 text

SOQLͱ͸ sf_queryʹจࣈྻΛ౉͢ɻFROMʹΦϒδΣΫτΛࢦఆɻ

Slide 29

Slide 29 text

Ͱ΍Δͱʁ salesforce

Slide 30

Slide 30 text

ઃఆ͔ΒDeveloper ConsoleΛ։͘ɻ SOQLͱ͸

Slide 31

Slide 31 text

SOQLͱ͸ Query EditorΛબ୒͠ɺΫΤϦΛهड़ɺExecuteΛԡ͢ɻ

Slide 32

Slide 32 text

SOQLͱ͸ தԝͷը໘ʹ݁Ռ͕දࣔ͞ΕΔɻ

Slide 33

Slide 33 text

Ϩϙʔτͱ͸

Slide 34

Slide 34 text

Ϩϙʔτͱ͸ Ϩϙʔτ ≒ ΦϒδΣΫτΛूܭͨ͠΋ͷ

Slide 35

Slide 35 text

Ϩϙʔτͱ͸ τοϓϖʔδͷλϒʹଘࡏ͢Δɻ

Slide 36

Slide 36 text

ͰϨϙʔτΛ࡞੒͢Δ

Slide 37

Slide 37 text

Ϩϙʔτͱ͸ sf_create_reportͰϕʔεͷϨϙʔτΛ࡞੒͔ͯ͠ΒɺϑΟϧλΛઃఆͯ͠ sf_run_reportͰ࠶౓࡞੒͢Δɻ

Slide 38

Slide 38 text

Ͱ΍Δͱʁ salesforce

Slide 39

Slide 39 text

Ϩϙʔτͱ͸ Ϩϙʔτը໘ͷNew Reportʢ৽نϨϙʔτʣΛ࣮ߦɻ

Slide 40

Slide 40 text

Ϩϙʔτͱ͸ ूܭର৅ͱͳΔΦϒδΣΫτΛબ୒ɻ

Slide 41

Slide 41 text

Ϩϙʔτͱ͸ FilterͰ৚݅Λઃఆɻ

Slide 42

Slide 42 text

Ϩϙʔτͱ͸ ूܭ݁Ռ͕ը໘தԝʹදࣔ͞ΕΔɻ

Slide 43

Slide 43 text

·ͱΊ SalesForceͱ͸ salesforcerͱ͸ ΦϒδΣΫτͱ͸ SOQLͱ͸ Ϩϙʔτͱ͸ CRMϓϥοτϑΥʔϜ RͰSalesForceΛૢ࡞͢Δlibrary SalesForceͷςʔϒϧ SalesForceͷSQL ΦϒδΣΫτΛूܭͨ͠΋ͷ

Slide 44

Slide 44 text

ɾTRAILHEAD https://trailhead.salesforce.com/ja/home ɾGitHub, ʮAn Implementation of Salesforce APIs Using Tidy Principles • salesforcerʯ https://stevenmmortimer.github.io/salesforcer/index.html ɾCRAN, ʮPackage salesforcerʯ https://cloud.r-project.org/web/packages/salesforcer/index.html ɾQiita, ʮΤϯδχΞͷͨΊͷsalesforce௒ೖ໳ʯ https://qiita.com/tarokamikaze/items/0bc2988534f63d4b65c5 ࢀߟจݙ

Slide 45

Slide 45 text

ENJOY!