Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Structure

Related Documents

Conventions

1 Introduction

Introduction to Oracle9i Clickstream Intelligence Builder

Using the Clickstream Intelligence Builder

Extending the Data Model

Extending Clickstream Analytics

2 The Agent Dimension

Agent Dimension Hierarchies

The Agent Client Software Hierarchy

The Agent Operating System Hierarchy

Agent Dimension Levels

CLK_L_CLIENT_TYPE

CLK_L_CLIENT

CLK_L_CLIENT_VERSION

CLK_L_PLATFORM

CLK_L_OPERATING_SYSTEM

CLK_L_AGENT

3 The Client Host Dimension

Client Host Dimension Hierarchies

The Client Geography Hierarchy

The Client Organization Hierarchy

Client Host Dimension Levels

CLK_L_REGION

CLK_L_COUNTRY

CLK_L_DOMAIN_TYPE

CLK_L_DOMAIN

CLK_L_CLIENT_HOST

4 The Date Dimension

Date Dimension Hierarchies

The Date Calendar Hierarchy

The Date Fiscal Hierarchy

The Date Week Hierarchy

Date Dimension Levels

CLK_L_CALENDAR_YEAR

CLK_L_CALENDAR_QUARTER

CLK_L_CALENDAR_MONTH

CLK_L_FISCAL_YEAR

CLK_L_FISCAL_QUARTER

CLK_L_FISCAL_MONTH

CLK_L_WEEK

CLK_L_DAY

5 The Event Type Dimension

Event Type Dimension Hierarchies

The Event Type Hierarchy

Event Type Dimension Levels

CLK_L_EVENT_TYPE

6 The Page Dimension

Page Dimension Hierarchies

The Page Category Hierarchy

The Page Resource Hierarchy

Page Dimension Levels

CLK_L_PAGE_CAT6

CLK_L_PAGE_CAT5

CLK_L_PAGE_CAT4

CLK_L_PAGE_CAT3

CLK_L_PAGE_CAT2

CLK_L_PAGE_CAT1

CLK_L_RESOURCE_TYPE

CLK_L_RESOURCE

CLK_L_PAGE

7 The Referrer Dimension

Referrer Dimension Hierarchies

The Referrer Campaign Hierarchy

The Referrer Category Hierarchy

The Referrer Geography Hierarchy

The Referrer Organization Hierarchy

Referrer Dimension Levels

CLK_L_CAMPAIGN

CLK_L_REF_CAT3

CLK_L_REF_CAT2

CLK_L_REF_CAT1

CLK_L_REGION

CLK_L_COUNTRY

CLK_L_DOMAIN_TYPE

CLK_L_DOMAIN

CLK_L_REF_SITE

CLK_L_REF_URL

8 The Search Dimension

Search Dimension Hierarchies

The Search Hierarchy

Search Dimension Levels

CLK_L_SEARCH_CAT3

CLK_L_SEARCH_CAT2

CLK_L_SEARCH_CAT1

CLK_L_SEARCH

9 The Server Dimension

Server Dimension Hierarchies

The Server Hierarchy

Server Dimension Levels

CLK_L_SERVER_FARM

CLK_L_SERVER

10 The Server Status Dimension

Server Status Dimension Hierarchies

The Server Status Hierarchy

Server Status Dimension Levels

CLK_L_STATUS_TYPE

CLK_L_STATUS

11 The Session Type Dimension

Session Type Dimension Hierarchies

The Session Type Hierarchy

Session Type Dimension Levels

CLK_L_SESSION_TYPE

12 The Site Dimension

Site Dimension Hierarchies

The Site Hierarchy

Site Dimension Levels

CLK_L_SITE

13 The Time of Day Dimension

Time of Day Dimension Hierarchies

The Time of Day Hierarchy

Time of Day Dimension Levels

CLK_L_HOUR

CLK_L_MINUTE

CLK_L_SECOND

14 The User Dimension

User Dimension Hierarchies

The User Age Gender Hierarchy

The User Company Hierarchy

The User Geography Hierarchy

User Dimension Levels

CLK_L_AGE_GROUP

CLK_L_GENDER

CLK_L_INDUSTRY

CLK_L_COMPANY

CLK_L_REGION

CLK_L_COUNTRY

CLK_L_STATE

CLK_L_USER

15 The Visitor Dimension

Visitor Dimension Hierarchies

The Visitor Hierarchy

Visitor Dimension Levels

CLK_L_VISITOR_TYPE

CLK_L_VISITOR

16 The Impression Fact

Impression Fact Attributes

Foreign Keys

Measures

17 The Session Fact

Session Fact Attributes

Foreign Keys

Measures

Index