Home
%3CLINGO-SUB%20id%3D%22lingo-sub-571512%22%20slang%3D%22en-US%22%3EThoughts%20on%20Web%20Analytics%20in%20SharePoint%202010%20-%20Part%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571512%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Nov%2015%2C%202012%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EWeb%20Analytics%20data%20collection%20is%20actually%20driven%20by%20the%20Usage%20and%20Health%20service%2C%20and%20then%20it%20mines%20the%20data%20to%20help%20administrators%20improve%20their%20Sites%20and%20Search.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ETo%20collect%20data%20the%20Usage%20and%20Health%20Service%2C%20aggregates%20the%20info%20thru%20Usage%20definitions%20which%20you%20can%20see%26nbsp%3B%20in%20Central%20Admin.%3C%2FP%3E%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3ESandboxed%20Requests%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EContent%20Import%20Usage%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EWorkFlow%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EClickthrough%20usage%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EContent%20Export%20Usage%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EPage%20Requests%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EFeature%20Use%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESearch%20Query%20Usage%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESite%20Inventory%20Usage%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESandboxed%20Requests%20Monitored%20Data%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ETimer%20Jobs%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ERating%20Usage%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20Using%20the%20Web%20Analytics%20Service%20these%20results%20are%20aggregated%20into%20reports%20at%20these%20levels%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3EWeb%20Application%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESite%20Collection%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESite%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESearch%20Service%20Application%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20By%20Default%20we%20have%20the%20following%20reports%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3ETraffic%20Reports%20-%20How%20many%20hits%20a%20page%20got%2C%20How%20the%20user%20got%20there%2C%20and%20What%20browser%20they%20used%20to%20get%20there.%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESearch%20Reports%20-%20What%20was%20searched%20for%2C%20top%20clicks%2C%20failed%20queries%2C%20etc%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EInventory%20Reports%20-%20What%20space%20is%20being%20used%20by%20who%2C%20How%20many%20sites%20you%20have%2C%20What%20languages%20those%20sites%20use%2C%20etc%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20You%20can%20manipulate%20the%20Usage%20Definitions%20using%20the%20PowerShell%20commands%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EGet-SPUsageDefinition%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ESet-SPUsageDefinition%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20Thoughts%20and%20Suggestions%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EYou%20can%20set%20the%20retention%20rate%20for%20each%20Usage%20Definition%2C%20I%20would%20recommend%20you%20leave%20it%20at%2014%20days.%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EThere%20is%20no%20way%20to%20log%20extra%20data%20for%20Web%20Analytics%20out%20of%20the%20box%2C%20but%20you%20could%20create%20a%20custom%20usage%20receiver%20by%20following%20this%20blog%20%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Ftejasr%2Farchive%2F2010%2F12%2F26%2Fcustomizing-web-analytics-in-sharepoint.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fb%2Ftejasr%2Farchive%2F2010%2F12%2F26%2Fcustomizing-web-analytics-in-sharepoint.aspx%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EIf%20you%E2%80%99re%20interested%20in%20monitoring%20server%20performance%20we%20may%20want%20to%20look%20at%20this%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fspeschka%2Farchive%2F2009%2F10%2F27%2Fadding-throttling-counters-in-sharepoint-2010.aspx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fspeschka%2Farchive%2F2009%2F10%2F27%2Fadding-throttling-counters-in-sharepoint-2010.aspx%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EAs%20well%20you%20can%20create%20your%20own%20reports%20by%20using%20SharePoint%20SQL%20Reporting%20Services%20against%20the%20Logging%20database%2C%20or%203%20%3CSUP%3E%20rd%20%3C%2FSUP%3E%20party%20tools%20that%20mine%20the%20data%20for%20you.%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20Articles%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ECapacity%20requirements%20for%20the%20Web%20Analytics%20Shared%20Service%20in%20SharePoint%20Server%202010%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fgg440601.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fgg440601.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EReporting%20and%20usage%20analysis%20overview%20(SharePoint%20Server%202010)%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fgg266383.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fgg266383.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EWeb%20Analytics%20in%20SharePoint%202010%3A%20Insights%20into%20Reports%20and%20Metrics%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Fecm%2Farchive%2F2010%2F05%2F03%2Fweb-analytics-in-sharepoint-2010-insights-into-reports-and-metrics.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fb%2Fecm%2Farchive%2F2010%2F05%2F03%2Fweb-analytics-in-sharepoint-2010-insights-into-reports-and-metrics.aspx%20%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-571512%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Nov%2015%2C%202012%20Web%20Analytics%20data%20collection%20is%20actually%20driven%20by%20the%20Usage%20and%20Health%20service%2C%20and%20then%20it%20mines%20the%20data%20to%20help%20administrators%20improve%20their%20Sites%20and%20Search.%3C%2FLINGO-TEASER%3E
First published on TECHNET on Nov 15, 2012

Web Analytics data collection is actually driven by the Usage and Health service, and then it mines the data to help administrators improve their Sites and Search.


To collect data the Usage and Health Service, aggregates the info thru Usage definitions which you can see  in Central Admin.



  1. Sandboxed Requests

  2. Content Import Usage

  3. WorkFlow

  4. Clickthrough usage

  5. Content Export Usage

  6. Page Requests

  7. Feature Use

  8. Search Query Usage

  9. Site Inventory Usage

  10. Sandboxed Requests Monitored Data

  11. Timer Jobs

  12. Rating Usage


Using the Web Analytics Service these results are aggregated into reports at these levels



  1. Web Application

  2. Site Collection

  3. Site

  4. Search Service Application


By Default we have the following reports



  1. Traffic Reports - How many hits a page got, How the user got there, and What browser they used to get there.

  2. Search Reports - What was searched for, top clicks, failed queries, etc

  3. Inventory Reports - What space is being used by who, How many sites you have, What languages those sites use, etc


You can manipulate the Usage Definitions using the PowerShell commands


Get-SPUsageDefinition


Set-SPUsageDefinition


Thoughts and Suggestions



  • You can set the retention rate for each Usage Definition, I would recommend you leave it at 14 days.





  • As well you can create your own reports by using SharePoint SQL Reporting Services against the Logging database, or 3 rd party tools that mine the data for you.


Articles


Capacity requirements for the Web Analytics Shared Service in SharePoint Server 2010


http://technet.microsoft.com/en-us/library/gg440601.aspx


Reporting and usage analysis overview (SharePoint Server 2010)


http://technet.microsoft.com/en-us/library/gg266383.aspx


Web Analytics in SharePoint 2010: Insights into Reports and Metrics


http://blogs.msdn.com/b/ecm/archive/2010/05/03/web-analytics-in-sharepoint-2010-insights-into-r...