How to Create a Combined SharePoint Site Usage Report
Question details
The user needs to generate a combined usage report covering pages, news, activity times, and search terms across multiple SharePoint hub sites.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Tracking combined analytics and search metrics across multiple SharePoint hub sites within an organization.
- Observed behavior
- Built-in SharePoint analytics only provide usage information for individual sites, lacking a unified organizational report containing all requested page-level and search metrics.
Ensure you have global administrator or SharePoint administrator privileges in the Microsoft 365 admin center before attempting to access usage reports or run administrative scripts.
Create Custom Combined Reports Using PowerShell or Microsoft Graph
Since SharePoint does not offer a built-in combined report for pages, news, and search terms across multiple hubs, you must use development tools to aggregate this data.
A custom solution requires extracting analytics data from individual sites and combining it programmatically. You can use Microsoft Graph APIs or PowerShell scripts to pull the required metrics.
Determine exactly which APIs or PowerShell cmdlets are needed to extract page views, activity times, and search queries for each site.
Use PowerShell (e.g., PnP PowerShell) or Microsoft Graph API to iterate through your organization's hub sites and systematically collect the analytical data.
Format the extracted analytical data into a single combined CSV file, or export it directly into Power BI to create a unified organizational dashboard.
View General SharePoint Usage Data via Microsoft 365 Admin Center
While it doesn't combine all page-level metrics natively, the admin center provides overarching usage data across your SharePoint sites.
Looking for a Lightweight and Affordable Office Suite? Try WPS Office
Managing extensive Microsoft 365 environments can be complex. If you are looking for a reliable, free, and highly compatible alternative for everyday document creation, spreadsheet management, and presentations, WPS Office is an excellent choice for individuals and teams.
Frequently Asked Questions
Can I combine SharePoint analytics natively without coding?
No, Microsoft 365 does not currently offer a built-in feature to generate a single combined report covering detailed page-level metrics, news, and search terms across multiple hub sites.
Where can I find individual SharePoint site usage reports?
You can find individual site usage by navigating to the specific SharePoint site, clicking the Settings gear icon in the top right, and selecting 'Site usage'. This displays metrics exclusively for that specific site.
How can I visualize the custom data I collect using PowerShell?
Once you export the analytics data using PowerShell or Microsoft Graph into a CSV or database format, you can connect that data source to Microsoft Power BI to design and share interactive, combined organizational dashboards.
Are there third-party tools available for combined SharePoint reporting?
Yes, several third-party applications and services specialize in deep SharePoint analytics and governance, offering the combined organizational reporting and dashboarding that native Microsoft admin tools currently lack.
