Clickstream Templates

The SAS Data Surveyor for Clickstream Data adds metadata for jobs, libraries, and tables to the tree view in SAS Data Integration Studio. To see all of these objects together, display the Folders tree, expand the Products folder and then the SAS Data Surveyor for Clickstream Data folder, as shown in the following display.
Clickstream Templates in the Products Folder
Clickstream Templates in the Products Folder
In addition to the Folders tree, clickstream jobs, libraries, and tables are also displayed under appropriate folders in the Inventory tree (jobs in the Job folder, and so on). The following table describes the templates that are installed with the SAS Data Surveyor for Clickstream Data.
Clickstream Templates
Name
Description
Basic (Multiple) Web Log Template
Enables you to process multiple clickstream logs from multiple servers.
Includes a setup job (clk_0010_setup_basic_multi_job), the job template (clk_0020_load_multi_dds), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Processing Multiple Clickstreams.
Customer Integration Template
Enables you to capture information that allows for customer web based activity to be associated with the marketing campaign that originated the activity.
Includes a setup job (clk_0010_setup_basic_ci_job), the job template (clk_0020_load_ci_dds), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Processing Campaign Information.
Basic (Single) Web Log Template
Enables you to process a single clickstream log.
Includes a setup job (clk_0010_setup_basic), the job template (clk_0020_create_output_detail), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Basic Processing of a Clickstream Log.
Page Tagging Template
Enables you to process a clickstream log that includes page tagging data.
Includes a setup job (clk_0010_setup_page_tagging), the job template (clk_0020_page_tagging_detail), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Processing Tagged Pages.
Subsite Template
Enables you to process a Web log that contains clickstream data for one or more subsites. The outputs include refined clickstream data for the entire site and for each subsite.
Includes a setup job (clk_0010_setup_sub_site), the job template (clk_0020_create_sub_site_tables), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Processing Subsite Information.
Template Column Metadata
Provides a repository of column definitions that are useful in clickstream jobs.
Includes the metadata for a number of tables and columns that are used in clickstream jobs.
In general, setup jobs generate the folder structure on the file system to hold the SAS logs and any generated data files. After you run the setup jobs, you should be able to run the template jobs to verify that all servers and other components are working properly.