The input data is a simulated clickstream.
Input Table Schema
Column | Data Type | Description |
---|---|---|
ind | INTEGER | Product ID. |
ts | INTEGER | Timestamp. |
int_type | VARCHAR | Event type. Impact events:
Conversion events:
Irrelevant event, which is coded as XXX. |
Input Table
This query returns the following table:
SELECT * FROM attrib ORDER BY ind, ts;
ind | ts | int_type |
---|---|---|
0 | 0 | ACTVD |
0 | 1 | XXX |
0 | 2 | CLKNI |
0 | 3 | XXX |
0 | 4 | REACT |
0 | 5 | APEST |
0 | 6 | APESU |
0 | 7 | ACTVD |
0 | 8 | APEST |
0 | 9 | XXX |
0 | 10 | CLKNI |
0 | 11 | APEAP |
0 | 12 | XXX |
0 | 13 | APESU |
0 | 14 | EMLOP |
0 | 15 | XXX |
0 | 16 | ACTVD |
... | ... | ... |