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. 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
uses built-in rules to determine values for Browser Type, Browser Version, and Platform

The Clickstream Parse transformation is shown in the following display.

Clickstream Parse Transformation