Tweet
Tweet

Slide 1

Slide 1 text

ϑϦϧͷ$.Λࢧ͑Δ෼ੳ ʢϝσΟΞόΠΠϯάฤʣ

Slide 2

Slide 2 text

ࣗݾ঺հ 2

Slide 3

Slide 3 text

3 ࣗݾ঺հ shoby @shobyshoby w 4IPUB*[BLB w 'BCMJD JOD w $.෼ੳJ04

Slide 4

Slide 4 text

֓ཁ 4

Slide 5

Slide 5 text

5 ֓ཁ w ελʔτΞοϓʹͱͬͯͷ$. w վળͷͨΊͷԾઆݕূ w ϝσΟΞόΠΠϯάͷվળ w ༵೔ɾ࣌ؒͷ࠷దԽ w ౎ಓ෎ݝͷ࠷దԽ

Slide 6

Slide 6 text

ελʔτΞοϓʹͱͬͯͷ$. 6

Slide 7

Slide 7 text

7 ελʔτΞοϓʹͱͬͯͷ$. w αʔϏεΛٸ੒௕ͤ͞ΔͨΊͷେ͖ͳ౤ࢿ w $.ͷ੒ޭࣦഊͰαʔϏεͷߦํ͕ܾ·Δ w ݶΒΕͨඅ༻Ͱ࠷େݶϢʔβʔΛ֫ಘ͢Δ

Slide 8

Slide 8 text

8 ελʔτΞοϓʹͱͬͯͷ$. w த௕ظతͳ੒௕ΛૂͬͨϓϩϞʔγϣϯ w தظɿϢʔβʔେྔ֫ಘʹΑΔαʔϏε׆ੑԽ w ௕ظɿαʔϏεೝ஌཰ͷ޲্ w $1*͚ͩߟ͑ΔͱΦϯϥΠϯ޿ࠂͷํ͕͍҆

Slide 9

Slide 9 text

վળͷͨΊͷԾઆݕূ 9

Slide 10

Slide 10 text

10 վળͷͨΊͷԾઆݕূ w ߏஙɺܭଌɺֶशͷαΠΫϧΛճ͢ w ߏஙɿ޿ࠂ಺༰ɺ౤Լεϙοτ w ܭଌɿ%-਺ɺ$1*ɺαʔϏεೝ஌཰ w ֶशɿ਺஋มԽͷཁҼߟ࡯

Slide 11

Slide 11 text

11 վળͷͨΊͷԾઆݕূ

Slide 12

Slide 12 text

ϝσΟΞόΠΠϯάͷվળ 12

Slide 13

Slide 13 text

13 ϝσΟΞόΠΠϯάͷվળ w අ༻ରޮՌͷߴ͍εϙοτͷ౤ԼྔΛ૿΍͢ w ༵೔ɾ࣌ؒͷ࠷దԽ w ౎ಓ෎ݝͷ࠷దԽ

Slide 14

Slide 14 text

14 ϝσΟΞόΠΠϯάͷվળ ༵೔ɾ࣌ؒ ౎ಓ෎ݝ

Slide 15

Slide 15 text

༵೔ɾ࣌ؒͷ࠷దԽ 15

Slide 16

Slide 16 text

16 ༵೔ɾ࣌ؒͷ࠷దԽ w શ೔Ͱങ͍ɺαʔϏεͷϐʔΫλΠϜʹدͤΔ w ίͷࣈ΍ٯ-Ͱ͸୯Ձ͕໿ʙഒʹͳΔͨΊɺ $1*͕ѱԽ͢Δ w ʮϚεϓϩϞʔγϣϯʯͱʮಛఆλʔήοτʯ ͸૬ੑ͕ѱ͍ҹ৅ w λʔήςΟϯά͸ΦϯϥΠϯ޿ࠂͰ΍Δ

Slide 17

Slide 17 text

17 ༵೔ɾ࣌ؒͷ࠷దԽ w طଘϢʔβʔͷϐʔΫλΠϜΛௐ΂Δ w ϐʔΫλΠϜɿλʔήοτ૚ͷ༨Ջ࣌ؒ w $.͕ࢹௌ͞Ε΍͍͢ˍ%-ʹ݁ͼ͖ͭ΍͍͢ w ೥ྸɾੑผ৘ใ΋׆༻ͯ͠෼ੳ

Slide 18

Slide 18 text

౎ಓ෎ݝͷ࠷దԽ 18

Slide 19

Slide 19 text

19 ౎ಓ෎ݝͷ࠷దԽ w $1*ͱਓޱΛߟྀͯ͠౤ԼྔΛௐ੔͢Δ w αʔϏεͱͷ૬ੑ͕ྑ͚Ε͹$1*΋ྑ͍ w ਓޱʹରͯ͠౤Լྔ͕ଟ͗͢Δͱ$1*͕ѱԽ͢Δ

Slide 20

Slide 20 text

20 ౎ಓ෎ݝͷ࠷దԽ w ౎ಓ෎ݝผ$1*ͷܭଌํ๏ w ౎ಓ෎ݝ͝ͱͷΠϯετʔϧ਺Λऔಘ w ϕʔεϥΠϯ͔Βͷ૿෼Λग़͢ w $1*Λग़ͯ͠૬ରൺֱ

Slide 21

Slide 21 text

21 ౎ಓ෎ݝͷ࠷దԽ w ౎ಓ෎ݝผͷΠϯετʔϧ਺Λऔಘ w 'JSFCBTFͱ#JH2VFSZΛ༻͍Δ w શϢʔβʔͷੜσʔλΛूܭՄೳ w ౎ಓ෎ݝ৘ใ͸ࣗಈܭଌͯ͘͠ΕΔ

Slide 22

Slide 22 text

22 ౎ಓ෎ݝͷ࠷దԽ SELECT STRFTIME_UTC_USEC(DATE_ADD(event_dim.timestamp_micros, 9, 'HOUR'), '%Y-%m-%d') AS install_date, user_dim.geo_info.region AS region, EXACT_COUNT_DISTINCT(user_dim.device_info.resettable_device_id) as install_count FROM your_table_name WHERE user_dim.geo_info.country = 'Japan' AND event_dim.name = 'first_open' GROUP BY install_date, region ORDER BY install_date ASC, install_count DESC ౎ಓ෎ݝผͷ%BJMZΠϯετʔϧ਺Λऔಘ

Slide 23

Slide 23 text

23 ౎ಓ෎ݝͷ࠷దԽ ౎ಓ෎ݝผͷ%BJMZΠϯετʔϧ਺Λऔಘ

Slide 24

Slide 24 text

24 ౎ಓ෎ݝͷ࠷దԽ w ϕʔεϥΠϯ͔Βͷ૿෼Λऔಘ w $.Λߦͳ͍ͬͯͳ͍࣌ظͷฏۉ஋ͱൺֱ IUUQXXXJOUFSOFUSJYDPNBVCMPHNFBTVSJOHUIFJNQBDUPGUWBEWFSUJTFNFOUPOXFCUSBGGJDΑΓҾ༻

Slide 25

Slide 25 text

25 ౎ಓ෎ݝͷ࠷దԽ w $1*Λग़ͯ͠૬ରൺֱ w ౎ಓ෎ݝผʹਪఆ$1*Λग़͢ w ྨࣅͨ͠౎ಓ෎ݝͱ૬ରൺֱ w ౤Լྔ͕ద੾͔ͩͬͨ൑அ

Slide 26

Slide 26 text

·ͱΊ 26

Slide 27

Slide 27 text

27 ·ͱΊ w ελʔτΞοϓʹͱͬͯ͸$.͸େ͖ͳ౤ࢿ w த௕ظతͳࢹ఺ͰɺόΠΠϯάͷվળΛߦ͏ w ༵೔ɾ࣌ؒͱ౎ಓ෎ݝͰ౤ԼྔΛௐ੔͢Δ w ༵೔ɾ࣌ؒɿαʔϏεͷϐʔΫλΠϜʹدͤΔ w ౎ಓ෎ݝɿ$1*ͱਓޱΛߟྀͯ͠౤ԼྔΛௐ੔