Release 2 (9.0.2.2)
Part Number A90888-02
 Home |
 Solution Area |
 Contents |
 Index |
| Oracle9iAS Clickstream Intelligence User's Guide Release 2 (9.0.2.2) Part Number A90888-02 |
|
The worksheets in Oracle9iAS Clickstream Intelligence Analytics (Clickstream Analytics) enable you to gather critical business intelligence from the information stored in the log files generated by your Web site's Web servers. With more than 150 pre-defined worksheets, Clickstream Analytics enables you to analyze Web site activity from several perspectives. Use these worksheets to analyze, troubleshoot, and improve your Web site's effectiveness.
This chapter describes the specific information provided by each pre-defined worksheet in Clickstream Analytics. All worksheets are organized by workbook, as listed below:
Use this workbook to see general activity on your site. The worksheets available give an accurate count of users, visitors, referrers, clients, sessions, searches, pages, bytes sent, session duration, and time to serve.
The following worksheets are available:
This worksheet displays the number of unique registered users that accessed the site on a daily basis. It enables you to track changes in the frequency of user visits.
This worksheet displays the number of unique registered users that accessed the site on an hourly basis. It enables you to track changes in the frequency of user visits.
This worksheet displays the number of unique unregistered users that accessed the site on a daily basis. It enables you to track changes in the frequency of unauthenticated user visits.
This worksheet displays the number of unique unregistered users that accessed the site on an hourly basis. It enables you to track changes in the frequency of unauthenticated user visits.
This worksheet displays the number of unique referrers that directed users and visitors to the site on a daily basis. This worksheet can help you examine the Web site(s) that directed customers to your site, and may indicate changes in the frequency of referrals from external Web sites.
This worksheet displays the number of unique referrers that directed users and visitors to the site on an hourly basis. This worksheet can help you examine the Web site(s) that directed customers to your site, and may indicate changes in the frequency of referrals from external Web sites.
This worksheet displays the daily number of client machines, or proxy servers, that accessed the site, and may indicate if there was a change in frequency of client connections to the site.
This worksheet displays the number of client machines, or proxy servers, that accessed this site on an hourly basis, and may indicate if there was a change in frequency of client connections to the site.
This worksheet displays the daily number of sessions by users and visitors of your site, and may indicate changes in Web site activity.
This worksheet displays, on an hourly basis, the number of sessions by users and visitors of your site, and may indicate changes in the Web site activity.
This worksheet displays the daily number of pages served by the site, and may indicate changes in the frequency of site usage.
This worksheet displays, on an hourly basis, the number of pages served by the site, and may indicate changes in the frequency of site usage.
This worksheet displays the daily amount of data, in bytes, transferred to and from the site. This worksheet may indicate fluctuations in site usage, since greater data flow typically results from increased use of your site's content.
This worksheet displays, on an hourly basis, the amount of data, in bytes, transferred to and from the site. This worksheet may indicate fluctuations in site usage, since greater data flow typically results from increased use of your site's content.
This worksheet displays the average length of all sessions that occurred on a particular day, and may indicate if there was a change in the length of customer visits to your Web site over consecutive days. Large changes in session duration over time (either increases or decreases in session length) for example, may be used to determine the popularity of your site.
This worksheet displays, on an hourly basis, the average length of all sessions that occurred on a particular day, and may indicate if there was a change in the length of customer visits to your Web site. Large changes in session duration over time (either increases or decreases in session length) for example, may be used to determine the popularity of your site.
This worksheet displays the daily number of unique searches performed by referring search engines, and indicates the frequency of searches performed on the site.
This worksheet displays, on an hourly basis, the number of unique searches performed by referring search engines. This worksheet indicates the frequency of searches performed on the site.
This worksheet displays, on a daily basis the average amount of time required for the site to serve a page request. This data may indicate changes in site traffic volume since it may take the server longer to respond to a request when many individuals want to view site content simultaneously.
This worksheet displays, on an hourly basis, the average amount of time required for the site to serve a page request during the date range you selected. Unlike other hourly reports in this workbook, hourly data in this worksheet is aggregated across the range of dates selected. This worksheet may indicate changes in site traffic volume, since it may take the server longer to respond to a request when many individuals want to view site content simultaneously.
Use this workbook to see the trends and volume of new and returning activity on your site for users. Users are defined as individuals who have registered with a Web site and been authenticated. Users are also defined as individuals who, upon logging in to a Web site, are granted access.
The following worksheets are available:
This worksheet displays the trends that appear in daily site usage by comparing first-time site users with registered users. This information may enable you to assess if new users respond to your campaigns. You can also infer the level of customer retention, since a high level of returning users typically indicates satisfaction with site usability, products, or content.
This worksheet compares the daily levels of first-time site users with the number of users that have previously accessed the site. You can use this information to determine the level of customer retention (wherein most users are returning users) or to determine the rate of influx of new customers that register on your site.
This worksheet displays a monthly trend for site usage among first-time and registered users. This information enables you to assess the efficacy of monthly marketing efforts, and determine the impact on site "stickiness." You can also infer the level of customer retention and observe changes in sign-up rates for new users.
This worksheet compares the monthly levels of first-time site users with the number of users that have previously accessed the site. You can use this information to determine the level of customer retention or to determine the monthly change in the number of new customers that register on your site.
This worksheet displays a quarterly site usage trend among first-time and registered users. This information may enable you to assess the efficacy of marketing efforts over a series of quarters and determine if new users respond to your campaigns. You can also infer your level of customer retention and compare that with results from previous quarters.
This worksheet compares the quarterly levels of first-time site users with the number of users that have previously accessed the site. You can use this information to assess customer retention for the site or to compare the change in new user registration on a quarterly basis.
This worksheet displays a yearly trend for site usage among first-time and registered users. This information may indicate annual fluctuations in new user sign-up and long-term trends in customer loyalty.
This worksheet compares the yearly levels of first-time site users with the number of users that have previously accessed the site. You can use this information to determine the level of customer retention over one or more years or to determine the annual influx of new site registrants.
Use this workbook to see the trends and volume of new and returning activity on your site for visitors. New visitors are defined as a person or agent that visits the site for the first time but has neither registered any personal information nor accepted a tracking device. Returning visitors are visitors who have not registered with the site, but have accepted a cookie or are identified by some other tracking device.
The following worksheets are available:
This worksheet displays a trend for daily site usage by comparing first-time site visitors with visitors that have previously accessed your site and accepted a cookie or are identified by a different tracking device. This information may enable you to assess the efficacy of marketing efforts over a specific number of days and determine if new visitors respond to your campaigns. You can also infer the level of visitor retention, since a high level of returning visitors typically indicates satisfaction with site design, products, or content.
This worksheet compares the daily levels of first-time site visitors with the number of visitors that have previously accessed your site and accepted a cookie or are identified by a different tracking device. You can use this information to assess site "stickiness" or to determine the rate of influx of new visitors to your site.
This worksheet displays a monthly trend for site usage by comparing first-time site visitors with visitors that have previously accessed your site and accepted a cookie or are identified by a different tracking device. This information enables you to assess the efficacy of monthly marketing efforts, and determine the impact on site "stickiness" among those who have not registered on your site.
This worksheet compares the monthly number of first-time site visitors with the number of visitors that have previously accessed your site and accepted a cookie or are identified by a different tracking device. You can use this information to determine the level of visitor retention or to determine the monthly change in the number of new visitors that access your site.
This worksheet displays a quarterly trend for site usage by comparing first-time site visitors with visitors that have previously accessed your site and accepted a cookie or are identified by a different tracking device. This information may enable you to assess the efficacy of marketing efforts over a series of quarters and determine if new visitors respond to your campaigns. You can also infer current levels of visitor traffic and compare that with trends from previous quarters.
This worksheet compares the quarterly levels of first-time site visitors with the number of visitors that have previously accessed your site and accepted a cookie or are identified by a different tracking device. You can use this information to assess site "stickiness" or to compare the change in new visitor traffic on a quarterly basis.
This worksheet displays a yearly trend for site usage by comparing first-time site visitors with visitors that have previously accessed your site and accepted a cookie or are identified by a different tracking device. This information may indicate annual fluctuations in new visitor traffic and long-term trends in visitor return rates.
This worksheet compares the annual levels of first-time site visitors with the number of visitors that have previously accessed your site and accepted a cookie or are identified by a different tracking device. You can use this information to determine the long-term patterns among returning unauthenticated site users or to determine the annual influx of new visitor traffic.
Use this workbook to see information relating to the different types of browsers and platforms that people use to visit your site.
The following worksheets are available:
This worksheet shows statistics and session information about the Internet browsing applications used most frequently to access the site. This worksheet enables you to infer the Internet browser preference of your audience so that you can optimize site content for one or more specific browsers.
This worksheet displays statistical data related to the activity of a particular browser type, and enables you to observe how people use that browser type to navigate your site.
This worksheet displays the version numbers of all Internet browsers used to access the site as well as the specific browser versions that your customers use most. If your site is primarily viewed with older browsers you may want to limit the appearance of certain site content that can only be viewed with newer browser versions.
This worksheet displays the Web crawler (also referred to as an intelligent agent, spider, or "bot") that is used most frequently to index the site. You can use this worksheet to determine which crawlers are indexing your site and whether you are attracting the appropriate type of search engine spider or other crawler.
This worksheet displays the types of Internet agents (such as text browsers, graphical browsers, or spiders) that access the site most frequently. You can use this worksheet to determine the Internet browser preference of your audience, so that site content can be optimized for that browser type. If your site is accessed frequently by text browsers, for example, you may want to design the site to be compatible with that type of browser.
This worksheet displays the types of processors in the computers that power the browsers which accessed your site. This information may enable you to design your site so that content is compatible with the types of processors used by most of your customers. If browsers powered by computers with x486 processors frequently visit your site, for example, you may want to limit the use of complex animation or other items that require powerful processors.
This worksheet displays the complete User-Agent string associated with the browser types used most frequently to access the site. You can use this worksheet to determine the Internet browser preference of your audience, so that site content can be optimized for that browser. For more information on User-Agents see Appendix A in the Oracle9iAS Clickstream Intelligence Administrator's Guide.
Use this workbook to see demographics and count information that relates to the computer used by a user or visitor to access your site.
The following worksheets are available:
This worksheet displays the IP address or resolved name of the computers that accessed your site most frequently. The IP address or name displayed may belong to an actual user or to their proxy server. This information can be combined with information from other site traffic or user origin worksheets to characterize the type of audience that accesses your site.
This worksheet displays the names of the domains from which users and visitors accessed your site. The information in this worksheet enables you to distinguish competitors, internal divisions of your company, and the general public.
This worksheet displays the domain types of the computers used to access your site. This worksheet may indicate the category of domains from which site traffic originates, such as educational institutions (.edu) or government organizations (.gov).
This worksheet displays the location of the computers used to access your site. This worksheet may indicate the region of the world from which most of your site's traffic originates.
This worksheet displays, by country, the location of the computers used to access your site. This worksheet enables you to determine the country from which most of your site's traffic originates, and may indicate the scope of the site's appeal within a specific country.
This worksheet displays all known data about a connecting machine associated with a particular IP address or resolved name, and may enable you to assess the usage habits of people that connect to your site from a particular computer or proxy server.
Use this workbook to cross reference the database using metrics that you control.
The following worksheets are available:
This worksheet displays all Web log data in the session fact table that is related to the Referrer dimension. This worksheet enables you to view and analyze relationships among data in all hierarchies within the Referrer dimension, and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
This worksheet displays all Web log data in the session fact table that is related to the User dimension. This worksheet enables you to view and analyze relationships among data in all hierarchies within the User dimension, and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
This worksheet displays all Web log data in the session fact table that is related to the Page dimension. This worksheet enables you to view and analyze relationships among data in all hierarchies within the Page dimension, and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
This worksheet displays all Web log data in the session fact table that is related to the Browser dimension. This worksheet enables you to view and analyze relationships among data in all hierarchies within the Browser dimension, and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
This worksheet displays all Web log data in the session fact table that is related to the Connecting Machine dimension. This worksheet enables you to view and analyze relationships among data in all hierarchies within the Connecting Machine dimension, and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
Use this workbook to see information relating to the paths that people followed through your site.
The following worksheets are available:
This worksheet displays the most popular two-page combinations viewed within your site, and may indicate key pages upon which advertising banners can be strategically placed for maximum customer visibility.
This worksheet displays the most popular five-page combinations viewed within your site. This information enables you to track the most common sequence of clicks through your site, and may indicate high-visibility pages for the strategic placement of advertising banners.
This worksheet displays the sequence of pages viewed most frequently by site users and visitors from a given starting point. This information may indicate common page sequences or navigational pathways, and may also enable you to determine the entry pages associated with the pathways that result in desired behaviors (such as making a purchase).
This worksheet displays the sequence by which users and visitors traveled through the site to a specific destination page. This information may enable you to determine the most common pathways that lead customers to advertising banners or other key areas of your site.
This worksheet displays the navigational paths followed by customers that were directed to your site by a particular referrer. If you want to analyze the differences (or similarities) in the interests of customers directed to your site by several different referrers, simply provide a new referrer name each time you run this report.
This worksheet displays the navigational paths followed by customers that were directed to your site by a particular referring host. If you want to analyze the differences (or similarities) in the interests of customers directed to your site from several different referring hosts, simply provide a new host name each time you run this report.
This worksheet displays, for a particular referring site, the navigational paths followed by customers that were directed to your site. If you want to analyze the differences (or similarities) in the interests of customers directed to your site from several different referring sites, simply provide a new site name each time you run this report.
This worksheet displays the navigational paths followed by people who used a particular browser to access your site. If you want to analyze the influence, if any, that browser selection has upon the sequence of pages viewed by site users and visitors, simply provide a new agent name each time you run this report.
This worksheet displays the navigational paths followed by people who used a particular computer or proxy server name to access your site. If you want to analyze the differences (or similarities) in the interests of customers that access your site from different domains or IP addresses, simply provide new connecting machine information each time you run this report.
This worksheet displays a specific user's navigational path through your site. If you want to analyze the differences (or similarities) in the browsing habits of several users, simply provide a new user name each time you run the report. This type of comparative information may enable you to determine typical pathways that result in specific customer behavior, such as making a purchase or downloading content, and may enable you to formulate ways of more effectively directing users to certain areas of your site.
This worksheet displays a specific visitor's navigational path through your site. If you want to analyze the differences (or similarities) in the browsing habits of several different visitors, simply provide a new visitor name each time you run the report. This type of comparative information may enable you to determine typical navigation pathways, such as making a purchase or downloading content, and may lend insight into the use of your site by visitors.
Use this workbook to see demographics and information relating to the origin of a person who is visiting your site.
The following worksheets are available:
This worksheet displays, by rank, the referrers (both internal and external) that directed visitors to your site most often. This information may enable you to determine the type of audience that is most frequently referred to your site, and may enable you to assess the effectiveness of current strategic partnerships with referring Web sites.
This worksheet displays the Web sites outside your realm that referred customers to your site most frequently. This information may enable you to assess the effectiveness of current strategic partnerships, and can help to characterize the type of audience that is most often directed to your site.
This worksheet displays the internal Web sites that most frequently referred customers to specific places within your site, and may enable you to assess the effectiveness of current internal promotions and marketing campaigns. Internal sites may reside within the realm of your own site, or may be sites classified as "internal" by your System Administrator for reporting and business purposes.
This worksheet displays URLs for the Web sites (internal and external) that referred customers to your site, which typically indicates the sites from which most of your site's traffic originates. This information may enable you to determine where your audience is coming from, and may help you to assess the effectiveness of current strategic partnerships with referring sites.
This worksheet displays domains that referred customers to your site, and may indicate the category of site from which most of your site's traffic originated, such as educational institutions (.edu) or corporate sites (.com). This information may help you to assess the effectiveness of current strategic partnerships with referring sites from particular domains.
This worksheet displays the Web sites from a particular category that referred customers to your site. Categories are typically defined by your System Administrator and provide a means of grouping referrers by specific criteria related to your business or type of Web site. This information may indicate the type of audience that is most frequently referred to your site, and may enable you to assess the effectiveness of strategic partnerships with specific types of referrers.
This worksheet displays the regions in which there are Web sites that directed customers to your site. This worksheet enables you to determine key regional areas from which site traffic originates, so that advertising campaigns and site content can be targeted for the audience that is most frequently directed to your site.
This worksheet displays the countries in which there are Web sites that directed customers to your site. This worksheet may enable you to determine the countries from which site traffic originates, so that advertising campaigns and site content can be targeted for the audience that is most frequently referred to your site.
This worksheet displays the types of domains that directed people to your site, such as educational institutions (.edu), commercial enterprises (.com), non-commercial organizations (.org), and so on, as well as the number of sessions generated by each referring type. This information may enable you to determine the type of audience that is typically referred to your site, so that advertising campaigns and site content can be targeted for the customers your site attracts.
This worksheet displays detailed information related to a specific Web site that referred traffic to your site. This statistical data may form the basis of further referrer analyses when combined with other Clickstream Analytics reports.
Use this workbook to see reports that combine information about the URLs that refer visitors to your site and the computers used by people to access your site.
The following worksheets are available:
This worksheet displays all Web log data in the session fact table of the database that is related to both the Referrer and Connecting Machine dimensions of the database. This worksheet enables you to analyze relationships and interactions between the data in all hierarchies of these two dimensions and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
This worksheet displays information about the domains from which users and visitors accessed your Web site and the types of computers they used to connect to the Internet. Because these users and visitors were referred to your site, the worksheet provides the names of the domains from which they were referred in the Domain Name column. The Country Name column tracks the physical location of the computers (known as connecting machines) they used to access your Web site.
Initially displays the intersection of data from two dimension levels - the Category level of the Referrer dimension and the Country level of the Connecting Machines dimension. This worksheet enables you to examine and establish relationships between data in any of the levels in the Referrer and Connecting Machine dimensions.
Use this workbook to see reports that combine information about the URLs that refer people to your site and information about registered site users.
The following worksheets are available:
This worksheet displays all Web log data in the session fact table that is related to both the Referrer and User dimensions. This worksheet enables you to analyze relationships and interactions between the data in all hierarchies of two dimensions, and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
This worksheet categorizes, by age group, the domains from which your site is accessed. Age information is typically provided by users upon registration with your site; the range of ages for each group is defined by your System Administrator. You may find, for example, that users from educational institutions (.edu) fall into a younger age group than individuals that access your site from corporate domains (.com).
This worksheet categorizes, by gender, the domains from which your site is accessed. The data returned by this worksheet may enable you to infer the domains from which mostly male or female users originate. Information about a user's gender, when specified, is usually provided upon registration with your site.
This worksheet categorizes, by marital status, the domains from which your site is accessed, and may enable you to infer the domains from which the largest number of married, single, or divorced users originate. Information about marital status, when specified, is usually provided by the user upon registration with your site.
This worksheet displays, by level of service, the domains from which your site is accessed, and may enable you to infer the domains from which users with the highest (or lowest) subscription level originate. You may find, for example, that users from educational institutions (.edu) usually subscribe to the basic level of service from your site, while individuals that subscribe to premium services generally access your site from corporate domains (.com). User subscription levels are typically defined by your System Administrator.
This worksheet displays, by age group, the categories of referrers that directed customers to your site, and may enable you to determine the age range of the users that are sent to your site by particular types of referring Web sites. Age information is typically provided by users upon registration with your site; both age groups and referrer categories are defined by your System Administrator.
This worksheet displays, by gender, the categories of referrers that directed customers to your site, and may enable you to infer the types of referring Web sites from which mostly male or female users originate. Information about a user's gender, when specified, is usually provided upon registration with your site; referrer categories are defined by your System Administrator.
This worksheet displays, by marital status, the categories of referrers that directed customers to your site. Information about marital status, when specified, is usually provided by the user upon registration with your site; referrer categories are defined by your System Administrator.
This worksheet displays, by level of service, the categories of referrers that directed customers to your site. This worksheet may enable you to determine the types of referrers from which users with the highest (or lowest) subscription level originate. Both user subscription levels and referrer categories are defined by your System Administrator.
Use this workbook to find the most popular search keywords, the most popular search phrases, and the most popular search engines on your site.
The following worksheets are available:
This worksheet displays the search engines that are used most frequently by site users and visitors to access information on the site. This information can help you determine the relative popularity of your site on those search engines.
This worksheet displays the most common words or phrases that were entered into the external search engines that referred users and visitors to the site. This worksheet may indicate specific site content that interests and attracts customers, and enables you to determine the keywords that prompt search engines to send visitors to your site.
This worksheet displays the most common phrases or keywords entered into search engines that exist on your site, and may indicate site content that is most appealing or interesting to customers that perform internal searches.
This worksheet displays the search engines used most frequently by site users and visitors. Additionally, this worksheet indicates the keywords used to produce successful search results. This information enables you to determine the phrases or topics within your site that people are searching for.
Use this workbook to see the most frequently requested items and content on your site.
The following worksheets are available:
This worksheet displays the pages within your site that are viewed most frequently. These are the most popular areas of your site. This worksheet also enables you to determine the visibility of particular advertisements or marketing campaigns.
This worksheet displays the requested pages within your site that are seldom viewed. Use this information to determine which sections of your site aren't getting the appropriate amount of attention from users and visitors. Pages within your site that have not been viewed do not appear in this worksheet.
This worksheet displays the pages within your site that are used most frequently as an entry point (such as the site homepage or other bookmarked page). Use this information to determine how users and visitors gain access to the site.
This worksheet displays the pages within your site that are most frequently viewed immediately before a session is ended. This information may indicate areas of the site that are difficult to use, causing users and visitors to lose interest in the site or its content.
This worksheet enables you to determine the top pages used to enter different sections of your site. Use this data to determine how people navigate within the site. Pages within the site that cause people to link to external sites are not considered in this count.
This worksheet enables you to determine which pages within your site cause people click the Refresh button on their browsers to reload the content. This data may reflect a technical error that causes your users and visitors to constantly refresh the page.
This worksheet enables you to determine the top pages used to enter your site. This report defines a bookmarked page as follows: The page URL is entered by the user directly into the browser, or the person selects the page from his or her list of bookmarks. Use this data to determine what pages are most popular within your site and place advertising or other important content there.
This worksheet enables you to determine which virtual directories within your site are most frequently accessed by users and visitors. A virtual directory is the path to a folder on the Web server used to provide site content. In a URL virtual directory information follows immediately after the domain information(.com, .org, .edu, and so on). Use this data to determine if you need to address potential performance problems.
This worksheet enables you to determine which files within your site are most frequently downloaded. Use this data to determine which file types are most popular with site users and visitors.
This worksheet gives you categorized views of which pages within your site are viewed most frequently. Use this data to determine what category types are most popular at your site. Page categories are set by your System Administrator. If your System Administrator has not defined categories, Oracle9iAS Clickstream Intelligence will create them by parsing the directory structure of your site.
This report enables you to track the activities on a specific page within your site. All known data about the page is shown in this report. Use this data to determine whether the page is useful within the context of the site.
Use this workbook to see server load information for your site. This workbook will also show error and status counts for the various resources on your site.
The following worksheets are available:
This worksheet enables you to determine which Web servers within your site are most frequently responding service requests. Use this data to determine a maintenance schedule for your Web servers. You can also use this data to determine if your servers are sharing the workload equally. If not you may want to make changes to balance the load on all your servers.
This worksheet enables you to determine how frequently servers within your site generate error status messages. This report includes all status codes returned by a server and the number of times each code occurred. Use this information for to determine which Web servers within your site may have performance issues that must be resolved.
This worksheet enables you to determine which servers within your site generate the most errors. Use this information to identify and address performance issues.
This worksheet enables you to determine the day in which the most server and client errors occurred. Use this information to create a server maintenance schedule.
This worksheet enables you to determine which pages within your site generate the most error status codes. Use this information to improve the usability of your site.
This worksheet enables you to determine which files within your site generate the most client errors. Use this information to improve the usability of your site.
This worksheet enables you to review the status codes generated by your site's servers for selected pages within your site. Use this information to determine the types of status messages generated by select pages, troubleshoot your site, and improve site usability.
This worksheet enables you to determine which pages within your site generated a specific status code during this time period. Use this information to determine if similar pages within the site generate the same types of status codes.
This worksheet enables you to determine which pages within your site are causing the most client errors. Use this information to correct or delete those pages and improve site usability.
This worksheet enables you to determine which pages within your site are causing the most server errors. Use this information to correct or delete those pages and improve site usability.
This worksheet enables you to determine which user and visitor requests generated the most error messages. Use this information to determine what types of errors occurred.
This worksheet enables you to determine which pages within your site cause the client machine to end a session. Use this information to create content on these pages that may be of more interest to site users and visitors.
This worksheet enables you to determine which pages in your site automatically redirect the most users and visitors to other areas within your site. Use this information to determine if the code responsible for redirection is sending people to the correct area within the site.
This worksheet enables you to determine which page categories (which are defined by your System Administrator or IT department) within your site generate the most status messages of a certain type (for example, "200: Successful" messages). Use this information to determine what pages within your category structure generate the most error status messages.
This worksheet enables you to determine the page types within your site that generate the most status messages of a certain type (for example, "200: Successful" messages). Page types are defined by your System Administrator or IT department. Use this information to determine what page types generate the most error status messages.
This worksheet enables you to determine which page categories within your site generate the most status messages. Page categories are defined by your System Administrator or IT department. If page categories have not been defined, Oracle9iAS Clickstream Intelligence creates categories by parsing the directory structure of your site. Use this information to determine the amount of status messages generated by different categories.
This worksheet enables you to determine which page types within your site generate the most status messages. Page types are defined by your System Administrator or IT department. Use this information to determine amount of status messages generated by different page types.
Use this workbook to gather demographic information about site users. A user is defined as a person who has provided personal information to a Web site or has created an identity on the site.
The following worksheets are available:
This worksheet enables you to determine identified users who visit your site most often. Use this information to determine whether or not your site has a loyal user base.
This worksheet enables you to view the age ranges of registered users who visit your site. This report will return demographic data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to target the type of audience that visits your site. You can also use this demographic information to make assumptions about the purchasing power of the types of the age groups who access your site.
This worksheet enables you to determine the location of the registered users who visit your site. This report will return demographic data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine where your site is the most popular.
This worksheet enables you to determine which companies the registered users who visit your site work for. This report will return company data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to explore possible relationships/synergies or competitive situations.
This worksheet enables you to determine the types of companies the registered users who visit your site work for. This report will return company data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine what types of companies your traffic is coming from.
This worksheet enables you to determine the location of the registered users who visited your site during this period. This report will return location data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine in which countries your site is the most popular.
This worksheet enables you to determine the gender of the registered users who visited your site. This report will return gender data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine if one gender visits your site more frequently than another gender does.
This worksheet enables you to determine which users of your site come from specific industries. This report will return industry data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine the types of industries your site attracts.
This worksheet enables you to determine the types of jobs the registered users who visit your site have. This report will return employment data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine what types of people visit your site (managers, clerks, technicians, and so on).
This worksheet enables you to determine whether the majority of the registered users who visit your site are married or not. This report will return relationship data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine if the content you provide is in step with the marital status of people visiting your site.
This worksheet enables you to determine the world location (For example, Europe, Oceania, North America, and so forth) of the registered users who visited your site during this period. This report will return location data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine in which part of the world your site is the most popular.
This worksheet enables you to determine who visited your site according to when they created a login account. This information is derived from the clickstream log file or from data loaded by your system administrator. Use this information to look for relationships or patterns related to registration dates and behavior.
This worksheet enables you to determine the location of the registered users who visited your site. This report will return location data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine in which part of the country your site is most popular.
This worksheet enables you to determine the various types of subscription levels held by your members and how frequently members with certain subscription levels visit your site. This report will return subscription data only if the registered user has supplied this information, and the information has been loaded into the Clickstream database by the System Administrator. Use this information to determine site usage by your premium registered users.
This worksheet enables you to determine how many visits to your site resulted in sessions consisting of multiple page requests. Oracle9iAS Clickstream Intelligence categorizes visits in one page increments and then determines how many visits fell into that range. A single user can have multiple visits. Visits with 25 or more page requests are not differentiated. A visit with 26 page requests is considered the same as a visit with 226 page requests. Use this information to determine the stickiness level of your site.
This worksheet enables you to determine the length of user sessions. Oracle9iAS Clickstream Intelligence categorizes sessions in one minute increments. Use this information to determine the amount of time spent per visit to your site. Long site visits may indicate a high level of user interest in your site.
This worksheet enables you to track the activities of a specific site user. All known data about the user is shown in this report. Use this information to gain insight into the use of your site by an individual.
Use this workbook to gather information about the data stored in the Connecting Machine dimension of the database and how it relates to other dimensions. These reports are very powerful. They enable you to sift through the stored Web log data at a very fine level of granularity.
The following worksheets are available:
This worksheet initially displays the intersection of data from two dimension levels - the Connecting Machine dimension and the User dimension. This worksheet enables you to analyze relationships and interactions between the data in all hierarchies of two dimensions, and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
This worksheet initially displays data at the Client Host level of the Client Host dimension as it relates to the Age Group level of the User dimension. As you drill into either of the dimensions you will see how the data contained in one dimension affects the data in the other dimension. Use this information to determine patterns that are not covered in other pre-formatted reports
This worksheet initially displays data at the Client Host level of the Client Host dimension as it relates to the Gender level of the User dimension. As you drill into either of the dimensions you will see how the data contained in one dimension affects the data in the other dimension. Use this information to determine patterns that are not covered in other pre-formatted reports.
This worksheet initially displays data at the Client Host level of the Client Host dimension as it relates to the Marital Status attribute contained in the User level of the User dimension. As you drill into either of the dimensions you will see how the data contained in one dimension affects the data in the other dimension. Use this information to determine patterns that are not covered in other pre-formatted reports.
This worksheet initially displays data at the Client Host level of the Client Host dimension as it relates to the Subscription Level attribute contained in the User level of the User dimension. As you drill into either of the dimensions you will see how the data contained in one dimension affects the data in the other dimension. Use this information to determine patterns that are not covered in other pre-formatted reports.
Use this workbook to see reports that combine user information in the database with page information.
The following worksheets are available:
This worksheet displays all Web log data in the session fact table that is related to both the User and Page dimensions. This worksheet enables you to analyze relationships and interactions between the data in all hierarchies of two dimensions, and may form the basis of further data analyses when combined with other Clickstream Analytics reports.
This worksheet initially displays data at the Age Group level of the User dimension as it relates to the Page Category level of the Page dimension. As you drill into either of the dimensions you will see how the data contained in one dimension affects the data in the other dimension. Use this information to determine patterns that are not covered in other pre-formatted reports.
This worksheet initially displays data at the Gender level of the User dimension as it relates to the Page Category level of the Page dimension. As you drill into either of the dimensions you will see how the data contained in one dimension affects the data in the other dimension. Use this information to determine patterns that are not covered in other pre-formatted reports.
This worksheet initially displays the data contained in the Marital Status attribute (which resides in the User level of the User dimension) as it relates to the Page Category level of the Page dimension. As you drill into either of the dimensions you will see how the data contained in one dimension affects the data in the other dimension. Use this information to determine patterns that are not covered in other pre-formatted reports.
This worksheet initially displays the data contained in the Subscription Level attribute (which resides in the User level of the User dimension) as it relates to the Page Category level of the Page dimension. As you drill into either of the dimensions you will see how the data contained in one dimension affects the data in the other dimension. Use this information to determine patterns that are not covered in other pre-formatted reports.
Use this workbook to see information relating to the people that have not logged in to your site. Identified visitors is defined as people who have not registered with the site but who are tracked via cookie or query string data. Unidentified visitors are defined as people who have not registered with the site, and have not been tracked using query string or cookie data.
The following worksheets are available:
This worksheet provides a full count of all the visits to your site and enables you to determine which people visited your site most often. Use this information to determine which visitors access your site most frequently.
This worksheet enables you to determine which identified visitors accessed your site most often. Use this information to determine who visits your site most frequently.
This worksheet enables you to determine which unidentified visitors accessed your site most often during this period. Use this information to determine how many visitors to your site wish to remain completely anonymous.
This worksheet enables you to determine which type of visitor accessed your site most frequently. Use this information to determine who visited your site more often: unidentified visitors or identified visitors.
This worksheet enables you to determine if there is a trend to which type of visitor accessed your site most frequently. Use this information to determine if the level of visits by either unidentified visitors or identified visitors increased or decreased.
This worksheet enables you to determine how many visits to your site resulted in sessions consisting of multiple page requests. Oracle9iAS Clickstream Intelligence categorizes visits in one page increments and then determines how many visits fell into that range. A single visitor can have multiple visits. Visits with 25 or more page requests are not differentiated. A visit with 26 page requests is considered the same as a visit with 226 page requests. Use this information to determine the stickiness level of your site.
This worksheet enables you to determine the length of visitor sessions. Oracle9iAS Clickstream Intelligence categorizes sessions in one minute increments. Use this information to determine the amount of time spent per visit to your site. Long site visits may indicate a high level of user interest in your site.
This worksheet enables you to track the activities of a specific site visitor. All known data about the visitor is shown in this report. Use this information to gain insight into the use of your site by an individual.
|
 Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|
