Setting Up Model Configurations

  • Article

You use the Predictor Model Configurations Setup Wizard to set up the model configurations provided with Commerce Server. Before you run the Wizard you must import data into your Data Warehouse, and determine where data is stored for the following items:

Transactions Profiles Web log file Campaigns
User ID
SKU
Quantity		 User ID
Age
Occupation
Marital Status
Gender
Income
Education
Children
Family Role
Region		 User ID
Page ID
Page Head Count		 User ID
Ad ID
ClicksNum

For information about importing data in to the Data Warehouse and finding where your data is, see Extract, Transform, and Load Processes for DTS Tasks.

To set up model configurations

  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 Resources, expand Predictor on <server name>, expand Predictor Service, right-click Model Configurations, and then click New Model Configurations.

  3. In the Predictor Model Configurations Setup Wizard, Welcome page, click Next.

  4. In the Configuration Selection Page, from the site drop-down box, select the site for which you want to set up model configurations.

  5. Select the model configurations you want to set up.

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

    • You can choose to select the Commerce Server default schema for all of the properties used in the model configurations by clicking Use Defaults. If you click Use Defaults, and the default tables and columns are properly configured, you will continue to the Completion dialog box when you click Next.

  6. To continue, click Next.

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

    • If you do not select a model configuration on the Configuration Selection dialog box, it will not be created.

  7. In the Transactions Model Configuration dialog box, do the following:

    Use this To do this
    Setup Transactions model configuration Select this check box to set up transactions model configuration.
    Table or View name From the drop-down list, select the name of the table or view transactional data from your Web site.
    User ID From the drop-down list, select the name of the column in the selected table that contains the buyer user data.
    SKU From the drop-down list, select the name of the column in the selected table that contains stock-keeping unit (SKU) data.
    Quantity From the drop-down list, select the name of the column in the selected table containing the Quantity data.

  8. Click Next.

  9. On the Demographics Model Configuration dialog box, do the following:

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

    • At least one property must be used to create the Demographics model configuration. You can uncheck properties that you do not want to use in the model configuration.
    Use this To do this
    Table or view name From the drop-down list, select the name of the table or view containing the demographic data of your users.
    User ID From the drop-down list, select the name of the column in the selected table that contains the user data.
    Age From the drop-down list, select the name of the column in the database containing the age of the user.
    Marital Status From the drop-down list, select the name of the column in the database containing the Marital Status of the user.
    Gender From the drop-down list, select the name of the column in the database containing the Gender of the user.
    Income From the drop-down list, select the name of the column in the database containing the Income of the user.
    Education From the drop-down list, select the name of the column in the database containing the Education level of the user.
    Children From the drop-down list, select the name of the column in the database containing the number of Children of the user.
    Family Role From the drop-down list, select the name of the column in the database containing the Family Role of the user.
    Region From the drop-down list, select the name of the column in the database containing the country/region of the user.
    Use Defaults Click to set the mapping for all properties used by this model configuration to the Commerce Server default schema. The default commerce server schema gathers the data from UriQuery, Visits and Request tables, which are populated by the Web Log Import DTS task.

  10. Click Next.

  11. In the Product Browsing Model Configuration dialog box, do the following:

    Use this To do this
    User ID From the drop-down list, select the name of the column in the selected table that contains the browsing user data.
    Page ID From the drop-down list, select the name of the column in the selected table containing data about Web page identifiers a user has browsed.
    Page Head Count From the drop-down list, select the name of the column in the selected table containing data about the number of times a user has viewed the Web page.
    Use Defaults Click to set the mapping for all properties used by this model configuration to the Commerce Server default schema. The default commerce server schema gathers the data from UriQuery, Visits and Request tables, which are populated by the Web Log Import DTS task.

  12. Click Next.

  13. In the Ad Click Model Configuration dialog box, do the following:

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

    • The Ad Click model configuration depends on the previously set model configurations. For example, if you select Transaction data, the source data will be collected from the Transaction model configuration. In order for the model to be properly built, the values of the user id columns should match in all of the selected sources. If your browsing data is gathered from logged users but your demographics data is gathered from registered users, then using both as data sources will result in a corrupted model.
    Use this To do this
    Transaction data Select this check box to use transaction data for predicting ad clicks. You must select at least one data source for predicting ad clicks.
    Demographic data Select this check box to use demographic data of registered users for predicting ad clicks. You must select at least one data source for predicting ad clicks. If you select this option, the ad click model configuration will use transaction and product browsing data for registered users only.
    Product browsing data Select this check box to use Product browsing data for predicting ad clicks. You must select at least one data source for predicting ad clicks.
    Table or view name From the drop-down list, select the name of the table or view containing the data about ads users clicked.
    User ID From the drop-down list, select the name of the column in the selected table containing the User ID data.
    Ad ID From the drop-down list, select the name of the column in the selected table that contains data about which ads were shown or clicked.
    ClicksNum From the drop-down list, select the name of the column in the selected table that 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.

  14. Click Next.

  15. On the Completing the Model Configuration Setup Wizard page, click Finish.

The selected model configurations are set up for your site and added to the Predictor resource. You can use the model configurations to build prediction and segment models.

See Also

Building a New Analysis Model

Deploying Predictor

Securing a Predictor Deployment

Copyright © 2005 Microsoft Corporation.
All rights reserved.