Input
attribution_sample_table3
user_id |
event |
time_stamp |
1 |
impression |
2001-09-27 23:00:07 |
1 |
impression |
2001-09-27 23:00:09 |
1 |
impression |
2001-09-27 23:00:11 |
1 |
impression |
2001-09-27 23:00:13 |
1 |
Email |
2001-09-27 23:00:15 |
1 |
impression |
2001-09-27 23:00:17 |
1 |
impression |
2001-09-27 23:00:19 |
1 |
SocialNetwork |
2001-09-27 23:00:21 |
1 |
PaidSearch |
2001-09-27 23:00:23 |
2 |
impression |
2001-09-27 23:00:29 |
2 |
impression |
2001-09-27 23:00:31 |
2 |
impression |
2001-09-27 23:00:33 |
2 |
impression |
2001-09-27 23:00:47 |
2 |
impression |
2001-09-27 23:00:51 |
2 |
impression |
2001-09-27 23:00:53 |
2 |
impression |
2001-09-27 23:00:55 |
2 |
SocialNetwork |
2001-09-27 23:00:59 |
SQL Call
SELECT * FROM Attribution@coprocessor (
ON attribution_sample_table3
PARTITION BY user_id
ORDER BY time_stamp
USING
EventColumn ('event')
ConversionEvents ('SocialNetwork', 'PaidSearch')
ExcludeEvents ('Email')
TimestampColumn ('time_stamp')
WindowSize ('rows:10&seconds:20')
Model1 ('SIMPLE', 'UNIFORM:NA')
) AS dt;
Output
user_id |
event |
time_stamp |
attribution |
time_to_conversion |
1 |
impression |
2001-09-27 23:00:07 |
0.166667 |
-14 |
1 |
impression |
2001-09-27 23:00:09 |
0.166667 |
-12 |
1 |
impression |
2001-09-27 23:00:11 |
0.166667 |
-10 |
1 |
impression |
2001-09-27 23:00:13 |
0.166667 |
-8 |
1 |
impression |
2001-09-27 23:00:17 |
0.166667 |
-4 |
1 |
impression |
2001-09-27 23:00:19 |
0.166667 |
-2 |
1 |
SocialNetwork |
2001-09-27 23:00:21 |
|
|
1 |
PaidSearch |
2001-09-27 23:00:23 |
|
|
2 |
impression |
2001-09-27 23:00:29 |
0 |
|
2 |
impression |
2001-09-27 23:00:31 |
0 |
|
2 |
impression |
2001-09-27 23:00:33 |
0 |
|
2 |
impression |
2001-09-27 23:00:47 |
0.25 |
-12 |
2 |
impression |
2001-09-27 23:00:51 |
0.25 |
-8 |
2 |
impression |
2001-09-27 23:00:53 |
0.25 |
-6 |
2 |
impression |
2001-09-27 23:00:55 |
0.25 |
-4 |
2 |
SocialNetwork |
2001-09-27 23:00:59 |
|
|