详情 类型: 任务 状态:处理中 (查看工作流) 优先级: Medium 解决结果: 未解决 标签:无 描述 需协助做Snapchat Click time 分析，确认Snapchat安装的前三次点击行为是来自于哪些渠道
需分析时间：2018/06/21-2018/06/27
load('/Users/milin/advertising/snapchat.Rdata')没有任何点击但是产生了下载行为，占比86%
head(snapchat[[1]])## click_time.x activity_kind network_name
## 1 2018-06-22 06:53:10 session Snapchat Installs
## 2 2018-06-23 06:55:12 session Snapchat Installs
## 3 2018-06-24 13:39:42 session Snapchat Installs
## 4 2018-06-25 02:23:27 event Snapchat Installs
## 5 2018-06-22 08:16:28 session Snapchat Installs
## 6 2018-06-23 04:51:59 session Snapchat Installs
## adid installed_at
## 1 96798fb6-0c4f-48ad-b038-2a1c140c4ddf 2018-06-22 07:40:00
## 2 a8bef087-7730-4617-8bab-e0eabb6bbd4a 2018-06-23 06:58:44
## 3 4b1c44ac-8f8b-4c38-8ada-f274d13d55db 2018-06-24 14:08:33
## 4 94c4c653-a584-4d62-8b08-c0cb1a3cb0ba 2018-06-25 02:26:17
## 5 f704c170-72b3-4a88-8c98-334b8a4a1126 2018-06-22 08:17:20
## 6 81e506c0-1df2-436b-b4f8-7273bb608efa 2018-06-23 04:55:19
## install_time
## 1 2018-06-22 06:53:10
## 2 2018-06-23 06:55:12
## 3 2018-06-24 13:39:42
## 4 2018-06-25 02:23:27
## 5 2018-06-22 08:16:28
## 6 2018-06-23 04:51:59head(snapchat[[2]])## adid install_time
## 1 0013bb48-cc9b-4383-b509-2236f9e72225 2018-06-25 06:29:34
## 2 00356545-d6e8-4b73-9e7b-b9a6a028eff0 2018-06-24 23:48:55
## 3 006012c2-0299-4afb-b603-483bc091bed8 2018-06-26 13:50:21
## 4 006511b0-9e43-49e1-9ddc-9b874574d621 2018-06-22 04:28:48
## 5 006a70db-fe86-4eae-bb6b-4f1afd4c6ae5 2018-06-24 05:49:00
## 6 006b3829-4c78-43aa-92d5-8249866017e8 2018-06-26 13:09:13
## click_time1 action1 network1 click_time2 action2
## 1 2018-06-23 17:45:31 click Affle <NA> <NA>
## 2 2018-06-22 09:40:24 click Affle <NA> <NA>
## 3 2018-06-26 06:19:40 click Affle 2018-06-24 03:27:43 click
## 4 2018-06-13 07:24:54 click Affle <NA> <NA>
## 5 2018-06-20 14:08:13 click Affle <NA> <NA>
## 6 2018-06-24 07:18:35 click Affle 2018-06-24 07:18:21 click
## network2 click_time3 action3 network3 click_time4
## 1 <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA>
## 3 Affle 2018-06-24 03:27:41 click Affle 2018-06-24 03:27:31
## 4 <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA>
## 6 Affle 2018-06-21 00:02:10 click Affle <NA>
## action4 network4 click_time5 action5 network5
## 1 <NA> <NA> <NA> <NA> <NA>
## 2 <NA> <NA> <NA> <NA> <NA>
## 3 click Affle <NA> <NA> <NA>
## 4 <NA> <NA> <NA> <NA> <NA>
## 5 <NA> <NA> <NA> <NA> <NA>
## 6 <NA> <NA> <NA> <NA> <NA>占比14%
总结：数据全部有问题