Microsoft 365 Reports in the admin center - SharePoint activity

As an Microsoft 365 admin, 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.

For example, you can understand the activity of every user licensed to use SharePoint by looking at their interaction with files. It also helps you to understand the level of collaboration going on by looking at the number of files shared.

How do I get to the to the SharePoint activity report?

  1. In the admin center, go to the Reports > Usage page.
  2. From the dashboard homepage, click on the View more button on the SharePoint card.

Interpret the SharePoint activity report

You can view the activities in the SharePoint report by choosing the Activity tab.
Microsoft 365 reports - Microsoft SharePoint activity report.

Select Choose columns to add or remove columns from the report.
SharePoint activity report - choose columns.

You can also export the report data into an Excel .csv file by selecting the Export link. This exports data of all users and enables you to do simple sorting and filtering for further analysis. If you have less than 2000 users, you can sort and filter within the table in the report itself. If you have more than 2000 users, in order to filter and sort, you will need to export the data.

The SharePoint activity report can be viewed for trends over the last 7 days, 30 days, 90 days, or 180 days. However, if you select a particular day in the report, the table will show data for up to 28 days from the current date (not the date the report was generated).

Item Description
Metric Definition
Username
The email address of the user who performed the activity on the SharePoint Site.
Last activity date (UTC)
The latest date a file activity was performed or a page was visited for the selected date range. To see activity that occurred on a specific date, select the date directly in the chart.
Files viewed or edited
The number of files that the user uploaded, downloaded, modified, or viewed.
Files synced
The number of files that have been synced from a user's local device to the SharePoint site.
Files shared internally
The count of files that have been shared with users within the organization, or with users within groups (that might include external users).
Files shared externally
The number of files that have been shared with users outside of the organization.
Pages visited
The visits to unique pages by the user.
Deleted
This indicates that the user's license was removed.
NOTE: Activity for a deleted user will still display in the report as long as he or she was licensed at some time during the selected time period. The Deleted column helps you to note that the user may no longer be active, but contributed to the data in the report.
Deleted date
The date on which the user's license was removed.
Product assigned
The Microsoft 365 products that are licensed to the user.