The input table is web clickstream data recorded as a user navigates through a web site. Events—view, click, and so on—are recorded with a timestamp.
userid | adid | productid | event | clicktime |
---|---|---|---|---|
1039 | 2 | 1001 | view | 2009-04-21 13:17:59 |
1039 | 2 | 1001 | view | 2009-04-21 13:17:59 |
1039 | 2 | 1001 | view | 2009-04-21 13:17:59 |
1039 | 3 | 1001 | view | 2009-05-23 13:17:59 |
1039 | 3 | 1001 | view | 2009-05-23 13:17:59 |
1039 | 3 | 1001 | view | 2009-05-23 13:17:59 |
1039 | 4 | 1001 | view | 2009-07-16 11:17:59 |
1039 | 4 | 1001 | view | 2009-07-16 11:17:59 |
1039 | 4 | 1001 | view | 2009-07-16 11:17:59 |
1039 | 4 | 1001 | click | 2009-07-16 11:18:16 |
1039 | 4 | 1001 | click | 2009-07-16 11:18:16 |
1039 | 4 | 1001 | click | 2009-07-16 11:18:16 |
1039 | 4 | 1001 | landing_page | 2009-07-16 11:18:18 |
1039 | 4 | 1001 | landing_page | 2009-07-16 11:18:18 |
1039 | 4 | 1001 | landing_page | 2009-07-16 11:18:18 |
... | ... | ... | ... | ... |