A
Column Descriptions

This appendix provides definitions for all columns available in the worksheets that comprise Clickstream Analytics.

Age Group - The name or number associated with the age group to which a user belongs. This name or number, entered by the user when they register, is imported into Clickstream Intelligence from the user database.

Agent Full String - An alphanumeric string that contains the name of the agent with all major and minor release numbers. The user agent string from the clickstream log may also include the computer platform and architecture.

All Browsers - The aggregate of all values in the Agent dimension.

All Connecting Machines - The aggregate of all values in the Connecting Machine dimension.

All Dates - The aggregate of all values in the Date dimension.

All Pages - The aggregate of all values in the Page dimension.

All Referrers - The aggregate of all values in the Referrer dimension.

All Searches -The aggregate of all values in the Search dimension.

All Servers - The aggregate of all values in the Server dimension.

All Session Types - The aggregate of all values in the Session Type dimension.

All Sites - The aggregate of all values in the Site dimension.

All Statuses - The aggregate of all values in the Server Status dimension.

All Times - The aggregate of all values in the Time of Day dimension.

All Users - The aggregate of all values in the User dimension.

All Visitors - The aggregate of all values in the Visitor dimension.

Architecture - The server architecture.

Authentication Group - A group that distinguishes verified users that belong to one or more sites within Clickstream Intelligence.

Authentication Name - The unique login or user name that is used to identify registered users.

Average Time to Serve (Sec) - The average number of seconds needed to serve requests at your site.

Average Dwell Time (Min) - The average number of minutes spent at your site.

Average Time Spent (Min) - The number of minutes spent at the site (Total Dwell Time) plus the number of minutes needed to serve requests (Total Time to Serve).

Average Time Spent (Sec) - The number of seconds spent at the site (Total Dwell Time) plus the number of seconds needed to serve requests (Total Time to Serve).

Bytes Sent (GB) - The number of gigabytes sent from your servers to clients and other connecting machines.

Bytes Sent (KB) - The number of kilobytes sent from your servers to clients and other connecting machines.

Bytes Sent (MB) - The number of megabytes sent from your servers to clients and other connecting machines.

Cache Memory Size - The amount of first-level cache memory installed on the server.

Cache Size - The amount of first-level cache memory installed on the server.

Campaign - The name of the campaign that provided a referral to your site.

Campaign Description - The description of the campaign that provided a referral to your site.

Campaign Name - The name of the campaign that provided a referral to your site.

City - A user's city of residence.

Clickthroughs - The number of times a particular page was used to reach another destination in your site.

Client - The name of the browser software used to access your site, such as Netscape Navigator.

Client Errors - The code number that identifies the error made most frequently by site visitors.

Client Host Name - The DNS hostname or IP address of the client host computer.

Client Host Resolved Name - The user-friendly name that corresponds to the IP address of the client host machine. If one is unavailable, then the IP address of the client host machine is displayed.

Client Name - The name of the browser software used to access your site, such as Netscape Navigator.

Client Timeouts - The name of the client whose session ended due to a timeout error.

Client Type - The browser type that was used to access your site, such as a graphical, email, or text browser.

Client Type is Crawler - Indicates when a particular client type is a Web crawler (spider). ('Y' = Crawler, 'N' = Not a crawler).

Client Version Full Name - The full name and version number of the browser software used to access your site, such as Netscape Navigator 4.76.

Client Version Major Number - The major version number of the browser used to access your site. The major version number in Netscape 4.76, for example, is 4.

Client Version Name - The name of the client browser that accessed your site.

Client Version Number - The complete version number of the browser that accessed your site. For example, in Netscape 4.76, 4 and 76 are the major and minor version numbers, respectively.

Code - The numeric code that identifies a particular server message, such as 404 for the error "Page Not Found."

Company Name - The name of the company for which the user works.

Company Type - A user-defined description of the type of company for which the user works.

Country Code - The two-letter ISO code for a country, such as US for the United States.

Country Name - The name of the country from which a request originated.

CPU Count - The number of processors installed on the server.

CPU Speed - The clock speed of the processor(s) installed on the server.

CPU Type - The type of processor used by the computer that connected to your site.

CPU Vendor - The manufacturer of the processor(s) on the server, such as Intel.

Date - The full date, written in the format January 26, 1969.

Day - The full name of the day, such as Monday or Saturday.

Description - A description of the status code returned by the server, such as "Page Not Found" for code 404.

Description - A user-defined description of the site.

Directory Hits - The number of times a particular Web server directory was accessed.

Domain - The hostname and suffix that identify a particular domain, or group of computers, such as oracle.com.

Domain Name - The name of the internet site that provided a referral to your site.

Domain Name - The hostname and suffix that identify a particular domain, or group of computers, such as oracle.com.

Domain Type Name - The name of the domain type that provided a referral to your site.

Domain Type Name - The type of domain, such as .com, .org, or .gov.

Downloads - The number of times a resource (such as a file, graphic, or non-content item) was downloaded from the site.

Dwell Time per Page (Min) - The average number of minutes spent per page.

Email Address - The user's email address.

Error Count - The number of errors that occurred.

First Name - The user's first name.

First Page In Path - The first page in a particular navigational path.

First Visit Date - The date of the first visit to your site by a person who is either unknown, unidentified, or identified but unregistered.

Fiscal Month Name - The full name of the fiscal month. January, for example.

Fiscal Quarter Name - The name of this fiscal quarter.

Fiscal Year Number - The four-digit number associated with this fiscal year.

Fourth Page In Path - The fourth page in a particular path

Gender - The user's gender.

Home Phone - The user's home telephone number.

Hostname - The hostname of the server, such as www.oracle.com.

Hour - The hour number in 24-hour form, such as 18 in 18:00 (six o'clock).

Hour Range - The descriptive name for an hourly range, such as 10am-11am.

Identified Visitors - The percentage of identified visitors, equal to the number of identified visitors who accessed your site divided by the total number of people who accessed your site.

Industry - The name of the industry sector in which the user works, such as Automotive or Construction.

Internet Service Provider - The name of the Internet service provider used to access the site.

Invalid Requests - The number of requests made to the server that were not valid.

Job Role - A description of the user's job.

Last Name - The user's surname.

Listener Port - The port on which the HTTP server listens.

Listener Software - The name of the software application the server uses to listen for requests.

Main Memory Size - The amount of RAM installed on the host computer.

Marital Status - The user's marital status.

Memory Size - The amount of RAM installed on the host computer.

Middle Name - The user's middle name or initial, if one was provided.

Minute - The number of minutes that have passed since midnight.

Minute of Hour - The number of a particular minute in an hour.

Mobile Phone - The user's mobile or cell phone number.

Month - The full name of the calendar month.

New Users - The number of people who registered at your site for the first time.

New Users - The percentage of identified users, equal to the number of first-time registrants divided by the total number of people who accessed your site.

Operating System - The operating system installed on the server, such as UNIX or Linux.

Operating System Name - The name of the operating system that powered the browser that accessed your site.

Operating System Version - The version number of the operating system on which the server runs, such as 2.7 in Sun Solaris 2.7.

Page Description - A user-defined description of the page.

Page Query String - The portion of the page's URL that contains query parameters sent by the browser to the server. If no value appears in this column, it has been disabled by your system Administrator.

Page Stem - The portion of the URI that is not part of the query string and identifies the resource corresponding to this page. For example, in "http://www.oracle.com/clickstream/index.jsp?init=dms" the stem is "/clickstream/index.jsp".

Page Time to Serve (Sec) - The number of seconds required for the server to return user and visitor page requests.

Page Time To Serve (Min) - The number of minutes required for the server to return user and visitor page requests.

Page Title - The name of the page, if it has one.

Page Type - A user-defined description of the page type.

Page Views - The number of requests for any file classified as a page.

Pages per Session - The total number of pages requested by users and visitors, divided by the total number of sessions.

Percentage of Errors - The number of sessions in which an error occurred, divided by the total number of sessions.

Percentage of Page Views - The percentage of page requests that occurred in a particular time period.

Percentage of Sessions - The percentage of sessions that occurred.

Platform - The name of the software platform that powers the browser that accessed this site. For example, Windows, Macintosh, or UNIX.

Platform Name - The name of the software platform that powers the browser that accessed this site. For example, Windows, Macintosh, or UNIX.

Port - The number of the port, or logical channel, to which the HTTP server is connected.

Postal Code - The ZIP code from the user's postal address.

Primary Phone - The primary telephone number of the user, including extension if applicable.

Product - The name of the browser type used to access the site, such as Mozilla in Mozilla/4.0.

Product Version - The version number of the browser used to access this site, such as 4.0 in Mozilla/4.0.

Quarter - The symbol for the calendar quarter, such as Q1 or Q3.

Raid Level - The level of performance and fault tolerance for the primary device that stores your Web data.

Redirects - The number of times the site redirected a user, visitor, or electronic agent to another page within the site.

Referrers - The location of the external site and page that was viewed immediately before your site. Typically, a referring page provides a link to your site.

Referring Searches - The number of times a search engine referred a visitor to your site.

Referring Site DNS Alias - The full DNS alias for the IP address of the site that provided a referral to your site. For example, www.oracle.com.

Referring Site Name - The name of the site from which a user or visitor came immediately before accessing this site.

Referring URL Host and Port - The Host:Port string taken from the referrer URL in the clickstream log. For example, in "www.oracle.com:604," www.oracle.com is the host and 604 is the port.

Referring URL Results Page - Indicates when the URL that referred a visitor to your site is a search engines results page.

Referring URL Search Param - The search criteria entered into a search engine page that referred a visitor to this site.

Referring URL Stem - The search criteria, or query string, entered into a search engine that referred a visitor to this site.

Region - The name of the region in which a country is located, such as North America or South America.

Region Name - The name of the region in which a country is located, such as North America or South America.

Registration Date - The date on which a visitor registered to become an authenticated user of this site.

Registration Method - The method by which the user registered at your site. For example, email.

Resource Delivery Method - The method used to deliver a resource to the client, such as 'dynamic' for a CGI script.

Resource Description - A user-defined description of the resource, such as a description of what a script does in a CGI program.

Resource File Directory - The full directory path to an image, or file, or other type of site resource, minus the file name. For example, "http:\\dwsun02\documents\pdfs\.

Resource File Extension - The type of this resource, minus the period (.)that precedes it. If no extension exists, only the period (.) appears. For example, htm.

Resource File Name - The filename portion of the URL stem. For example, in "http://www.oracle.com/clickstream/index.html" the resource file name is "index.html".

Resource Mime Type - The Multipurpose Internet Mail Extension type of a resource, such as .GIF or .JPG for a picture file.

Resource Results Page - Indicates if the resource that enabled access to your site is a search engine results page.

Resource Search Param - The search expression entered into the search engine that was used to find your site.

Resource Stem - The portion of the URI that identifies a resource and immediately precedes the query string. For example, in "http://www.oracle.com/clickstream/index.jsp?init=dms" the stem is "/clickstream/index.jsp".

Resource Type Name - The type of file or other object served by the site.

Returning Users - The number of registered site users whose current visit is not their first visit.

Returning Users Ratio - The percentage of returning users, equal to the number of previously-registered users divided by the total number of people who visited your site during a specific time period.

Search Expression - The search parameters entered into a search engine that comprise the query string of a URL.

Searches - The search criteria entered into a search engine that comprise the query string of a URL.

Second - The number of seconds that have elapsed since midnight.

Second of Minute - The number of a second in a given minute, such as 57 in 12:02:57.

Second Page In Path - The second page in a particular path

Server Errors - The number of errors that occurred on the servers that store site content.

Server Farm Name - The name of the server farm, or group of servers, to which the server belongs.

Server Name - A user-friendly name assigned to the HTTP server.

Session Type Map - An internal code used to represent session types.

Sessions - A count of the number of sessions that occurred.

Site Description - A user-defined description of the site.

Site DNS Alias - The domain name of the site, such as www.oracle.com.

Site Name - A user-friendly name for the site, such as oracle.com instead of 148.87.9.44 (the IP address).

Site User Group - A default registered user group that is set by your site Administrator.

Site Visitor Group - A default visitor group that is set by your site Administrator.

Start Page - The initial page from which a path started.

State Code - The identifying code for a state within a country, such as CA for the state of California.

State Name - The name of the state or province in a country.

Status Code - The status code returned from the Web server.

Status Name - The name given to the status code returned by the server, such as "OK" for status code 200.

Status Type - The classification of a status code. For example, codes in the range of 400 to 499 are classified as client errors.

Storage Capacity - The capacity of a site's primary storage device.

Storage Raid Level - The level of fault tolerance for a site's primary storage device.

Storage Vendor - The manufacturer of the site's primary storage device.

Subscription Level - The level of service to which a user is subscribed.

Third Page In Path - The third page in a particular path

Time Spent per Page (Min) - The average number of minutes spent per Web site page.

Time Spent per Search (Min) - The number of minutes spent on a search.

Times Path Was Followed - The number of times a particular path was followed.

Time Spent per Session (Min) - The total number of minutes spent at the site, divided by the total number of sessions.

Total Dwell Time (Hrs) - The total number of hours spent at the site.

Total Time Spent (Hrs) - The total number of hours spent at the site, equal to the number of hours users and visitors spent at the site (Total Dwell Time) plus the number of hours needed to respond to service requests (Total Time to Serve).

Total Time Spent (Mins) - The total number of minutes spent at the site, equal to the number of minutes users and visitors spent at the site (Total Dwell Time) plus the number of minutes needed to respond to service requests (Total Time to Serve).

Unidentified Visitors - The percentage of unidentified visitors, calculated by dividing the number of visitors who accessed your site anonymously by the total number of people who visited your site.

User Defined Page Category 1 Code/Description - A user-defined description of a particular page category.

User Defined Page Category 2 Code/Description - A user-defined description of a particular page category.

User Defined Page Category 3 Code/Description - A user-defined description of a particular page category.

User Defined Page Category 4 Code/Description - A user-defined description of a particular page category.

User Defined Page Category 5 Code/Description - A user-defined description of a particular page category.

User Defined Page Category 6 Code/Description - A user-defined description of a particular page category.

User Defined Referrer Category 1 Code/Description - A user-defined description of a referrer or referrer category.

User Defined Referrer Category 2 Code/Description - A user-defined description of a referrer or referrer category.

User Defined Referrer Category 3 Code/Description - A user-defined description of a referrer or referrer category.

User Type - The type of user that registered on your site, if user types were defined by your System Administrator.

Users - A unique count of users

User Name - The full user name (if defined); otherwise, the authentication name in the clickstream log file.

Virtual Directory - The first directory contained in the host directory. In a URL, this is the term that immediately follows the top-level domain.

Visitor - The identifying string for a visitor.

Visitor Group - The visitor group to which a unique visitor belongs.

Visitor Type - One of three possible values associated with a particular visitor: Unknown, Identified, or Unidentified.

Visitor Type Name - One of three possible values associated with the name of a visitor type: Unknown, Identified, or Unidentified.

Website URL - The Internet address for a user's homepage.

Week - The full week name, such as May 01-May 07.

Whole Name - The user's full name or pseudonym.

Work Phone - The work telephone number of the user, including extension if available.

Year - The four-digit number of the calendar year.