SQL Call
SELECT * FROM Attribution@coprocessor (
ON attribution_sample_table
PARTITION BY user_id
ORDER BY time_stamp
USING
EventColumn ('event')
ConversionEvents ('SocialNetwork', 'PaidSearch')
OptionalEvents ('OrganicSearch', 'Direct', 'Referral')
TimestampColumn ('time_stamp') Window ('rows:10&seconds:20')
Model1 ('EVENT_REGULAR', 'Email:0.19:LAST_CLICK:NA',
'impression:0.81:WEIGHTED:0.4,0.3,0.2,0.1')
Model2 ('EVENT_OPTIONAL', 'ALL:1:WEIGHTED:0.4,0.3,0.2,0.1')
) AS dt;
Output
user_id |
event |
time_stamp |
attribution |
time_to_conversion |
1 |
impression |
2001-09-27 23:00:01 |
0 |
|
1 |
impression |
2001-09-27 23:00:03 |
0 |
|
1 |
impression |
2001-09-27 23:00:05 |
0 |
|
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.081 |
-9 |
1 |
impression |
2001-09-27 23:00:13 |
0.162 |
-7 |
1 |
Email |
2001-09-27 23:00:15 |
0.19 |
-5 |
1 |
impression |
2001-09-27 23:00:17 |
0.243 |
-3 |
1 |
impression |
2001-09-27 23:00:19 |
0.324 |
-1 |
1 |
SocialNetwork |
2001-09-27 23:00:20 |
|
|
1 |
Direct |
2001-09-27 23:00:21 |
0.428571 |
-2 |
1 |
Referral |
2001-09-27 23:00:22 |
0.571429 |
-1 |
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:36 |
0 |
|
2 |
impression |
2001-09-27 23:00:38 |
0 |
|
2 |
impression |
2001-09-27 23:00:43 |
0 |
|
2 |
impression |
2001-09-27 23:00:47 |
0.1 |
-12 |
2 |
impression |
2001-09-27 23:00:51 |
0.2 |
-8 |
2 |
impression |
2001-09-27 23:00:53 |
0.3 |
-6 |
2 |
impression |
2001-09-27 23:00:55 |
0.4 |
-4 |
2 |
SocialNetwork |
2001-09-27 23:00:59 |
|
|