Analyzing Web Traffic Clickstream Intelligence

Module Objectives

Introduction

In this Oracle9i by Example course, you learn to recognize and use Oracle9iAS Clickstream Intelligence reports to perform Web site analysis. You glean necessary skills using this Web-based, e-Business Intelligence solution to improve Web site content and effectiveness.

Prerequisites

Before starting this module, you must:

	Complete the Preinstallation Tasks module
	Complete the Install the Oracle9i Database module
	Complete the Administering a Web Site module, Introduction to Oracle9iAS Clickstream Intelligence
	Complete the Install the Oracle9i Application Server module including either the Business Intelligence or Unified Messaging component
	Understand data warehouse development methodology
	Be familiar with web server technology
	Have a technical understanding of information storage and retrieval

Reference Material

The following is a list of useful reference material if you want additional information about the topics in this module:

	Documentation: Oracle9iAS Clickstream Intelligence Administration Guide
	eClass: D12847GC10 - Oracle9iAS Clickstream Intelligence Administration
	eClass: D10823GC40 - Oracle9iAS Discoverer Plus for End Users
	eClass: D13306GC10 - Oracle9iAS Discoverer Viewer for End Users
	eStudy: Oracle9iAS Clickstream Intelligence for End Users

Scenario

You are a Marketing Director for DrugDepo's corporate headquarters in NYC. Your department is responsible for running effective sales and marketing efforts. In order to achieve this goal, you need to gather user statistics and make sure that the Web site is worth the expense. Some of the challenges that you face on a regular basis are:

	Gather user statistics which will aid in selecting the best Web sites for banner advertisement
	Evaluate site content to see if it is meeting users' needs by stocking products and accessories in demand
	Select and evaluate site content to continuously improve the effectiveness of the online store

Overall Objectives

	Identify and describe Web site, Web traffic, Oracle9iAS Clickstream Intelligence, and Internet advertising terminology
	Describe the analysis capabilities of Oracle9iAS Clickstream Intelligence
	Connect to Oracle9iAS Clickstream Intelligence Analytics
	View Clickstream Intelligence reports
	Navigate between Clickstream Intelligence workbooks and worksheets
	Describe and use Oracle9iAS Clickstream Intelligence reports to perform Web site analysis and to improve Web site content
	Drill and pivot in Clickstream Intelligence reports

Introduction to Oracle9iAS Clickstream Intelligence Analytics

Purpose

This module introduces you to Oracle9iAS Clickstream Intelligence Analytics and provides you with an understanding of Web Traffic Analysis.

Module Objectives

After completing this module, you will be able to:

	Describe the analysis capabilities of Oracle9iAS Clickstream Intelligence
	Understand Web traffic concepts
	Explain Web traffic analysis through Oracle9iAS Clickstream Intelligence

What is Clickstream Analysis?

The term clickstream refers to a collection of users' interactions with a Web site, which are recorded in a Web server log. Clickstream analysis processes this Web log information into a form that the owner of the Web site can analyze and use to improve their site.

There are numerous, valuable pieces of information, which you can garner from your Web site. You can find out where the user came from, what the user is looking for, which route the user took through the Web site and when, where, and to which place the user went when the user left your site. Other characteristics can be discerned as well. Additionally, you can tell how well your Web site is performing technically and at the individual content level. There is a tremendous amount of information that you can use to guide you when you are improving your online business. Over the long term, clickstream data must be integrated with other data sources such as order fulfillment, customer support, and purchasing systems.

To better understand how clickstream analysis can enhance your online business, let's take a look at a visitor's experience to a Web site. Three scenarios are presented for your edification.

	Scenario 1 A visitor arrives at the DrugDepo Web site and finds the desired item. This experience results in a purchase.
	Scenario 2 A visitor performs a keyword search for "beauty care". DrugDepo is the first link on the list. The visitor selects the DrugDepo Web site and performs a product search using the keyword "cosmetics". A "Page Not Found" error ensues. The visitor leaves the DrugDepo Web site immediately.
	Scenario 3 A visitor arrives at the DrugDepo Web site through a banner ad and searches for "cosmetics" . The visitor finds a cosmetic kit and places it in the shopping cart. When the customer checks out, a notification is issued that the item is currently back ordered. The order is cancelled and the visitor leaves the DrugDepo Web site.

In scenario 1, the visitor becomes a satisfied customer who is likely to return to DrugDepo's Web site for future purchases. Scenario 2 and 3 result in frustration for the visitor and lost sales for DrugDepo. Positive experiences at online store fronts can motivate a happy first-time visitor to register at the Web site. This same visitor is now a registered user. When a registered user has a good experience, he or she is most likely to buy products from the Web site.

When a registered user purchases goods from a Web site, he or she becomes a first-time customer. If this user continues to derive value from the site, it is most likely they will continue to make purchases. With more purchases, this person is now a repeat customer and if the online store continues to keep this repeat customer happy, the buying pattern is likely to continue. Before long, this customer is going to be considered a profitable customer who most likely trusts the site and will be loyal and provide referrals to the online store.

Reviewing Oracle9iAS Components

Let's recap what you learned in the Administering a Web Site module.

Oracle9i is Oracle's family of database, application server, and Internet tools for building, deploying, hosting, and managing enterprise-class applications.

Oracle9i Application Server (Oracle9iAS) is a complete, integrated application server that you can use to:

	Develop and deploy all of your dynamic Web sites and applications
	Create personalized portals to access all of your content and applications
	Enable wireless access to portals
	Cache data and pages to accelerate performance of any Web site
	Extract business intelligence from site and application usage and use it to personalize applications
	Integrate users, applications, and businesses
	Manage and secure your entire Web infrastructure

Oracle9iAS provides four types of comprehensive business intelligence solutions:

	Oracle9iAS Clickstream Intelligence - provides reports on Web site activity
	Oracle9iAS Personalization - dynamically serves personalized real-time content recommendations to both registered and anonymous visitors
	Oracle9iAS Discoverer - enables users to perform dynamic, ad hoc query, reporting, and analysis using a standard Web browser
	Oracle9iAS Reports Services - provides a powerful deployment platform for publishing high-quality, dynamically generated end-user reports in a scalable, secure environment

Oracle9iAS Clickstream Intelligence collects data from Web site activities, and presents it in reports. It is not a standalone product, but a powerful, scalable, integrated tool built to handle Oracle's own online store. You can use Oracle9iAS Clickstream Intelligence to:

	Read Web server logs, parse cookies and query string data to identify many Web site activities.
	Transform Web server log data into business information such as the number and length of time that a user sees specific content.
	Integrate Web traffic data with business transaction data from CRM and ERP applications.
	Condense enormous volumes of data into meaningful reports.

Oracle9iAS Clickstream Intelligence

Oracle9iAS Clickstream Intelligence collects clickstream data from either Web server logs or from an Internet Service Provider (ISP) database log. Business data is obtained either through interface files or through published APIs. Clickstream Intelligence automatically filters, transforms and loads the data into a data warehouse and publishes it to a predefined data mart.

Specifically, Oracle9iAS Clickstream Intelligence has the following features:

	Oracle9iAS Clickstream Intelligence Runtime Administrator
	Oracle9iAS Discoverer Viewer
	Oracle9iAS Discoverer Plus
	Oracle9i Warehouse Builder

Oracle9iAS Clickstream Intelligence Runtime Administrator lets you create and mange Web log files. You will recall that Clickstream is composed of two major components: Runtime Administrator and Clickstream Analytics. The Runtime Administrator is a Web-based interface enabling your System Administrator to set and configure Clickstream data collection parameters for specific web sites. We will look at Clickstream Analytics shortly.

With Oracle9iAS Clickstream Intelligence Runtime Administrator you can:

	Configure your system connection
	Configure your sites and servers
	Configure your notion of a "user," "visitor," and "session"
	System configuration
	Dimension management

Oracle9iAS Discoverer Viewer is 100% HTML and requires no software other than a Web browser.

Discoverer Viewer enables you to:

	Run and view pre-defined Clickstream reports and graphs with ease
	Pivot multiple items at the same time use the tabular layout or crosstabular layout
	Analyze your log data by modifying the parameters, changing the layout, and sorting items

Oracle9iAS Discoverer Plus lets you customize Clickstream reports and graphs.

With Oracle9iAS Discoverer Plus you can:

	Create new Clickstream reports and graphs
	Add graph titles, resize format styles and colors to conform to corporate standards
	Expand your Clickstream analytical capabilities because Discoverer Plus lets you define analytic functions such as ranking, windowing, cumulative reporting functions, and moving averages.

Oracle9i Warehouse Builder provides the infrastructure for the Oracle9iAS Clickstream Intelligence solution. Oracle9iAS Clickstream Intelligence installs a Warehouse Builder repository and creates an open Oracle data warehouse that may be accessed by a variety of tools.

With Oracle9i Warehouse Builder, you have:

	An open Clickstream metadata repository
	Ease of scalability by adding other data sources
	Ease of extensibility by adding transformations

Oracle9iAS Clickstream Intelligence Analytics

Clickstream Analytics is a Web-based tool that enables users to query the data stored in the Data Warehouse and display this data in report format. The analytic component provides more than 150 pre-configured reports that can be accessed and viewed with Oracle9iAS Discoverer Viewer and Oracle9iAS Discoverer Plus. Reports and charts are produced through queries to the data mart.

Predefined reports are compartmentalized into standard report categories, which include:

	Activity
	Activity for new versus returning users/visitors
	Browsers and platforms
	Connecting machines
	Dimensional analysis
	Path analysis
	Referring URLs
	Referring URLs by connecting machines
	Referring URLs by users
	Search analysis
	Site content
	Site status
	Users/visitors
	Users by connecting machines
	Users by pages

Discoverer Viewer is the Web component of the Discoverer family that enables business professionals to execute queries that have already been stored in the database. Discoverer Viewer is a lightweight business intelligence tool that gives you access to workbooks and worksheets that have been created in Discoverer Plus or Desktop Edition. The workbooks and worksheets cannot be changed by the user with Discoverer Viewer. Discoverer Viewer is 100% HTML and requires no software other than a Web browser. It can be used over low-speed modems and can be accessed through high-security networks and firewalls.

Discoverer Plus is a Web/Java-based application that you can use to create ad hoc queries and generate reports. Existing reports can be changed and new reports can be built using Discoverer Plus.

Web Traffic Analysis Using Oracle9iAS Clickstream

Web traffic analysis enables Webstores to answer the following questions:

	Who is visiting the Web site?
	What are the visitors doing at the Web site?
	Where are visitors coming from?
	What content on the site is attracting and retaining most visitors?
	What content should be on the Web site?
	How can the overall Web site performance be improved?

The answers to these questions assist Web sites succeed in attracting visitors. Furthermore, these visitors can potentially be converted to customers. Additionally, they make available data, which can be used to attract sufficient traffic volume, provide visitors with a reason to stay after they arrive, provide products that visitors are looking for, and price products appropriately.

Let's examine for a moment, two scenarios that are present in today's marketplace. A visitor's experience to a Webstore is depicted, and compared and contrasted to a brick-and-mortar store experience.

Brick-and-mortar store...

	A customer enters a retail store.
	The customer walks down an aisle, looks at the cosmetics display, selects a bottle of perfume, and puts it into a shopping basket.
	The customer looks at various brands of shampoo, but passes up the opportunity to buy.
	Eventually, the customer completes the shopping and proceeds to the checkout with the basket.

Webstore...

	A customer enters a Webstore through a homepage.
	The customer clicks the product link, looks at the cosmetics, selects a bottle of perfume, and puts it into the shopping cart. This is the dynamic content of the Web site.
	The customer looks at various brands of shampoo, but passes up the opportunity to buy.
	Eventually the customer completes the shopping and clicks the checkout button.

In a Webstore, you have the opportunity to follow the visitor through the entire shopping trip. You can do the following:

	Identify returning visitors or customers.
	Track visitors or customers as they navigate through the Web site.
	Measure what visitors or customers look at, how long they look at an item, what they select, and what they reject.
	Customize and personalize the product listing to show the categories that returning visitors or customers are most likely to buy.

In a brick-and-mortar store, a customer always passes the checkout stand, with or without a purchase, before walking out the door. In a Webstore, a visitor or customer is just one mouse-click away from leaving the Web site, and may never return to check out the purchase. Oracle9iAS Clickstream Intelligence provides the facility to track Web site traffic and perform analysis on Clickstream data.

Oracle9iAS Clickstream Intelligence supports the following key areas of analysis for Web traffic:

	Site activity analysis - measures how active the site has been by hour, day, week, month or year, or by user-specified interval
	Page/content analysis - identifies effective and important Web site content
	Referral analysis - identifies the sources of the Web site visitors
	Visitor identification and analysis - identifies the types of visitors to the Web site and determines customer retention and demographics
	User analysis - gives you an opportunity to learn more about the users coming to your Web site (that is, you can find out who your top users are, what age group they are in, which geographic locations they are coming from, and how much time they spend at your Web site, for example)
	Proxy and client machine analysis - provides more information about the visitors to your Web site by domain, domain type, region, and country
	Dimensional analysis - assists you to uncover possible trends in your Web logs using referrer dimensional analysis, user dimensional analysis, page dimensional analysis, browser dimensional analysis, and connecting machines dimensional analysis
	Session identification and analysis - gives you an opportunity to feel the pulse of the visitor to the Web site (A long session indicates that visitors are attracted to the content of the Web site.)
	Path analysis - tracks and reports on paths used for navigation through the Web site
	Error analysis - allows you to identify technical problems on the Web site
	Search analysis - helps you find out how visitors are getting to your Web site
	Browser type analysis - browser type analysis identifies the most popular browsers used by visitors to the Web site

A key differentiator for Clickstream Intelligence is the product's open metadata-based tools, such as Oracle9i Warehouse Builder and Oracle9i Discoverer. These tools complement the Web analysis process. You will want to leverage this open model by building custom extensions on top of the core model and ETL process provided by Clickstream Intelligence. To extend the core Clickstream Intelligence tool, you might consider creating user-defined facts and dimensions, adding levels (hierarchies) to core dimensions, adding measures to levels and facts, creating user-defined reports and materialized views to support these reports, or defining additional log formats.

Understanding Web Site and Interaction Terminology

Purpose

This module introduces you to basic terminology for Web sites, Clickstream, and Internet advertising.

Module Objectives

After completing this module, you will be able to:

	Define Web terminology accurately
	Differentiate Clickstream terminology correctly
	Describe Internet advertising terminology clearly

Acquainting Yourself with Basic Web Terminology

It seems logical that before we discuss reporting and analysis techniques, we should have a fundamental understanding of the terminology used to build those reports. Let's take a look at some basic Web terminology that might assist you.

	URL - an addressing system identifying a Web resource consisting of a protocol portion (such as HTTP), a computer domain name, and an optional document name Example - http://www.drugdepo.com
	IP Address - the protocol number that uniquely identifies an address of a computer on a network Example - http://www.drugdepo.com/index.html is 123.11.22.333
	Link/hyperlink - is the URL associated with text or graphics on a page that when clicked causes the browser to display the page corresponding to the URL. A link is also known as a hyperlink.
	Page - refers to an HTML document or dynamically generated document, usually containing text, and often containing references to graphic images or interactive objects that make up the document A page has its own URL, which Internet users can request to view. There are three distinct types of pages: Home, Entry, and Exit. The main page of a Web site is the Home page. This usually contains links to the other pages of the site or to other sites. The page that a visitor first sees on a Web site is the Entry page. An example of using an entry page would be a URL in response to a banner ad. This way you can track the traffic from that specific ad. The page that a visitor last sees on a Web site is the Exit page. This may be because the visitor clicks a banner ad on the page, clicks a link to another site, selects the URL of another site, quits the browser, and so forth.
	Cookie - information that a user's browser stores on the user’s computer, at the request of a Web server Cookies are used to uniquely identify visitors, track users through a Web site, and among different Web sites, implement shopping carts, track users through a site and between visits, and store information about users' activities. Example - cookie:lshaw@ilearning.oracle.com/ilearn/en/learner/jsp/
	Portal - a Web site designed to be the first point of entry for visitors to the Web A Portal is a single, personalized view of all the applications and information users need to do their jobs. An example of a portal site is Yahoo!™. Most portals adopt the Yahoo!™ style of content categories with a text-intensive, faster loading page that visitors will find easy to use.
	Portlet - a reusable information component that can be assembled to deliver highly personalized portals to any user A portlet runs on the server and delivers a live area of HTML, which can then be placed on the portal site. An example of a portal site or page is My Yahoo!™, which allows you to customize the content of Yahoo!™. A user can personalize the information, including news, stock quotes, and more, and check his or her Yahoo!™ Mail, all in one place.

Understanding Web Traffic Terminology

Now that you have the basics down, let's continue to explore other terminology that will clarify your understanding of Web traffic.

	Clickstream - information about each request received by a Web server. The clickstream exists in the form of Web server logs, where each Web server log record relates to a single page event.
	Client - the broad name of the software used to access your Web site. An example of a client is Netscape™, Netscape Navigator™, Netscape Communicator™, Internet Explorer™, WebTV™, Real™, Lynx™, or Opera™.
	Connecting machines - the computer identified by the server, via its Internet address, as making the request, which could be a client machine or proxy server machine. When a proxy server makes a request on behalf of a client machine, it removes the Internet address of the client machine from the client machine from the request and replaces it with its own before doing so and thus hides the original client machine.
	Dwell time - the length of time that a specific Web page is available for viewing on a user’s browser. It is approximated by the time period between page requests to the site by the user.
	Events - discrete, significant visitor actions such as arriving at a homepage, searching for products, or specifying overnight delivery
	Hits - a single entry in a server log file, generated when a user requests a resource on a Web site
	Impressions - a measure of the number of times someone views something. The term is usually used for the number of times an advertisement is seen (ad views). The number of times an ad banner is downloaded from the Web server (measurable) understates this, as a browser may use the banner from its cache when the same banner appears several times.
	Impression duration - the elapsed time for a page view measured from the beginning of the page download to the beginning of the next impression
	Impression time to serve - the amount of time in seconds taken by the server to serve a page impression fully, measured from the beginning of the first resource request for that page until the end of the last resource for that page
	Impression dwell time - the impression duration minus impression time to serve
	Page Views (Page impressions) - the number of times a page is viewed (rather than an element such as an image or an audio file) If an advertisement is on a page, then page views are roughly equal to ad views on that page unless the user turns off graphics.
	Query String - the portion of the URL after the question mark usually used to hold a query Example - http://www.drugdepo.com/whydrugdepo.html whydrugdepo.html is the query string
	Resource - may represent a static server object such as an HTML document, navigation bar, image, movie, or CGI program
	Session (visit) - a sequence of requests made by one user When a visitor stops making requests from a site for a given period of time, called a session threshold, the next hit by this visitor is considered a new session.
	Session duration - total number of seconds that elapsed during a session measured from the first resource request to the last page impression of the session (approximated)
	Spider (crawler or bot) - a program that automatically fetches some or all of the Web pages that are referenced from a Web site The term crawler is used when the program spaces out its fetches, so it does not overload your Web site. Spiders and crawlers are mostly used by search engines to create an index of the Web site.
	User - a uniquely identifiable person. An accurate count of users is not possible without some form of registration or authentication.
	User agent - the computer identified by the server, via its Internet address, as making the request, which could be a client machine or proxy server machine When a proxy server makes a request on behalf of a client machine, it removes the Internet address of the client machine from the client machine and replaces it with its own before making the request, and thus hides the original client machine.
	Uniform Resource Identifier (URI) - is the portion of a URL that follows the host and port, but precedes the query string Example - http://www.drugdepo.com/index.html index.html is the URI stem
	Visitor - an individual who visits a Web site (usually this visit is anonymous)
	Web log - file that lists actions that have occurred. With log file analysis tools, it is possible to get a good idea of where visitors are coming from, how often they return, and how they navigate through a site

Recognizing Internet Advertising Terminology

With a firm grasp of Web and Clickstream terminology, let's move along to the final topic. This topic describes terms that are commonly used in Internet advertisement such as clickthroughs, clickthrough rate, and cost per thousand impressions (CPM). This topic concludes with cross-selling and up-selling. Every Web site dream is to generate sales for the company and one of the ways to accomplish this, is to cross-sell and up-sell products offered on the online storefront.

	Affiliate - a type of referrer which has been identified as a marketing partner site
	Churn rate - measures the percentage of customers who are lost in a given time period If the time period is one month, and in the first month you have 100 customers and in the second month you have only 80 out of the original 100, then the churn rate is 20% per month. The period of time is a critical component for properly measuring churn. With Web sites, there may not be a specific mechanism that really tells when a customer will no longer buy a product or service from that site.
	Clickthrough - the number of times users click on a banner advertisement to go to the site linked to the banner If a banner ad is viewed 100 times by users and only 4 of those users clicked on the ad, then the number of clickthroughs is 4.
	Clickthrough rate - the percentage of ad impressions that are clicked on by users If a banner ad is viewed 100 times by users and only 5 of those users clicked on the ad, then the clickthrough rate is 5%. The clickthrough rate is good indicator of an advertisement's effectiveness.
	Conversion - said to occur when a prospect becomes a customer of a product or service If a visitor to a Web site decides to register as a user or buys a product, then the visitor is said to have been converted. The ability to convert visitors to customers is critical for Web sites that depend on the sales of products or services.
	Cross selling - selling of related goods and services to a consumer For example, if Joe buys a car from you and you subsequently sell him a car hi-fi system, car security system, or golf clubs.
	CPM - the cost per thousand impressions of a banner advertisement If the CPM of a site is $10, then for a payment of $10 the banner advertisement will be shown 1000 times.
	Draw - the measure of the ability of an advertisement or promotion to attract visitors Draw does not measure customers as visitors may not become customers. There is a tendency for "cute" banner ads to result in high draw, but low conversion.
	Referral - the transfer of a visitor from one site to another The site from where the visitor came is called the referring site, and the site that the visitor reaches is called the referred site.
	Retention - measures the ability to keep existing customers If a visitor to a Web site purchases a product, the visitor becomes a customer, and if the customer returns to the Web site to purchase another product or post comments on the site's message board within a certain time period, then the customer is considered retained. Otherwise, the customer is said to have been lost.
	Retention rate - the percentage of customers who are repeat customers over a period of time
	Stickiness - the measure of the amount of time a visitor spends on a Web site per visit In an effort to encourage people to stay on their site longer, Yahoo! launched free Java-based games at Yahoo!Games.
	Up selling - selling of upgrades, add-ons, enhancements to a particular product or service For example, if a customer purchased a cheap wine from you and you subsequently sold that customer a more expensive wine, then you have successfully up sold that customer.

With this solid foundation of terms and concepts, we can now proceed to accessing, manipulating, and understanding the Clickstream reports.

Accessing and Understanding Reports

Purpose

This module provides a walkthrough of the Oracle9iAS Clickstream Intelligence analytics user interface and describes how to employ Discoverer Viewer to view Clickstream reports. Additionally, all report types are discussed.

Module Objectives

After completing this module, you will be able to:

	Connect to Oracle9iAS Clickstream Intelligence Analytics
	View Clickstream Intelligence reports
	Describe how the Oracle9iAS Clickstream Intelligence reports are organized
	Identify and use the Oracle9iAS Clickstream Intelligence reports to perform Web site analysis and improve Web site content

What is Clickstream Intelligence Analytics?

Oracle9iAS Clickstream Analytics includes:

Oracle9iAS Discoverer Viewer - Web component of the Discoverer family that enables business professionals to execute queries, which have already been stored in the database Discoverer Viewer is a lightweight business intelligence tool that gives you access to workbooks and worksheets that have been created in Discoverer Plus or Desktop Edition. The workbooks and worksheets cannot be changed by the user with Discoverer Viewer. Discoverer Viewer is 100% HTML and requires no software other than a Web browser, can be used over low-speed modems, and can be accessed through high-security networks and firewalls. Oracle9iAS Clickstream Intelligence uses Discoverer as its reporting environment. There are two types of connections in Oracle9iAS Discoverer Viewer: public connections and private connections. A Public connection is a shared connection created by Discoverer Manager that anyone with access to the Web page can use. A Private connection is an individual connection created by you to store specific login details (i.e., database user name, database password, and database name) to connect to a Discoverer database account.

Oracle9iAS Discoverer Plus - Web/Java-based application that you can use to create ad hoc queries and generate reports Existing reports can be changed and new reports can be built with the use of Discoverer Plus.

Connecting to Clickstream Intelligence

As mentioned in the Administration module, Clickstream is installed as part of the Business Intelligence or Unified Messaging component of Oracle9i Application Server. Open an Internet browser window and enter the URL established during the install. (If you are not the Clickstream Administrator, ask the Clickstream Administrator for the URL).

The URL will follow this format: http://HOST:PORT/click/

The HOST is the name of the computer on your network that provides access to Oracle9iAS Clickstream Intelligence. The PORT is the HTTP port number on which the host (server) listens. (To determine the port number for your host, ask your Database Administrator (DBA) or Clickstream Administrator.)

You can also go to the following configuration file located in the directory in which Oracle9iAS was installed to find the URL:

(UNIX) /Apache/Apache/conf/httpd.conf

Creating a Private Connection

Once the Connect to Discoverer Viewer screen appears, follow these instructions to create a private connection.

Once you are in the list of workbook pages, you will see a list of the workbooks available for selection. These workbooks are the report categories for Oracle9iAS Clickstream Intelligence.

Introduction to Clickstream Intelligence Reports

The Oracle9iAS Clickstream Intelligence reports are ordered by workbook. A workbook is similar to a report category. There are seventeen workbooks (report categories) within Oracle9iAS Clickstream Intelligence. Each workbook is listed in the table and is accompanied by a description detailing what each report can provide you with. The second table provides you with a list of each report found in the corresponding workbook. There are 154 reports available.