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 |
| ... | ... | ... |