This example specifies one distribution model for regular events and one distribution model for each type of optional event.
Input
attribution_sample_table
user_id |
event |
time_stamp |
1 |
impression |
2001-09-27 23:00:01 |
1 |
impression |
2001-09-27 23:00:03 |
1 |
impression |
2001-09-27 23:00:05 |
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:20 |
1 |
Direct |
2001-09-27 23:00:21 |
1 |
Referral |
2001-09-27 23:00:22 |
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:36 |
2 |
impression |
2001-09-27 23:00:38 |
2 |
impression |
2001-09-27 23:00:43 |
2 |
impression |
2001-09-27 23:00:47 |
2 |
OrganicSearch |
2001-09-27 23:00:49 |
2 |
impression |
2001-09-27 23:00:51 |
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')
WindowSize ('rows:10&seconds:20')
Model1 ('EVENT_REGULAR', 'Email:0.19:LAST_CLICK:NA',
'impression:0.81:UNIFORM:NA')
Model2 ('EVENT_OPTIONAL', 'OrganicSearch:0.5:UNIFORM:NA',
'Direct:0.3:UNIFORM:NA', 'Referral:0.2:UNIFORM:NA')
) AS dt;
Output
user_id |
event |
time_stamp |
attribution |
time_to_conversion |
1 |
impression |
2001-09-27 23:00:01 |
0.09 |
-19 |
1 |
impression |
2001-09-27 23:00:03 |
0.09 |
-17 |
1 |
impression |
2001-09-27 23:00:05 |
0.09 |
-15 |
1 |
impression |
2001-09-27 23:00:07 |
0.09 |
-13 |
1 |
impression |
2001-09-27 23:00:09 |
0.09 |
-11 |
1 |
impression |
2001-09-27 23:00:11 |
0.09 |
-9 |
1 |
impression |
2001-09-27 23:00:13 |
0.09 |
-7 |
1 |
Email |
2001-09-27 23:00:15 |
0.19 |
-5 |
1 |
impression |
2001-09-27 23:00:17 |
0.09 |
-3 |
1 |
impression |
2001-09-27 23:00:19 |
0.09 |
-1 |
1 |
SocialNetwork |
2001-09-27 23:00:20 |
|
|
1 |
Direct |
2001-09-27 23:00:21 |
0.6 |
-2 |
1 |
Referral |
2001-09-27 23:00:22 |
0.4 |
-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 |
-16 |
2 |
impression |
2001-09-27 23:00:47 |
0.2 |
-12 |
2 |
impression |
2001-09-27 23:00:51 |
0.2 |
-8 |
2 |
impression |
2001-09-27 23:00:53 |
0.2 |
-6 |
2 |
impression |
2001-09-27 23:00:55 |
0.2 |
-4 |
2 |
SocialNetwork |
2001-09-27 23:00:59 |
|
|