Condividi tramite


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.

 

clip_image002

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

 

clip_image004

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

check

check[4]

check[6]

Number of Unique Visitors

check[9]

check[11]

check[13]

 

Number of Referrers

check[15]

check[17]

check[19]

 

Top Pages

check[21]

check[23]

check[25]

 

Top Visitors

check[27]

check[29]

check[31]

 

Top Referrers

check[33]

check[35]

check[37]

 

Top Destinations

check[39]

check[41]

check[43]

 

Top Browsers

check[45]

check[47]

check[49]

 

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

 

check[51]

check[53]

check[55]

Top Queries

 

check[59]

 

check[57]

Failed Queries

 

check[61]

   

No Result Queries

     

check[63]

Best Bet Usage

 

check[65]

   

Best Bet Suggestions

 

check[67]

   

Best Bet Suggestion Action History

 

check[69]

   

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

   

check[71]

Storage Usage

 

check[73]

   

Number of Sites

check[85]

check[75]

   

Top Site Production Versions

check[83]

check[77]

   

Top Site Languages

check[81]

check[79]

   

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