SQL Call
SELECT * FROM Attribution@coprocessor (
ON attribution_sample_table3
PARTITION BY user_id
ORDER BY time_stamp
USING
EventColumn ('event')
ConversionEvents ('SocialNetwork', 'PaidSearch')
TimestampColumn ('time_stamp')
WindowSize ('rows:10&seconds:20')
Model1 ('SEGMENT_ROWS', '3:0.5:EXPONENTIAL:0.5,ROW',
'4:0.3:WEIGHTED:0.4,0.3,0.2,0.1', '3:0.2:FIRST_CLICK:NA')
Model2 ('SEGMENT_SECONDS', '6:0.5:UNIFORM:NA',
'8:0.3:LAST_CLICK:NA', '6:0.2:FIRST_CLICK:NA')
) AS dt;
Output
user_id |
event |
time_stamp |
attribution |
time_to_conversion |
1 |
impression |
2001-09-27 23:00:07 |
0 |
|
1 |
impression |
2001-09-27 23:00:09 |
0 |
|
1 |
impression |
2001-09-27 23:00:11 |
0 |
|
1 |
impression |
2001-09-27 23:00:13 |
0.375 |
-8 |
1 |
Email |
2001-09-27 23:00:15 |
0.208333 |
-6 |
1 |
impression |
2001-09-27 23:00:17 |
0.208333 |
-4 |
1 |
impression |
2001-09-27 23:00:19 |
0.208333 |
-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 |
|
2 |
impression |
2001-09-27 23:00:51 |
0.375 |
-8 |
2 |
impression |
2001-09-27 23:00:53 |
0.3125 |
-6 |
2 |
impression |
2001-09-27 23:00:55 |
0.3125 |
-4 |
2 |
SocialNetwork |
2001-09-27 23:00:59 |
|
|