Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The SharePoint site usage report provides a high-level view of the value you get from SharePoint. The report includes details about the total number of files that users store in SharePoint sites, how many files are actively used, and the storage consumed across all these sites. You can drill into the SharePoint site usage report to understand the trends and per-site level details for all sites.
For general information about Microsoft 365 Usage reports and to see a list of all available reports, see Microsoft 365 admin center usage reports overview.
View the SharePoint site usage report
For information about the roles needed to view usage reports, see Microsoft 365 admin center usage reports overview.
- Go to the Microsoft 365 admin center.
- In the navigation menu, select Reports. If you don't see Reports, select Show all, and then select Reports.
- Select Usage.
- On the Usage page, under Reports, select SharePoint.
- On the report page, select the Site usage tab.
Interpret the SharePoint site usage report
To add or remove columns from the report, select Choose columns.
To export the report data into an Excel .csv file, select the Export link. This action exports data for all users and lets you do simple sorting and filtering for further analysis.
The SharePoint site usage report displays trends over the last 7, 30, 90, or 180 days. However, if you select a particular day in the report, the table shows data for up to 28 days from the current date (not the date the report was generated).
| Metric | Description |
|---|---|
| Site URL | The full URL of the site. |
| Deleted | The deletion status of the site. The site is marked as deleted after at least 7 days. |
| Site owner | The username of the primary owner of the site. |
| Site owner principal name | The email address of the owner of the site. |
| Last activity date (UTC) | The date of the last time file activity was detected or a page was viewed on the site. |
| Site sensitivity label ID | The sensitivity label on the site. |
| External sharing | The value of the external sharing setting for the site. This value doesn't reflect changes to the effective setting made by site sensitivity labels. If you use sensitivity labels, use the data access governance reports to get the correct values. |
| Unmanaged device policy | The site access policy for unmanaged devices. |
| Geo location | The Geo location of the site. |
| Files | The number of files on the site. |
| Active files | The number of active files on the site. A file is active if it's saved, synced, modified, or shared within the specified time period. NOTE: If files were removed during the specified time period for the report, the number of active files shown in the report might be larger than the current number of files on the site. |
| Storage used (MB) | The amount of storage currently used on the site. |
| Storage allocated (MB) | The maximum amount of storage allocated for the site. |
| Page views | The number of times pages were viewed on the site. |
| Pages visited | The number of unique pages that were visited on the site. |
| Anonymous link count | The number of times documents or folders are shared using "Anyone with the link" on the site. |
| Company link count | The number of times documents or folders are shared using "People in org with the link" on the site. |
| Secure link for guest count | The number of times documents or folders are shared using "specific people" on the site. |
| Secure link for member count | The number of times documents or folders are shared using "specific people" on the site. |
| Root Web Template | The template used for creating the site. NOTE: To filter the data by different site types, export the data and use the Root Web Template column. |
| Site ID | The site ID of the site. |
By default, user-specific information like usernames, display names, groups, and sites is hidden in usage reports. To learn how to display this information in usage reports, see Show user, group, or site details in usage reports.
Note
The SharePoint site URL doesn't display if BYOK or Customer Lockbox is enabled. If you meet the requirement, submit a request via ODSP Site URLs Displaying Request. The site URL is visible within one week. If the requirement isn't met, you can use PowerShell. To follow the steps, see Use PowerShell to resolve site URLs.
You might see differences between the sites listed in the Site udage report and those listed on the Sites > Active sites page in the SharePoint admin center because certain site templates and URLs aren't included as Active sites. For more information, see Manage sites in the SharePoint admin center.