MOSS Usage Reports explained

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 (which may also be called a Hit in underlying code) 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.

Hidden green text shows SharePoint object model classes, report definition language files and stored procedures that implement the reports.

  • ·Classes are defined in the namespace Microsoft.SharePoint.Portal.Analytics.UI.
  • ·RDLC files are defined in Program Files\Microsoft Office Servers\12.0\Bin\Analytics.
  • ·Stored procedures are defined in the SSP database.

All of the logic for computing the report data is in the stored procedures.  The class just executes the stored proc against the rdl file to render results onto the report page.

Site/collection usage summary

Site: SpUsageWeb.aspx / Site Collection: SpUsageSite.aspx

Site collection summary

Class: SiteSummaryReportControl

RDL: Summary.rdlc

SProc: proc_ANL_SiteSummary

Requests count a single page, not all individual items.

Table

  • Metric : Description of measurement for this site/collection
  • Value: Value of measurement

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)

Class: SiteTopPagesReportControl

RDL: SitePages.rdlc

SProc: proc_ANL_SiteTopPages

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)

Class: SiteTopUsersByHitsReportControl

RDL: Users.rdlc

SProc: proc_ANL_SiteTopUsersByHits

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)

Class: SiteTopReferrersByHitsReportControl

RDL: ReferrersPie.rdlc

SProc: proc_ANL_SiteTopReferrersByHits

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.

Top destination sites (past 30 days)

(Named Top destination pages on site collection report; this is correct)

Class: SiteTopPageClickthroughsByHitsReportControl

RDL: ClickthroughsPie.rdlc

SProc: proc_ANL_SiteTopClickthroughPagesByHits

Pie Chart

  • URL: site that a user navigated to from the current site/collection.
  • Slice-value (integer): the total number of times this URL was a destination page over the past 30 days.

Requests per day (past 30 days)

Class: SiteHitsByDayReportControl

RDL: HitsByDay.rdlc

SProc: proc_ANL_SiteHitsByDay

Requests count a single page, not all individual items.

Bar Chart

  • Date: Day of month
  • Y-axis (integer): Total number of requests per day from all users to this site/collection over the past 30 days.

Top referring hosts (past 30 days)

Class: SiteDnsTopReferrersByHitsReportControl

RDL: ReferrersPie.rdlc

SProc: proc_ANL_SiteDNSTopReferrersByHits

Pie Chart

  • URL: site hosting pages that 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 host over the past 30 days.

 

Top Queries Over Previous 30 Days

Class: TopQueriesForSummaryReportControl

RDL: QueriesTop.rdlc

SProc: proc_MSS_QLog_TopQueries

(Site Collection report only)

Table

  • Query: keyword(s) entered into search box on this site collection by any user to initiate search query.
  • Scope: search scope selected for query
  • Occurrences (integer): number of times this specific keyword or keyword phrase was entered by any user over the past 30 days.

Search Results Top Destination Pages

Class: TopDestinationsForSummaryReportControl

RDL: ResultsTopDestinations.rdlc

SProc: proc_MSS_QLog_TopDestinations

(Site Collection report only)

Only destination pages browsed by clicking a search result (click-through)

Table

  • Page URL: page that any user browsed to by clicking a search result link.
  • Clicks (integer): number of times this page was browsed to by clicking a search result link over the past 30 days.

Site/collection requests

Site: SpUsageWebTopPages.aspx / Site Collection: SpUsageSiteTopPages.aspx

Requests per day (past 30 days)

Class: SiteHitsByDayReportControl

RDL: HitsByDay.rdlc

SProc: proc_ANL_SiteHitsByDay

Requests count a single page, not all individual items.

Bar Chart

  • Date: Day of month
  • Y-axis (integer): Total number of requests per day from all users to this site/collection over the past 30 days.

Average requests per day by month

Class: SiteHistoricalHitsByMonthReportControl

RDL: HitsByMonth.rdlc

SProc: proc_ANL_SiteHistoricalHitsByDay

Requests count a single page, not all individual items.

Bar Chart

  • Date: Month of year
  • Y-axis (integer): Average number of requests per day (averaged per month) from all users to this site/collection over the past 5 months.

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

(Named Top requests on site collection report)

Class: SiteAllPagesReportControl

RDL: SitePages.rdlc

SProc: proc_ANL_SiteAllPages

“Request” counts as a single request for a page, not including additional requests for items on the page.

Table

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

Site collection users

Site: SpUsageWebUsers.aspx / Site Collection: SpUsageSiteUsers.aspx

Unique users (past 30 days)

Class: SiteUniqueUsersByDayReportControl

RDL: UniqueUsersByDay.rdlc

SProc: proc_ANL_SiteUniqueUsersByDay

Bar Chart

  • Date: Day of month
  • Value (integer): total number of users accessing this site/collection over the past 30 days, not including repeat visits from the same user.

Average unique users per day by month

Class: SiteHistoricalUniqueUsersByMonthReportControl

RDL: UniqueUsersByMonth.rdlc

SProc: proc_ANL_SiteHistoricalUniqueUsersByDay

Bar Chart

  • Date: Month of year
  • Value (integer): Average number of users accessing this site/collection (averaged per month) over the past 5 months, not including repeat visits from the same user.

User activity (past 30 days)

Class: SiteUsersByHitsReportControl

RDL: Users.rdlc

SProc: proc_ANL_SiteUsersByHits

Table

  • User: ID of user accessing this site/collection.
  • Value (decimal): average = total number of times the user accessed this site/collection over the past 30 days, divided by 30 to give daily average.

Site/collection referrers

SpUsageSiteReferrers.aspx

Top referring hosts (past 30 days)

Class: SiteDnsTopReferrersByHitsReportControl

RDL: ReferrersPie.rdlc

SProc: proc_ANL_SiteDnsTopReferrersByHits

This computes the same data as the table report beneath it, except it only looks at the top 5 referrer URLs, and it displays its values as integers instead of decimals.

Pie Chart

  • URL: site hosting pages 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): average = total number of times the URL was a referring host over the past 30 days, divided by 30 to give daily average.

Top referring hosts (past 30 days)

Class: SiteDnsReferrersByHitsReportControl

RDL: ReferrersHost.rdlc

SProc: proc_ANL_SiteDnsReferrersByHits

Table

  • Referring host: URL of site hosting pages that any user visited just prior to browsing to a page in the current site collection.  The top 300 URLs are examined.
  • Value (decimal): average = total number of times the URL was a referring host over the past 30 days, divided by 30 to give daily average.

Top referring pages (past 30 days)

Class: SiteTopReferrersByHitsReportControl

RDL: ReferrersPie.rdlc

SProc: proc_ANL_SiteTopReferrersByHits

This computes the same data as the table report beneath it, except it only looks at the top 5 referrer URLs, and it displays its values as integers instead of decimals.

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): average = total number of times the URL was a referring page over the past 30 days, divided by 30 to give daily average.

Top referring pages (past 30 days)

Class: SiteReferrersByHitsReportControl

RDL: Referrers.rdlc

SProc: proc_ANL_SiteReferrersByHits

Table

  • Referring page: URL of page that any user visited just prior to browsing to a page in the current site collection.  The top 300 URLs are examined.
  • Value (decimal): average = total number of times the URL was a referring page over the past 30 days, divided by 30 to give daily average.

Site/collection destination pages

Site: SpUsageSiteClickthroughs.aspx / Site Collection: SpUsageSiteClickthroughs.aspx

Top destination sites (past 30 days)

Class: SiteTopWebClickthroughsByHitsReportControl

RDL: ClickthroughsPie.rdlc

SProc: proc_ANL_SiteTopClickthroughWebsByHits

Pie Chart

  • URL: site that a user navigated to from the current site/collection.
  • Slice-value (integer): total number of times this URL was a destination site over the past 30 days.

Top destination sites (average requests per day over past 30 days)

Class: SiteWebClickthroughsByHitsReportControl

RDL: Clickthroughs.rdlc

SProc: proc_ANL_SiteClickthroughWebsByHits

Table

  • Destination: URL of the site that a user navigated to from the current site/collection.
  • Requests (integer): total number of times this URL was a destination site over the past 30 days.

Top destination sites (past 30 days)

Class: SiteTopPageClickthroughsByHitsReportControl

RDL: ClickthroughsPie.rdlc

SProc: proc_ANL_SiteTopClickthroughPagesByHits

(Named Top destination pages on site collection report; this is correct)

Pie Chart

  • URL: page that a user navigated to from the current site/collection.
  • Slice-value (integer): total number of times this URL was a destination page over the past 30 days.

Top destination pages (average requests per day over past 30 days)

Class: SitePageClickthroughsByHitsReportControl

RDL: Clickthroughs.rdlc

SProc: proc_ANL_SiteClickthroughPagesByHits

Table

  • Destination: URL of the page that a user navigated to from the current site/collection.
  • Requests (integer): total number of times this URL was a destination page over the past 30 days.

Site/collection home page

Site: SpUsageWebHomePage.aspx / Site Collection: SpUsageSiteHomePage.aspx

Site home page requests per day (past 30 days)

Class: SiteHomePageHitsByDayReportControl

RDL: HitsByDay.rdlc

SProc: proc_ANL_WebHomePageHitsByDay

(Named Home page requests on site collection report)

Bar Chart

  • Date: Day of month
  • Y-axis (integer): total number of times the home page of this site/collection was requested by any user over the past 30 days.

Site home page unique users (past 30 days)

(Named Home page unique users on site collection report)

Class: SiteHomePageUniqueUsersByDayReportControl

RDL: UniqueUsersByDay.rdlc

SProc: proc_ANL_ WebHomePageUniqueUsersByDay

Bar Chart

  • Date: Day of month
  • Y-axis (integer): total number of users accessing the home page of this site/collection over the past 30 days, not including repeat visits from the same user.

Top referring pages to home page (average requests per day over past 30 days)

Class: SiteHomePageReferringPagesReportControl

RDL: Referrers.rdlc

SProc: proc_ANL_ WebHomePageReferringPages

Table

  • Referring page: URL of page that any user visited just prior to browsing to a page in the current site collection.
  • Value (decimal): average = total number of times the URL was a referring page over the past 30 days, divided by 30 to give daily average.

Average daily home page requests (past 365 days)

Class: SiteHomePageHistoricalHitsByMonthReportControl

RDL: HitsByMonth.rdlc

SProc: proc_ANL_ WebHomePageHistoricalHitsByDay

(Named Average home page requests per day by month on site collection report)

Bar Chart

  • Date: Month of year
  • Y-axis (integer): Average number of requests per day (averaged per month) from all users to the home page of this site/collection over the past 5 months.

Average daily unique users on home page (past 365 days)

(Named Average home page unique users per day by month on site collection report)

Class: SiteHomePageHistoricalUniqueUsersByMonthReportControl

RDL: UniqueUsersByMonth.rdlc

SProc: proc_ANL_ WebHomePageHistoricalUniqueUsersByDay

Bar Chart

  • Date: Month of year
  • Y-axis (integer): Average number of users accessing the home page of this site/collection (averaged per month) over the past 5 months, not including repeat visits from the same user.

Top destination pages from home page (average requests per day over past 30 days)

Class: SiteHomePageClickthroughPagesReportControl

RDL: Clickthroughs.rdlc

SProc: proc_ANL_ WebHomePageClickthroughPages

Table

  • Destination: URL of the next page that any user opened after accessing the home page of this site/collection in any single browser session.
  • Requests (integer): total number of times this URL was a destination page over the past 30 days.

Search Queries Report

Site: (not available at this level) / Site Collection: SpUsageSiteSearchQueries.aspx

Queries Over Previous 30 days

Class: QueriesByDayReportControl

RDL: QueriesByDay.rdlc

SProc: proc_MSS_QLog_QueriesByDay

Bar Chart

  • Date: numerical day of current month; may show days from previous month towards left of axis.
  • Queries (integer): total number of search queries, per day, initiated from this site collection by any user over the past 30 days.

Top Queries Over Previous 30 Days

Class: TopQueriesReportControl

RDL: QueriesTop.rdlc

SProc: proc_MSS_QLog_TopQueries

Table

  • Query: keyword(s) entered into search box to initiate search query
  • Scope: search scope selected for query
  • Occurrences (integer): number of times this specific keyword or keyword phrase was entered by any user over the past 30 days.

Queries Over Previous 12 Months

Class: QueriesByMonthReportControl

RDL: QueriesByMonth.rdlc

SProc: proc_MSS_QLog_QueriesByMonth

Bar Chart

  • Month: Month name
  • Queries (integer): total number of search queries, per month, initiated from this site collection by any user over the past 12 months.

Queries Per Scope Over Previous 30 Days

Class: QueriesByScopeReportControl

RDL: QueriesByScope.rdlc

SProc: proc_MSS_QLog_QueriesByScope

Pie Chart

  • Scope: search scope selected for query
  • Slice-value (percentage): the relative frequency of when the scope was selected over the past 30 days.

Search Results Report

Site: (not available at this level) / Site Collection: SpUsageSiteSearchResults.aspx

Search Results Top Destination Page

Class: TopDestinationsReportControl

RDL: ResultsTopDestinations.rdlc

SProc: proc_MSS_ QLog_TopDestinations

This report lists pages that users browsed to after viewing search results.

Only destination pages browsed by clicking a search result (click-through)

Table

  • Page URL: page that any user browsed to by clicking a search result link.
  • Clicks (integer): number of times this page was browsed to by clicking a search result link over the past 30 days.

Most Clicked Best Bets

Class: TopBestBetsReportControl

RDL: ResultsTopBestBets.rdlc

SProc: proc_MSS_ QLog_TopBestBets

This report lists “best bet” search results that were clicked most by users.

Table

  • Best Bet: name of best bet that was clicked
  • Clicks (integer): number of clicks on the best bet from all users over the past 30 days.

Queries with Low Clickthrough

Class: LowClickthroughReportControl

RDL: .rdlc

SProc: proc_MSS_

This report lists search queries that were executed and produced results, but for which the user did not click any of the search results.

Table

  • Query: keyword(s) entered into search box to initiate search query, for queries having low click-through.
  • Scope: search scope selected for query
  • Occurrences (integer): number of times this specific keyword or keyword phrase was entered by any user over the past 30 days.
  • Click-Through (percentage): the frequency with which users clicked a search result.

Queries With Zero Results

Class: ZeroResultsReportControl

RDL: ResultsZero.rdlc

SProc: proc_MSS_ QLog_ZeroResults

This report lists search queries that did not produce any normal search results.

Table

  • Query: keyword(s) entered into search box on this site collection by any user to initiate search query, for queries having no results.
  • Scope: search scope selected for query
  • Occurrences (integer): number of times this specific keyword or keyword phrase was entered by any user over the past 30 days.

Queries With Zero Best Bets

Class: ZeroBestBetsReportControl

RDL: ResultsZeroBestBets.rdlc

SProc: proc_MSS_ QLog_ZeroBestBets

This report lists search queries that did not produce any “best bet” results.

Table

  • Query: keyword(s) entered into search box on this site collection by any user to initiate search query, where that search query did not have a best bet defined for it.
  • Occurrences (integer): number of times this specific keyword or keyword phrase was entered by any user over the past 30 days.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s