clickstreamdata_
This table stores additional information about a click through/stream event.
The standard information
is recorded in the clicktracking_ table, with the additional information provided in this table. Generally
only one of these fields is present for each clickstream event, as supported by that technology.
Primary key: ClickID_
Field Name | Description | Version Added |
|---|---|---|
ClickID_ | The ClickID_ value from the clicktracking_ table. (int, NOT NULL) | |
| UnitPrice_ | The price recorded for this purchase. (numeric (2,), NULL) | |
| Quantity_ | The number of items purchased. (int, NULL) | |
| Points_ | The points that this item represents. (int, NULL) | |
| Stage_ | The stage that this item represents. (int, NULL) | |
| ProductSku_ | The product SKU for this purchase. (varchar(25), NULL) | |
| OrderID_ | The Order ID of this purchase. (varchar(25), NULL) | |
| CustomerID_ | The customer ID, from the customer's accounting system, for this transaction. (varchar(25), NULL) |