How can I make a combined site usage analytics report from all SharePoint Online sites in my tenant?

Question

Hi everyone,

I need to analyze user activity across the entirety of SharePoint Online Intranet for my organization (Communication sites). The metrics I need are most visited pages, most read news, popular activity times, and popular search terms. The first three I can get from Site Usage Analytics, and the search terms are available on Microsoft Search in the site settings. But here comes the problem: every site has its own statistics, but I need a report across the entire network of sites (the right term here is Site Collection, I believe).

I have read that Hub Sites are able to combine reports into a unified one, but we have multiple Hubs and no main Hub. The landing page is not a Hub Site.

How do I go about creating a combined report?

I am a beginner in PowerShell, but I have researched some ideas for a script that would access hidden lists with those metrics and combine them. I still cannot find the names of the hidden lists where those are stored, however. Simple cmdlets don't seem to have such report functionality, either. I would be happy to hear some scripting ideas.

Another direction I am thinking of is writing a script that downloads all the reports from different sites and hubs and creates a combined report in Excel. Is this possible? I can immediately imagine some issues, like all the Home pages of different sites having the same name and therefore delivering wrong statistics.

I have also found some people referencing Microsoft Graph API, but it is still unknown to me.

Any ideas on what I can do? Maybe the solution is incredibly easy and I just don't see it? I appreciate your replies!

Answer 1

Hi @Kislitsa, Tatiana

You can get Microsoft 365 Reports in the admin center - SharePoint activity to analyze user activity. The Reports dashboard shows you the activity overview across various products in your organization. It enables you to drill in to get more granular insight about the activities specific to each product. Check out the activity reports in the Microsoft 365 admin center.

Here is the activity reports available in the admin center

Available activity reports

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.