Collecting Campaign Information in a Customer Intelligence Job

Overview

The customer intelligence template jobs enable you want to process the data contained in one or more clickstream logs in a single job while filling the marketing campaign information into all records for each job. The campaign information values that you need to capture are the Response Tracking Code (RTC) and the Subject ID (Sn) fields. The following actions support the acquisition of these values:
  • New columns have been added to contain campaign information.
  • Additional Clickstream Parse rules extract the values from the raw Web log.
  • Fill Column options copy the values for these new columns into all records for a session.
This template comes in two versions, one for page-tagged Web logs and another for standard Web logs. The page-tagging version of the template contains the Parse Tagged Data Items transformation in the Loop One: Recognize, Parse, Group Data stage of the job. This transformation is a renamed Clickstream Parse transformation. The topic describes the process that you use to run the standard Web log version of the template job.
You can collect campaign information by using the standard Web logs customer intelligence template job. If you have not done so already, you should run a copy of the setup job for the standard Web logs customer intelligence template job, which is named clk_0010_weblog_ci_setup. When you actually process the data, you should run a copy of the customer intelligence template job, which is named clk_0200_weblog_ci_load_weblog_detail. By running a copy, you protect the original template. For information, see Copying the Folder Structure of a Clickstream Job.