Microsoft Teams user activity report

The Teams user activity report gives you insight into the types of activities that users in your organization perform in Teams. For example, you can see how many users communicate through 1:1 calls, how many users communicate through channel messages, and how many users engage in private chat messages.

Screen shot of the Teams user activity report

View the report

  1. Go to the Microsoft Teams admin center, in the left navigation, click Analytics & reports, and then under Report, select Teams user activity.
  2. Under Date range, select a range, and then click Run report.

Interpret the report

Screenshot of the Teams user activity report with numbered callouts

Callout Description
1 The Teams user activity report can be viewed for trends over the last 7 days or 28 days.
2 Each report has a date for when this report was generated. The reports usually reflect a 24 to 48 hour latency from time of activity.
3
  • The X axis on the charts is the selected date range for the specific report.
  • The Y axis is the number of users participating in the activity.
Hover over the dot representing an activity on a given date to see the number of instances of that activity on that given date.
4 You can filter what you see on the chart by clicking an item in the legend. For example, click 1:1 calls, Channel messages, or Chat messages to see only the info related to each one. Changing the selection doesn’t change the information in the table.
5 The table gives you a breakdown of usage by user.
  • Display name is the display name of the user. You can click the display name to go to the user's setting page in the Microsoft Teams admin center.
  • 1:1 calls is the number of 1:1 calls that the user participated in during the specified time period.
  • Channel messages is the number of unique messages that the user posted in a team chat during the specified time period.
  • Chat messages is the number of unique messages that the user posted in a private chat during the specified time period.
  • Last activity is the last date (UTC) that the user participated in a Teams activity.
Note that if a user account no longer exists in Azure AD, the user name is displayed as "--" in the table.

To see the information that you want in the table, make sure to add the columns to the table.
6 Select Edit columns to add or remove columns in the table.
7 You can export the report to a CSV file for offline analysis. Click Export to Excel, and then on the Downloads tab, click Download to download the report when it's ready.
Screen shot of the Downloads tab showing exported reports to download
When you view the report in Excel, you'll also see an Id column, which represents the team ID. A team ID is typically an alphanumeric string. If the Id column shows as \n, this means that a user requested their information to be deleted.