About the Clickstream Parse Transformation

The Clickstream Parse transformation usually reads the output table from the Clickstream Log transformation. However, the Clickstream Parse transformation can read from any input table containing clickstream data that can be mapped to standard clickstream parse input columns. Then, it interprets this incoming data and creates a common set of output columns, independent of the incoming Web log type.

The Clickstream Parse transformation performs the following functions:

associates input columns with Clickstream Parse Input Columns that have specific roles during processing
filters unwanted data records from the target table, according to both default and user-defined rules.
enables the definition of one or more cookie, query string, or referrer parameters to be parsed and stored as new data items in the target table.
if possible, uniquely identifies the visitor who is associated with each data record and adds the visitor ID as a new data item in the target table.
creates an output table used as the input to the Clickstream Sessionize transformation.
provides several built-in rules for processing incoming data, as well as several sample rules.
stores the value from an incoming cookie, query, or referrer parameter in a user column. For information, see Extracting Data from Clickstream Parameters.

The Clickstream Parse transformation is shown in the following display.

Clickstream Parse Transformation