Multiple-Input Attribution Example Input Table attribution_sample_table1
| user_id |
event |
time_stamp |
| 1 |
impression |
2001-09-27 23:00:01 |
| 1 |
impression |
2001-09-27 23:00:05 |
| 1 |
Email |
2001-09-27 23:00:15 |
| 2 |
impression |
2001-09-27 23:00:31 |
| 2 |
impression |
2001-09-27 23:00:51 |
Multiple-Input Attribution Example Input Table attribution_sample_table2
| user_id |
event |
time_stamp |
| 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 |
Multiple-Input Attribution Example Conversion Event Table conversion_event_table
| conversion_events |
| PaidSearch |
| SocialNetwork |
Multiple-Input Attribution Example Excluding Event Table excluding_event_table
| excluding_events |
| Email |
Multiple-Input Attribution Example Dimension Table optional_event_table
| optional_events |
| Direct |
| OrganicSearch |
| Referral |
The following two model tables apply the distribution models by rows and by seconds, respectively.
Multiple-Input Attribution Example Model Table model1_table
| id |
model |
| 0 |
SEGMENT_ROWS |
| 1 |
3:0.5:EXPONENTIAL:0.5,SECOND |
| 2 |
4:0.3:WEIGHTED:0.4,0.3,0.2,0.1 |
| 3 |
3:0.2:FIRST_CLICK:NA |
Multiple-Input Attribution Example Model Table model2_table
| id |
model |
| 0 |
SEGMENT_SECONDS |
| 1 |
6:0.5:UNIFORM:NA |
| 2 |
8:0.3:LAST_CLICK:NA |
| 3 |
6:0.2:FIRST_CLICK:NA |