URLs Summary Table


The information from the URLs Table is summarized to allow a variety of statistical reports to be generated.



Columns
uniqueSummaryID
frequency
startTimestamp
cardinality
webServerID
URLID
URLExtension
URLBytes
newUniqueDomainNames
rptUniqueDomainNames
uniqueDomainNames
hitsFromExtRefs
hitsFromIntRefs
hitsFromNoRefs
hits
bytesSent
transferTime
percentHits
percentBytesSent
percentTransferTime
averageHits
averageBytesSent
averageTransferTime





Indices

Unique
  1. uniqueSummaryID


Non-Unique
  1. frequency, startTimestamp
  2. webUserID


Column Definitions

uniqueSummaryID

Each summary row has its own unique ID, which distinguishes it from other rows.

Description of rows entered for each summary frequency.

Hourly: Unique ID assigned to this summary row
Daily: Unique ID assigned to this summary row
Weekly: Unique ID assigned to this summary row
Monthly: Unique ID assigned to this summary row




frequency

This column indicates the frequency of the summary row--hourly (H), daily (D), weekly (W) or monthly (M).

Description of rows entered for each summary frequency.

Hourly: H
Daily: D
Weekly: W
Monthly: M




startTimestamp

The start date and time of a summary.

Description of rows entered for each summary frequency.

Hourly: The date and the hour of the day (eg. 02/22/1996 14:00:00)
Daily: The date and the midnight hour (eg. 02/22/1996 00:00:00)
Weekly: The date of first day of the week and the midnight hour (eg. 02/18/1996 00:00:00)
Monthly: The date of the first day of the month and the midnight hour (eg. 02/01/1996 00:00:00)




cardinality

Depending on the frequency (hourly, daily, weekly or monthly), the number displayed indicates the exact hour, day, week or month at the time of the summary.

Description of rows entered for each summary frequency.

Hourly: Hour of the day (0-23)
Daily: Day of the week (1-7, 1=Sunday)
Weekly: Week of the year (1-52, or 53)
Monthly: Month of the year (1-12)




webServerID

The unique ID of Web server that sent the log entry. The corresponding Web Server can be found in the WebServers table. This information is not affected by the summary frequency.


URLID

The unique ID of the URL affected. This information is not affected by the summary frequency.


URLExtension

The extension tag provided after a URL (eg: *.html, *.gif). This information is not affected by the summary frequency.


URLBytes

The number of bytes contained in a URL.

Description of rows entered for each summary frequency.

Hourly: Total URL bytes per hour
Daily: Total URL bytes per day
Weekly: Total URL bytes per week
Monthly: Total URL bytes per month




newUniqueDomainNames

This column indicates the number of new visitors to the Web site by hour, day, week and month.

Description of rows entered for each summary frequency.

Hourly: The count of new visitors who arrived during this hour
Daily: The count of new visitors who arrived during this day
Weekly: The count of new visitors who arrived during this week
Monthly: The count of new visitors who arrived during this month




rptUniqueDomainNames

This column indicates the number of repeat visitors to the Web site by hour, day, week and month.

Description of rows entered for each summary frequency.

Hourly: The count of repeat visitors arriving during this hour
Daily: The count of repeat visitors arriving during this day
Weekly: The count of repeat visitors arriving during this week
Monthly: The count of repeat visitors arriving during this month




uniqueDomainNames

This column indicates the number of unique visitors to the Web site by hour, day, week and month.

Description of rows entered for each summary frequency.

Hourly: The count of unique visitors arriving during this hour
Daily: The count of unique visitors arriving during this day
Weekly: The count of unique visitors arriving during this week
Monthly: The count of unique visitors arriving during this month




hitsFromExtRefs

This means 'hits from external referers', and indicates the number of hits from external referers to the Web site by hour, day, week or month.

Description of rows entered for each summary frequency.

Hourly: Total hits generated as a result of external referrals for this hour
Daily: Total hits generated as a result of external referrals for this day
Weekly: Total hits generated as a result of external referrals for this week
Monthly: Total hits generated as a result of external referrals for this month




hitsFromIntRefs

This means 'hits from internal referers', and indicates the number of hits from internal referers to the Web site by hour, day, week or month.

Description of rows entered for each summary frequency.

Hourly: Total hits generated as a result of internal referrals (URL to URL) for this hour
Daily: Total hits generated as a result of internal referrals (URL to URL) for this day
Weekly: Total hits generated as a result of internal referrals (URL to URL) for this week
Monthly: Total hits generated as a result of internal referrals (URL to URL) for this month




hitsFromNoRefs

This means 'hits from no referers', and indicates the number of hits without referers (users who typed in the URL directly) by hour, day, week or month.

Description of rows entered for each summary frequency.

Hourly: Total hits generated as a result of a URL being typed-in directly for this hour
Daily: Total hits generated as a result of a URL being typed-in directly for this day
Weekly: Total hits generated as a result of a URL being typed-in directly for this week
Monthly: Total hits generated as a result of a URL being typed-in directly for this month




hits

Hits indicates how many times a certain Web page is accessed every hour, day, week or month.

Description of rows entered for each summary frequency.

Hourly: Total hits received for this hour
Daily: Total hits received for this day
Weekly: Total hits received for this week
Monthly: Total hits received for this month




bytesSent

Bytes sent indicates the number of bytes transmitted every hour, day, week or month.

Description of rows entered for each summary frequency.

Hourly: Total bytes transmitted for this hour
Daily: Total bytes transmitted for this day
Weekly: Total bytes transmitted for this week
Monthly: Total bytes transmitted for this month




transferTime

The number of seconds (with decimal precision) it takes to complete a transmission.

Description of rows entered for each summary frequency.

Hourly: Total time spent transmitting data for this hour
Daily: Total time spent transmitting data for this day
Weekly: Total time spent transmitting data for this week
Monthly: Total time spent transmitting data for this month




percentHits

The percentage of hits per hour, day, week or month is indicated in this column.

Description of rows entered for each summary frequency.

Hourly: Percent of total hits per hour
Daily: Percent of total hits per day
Weekly: Percent of total hits per week
Monthly: Percent of total hits per month




percentBytesSent

The percentage of bytes sent per hour, day, week or month is indicated in this column.

Description of rows entered for each summary frequency.

Hourly: Percent of total bytes sent per hour
Daily: Percent of total bytes sent per day
Weekly: Percent of total bytes sent per week
Monthly: Percent of total bytes sent per month




percentTransferTime

The percentage of time sent transferring per hour, day, week or month is indicated in this column.

Description of rows entered for each summary frequency.

Hourly: Percent of total transfer time per hour
Daily: Percent of total transfer time per day
Weekly: Percent of total transfer time per week
Monthly: Percent of total transfer time per month




averageHits

The total number of hits is averaged out for each day, week or month.

Description of rows entered for each summary frequency.

Hourly: N/A
Daily: Average hits received per hour for this day
Weekly: Average hits received per day for this week
Monthly: Average hits received per day for this month




averageBytesSent

The total number of bytes sent is averaged out for each day, week or month.

Description of rows entered for each summary frequency.

Hourly: N/A
Daily: Average bytes transmitted per hour for this day
Weekly: Average bytes transmitted per day for this week
Monthly: Average bytes transmitted per day for this month




averageTransferTime

The total amount of time spent transferring data is averaged out for each day, week and month.

Description of rows entered for each summary frequency.

Hourly: N/A
Daily: Average time spent transmitting data per hour for this day
Weekly: Average time spent transmitting data per day for this week
Monthly: Average time spent transmitting data per day for this month


Home Page - Reports