This post is a contribution from Jaishree Thiyagarajan, an engineer with the SharePoint Developer Support team.
To use WebAnalytics API, first we need to add reference to Microsoft.Office.Server.WebAnalytics.dll and Microsoft.Office.Server.WebAnalytics.UI.dll. These DLLs can be located in GAC (C:\Windows\Assembly\GAC_MSIL\).
The WebAnalytics DB (Report DB) has many Table-Valued-functions, which we can leverage programmatically through FrontEndDataRetriever.QueryData .
Check out the example given below. I’ve used “fn_WA_GetNumberOfClickthroughs”, this function will retrieve the number of hits per URL.