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.

View the report

  1. In the left navigation of the Microsoft Teams admin center, click Analytics & reports > Usage reports. On the View reports tab, under Report, select Teams user activity.

  2. Under Date range, select a range, and then click Run report.

    Screenshot of the Teams user activity report in the Teams admin center with callouts

Interpret the report

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.

Screenshot 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.

Definitions

The Teams reports show data for active users and active channels. For example, if a user in your organization isn't active in Teams during the date range that you specified for a report, data for that user isn't included in that report.

Item Definition
Active user Measures the number of unique users who perform an action in Teams during the specified date range.
Active channel Measures the number of channels of a team in which users perform an action during the specified date range.