Moss Site usages report

Moss Site usages report explained

This paper gives detailed descriptions of parameters displayed in MOSS 2007’s usage reports.
Since very similar reports exist at both the Site and Site Collection level, descriptions will be combined when applicable.  The phrase “site/collection” will be used to indicate either site or site collection, depending on which level the report was requested at.
Performance tip: the default page for usage reporting demands the most of SQL Server because it has the most reporting parts; each part executes at least one stored procedure to retrieve its data.  Each part is also found on other reporting pages.  It may be desirable to bookmark specific pages for detailed reports, it the summary report is not desired.  This will prevent the intensive processing required to summarize all reports if all that is wanted are details.
Note, when a description says “over the past 30 days” or “divided by 30” the underlying calculations always account for the possibility that usage reporting may have been turned on less than 30 days ago, and fewer than 30 days worth of records exist.  In these cases, the appropriate number less than 30 is used.
In all calculations, “Requests” means a request for a single page, and does not include any of the items that appear on the page that may require additional HTTP requests to the server.  In other words, a Request is equivalent to what is commonly called a Page View.  Statistics for intra-page requests such as graphics, scripts and style sheets are not collected for SharePoint usage reporting.
“Distinct” users are the same as “Unique” users.  Each is computed via the SQL operator DISTINCT when selecting over all users.
Show hidden text for underlying technical specifications.

Average requests per day over past 30 days: average = total number of requests over past 30 days, divided by 30 to give daily average.

Distinct users over past 30 days: total number of users accessing this site/collection over the past 30 days, not including repeat visits from the same user.

Distinct users yesterday: total number of users accessing this site/collection on yesterday’s date, not including repeat visits from the same user.

Requests yesterday: total number of requests to this site/collection on yesterday’s date.

Queries Yesterday: total number of search queries submitted by all users from this site/collection on yesterday’s date.

Queries Over Past 30 Days: total number of search queries submitted by all users from this site/collection over the past 30 days.

Top Pages (Average requests per day over past 30 days)

Table

• Page: URL of requested page

• Value (decimal): average = total number of requests for this page over the past 30 days, divided by 30 to give daily average.

Top Users (Average requests per day over past 30 days)

Table

• User: ID of user accessing this site/collection.

• Value (integer): average = total number of requests from the user to this site/collection over the past 30 days, divided by 30 to give daily average.

Top referring pages (past 30 days)

Pie Chart

• URL: page that any user visited just prior to browsing to a page in the current site collection.  The top 5 URLs are shown.

• Slice-value (integer): total number of times this URL was a referring page over the past 30 days.

Twitter Delicious Digg Facebook Stumbleupon RSS