Forum Discussion

SPONoob's avatar
SPONoob
Copper Contributor
Sep 30, 2021

SharePoint get all Site Views (not only Top 10 by standard Site-Analytics)

Hey everyone,

 

I want to get all the SharePoint Intranet statistics that are possible.

Unfortunately the "standard" Site-Analystics doesn't help, because they only list the top 10 elements (e.g. Top 10 Sites, Top 10 Site Pages, Top 10 Document)

Is there a way to get ALL view numbers of ALL Elements? 
In the specific case I want to see the less seen Sites and the less seen Documents (so my colleques can improve these sites/ documents to get more views and relevance in the intranet)

Thank you very much in advance 😉 

P.S: The audit log reports (in the SPO Site Settings) doesn't work anymore... So there must be a way in the compliance center or via PowerShell...

power bi
sharepoint

3 Replies

  • christinepayton's avatar
    christinepayton
    Iron Contributor
    Sep 27, 2023
    I just posted this, which is relevant - it'll get you global site views at the least. I think you can probably also get item views with a similar technique but the limiter there will probably be the size of your environment (it uses the OData feeds and pulling activity data for all items in all sites would be a bit massive). https://techcommunity.microsoft.com/t5/sharepoint-bi/tutorial-tenant-level-usage-metrics-site-subsite-list-library/td-p/3939590
  • christinepayton's avatar
    christinepayton
    Iron Contributor
    Aug 22, 2023

    You can get viewer activity in the compliance center audit logs (https://compliance.microsoft.com/auditlogsearch?viewid=Async%20Search). The selector in there will let you choose the things you want to pull activity info for - things like "accessed file", "viewed page" etc. The issue with the audit log is that it doesn't go back very far in history, so if you want to do reporting over time you have to export it on a periodic basis. BUT you could export those to CSV each month, and use the "SharePoint folder" connector in Power BI to combine them all and make some charts out of it.

     

     


    If you are in a large organization, the number of records is going to be unwieldy for this connector; in that case you might be better off doing something custom with the REST API.

Resources