Choosing a Starting Tutorial or Template Job

Overview

The tutorials and templates covered in the following table are available for your jobs:
Clickstream Templates
Name
Description
SAS Page Tag Log Tutorial (Tutorialthen selectGetting Startedthen selectSAS Page Tag Log)
Enables you to process a single clickstream log that includes SAS page tagging data.
Includes a setup job (clk_0010_tutorial_sastag_setup), the job template (clk_0020_tutorial_sastag_load_weblog_detail), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Running the SAS Page-Tag Tutorial Job SAS Page Tagging” on page 57.
Standard Web Log Tutorial (Tutorialthen selectGetting Startedthen selectStandard Web Log)
Enables you to process a single clickstream log as a tutorial when working with clickstream data.
Includes a setup job (clk_0010_tutorial_weblog_setup), the job template (clk_0020_tutorial_weblog_load_weblog_detail), and metadata objects for sample data under the Data Sources folder. For more information about this template, see About the Standard Web Log Tutorial Job .
Template Column Metadata (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. For detailed information about these tables, see Clickstream Standard Columns Reference.
SAS Page-Tagging Basic Template (Template Jobsthen selectSAS Page Tag Logsthen selectBasic)
Enables you to process clickstream logs that include page tagging data.
Includes a setup job (clk_0010_sastag_basic_setup), the job template (clk_0020_sastag_basic_load_weblog_detail), and metadata objects for sample data under the Data Sources folder.
SAS Page-Tagging Customer Intelligence Template (Template Jobsthen selectSAS Page Tag Logsthen selectCustomer Intelligence)
Enables you to process tagged Web logs that include 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__sastag_ci_setup), the job template (clk_0020_sastag_ci_load_weblog_detail), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Processing Campaign Data.
Standard Web Logs Basic Template (Template Jobsthen selectStandard Web Logsthen selectBasic)
Enables you to process clickstream logs that include data from standard Web logs from servers.
Includes a setup job (clk_0010_weblog_basic_setup), the job template (clk_0020_weblog_basic_load_weblog_detail), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Using Template Jobs.
Standard Web Logs Customer Intelligence Template (Template Jobsthen selectStandard Web Logsthen selectCustomer Intelligence)
Enables you to process 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__weblog_ci_setup), the job template (clk_0020_weblog_ci_load_weblog_detail), and metadata objects for sample data under the Data Sources folder. For more information about this template, see Processing Campaign Data.
Legacy Sub Site Template (Template Jobsthen selectStandard Web Logsthen selectLegacy Sub Site)
Enables you to process a single standard 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_weblog_sub_site_setup), the job template (clk_0020_weblog_sub_site_load_tables), and metadata objects for sample data under the Data Sources folder.
Note: This template is not available by default and is being deprecated. You must import it if you have users who have used it in a prior release and still need the functionality. This template will be omitted from future releases..
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 can run the template jobs to verify that the template job is working properly.
Several tutorial and template jobs are provided with the SAS Data Surveyor for Clickstream Data. These jobs are provided as the starting points for the most common ETL tasks. Choosing the correct template job from the beginning is crucial to ensuring the proper final output. These template jobs are divided into two classes. The first class is designed for processing standard Web logs and the second for processing SAS page tag logs.

Standard Web Logs

You can find the template jobs that are designed for processing standard Web logs in the following location in SAS Data Integration Studio: Foldersthen selectProductsthen selectSAS Data Surveyor for Clickstream Datathen select2.2then selectTemplate Jobsthen selectStandard Web Logs.
The templates and tutorials are shown in the following display:
Standard Web Logs in the Products Folder
Standard Web Logs in the Products Folder
When you expand the Standard Web Logs folder, you see the following types of Web log templates:
Basic
Designed for processing one or more standard Web logs from one or more standard Web servers. See Using Template Jobs for detailed information about this job.
Customer Intelligence
Designed to integrate data generated from customer campaigns when using the SAS Digital Marketing solution with standard Web logs. See Processing Campaign Data for detailed information about this job.

SAS Page Tag Logs

The template jobs that are designed for processing SAS page tag logs are located at Foldersthen selectProductsthen selectSAS Data Surveyor for Clickstream Datathen select2.2then selectTemplate Jobsthen selectPage Tag Logs.
The templates and tutorials are shown in the following display:
SAS Page Tag Logs in the Products Folder
SAS Page Tag Logs in the Products Folder
When you expand the Page Tag Logs folder, you see the following types of Web log templates:
Basic
Designed for processing one or more SAS page tag logs from one or more clickstream collection servers. See Running the SAS Page-Tag Tutorial Job for detailed information about this job.
Customer Intelligence
This template is designed to integrate data generated from customer campaigns when using the SAS Real-time Decision Manager and the SAS RTDM integration page tag module. If SAS page tags are used with the SAS Digital Marketing solution, then this job also supports integration of data generated from those campaigns. See Integrating SAS Real-Time Decision Manager.

Column Metadata

The Column Metadata folder does not contain template jobs. Instead, it contains table metadata with columns that are commonly used within the template jobs. The columns in these tables are useful when you work with copies of the template jobs because their metadata can be easily imported into jobs during development. The use of this column metadata enables you to avoid keying in commonly used column attributes. You can find this column metadata at the following location: Foldersthen selectProductsthen selectSAS Data Surveyor for Clickstream Datathen select2.2then selectTemplate Jobsthen selectColumn Metadata.
The column metadata folders are shown in the following display:
Column Metadata in the Products Folder
Column Metadata in the Products Folder
Copyright © SAS Institute Inc. All rights reserved.