Web Analytics in SharePoint 2010: Insights into Reports and Metrics

As part of SharePoint 2010, we have created a set of features to help you collect, report, and analyze the usage and effectiveness of your SharePoint 2010 deployment.  These features are a part of the Web Analytics capabilities of SharePoint 2010. The overview of the Web Analytics features in SharePoint 2010 was presented in this blog post.

This blog post delves deeper into the various metrics available to analyze the site usage data. There are three categories of the SharePoint Web Analytics reports: Traffic, Search, and Inventory. The reports are aggregated for various SharePoint entities like Site, Site Collection, and Web Application for each farm. Further, reports are also aggregated per search service application. By default, the reports show the data for a period of 30 days but you can change the time period to view data for up to 25 months by going to ‘Analyze’ tab in the Ribbon UI.

Visually we show the metrics in one of the two ways: trend reports and rank reports. A trend report shows how a particular metric is doing over a period of time. While a rank report, shows the top 2000 results for a particular metric. Figures 1 and 2 show examples of a trend and rank report respectively. That’s not all; you can further analyze the reports by applying filters like string match in the URL, user name, queries, browser and others.

 

Figure 1:  Example of a Trend Report showing Number of Page Views for each day for a default period of 30 days.

 

Figure 2:  Example of a Rank Report showing the Top Pages sorted on the Number of Page Views for a default period of 30 days.

 

What follows is an overview of each type of the report and the associated metrics. Also, summarized are the kind of reports available for each level of aggregation i.e. Site, Site Collection and Web Application and Search Service Application.

 

Traffic Reports

The traffic reports capture the user behavior information related to total clicks, frequent users, popular pages, and information about navigation to and from the current SharePoint component.

Trend Reports

1. Number of Page Views: Total number of page views each day.
2. Number of Daily Unique Visitors: Total number of unique visitors each day. SharePoint authenticated users and anonymous users (using IP address) are counted as visitors.
3. Number of Referrers: Total number of unique URL’s external to the current entity (parent entity is treated as external as well), from where the users navigated to the current entity.

Rank Reports

1. Top Pages: Most viewed pages in the current entity.
2. Top Visitors: Most frequent visitors of the current entity.
3. Top Referrers: Top URL’s external to the current entity from where users navigated to the current entity.
4. Top Destinations: Similar to Referrers, these are the top external URL’s that the user visited from the current entity.
5. Top Browsers: Top browsers being used to visit the current entity.

Report Scope	Site	Site Collection	Web Application	Search Service Application
Number of Page Views
Number of Unique Visitors
Number of Referrers
Top Pages
Top Visitors
Top Referrers
Top Destinations
Top Browsers

Table 1:  Summary of the traffic reports availability at different SharePoint hierarchy levels

 

Search Reports

The search reports capture the user behavior information related to the queries on the site.

Trend Reports

1. Number of Queries: Total number of queries each day.

Rank Reports

1. Top Queries: Most issued queries per day.
2. Failed Queries: Most issued queries for which either there were no results or the user did not click on any results.
3. No Result Queries: Most issued queries for which no results were returned.

Other Reports

1. Best Bet Suggestion Report: Recommends URLs as most likely results for particular search queries based on analysis of usage patterns. The site administrators can accept or reject these suggestions. If they accept, the corresponding query-URL pair is added to the search keywords list.
2. Best Bet Usage: Shows how Best Bet suggestions are doing over time. For every Best Bet query issued, the report shows the percentage of clicks on the Best Bet URL compared to other URLs.
3. Best Bet Action History Report: Tracks the actions performed by the site administrator on the ‘Best Bet Suggestion’ Report.

Report Scope	Site	Site Collection	Web Application	Search Service Application
Number of Queries
Top Queries
Failed Queries
No Result Queries
Best Bet Usage
Best Bet Suggestions
Best Bet Suggestion Action History

Table 2:  Summary of the search reports availability at different SharePoint component hierarchy levels

 

Inventory Reports

The inventory reports are targeted to help the site administrators in managing the site by keeping track of the site structure and storage and version issues.

Trend Reports

1. Number of Site Collections: Total number of site collections for each Web Service Application for each day.
2. Storage Usage: Total storage used in Megabyte (MB) for a site collection and the ‘Maximum Storage Allowed’ in MB for each day.
3. Number of Sites: Total number of sites within each Site Collection for each day.

Rank Reports

1. Top Site Product Versions: The ‘Site Product Version’ sorted in the order of ‘Number of Sites’ or ‘Percentage of Overall’ sites using the corresponding version for this site collection.
2. Top Site Languages: The ‘Site Product Language’ sorted in the order of ‘Number of Sites’ or ‘Percentage of Overall’ sites using that language for this site collection.

Report Scope	Site	Site Collection	Web Application	Search Service Application
Number of Site Collections
Storage Usage
Number of Sites
Top Site Production Versions
Top Site Languages

Table 3:  Summary of Inventory Reports availability at different SharePoint component hierarchy levels

 

Look out for more to come

Keep an eye out for more blogs on customizing the reports using Excel, using workflow feature to scheduled reports and alerts and adding the ‘What’s Popular’ Web Part to your pages.

Comments

• Anonymous
  May 04, 2010
  hi sounds very promising !! Please let me know if this works with the Foundation version as well.

• Anonymous
  June 06, 2010
  Is there really a 25-month historical limit to how far back these reports can reach? Post above states:  "By default, the reports show the data for a period of 30 days but you can change the time period to view data for up to 25 months by going to ‘Analyze’ tab in the Ribbon UI." I looked at the beta Hyper-V image, and it looks like you can specify date ranges to run the reports much farther back than 25 months (for example, I looked at page views from 1970 - 2010 - and although there was no data outside of 2010 that displayed in report results - the report ran). - tx

• Anonymous
  February 26, 2012
  Hi All, we offer on-premise web-analytics and audit software product for SharePoint 2010 and 2007, HarePoint Analytics for SharePoint: www.harepoint.com/.../Default.aspx

• 70+ reports on users behaviour, document and list item usage, performance

• Integrations without scripts or any other content modification

• No limits on the data storage Free trial download. WBR, Alexander