Slide 7
Slide 7 text
©2019 Wantedly, Inc.
1. BigQuery ͷجຊతͳࣝ
• جຊతͳ SQL ͷࣝ͋Δલఏ
• BigQuery ͳΒͰͷಛΛ͑ΔʢྻࢦɼARRAY ͷѻ͍ɼWindow ؔ…ʣ
2. Wantedly ͷαʔϏεʹ͍ͭͯͷσʔλͷυϝΠϯࣝ
• Ұൠతͳͱ͜ΖʢBotɼRPAɼࣗࣾࣾһͷߦಈ …ʣผͷߨٛʢʰσʔλΛਖ਼͘͠ݟΔͨΊʹʱʣͰ
• ςʔϒϧϨϕϧͷࣝʢʮΛฉ͖ʹߦ͖͍ͨʯͷσʔλͱʁɼεΧτػೳͷݕࡧϩάͲ͜ʹ͋Δʁʣ
3. σʔλΛੳ͢Δࡍͷࢦඪʹ͍ͭͯͷࣝ
• ҰൠతͳࢦඪʢMAUɼARPUɼRetentionɼPVɼImpression…ʣ
• υϝΠϯґଘͳࢦඪʢVisit ͷCVR ͱʁɼ༗ྉاۀͷܧଓͱʁʣ
͜ͷݚमΛ௨ͯ͠ಘͯ΄͍͠ͷ