Lab 6: Using the Predictor Model Configuration Setup Wizard

  • Article

In this lab you will learn how to use the Predictor Model Configuration Setup Wizard. Before you use the wizard you must import data into the Data Warehouse by running Commerce Server Data Transformation Services (DTS) tasks. The DTS tasks modify the Data Warehouse schema and prepare your Web site for the Predictor Model Configuration Setup wizard.

The following table lists the DTS tasks corresponding to the model configuration:

Model Configuration DTS Tasks
Transaction Transactions Import
Demographics Profile Data Import
Transaction and Demographics Transactions Import and Profile Data Import
Product Browsing Web server log import
Ad Clicks Web server log import and Campaign Data Import

Ee811099.note(en-US,CS.20).gifNote

  • These tasks were already performed when you imported sample data in preparation for the tutorial. The following redundant steps are for educational purposes to explain site requirements for building model configurations except the Web server log import (Commerce Server) task in Step 3.

This lab contains the following steps:

  • Step 1: Run DTS tasks for the Transaction Model Configuration
  • Step 2: Run DTS tasks for the Demographics Model Configuration
  • Step 3: Run DTS tasks for the Product Browsing Model Configuration
  • Step 4: Run DTS tasks for the Ad Clicks Model Configuration
  • Step 5: Create a workflow for data import
  • Step 6: Run the Predictor Model Configuration Setup wizard

Step 1: Run DTS tasks for the Transaction Model Configuration

  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

  2. In the SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand your SQL server, right-click Data Transformation Services, and then click New Package.

  3. On the Task menu, click Transaction data import (Commerce Server).

  4. In the Transaction Import Properties dialog box, do the following:

    Use this To do this
    Description Type Transactions.
    Operation level Select Site level from the drop-down list.
    Site name Select PredictorDemo from the drop-down list.
    Incremental Do not select this option.
    Full Select this option to import all transaction data.

  5. In the Retry Properties section, do the following:

    Use this To do this
    Number of retry attempts Accept the default number of retry attempts of 10 times.
    Seconds between retries Accept the default time interval of 30 seconds.

  6. In the Import property section, accept the default value of 25 minutes for the Query interval.

  7. Click OK.

    Ee811099.note(en-US,CS.20).gifNote

    • You are not required to run the Transaction DTS task before you run the Predictor Configuration wizard. However, you must run this DTS task before you build analysis models based upon the Transactions model configuration.

Step 2: Run DTS tasks for the Demographics Model Configuration

  1. On the Task menu, click Profile data import (Commerce Server).
  2. In the Profile Import Properties dialog box, do the following:
    Use this To do this
    Description Type Demographics.
    Operation level Select Site level from the drop-down list.
    Site name Select PredictorDemo from the drop-down list.
    Import start date Accept the default date.
    Query interval (mins.) Accept the default value.
    Incremental Do not select this option
    Full Select this option to import all user data.
  3. In the Retry Properties section, do the following:
    Use this To do this
    Number of retry attempts Accept the default number of retry attempts of 10 times.
    Seconds between retries Accept the default time interval of 30 seconds.
  4. Click OK.

Ee811099.note(en-US,CS.20).gif Note

  • You must run the User Profile Import Task DTS task in order for the Predictor Model Configuration Setup wizard to work correctly. This DTS task expands the Data Warehouse schema to include all the user profile properties that were predefined in the Predictor Demo site. For more information about adding new properties to the user profile, see Adding Properties to a Profile Definition.

Step 3: Run DTS tasks for the Product Browsing Model Configuration

  1. On the Task menu, click Web server log import (Commerce Server).

  2. In the Import Web Server Logs dialog box, do the following:

    Use this To do this
    Description Type Product Browsing.
    Operation level Select Site level from the drop-down list.
    Site Select PredictorDemo from the drop-down list
    Number of retry attempts Accept the default number of retry attempts of 10 times.
    Seconds between retries Accept the default time interval of 30 seconds.

  3. In the Log File Locations tab, do the following:

    Use this To do this
    Log file locations Select the PredictorDemo from the application list.
    Log file path Type <drive>:\\Program Files\Microsoft Commerce Server 2002\Predictor Tutorial\.
    Log Files button Click to open the Web Server Log Files dialog box. Make sure that the ex010917.log file is selected and then click OK to return to the Import Web Server Logs dialog box.

  4. On the Import Criteria tab, select the All logs since last import option from the list.

  5. Click Advanced.

  6. In the Advanced Web Log Import Properties dialog box, click the Query Strings tab, and then click Add.

  7. In the Query Strings dialog box do the following:

    Use this To do this
    Name Type product_id.
    All applications within a site Do not select this option.
    Selected applications within a site Select to specify which applications within the site to import the query string for.
    PredictorDemo Make sure this application is selected.
    PredictorDemoBizDesk (PredictorDem...) Clear this application, if it is selected.
    Select data type Select String as the data type.
    Multivalue data type Do not select this option.

  8. Click OK, and then click Add.

  9. In the Query Strings dialog box do the following:

    Use this To do this
    Name Type PageGroupId.
    All applications within a site Do not select this option.
    Selected applications within a site Select to specify which applications within the site to import the query string for.
    PredictorDemo Make sure this application is selected.
    PredictorDemoBizDesk (PredictorDem...) Clear this application, if it is selected.
    Select data type Select String as the data type.
    Multivalue data type Do not select this option.

  10. Click OK.

    Ee811099.note(en-US,CS.20).gifNotes

    • The Data Warehouse schema is updated with the necessary changes for the Product Browsing model configuration.
    • Product_id and PageGroupId are standard event-log keywords for product IDs and page-group IDs used by most sites. If your site uses different keywords, you must modify the previous steps appropriately.

  11. In the Import Web Server Logs dialog box, click OK.

    Ee811099.note(en-US,CS.20).gifNote

    • You run the Configuration Synchronization task to propagate the changes to the Commerce Admin database.

  12. On the Task menu, click Configuration synchronization (Commerce Server).

  13. In the Synchronize DW Properties dialog box, do the following:

    Use this To do this
    Description Accept the default value.
    Operation level Select Site level from the drop-down list to synchronize a site with the Data Warehouse.
    Site name Select PredictorDemo from the drop-down list.

  14. In the Retry Properties section, do the following:

    Use this To do this
    Number of retry attempts Accept the default number of retry attempts of 10 times.
    Seconds between retries Accept the default time interval of 30 seconds.

  15. Click OK.

Step 4: Run DTS tasks for the Ad Clicks Model Configuration

  1. On the Task menu, click Campaign data import (Commerce Server).
  2. In the Campaign Import Properties dialog box, do the following:
    Use this To do this
    Description Ad Clicks.
    Operation level Select Site level from the drop-down list.
    Site name Select PredictorDemo from the drop-down list.
  3. In the Retry Properties section, do the following:
    Use this To do this
    Number of retry attempts Accept the default number of retry attempts of 10 times.
    Seconds between retries Accept the default time interval of 30 seconds.
  4. Click OK.

Step 5: Create a workflow for data import

  1. In the Commerce Server Manager – [DTS Package: <New Package>] screen, select Configuration synchronization, hold down the CTRL key, and then select Demographics (Profile Data Import).

  2. On the Workflow menu, select On Success.

  3. Select Demographics (Profile Data Import), hold down the CTRL key, and then select Product Browsing (Web server log import).

  4. On the Workflow menu, select On Success.

  5. Select Demographics (Profile Data Import), hold down the Ctrl key, and then select Ad Clicks (Campaign data import).

  6. On the Workflow menu, select On Success.

  7. Select Demographics (Profile Data Import), hold down the Ctrl key, and then select Transactions.

  8. On the Workflow menu, select On Success.

  9. On the Package menu, select Auto Layout.

    DTS Package

  10. On the Package menu, select Execute. The Executing Package dialog box appears.

  11. In the Package Execution Results dialog box, click OK.

  12. In the Executing Package dialog box, click Done.

Step 6: Run the Predictor Model Configuration Setup wizard

  1. Click Start, point to Programs, point to Microsoft Commerce Server 2002, and then click Commerce Server Manager.

  2. Expand Commerce Server Manager, expand Global Resource, expand Predictor on <server name>, expand Predictor Service, right-click Model Configurations, and then select Add Model Configurations.

    The Predictor Model Configuration Setup Wizard Starts.

  3. Click Next.

  4. In the Configuration Selection page, do the following:

    Use this To do this
    Select the site to setup the model configuration Select the PredictorDemo site from the drop-down list.
    Select the model configurations you want to setup Make sure the following model configurations are selected:
    • Transactions Model Configuration.
    • Demographics Model Configuration.
    • Combined Transactions and Demographics Model Configuration
    • Product Browsing Model Configuration.
    • Ad Click Model Configuration.
    Use Defaults Do not click this button. Clicking this button causes the wizard to skip pages where default data is available.

  5. Click Next.

  6. In the Transaction Model Configuration page, do the following:

    Use this To do this
    Setup Transactions model configuration Make sure this option is selected.
    Table or View name Make sure PredictorView_TransactionsPredictorDemo is selected from the drop-down list.
    User ID Make sure UserID is selected from the drop-down list. This column contains the buyer user data.
    SKU Make sure SKU is selected from the drop-down list. This column contains stock-keeping unit (SKU) data.
    Quantity Select QTY from the drop-down list. This column contains the Quantity data.

    Ee811099.note(en-US,CS.20).gifNote

    • The Transactions model configuration requires you to define a view that contains a unique identifier for users on your site making a purchase, products purchased, and the quantity of each product purchased during a single transaction.

  7. Click Next.

  8. On the Demographics Model Configuration page, do the following:

    Use this To do this
    Setup Demographics model configuration Select this check box to set up a Demographics model configuration.
    Table or view name Select RegisteredUser from the drop-down list. This table contains the demographic data for sample users.
    User ID Select UserID from the drop-down list. This column contains the user data.

    If you use a different schema, this column must use the same property used for the Transactions model. Any users who appear in the Transactions configuration, but not in Demographics, are not included in the Combined models.
    Age Select Age from the drop-down list. This column contains the age of the user.
    Occupation Select Occupation from the drop-down list. This column contains the occupation of the user.
    Marital Status Clear this option.
    Gender Clear this option.
    Income Clear this option.
    Education Clear this option.
    Children Clear this option.
    Family Role Clear this option.
    Region Clear this option.

  9. Click Next.

  10. In the Product Browsing Model Configuration page, do the following:

    Use this To do this
    Setup Product Browsing model configuration Select this check box to setup product browsing model configuration.
    Table or view name Make sure PredictorView_ProductsPredictorDemo is selected from the drop-down list.
    User ID Make sure UserKey is selected from the drop-down list. This column contains the browsing user data.
    Page ID Make sure Page_ID is selected from the drop-down list. This column contains data about page identifiers a user has browsed.
    Page Head Count Make sure PageHeadCount is selected from the drop-down list. This column contains data about the number of times a user has viewed the page.
    Use Defaults Do not click this button.

    Ee811099.note(en-US,CS.20).gifNote

    • The Product Browsing model configuration requires you to define a view that contains a unique identifier for users on your site browsing product pages, product pages browsed, and the number of times the user has viewed the product page.
    • The Product Browsing model configuration requires you to define a view that contains a unique identifier for: users on your site browsing product pages, product pages browsed, and the number of times the user has viewed the product page.
    • If you have your product browsing data imported into tables other than the default schema (as referenced by PredictorView_AdsPredictorDemo), you must modify the table name to your own table or view.

  11. Click Next.

  12. In the Ad Clicks Model Configuration page, do the following:

    Use this To do this
    Setup Ad Click model configuration Select this check box to set up Ad Click model configuration.
    Transaction data Clear this option.
    Demographic data Clear this option.
    Product browsing data Select this check box to use Product browsing data for predicting ad clicks.
    Page groups browsing data Clear this option.
    Table or view name Make sure that PredictorView_AdsPredictorDemo is selected from the drop-down list.
    User ID Make sure that UserKey is selected from the drop-down list. This column contains the User ID data.
    Ad ID Make sure that Ad_ID is selected from the drop-down list. This column contains data about the ads that were shown or clicked.
    ClicksNum Make sure Click is selected from the drop-down list. This column contains data about the number of times the ad was clicked by the user. If an ad was shown, but not clicked, the value of ClicksNum should be 0.

    Ee811099.note(en-US,CS.20).gifNotes

    • The Ad Clicks model configuration uses the prior configurations as its input, and the ads data as output. The Ad Clicks model predicts whether someone will click on an ad based upon transactional data (items the user has bought), demographics properties, product browsing (the product pages the user had viewed), and page group browsing data.
    • Transactions and Demographics data is only recorded for registered users (using UserID), whereas Product Browsing and Page Group Browsing can be recorded for registered users (using UserID) or all users (using UserKey).
    • If either the Transactions or Demographics data sources are used, then only browsing data logged with UserID are used for building the model.
    • If you have lots of registered users on your site, then it is recommended that you use all data sources. Otherwise, you can just use Product Browsing and/or Page Group Browsing data sources.

  13. Click Finish to exit the Predictor Model Configuration Setup wizard. The model configurations you selected are created and will appear in Commerce Server Manager.

Copyright © 2005 Microsoft Corporation.
All rights reserved.