Slide 1
Slide 1 text
©2022 Wantedly, Inc.
ΞϓϦͷϩάΛνʔϜ֎Ͱ׆༻
ͯ͠Β͏ͨΊʹͬͨ͜ͱ
.PCJMFษڧձ
Shota Kashihara @kashihararara
Slide 2
Slide 2 text
©2022 Wantedly, Inc.
λΠτϧͷิͰ͢
ΞϓϦͷϩάΛ → Treasure Data / Google Analytics for Firebase ͷϩά
νʔϜ֎Ͱ → ϞόΠϧΞϓϦνʔϜҎ֎ͷϝϯόʔ
׆༻͢Δ → తͷࢦඪʹ͍ͭͯूܭ͢Δ͜ͱ
࠷ॳʹ
Slide 3
Slide 3 text
©2022 Wantedly, Inc.
5SFBTVSF%BUB("GPS'JSFCBTFͷϩάΛ
ϞόΠϧΞϓϦνʔϜҎ֎ͷϝϯόʔ͕
తͷࢦඪʹ͍ͭͯࣗ༝ʹूܭ͢ΔͨΊʹͬͨ͜ͱ
.PCJMFษڧձ
Shota Kashihara @kashihararara
Slide 4
Slide 4 text
©2022 Wantedly, Inc.
ཧͱݱ࣮
Slide 5
Slide 5 text
©2022 Wantedly, Inc.
՝
ΞϓϦͷϩά
ΞϓϦΤϯδχΞ ඇΞϓϦΤϯδχΞ
࣮ ར༻
ཧ
Slide 6
Slide 6 text
©2022 Wantedly, Inc.
՝
ΞϓϦͷϩά
ΞϓϦΤϯδχΞ ඇΞϓϦΤϯδχΞ
ूܭ
ґཔ
ݱ࣮
Slide 7
Slide 7 text
©2022 Wantedly, Inc.
՝
ϩάར༻ʹ͔͔Δ༷ʑͳϋʔυϧ
w ͭͷUBCMF
EBUBTFUʹશͯͷϩά͕ೖ͍ͬͯΔ
w ཉ͍͠ϩάʹରԠ͢ΔFWFOU@OBNF
FWFOU@QBSBNT͕Θ͔Βͳ͍
w TDIFNF͕ͳ͍
w FWFOU@OBNF
FWFOU@QBSBNTͷΓํ͕όϥόϥ
w ҉ͷʑ
w J04
"OESPJEͰFWFOU@OBNF͕ҟͳΔ
w J04
"OESPJE͓Αͼ࢞ຓΞϓϦͷϩάಉҰUBCMFʹೖ͍ͬͯΔ
w 4XJGU,PUMJOͷΫϥε໊࣮༝དྷͷ͕ϩάʹೖ͍ͬͯΔ
w લʹFWFOU@OBNFͷUZQPΛͨ͠FUD
Slide 8
Slide 8 text
©2022 Wantedly, Inc.
՝
-- εΫϦʔϯϩάΛूܭ͢Δ View
select
case (
select value.string_value
from unnest(event_params)
where key = "screen_name"
)
when "UserViewController" then "Ϣʔβʔը໘"
when "SettingViewController" then "ઃఆը໘"
... -- @ը໘͚ͩ
else ""
end,
... -- user_id ͳͲ
from `.analytics.events_*`
where _table_suffix = "20220401"
and event_name = "screen_event"
and app_info.id = "com.wantedly.app"
w ը໘ͱΫϥε໊ͷରԠΛͬͯ
͍Δ ඞཁ͕͋Δ
w εΫϦʔϯϩάͷFWFOU@OBNF
Λ͍ͬͯΔ
w తͷΞϓϦͷCVOEMF
JEFOUJ
fi
FSΛ͍ͬͯΔ
ूܭ͢ΔͨΊʹɺΒͳ͍ͱ͍͚ͳ͍͜ͱ͕ଟ͍
Slide 9
Slide 9 text
©2022 Wantedly, Inc.
՝
ॱ൪ʹϩάΛཧ͍ͯ͘͠
w ੳ͍͢͠ܗʹΠϕϯτͷཻΛἧ͑Δ
w ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δ
w ࡞ͬͨ7JFXͷΫΤϦΛ(JU)VCͰཧ͢Δ
Slide 10
Slide 10 text
©2022 Wantedly, Inc.
ੳ͍͢͠ܗʹΠϕϯτͷཻΛἧ͑Δ
τοϓϨϕϧͷFWFOU@OBNFʹͯ͢ͷΠϕϯτΛྻڍ͢ΔͷͰͳ͘ɺΠϕϯτΛΧ
ςΰϦ͝ͱʹू͢Δ
ޙड़͢ΔɺFWFOU@OBNFͰ·ͱ·ͬͨ7JFXΛ࡞ΔͨΊͷԼ४උ
enum EventName {
case tapControl(name: TapControlName)
...
}
enum TapControlName {
case userShareButton(userId: String)
case companyShareButton(companyId: String)
...
}
Slide 11
Slide 11 text
©2022 Wantedly, Inc.
enum EventName {
// DO NOT EDIT
extension Event {
var name: String {
switch self {
case .tapControl:
return "tap_control"
}
}
var params: [String: Any] {
switch self {
case .tapControl(name):
switch name {
case .userShareButton(let userId):
return ["name": "user_share_button", "user_id": userId]
case .companyShareButton(let companyId):
return ["name": "company_share_button", "company_id": companyId]
}
}
}
}
TUFDJM
📄
Slide 12
Slide 12 text
©2022 Wantedly, Inc.
ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δ
શͯͷϩά͕ೖ͍ͬͯΔςʔϒϧ͔ΒɺΧςΰϦ͝ͱʹ7JFXΛΓग़͢
ඇΞϓϦΤϯδχΞ
ཁٻ͞ΕΔ༷ʑͳ҉
BOBMZUJDTFWFOUT@
-- εΫϦʔϯϩάΛूܭ͢Δ View
select
case (
select value.string_value
from unnest(event_params)
where key = "screen_name"
)
when "UserViewController" then "Ϣʔβʔը໘"
when "SettingViewController" then "ઃఆը໘"
... -- @ը໘͚ͩ
else ""
end,
... -- user_id ͳͲ
from `.analytics.events_*`
where _table_suffix = "20220401"
and event_name = "screen_event"
and app_info.id = "com.wantedly.app"
Slide 13
Slide 13 text
©2022 Wantedly, Inc.
ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δ
શͯͷϩά͕ೖ͍ͬͯΔςʔϒϧ͔ΒɺΧςΰϦ͝ͱʹ7JFXΛΓग़͢
ඇΞϓϦΤϯδχΞ
҉ΛӅṭͨ͠7JFX
-- εΫϦʔϯϩάΛूܭ͢Δ View
select *
from `ios_screen_view`
JPT@TDSFFO@WJFX
JPT@TDSFFO@WJFX
JPT@TDSFFO@WJFX
BOBMZUJDTFWFOUT@
-- εΫϦʔϯϩάΛूܭ͢Δ View
select
case (
select value.string_value
from unnest(event_params)
where key = "screen_name"
)
when "UserViewController" then "Ϣʔβʔը໘"
when "SettingViewController" then "ઃఆը໘"
... -- @ը໘͚ͩ
else ""
end,
... -- user_id ͳͲ
from `.analytics.events_*`
where _table_suffix = "20220401"
and event_name = "screen_event"
and app_info.id = "com.wantedly.app"
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 ྫ
ϓογϡ௨ͷड৴ϩά ։෧ϩά ϓογϡ௨ͷ։෧ͷूܭ
Slide 15
Slide 15 text
©2022 Wantedly, Inc.
࡞ͬͨ7JFXͷΫΤϦΛ(JU)VCͰཧ͢Δ
#JH2VFSZͷ7JFX6%'Λ(JU)VCͰཧ͢ΔπʔϧSFSPTUCRW
https://www.wantedly.com/companies/wantedly/post_articles/286165
Slide 16
Slide 16 text
©2022 Wantedly, Inc.
࡞ͬͨ7JFXͷΫΤϦΛ(JU)VCͰཧ͢Δ
#JH2VFSZͷ7JFX6%'Λ(JU)VCͰཧ͢ΔπʔϧSFSPTUCRW
w ΫΤϦͷϨϏϡʔ͕ग़དྷΔ
w ΫΤϦͷଐਓԽɺൿͷλϨԽΛ͙
Slide 17
Slide 17 text
©2022 Wantedly, Inc.
՝
ΞϓϦͷϩά
ΞϓϦΤϯδχΞ ඇΞϓϦΤϯδχΞ
ूܭ
ґཔ
ݱ࣮
Slide 18
Slide 18 text
©2022 Wantedly, Inc.
՝
7JFX
ΞϓϦΤϯδχΞ ඇΞϓϦΤϯδχΞ
࣮ ར༻
ݱࡏ
ΞϓϦͷϩά
Slide 19
Slide 19 text
©2022 Wantedly, Inc.
͓͞Β͍
ॱ൪ʹϩάΛཧ͍ͯ͘͠
w ੳ͍͢͠ܗʹΠϕϯτͷཻΛἧ͑Δ
w ҙຯͷ͋Δ୯ҐͰ7JFXΛ࡞Δ
w ࡞ͬͨ7JFXͷΫΤϦΛ(JU)VCͰཧ͢Δ
Slide 20
Slide 20 text
ϖʔδλΠτϧ ϖʔδαϒλΠτϧ
©2022 Wantedly, Inc.
5IBOLT