Create PAL data sets

This task describes how to create the following data sets: IIS W3C, Apache, RUM, Google Analytics, and Webtrends.

Note: This task is part of a higher-level task. For details, see Create a testing environment using PAL.

Creating Data Sets from IIS W3C

This task includes the following steps:

  1. Create log files

    1. Open the Internet Information Services (IIS) Manager window.
    2. Under Connections, select a Website (not a virtual directory).
    3. In the right pane, select Logging.
    4. In the Log File section, under Format, verify that W3C is selected.
    5. Click the Select Fields button and select the following fields: Date, Time, Client IP Address, Server Name, Server IP Address, Server Port, Method, URI Stem, URI Query, Protocol Status, Time Taken, Host, User Agent, Cookie, and Referer.
    6. Under Directory, set the directory location for storing the logs.

  2. Create the IIS data set file

    Open the PAL Data Set Creator wizard to create the IIS data set file. For user interface details, see PAL Data Set Creator wizard.

Back to top

Creating Apache Data Sets

This task includes the following steps:

  1. Configure the Apache log parameters

    1. To edit the Apache log configuration file, navigate to <apache_install_folder>\conf\httpd.conf.

    2. Under LogFormat, define you configuration.

      The section should contain the following parameters:

      • %t
      • %T or %D
      • %{Cookie}i or %{your_cookie_name}C

      Typical configuration example: %h %l %u %t %T \"%{Cookie}i\" \"%{Set-Cookie}o\" \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"

    3. To complete the configuration process, restart the Apache service.

  2. Create the Apache data set file

    Open the PAL Data Set Creator wizard to create the Apache data set file. For user interface details, see PAL Data Set Creator wizard.

Back to top

Creating RUM Data Sets

The RUM data export file is located in: <install dir>\conf\datapublisher\pc_integration.xml.

The data export file defines the default output folder (C:\RUM_Export\pc_integration) and the maximum default folder size (2 Gb) among other information.

For information about the RUM data export function, see the Real User Monitor Administration Guide.

This task includes the following steps:

  1. Copy the data export configuration file from <install dir>\conf\datapublisher\pc_integration.xml

    to <install dir>\conf\datapublisher\consumers\pc_integration.xml

  2. From the RUM web console, click Tools > Monitoring configuration information.

  3. Click Sync all configuration.

  4. Create the RUM data set file

    Open the PAL Data Set Creator wizard to create the RUM data set file. For user interface details, see PAL Data Set Creator wizard.

Back to top

Creating Data Sets from Google Analytics

This task includes the following steps:

  1. Create a new custom report

    1. From Google Analytics, click the Customization tab.
    2. Click the New Custom Report button.
    3. Add a title name.
    4. In the Type section, select Flat Table.
    5. In the Dimensions section, add Time > Hour of Day.
    6. In the Metric Groups section, add Users > Pageviews.
    7. In the Views section, select Web sites.
    8. Click Save.

  2. Export the report

    Open the report, and select Export > CSV.

  3. Create the Google Analytics data set file

    Open the PAL Data Set Creator wizard to create the Google Analytics data set file. For user interface details, see PAL Data Set Creator wizard.

Back to top

Creating Webtrends Data Sets

Open the PAL Data Set Creator wizard to create the Webtrends data set file. For user interface details, see PAL Data Set Creator wizard.

Back to top