Slide 14
Slide 14 text
©2022 Wantedly, Inc.
ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δ
7JFXΛΈ߹ΘͤΔ
w ఆٛࡁΈ7JFXΛ࠶ར༻͢Δ͜ͱͰෳࡶΛ͑ͳ͕Β༷ʑͳूܭΛՄೳʹ͢Δ
select
count(receive.id) receive_count,
count(open.id) open_count,
count(open.id) / count(receive.id) open_rate,
from `ios_receive_push_notifications` receive
left outer join `ios_open_push_notifications` open using (id)
w ྫ
ϓογϡ௨ͷड৴ϩά։෧ϩάϓογϡ௨ͷ։෧ͷूܭ